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.

MySQL refuses access to everything...

Discussion in 'General Discussion' started by ontheweb, Apr 8, 2011.

  1. ontheweb

    ontheweb Registered

    Joined:
    Apr 8, 2011
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    I ran and upgrade from 5.0 to 5.1 using the cPanel upgrade manager (for MySQL) and ever since then nothign has been able to make connections to MySQL, but there is a twist.

    Things that already have a connection (for example, my forum and blog work because they were around before the upgrade) but anything added after the upgrade (including new accounts and even a new root account I created) doesn't work.

    I've spent the best part of 2 days trying to find a way to fix it but am getting nowhere, please help!
     
  2. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Please open up a ticket about this issue as it will be difficult to troubleshoot via the forum for a MySQL issue such as this. Please do confirm if you can access MySQL directly from command line:

    Code:
    mysql
    Also, does "mysqladmin proc" return any information or error? Next, you might want to check the error logs when trying to connect to a database for the MySQL logs at /var/lib/mysql/hostname.err where hostname is the fully qualified hostname for the machine.
     
  3. ontheweb

    ontheweb Registered

    Joined:
    Apr 8, 2011
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    I can access mysql using mysql, mysqladmin proc returns:

    +----+------+-----------+----+---------+------+-------+------------------+
    | Id | User | Host | db | Command | Time | State | Info |
    +----+------+-----------+----+---------+------+-------+------------------+
    | 18 | root | localhost | | Query | 0 | | show processlist |
    +----+------+-----------+----+---------+------+-------+------------------+


    and there are no errors in that file!
    I'll create a ticket now, thanks for the reply.
     
  4. danissch

    danissch Registered

    Joined:
    Apr 26, 2011
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    sorry I put this post in another thread before, but really im not sure, because I have many throubles...

    I have this in my email every hour:

    install_driver(mysql) failed: Can't load '/usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib64/libmysqlclient.so.15: version `libmysqlclient_15' not found (required by /usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/DBD/mysql/mysql.so) at /usr/local/lib/perl5/5.8.8/x86_64-linux/XSLoader.pm line 70.
    at /usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/DBD/mysql.pm line 14
    Compilation failed in require at (eval 4) line 3.
    Perhaps a required shared library or dll isn't installed where expected
    at /etc/cron.hourly/modsecparse.pl line 19

    I dont know what to do!!, the database connectios are crashing (some accounts, after update MySql and others system updates), the mod security Plugin not work, cPHulk Brute Force Protection dont display settings in Whm and says "Error while connecting to MySQL."

    I did everything that indicates these posts

    http://forums.cpanel.net/f5/problem-mod-sec-cron-job-193281.html

    http://forums.cpanel.net/f5/mod-security-plugin-after-11-25-upgrade-143361.html

    http://forums.cpanel.net/f5/problem-mod-sec-cron-job-193281.html#post794882

    http://forums.cpanel.net/f5/upgraded-mysql-v5-1-30-a-100741-p3.html

    I have 5 days trying to solved it and nothing is going right.

    Please Help!!!
     
  5. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Hello,

    Please try the following:

    Code:
    /scripts/mysqlup --force
    /scripts/perlinstaller --force DBD::mysql
    Also, what is sending the email? Is it /etc/cron.hourly/modsecparse.pl that sends an hourly cron email?

    If the above does not completely correct the issue, please let us know and please clarify what is sending the email out to you. You may also want to consider a ticket if the above does not fix what is happening due to the emergency status of the issue. You can open up a ticket if you have root SSH and root WHM access to the machine by using WHM > Support Center > Contact cPanel or via the link in my signature.

    Thank you
     
  6. diegoalberto.me

    diegoalberto.me Registered

    Joined:
    Sep 3, 2009
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Tried this, didn't worked for me. Did you solved it? thanks
     
  7. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Are you having the same error that the prior user mentioned? This error:

    If you are not having that exact error, then the commands noted wouldn't be the way to resolve whatever issue you are having. Please provide more details on what is happening on your machine, or please submit a ticket as I requested on my last reply if you are having the same exact error and those commands did not fix it.
     
Loading...

Share This Page