search

pBlueG / SA-MP-MySQL

MySQL plugin for San Andreas Multiplayer
BSD 3-Clause "New" or "Revised" License
197 stars 78 forks source link

[MySQL R41-3] system error: 10060 #163

Closed CheRrySMinT closed 7 years ago

CheRrySMinT commented 7 years ago

I don't know anything, i'll just leave it there. (With version R41-2 all works perfectly, idk why. These are errors when starting server with R41-3)

[21:04:18] [ERROR] CConnection::CConnection - establishing connection to MySQL database failed: #2013 'Lost connection to MySQL server at 'reading authorization packet', system error: 10060' [21:04:19] [ERROR] CConnection::CConnection - establishing connection to MySQL database failed: #2013 'Lost connection to MySQL server at 'reading authorization packet', system error: 10060' [21:04:20] [ERROR] CConnection::CConnection - establishing connection to MySQL database failed: #2013 'Lost connection to MySQL server at 'reading authorization packet', system error: 10060' [21:04:21] [ERROR] CConnection::CConnection - establishing connection to MySQL database failed: #2013 'Lost connection to MySQL server at 'reading authorization packet', system error: 10060'

maddinat0r commented 7 years ago

Are you on Windows or on Linux (distribution name + version please)? Do you use the static version?

JustDeimos commented 7 years ago

I apologize in advance for my English. Met with the same problem as the author. System: Windows 8.1 Plug-in version: R41-3 On the R41-2 version, there is no error.

maddinat0r commented 7 years ago

Which version is your MySQL server?

JustDeimos commented 7 years ago

Ver 14.14 Distrib 5.5.53, for Win32 (AMD64)

This? Now I'll try to put a newer version and write about what happened

UPD: The problem is observed on all versions, starting with 5.5 and ending with 5.7. Other versions so far there is no way to check if there is any need at all.

maddinat0r commented 7 years ago

I can't reproduce this issue on a clean SA-MP server with R41-3 and a fresh MySQL 5.5.57 server. Try deleting all plugin-related files (mysql.dll, libmariadb.dll, libmysql.dll (if there is one), a_mysql.inc), re-download R41-3, place it into your SA-MP server folder and recompile your script.

JustDeimos commented 7 years ago

https://www.youtube.com/watch?v=Y-vv9FMh9RE&feature=youtu.be

I am ready to help in every way to solve this problem. Just tell me what to do.

maddinat0r commented 7 years ago

Can you try to replace your current (R41-3) libmariadb.dll with that one from the R41-2 package?

JustDeimos commented 7 years ago

It worked. The error has disappeared.

maddinat0r commented 7 years ago

Can you try out this build please?

JustDeimos commented 7 years ago

Working

maddinat0r commented 7 years ago

Okay, I'll bump the version and release this as R41-4. Thanks for your help!