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.

Error in mySQL stats on cPanel

Discussion in 'General Discussion' started by LuxSpaces, Sep 16, 2009.

  1. LuxSpaces

    LuxSpaces Registered

    Joined:
    Sep 16, 2009
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    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.

    [​IMG]

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


    [​IMG]

    how i can fix this?

    here my phpinfo if needed

    Code:
    http://rootzone.net/inf.php
    Thx in advanced
     
    #1 LuxSpaces, Sep 16, 2009
    Last edited: Sep 16, 2009
  2. MattCurry

    MattCurry Well-Known Member

    Joined:
    Aug 18, 2009
    Messages:
    275
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Houston, Tx
    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. LuxSpaces

    LuxSpaces Registered

    Joined:
    Sep 16, 2009
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    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
     
Loading...

Share This Page