#1  
Old 30th May 2007, 21:41
sefokuma sefokuma is offline
Junior Member
 
Join Date: May 2007
Posts: 6
Thanks: 2
Thanked 0 Times in 0 Posts
Default ispconfig and mysql

Hi, i´ve a ispconfig server running ok but i want use other sever for mysql server. When i try change the config (db_host) from localhost to new_mysql_server I recive an error and cant login, in the new server i have the same database copied and runs with the same permissions.

I have could see that when i try restart ispconfig service this launch the next error, but the system starts.

error:

Code:
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!
I have only edit the file /home/admispconfig/ispconfig/lib/config.inc.php, switching in the line 87 localhost to new_mysql_server.

Thx, bye.
Reply With Quote
Sponsored Links
  #2  
Old 31st May 2007, 09:10
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,046
Thanks: 826
Thanked 5,389 Times in 4,234 Posts
Default

are you able to login in the ISPConfig interface?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
sefokuma (31st May 2007)
  #3  
Old 31st May 2007, 10:18
sefokuma sefokuma is offline
Junior Member
 
Join Date: May 2007
Posts: 6
Thanks: 2
Thanked 0 Times in 0 Posts
Default

Yes i have running ispconfig on port 81 with https ok, and load login.php but when i try to login with the user and password corrects i recive ERROR 101.

Some idea?
Reply With Quote
  #4  
Old 31st May 2007, 10:25
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,046
Thanks: 826
Thanked 5,389 Times in 4,234 Posts
Default

Ok, in this case the login data to the mysql database is not correct or the database is empty or ISPConfig has no permissions to read the data.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
sefokuma (31st May 2007)
  #5  
Old 31st May 2007, 11:19
sefokuma sefokuma is offline
Junior Member
 
Join Date: May 2007
Posts: 6
Thanks: 2
Thanked 0 Times in 0 Posts
 
Default

OMG, mate i forgot a simple GRANT ALL. Sorry but this noob post lol.

Thx
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
ISPconfig after installation cannot reach www.xyz.de:81 Figth4Linux Installation/Configuration 23 6th March 2008 22:38
ISPConfig server also a MySQL replication slave jamesh Installation/Configuration 1 2nd August 2006 09:59
SP-Server Setup - Ubuntu 5.10 "Breezy Badger" - Page 6 (changes) LuisC-SM HOWTO-Related Questions 0 21st April 2006 15:16
Problem installing ISPConfig, then with MySQL... ctroyp Installation/Configuration 7 26th September 2005 16:37
MySQL issue during install of ISPConfig ricbax Installation/Configuration 4 16th September 2005 09:41


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


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