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 install problems.

Discussion in 'General Discussion' started by AidanF, Dec 10, 2006.

  1. AidanF

    AidanF Registered

    Joined:
    Oct 8, 2006
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    ok i have CPanel installed on my dedicated server, No matter what i do i cant install MySQL. I get the following erorr:
    /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! mysql has failed, please contact the sysadmin (result was "Warning, no valid mysql.sock file found.mysql has failed").
    Now i know that you need to set the dir inside my.cnf but i cant seem to find MySQl.sock even when i type in locate MySQL.sock it doesnt seem to have any MySQl.sock file. i was wondeing if i have to create the file myself and edit it with certain information. If you have any ideas on what my problem may be please post a reply.
    Os = Linux, Fedora 6
    Email = fewstera[replace this with a @ sign just stopping spam]hotmail.com
    Thanx in advanced,
    Aidan (If you have MSN please could you add me)
     
    #1 AidanF, Dec 10, 2006
    Last edited: Dec 10, 2006
  2. jayh38

    jayh38 Well-Known Member

    Joined:
    Mar 3, 2006
    Messages:
    1,215
    Likes Received:
    0
    Trophy Points:
    36
    Try running the following commands to create the sock and
    then link it to your temp. That should get you going.

    cd /var/lib/mysql
    touch mysql.sock
    chown mysql:mysql mysql.sock
    chmod 1777 mysql.sock
    ln -s /var/lib/mysql/mysql.sock /tmp
    chmod 1777 /tmp
    /scripts/mysqlup --force
    /etc/rc.d/init.d/mysql restart
     
  3. AidanF

    AidanF Registered

    Joined:
    Oct 8, 2006
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Thanx alot im just running it now. I gotta reinstall HTTP, APache and PHP now because i uninstalled them all because i was gong to install LAMP. But this seems to be working atm it says:
    Preparing... ########################################### [100%]
    1:MySQL-shared ########################################### [100%]
    Preparing... ########################################### [100%]
    1:MySQL-devel ########################################### [100%]
    Preparing... ########################################### [100%]
    1:MySQL-client ########################################### [100%]
    Preparing... ########################################### [100%]
    1:MySQL-bench ########################################### [100%]
    So i think it working
    Thanx again,
    Aidan
     
  4. AidanF

    AidanF Registered

    Joined:
    Oct 8, 2006
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Now i get:

    /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! mysql has failed, please contact the sysadmin (result was "mysql has failed").
     
  5. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,461
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    Are you using i386 or x86-64 version of Fedora Core 6?

    We don't distribute RPMs of MySQL, so if you are using /scripts/mysqlup it will be trying to build the RPMs from source. Try executing
    Code:
    /scripts/mysqlup --force --verbose --source
    
    It's possible you are lacking a library or something that is needed during compiling.

    If you are simply doing yum install mysql-server then it's obviously not anything related to the above and might need researched on Fedoras Forums/mailing lists.
     
  6. katmai

    katmai Well-Known Member

    Joined:
    Mar 13, 2006
    Messages:
    526
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Brno, Czech Republic
    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    skip-locking
    skip-innodb
    query_cache_limit=1M
    query_cache_size=32M
    query_cache_type=1
    max_user_connections=500
    max_connections=1000
    interactive_timeout=10
    wait_timeout=30
    connect_timeout=10
    thread_cache_size=96
    key_buffer=32M
    join_buffer=1M
    max_allowed_packet=8M
    table_cache=1024
    record_buffer=1M
    sort_buffer_size=1024K
    read_buffer_size=1024K
    max_connect_errors=10
    thread_concurrency=8
    myisam_sort_buffer_size=64M
    server-id=1
    log-slow-queries
    long_query_time = 5

    [mysql.server]
    user=mysql

    [safe_mysqld]
    err-log=/var/log/mysqld.log
    pid-file=/var/lib/mysql/mysql.pid
    open_files_limit=8192

    [mysqldump]
    quick
    max_allowed_packet=16M

    [mysql]
    no-auto-rehash

    [isamchk]
    key_buffer=64M
    sort_buffer=64M
    read_buffer=16M
    write_buffer=16M

    [myisamchk]
    key_buffer=64M
    sort_buffer=64M
    read_buffer=16M
    write_buffer=16M

    [mysqlhotcopy]
    interactive-timeout

    here is my.cnf. try replacing /etc/my.cnf with this, and then restarting mysql.
     
  7. k1k

    k1k Active Member

    Joined:
    Mar 24, 2006
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    Mysql issues

    The easiest procedure:

    su mysql

    When you are logged as "mysql" user you could try to strart the service manually:

    "mysqld"

    If there are any issues with your configuration then you will see the exact error.
     
  8. jayh38

    jayh38 Well-Known Member

    Joined:
    Mar 3, 2006
    Messages:
    1,215
    Likes Received:
    0
    Trophy Points:
    36
    I was asked to look at the box so here is a followup for those interested.

    After creating the mysql.sock and forced update, MySql started fine.
    Root was unable to connect at all. I tried every type of reset
    procedure and password change via ssh and whm with no luck.

    The privileges table seemingly accepted the new passwords but also seemed
    to corrupt it as well. With no way to run utilities on it, I decided to delete the
    the priv data. This rebuilt fine after another forced update.

    I then recompiled apache and updated cPanel.

    This was a fedora 6 686 box
     
  9. AidanF

    AidanF Registered

    Joined:
    Oct 8, 2006
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Jayh helped me alot :) Thank you VERY much again.
     
Loading...

Share This Page