Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Enabling ssl support mysql : SSL:Not in use

Discussion in 'Data Protection' started by sreeninair, Feb 19, 2014.

  1. sreeninair

    sreeninair Well-Known Member

    Joined:
    Dec 23, 2013
    Messages:
    100
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    Hello Guys,

    I want to enable ssl in mysql. Currently it is showing as disabled. I have followed the steps in

    " http://www.thecpaneladmin.com/installing-ssl-certificate-mysql/" but getting the following error while accessing mysql.

    mysql log
    100820 15:10:43 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.0.91-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)
    100820 15:12:25 [Note] /usr/sbin/mysqld: Normal shutdown


    error while restarting
    root@server [/var/cpanel/ssl/mysql]# /etc/init.d/mysql start
    Starting MySQL. ERROR! Manager of pid-file quit without updating file.

    tatus
    --------------
    mysql Ver 14.12 Distrib 5.0.96, for pc-linux-gnu (i686) using readline 5.1

    Connection id: 1
    Current database:
    Current user: root@localhost
    SSL: Not in use
    Current pager: stdout



    Thanks
    Sreeni
     
  2. vanessa

    vanessa Well-Known Member
    PartnerNOC

    Joined:
    Sep 26, 2006
    Messages:
    834
    Likes Received:
    29
    Trophy Points:
    178
    Location:
    Virginia Beach, VA
    cPanel Access Level:
    DataCenter Provider
    Can you provide the last 80 lines or so of your error log file? /var/lib/mysql/<hostname>.err
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,532
    Likes Received:
    1,966
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello :)

    Yes, please let us know the output of your MySQL error log when restarting MySQL.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. vanessa

    vanessa Well-Known Member
    PartnerNOC

    Joined:
    Sep 26, 2006
    Messages:
    834
    Likes Received:
    29
    Trophy Points:
    178
    Location:
    Virginia Beach, VA
    cPanel Access Level:
    DataCenter Provider
    And also, not like this matters, but 5.0.96? Come on :)
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. sreeninair

    sreeninair Well-Known Member

    Joined:
    Dec 23, 2013
    Messages:
    100
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    Hello Vanessa,

    Thank you for your update.

    So ssl is unsupported in this version?.

    Thanks
    Sreeni
     
  6. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,532
    Likes Received:
    1,966
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    No, it was to make note that MySQL 5.0 is EOL (End-Of-Life). You should consider upgrading to MySQL 5.5 through WHM at some point (though it should not make a difference for this issue).

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice