Access to mysql

Databases
1

hi
When trying to login to db error 2026. Please anyone know what to do with it. Xojo 2020R1
thanks

2

Are you trying to connect to a non-SSL-Secured Server with activated SSL?
Or maybe you are trying to access a SSL Secured Server without a or without the correct CA Certificate?

3

The provider says it doesn’t have ssl enabled. Z C-scharp works as standard

Session.db = new MySQLCommunityServer

Session.db.Host = str(“uvdb53.active24xxx.cz”).ConvertEncoding(Encodings.SystemDefault)
Session.db.Port = 3306
Session.db.Username = str(“trutechcshopxx”).ConvertEncoding(Encodings.SystemDefault)
Session.db.Password = str(“xxxxxxx”).ConvertEncoding(Encodings.SystemDefault)
Session.db.DatabaseName = str(“trutechcshop”).ConvertEncoding(Encodings.SystemDefault)

4

What happens if you add: Session.db.SSLEnabled = False ?

And you should replace those .ConvertEncoding(Encodings.SystemDefault) to the used encoding (like .ConvertEncoding(Encodings.UTF8)) :wink:

5

Have you tried connecting with MySQL Workbench? This helps determine if the problem is in your code or Xojo, or something with the server or network.

1 Like
7

Follow this advise please, @Frantisek_Jesatko. We use mysqlCommunityServer for many, many mysql environments and it works just fine. Most if not all cases in which i had issues, it was the server config or my own lack of knowledge :wink:

8

Can you access this database using Navicat or any other DB tool ?

9

Hi ,
After testing the connection settings to the mysql server in xojo, I have no results. So I took the connection parameters and set the visual studo in the Winforms studio without any problems, the connection I made in WebForms ASP.net also works. So the problem is in the Xojo, but I don’t know where.

10

Can you please add:

   Session.db.SecureAuth = False
   Session.db.SSLEnabled = False

and try again?

11

Hi,
connection error 2026 being tested

12

I also have this problem with the MBSdatabase plugin

13

Ok. Maybe it’s just an old unpatched server… (https://bugs.mysql.com/bug.php?id=9270)

14

provider says ssl is not activated

15

I’ sorry, but i have no more ideas. All i can say is we use the mysqCommunityPlugin with various local and remote connections/servers and have no issues. We use MBS only for MSSQL connections.

16

Thank you I also use it in more places and it always works here it’s a problem of the provider I solve it with it but I don’t want to do anything

17

Now provider says openssl is activated

18

With xojo 2015R2.1 everything works as possible