since the version Xojo 2017r2.x, I have the problem, under macOS 10.12.6/10.13 i can’t access with my program on my mySQL database.
I get the error message "Error: 2013 - Lost connection to MySQL server at ‘reading initial communication packet’, system error:0.
[code]dbc_TI = New MySQLCommunityServer
Dim Network As New TCPSocket3
Dim ar_ipadr() As String
ar_ipadr = Network.LocalAddress.Split(".")
If ar_ipadr(2) = “1” Then
dbc_TI.Host = “192.168.1.50”
Elseif ar_ipadr(2) = “2” Then
dbc_TI.Host = “192.168.2.35”
Else
dbc_TI.Host = “localhost”
End If
If Not dbc_TI.Connect Then
’ Connection error
MsgBox("Error : " + Str(dbc_TI.ErrorCode) + Chr(13) + dbc_TI.ErrorMessage)
’ Programm beenden
Quit
End If[/code]
On Windows 10.x, the same program works without problems, i get the connection.
Is this a Xojo Bug ? Any Idea ?
One possible reason: Make sure the Route between Client and Server is valid. I f.e. the DNS Server refuses to resolve the Adress or if there is no valid Route (Blocked?) to the Server, you may get this error.
Thank’s for your answer , i’m away on business, i 'll try it at friday. It could be the Programm Little Snitch, i’ve since 3 week’s an new one with version Number 4.
We use SSL Connections with Certificates to communicate with our Servers (over Tunneld VPN Connnections). In very rare cases i saw this error if the Server is not accepting the connection because of an auth. issue. We should see something like “: SSL connection error: protocol version mismatch” but sometimes (again, very rare (1 or 2 times now in 3 years)) we saw Error:2013.
I’m at the office right now. But i may be using 5 + 10, not 7 + 10. I use them on Synology NAS’s (DSM 6.x) and they offer 5 + 10 out of the box. So i may also use 5 + 10 only.