Today I have signed up for 30-day free trial of ASL to try out in my dedicated server. My server runs on CentOS5 and Plesk control panel 10.
During the installation process it asked me:
skip networking is set in /etc/my.cnf
enable and re-run /var/asl/bin/database-setup
[root@u15426193 ~]# /var/asl/bin/database-setup
Testing login with defined credentials...failed.
This may be a first time install.
Attempting to create the user and database through Plesk
Configuring mysql user: tortix
Creating database: tortix
Loading OSSEC database schema: OK
/var/asl/bin/database-setup: line 152: /var/ossec/etc/mysql/mysql.schema: No such file or directory
Now, I am NOT able to start MySQL server
Starting psa... done
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[root@u15426193 tmp]# /etc/init.d/mysqld start
MySQL Daemon failed to start.
Starting mysqld: [FAILED]
I have tried setting "ln -s /var/lib/mysql/mysql.sock /tmp" but still no luck.
tail -f /var/log/mysqld.log
110912 11:01:18 mysqld started
110912 11:01:18 InnoDB: Started; log sequence number 0 221160096
110912 11:01:18 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
110912 11:02:59 [Note] /usr/libexec/mysqld: Normal shutdown
110912 11:02:59 InnoDB: Starting shutdown...
110912 11:03:00 InnoDB: Shutdown completed; log sequence number 0 221160096
110912 11:03:00 [Note] /usr/libexec/mysqld: Shutdown complete
All my sites are down.