I'm just installing the new ISPConfig release to upgrade from ISPConfig 2.2.14 to 2.2.15. During the installation I've been asked"Give a name for the database". There's allready a database, why I have to give a new name? I'm confused. What should I do not to lose the old database? I would like to keep it [EDIT] SAFE your time and read the summarize in the third post on side two!
You must stop the installation process. ISPConfig does not ask for a new database name during update. If you where asked for a database name, then the installer does not run in update mode. Did you start the instller more then once without creating the directory /root/ispconfig again.
If the folders /root/ispconfig and /home/admispconfig are there, the installer definately does not run in install mode.
I don't know why but /root/ispconfig was'nt there. I could copy it back from a backup. Now the most thinks went ok but I got this errors: Code: Connected successfully to db isp_db mysqldump: Couldn't execute 'show fields from `del_status`': Got error 28 from storage engine (1030) Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /root/install_ispconfig/install.php on line 799 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /root/install_ispconfig/install.php on line 807 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /root/install_ispconfig/install.php on line 812 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /root/install_ispconfig/install.php on line 822 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /root/install_ispconfig/install.php on line 839 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /root/install_ispconfig/install.php on line 1145 What does it mean? The big problem is: I can't login anymore in ISPConfig after this upgrade. How can I login again?
I've deleted some file but during an new try I got new errors: Code: Connected successfully to db isp_db Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /root/install_ispconfig/install.php on line 692 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /root/install_ispconfig/install.php on line 717 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /root/install_ispconfig/install.php on line 767 mysqldump: Got error: 1049: Unknown database 'isp_db' when selecting the database Warning: in_array(): Wrong datatype for second argument in /root/install_ispconfig/install.php on line 800 Warning: in_array(): Wrong datatype for second argument in /root/install_ispconfig/install.php on line 800 ... Neustart einiger Dienste... ./setup2: line 1135: [: ==: unary operator expected Shutting down ISPConfig system... /root/ispconfig/httpd/bin/apachectl stop: httpd (no pid file) not running ISPConfig system stopped! Starting ISPConfig system... Syntax error on line 1072 of /root/ispconfig/httpd/conf/httpd.conf: ServerName takes one argument, The hostname of the server /root/ispconfig/httpd/bin/apachectl startssl: httpd could not be started No results found!ISPConfig system is now up and running!
Code: server:~# df -h Filesystem Size Used Avail Use% Mounted on /dev/hda3 2.5G 1.8G 519M 78% / tmpfs 76M 4.0K 76M 1% /dev/shm server01:~#
After I've made more space I got this result: Code: Alle Voraussetzungen erfuellt. Here we go... Connected successfully to db isp_db Neustart einiger Dienste... ./setup2: line 1135: [: ==: unary operator expected Shutting down ISPConfig system... /root/ispconfig/httpd/bin/apachectl stop: httpd (no pid file) not running ISPConfig system stopped! Starting ISPConfig system... Syntax error on line 1072 of /root/ispconfig/httpd/conf/httpd.conf: ServerName takes one argument, The hostname of the server /root/ispconfig/httpd/bin/apachectl startssl: httpd could not be started No results found!ISPConfig system is now up and running! on line 1072 of /root/ispconfig/httpd/conf/httpd.conf I find this(it starts with line 1078. so in line 1072 is ServerName): Code: <VirtualHost _default_:81> # General setup for the virtual host DocumentRoot "/home/admispconfig/ispconfig/web" ServerName ServerAdmin [email protected] ErrorLog /root/ispconfig/httpd/logs/error_log TransferLog /root/ispconfig/httpd/logs/access_log I've compared /root/ispconfig/httpd/conf/httpd.conf with a two day ago backup and the line 1072 ist identically. But now I'm not even able to reach the ISPConfig Server. It seems to be down.
I did a new upgrade try without the error message as I had before. But then I got new faults as the not runnig ISPConfig apache. This new upgrade try I did with Code: server01:~/install_ispconfig# df -h Filesystem Size Used Avail Use% Mounted on /dev/hda3 2.5G 1.5G 892M 62% / tmpfs 76M 4.0K 76M 1% /dev/shm but with the same resulution. How big has the patition to be for an ISPConfig upgrade that it works? The size of the partition is that smal because it is an virtual machine and I could increase but not decrease it, and it upgrades went ok at the passed time. Do you think that this probles only arise of a to smal partition? There was ho hint for that. However, how can I get the ISPConfig system running? And why before the root password are changed, it is stored in /root/ispconfig?
I will summerize what I did: 1. removed /root/ispconfig 2. installed ispconfig - aften question "give a new databse name" install process interrupted 3. copied an backup of /root/ispconfig to /root/ispconfig 4. installed ispconfig again - error message: Code: Connected successfully to db isp_db mysqldump: Couldn't execute 'show fields from `del_status`': Got error 28 from storage engine (1030) Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /root/install_ispconfig/install.php on line 799 - Login unpossible 5. new install with : Code: Filesystem Size Used Avail Use% Mounted on /dev/hda3 2.5G 1.5G 892M 62% / rsolution: Code: ./setup2: line 1135: [: ==: unary operator expected Shutting down ISPConfig system... /root/ispconfig/httpd/bin/apachectl stop: httpd (no pid file) not running ISPConfig system stopped! Starting ISPConfig system... Syntax error on line 1072 of /root/ispconfig/httpd/conf/httpd.conf: and cant reach ispconfig apache. Now. What to do? Do I need /root/ispconfig - which data are stored in there?
Yes, you need /root/ispconfig. It contains the complete ISPConfig backend. BTW, 2.5GB is still very small for a partition. I'd use at least 5GB. Do you have a backup of a working ISPConfig (maybe in the /tmp directory)? If so, restore it, make sure it's working then, and if it's working, try to upgrade again.
looks bad 8| i am no ispconfig-insider, but to me it looks like your database is corrupted. i recommend you to restore a database from your last backup, or maybe issuing as root: Code: mysqlcheck -r --auto-repair -o -A -p may help. good luck !