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

Next topic

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