Page 1 of 2

Unable to login after resetting Admin Password in PhpMyAdmin

Posted: Thu Apr 09, 2009 1:56 pm
by blooink
Ive been following instructions for resetting my admin password via PhpMyAdmin and I am still unable to login!
I have used the seggested MD5 codes but that hasn't worked!
I wonder if this is a configuration issue with Community Builders login module settings or something like that?

Re: Unable to login after resetting Admin Password in PhpMyAdmin

Posted: Thu Apr 09, 2009 2:06 pm
by parkerj
Do you have a login module on your site or community builder that has a "forgot password" link? If so, maybe you can have it reset your password so that you can log back in to change it to whatever you like.

Re: Unable to login after resetting Admin Password in PhpMyAdmin

Posted: Thu Apr 09, 2009 2:16 pm
by blooink
parkerj wrote:Do you have a login module on your site or community builder that has a "forgot password" link? If so, maybe you can have it reset your password so that you can log back in to change it to whatever you like.
It does but it doesn't work???

Re: Unable to login after resetting Admin Password in PhpMyAdmin

Posted: Thu Apr 09, 2009 2:24 pm
by blooink
I have sent for a password reset and nothing is arriving?
Also tried to reset it in PhpMyAdmin but nothing!

Re: Unable to login after resetting Admin Password in PhpMyAdmin

Posted: Thu Apr 09, 2009 2:28 pm
by parkerj
What password encryption generator are you using to input a password in phpmyadmin?

Re: Unable to login after resetting Admin Password in PhpMyAdmin

Posted: Thu Apr 09, 2009 2:30 pm
by Jay44
mail settings in Global - server? php or smtp? This will affect some servers

caught in a spam folder and not getting to you?

is the live_site variable set in the config file? This can cause log in problem sometimes

Otherwise, check those MD5 codes and try again... it should fix it

J

Re: Unable to login after resetting Admin Password in PhpMyAdmin

Posted: Thu Apr 09, 2009 2:38 pm
by blooink
parkerj wrote:What password encryption generator are you using to input a password in phpmyadmin?
MD5

Re: Unable to login after resetting Admin Password in PhpMyAdmin

Posted: Thu Apr 09, 2009 2:41 pm
by parkerj
Have you considered Jay44's suggestions? If so, have you tried this MD5 generator: http://www.zappersoftware.com/Help/md5.php?

Re: Unable to login after resetting Admin Password in PhpMyAdmin

Posted: Thu Apr 09, 2009 3:01 pm
by blooink
ok I recieved the emails to reset the passwords. I followed the instructions to reset but still I am unable to login!
What is going on?

Re: Unable to login after resetting Admin Password in PhpMyAdmin

Posted: Thu Apr 09, 2009 3:04 pm
by blooink
I am unable to login both front and back ends of the site!

Re: Unable to login after resetting Admin Password in PhpMyAdmin

Posted: Thu Apr 09, 2009 3:10 pm
by parkerj
Try registering a new user, go into phpmyadmin and set the new user to Super Administrator, and then see if you can log into the backend.

Re: Unable to login after resetting Admin Password in PhpMyAdmin

Posted: Thu Apr 09, 2009 3:27 pm
by blooink
Ok I tried to register a new user. Upgraded him to super admin and then tried to login and got the following error....

Please log in or register to view or modify your profile.

So I think this has something to do with the settings of the actual login module.
Not sure how that ties in with the original problem but they must be connected?

Re: Unable to login after resetting Admin Password in PhpMyAdmin

Posted: Thu Apr 09, 2009 3:32 pm
by parkerj
Did you try logging into the backend, or through the login module?

Re: Unable to login after resetting Admin Password in PhpMyAdmin

Posted: Thu Apr 09, 2009 3:35 pm
by blooink
both

Re: Unable to login after resetting Admin Password in PhpMyAdmin

Posted: Thu Apr 09, 2009 3:40 pm
by parkerj
That new user you created, can you set the role back to what it was, and let me know if you can login into the front end. If not, see if you can find the joomla login module in your database and set it to active, then see if you can login. If you can, then try logging in with the old super administrator account, change your password, and then see if you can log into the backend.

Re: Unable to login after resetting Admin Password in PhpMyAdmin

Posted: Thu Apr 09, 2009 3:43 pm
by blooink
Well I think I have found the problem but not the solutions and in the process some new more serious problems!
1. The issue seems to be related to my new installation of Jfusion.
2. I have made the mistake of dropping the tables to jfusion in Phpmyadmin and now i get the following error!

Fatal error: Call to a member function getUser() on a non-object in /home/blooinkc/public_html/blootrax.co.cc/plugins/authentication/jfusion.php on line 71

What have I done?? ;-(

Re: Unable to login after resetting Admin Password in PhpMyAdmin

Posted: Thu Apr 09, 2009 3:50 pm
by parkerj
The only thing I can think of is delete everything that jfusion may have installed (components, modules, plugins, etc.). Also, if jfusion has modified any core files, then FTP a fresh copy of those files. After doing so, you should then be able to login. I am not familiar with jfusion, so I don't know if it manipulates any other tables in your database.

Re: Unable to login after resetting Admin Password in PhpMyAdmin

Posted: Thu Apr 09, 2009 3:58 pm
by blooink
blooink wrote:Well I think I have found the problem but not the solutions and in the process some new more serious problems!
1. The issue seems to be related to my new installation of Jfusion.
2. I have made the mistake of dropping the tables to jfusion in Phpmyadmin and now i get the following error!

Fatal error: Call to a member function getUser() on a non-object in /home/blooinkc/public_html/blootrax.co.cc/plugins/authentication/jfusion.php on line 71

What have I done?? ;-(
Ok I've fixed that issue by unpublishing the Jfusion Authentication in PhpMyAdmin.

Only thing to sort out now is the issue of still being unable to login!

Re: Unable to login after resetting Admin Password in PhpMyAdmin

Posted: Thu Apr 09, 2009 4:09 pm
by parkerj
If you feel comfortable with giving me login information to your database and link to site, pm me. If not, hopefully someone else who may have had this issue will chime in.

Re: Unable to login after resetting Admin Password in PhpMyAdmin

Posted: Thu Apr 09, 2009 4:22 pm
by blooink
Well some how and im not sure how but Ive deleted the Jos_Modules whilst deleting Jfusion. Now my site has gone completely tits up!

Is there a way to recover the Jos_Modules table?

Re: Unable to login after resetting Admin Password in PhpMyAdmin

Posted: Thu Apr 09, 2009 4:34 pm
by parkerj
I will take a look at that.

Re: Unable to login after resetting Admin Password in PhpMyAdmin

Posted: Thu Apr 09, 2009 4:58 pm
by parkerj
Can you see if you can login now?

Re: Unable to login after resetting Admin Password in PhpMyAdmin

Posted: Thu Apr 09, 2009 5:05 pm
by parkerj
I am off to lunch, but you should be able to login. If not, I will be back in 30min.

Re: Unable to login after resetting Admin Password in PhpMyAdmin

Posted: Thu Apr 09, 2009 5:41 pm
by blooink
No unfortunately I am still unable to login and the admin section displays the followinh errors:



* Error loading Plugins: Table 'blooinkc_jo154.jos_plugins' doesn't exist SQL=SELECT folder AS type, element AS name, params FROM jos_plugins WHERE published >= 1 AND access <= 0 ORDER BY ordering
* Error loading Plugins: Table 'blooinkc_jo154.jos_plugins' doesn't exist SQL=SELECT folder AS type, element AS name, params FROM jos_plugins WHERE published >= 1 AND access <= 0 ORDER BY ordering
* Error loading Plugins: Table 'blooinkc_jo154.jos_plugins' doesn't exist SQL=SELECT folder AS type, element AS name, params FROM jos_plugins WHERE published >= 1 AND access <= 0 ORDER BY ordering
* JAuthentication::__construct: Could not load authentication libraries.
* Error loading Plugins: Table 'blooinkc_jo154.jos_plugins' doesn't exist SQL=SELECT folder AS type, element AS name, params FROM jos_plugins WHERE published >= 1 AND access <= 0 ORDER BY ordering
* Username and password do not match
* Error Loading ModulesUnknown column 'control' in 'field list' SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 1 ORDER BY position, ordering
* Error loading Plugins: Table 'blooinkc_jo154.jos_plugins' doesn't exist SQL=SELECT folder AS type, element AS name, params FROM jos_plugins WHERE published >= 1 AND access <= 0 ORDER BY ordering

Re: Unable to login after resetting Admin Password in PhpMyAdmin

Posted: Thu Apr 09, 2009 5:56 pm
by parkerj
Maybe I am looking at the wrong site, is your site at http://blooink.co.cc or do you have more than one install?

Re: Unable to login after resetting Admin Password in PhpMyAdmin

Posted: Thu Apr 09, 2009 6:00 pm
by blooink
oh ok sorry. The root is Blooink.co.cc but the problem is blootrax.co.cc which is in a sub folder of blooink.co.cc

Re: Unable to login after resetting Admin Password in PhpMyAdmin

Posted: Thu Apr 09, 2009 6:01 pm
by blooink
blooink wrote:oh ok sorry. The root is Blooink.co.cc but the problem is blootrax.co.cc which is in a sub folder of blooink.co.cc
Database jo_154

Re: Unable to login after resetting Admin Password in PhpMyAdmin

Posted: Thu Apr 09, 2009 6:03 pm
by blooink
looks like it might need a clean install?

Re: Unable to login after resetting Admin Password in PhpMyAdmin

Posted: Thu Apr 09, 2009 6:11 pm
by parkerj
Let's see if we can avoid that first. Can you FTP new files in folder /administrator and let me know when you are done?

Re: Unable to login after resetting Admin Password in PhpMyAdmin

Posted: Thu Apr 09, 2009 6:19 pm
by parkerj
Actually, scratch that. You have too many missing tables. Your plugins table is missing as well. What you should do is download all your sql tables if you are using or planning on using all of them. Delete the configuration file and upload the installation folder. Then go through the installation process again, and use the same database. At the mysql section of the install, it will notice that you have tables, you should choose the backup tables option and complete the install.