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.

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:
    16
    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