#1  
Old 8th April 2012, 03:07
diago diago is offline
Junior Member
 
Join Date: Mar 2012
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Mysql Issue related to ISPC3

All of a sudden, I am having some serious issues with ISPC3. Everytime I try to create a new mysql database through ISPC3, I end up losing ALL root access to mysql. It is like it is changing the password for root each and everytime because I have to go in with --skip-grant-tables in order to fix whatever it does. The other weird part is that it won't even create the database either.

I have no clue what is going on and this didn't start until I went to get rid of the prefix settings. Any help in figuring out what could cause this would be appreciated. While I am waiting for a fix, I will just administer the databases using phpMyAdmin.
Reply With Quote
Sponsored Links
  #2  
Old 8th April 2012, 11:13
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,751 Times in 2,581 Posts
Default

Are there any MySQL errors in your logs? Which distribution do you use?
__________________
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 April 2012, 14:13
diago diago is offline
Junior Member
 
Join Date: Mar 2012
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

Sorry, forgot to include that. I am using Centos 6.2 64bit. I installed everything based on 'The Perfect Server' tutorial using Apache 2.

As for errors in the log, none. Only reason I figured out there was a problem was when it stopped creating databases. I noticed it showed a database that I created, however; neither mysql nor phpmyadmin showed the database. Not long after that, I starting getting this when trying to log-in to mysql;

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Like I said in my first post, I ended up having to use shut off the grant tables in order to fix whatever occurred. The only reason I know it has something to do with ISPC3 is the fact that this will occur if I try to create another database. It has happened 3 times now before I realized ISPC3 was causing this issue.

Hopefully you will know what the issue might be. I know there being no error messages is going to make it hard to track down the issue, however; here's hoping.

P.S. The only message ISPC3 was giving me was that it couldn't connect to database. Also, the only thing I did was remove the prefix for both database and database user. Being the only one using this, I see no use for it. Also, I set root as the database user. I have tried to stop this from happening by putting everything back to the way it was, but that isn't fixing it.

Also, I was having other issues where, when I originally set all of this up, I set my domain up through a client. After a few days, everything (including 2 domains) all turned into SSL default and would not show the actual website, but the Apache 2 Installed page. I ended up deleting all sites and the client in order to fix this. I then set the domain up for the admin itself.

Perhaps this information can help with tracking down the issue as well.

EDIT: Also, this occurs even with a different db user being added. I attempted it using both dbname: test & dbuser: test (also dbname: c0test & dbuser: c0test) and the issue still occurs.

EDIT #2: Ok, after further testing and searching, I find out that some how, root@localhost had lost all Grant permissions. This is weird because I don't mess with the 'mysql' database or any of the other two. Some how or another, ISPC3 deleted the Grant permissions. I ended up restoring those permissions and ISPC3 is able to create databases and users once again, without messing up the system.

Last edited by diago; 9th April 2012 at 07:34. Reason: adding possible cause
Reply With Quote
Reply

Bookmarks

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
Need help with ISPConfig Mail and Squirrelmail m.xander Installation/Configuration 109 3rd February 2012 01:15
zarafa mysql related ashish@# HOWTO-Related Questions 1 11th February 2011 14:52
Problem updating (MySQL issue) Youko Installation/Configuration 3 24th December 2010 16:09
Mail Server Setup With Exim, MySQL, Cyrus-Imapd, Horde Webmail On Centos 5.1 - issue c0mrade HOWTO-Related Questions 25 19th April 2009 19:11
ISPConfig Mysql root password issue ?? Stuck at install Randall Hoffman Installation/Configuration 1 16th January 2007 21:53


All times are GMT +2. The time now is 14:57.


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