Home› General support

Database location

Alov Member
in General support
Hi guys,
I recently started a new job and found there is a ZenPhoto running. The gallery goes well while admin page http://ip/zp-core/admin.php prompt me a password which i actually dont know at all. Looking through the forum i found it is a good idea to delete the records with the names adminpass and adminuser in the database. But the bad thing is I have no idea what is the current location of the database .. probably some other server or planet. So is there a way to determine where ZenPhoto database is?

Comments

  • fretzl Administrator, Developer
    Your host should know where to find and administer the database.
  • sbillard Member
    If you know where the installation files are located you can look at the configuration file. It will give you the database details.
  • Alov Member
    When accessing to zp-core and zp-data folders the only configuration file i can see is zenphoto_cfg but it still doesn`t give me a hint where the database is.

    $conf['mysql_host'] = 'localhost'; // Supply the name of your Database server.
    $conf['mysql_database'] = ''; // Supply the name of Zenphoto's database
  • acrylian Administrator, Developer
    Yes, of course because how should Zenphoto know where on your webspace the database is located? Your webhost should provide you with the info about that. Generally on shared hosts the database is on a separate server.
  • Alov Member
    I am currently on my webhost where one can see albums folder and pics in it and so on.. What steps should i do to find and edit the database using say phpMyAdmin ?
  • fretzl Administrator, Developer
    Please ask your host.
  • sbillard Member
    If Zenphoto is really running the configuration file would have the correct database information. So we can only conclude that the configuration file you found is not the one from the running installation.
  • Alov Member
    Yes Zenphoto is running pretty fine - i can access the website both from outside and LAN. Is is possible that the original configuration file was deleted/replaced during ZenPhoto update though once again it`s running ? Is there option to install ZehPhoto with no database - i've racked my brain...
  • acrylian Administrator, Developer
    The config file is normally created by setup when installing Zenphoto the first time. On that occasion you are requested to enter the database credentials.

    Zenphoto requires a database.
  • sbillard Member
    You will have to speak with your website administration to find where the files are. Find the installation files and you will find the real configuration file. It will have the database credentials.
  • Alov Member
    Argh. That be me who administer the website and got no contact info for the previous admin guy. The webserver is inside of our Local Area Network and can be accessed from the Internet as well. I suspect that installation files were deleted after install process as recommended?
  • acrylian Administrator, Developer
    The installation files do not tell you where your database or what database server is. Those are entered via the installation files (Setup) on installing the first time and stored in the config file withn /zp-data.

    If that has been deleted for whatever reason you need to find out those credentials.
  • sbillard Member
    If you do not know where the files are, you will have to find out somehow. If for nothing else than you cannot upgrade unless you know where to place the files.

    I guess you should log onto the server and do a file search for something like "zenphoto.package".
  • Alov Member
    Zenphoto.package is located in C:\Inetpub\wwwroot\zp-core. Are there any specific lines in the file worth to check out?
  • acrylian Administrator, Developer
    You can always re-download the Zenphoto version you installed to get the install files back. We have an older release archive on our site.
  • sbillard Member
    The file you want to look at would be `C:\Inetpub\wwwroot\zp-data\zenphoto.cfg` (Your installation is in your wwwroot folder.)
  • Alov Member
    Many Thanks sbillard - you've made my day! Thanks to acrylian as well! That`s exactly what i need to locate the database and reset a password.
  • acrylian Administrator, Developer
    Great that we finally got it..:-)
Sign In or Register to comment.