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.

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:
    817
    Likes Received:
    22
    Trophy Points:
    18
    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
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,723
    Likes Received:
    660
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  4. vanessa

    vanessa Well-Known Member
    PartnerNOC

    Joined:
    Sep 26, 2006
    Messages:
    817
    Likes Received:
    22
    Trophy Points:
    18
    Location:
    Virginia Beach, VA
    cPanel Access Level:
    DataCenter Provider
    And also, not like this matters, but 5.0.96? Come on :)
     
  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 Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,723
    Likes Received:
    660
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
Loading...

Share This Page