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.

Updating MySQL4 for SSL support

Discussion in 'General Discussion' started by roskopfj, Mar 18, 2005.

  1. roskopfj

    roskopfj Member

    Joined:
    Dec 7, 2004
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    1
    Are there any Cpanel friendly instructions for updating MySQL for SSL support? I've got a new CPanel/WHM installation with the default MySQL4 installation, which aparrently doesn't include SSL support. These are the instructions that the application developer sent me for updating MySQL for SSL support. Does anyone know if these are Cpanel friendly? I don't want to break anything and still want to be able to control MySQL through cpanel.




     
  2. roskopfj

    roskopfj Member

    Joined:
    Dec 7, 2004
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    1
    Has anyone managed to get SSL enabled in MySQL and still have it work with CPanel?
     
  3. anup123

    anup123 Well-Known Member

    Joined:
    Mar 29, 2004
    Messages:
    897
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    This Planet
    Post it on feature request in bugzilla. Unless your request gets a big poll in favour of it, it would just lie burried deep amidst other feature requests.

    OR

    Could check on this if it interests you

    http://www.stunnel.org/examples/mysql.html

    Anup
     
    #3 anup123, Mar 28, 2005
    Last edited: Mar 28, 2005
  4. Blue|Fusion

    Blue|Fusion Well-Known Member

    Joined:
    Sep 12, 2004
    Messages:
    378
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Cleveland, Ohio
    You can compile MySQL from source and enable SSL support. Just backup /var/lib/mysql directory, uninstall the MySQL RPMs, compile the source, and then move /var/lib/mysql back into place. Once done, you should have SSL support, and cPanel shouldn't have any problems connecting as it's not a forced SSL connection.
     
  5. cPanelBilly

    cPanelBilly Guest

    ok well I had a lil bit of free time on my hands.
    Make sure you have openssl-devel install
    Code:
    /scripts/ensurerpm openssl-devel
    Then get all of the files here:
    http://billyvierra.com/mysql/

    put them into their own directory.

    then install them all with the following
    Code:
    rpm -Uvh --force *.rpm

    All should go well and you should get the following:
    Code:
    mysql> show variables like "%ssl%";
    +---------------+-------+
    | Variable_name | Value |
    +---------------+-------+
    | have_openssl  | YES   |
    +---------------+-------+
    1 row in set (0.02 sec)
    
    Now please remember this is not part of cPanel, this is something I did myself on my off time today.
     
  6. roskopfj

    roskopfj Member

    Joined:
    Dec 7, 2004
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    1
    Thanks cpanelbilly :D
     
  7. roskopfj

    roskopfj Member

    Joined:
    Dec 7, 2004
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    1
    This is what I get when I try to install them... is --force not working correctly here? I'm running RedHat EL3

    rpm -Uvh --force *.rpm
    error: Failed dependencies:
    libmysqlclient.so.10 is needed by (installed) perl-DBD-MySQL-2.1021-3
    libmysqlclient.so.10 is needed by (installed) libdbi-dbd-mysql-0.6.5-5
    libmysqlclient.so.10 is needed by (installed) MySQL-python-0.9.1-6
    libmysqlclient.so.10 is needed by (installed) MyODBC-2.50.39-12
     
  8. dgbaker

    dgbaker Well-Known Member
    PartnerNOC

    Joined:
    Sep 20, 2002
    Messages:
    2,578
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Toronto, Ontario Canada
    cPanel Access Level:
    DataCenter Provider
    Try installing the client one by itself then do the others

    rpm -Uvh --force MySQL-client-4.1.10a-0.i386.rpm
     
  9. roskopfj

    roskopfj Member

    Joined:
    Dec 7, 2004
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    1
    Alright, that did work, MySQL is updated from the RPM's above and it's running, however when the user goes to https://theapplication they're still getting popups from Internet Explorer that say:

    "This page contains both secure and nonsecure items. Do you want to display the nonsecure items?"
     
  10. Blue|Fusion

    Blue|Fusion Well-Known Member

    Joined:
    Sep 12, 2004
    Messages:
    378
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Cleveland, Ohio
    That's probobly because any images linked from other sites are not over https, but just http.
     
  11. roskopfj

    roskopfj Member

    Joined:
    Dec 7, 2004
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    1
    I think those rpm's might not be stable... Since I installed them my whole server crashes every day and a half or so.
     
  12. krisdv

    krisdv Well-Known Member

    Joined:
    Jun 18, 2003
    Messages:
    175
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Belgium
    Then get all of the files here:
    http://billyvierra.com/mysql/

    Where can i find these files please.

    Can you send me how you did create it to zxr750@citap.com

    I mean what are the default compile options that CPANEL uses for compiling mysql.

    Or can i add in the default setup of cpanel the --ssl option for mysql?

    What do i need to do when cpanel lateron updates mysql so that the new version still will compiled with the --ssl option?


    -- Alex
     
    #12 krisdv, Sep 25, 2005
    Last edited: Sep 25, 2005
Loading...

Share This Page