Re: Received an unexpected EOF or 0 bytes from the transport stream when using SSL

[Fernando Gonzalez]

Hi Peter,

True, removing CertificateFile & CertificatePath from connection string doesn't make sense.

Could it be the case that your certificate expired?
You can check in MMC, following steps like this:
http://www.youtube.com/watch?v=kdQFvm_eKpU

If certificate is expired, you can try SSLMode=Preferred.

The following is the lists of SSL modes allowed (from the source code).

/// <summary>
/// SSL options for connection.
/// </summary>
public enum MySqlSslMode
{
/// <summary>
/// Do not use SSL.
/// </summary>
None,
/// <summary>
/// Use SSL, if server supports it.
/// </summary>
Preferred,
Prefered = Preferred,
/// <summary>
/// Always use SSL. Deny connection if server does not support SSL.
/// Do not perform server certificate validation.
/// </summary>
Required,
/// <summary>
/// Always use SSL. Validate server SSL certificate, but different host name mismatch.
/// </summary>
VerifyCA,
/// <summary>
/// Always use SSL and perform full certificate validation.
/// </summary>
VerifyFull
}

Thanks.