Forums / Install & configuration / "No database connection could be made" after IP-address changed
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
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_usrPassword=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';