Home› General support

login and password problems

joebak Member
in General support
my url is http://www.tahoeunderground.com/zenphoto/zp-core/setup.php.

So I set up my username, password, host, and database info entered in the zp-setup.php. It then asks me for a login and password. Im assuming the login is the username i created for the database and the password is the password for the database. I enter those and I get redirected to the "zenphoto upgrade page" http://www.tahoeunderground.com/zenphoto/zp-core/setup.php?checked ,where it asks for a login and password. I accepts nothing and keeping bouncing back to the "zenphoto upgrade page". I tried to request a reset a couple times and received no email. Whats my next move? I really want to integrate this program into my website but this is not proving to be that "easy". please help

Comments

  • sbillard Member
    Have you installed a previous version of zenphoto? What version are you installing now?

    Anyway, the user/password for the database need not be the same as for your login to zenphoto. In fact, we would recommend that they be different.

    The general procedure for password problems is found here http://www.zenphoto.org/2007/12/troubleshooting-zenphoto/#16

    Also check your zp-config.php file to be sure it does not have a user/password configured.
  • joebak Member
    No, no previous program installed, I just downloaded it from your website two days ago so I assume the version is 1.1.7. I will try to use the link you gave but when you say to be sure my zp-config.php does not have a user/password configured we might have something because the first thing I tried to do with this issue was to configure zp-config.php to include my username, password, host, and database name. I added the info to the file and reuploaded. The program then was able to connect to the database, I believe, but then prompted me to input the user and password, which never let me past that point. So, do I need to erase the user and password info from the zp-config file and leave the host name and database name? And do I need to change the "true" back to false for a first time download of the program?
  • sbillard Member
    There are two different user/passwords we are talking about here. Best to prefix them to be sure we are on the same track.

    MySQL Admin user/passwords are the ones you configured when you setup your database. They are used solely for connecting to the database and are stored in the zp-config.php file with the lines:
    `$conf['mysql_user'] = "";

    $conf['mysql_pass'] = "";`

    There is also a Zenphoto Admin user/password. These should not be stored in zp-config.php. They are stored in a database table named 'administrators' (prefixed with whatever you set as your database table prefix.)

    I think the best thing for you to do at this point is to drop the tables from your zenphoto database, delete the zp-config.php file from the zp-core folder. Clear any zenphoto browser cookies and re-run the setup program.

    This should prompt you for you MySQL information but should not ask for a user/password for zenphoto. Once you have clicked the GO button you should get a link to setup your zenphoto user/password.
  • joebak Member
    Ok. I dropped the tables from the database via my phpadmin. I then deleted the whole database and created a new one. I entered the mysql user,password,database name and changed the false to true option for a new install on the zp-config.php file. I also deleted all cookies. I then went to the setup page... http://www.tahoeunderground.com/zenphoto/zp-core/setup.php. All I had to do was click go and I was able to set up a new user and password. I entered a couple more lines of info like my website info, clicked save, and now im on this page... http://www.tahoeunderground.com/zenphoto/zp-core/admin.php# ... where I cant get past. I entered the 2nd login and password from the admin.php# page and both were rejected. I then entered zenphoto as the login (the database name on my host) and the password for it was rejected also, but the login "zenphoto" came back, just asking me for my password. Ive tried all combos of both! Which one should I use Can I find the any info i need in my phpadmin? I know we are close here... I can taste it!
  • sbillard Member
    The zenphoto version you are running is not to be the 1.1.7 release. With the 1.1.7 release the version and release numbers are displayed at the bottom of the Admin or Setup pages. So, download version 1.1.7 and try that.
  • sbillard Member
    Forgot to mention you should drop your 'administrators' table prior to running the setup so you start without any zenphoto user/password.
  • joebak Member
    I downloaded it from your website. I thought that was the most recent version. Should I do the nightly update or do a full reinstall. Do you have a direct link to 1.1.7? i deleted the whole database and made a new one. I checked to be sure there were no tables in the database when I tried again. Thank you for your time by the way!
  • sbillard Member
    Of course it depends on when you do the download. Yesterday was the release of 1.1.7. Anyway, you are running 1.1.6, so get 1.1.7 from http://www.zenphoto.org/
  • joebak Member
    Ok. I reuploaded zenphoto from your website. I uploaded the zp-config.php with the information for my zenphoto database. I then went to http://www.tahoeunderground.com/zenphoto
    which redirects me to http://www.tahoeunderground.com/zenphoto/zp-core/setup.php It gives me the "GO" link at the bottom of the page to create the tables in my database. When I click "GO" it takes me here... http://www.tahoeunderground.com/zenphoto/zp-core/setup.php?checked&create=zp_options,zp_albums,zp_images,zp_comments,zp_administrators,zp_admintoalbum,zp_tags,zp_obj_to_tag . The page says...

    Zenphoto Setup
    About to create tables...

    Then in a red table it says...

    Zenphoto Error
    MySQL Query ( SELECT * FROM `zp_albums` ) Failed. Error:Table 'zenphoto.zp_albums' doesn't exist
    It looks like your zenphoto tables haven't been created.You may need to run the setup script.

    "run the set up script" is a link which I click, which takes me back to http://www.tahoeunderground.com/zenphoto/zp-core/setup.php with the "Go" set up tables link. It just takes me in a circle from one page to the next. This is obviosly a new problem and I'm not getting as far in the setup as I did before I installed 1.1.7. What should I do now?
  • joebak Member
    Does this have to do with the problem? I was just looking at the setup.php file. At the top it says...
    define('HTACCESS_VERSION', '1.1.6.0'); // be sure to change this the one in .htaccess when the .htaccess file is updated.

    I then went to the .htaccess file and at the top it says...
    # htaccess file version 1.1.6.0
    # Update the above and the define in setup.php when you make changes to the rewrite rules!
    # NOTE: Change the RewriteBase below to the absolute path to your zenphoto directory. (Or let setup.php do it for you!)

    Do I need to change any of this or is it automated? Does this mean I downloaded version 1.1.6 again?
    Dang I know this should be easy but...
  • sbillard Member
    You do not need to change the .htaccess file. It his not been modified since 1.1.6.0 so we have left the versions intact.

    Run setup again this time add ?debug to the URL: `http://www.tahoeunderground.com/zenphoto/zp-core/setup.php?debug`

    This will create a log of what Setup is doing and the results. First guess is that it is not succeeding in creating the tables.
  • Vertigo Member
    Hi sbillard,
    I have the same problem of joeback, I followed your steps, and what I found out in the log file is that there are those errors:

    Begin table updates
    MySQL Query ( ALTER TABLE `zp_albums` ADD COLUMN `sort_type` varchar(20); ) Failed. Error: Duplicate column name 'sort_type'
    MySQL Query ( ALTER TABLE `zp_albums` ADD COLUMN `sort_order` int(11); ) Failed. Error: Duplicate column name 'sort_order'
    MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `sort_order` int(11); ) Failed. Error: Duplicate column name 'sort_order'
    MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `height` INT UNSIGNED; ) Failed. Error: Duplicate column name 'height'
    MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `width` INT UNSIGNED; ) Failed. Error: Duplicate column name 'width'
    MySQL Query ( ALTER TABLE `zp_albums` ADD COLUMN `parentid` int(11) unsigned default NULL; ) Failed. Error: Duplicate column name 'parentid'
    MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `mtime` int(32) default NULL; ) Failed. Error: Duplicate column name 'mtime'
    MySQL Query ( ALTER TABLE `zp_albums` ADD COLUMN `mtime` int(32) default NULL; ) Failed. Error: Duplicate column name 'mtime'
    MySQL Query ( ALTER TABLE `zp_options` DROP `bool`, DROP `description`; ) Failed. Error: Can't DROP 'bool'; check that column/key exists

    and some more, please let me know if you want me to send you also them.

    my zenphoto version is 1.1.7 [1842]
  • sbillard Member
    Please create a ticket and post the complete file. These are expected errors if you are upgrading.
  • Vertigo Member
    H

    I'm not upgrading...
    how can I create a ticket?
  • sbillard Member
    Please see #2 here http://www.zenphoto.org/support/topic.php?id=2831&replies=2
  • joebak Member
    Your first guess was right. It doesn't get past the http://www.tahoeunderground.com/zenphoto/zp-core/setup.php page anymore to set up the tables. It did set up the tables before I did the upgrade, but I erased that database to create a new fresh one. I added "debug" to think link and the list it gives is a mile long.!? Im not going to past it here to save space. But the link is above for you to view.
  • sbillard Member
    You should then check the permissions that the MySQL user you assigned to zenphoto has. Your setup indicates that there might be a problem there and the result of this exercise indicates that setup is unable to create tables in the database.
  • joebak Member
    I just got this message from my host... " Hi Joe,

    MySQL show grants access is disabled due to shared database security
    policies and cannot be enabled for client users.

    You may wish to consult the developer to see if this is necessary to
    run the program or if it only affects certain modules of the program. "

    Is this my problem?
  • sbillard Member
    It is not necessary for the show grants access as this is just a warning that setup cannot tell if things are set correctly. However, the rights that setup suggests are required for zenphoto to run. In your case it appears that zenphoto does not have the correct rights. Of course, since your ISP thinks that show rights is a security problem we can't check that.
  • donguthrie Member
    I lost my login and password, can you email me the pass codes.
  • sbillard Member
    check the troubleshooting guide for instructions.
Sign In or Register to comment.