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

[Jeff-C]

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?

[simplestar]

Chattr errors are normal on a VPS as I've come to find out. Check to be sure MySQL is not already installed.

[Jeff-C]

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?

[Jeff-C]

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

<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 [~]#

[Jeff-C]

While WHM monitoring says mysql is down, it does appear to me as a novice to be running

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?

[madaboutlinux]

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.

[Jeff-C]

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)

[madaboutlinux]

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.

[Jeff-C]

Many many thanks for the help, but still a no go.

[~]# 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: 
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
[/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!

[madaboutlinux]

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.

[Jeff-C]

Sorry to be such a newbie to mysql - how exactly should I connect to mysql at step 4?

[madaboutlinux]

To connect to Mysql, just type mysql at the prompt and hit enter key. You have already done that before.
root@hostname[~]# mysql

[Jeff-C]

Still no-go then.

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

Already there, and copied and pasted to be sure.

File: /root/.my.cnf                                                   

[client]
user="root"
pass="Jqss09f39EWdmC4X7a3t"

2) killall mysqld

mysqld: no process killed

3) Restart mysqld with the --skip-grant-tables option
/usr/bin/safe_mysqld --skip-grant-tables &

[~]# /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

[madaboutlinux]

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

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.

[Jeff-C]

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.

I still am not getting it. Rebooted the vps even and repeated steps above and still get the same error

Check the /tmp permission as well. It should be 1777.

Double checked and it is.