how to find out username and password

[SMF]

I tried this and saw that the password field for user_id 1 now says 21232f297a57a5a743894a0e4a801fc3 yet I still can't login using the password 'admin'. I even tried to insert a new user but that won't let me log in as well.

Are you certain the "admin" username *is* admin?? Because the MD5 you've quoted *is* admin.

SELECT COUNT( * ) AS `Rows` , `username`
FROM `your_database`

1. Do you know the OS flavor?
2. Do you have root access?
If the answer to, 1. is Debian, and 2. is yes, then you can gain access using the username of debian-sys-maint and the root passwd.

May I ask what the value of the admin_access should be? Right now, it's set to 1.

You can ask... ;-p
1 means admin group id, it also means active. So, yes.

[SMF]

and have a reasonably fast box

and have a quantum computer....

There, fixed that for you ;-p


--- why use a sledgehammer to crack a peanut?

[KJHunt]

I have this problem now and I have tried all of the solutions listed to date.

Even after using the DB username password reset the admin login screen just seems to refresh without accessing the cms admin.

Is it an otion to re-install the files without creating new tables in the DB?

Will this overwrite existing uploads files and uploaded images etc?

[Wishbone]

If you don't delete the uploads/ files during your upload, it won't be an issue. There was a thread about this. Make sure your method of uploading only makes non-existent directories and copies files, not replace directories. FTP and rsync do this correctly.

[calguy1000]

Even after using the DB username password reset the admin login screen just seems to refresh without accessing the cms admin.

Check your .htaccess I bet your .htaccess file is generating rewrite rules that are a bit too broad, causing a redirect when accessing the login page. and POST information is lost on redirect.

[KJHunt]

Would it be an idea to only upload the install directory and blank config file instead of doing a full upload?

What are the files required to establish a new connection to the DataBase?

[KJHunt]

Even after using the DB username password reset the admin login screen just seems to refresh without accessing the cms admin.

Check your .htaccess I bet your .htaccess file is generating rewrite rules that are a bit too broad, causing a redirect when accessing the login page. and POST information is lost on redirect.

Hi calguy1000 this is the htaccess:
# -FrontPage-

IndexIgnore .htaccess */.??* *~ *# */HEADER* */README* */_vti*

<Limit GET POST>
order deny,allow
deny from all
allow from all
</Limit>
<Limit PUT DELETE>
order deny,allow
deny from all
</Limit>
AuthName crossogue-equestrian.ie
AuthUserFile /home/crossogu/public_html/_vti_pvt/service.pwd
AuthGroupFile /home/crossogu/public_html/_vti_pvt/service.grp