"No database connection could be made" after IP-address changed

Wednesday 04 February 2004 10:41:29 am - 3 replies

3 replies

Author	Message
Marco Zinn	Wednesday 04 February 2004 11:06:12 am Hm, strange. Is your database on the same server as the webserver? If so, which got a new IP-Adress? I think, the IP-Adress of the (web)server is not stored somewhere. But of course, the webserver needs a connection to your DB server. If this is on a different server (not "localhost"), then this may cause the problem. If so, check the site.ini override files (.append) for "DatabaseSettings". Marco http://www.hyperroad-design.com
Maarten Holland	Wednesday 04 February 2004 1:19:45 pm Thank you for your reply. eZ and the database are on the same server. Databasesettings seem OK. Perhaps I need to check my db-permissions from MySQL. I've changed the rights for the relevant user from 'localhost' to 'hosts: any'. I don't think that should be a problem, but you never know. Any other suggestions are welcome.
Vidar Langseid	Wednesday 11 February 2004 2:16:11 am Since you are running the database on the same server you should have this in the correspondig site.ini (in settings/override/site.ini.append or settings/siteaccess/FOOBAR/site.ini.append) [DatabaseSettings] DatabaseImplementation=ezmysql Server=localhost Database=ezp_db User=ezp_usr Password=ezp_pas (you have to substitute ezp_db, ezp_usr and ezp_pas with your login information of course) Then grant the correct persmissions by applying this command in the mysql client: mysql> grant all privileges on ezp_db.* to ezp_usr@localhost identified by 'ezp_pas';

Author

Message

Wednesday 04 February 2004 11:06:12 am

Hm, strange.
Is your database on the same server as the webserver? If so, which got a new IP-Adress?

I think, the IP-Adress of the (web)server is not stored somewhere. But of course, the webserver needs a connection to your DB server. If this is on a different server (not "localhost"), then this may cause the problem.
If so, check the site.ini override files (.append) for "DatabaseSettings".

Marco
http://www.hyperroad-design.com

Maarten Holland

Wednesday 04 February 2004 1:19:45 pm

Thank you for your reply. eZ and the database are on the same server. Databasesettings seem OK. Perhaps I need to check my db-permissions from MySQL. I've changed the rights for the relevant user from 'localhost' to 'hosts: any'. I don't think that should be a problem, but you never know. Any other suggestions are welcome.

Vidar Langseid

Wednesday 11 February 2004 2:16:11 am

Since you are running the database on the same server you should have this in the correspondig site.ini (in settings/override/site.ini.append or settings/siteaccess/FOOBAR/site.ini.append)
[DatabaseSettings]
DatabaseImplementation=ezmysql
Server=localhost
Database=ezp_db
User=ezp_usr
Password=ezp_pas

(you have to substitute ezp_db, ezp_usr and ezp_pas with your login information of course)

Then grant the correct persmissions by applying this command in the mysql client:
mysql> grant all privileges on ezp_db.* to ezp_usr@localhost identified by 'ezp_pas';

You must be logged in to post messages in this topic!