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.

Read-only & MySQL Failed

Discussion in 'General Discussion' started by ccreighton, Dec 24, 2003.

  1. ccreighton

    ccreighton Active Member

    Joined:
    Aug 28, 2001
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    Hello,

    Merry Christmas to all!

    My server is acting up...

    MySQL is presenting the following error:
    "Warning: mysql_pconnect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)"

    Then when I attempted to apply fixes shown in the forums I ran into this problem: "Read-only file system"

    I don't know if one caused the other. Your help is appreciated.
     
  2. jphilipson

    jphilipson Well-Known Member

    Joined:
    Jan 8, 2003
    Messages:
    80
    Likes Received:
    0
    Trophy Points:
    6
    Sounds like you were owned,start over with a clean drive... then resore your data from the old
     
  3. HSAdam

    HSAdam Member

    Joined:
    Jan 3, 2003
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    1
    That's totally not true, and a very stupid response.. you should get off these boards.
     
  4. jphilipson

    jphilipson Well-Known Member

    Joined:
    Jan 8, 2003
    Messages:
    80
    Likes Received:
    0
    Trophy Points:
    6
    Well it does sound like he is owned.. while there are other ways to solve that problem, I do not think most dcs will allow it.. it is in the dcs best interest to make the server leasee get a fresh drive.. and if he was owned its easy enough to restore from the old drive, and its much safer than tring to clean up an owned server
     
  5. Donna

    Donna BANNED

    Joined:
    Feb 15, 2003
    Messages:
    88
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Toronto, Canada
    assuming he was owned and somehow something didn't get mounted right (I've had that happen, and done by a DC tech no less).

    First he needs to investigate a little, try a reboot, reset the mySQL root pass etc, check tmp and /var/tmp for odd things as well as running chkrootkit and so on and so forth.

    Also, did he run the new securetmp script nick made, I have a mysql problem similar to this guys on one server when I use that script and have to disable it to keep it working.

    Assuming he was owned right off the bat with no real information provided by the original poster is getting a little ahead of things. If apache fails should you reinstall too? Or maybe take a look at things first and see if you can get it going again?
     
  6. denisdekat09

    denisdekat09 Well-Known Member

    Joined:
    Mar 2, 2002
    Messages:
    265
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    San Francisco
    How do you disable this script (securetmp)? I am going batty, I took it out of the cron job thinking that would do it but mysql is dead :(

    I should add that the server had no tmp partition as it was an older one, I hope this is reversible....



    cPanel.net Support Ticket Number: 34570
     
    #6 denisdekat09, Jan 7, 2004
    Last edited: Jan 7, 2004
  7. denisdekat09

    denisdekat09 Well-Known Member

    Joined:
    Mar 2, 2002
    Messages:
    265
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    San Francisco
    BTW, I fixed the mysql problem by rerunning /scripts/securetmp I think the fact that this server had no /tmp partition to begin with may have made it more difficult to remove.
     
  8. denisdekat09

    denisdekat09 Well-Known Member

    Joined:
    Mar 2, 2002
    Messages:
    265
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    San Francisco
    Ok, I fixed my woes, it was all my own mishaps and advetures...

    Sorry for the noise :)
     
  9. guinea812

    guinea812 Member

    Joined:
    Sep 27, 2003
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    hey-I have the same problem, how did you fix it? It killed sql and it won't allow it to work, please help. I also had no /tmp partition, please help!
     
  10. denisdekat09

    denisdekat09 Well-Known Member

    Joined:
    Mar 2, 2002
    Messages:
    265
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    San Francisco
Loading...

Share This Page