Admin password no longer works

breakerke · Post by **breakerke** » Tue Jan 09, 2007 8:49 am

hi,

yesterday I have downloaded/installed Serendipity on my webserver because I liked the screenshots and functionality of the package.

Everything went well but I haven't started configuring it yet...
Today I wanted to go to the Admin panel and for some strange reason,
I can no longer log in with the admin account... No, CAPS LOCK isn't on and yes I have verified the password and username...

The system just won't accept them...

Any idea how I can reset that? I have db access off course if needed...

Thanks in advance & keep up the excellent work!

regards,
breakerke

breakerke · Post by **breakerke** » Tue Jan 09, 2007 11:15 am

For those who are interested, I have found a solution.

Go to phpMyAdmin and open the serendipity_authors table.
There just empty the password field and log in with a blank password.

Off course it is advisable to immediately enter a password again...

laterzzz

kaediem · Post by **kaediem** » Fri Mar 02, 2007 8:33 am

was fighting with this for a while.

Lisa

kerry · Post by **kerry** » Fri Mar 02, 2007 7:42 pm

I am struggling with this same thing. I am in phpmyadmin in the authors. and i see the table, and I see a field that says passwords that I can browse, delete, change etc. BUt I am totally clueless which field where I should be deleting to take out the password. Very weird that admin password stopped working, as I do have it to automatically fill in the page on my computer, and I cannot get in anyhow

kaediem · Post by **kaediem** » Fri Mar 02, 2007 11:15 pm

hi Kerry,

When I did this last night the field should be filled with a giant string of numbers/letters - that's the one you delete.

The same happened to me - had it saved in my browser and poof... gone.

I hope this helps.

Lisa

kerry · Post by **kerry** » Fri Mar 02, 2007 11:51 pm

Yep, ok I deleted the right one, which also then deleted the fields for username etc for that, but still not letting me in, what did you use for your user name? When I deleted the password it also deleted the user name.
This is weird...

kaediem · Post by **kaediem** » Sat Mar 03, 2007 12:00 am

oh man, I don't know what to tell you - when I did it I just blanked out the password field and everything else stayed.

I hope Garvin can help you here.

Lisa

Post by **garvinhicking** » Sat Mar 03, 2007 11:51 pm

Hi kerry!

Can you make a screenshot of how your serendipity_authors table contents look like right now?

You need to make sure a password and the username is in that row...

Regards,
Garvin

kerry · Post by **kerry** » Sun Mar 04, 2007 1:34 am

This is what the authors returns and then when I go into the password etc it contains what is below this where it says that it returns nothing
Field Type Attributes Null Default Extra Action
realname varchar(255) No Browse Change Drop Primary Index Unique Fulltext
username varchar(20) Yes NULL Browse Change Drop Primary Index Unique Fulltext
password varchar(32) Yes NULL Browse Change Drop Primary Index Unique Fulltext
authorid int(11) No auto_increment Browse Change Drop Primary Index Unique Fulltext
mail_comments int(1) Yes 1 Browse Change Drop Primary Index Unique Fulltext
mail_trackbacks int(1) Yes 1 Browse Change Drop Primary Index Unique Fulltext
email varchar(128) No Browse Change Drop Primary Index Unique Fulltext
userlevel int(4) UNSIGNED No 0 Browse Change Drop Primary Index Unique Fulltext
right_publish int(1) Yes 1 Browse Change Drop Primary Index Unique Fulltext
With selected: Check All / Uncheck All With selected: Browse Change Drop Primary Index Unique Fulltext
Print viewPrint view Propose table structurePropose table structureDocumentation
Add new fieldAdd field(s)At End of Table At Beginning of Table After
Indexes: Documentation
Keyname Type Cardinality Action Field
PRIMARY PRIMARY 0 Edit Drop authorid
Create an index on columns
Space usage Type Usage
Data 0 Bytes
Index 1,024 Bytes
Total 1,024 Bytes
Row Statistics Statements Value
Format dynamic
Rows 0
And this is what it returns when I go into the password or user name or such

MySQL returned an empty result set (i.e. zero rows). (Query took 0.0006 sec)
SQL query: SELECT COUNT( * ) AS `Rows` , `password`
FROM `serendipity_authors`
GROUP BY `password`
ORDER BY `password`
LIMIT 0 , 30
[ Edit ] [ Explain SQL ] [ Create PHP Code ] [ Refresh ]

Field Type Attributes Null Default Extra Action
realname varchar(255) No Browse Change Drop Primary Index Unique Fulltext
username varchar(20) Yes NULL Browse Change Drop Primary Index Unique Fulltext
password varchar(32) Yes NULL Browse Change Drop Primary Index Unique Fulltext
authorid int(11) No auto_increment Browse Change Drop Primary Index Unique Fulltext
mail_comments int(1) Yes 1 Browse Change Drop Primary Index Unique Fulltext
mail_trackbacks int(1) Yes 1 Browse Change Drop Primary Index Unique Fulltext
email varchar(128) No Browse Change Drop Primary Index Unique Fulltext
userlevel int(4) UNSIGNED No 0 Browse Change Drop Primary Index Unique Fulltext
right_publish int(1) Yes 1 Browse Change Drop Primary Index Unique Fulltext
With selected: Check All / Uncheck All With selected: Browse Change Drop Primary Index Unique Fulltext
Print viewPrint view Propose table structurePropose table structureDocumentation
Add new fieldAdd field(s)At End of Table At Beginning of Table After
Indexes: Documentation
Keyname Type Cardinality Action Field
PRIMARY PRIMARY 0 Edit Drop authorid
Create an index on columns
Space usage Type Usage
Data 0 Bytes
Index 1,024 Bytes
Total 1,024 Bytes
Row Statistics Statements Value
Format dynamic
Rows 0
Next Autoindex 1
Creation Mar 02, 2007 at 11:40

Post by **garvinhicking** » Sun Mar 04, 2007 6:17 pm

Hi!

Sadly this doesn't help at all - the formatting is all lost here. Please make a screenshot.

Why are you using a GROUP BY query? Simply use "SELECT * FROM serendipity_authors", that would be more helpful

HTH,
Garvin

kerry · Post by **kerry** » Sun Mar 04, 2007 8:06 pm

Unfortunately I nothing about adminphp...besides how to get in there!
I put up the two screenshots here at this link.
http://www.bvihcg.com/1.jpg
http://www.bvihcg.com2.jpg

Thank you for the help

Post by **garvinhicking** » Sun Mar 04, 2007 8:43 pm

Hi!

Ah. Your serendipity_authors table is empty. So you seem to have deleted any authors.

It might be that you have deleted even more things that are vital to serendipity, like the serendipity_groups or serendipity_authorgroups tables. Or are you sure you only used phpMyAdmin to edit the serendipity_authors table?

If so, then click on the "Insert" link in the screenshots you showed us. There you can add a new row.

Enter this data on the next screen:

realname: kerry
username: kerry
password: anything you like (make sure on the left to the input box you selected "MD5" in the 'function' dropdown, because passwords need to be encoded and not cleartext)
authorid: 1
mail_comments: 1
mail_trackbacks: 1
email: your@mail.com
userlevel: 255
right_publish: 1

Then you can login with username "kerry" and the password you chose.

Regards,
Garvin

kerry · Post by **kerry** » Sun Mar 04, 2007 10:57 pm

Ok. I tried that, and it still will not let me in. The only place I tried to fix anything is in the passwords by trying to delete the password, which then deleted the user name etc as well. I did not know where to do anything else.
I have posted new screen shots, as well the third link is to the author groups table as well in case that has anything to do with it.
http://www.bvihcg.com/1.jpg
http://www.bvihcg.com/2.jpg
http://www.bvihcg.com/3.jpg

Thank you
Kerry

Post by **garvinhicking** » Mon Mar 05, 2007 2:50 pm

Hi!

When you are in a table simply click on the top left tab "Browse". Then you see all rows in that database.

In serendipity_authors there should be one, and in serendipity_Groups should be 3 and serendipity_Authorgroups also one row with your userid and the admin group id.

Regards,
Garvin

kerry · Post by **kerry** » Mon Mar 05, 2007 3:28 pm

Ok, lets try again!
http://www.bvihcg.com/groups.jpg
http://www.bvihcg.com/author_groups.jpg
http://www.bvihcg.com/authors.jpg