rsfeller - I did see your screenshot, and you are misunderstanding how the options table is created. The column names you see are correct, the options themselves (including username and password) are stored in the table as rows through the "name" and "value" columns -- you shouldn't see any columns about username or password.
If you can log in at all then the username/password are working, it's just the cookie mechanism that's the problem. So, do not worry about the database.
I think you're right about the problem being server-side, since you can't see the cookie at all (it's called 'zenphoto' I believe). I just wish I had more information, because I'm stumped...
Would you be willing to change the user/pass to something to share with us so we can test this out ourselves? Make it admin/pass1234 if that's ok.
Not sure if you wanted the database access password changed or the zenphoto change, so I made both admin/pass1234.
I was curious in previous comments that I now see this comment, posibly a trigger written into the nightly build:
"Your mySQL user must have Select, Insert, Update, and Delete rights."
anything to be concerned about?
I'll crack open a mysql for dummies book I have around here and try to remember how to look tables/values via cmd line, late time I did that it took me all night to view things via cmd line.
I suggest you use myphpadmin for this looking into your database: http://www.phpmyadmin.net
No need for cmd line.
First - "Your mySQL user must have Select, Insert, Update, and Delete rights." - no, nothing to be concerned about right now -- it doesn't seem to be related or affecting this problem. Let's go one thing at a time.
Again, do not worry about the database, forget about mysql, let's focus on Zenphoto first. Once we can see what's wrong we'll go from there.
I definitely want just the Zenphoto password changed - not the database password. Change the database back (make sure the zenphoto zp-config.php matches it), and just try changing the zenphoto password. Also, try logging in to zenphoto with the new username/password and make sure that works.
sbillard,
I'm sorry this was my error:
user:admin
pass:admin1234
I can in fact login with those credentials but as expected am returned to the same login screen. There must be a password in the database becuase even knowing I'm returned to that screen we know a "bad" password will inform us! Therefor the user/pass is accepted but the cookie issue is the concern.
We'll let's verfy we are on the same page:
This is the url: http://carboncow.net/zenphoto/zp-core/admin.php
user: admin
pass: admin1234
When I login the screen doesn't advance, it simply returns to a blank login screen but if I enter the wrong credentials it gives me a failure.
This first link shows you what I see after loging in:
http://carboncow.net/php/gallery/view_photo.php?set_albumName=album164&id=1_G
This link shows the error message when I enter the wrong credentials on purpose:
http://carboncow.net/php/gallery/view_photo.php?set_albumName=album164&id=2_G
Again, this tells me that the credentials are in fact being verified and when they fail we get the message we would expect. The correct credentials do not advance to the expected admin screen with tabs. I have never seen that screen after logging in.
Fun eh?
I honestly don't want to give up on the project but was hoping for an easy answer. I know these install can throw some curves as I have NEVER had and easy install on a Win2K server with Mambo, Joomla!, Gallery 1.5, ect. I think word press may have been the only think that never gave me issues, but I never liked that product.
Thanks again for the continued efforts. Let me know if you can get to the login screen with the credentials supplied.
Shawn
OK, we are now on the same page. I have tried to log into your site and get the behavior you describe. I reviewed my cookies file and have no cookie from your site, so the issue is that the cookies are not being sent.
Now you are beyond my ability to help. Perhaps someone else would know why the cookie would not be sent.
I'm sorry, I too am stumped.
I've filed a bug and we'll see if we can find the problem, but my first guess is some kind of server security setting. It seems like the username/password are validated and allowed, but then the cookie header simply does not get sent... very strange.
I'll research more later when I have time. Sorry I can't help you more...
I'm having this same problem. I did a re-install of the latest nightly build because the software couldn't create tables now it won't let me login. I type my UN/PS hit enter then it reloads the admin page again.
Any suggestions? www.delmarvagraphics.com/gallery/zp-core/admin.php
Do I have to login first to see anything on www.delmarvagraphics/gallery/?
Thanks for help guys...
Tom, just to help those who are trying to help us.
What is the server you are running this on and version? Are you using Microsoft, Apache, ect. If you are using MS do you have .ASP?
I tried a fake UN/PS on your site and as expected was rejected. When you use the correct credentials does it simply return to the page w/o a rejection? If so you are in the same boat as me.
Make sure you client side cookies are allowed (I'm sure they are).
I did some searching and saw posts about ASP and cookie issues on the server side. Will do more research to see if this pertains to me.
Shawn
tom4panic:
You should be able to view your gallery even without loggin in (after all, that is how most visitors will do it.) When I visit your link, my browser just says it cannot display the web page.
I assume you could log in before you did the upgrade?
Some other users have reported strange problems that ended up being problems with corrupted file uploads. Can you try removing the zenphoto files and re-uploading them?
does this apply?
http://rtfm.atrax.co.uk/infinitemonkeys/articles/asp/910.asp
I know this most likly wasn't developed with IIS and ASP in mind but I'm readying quite a bit on ASP and cookies not being set issues. Wish I could read code!