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

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 17th October 2007, 20:56
h00s h00s is offline
Junior Member
 
Join Date: Jun 2007
Location: Croatia
Posts: 7
Thanks: 2
Thanked 0 Times in 0 Posts
Default Problem upgrading 2.2.17 -> 2.2.18, database empty

(Argh, i'm sorry i missed the forum, please move it to proper forum,
sorry again)


Problem is, after upgrade I can't login to ispconfig and ispconfig database is empty (0 tables).

I have no special characters in mysql password and upgrade worked always fine till now.

I'm using Ubuntu 6.06.1 and it was mysql update before updating ISPConfig to 2.2.18, I don't know if that mysql update could be the problem.

This is output of install:
Code:
Connected successfully to db ispconfig

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /root/install_ispconfig/install.php on line 692

(same errors on lines 717, 807, 812, 822, 839, 1145)

Restarting some services...
./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

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /root/ispconfig/scripts/lib/config.inc.php on line 47
No results found!ISPConfig system is now up and running!
Congratulations! Your ISPConfig system is now installed. If you had to install quota, please take the steps described in the installation manual. Otherwise your system is now available without reboot.
Can it be fixed?
(I moved existing_db*.sql, home_admispconfig*.tar.gz, root_ispconfig*.tar.gz from /tmp to safe location)
Reply With Quote
Sponsored Links
  #2  
Old 17th October 2007, 21:30
Ben Ben is offline
Moderator
 
Join Date: Jul 2006
Posts: 1,029
Thanks: 7
Thanked 62 Times in 56 Posts
Default

Hmmm normally this only happens, if an error occurs during installation, in this case I would the userdata for mysql is wrong, cause there is no valid ressource for a connection.... but i thought this would be fetched?

Anyway you can rebuild you ispconfig database with your backup. Then I would just try to reupdate 2.2.18. but to avoid running in the same error, I would check if the root password defined for this is correct.
Reply With Quote
  #3  
Old 18th October 2007, 09:33
h00s h00s is offline
Junior Member
 
Join Date: Jun 2007
Location: Croatia
Posts: 7
Thanks: 2
Thanked 0 Times in 0 Posts
Default

I checked root password and it's ok. I restored from backup, run install again and I get same errors

I think this problems/errors has something with recent Ubuntu mysql update..
Reply With Quote
  #4  
Old 18th October 2007, 12:25
chuckl chuckl is offline
Senior Member
 
Join Date: May 2007
Location: Uxbridge, Middlesex, UK
Posts: 166
Thanks: 1
Thanked 20 Times in 20 Posts
Default

I upgraded 2 Ubuntu 6.06 systems with MySQL 5.0.22 installed, no problems at all.
Apt-get update and upgrade done immediately before the ISPConfig upgrade, so it is the current Ubuntu repo versions.
Check the connection to MySQL with mysqld perhaps? Maybe the database itself is having a bad hair day, or has a probelm in the ispconfig database.
Reply With Quote
  #5  
Old 18th October 2007, 19:13
Ben Ben is offline
Moderator
 
Join Date: Jul 2006
Posts: 1,029
Thanks: 7
Thanked 62 Times in 56 Posts
Default

So you checked, that the mysql-data in /home/admispconfig/ispconfig/lib/config.inc.php is correct?
e.g. try with mysql -u xxxxx -p

but on the other hand, if the script can not connect, it should die with an error and so not continue and it should be logged in /var/log/ispconfig_install.log.

So I'd suggest either the db, the php tries to select does not exist, or the table "isp_isp_web" does not exist in the database.
Reply With Quote
  #6  
Old 19th October 2007, 10:13
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,405
Thanks: 834
Thanked 5,496 Times in 4,326 Posts
Default

The database format has not been changed from 2.2.17 to 2.2.18, so you can try to restore just the database and the new ISPConfig version should work with it. I know that thsi is not a solution for future updates on your system
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #7  
Old 23rd October 2007, 12:53
h00s h00s is offline
Junior Member
 
Join Date: Jun 2007
Location: Croatia
Posts: 7
Thanks: 2
Thanked 0 Times in 0 Posts
 
Thumbs up

Hi! I solved the problem. The problem was in my mysql configuration . Database worked but not mysql cmd utility which is crucial for ISPConfig install/upgrade.
Here's how I fix it (after I fixed mysql):

1. Installed 2.2.17 ver.
2. Edited ISPConfig database and deleted all the data from tables (but leaving the tables)
3. Restored database from database backup ISPConfig setup left in /tmp
4. Restored /root/ispconfig and /home/admispconfig
5. Installed/upgraded to 2.2.18

And, it worked
Thank you all for help
Reply With Quote
Reply

Bookmarks

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
sending e-mail using mail() function linuxuser1 HOWTO-Related Questions 38 21st April 2009 12:20
network_setup problem after upgrade 2.2.3 -> 2.2.14 rhl2000 General 6 17th February 2008 22:28
Mail System doesnt work! crichton Installation/Configuration 3 17th September 2007 23:49
mysql clustering problem : cannot create table in database prince.fer Server Operation 2 16th April 2007 17:03
ISPConfig-2.2.2 installation problem (empty mysql db after installation) sfrank Installation/Configuration 4 25th May 2006 14:56


All times are GMT +2. The time now is 03:04.


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