Home› General support

Where is DB config file?

EoinDubh Member
in General support
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

Comments

  • sbillard Member
    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?
  • EoinDubh Member
    No errors. It fails at the dbconnect and does not log anything.
  • acrylian Administrator, Developer
    Try to add the db credentials manually if for some reason it cannot be updated via setup.
  • EoinDubh Member
    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.
  • EoinDubh Member
    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.
  • EoinDubh Member
    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.
Sign In or Register to comment.