Installs OK, but can't log in...

Having trouble installing serendipity?
Post Reply
swcarrel
Posts: 3
Joined: Mon May 01, 2006 12:45 am
Location: Denver
Contact:

Installs OK, but can't log in...

Post by swcarrel »

Making me crazy! Installs just fine, reports success, but when I try to log in I get the message "You appear to have entered an invalid username or password." I even tried not putting in a name or password during install, just left the default "John Doe" and "john" for password, same result. What the heck am I overlooking or doing wrong?
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Installs OK, but can't log in...

Post by garvinhicking »

Hi!

If you install serendipity again over an existing installation, it reports that it is checking for existing tables. If those tables are found, NO NEW TABLE CONTENTS are inserted, so your old author login would stay the time every re-installation.

This is to ensure that people are not accidently dumping their database (trust me, this would've happened a lot in the past, if that mechanism weren't in place ;).

So, to fix your problem you would need to delete all serendipity_* tables (via phpMyAdmin or similar) and do the new installation.

The other way of course is to use phpMyAdmin to edit your serendipity_authors table and insert a new password for the user (something like "UPDATE serendpipity_authors SET password = MD5('mypass')".

HTH,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
swcarrel
Posts: 3
Joined: Mon May 01, 2006 12:45 am
Location: Denver
Contact:

Post by swcarrel »

Hi Garvin

Thanks for your very fast and helpful response -- I think I at least understand the problem now. But if you can help me a little further, I will really appreciate it.

When I enter "UPDATE serendpipity_authors SET password = MD5('101trombones')" I get "#1146 - Table 'serendipity.serendpipity_authors' doesn't exist"

What am I doing wrong?

Wayne
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

Hi!

My bad, it was a spelling mistake :D It needs to read "serendipity" and not "serendpipity". Who chose such a damn name... ;-)))

Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
swcarrel
Posts: 3
Joined: Mon May 01, 2006 12:45 am
Location: Denver
Contact:

Post by swcarrel »

Well, now I feel really dumb, not to notice a simple spelling error like that. I guess it's what I get for being lazy and "cutting and pasting."

Anyway, that worked fine, and all is well with the Serendipity world.

Thanks, Garvin

Wayne
Post Reply