1
Kainaij
Login issue...
  • 2008/4/28 6:52

  • Kainaij

  • Quite a regular

  • Posts: 256

  • Since: 2004/10/5


My admin account has miraculously stopped logging in. Top it off I cannot register as a new user. These problems seemed to begin back on the 16th of April after user wzza##### registered. I can't be certain of this as being related but it's quite a coincidence.

I've recently been doing some adjustments to my site and .htaccess file. I've copied a working copy of this file from a recent backup and still this problem persists.

Also the config seemed to be stuck in php5 aven after I removed the addhandler line code in .htaccess locking in php5. I've since locked it in back down to php4 since using php5 also gave me login issues.

Can anyone help me remedy this issue?

My Info:

Website URL:
http://kainaistudies.com

XOOPS Version:
XOOPS 2.0.17

XOOPS Theme:
7dana-jane

XOOPS Template Set:
default

PHP Version:
4.4.8

MySQL Version:
5.0.45-community

Server Software:
Apache/1.3.41 (Unix) mod_log_bytes/1.2 mod_bwlimited/1.4 mod_auth_passthrough/1.8 FrontPage/5.0.2.2635 mod_ssl/2.8.31 OpenSSL/0.9.7a

User's Browser:
Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.14) Gecko/20080404 Firefox/2.0.0.14
Current Projects:
http://kainaistudies.com
http://mikaisto.com

2
elbeer
Re: Login issue...
  • 2008/4/28 13:54

  • elbeer

  • Just popping in

  • Posts: 68

  • Since: 2007/8/26


do a search for login errors or auto log out.

3
Catzwolf
Re: Login issue...
  • 2008/4/28 19:58

  • Catzwolf

  • Home away from home

  • Posts: 1392

  • Since: 2007/9/30


Check your database for corrupt database tables, sounds like that could be the problem. if not, delete that user to see if it starts working again, if it does let us know and we will look into why this should be happening.

John

4
Kainaij
Re: Login issue...
  • 2008/4/29 0:36

  • Kainaij

  • Quite a regular

  • Posts: 256

  • Since: 2004/10/5


Which tables specifically am I looking at? Also what would a corrupt table look like? I can make my way around PHP Admin well enough, just my SQL parsing isn't the greatest.
Current Projects:
http://kainaistudies.com
http://mikaisto.com

5
tom
Re: Login issue...
  • 2008/4/29 1:34

  • tom

  • Friend of XOOPS

  • Posts: 1359

  • Since: 2002/9/21


I know it goes without saying, but first make your back up.

If you have phpMyAdmin, then you should be able to select the tables, and then at the bottom should be a drop down box, in there are options such as 'Check Tables', 'Repair Tables' and 'Analyse Tables'.

You can repair them from there if required.

If your going to remove the user as Catz suggested, then if possible get the UID, normally in the url of their profile.

Or if you know their username (which I think you said you did), then you can always do a search on the users table.

_users

Hope this is of some use.
Kind Regards.
Tom

http://bassmanthemes.com
http://www.xoopslance.com

6
Kainaij
Re: Login issue...
  • 2008/4/29 12:46

  • Kainaij

  • Quite a regular

  • Posts: 256

  • Since: 2004/10/5


I did a check of my tables and all were ok except xoops_session which gives the cryptic response "in use". I checked all my table and they all gave the response "ok" except xoops_session which gave "Table is already up to date".

Is this normal?
Current Projects:
http://kainaistudies.com
http://mikaisto.com

7
Kainaij
Re: Login issue...
  • 2008/4/29 13:42

  • Kainaij

  • Quite a regular

  • Posts: 256

  • Since: 2004/10/5


OK

@Tom & Catz
Did the search, deleted the user, tried to login, no luck.

I also cleared templates_c and deleted cache\adminmenu, no luck.

With some great advice from Aph3x I emptied the _sessions table and it worked.

Thank you Catz, Tom, and Aph3x for your advice.

Last question; with _sessions being frozen, could it have been malicious or just one of those things?

P.S.
Welcome back Catz.
Current Projects:
http://kainaistudies.com
http://mikaisto.com

8
aph3x
Re: Login issue...
  • 2008/4/29 14:02

  • aph3x

  • Theme Designer

  • Posts: 834

  • Since: 2004/12/26


ur most welcome
Everything I'm not made me everything I am
The Themes

9
Catzwolf
Re: Login issue...
  • 2008/4/30 1:14

  • Catzwolf

  • Home away from home

  • Posts: 1392

  • Since: 2007/9/30


Normally if your website starts having login issues, 9/10 it is due to a currupt database table (Sessions to be exact). Not exactly sure why this only happens with this table within XOOPS but it does.

10
Kainaij
Re: Login issue...
  • 2008/5/4 6:46

  • Kainaij

  • Quite a regular

  • Posts: 256

  • Since: 2004/10/5


My issue has arisen again, arrrgh!

More info to come, after I finish picking my hair up off the floor.
Current Projects:
http://kainaistudies.com
http://mikaisto.com

Login

Who's Online

181 user(s) are online (97 user(s) are browsing Support Forums)


Members: 0


Guests: 181


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits