1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Plesk 10.4.4 Windows & MySQL 4.1.22-community-nt - is SSL supported or not?

Discussion in 'Plesk 10.x for Windows Issues, Fixes, How-To' started by burnleyvic, Jan 30, 2013.

  1. burnleyvic

    burnleyvic Regular Pleskian

    17
    85%
    Joined:
    Nov 9, 2011
    Messages:
    174
    Likes Received:
    1
    Hi,

    On a Windows 2008R2 64bit server running 10.4.4 I'm trying to enable SSL connections for the MySQL instance used by Plesk, the one installed in c:\Program Files (x86)\Parallels\Plesk\MySQL\, but haven't been successful so far. I've added the following entries in c:\Program Files (x86)\Parallels\Plesk\MySQL\Data\my.ini:
    ssl
    ssl-ca=c:\\work\ssl\\host07.quick.net.au_ca-cert.pem
    ssl-cert=c:\\work\ssl\\host07.quick.net.au_server-cert.pem
    ssl-key=c:\\work\\ssl\\host07.quick.net.au_server-key.pem
    Plesk MySQL service couldn't be restarted after this, sending this error message to the Event Viewer:
    C:\Program Files (x86)\Parallels\Plesk\MySQL\bin\mysqld-nt.exe: unknown option '--ssl'
    When running C:\Program Files (x86)\Parallels\Plesk\MySQL\bin\mysqld-nt.exe --verbose --help there's no ssl option displayed, compared to the other MySQL version installed, 5.1, where ssl options appear in the listing.
    Question: is openssl supported in the MySQL 4.1.22-community-nt version, as shipped with Plesk? If yes, how can it be enabled? If no, what options do I have, excluding workarounds like vpn, stunnel etc?
     
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    If I correctly understood you have tried to enable SSL connection for admin's but not client's MySQL. Admin's MySQL is based on mysql-essential-4.1.22-win32.msi and seems does not support SSL. Also Plesk does not support operation with admin's MySQL through SSL connection.
    Could you please clarify for what purpose you need SSL connection for admin's MySQL?
     
  3. burnleyvic

    burnleyvic Regular Pleskian

    17
    85%
    Joined:
    Nov 9, 2011
    Messages:
    174
    Likes Received:
    1
    Igor,

    this is correct, I'm talking about 4.1.22 version used for the psa database. Why do we need remote access into 4.1.22? For some custom features and what we need isn't currently supported by the Plesk API.
     
  4. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    We just use vendor's build and if vendor does not support SSL then we doesn't support it too.
    You can use some scripts for your custom features and these scripts can be executed remotely.
     
  5. burnleyvic

    burnleyvic Regular Pleskian

    17
    85%
    Joined:
    Nov 9, 2011
    Messages:
    174
    Likes Received:
    1
    Is there any specific reason why plesk for windows uses a separate DB instance for itself. Unlike on Linux installs where a single mysql instance runs both by default?
     
  6. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    Plesk for Windows can use other database engines - MSSQL, for example. Plesk for Linux can use only one MySQL engine. I suppose that it is the main reason.
     
Loading...