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!

Urgent - mysql socket errors.. - tried previous posts but to no avail

Discussion in 'General Discussion' started by SupermanInNY, Sep 24, 2005.

  1. SupermanInNY

    SupermanInNY Well-Known Member

    Joined:
    Jul 19, 2003
    Messages:
    255
    Likes Received:
    0
    Trophy Points:
    166
    Urgent - mysql socket errors.. - [RESOLEVED]

    [THE ISSUE IS RESOLVED]

    [RESOLVED - READ BELOW HOW I DID IT].


    ERROR 2002: Can't connect to local MySQL server through socket


    myserver.com:/var/lib/mysql => mysql
    ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)


    From the log file:
    myserver.com:/var/lib/mysql => less myserver.com.err


    050924 15:37:03 mysqld started
    050924 15:37:03 Warning: Asked for 196608 thread stack, but got 126976
    050924 15:37:03 InnoDB: Started
    050924 15:37:03 /usr/sbin/mysqld: Can't open file: 'host.MYI'. (errno: 142)
    050924 15:37:03 Fatal error: Can't open privilege tables: File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
    050924 15:37:03 Aborting

    050924 15:37:03 InnoDB: Starting shutdown...
    050924 15:37:06 InnoDB: Shutdown completed
    050924 15:37:06 /usr/sbin/mysqld: Shutdown Complete

    050924 15:37:06 mysqld ended



    my.cnf file:


    myserver.com:/etc => less my.cnf
    [mysqld]

    socket=/var/lib/mysql/mysql.sock
    set-variable = max_connections=650
    safe-show-database

    set-variable = long_query_time=2
    log-long-format

    key_buffer = 384M
    max_allowed_packet = 1M

    table_cache = 512


    sort_buffer_size = 2M
    read_buffer_size = 2M
    myisam_sort_buffer_size = 64M
    thread_cache = 8

    query_cache_size= 32M
    thread_concurrency = 4


    I've already done the
    /scripts/mysqlup --force

    but got the same error.


    Please help.

    -Alon.


    [UPDATE]


    THE ISSUE HAS BEEN RESOLVED.
    HOW???

    My sys admin guru did the following:

    ---------------------------------------------------------------------
    I tried checking the database file with myisamchk:
    myisamchk /var/lib/mysql/mysql/host.MYI


    The error message said that mysql's programs can't find charset number 83. So I added one to /usr/share/mysql/charset/Index
    ---------------------------------------------------------------------

    And.. the issue was resolved!

    Thanks,

    -Alon.
     
    #1 SupermanInNY, Sep 24, 2005
    Last edited: Sep 24, 2005
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