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.

cpanel won't install mysql on Virtuozzo vps? chattr: Inappropriate ioctl

Discussion in 'General Discussion' started by Jeff-C, Jan 18, 2006.

  1. Jeff-C

    Jeff-C Well-Known Member

    Joined:
    Mar 16, 2004
    Messages:
    117
    Likes Received:
    0
    Trophy Points:
    16
    When I try to install mysql (change mysql version and then run /scripts/upcp or run /scripts/mysqlup) it fails with both 4.0 and 4.1 (which I want).

    I get many errors along the lines of:
    chattr: Inappropriate ioctl for device while reading flags on /usr/include/mysql/mysql_com.h

    How do I fix this and get mysql installed?
     
  2. simplestar

    simplestar Well-Known Member

    Joined:
    Nov 15, 2005
    Messages:
    97
    Likes Received:
    0
    Trophy Points:
    6
    Chattr errors are normal on a VPS as I've come to find out. Check to be sure MySQL is not already installed.
     
  3. Jeff-C

    Jeff-C Well-Known Member

    Joined:
    Mar 16, 2004
    Messages:
    117
    Likes Received:
    0
    Trophy Points:
    16
    Do I need to forcefully uninstall mysql from cpanel's first attempts before trying mysqlup --force again? If so, could you give me some tips on how best to do this?
     
  4. Jeff-C

    Jeff-C Well-Known Member

    Joined:
    Mar 16, 2004
    Messages:
    117
    Likes Received:
    0
    Trophy Points:
    16
    OK, I'm lost. I know this is a lot to post, but here is what I get when I try to do mysqlup -- force.

    Any ideas on what I should try to get mysql 4.1 working on my VPS?

    Please :)
    Code:
    <snip>
    chattr: Inappropriate ioctl for device while reading flags on /usr/share/mysql/ukrainian
    chattr: Inappropriate ioctl for device while reading flags on /usr/share/mysql/ukrainian/errmsg.sys
    chattr: Inappropriate ioctl for device while reading flags on /usr/share/mysql/ukrainian/errmsg.txt
    warning: /var/spool/cpupdates/MySQL-server-4.1.13-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
    Preparing...                ########################################### [100%]
    Giving mysqld a couple of seconds to exit nicely
       1:MySQL-server           ########################################### [100%]
    060119 10:38:27 [Warning] Asked for 196608 thread stack, but got 126976
    060119 10:38:27 [Warning] Asked for 196608 thread stack, but got 126976
    
    <snip to fit forum>
    
    Support MySQL by buying support/licenses at https://order.mysql.com
    Starting MySQL................................... ERROR! 
    --10:39:05--  http://sunsite.cnlab-switch.ch/ftp/mirror/mysql//Downloads/MySQL-4.1/MySQL-shared-4.1.13-0.i386.rpm
               => `/var/spool/cpupdates/MySQL-shared-4.1.13-0.i386.rpm'
    Resolving sunsite.cnlab-switch.ch... 130.59.10.35, 2001:620:0:8:203:baff:fe52:38e5
    Connecting to sunsite.cnlab-switch.ch|130.59.10.35|:80... connected.
    HTTP request sent, awaiting response... 404 Not Found
    10:39:05 ERROR 404: Not Found.
    
    --10:39:05--  http://ftp.tpnet.pl/vol/d3/ftp.mysql.com//Downloads/MySQL-4.1/MySQL-shared-4.1.13-0.i386.rpm
               => `/var/spool/cpupdates/MySQL-shared-4.1.13-0.i386.rpm'
    Resolving ftp.tpnet.pl... 80.50.248.77
    Connecting to ftp.tpnet.pl|80.50.248.77|:80... connected.
    HTTP request sent, awaiting response... 200 OK
    Length: 1,212,966 (1.2M) [text/plain]
    
    100%[=================================================================================>] 1,212,966    192.14K/s    ETA 00:00
    
    10:39:15 (125.38 KB/s) - `/var/spool/cpupdates/MySQL-shared-4.1.13-0.i386.rpm' saved [1212966/1212966]
    
    warning: /var/spool/cpupdates/MySQL-shared-4.1.13-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
    MySQL-shared-4.1.13-0
    warning: /var/spool/cpupdates/MySQL-shared-4.1.13-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
    chattr: Inappropriate ioctl for device while reading flags on /usr/lib/libmysqlclient.so
    chattr: Inappropriate ioctl for device while reading flags on /usr/lib/libmysqlclient.so.14
    chattr: Inappropriate ioctl for device while reading flags on /usr/lib/libmysqlclient.so.14.0.0
    chattr: Inappropriate ioctl for device while reading flags on /usr/lib/libmysqlclient_r.so
    chattr: Inappropriate ioctl for device while reading flags on /usr/lib/libmysqlclient_r.so.14
    chattr: Inappropriate ioctl for device while reading flags on /usr/lib/libmysqlclient_r.so.14.0.0
    warning: /var/spool/cpupdates/MySQL-shared-4.1.13-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
    Preparing...                ########################################### [100%]
       1:MySQL-shared           ########################################### [100%]
    Starting MySQL................................... ERROR! 
    
    Waiting for MySQL to restart ...
    mysql     3735  0.3  0.5 32052 11652 ?       S    10:39   0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/vps270.ev1servers.net.pid --skip-locking --socket=/var/lib/mysql/mysql.sock
    mysql     3738  0.0  0.5 32052 11652 ?       S    10:39   0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/vps270.ev1servers.net.pid --skip-locking --socket=/var/lib/mysql/mysql.sock
    mysql     3739  0.0  0.5 32052 11652 ?       S    10:39   0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/vps270.ev1servers.net.pid --skip-locking --socket=/var/lib/mysql/mysql.sock
    mysql     3740  0.0  0.5 32052 11652 ?       S    10:39   0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/vps270.ev1servers.net.pid --skip-locking --socket=/var/lib/mysql/mysql.sock
    mysql     3741  0.0  0.5 32052 11652 ?       S    10:39   0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/vps270.ev1servers.net.pid --skip-locking --socket=/var/lib/mysql/mysql.sock
    mysql     3742  0.0  0.5 32052 11652 ?       S    10:39   0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/vps270.ev1servers.net.pid --skip-locking --socket=/var/lib/mysql/mysql.sock
    mysql     3797  0.0  0.5 32052 11652 ?       S    10:39   0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/vps270.ev1servers.net.pid --skip-locking --socket=/var/lib/mysql/mysql.sock
    mysql     3798  0.0  0.5 32052 11652 ?       S    10:39   0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/vps270.ev1servers.net.pid --skip-locking --socket=/var/lib/mysql/mysql.sock
    mysql     3799  0.0  0.5 32052 11652 ?       S    10:39   0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/vps270.ev1servers.net.pid --skip-locking --socket=/var/lib/mysql/mysql.sock
    mysql     3800  0.0  0.5 32052 11652 ?       S    10:39   0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/vps270.ev1servers.net.pid --skip-locking --socket=/var/lib/mysql/mysql.sock
    This script updates all the mysql privilege tables to be usable by
    MySQL 4.0 and above.
    
    This is needed if you want to use the new GRANT functions,
    CREATE AGGREGATE FUNCTION, or the more secure passwords in 4.1
    
    You can safely ignore all 'Duplicate column' and 'Unknown column' errors
    because these just mean that your tables are already up to date.
    This script is safe to run even if your tables are already up to date!
    
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    Got a failure from command:
    /usr/bin/mysql --no-defaults --force --user=root --host=localhost --password=kAVoDfezb3kVnIv3 --database=mysql
    Please check the above output and try again.
    
    If you get an 'Access denied' error, you should run this script again and
    give the MySQL root user password as an argument with the --password= option
    Waiting for mysql to restart..............finished.
    
    root      4049  0.2  0.0  2060 1028 ?        S    10:39   0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/vps.mydomain.com.pid
    mysql     4081  0.6  0.5 32004 11668 ?       S    10:39   0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/vps.mydomain.com.pid --skip-locking --socket=/var/lib/mysql/mysql.sock
    mysql     4082  0.0  0.5 32004 11668 ?       S    10:39   0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/vps.mydomain.com.pid --skip-locking --socket=/var/lib/mysql/mysql.sock
    mysql     4083  0.0  0.5 32004 11668 ?       S    10:39   0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/vps.mydomain.com.pid --skip-locking --socket=/var/lib/mysql/mysql.sock
    mysql     4084  0.0  0.5 32004 11668 ?       S    10:39   0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/vps.mydomain.com.pid --skip-locking --socket=/var/lib/mysql/mysql.sock
    mysql     4085  0.0  0.5 32004 11668 ?       S    10:39   0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/vps.mydomain.com.pid --skip-locking --socket=/var/lib/mysql/mysql.sock
    mysql     4086  0.0  0.5 32004 11668 ?       S    10:39   0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/vps.mydomain.com.pid --skip-locking --socket=/var/lib/mysql/mysql.sock
    mysql     4087  0.0  0.5 32004 11668 ?       S    10:39   0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/vps.mydomain.com.pid --skip-locking --socket=/var/lib/mysql/mysql.sock
    mysql     4088  0.0  0.5 32004 11668 ?       S    10:39   0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/vps.mydomain.com.pid --skip-locking --socket=/var/lib/mysql/mysql.sock
    mysql     4089  0.0  0.5 32004 11668 ?       S    10:39   0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/vps.mydomain.com.pid --skip-locking --socket=/var/lib/mysql/mysql.sock
    mysql     4090  0.0  0.5 32004 11668 ?       S    10:39   0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/vps.mydomain.com.pid --skip-locking --socket=/var/lib/mysql/mysql.sock
    
    /usr/bin/mysqladmin: connect to server at 'localhost' failed
    error: 'Access denied for user 'root'@'localhost' (using password: YES)'
    mysql has failed, please contact the sysadmin (result was "mysql has failed").
    Install Complete
    root@vps [~]# /usr/bin/mysql --no-defaults --force --user=root --host=localhost --password=kAVoDfezb3kVnIv3 --database=mysql
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
    root@vps [~]# /usr/bin/mysql --no-defaults --force --user=root --host=localhost --password=kAVoDfezb3kVnIv3 --database=mysql
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
    root@vps [~]# 
    
     
  5. Jeff-C

    Jeff-C Well-Known Member

    Joined:
    Mar 16, 2004
    Messages:
    117
    Likes Received:
    0
    Trophy Points:
    16
    While WHM monitoring says mysql is down, it does appear to me as a novice to be running

    Code:
    root@vps [~]# ps -aux | grep mysql
    root     23072  0.0  0.0  2060 1028 ?        S    14:09   0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/vps.mydomain.com.pid
    mysql    23107  0.0  0.5 32000 11668 ?       S    14:09   0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/vps.mydomain.com.pid --skip-locking --socket=/var/lib/mysql/mysql.sock
    mysql    23108  0.0  0.5 32000 11668 ?       S    14:09   0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/vps.mydomain.com.pid --skip-locking --socket=/var/lib/mysql/mysql.sock
    mysql    23109  0.0  0.5 32000 11668 ?       S    14:09   0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/vps.mydomain.com.pid --skip-locking --socket=/var/lib/mysql/mysql.sock
    mysql    23110  0.0  0.5 32000 11668 ?       S    14:09   0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/vps.mydomain.com.pid --skip-locking --socket=/var/lib/mysql/mysql.sock
    mysql    23111  0.0  0.5 32000 11668 ?       S    14:09   0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/vps.mydomain.com.pid --skip-locking --socket=/var/lib/mysql/mysql.sock
    mysql    23112  0.0  0.5 32000 11668 ?       S    14:09   0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/vps.mydomain.com.pid --skip-locking --socket=/var/lib/mysql/mysql.sock
    mysql    23113  0.0  0.5 32000 11668 ?       S    14:09   0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/vps.mydomain.com.pid --skip-locking --socket=/var/lib/mysql/mysql.sock
    mysql    23114  0.0  0.5 32000 11668 ?       S    14:09   0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/vps.mydomain.com.pid --skip-locking --socket=/var/lib/mysql/mysql.sock
    mysql    23115  0.0  0.5 32000 11668 ?       S    14:09   0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/vps.mydomain.com.pid --skip-locking --socket=/var/lib/mysql/mysql.sock
    mysql    23116  0.0  0.5 32000 11668 ?       S    14:09   0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/vps.mydomain.com.pid --skip-locking --socket=/var/lib/mysql/mysql.sock
    root     28998  0.0  0.0  1508  456 pts/0    S    14:56   0:00 grep mysql
    root@vps [~]# mysql
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
    But I seem to get that ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) no matter what.

    In WHM I used both password reset routines, and both said they worked without error.

    But still the same.

    Anyone have any ideas?
     
    #5 Jeff-C, Jan 19, 2006
    Last edited: Jan 19, 2006
  6. madaboutlinux

    madaboutlinux Well-Known Member

    Joined:
    Jan 24, 2005
    Messages:
    1,052
    Likes Received:
    2
    Trophy Points:
    38
    Location:
    Earth
    Execute the below commands on shell as root :-
    killall mysqld
    mysql -u root -p
    It will prompt you for the password. Enter the password and you will be taken to mysql prompt. Do the following on Mysql prompt.
    use mysql;
    UPDATE SET password=password("anypassword") where user="root";
    exit

    Try to connect to Mysql again.
     
  7. Jeff-C

    Jeff-C Well-Known Member

    Joined:
    Mar 16, 2004
    Messages:
    117
    Likes Received:
    0
    Trophy Points:
    16
    Many thanks, but...

    # mysql -u root -p
    Enter password:
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
     
  8. madaboutlinux

    madaboutlinux Well-Known Member

    Joined:
    Jan 24, 2005
    Messages:
    1,052
    Likes Received:
    2
    Trophy Points:
    38
    Location:
    Earth
    First check whether mysql.sock is present in /var/lib/mysql, if not create one and assign the appropriate permission and ownership using below commands :-
    cd /var/lib/mysql
    touch mysql.sock
    chown mysql.mysql mysql.sock
    chmod 1777 mysql.sock

    Also check whether the sym link is created in /tmp else
    ln -s /var/lib/mysql/mysql.sock /tmp

    Then execute the commands given in the previous post.
     
  9. Jeff-C

    Jeff-C Well-Known Member

    Joined:
    Mar 16, 2004
    Messages:
    117
    Likes Received:
    0
    Trophy Points:
    16
    Many many thanks for the help, but still a no go.

    Code:
    [~]# cd /var/lib/mysql
    [/var/lib/mysql]# ls *.sock
    /bin/ls: *.sock: No such file or directory
    [/var/lib/mysql]# cd /var/lib/mysql
    [/var/lib/mysql]# touch mysql.sock
    [/var/lib/mysql]# chown mysql.mysql mysql.sock
    [/var/lib/mysql]# chmod 1777 mysql.sock
    [/var/lib/mysql]# cd /tmp
    [/tmp]# ls -al *.sock
    srwxrwxrwx    1 110      root            0 Sep 11  2004 spamd_full.sock=
    srwxrwxrwx    1 110      root            0 Sep 11  2004 spamd_light.sock=
    [/tmp]# ln -s /var/lib/mysql/mysql.sock /tmp
    [/tmp]# killall mysqld
    mysqld: no process killed
    [/tmp]# mysql -u root -p
    Enter password: 
    [b]ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)[/b]
    [/tmp]# ls -al /var/lib/mysql/mysql.sock
    -rwxrwxrwt    1 mysql    mysql           0 Jan 19 16:37 /var/lib/mysql/mysql.sock*
    
    
    [/tmp]# service mysql start
    Starting MySQL................................... ERROR! 
    
     
    #9 Jeff-C, Jan 19, 2006
    Last edited: Jan 19, 2006
  10. madaboutlinux

    madaboutlinux Well-Known Member

    Joined:
    Jan 24, 2005
    Messages:
    1,052
    Likes Received:
    2
    Trophy Points:
    38
    Location:
    Earth
    Try the below steps :-
    1) Set the passwd for mysql in /root/.my.cnf
    2) killall mysqld
    3) Restart mysqld with the --skip-grant-tables option
    /usr/bin/safe_mysqld --skip-grant-tables &
    4) Connect to Mysql
    5) Update passwd for root user with the command :-
    > update user set Password = Password('pass') where User ='root';
    6) exit

    Try to connect to mysql again.
     
  11. Jeff-C

    Jeff-C Well-Known Member

    Joined:
    Mar 16, 2004
    Messages:
    117
    Likes Received:
    0
    Trophy Points:
    16
    Sorry to be such a newbie to mysql - how exactly should I connect to mysql at step 4?
     
  12. madaboutlinux

    madaboutlinux Well-Known Member

    Joined:
    Jan 24, 2005
    Messages:
    1,052
    Likes Received:
    2
    Trophy Points:
    38
    Location:
    Earth
    To connect to Mysql, just type mysql at the prompt and hit enter key. You have already done that before.
    root@hostname[~]# mysql
     
  13. Jeff-C

    Jeff-C Well-Known Member

    Joined:
    Mar 16, 2004
    Messages:
    117
    Likes Received:
    0
    Trophy Points:
    16
    Still no-go then.

    1) Set the passwd for mysql in /root/.my.cnf

    Already there, and copied and pasted to be sure.
    Code:
    File: /root/.my.cnf                                                   
    
    [client]
    user="root"
    pass="Jqss09f39EWdmC4X7a3t"
    
    2) killall mysqld
    Code:
    mysqld: no process killed
    3) Restart mysqld with the --skip-grant-tables option
    /usr/bin/safe_mysqld --skip-grant-tables &
    Code:
    [~]# /usr/bin/safe_mysqld --skip-grant-tables &
    [1] 2452
    root@vps [~]# Starting mysqld daemon with databases from /var/lib/mysql
    STOPPING server from pid file /var/run/mysqld/mysqld.pid
    060119 18:04:36  mysqld ended
    
    mysql
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
    [1]+  Done                    /usr/bin/safe_mysqld --skip-grant-tables
    
     
  14. madaboutlinux

    madaboutlinux Well-Known Member

    Joined:
    Jan 24, 2005
    Messages:
    1,052
    Likes Received:
    2
    Trophy Points:
    38
    Location:
    Earth
    This means Mysql is running in the background. You just need to follow the steps without any mistake in order for mysql to start working. Check the /tmp permission as well. It should be 1777.
     
  15. Jeff-C

    Jeff-C Well-Known Member

    Joined:
    Mar 16, 2004
    Messages:
    117
    Likes Received:
    0
    Trophy Points:
    16
    I still am not getting it. Rebooted the vps even and repeated steps above and still get the same error :(

    Double checked and it is.
     
  16. madaboutlinux

    madaboutlinux Well-Known Member

    Joined:
    Jan 24, 2005
    Messages:
    1,052
    Likes Received:
    2
    Trophy Points:
    38
    Location:
    Earth
    hehe. You need someone to get into your server and do it for you. Its not all that difficult, just because you are new to it, you are not able to try different things for it to work. Ask someone to look into your server. :)
     
  17. Jeff-C

    Jeff-C Well-Known Member

    Joined:
    Mar 16, 2004
    Messages:
    117
    Likes Received:
    0
    Trophy Points:
    16
    I usually get along pretty well with software. Installed mysql from scratch on a home system and didn't run into problems. This one has me stumped though and I don't seem to be making progress yet :(
     
  18. Jeff-C

    Jeff-C Well-Known Member

    Joined:
    Mar 16, 2004
    Messages:
    117
    Likes Received:
    0
    Trophy Points:
    16
    Got it.

    Trick was simply to read the /var/log/mysqld.log carefully

    Finally noticed it was looking for mysql.sock in /var/lib/mysql/mysql.sock vs. /var/lib/mysql/sock and data directory was in /var/lib/mysql/mysql not /var/lib/mysql

    Doh!

    Spent all day not seeing what was right in front of me. But glad it's up and running at last.
     
  19. madaboutlinux

    madaboutlinux Well-Known Member

    Joined:
    Jan 24, 2005
    Messages:
    1,052
    Likes Received:
    2
    Trophy Points:
    38
    Location:
    Earth
    Good job 'Jeff'. Got something to learn from you. :)
     
Loading...

Share This Page