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

Author Message

Maarten Holland

Wednesday 04 February 2004 10:41:29 am

Recently the IP-address of my server changed. Most DNS-servers have not yet picked up the new addresss.

After this change, it seems eZ can't connect to the database. Does anyone know if there are configurationfiles that I must change to my new address?

Thanks in advance,

Maarten

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';

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.