zenphoto forums » General Zenphoto Discussion

Where is DB config file?

(7 posts)
  • Started 10 months ago by EoinDubh
  • Latest reply from EoinDubh

  1. EoinDubh

    Member
    Joined: Jan '11
    Posts: 20

    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

    Posted 10 months ago #

  2. Zenphoto development team
    sbillard

    Chief Developer
    Joined: May '07
    Posts: 9,769

    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?

    Don't forget to read the Forum rules and usage resources
    Posted 10 months ago #

  3. EoinDubh

    Member
    Joined: Jan '11
    Posts: 20

    No errors. It fails at the dbconnect and does not log anything.

    Posted 10 months ago #

  4. Zenphoto development team
    acrylian

    Developer
    Joined: Jul '07
    Posts: 13,365

    Try to add the db credentials manually if for some reason it cannot be updated via setup.

    Don't forget to read the Forum rules and usage resources
    Posted 10 months ago #

  5. EoinDubh

    Member
    Joined: Jan '11
    Posts: 20

    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.

    Posted 10 months ago #

  6. EoinDubh

    Member
    Joined: Jan '11
    Posts: 20

    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.

    Posted 10 months ago #

  7. EoinDubh

    Member
    Joined: Jan '11
    Posts: 20

    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.

    Posted 10 months ago #

RSS feed for this topic

Reply

You must log in to post.