Fresh cPanel install - MySQL is Broken

[TPMGJustin]

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

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

The .err log file

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

 

[cPanelMichael]

Hello

Did you use any custom settings in your /etc/my.cnf file or make any modifications to MySQL before or after the cPanel installation? Please post the output from the following commands:

grep innodb_log_file_size /etc/my.cnf
du -s /var/lib/mysql/ib_logfile*

Thank you.

 

[TPMGJustin]

Hello

Did you use any custom settings in your /etc/my.cnf file or make any modifications to MySQL before or after the cPanel installation? Please post the output from the following commands:

grep innodb_log_file_size /etc/my.cnf
du -s /var/lib/mysql/ib_logfile*

Thank you.

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.

[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*

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

 

[cPanelMichael]

Try adding the following line to /etc/my.cnf and see if MySQL restarts:

innodb_log_file_size=102400

If that does not help, please open a support ticket using the link in my signature so we can take a closer look. You can post the ticket number here so we can update this thread with the outcome.

Thank you.

 

[TPMGJustin]

Try adding the following line to /etc/my.cnf and see if MySQL restarts:

innodb_log_file_size=102400

If that does not help, please open a support ticket using the link in my signature so we can take a closer look. You can post the ticket number here so we can update this thread with the outcome.

Thank you.

Hey Michael,

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

4897175

 

[JaredR.]

Friendly Moderator Note

I removed the link to the ticket; we do not advise posting it in a public forum. Also, our ticket system does not use the same URLs on our end, as on your end, and we actually cannot use the URL you receive, so it is not useful to us. All we need in the forum, or when referring to another ticket in a ticket, is the ticket number.

 

[TPMGJustin]

Re: Friendly Moderator Note

Gotcha,

Thanks for letting me know Jared!

 

[cPanelMichael]

To update, the issue was resolved after attempting to reinstall MySQL and verifying the MySQL root password did not use illegal characters.

Thank you.

 

[supportmwm]

the issue was resolved after attempting to reinstall MySQL

Hello Michael, I have been having a similar issue (I have mistakenly replaced "mysql" DB with a copy from another server - how silly hmm). I have been doing rounds of how can I do a fresh re-install and could not find anyway. Hope you can help me here? Can you give me commands/steps to perform this? I do not have any important DBs to backup so data loss is not an issue.

Thanks.

 

[storminternet]

You can reset the mysql installation as mentioned here http://forums.cpanel.net/f354/how-reset-mysql-server-cpanel-server-without-reinstalling-408952.html