ISPConfig 3 system installation script

[Mark_NL]

Since I'm deploying ISPConfig 3 installations on new servers on a frequent base, I got tired of installing the same system software over and over and doing the same settings over and over.

Then dclardy came with a install script. With no disrespect towards him i recreated an improved version from scratch.

The script uses whiptail and is almost unattended, the only thing you need to do is give some default required values, choose 'no' at dbconfig-common db configuration for phpmyadmin, and enter the common name when creating a ssl certificate for pure-ftpd (which i want to automate with a template in a future version). The "No" question is because of a bug in dbconfig-common. The bug prevents you to set the "No" option via debconf. The rest (up to installing ISPConfig 3 itself is completely unattended)

The script currently supports Debian only. (If someone can convert it to a different distribution for me, I'll be glad to merge it into the existing script)

I've tested this on a clean installation of Debian Squeeze 32bits.

Please test this script and give feedback in this thread.

The script can be downloaded here: http://www.e-rave.nl/dump/ispc3sysinstall.sh

maybe add it to ISPConfig3 tarball when it's tested well enough?

[dclardy]

It would be nice to work together on something like this instead of attempting to bash another person just trying to help.

[Mark_NL]

I'm not bashing you, as i quote myself from my previous post:

Then dclardy came with a install script. With no disrespect towards him i recreated an improved version from scratch

Something like this was already on my to-do list for some time.

So again, this wasn't to bash you, i just wanted to make one myself and this is the end result, thought i'd share it with the rest.

[digitalage]

Originally Posted by Mark_NL

The script can be downloaded here: http://www.e-rave.nl/dump/ispc3sysinstall.sh

Not there anymore. Anyone having it? Please...

[Mark_NL]

Hi!

Sorry about that, I relocated my site to a new VPS, i forgot one setting which prevented graabing those files, this should be fixed now. Let me know it you still can't get it and i'll send you a copy.

Regards,
Mark

[digitalage]

It works now, thank you!

[digitalage]

Excelent work!
I got some errors, 'though! (I followed Courier path)

Oct 6 02:37:08 ns1 mysqld_safe[3514]: ERROR: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1
Oct 6 02:37:08 ns1 mysqld_safe[3514]: 121006 2:37:08 [ERROR] Aborting
Oct 6 02:37:19 ns1 mysqld_safe[3556]: ERROR: 1050 Table 'plugin' already exists
Oct 6 02:37:19 ns1 mysqld_safe[3556]: 121006 2:37:19 [ERROR] Aborting
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: Error : You can't use locks with log tables.
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: Error : You can't use locks with log tables.
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 1053 (08S01) at line 433: Server shutdown in progress
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 435: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 436: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 441: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 442: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 443: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 448: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 454: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 455: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 457: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 458: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 459: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 467: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 471: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 475: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 479: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 483: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 491: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 538: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 540: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 547: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 550: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 553: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 559: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 562: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 565: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 568: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 574: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 577: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 580: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 583: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 589: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 595: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 597: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 603: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 604: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 606: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 607: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 609: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 611: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 612: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 617: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 618: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 620: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 622: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 656: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 658: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 659: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 661: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 663: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 666: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 669: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 672: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 675: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 678: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 681: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 684: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 686: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 693: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 694: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 696: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 697: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 699: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 700: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 702: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 703: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 705: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: ERROR 2006 (HY000) at line 711: MySQL server has gone away
Oct 6 02:37:26 ns1 /etc/mysql/debian-start[3772]: FATAL ERROR: Upgrade failed
Oct 6 02:37:32 ns1 /etc/mysql/debian-start[4006]: Error : You can't use locks with log tables.
Oct 6 02:37:32 ns1 /etc/mysql/debian-start[4006]: Error : You can't use locks with log tables.

However, the control panel is opening, the email is opening (round-cube). I didn't setup further.

Any idea what's happening?

[digitalage]

And a quick (dumb) question. I notices a few time is generating a certificate (3 x times if I recall correctly). Is it possible to ask all those questions only once and then the automatic script to fill everything in?

[webguyz]

The installation script works well with Debian Squeeze 64 bit.

This is setup for a single user system, thinking that with a little tweaking it could be truned into a multiuser installation tool where you had the option to specify what apps you wanted to install based on the type of server it was that you were installing.(Web, Mail, etc)

Thanks for the hard work!

[Mark_NL]

@webguyz: You're welcome! Feel free to edit the installation script and post the results here to share it with everyone

@digitalage: That looks like a debian mysql installation error, not related to the script itself. What the script does is try to automate the most of the stuff for you, the certificated can be generated from a template file, so what you're asking IS possible, but i was just to damn lazy at the time to make something like that. ;-)

Greetings,
Mark