+- ZenphotoCMS Forum (https://forum.zenphoto.org)
+-- Forum: Support (https://forum.zenphoto.org/forum-1.html)
+--- Forum: General support (https://forum.zenphoto.org/forum-4.html)
+--- Thread: Where is DB config file? (/thread-10136.html)
Where is DB config file? - EoinDubh - 2012-07-03
I ran into a totally different problem trying to upgrade another site to version 1.4.2.4. I deleted the index.php file and the standard themes and zp-core directories and FTPed up new copies. When I try to run setup I get an error on the database connection. I checked the zp-data/zp-config.php file and found that it had no database connection info in it. I entered the database connection in the space provided in the setup form but it fails to connect. I tried creating a new user in phpmyadmin and assigning that user all rights on the zp database and can connect in phpmyadmin with those credentials.
I cannot connect using these credentials by either entering the info into the zp-config.php file or by entering the info into the setup form.
Do I need to delete the zp-config.php file so it can be created by setup or is there somewhere else that I need to enter the connection info?
Thanks
Where is DB config file? - sbillard - 2012-07-03
This file (zp-data/zp-config.php) is from your old installation. You need to examine the zenphoto.cfg file.
BTW, on a normal update the infromation from zp-config.php would have been imported and the file deleted. Did you get any errors from Setup?
Where is DB config file? - EoinDubh - 2012-07-03
No errors. It fails at the dbconnect and does not log anything.
Where is DB config file? - acrylian - 2012-07-03
Try to add the db credentials manually if for some reason it cannot be updated via setup.
Where is DB config file? - EoinDubh - 2012-07-03
Both zp-data/zp-config and zenphoto.cfg have the same db info. I can go to the ISPs website and log into phpmyadmin with these credentials and get right to the database.
Where is DB config file? - EoinDubh - 2012-07-03
I checked the logs again this morning and found this in the setup log from my last try this morning:
Zenphoto Setup v1.4.2.4[10045] Tue, 03 Jul 2012 02:59:55 -0600
Query error: Access denied for user 'root'@'localhost' (using password: NO)
fail: Database setup in configuration file Access denied for user 'root'@'localhost' (using password: NO)
warn: albums folder [The line $conf['album_folder'] is missing from your configuration file] You should update your configuration file to conform to the current zenphoto.cfg example file.
Where is DB config file? - EoinDubh - 2012-07-03
I renamed .htaccess anf the /zpdata/zenphoto.cfg files and copied the zenphoto.cfg file from /zenphoto/zp-core in the download to /zp-data and re-ren the install. It ran to completion and the photosite is back up.
Thank you for the pointers.