The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Massive SQL Problems

Discussion in 'Database Discussions' started by GCIS, Dec 20, 2006.

  1. GCIS

    GCIS Active Member

    Joined:
    Dec 12, 2006
    Messages:
    26
    Likes Received:
    0
    Trophy Points:
    1
    One of my cPanel boxes has begun experiencing massive SQL related problems over the past 24 hours. This problem appeared spontaneously today, and no software changes have been made on this specific system recently.

    This may or may not be related to a recent cPanel update; I have yet to see similar problems described via the support forums over the past few weeks.


    The first and by far most important problem has to do with MySQL account and database listing and creation. Accounts and databases are not displayed on any cPanel MySQL administration page. This applies to all user accounts on the machine. New users and databases cannot be created.

    Even though databases cannot be listed or created, and user accounts cannot be created, listed, or granted permissions, all existing databases still exist, and all MySQL user accounts can still access them. Furthermore, all cPanel user accounts can use phpMyAdmin, although root cannot.


    The second problem deals with MySQL root access. root cannot access phpMyAdmin, and receives an access denied error upon every attempt. Attempts to reset the root password are met with an error as follows (reproduced in entirety):
    Code:
    Mysql password change failed!!
    A forced reset will now be attempted.
    Reset MySQL Password
    
    Waiting for mysql to restart.....This script updates all the mysql privilege tables to be usable by
    MySQL 4.0 and above.
    
    This is needed if you want to use the new GRANT functions,
    CREATE AGGREGATE FUNCTION, stored procedures, or
    more secure passwords in 4.1
    
    done
    Done
    Changing Password....Done
    Reloading Mysqld...
    Done
    Waiting for mysql to terminate.....
    
    Restarting MySQL ....Starting MySQL[ OK ] Done
    
    The MySQL root password has been changed.
    Password changed for root to [ROOT PASSWORD REMOVED]
    
    
    Although the script reports a successful root password change, the root password does not change. Furthermore, neither the old nor new root passwords enable root MySQL access; MySQL reports an authentication failure upon access attempts.


    The third problem experienced related to PgSQL. Some cPanel user accounts are showing "1/NA" in the PgSQL database usage field. PgSQL is not used on this machine, and is not even running (and never has been). This problem is not important to the proper operation of the machine, but is odd enough that it certainly warrants attention from support staff, as something quite odd is happening with cPanel's internals.



    Upgrades (and forced upgrades) of cPanel in general, as well as MySQL specifically (via cpup and mysqlup) fail to remedy this problem.


    Are any of these known issues with current releases of cPanel? If this is a known issue, I'd rather take care of it now before I have to spend hours tracing it down in the system's internals.
     
  2. GCIS

    GCIS Active Member

    Joined:
    Dec 12, 2006
    Messages:
    26
    Likes Received:
    0
    Trophy Points:
    1
    Any ideas?
     
  3. equens

    equens Well-Known Member

    Joined:
    Feb 8, 2002
    Messages:
    270
    Likes Received:
    0
    Trophy Points:
    16
    MySQL root password problems

    Same problem here:


    HTML:
    Mysql password change failed!!
    A forced reset will now be attempted.
    Reset MySQL Password
    
    Waiting for mysql to restart.....This script updates all the mysql privilege tables to be usable by
    MySQL 4.0 and above.
    
    This is needed if you want to use the new GRANT functions,
    CREATE AGGREGATE FUNCTION, stored procedures, or
    more secure passwords in 4.1
    
    done
    Done
    Changing Password....Done
    Reloading Mysqld...
    Done
    Waiting for mysql to terminate.....
    
    Restarting MySQL ....Starting MySQL[ OK ] Done
    
    The MySQL root password has been changed.
    Password changed for root to xxxxxxxxxxxx
    
    HTML:
    Attempting to restart mysql  	
    Waiting for mysql to restart.... . . . . . . . . . . finished.
    
    mysql status
    /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)' mysql has failed, please contact the sysadmin (result was "mysql has failed").
    
     
  4. 2fast51

    2fast51 Registered

    Joined:
    Dec 16, 2006
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Looks like I just came up with the same problem, anyone figure anything out?
     
  5. Stefaans

    Stefaans Well-Known Member

    Joined:
    Mar 5, 2002
    Messages:
    451
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    Vancouver, Canada
    Taking a wild guess, I suggest you check for full disk partitions, in particular /var (where databases are stored) and /tmp.
     
  6. forlinuxsupport

    forlinuxsupport Well-Known Member
    PartnerNOC

    Joined:
    Dec 22, 2004
    Messages:
    386
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    force update cpanel ??
    /scripts/upcp --force

    force reinstall mysql ?
    /scripts/mysqlup --force

    :)
     
  7. oleanhst

    oleanhst Active Member

    Joined:
    Sep 25, 2004
    Messages:
    33
    Likes Received:
    0
    Trophy Points:
    6
    I am having the same issue, running the latest edge
     
  8. eNetHosts

    eNetHosts Well-Known Member

    Joined:
    Apr 21, 2007
    Messages:
    195
    Likes Received:
    0
    Trophy Points:
    16
    Sound's like an idea + restart cPanel after

    SSH line: /etc/init.d/cpanel restart
     
  9. oleanhst

    oleanhst Active Member

    Joined:
    Sep 25, 2004
    Messages:
    33
    Likes Received:
    0
    Trophy Points:
    6

    Did the above, still same issue
     
  10. eNetHosts

    eNetHosts Well-Known Member

    Joined:
    Apr 21, 2007
    Messages:
    195
    Likes Received:
    0
    Trophy Points:
    16
    Does anyone know where the file mysql.sql is located?
     
  11. callc

    callc Registered

    Joined:
    May 10, 2007
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    \mysql\scripts\mysql_fix_privilege_tables ?
     
Loading...

Share This Page