Professional Web Applications Themes

replacing missing mysql.sock (FreeBSD OS) - MySQL

Don't you hate it when you have a missing sock? I'm hoping there's someone (anyone!) who knows FreeBSD who can advise me how to recreate the MySql socket file in its default location (in my case, in /tmp/mysql.sock). Seems my /var partition got over-full last night and evidently brought down the server. I guess that was the cause; I can't see any other. Since last night, I haven't been able to restart MySql. This effects of my sites, since most of my content now runs on Drupal, which requires MySql. One of the things that I did today was move ...

  1. #1

    Default replacing missing mysql.sock (FreeBSD OS)

    Don't you hate it when you have a missing sock?

    I'm hoping there's someone (anyone!) who knows FreeBSD who can advise
    me how to recreate the MySql socket file in its default location (in
    my case, in /tmp/mysql.sock). Seems my /var partition got over-full
    last night and evidently brought down the server. I guess that was the
    cause; I can't see any other.

    Since last night, I haven't been able to restart MySql. This effects
    of my sites, since most of my content now runs on Drupal, which
    requires MySql. One of the things that I did today was move MySql data
    files to my /usr partition, where there's more room, with a sym link
    to its default location at /var/db/mysql; careful to chown the
    directory and files to the user mysql. I also tried deinstalling and
    then reinstalling MySql from ports, hoping that would resurrect the
    socket, but no go. I've googled and scoured the mysql.com, to no
    avail. If there is an answer out there (and there undoubtedly is, I
    haven't been able to find it.)

    Any suggestions would be sincerely appreciated. I know there are a lot
    of a number of subscribers here who are more expert than me with
    MySql.

    I'd really like to get this thing back ASAP, if possible, not just for
    my own site, but also for the benefit of the people and organizations
    who relying on me as a host.

    Many thanks.

    Tom

    P.S. For the record, I'm running a mixture of Drupal sites; some
    v4.7.x and others v5.x. OS is FreeBSD 6.1 on Apache 1.3.24, PHP 5.1.2
    mod_perl/1.29, MySql 5.0.18, with Gallery 2.1, TNG 6.1, and PmWiki
    2.0.13.

    tomrue Guest

  2. #2

    Default Re: replacing missing mysql.sock (FreeBSD OS)

    tomrue wrote:
     


    touch /tmp/mysql.sock

    Will suffice.

    Make sure mysql has permission to enter /tmp and read/write to mysql.sock


    --
    Brian Wakem
    Email: http://homepage.ntlworld.com/b.wakem/myemail.png
    Brian Guest

  3. #3

    Default Re: replacing missing mysql.sock (FreeBSD OS)

    Brian

    Thanks for the reply.

    I tried your suggestion, even chmod 777 mysql.sock. Still no go. I'm
    starting to think it has something to do with some log files that may
    have been damaged by the disk overflow last night.

    I'll keep poking.

    Any other suggestions most welcome.

    Thanks again.


    --
    http://tomrue.net




    On Apr 21, 5:29 pm, Brian Wakem <com> wrote: 
    >
    > touch /tmp/mysql.sock
    >
    > Will suffice.
    >
    > Make sure mysql has permission to enter /tmp and read/write to mysql.sock
    >
    > --
    > Brian Wakem
    > Email:http://homepage.ntlworld.com/b.wakem/myemail.png[/ref]


    tomrue Guest

  4. #4

    Default Re: replacing missing mysql.sock (FreeBSD OS)

    >Don't you hate it when you have a missing sock? 

    My observation is that when you shut down the server process, the
    socket goes away, and when you start it up again, it comes back.
    I'm running FreeBSD 6 now, but I've been running FreeBSD and MySQL
    for a long time and this hasn't changed recently. Now, if the
    server fails to start for some reason, like passing it bogus
    command-line options which I've done a few times, it will quit and
    not create the socket.

    Check permissions on /tmp and /var/db/mysql to make sure the server
    won't have problems trying to create the socket or log files.
    Also make sure there's a decent amount of disk space.
     

    You need to be really careful about permissions and ownership here,
    as you've noted.
     
    Gordon Guest

Similar Threads

  1. Where should I put the mysql.sock ?
    By howachen@gmail.com in forum MySQL
    Replies: 2
    Last Post: August 18th, 04:30 PM
  2. Replies: 0
    Last Post: January 29th, 02:03 PM
  3. Replies: 7
    Last Post: June 12th, 07:43 AM
  4. Replies: 1
    Last Post: January 27th, 02:49 AM
  5. Replies: 0
    Last Post: January 24th, 10:55 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139