Fresh cPanel install - MySQL is Broken

TPMGJustin

Registered
May 2, 2014
4
0
1
cPanel Access Level
Root Administrator
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:
[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
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
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,884
2,254
463
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:

Code:
grep innodb_log_file_size /etc/my.cnf
du -s /var/lib/mysql/ib_logfile*
Thank you.
 

TPMGJustin

Registered
May 2, 2014
4
0
1
cPanel Access Level
Root Administrator
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:

Code:
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.
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
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,884
2,254
463
Try adding the following line to /etc/my.cnf and see if MySQL restarts:

Code:
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

Registered
May 2, 2014
4
0
1
cPanel Access Level
Root Administrator
Try adding the following line to /etc/my.cnf and see if MySQL restarts:

Code:
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
 
Last edited by a moderator:

JaredR.

Well-Known Member
Feb 25, 2010
1,834
27
143
Houston, TX
cPanel Access Level
Root Administrator
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. :)
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,884
2,254
463
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

Member
May 21, 2014
6
0
51
cPanel Access Level
Root Administrator
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.