Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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:
    156
    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:
    156
    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:
    156
    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:
    343
    same problem here .... Darkorb ?!?!?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. itrends

    itrends Well-Known Member

    Joined:
    Oct 21, 2004
    Messages:
    50
    Likes Received:
    0
    Trophy Points:
    156
    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,460
    Likes Received:
    21
    Trophy Points:
    463
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. easyhoster1

    easyhoster1 Well-Known Member

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

    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:
    166
    ticket submitted.... :(
     
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice