Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 8th January 2010, 00:13
isn isn is offline
Member
 
Join Date: Oct 2009
Posts: 55
Thanks: 6
Thanked 2 Times in 2 Posts
Default phpmyadmin stops authenticating, mysql does fine

CentOS 5.4
ISP Config 3.0.1.3 (Afraid to upgrade at this point)
phpmyadmin was working as recently as Saturday night.

It authenticates users and they can do phpmyadmin things.

Server was configured as per "The Perfect Server" document.

Then:

I update a number of rpms unrelated to ISPconfig. Specifically I avoid touching postfix because its working quite well and I do not go looking for trouble.

I thought about leaving phpmyadmin alone. But did eventually update it after backing up the configuration files.

First time I try and visit http://mysite.com/phpmyadmin/

Welcome to phpMyAdmin 2.11.10

Wrong username/password. Access denied.

mysql command line works perfectly for all users.


So I removed phpmyadmin as follows:
yum -y remove phpmyadmin
yum -y install phpmyadmin

Went through the phpmyadmin.conf file and opened it up to external connections.

Changed the authentication type to http from cookie.

Restarted the mysql and httpd services.

No joy.

Cleared all the php files in /var/lib/php/sessions

restarted all services.

Restarted the box.

I don't see any log files to look at. the server access and error logs provide no clues.

/var/log/mysqld.log is normal.

Though its a PITA, I suppose I could track down and find the previous version of phpmyadmin.

SEP

What to do now?

Update:
Downgrade of phpmmyadmin did not help.


Welcome to phpMyAdmin 2.11.5

Wrong username/password. Access denied.

<sigh>

Just for grins I did this:
changed the authentication back to cookie
put in a fake blowfish password.

Fixed.

But still, this is a dork type solution.

What gives?
__________________
isn aka SEP from ITRC forums

Last edited by isn; 8th January 2010 at 00:58. Reason: Added more information.
Reply With Quote
Sponsored Links
  #2  
Old 8th January 2010, 16:15
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,745 Times in 2,578 Posts
Default

Do the MySQL logins still work on the command line?

Code:
mysql -u <username> -p
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 8th January 2010, 17:57
isn isn is offline
Member
 
Join Date: Oct 2009
Posts: 55
Thanks: 6
Thanked 2 Times in 2 Posts
 
Default

mysql -u -ppassword access has worked through out this process.
__________________
isn aka SEP from ITRC forums
Reply With Quote
Reply

Bookmarks

Tags
ispconfig 3, mysql 5.1, phpmyadmin

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ISPConfig3 Mail Warn Errors reason8 General 3 25th November 2009 14:58
PhpMyAdmin MySql Basics - MySql Connect DankSherman Programming/Scripts 1 10th March 2008 06:29
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 10:11
LAMP System Fedora Core 6 MySQL start error gavino HOWTO-Related Questions 13 21st November 2007 20:13
phpmyadmin "Cannot load mysql extension. Please check your PHP configuration" rjamesd Programming/Scripts 4 23rd October 2007 17:27


All times are GMT +2. The time now is 16:21.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.