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.

apache & mySQL trouble. Need help bad!

Discussion in 'EasyApache' started by jsonline2k3, Jul 30, 2003.

  1. jsonline2k3

    jsonline2k3 Member

    Joined:
    Jul 30, 2003
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    I was running MySQL 4 and was having problems importing databases I need that were created in MySQL 3 so I downgraded back to MySQL 3 and now I get this mySQL error:



    I have been reading that when I go back to mySQL 3 I have to recompile Apache, so I am not fully sure on how to do that but I am guessing in WMH I go to "Update Apache", when I do this I get this message:



    If I go to use /scripts/easyapache VIA ssh I get this:



    I really need to get this worked out, anyone please help! I am very sorry if this is easy and I am a dumb a$$ for not knowing but I will be the first to admit I am 100% newbie to all of this and hoping over time of visiting here and so on I can learn it well.

    cPanel.net Support Ticket Number:
     
  2. jsonline2k3

    jsonline2k3 Member

    Joined:
    Jul 30, 2003
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    bump. please help!

    cPanel.net Support Ticket Number:
     
  3. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    If there is trouble, it will find me
    Does tmp/mysql.sock exist? I don't think you have to recompile apache. The cpanel php install defaults to mysql3 anyway.

    Sometimes layer1.cpanel.net is down, so that may be why you can't connect. First check to see if mysql.sock is in your /tmp directory. If not, type:
    locate mysql.sock
    to find where it is. Then copy it into your /tmp directory and restart mysql. See if that fixes it.

    cPanel.net Support Ticket Number:
     
  4. jsonline2k3

    jsonline2k3 Member

    Joined:
    Jul 30, 2003
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    here is what I get now:

    mysql has failed, please contact the sysadmin (result was "/usr/bin/mysqlshow: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (40)"). Jul 29 21:05:17 server1 mysql: Killing mysqld with pid 21889 Jul 29 21:05:18 server1 rc: Stopping mysql: succeeded
     
    #4 jsonline2k3, Jul 31, 2003
    Last edited: Jul 31, 2003
  5. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    If there is trouble, it will find me
    What are the contents of mysql.sock?

    cPanel.net Support Ticket Number:
     
  6. jsonline2k3

    jsonline2k3 Member

    Joined:
    Jul 30, 2003
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    i went to the directory and did pico, it appears to be empty. Nothing in it that I can see

    cPanel.net Support Ticket Number:
     
  7. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    If there is trouble, it will find me
    You're right. It is empty....

    Hmm. Well, my only suggestion now would be to upgrade cpanel to the latest edge build and see what happens. Go to your WHM and change the update preferences to bleeding edge and then do upcp.

    cPanel.net Support Ticket Number:
     
  8. jsonline2k3

    jsonline2k3 Member

    Joined:
    Jul 30, 2003
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    now I get:

    PHP version file is up to date
    Doing a manual update...
    Bad arg length for Socket::pack_sockaddr_in, length is 0, should be 4 at /usr/li
    b/perl5/5.8.0/i386-linux-thread-multi/Socket.pm line 373.

    cPanel.net Support Ticket Number:
     
  9. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    If there is trouble, it will find me
    Did you manually upgrade perl? You're supposed to have 5.6 not 5.8. Or are you on RedHat9? Upgrading perl breaks cPanel, I have heard.

    cPanel.net Support Ticket Number:
     
  10. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    If there is trouble, it will find me
  11. shaun

    shaun Well-Known Member

    Joined:
    Nov 9, 2001
    Messages:
    698
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    San Clemente, Ca
    rm -f /tmp/mysql.sock
    rm -f /var/tmp/mysql.sock
    /etc/init.d/mysql stop
    rm -f /var/lib/mysql/mysql.sock
    /etc/init.d/mysql start
    ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
    ln -s /var/lib/mysql/mysql.sock /var/tmp/mysql.sock

    cPanel.net Support Ticket Number:
     
  12. jsonline2k3

    jsonline2k3 Member

    Joined:
    Jul 30, 2003
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    I dont know what went wrong now but the server wont reboot, it is stuck offline (i think it got messed up) now to try and contact the great people at server beach! ack!

    I loved cPanel back in my shared hosting days, now that I have to run it I am becoming not to fond of it. I think I will be going back to Plesk 6

    cPanel.net Support Ticket Number:
     
  13. Solokron

    Solokron Well-Known Member

    Joined:
    Aug 8, 2003
    Messages:
    849
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Seattle
    cPanel Access Level:
    DataCenter Provider
    Perfect! Thanks Shaun.

     
  14. AnthonyR

    AnthonyR Active Member

    Joined:
    Oct 28, 2003
    Messages:
    38
    Likes Received:
    0
    Trophy Points:
    6
    Thanks for this Shaun.
     
Loading...

Share This Page