The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Fresh cPanel install - MySQL is Broken

Discussion in 'General Discussion' started by TPMGJustin, May 2, 2014.

  1. TPMGJustin

    TPMGJustin Registered

    Joined:
    May 2, 2014
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    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:
    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
    
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    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.
     
  3. TPMGJustin

    TPMGJustin Registered

    Joined:
    May 2, 2014
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    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
    
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    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.
     
  5. TPMGJustin

    TPMGJustin Registered

    Joined:
    May 2, 2014
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hey Michael,

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

    4897175
     
    #5 TPMGJustin, May 2, 2014
    Last edited by a moderator: May 2, 2014
  6. cPanelJared

    cPanelJared Technical Analyst
    Staff Member

    Joined:
    Feb 25, 2010
    Messages:
    1,842
    Likes Received:
    18
    Trophy Points:
    38
    Location:
    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. :)
     
  7. TPMGJustin

    TPMGJustin Registered

    Joined:
    May 2, 2014
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Re: Friendly Moderator Note

    Gotcha,

    Thanks for letting me know Jared!
     
  8. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    To update, the issue was resolved after attempting to reinstall MySQL and verifying the MySQL root password did not use illegal characters.

    Thank you.
     
  9. supportmwm

    supportmwm Registered

    Joined:
    May 21, 2014
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    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.
     
  10. storminternet

    storminternet Well-Known Member

    Joined:
    Nov 2, 2011
    Messages:
    462
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page