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.

Mysql commandline not working

Discussion in 'General Discussion' started by itrends, May 8, 2005.

  1. itrends

    itrends Well-Known Member

    Joined:
    Oct 21, 2004
    Messages:
    50
    Likes Received:
    0
    Trophy Points:
    6
    Very weird problem here..

    when a webpage try's to access mysql it uses '/var/tmp/mysql.sock' (as i want) and works fine. But when eximstats (or a user on shell) tries to use it it wants a '/tmp/mysql.sock' (wich DOES exist) and mysql just wont work.

    Now every 10 minutes eximstats and mysql both fail.. i hate the emails, can't find ANYthing wrong? Didn't change anything.

    --
    Using:
    root@bt2:/var/log# uname -a
    FreeBSD bt2.xxx.nl 5.4-PRERELEASE FreeBSD 5.4-PRERELEASE #0: Wed Mar 16 18:24:13 CET 2005 root@bt2.xxx.nl:/usr/obj/usr/src/sys/BONTEKOE i386
    root@bt2:/var/log#


    update
    Found something:
    root@bt2:/tmp# df
    I have never seen a /var/tmp partition before, no idea how that got there? It's not even in the FSTAB!
     
    #1 itrends, May 8, 2005
    Last edited: May 8, 2005
  2. itrends

    itrends Well-Known Member

    Joined:
    Oct 21, 2004
    Messages:
    50
    Likes Received:
    0
    Trophy Points:
    6
    Anybody?

    I need an sollution pretty bad :eek:
     
  3. itrends

    itrends Well-Known Member

    Joined:
    Oct 21, 2004
    Messages:
    50
    Likes Received:
    0
    Trophy Points:
    6
    OK, seems that cpanel creates a 'nullfs' partition in the swapspace.. Just wondering why nobody of the cpanel team could have just told me so.

    Now the only problem, it's not identical! mysql.sock files in /tmp and /var/tmp don't match, so mysql won't work.
     
  4. Radio_Head

    Radio_Head Well-Known Member

    Joined:
    Feb 15, 2002
    Messages:
    2,051
    Likes Received:
    1
    Trophy Points:
    38
    same problem here .... Darkorb ?!?!?
     
  5. itrends

    itrends Well-Known Member

    Joined:
    Oct 21, 2004
    Messages:
    50
    Likes Received:
    0
    Trophy Points:
    6
    Yea.. cpanel supprt rox.. great!

    I got somebody to help me out, at 75 € an hour. Just UNCOMMENT the 'nullfs' part in the securetmp script that cpanel provides.
     
  6. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,475
    Likes Received:
    20
    Trophy Points:
    38
    Location:
    Go on, have a guess
    These forums are not the place to get support from cPanel. Posying here is simply asking other server admins who come here in their spare time if they can help. If you want cPanel help then you have to log a support ticket with cPanel or through your cPanel license provider.
     
  7. easyhoster1

    easyhoster1 Well-Known Member

    Joined:
    Sep 25, 2003
    Messages:
    659
    Likes Received:
    0
    Trophy Points:
    16

    Well...I have a machine now with the exact some problem...Cant find anywhere in /scripts/securetmp "nullfs"...Do you know what line its at??
     
  8. easyhoster1

    easyhoster1 Well-Known Member

    Joined:
    Sep 25, 2003
    Messages:
    659
    Likes Received:
    0
    Trophy Points:
    16
    ticket submitted.... :(
     
Loading...

Share This Page