Fresh cPanel install - MySQL is Broken

I have searched for the past 3 hours on Google and the cPanel forums without any luck for trying to fix this issue, so I'm resorting to creating a topic in hopes of a resolution.

I currently have a cPanel server that's working perfectly. However, we are migrating to a new server with better specs for the same price. Naturally, I figured the best way to do this would be to install the trial of cPanel on the new server and then proceed to mass-transfer the accounts, make the new server live and change the license for the current server over to the new one.

The cPanel install script ran beautifully. No errors of any kind. Now comes my problem. Everything on the server is working perfectly EXCEPT for MySQL. The server will not start, claiming that it can't connect via socket (/var/lib/mysql/mysql.sock). The first thing I did was checked "/var/lib/mysql/" for the existence of mysql.sock. The file isn't even there. I also checked the /tmp directory with no luck of finding "mysql.sock" either. It seems like it's nowhere on the server.

Next, I tried running /scripts/fixmysql, which it seems is a deprecated script since it was not found as well as /scripts/mysqlup.

At this point, I'm at a complete loss why this server would have so much trouble getting cPanel fully working when it's running the same CentOS as our current server without an issue. Below are all the error messages I have from starting the MySQL server and reading the .err log file. if anyone can take a look and provide some info on what might be wrong, it would be greatly appreciated.

Attempting to run mysql

Code:

root@s1 [/scripts]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

The .err log file

Code:

140502 10:00:39 mysqld_safe mysqld from pid file /var/lib/mysql/s1.***HIDDEN***.net.pid ended
140502 10:43:39 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140502 10:43:39 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead.
140502 10:43:39 [Note] Plugin 'FEDERATED' is disabled.
140502 10:43:39 InnoDB: The InnoDB memory heap is disabled
140502 10:43:39 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140502 10:43:39 InnoDB: Compressed tables use zlib 1.2.3
140502 10:43:39 InnoDB: Using Linux native AIO
140502 10:43:39 InnoDB: Initializing buffer pool, size = 128.0M
140502 10:43:39 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 104857600 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
140502 10:43:39 [ERROR] Plugin 'InnoDB' init function returned error.
140502 10:43:39 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140502 10:43:39 [ERROR] Unknown/unsupported storage engine: InnoDB
140502 10:43:39 [ERROR] Aborting

140502 10:43:39 [Note] /usr/sbin/mysqld: Shutdown complete

 

Hey Michael,

Thanks for the quick reply!

I haven't added anything to the my.cnf. I looked at the file, but haven't modified it. Here are the contents of the my.cnf file.

Code:

[mysqld]
max_connections=500
log-slow-queries

open_files_limit=35558

As instructed, I tried both commands.

grep innodb_log_file_size /etc/my.cnf <-- Nothing returned

du -s /var/lib/mysql/ib_logfile*

Code:

102400  /var/lib/mysql/ib_logfile0
102400  /var/lib/mysql/ib_logfile1

 

Hey Michael,

Unfortunately that didn't work. Here is the number to the ticket I created.

4897175

 

Re: Friendly Moderator Note

Gotcha,

Thanks for letting me know Jared!