HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=27)
-   -   Error updating from 3.0.3.2 to 3.0.4 (http://www.howtoforge.com/forums/showthread.php?t=54769)

hoenes 4th November 2011 11:00

Error updating from 3.0.3.2 to 3.0.4
 
When updating from 3.0.3.2 to 3.0.4 i get the this error :

--------------------------------------------------------------------------------
_____ ___________ _____ __ _ ____
|_ _/ ___| ___ \ / __ \ / _(_) /__ \
| | \ `--.| |_/ / | / \/ ___ _ __ | |_ _ __ _ _/ /
| | `--. \ __/ | | / _ \| '_ \| _| |/ _` | |_ |
_| |_/\__/ / | | \__/\ (_) | | | | | | | (_| | ___\ \
\___/\____/\_| \____/\___/|_| |_|_| |_|\__, | \____/
__/ |
|___/
--------------------------------------------------------------------------------


>> Update

Operating System: Debian 6.0 (Squeeze/Sid) or compatible

This application will update ISPConfig 3 on your server.
Checking ISPConfig database .. OK
PHP Notice: Uninitialized string offset: 0 in /tmp/ispconfig3_install/install/lib/update.lib.php on line 127
PHP Fatal error: Cannot use string offset as an array in /tmp/ispconfig3_install/install/lib/update.lib.php on line 127

any ideas on how to fix this ?

till 4th November 2011 11:15

Seems as if the updater is not able to read the server config details in the mysql database. Please check if the mysql root password in /usr/local/ispconfig/server/lib/mysql_clientdb.conf is correct.

hoenes 4th November 2011 11:20

The root password in mysql_clientdb.conf is correct.

I can log on mysql from console and phpmyadmin with informations from this file.

till 4th November 2011 11:22

Please login with phpmyadmin as root user, go to the ispconfig db, select all tables and choose repair as action.

hoenes 4th November 2011 11:31

Reparing tables in ispconfig db didn't solve the problem

speedx 4th November 2011 19:34

Hello Guys!

I've got the same Problem, but i'm trying to update from 3.0.1.4. I'm not sure that it is a clever idea, if i look at the wide range of versions ^^.

If i use update.php from 3.0.4 all seems to be ok...
...the script makes a backup and than it drops my database (because of updating from a too older version)

...than the function configure_database(), i think, had a problem to create a new database und the script breaks down with the message "Unable to create database"

If i try to restart the process i become this screen:
--------------------------------------------------------------------------------
_____ ___________ _____ __ _ ____
|_ _/ ___| ___ \ / __ \ / _(_) /__ \
| | \ `--.| |_/ / | / \/ ___ _ __ | |_ _ __ _ _/ /
| | `--. \ __/ | | / _ \| '_ \| _| |/ _` | |_ |
_| |_/\__/ / | | \__/\ (_) | | | | | | | (_| | ___\ \
\___/\____/\_| \____/\___/|_| |_|_| |_|\__, | \____/
__/ |
|___/
--------------------------------------------------------------------------------


>> Update

Operating System: Debian Lenny or compatible

This application will update ISPConfig 3 on your server.
mysqldump: Got error: 1049: Unknown database 'dbispconfig' when selecting the database
Checking ISPConfig database .. mysqlcheck: Got error: 1049: Unknown database 'dbispconfig' when selecting the database
OK

Fatal error: Cannot use string offset as an array in /tmp/ispconfig3_install/install/lib/update.lib.php on line 127



The script wants starting again with making a backup, but it drops the database at the first call and skips this step not to create a new database with the function configure_database().

Any ideas?

BTW: n1ce, powerfull software!

till 5th November 2011 11:51

Hi,

your error messages are different, so its unlikely that you have the same problem. The ispconfig update never drops or creates a new database, it just drops the tables inside of the database and reloads it. So its ok that no new databse was created as the database was not dropped by ispconfig.

There are several possible reasons for your problem:

1) The database is broken, repair it with the mysql repair function.
2) The information about the database in config.inc.php file is wrong. I guess your ispconfig database has a different name then the one that is set in config.inc.php
3) The mysql root password in mysql_clientdb.conf is wrong

speedx 5th November 2011 14:15

Hello again!

Sorry, I've only read "/tmp/ispconfig3_install/install/lib/update.lib.php on line 127" so i've thought that their was a similar failure.

Thank you for helping, but its still not solved :-(
Perhaps its an Bug from my mSQL Version (5.0.51a-24+lenny5)...
Again and again, if I use ispconfig_update.sh or manualy download the tarball an execute "php -q update.php" the script backups my database (dbispconfig) and than it breaks:

--------------------------------------------------------------------------------
_____ ___________ _____ __ _ ____
|_ _/ ___| ___ \ / __ \ / _(_) /__ \
| | \ `--.| |_/ / | / \/ ___ _ __ | |_ _ __ _ _/ /
| | `--. \ __/ | | / _ \| '_ \| _| |/ _` | |_ |
_| |_/\__/ / | | \__/\ (_) | | | | | | | (_| | ___\ \
\___/\____/\_| \____/\___/|_| |_|_| |_|\__, | \____/
__/ |
|___/
--------------------------------------------------------------------------------


>> Update

Operating System: Debian Lenny or compatible

This application will update ISPConfig 3 on your server.
Checking ISPConfig database .. OK
Starting full database update.
ERROR: Unable to create MySQL database: dbispconfig.


1. I've used the repair Function at my restored dbispconfig Database - Msg= All OK.

2./3. I've used the "howto setup a perfect Debian lenny" server in the passt und have also installed deny.hosts and greylisting via apt-get and if ispconfig wants an update, i've regulary execute apt-get update and apt-get upgrade or have installed the wanted components manualy. I remember that i've got a db user called ispconfig in the past, perhaps it was on the ispconfig 2 Version. I#m not sure. However in config.inc.php and in mysql_clientdb.conf are the same db user (root) and the same password und the same standard-called database: dbispconfig.

Perhaps, can you give a little walktrough to do it by hand?

greetz
speedx

till 5th November 2011 17:17

The mysql user in the ispconfig config.inc.php file is always ispconfig, thats hardcoded in the installer, so it can never be root. If the user in your file is root, then the file must have been modified manually and this can cause updates to fail. Do you have any backups of the file with the correct login details for the user ispconfig?

speedx 5th November 2011 20:38

Sorry I forgot to say that i've hardcoded the file - When I looked into the file I saw that there was the user ispconfig, but in mysql doesn't exist a user named ispconfig. So I thought that was a failure and I coded the config. It's no problem to restore the file, but with mysql root in the file it should go or why is it a problem?

On the other side, what happend to the mysql user ispconfig? I'm very sure that i haven't delete him, but there is no user ispconfig. *Damn* there is no backup of the mysql user table...

Will it be a good start to restore the config file and create a new mysql user named ispconfig for dbispconfig database?


All times are GMT +2. The time now is 21:00.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.