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.

Problem connecting to database

Discussion in 'Database Discussions' started by JBloggs, Feb 8, 2013.

  1. JBloggs

    JBloggs Registered

    Joined:
    Feb 7, 2013
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi,

    I'm fairly new to WHM/cPanel although I've used it a little in the past.

    I'm simply trying to install Wordpress (which I've done many times) on a number of sites but I keep on getting an error message each time. I cannot connect to the database wether I create it in cPanel or in phpMyAdmin.

    I managed to get around it by connecting via shell and using the default username but that's not ideal. If I try and install WP via SFTP when I'm connecting as root it's a no go.

    I think it could be a permissions problem for the root user but I'm not sure.

    This is the error message:

    [Fri Feb 08 19:05:35 2013] [error] [client MYIPADDRESS] File does not exist: /home/MYWEBSITE/public_html/404.shtml
    [Fri Feb 08 19:05:35 2013] [error] [client MYIPADDRESS] File does not exist: /home/MYWEBSITE/public_html/favicon.ico
    [Fri Feb 08 19:05:35 2013] [error] [client MYIPADDRESS] File does not exist: /home/MYWEBSITE/public_html/500.shtml
    [Fri Feb 08 19:05:35 2013] [error] [client MYIPADDRESS] SoftException in Application.cpp:357: UID of script "/home/wwwvns/public_html/wp-admin/install.php" is smaller than min_uid


    I've checked the user minimum ID value and it's the default 500 so I don't think that's the problem.

    Any help would be appreciated.

    Thanks,

    JB
     
  2. quietFinn

    quietFinn Well-Known Member

    Joined:
    Feb 4, 2006
    Messages:
    998
    Likes Received:
    10
    Trophy Points:
    18
    Location:
    Finland
    cPanel Access Level:
    Root Administrator
    That is the problem.
    Seems you are trying to install it as root, and that is not going to work.
     
  3. JBloggs

    JBloggs Registered

    Joined:
    Feb 7, 2013
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Thanks for replying.

    The odd thing is I have an identical server where I can install through root and the Min ID value is exactly the same as the new server.
     
  4. JBloggs

    JBloggs Registered

    Joined:
    Feb 7, 2013
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Help Please! Permissions Problem

    Hi,

    I'm fairly new to WHM/cPanel although I've used it a little in the past.

    I'm simply trying to install Wordpress (which I've done many times) on a number of sites but I keep on getting an error message each time. I cannot connect to the database wether I create it in cPanel or in phpMyAdmin.

    I managed to get around it by connecting via shell and using the default username but that's not ideal. If I try and install WP via SFTP when I'm connecting as root it's a no go.

    I think it could be a permissions problem for the root user but I'm not sure.

    This is the error message:

    [Fri Feb 08 19:05:35 2013] [error] [client MYIPADDRESS] File does not exist: /home/MYWEBSITE/public_html/404.shtml
    [Fri Feb 08 19:05:35 2013] [error] [client MYIPADDRESS] File does not exist: /home/MYWEBSITE/public_html/favicon.ico
    [Fri Feb 08 19:05:35 2013] [error] [client MYIPADDRESS] File does not exist: /home/MYWEBSITE/public_html/500.shtml
    [Fri Feb 08 19:05:35 2013] [error] [client MYIPADDRESS] SoftException in Application.cpp:357: UID of script "/home/wwwvns/public_html/wp-admin/install.php" is smaller than min_uid


    I've checked the user minimum ID value and it's the default 500 so I don't think that's the problem, and I've increased it and still had the problem.

    Any help would be appreciated.

    Thanks,

    JB
     
  5. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,474
    Likes Received:
    202
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    There is no need to start a second thread on the same topic.

    What is the error message you get when trying to create a new Database in cPanel?

    The first 3 errors in your posts can be fixed easy enough, add your error pages and favicon to the account in the public_html directory.

    More on error pages here:

    Error Pages - cPanel Documentation
     
  6. JBloggs

    JBloggs Registered

    Joined:
    Feb 7, 2013
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Thanks for replying. I moved the question as I'm new to the forum and it looked like I would get more helpful answers in the other location.

    I posted the full error message as I thought it would be useful, obviously the problem isn't a favicon! The problem is I cannot connect to a database that is created by the root user. There are no problems at all when I connect as the account user.

    I have access to an identical server where I can connect as the root and do not have such problems. Perhaps what I'm encountering is normal out-of-the-box but it doesn't suit my needs.

    There are no errors creating databases in cPanel or command line with either root access or account user access. The problem is connecting to that database.

    - I have tried amending the min. ID value which didn't work.

    - I have tried amending permissions with chown-R mywebsite:mywebsite /home/mywebsite/public_html which didn't work either.

    If anyone could throw some light on this it would be appreciated.

    Thanks.

    JB
     
  7. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,474
    Likes Received:
    202
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    What are those needs, exactly? Lets start there. :)
     
Loading...

Share This Page