Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 4th November 2011, 11:00
hoenes hoenes is offline
Junior Member
 
Join Date: Nov 2011
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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 ?
Reply With Quote
Sponsored Links
  #2  
Old 4th November 2011, 11:15
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,461
Thanks: 813
Thanked 5,240 Times in 4,108 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 4th November 2011, 11:20
hoenes hoenes is offline
Junior Member
 
Join Date: Nov 2011
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The root password in mysql_clientdb.conf is correct.

I can log on mysql from console and phpmyadmin with informations from this file.
Reply With Quote
  #4  
Old 4th November 2011, 11:22
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,461
Thanks: 813
Thanked 5,240 Times in 4,108 Posts
Default

Please login with phpmyadmin as root user, go to the ispconfig db, select all tables and choose repair as action.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 4th November 2011, 11:31
hoenes hoenes is offline
Junior Member
 
Join Date: Nov 2011
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Reparing tables in ispconfig db didn't solve the problem
Reply With Quote
  #6  
Old 4th November 2011, 19:34
speedx speedx is offline
Junior Member
 
Join Date: Nov 2011
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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!
Reply With Quote
  #7  
Old 5th November 2011, 11:51
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,461
Thanks: 813
Thanked 5,240 Times in 4,108 Posts
Default

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
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #8  
Old 5th November 2011, 14:15
speedx speedx is offline
Junior Member
 
Join Date: Nov 2011
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #9  
Old 5th November 2011, 17:17
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,461
Thanks: 813
Thanked 5,240 Times in 4,108 Posts
Default

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?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #10  
Old 5th November 2011, 20:38
speedx speedx is offline
Junior Member
 
Join Date: Nov 2011
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

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?
Reply With Quote
Reply

Bookmarks

Tags
3.0.3.2, 3.0.4, updating

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ISPConfig 3.0.4 released till General 49 15th November 2011 19:53
ISPConfig 3.0.4 Beta 1 available for download till Developers' Forum 26 4th November 2011 17:47
Problem with version 3.0.3.2 chume General 2 27th January 2011 16:33
unable to login after updating to 3.0.3.2 aldo Installation/Configuration 15 17th January 2011 17:50
ISPConfig 3.0.3.2 reporting FTP server offline. CSsab Installation/Configuration 2 14th January 2011 08:15


All times are GMT +2. The time now is 01:50.


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