Page 2 of 2

Re: how to find out username and password

Posted: Mon Nov 15, 2010 3:57 pm
by SMF
thecrush wrote: 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.

Re: how to find out username and password

Posted: Mon Nov 15, 2010 4:04 pm
by SMF
rtkd wrote: 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?

Re: how to find out username and password

Posted: Wed Mar 02, 2011 3:50 pm
by 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?

Re: how to find out username and password

Posted: Wed Mar 02, 2011 5:08 pm
by 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.

Re: how to find out username and password

Posted: Wed Mar 02, 2011 5:28 pm
by 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.

Re: how to find out username and password

Posted: Wed Mar 02, 2011 5:42 pm
by 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?

Re: how to find out username and password

Posted: Wed Mar 02, 2011 5:46 pm
by KJHunt
calguy1000 wrote:
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