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

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