Results 1 to 3 of 3

Thread: Error in mySQL stats on cPanel

  1. #1
    Registered User
    Join Date
    Sep 2009
    Posts
    2

    Default Error in mySQL stats on cPanel

    Everytime i create a new account from whm ( i login whm as root user ) on client's cpanel there's always show that already 1 mysql database exist on cpanel stats.



    But in mysql panel itself shown there's no mysql database exist




    how i can fix this?

    here my phpinfo if needed

    Code:
    http://rootzone.net/inf.php
    Thx in advanced
    Last edited by LuxSpaces; 09-16-2009 at 01:16 PM.

  2. #2
    Member
    Join Date
    Aug 2009
    Location
    Houston, Tx
    Posts
    275

    Post

    Hello,

    This can be caused by a couple of things, but I need a little more info before I could say for sure. First, have you isntalled postgres or mysql or both? The reason I ask is with postgres it will show 1 when there are zero if the install wasn't completed. So you can either finish the install or remove the binary from the machine. Second, you can check that and you can also check /home/USER/.cpanel/datastore/
    There will be two files there:
    mysql-db-count
    postgres-db-count
    The cpanel install takes the number in these files and adds them together. This will be the number that you see on the page (1 database). So you can correct it there as well.

    Please let me know if this resolves your issue, if you additional questions feel free to ask.

    Thank you,
    Matthew Curry

  3. #3
    Registered User
    Join Date
    Sep 2009
    Posts
    2

    Default

    problem is resolved

    trully it's on the postgresql installation, i've reinstall postgresql and my problem is solved


    thx so much sir for your help

Similar Threads

  1. Cpanel stats showing not a reference error
    By B12Org in forum cPanel & WHM Discussions
    Replies: 6
    Last Post: 09-02-2010, 11:07 AM
  2. cPanel Stats Menu Error
    By mikelegg in forum cPanel & WHM Discussions
    Replies: 6
    Last Post: 03-29-2010, 03:20 PM
  3. Emptying Cpanel Error Stats
    By bls24 in forum New User Questions
    Replies: 1
    Last Post: 05-19-2007, 12:36 AM
  4. MySQL stats not showing in Cpanel after 10.9.0-C4 update
    By rikgarner in forum cPanel & WHM Discussions
    Replies: 4
    Last Post: 09-23-2006, 09:03 AM