Page 1 of 1

Admin login not working - users table empty

PostPosted: Tue Mar 24, 2009 1:00 pm
by yvan
I recently installed web auction on a windows-based shared hosting environment that's running PHP 5 and MySQL 5.

I did manage to get the software installed and interfacing with a mysql 5 database -- however -- I am unable to log in to the admin site.

In the readme file -- it states that the admin can be accesed using "admin" as the username, and "password" as the password. That didn't work for me. Instead, I get redirected to the login screen with the message "Sorry, you have entered an incorrect username /password combination. Please try again" displayed at the top.

I then manually inserted a new record in the "users" table in the database (the user table was previously empty) .. but I am still unable to log in to the admin using that username and password combination. Again, I get redirected to the login screen with the message "Sorry, you have entered an incorrect username /password combination. Please try again" displayed at the top.

Are there any known issues with running this app under Windows? And does this software even run under PHP 5 / MySQL 5? Lastly -- why am I unable to log in to the admin site, and what can I do to fix this?

Thanks,
- Yvan

PostPosted: Thu Apr 02, 2009 7:17 pm
by shannah
Passwords need to be stored with md5() encryption. E.g. when you add your user you would need to do something like:

Code: Select all
insert into users (username,password) values ('foo', md5('password'))