MySQL and Tunneling, SQLite and encryption on OS X

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
karolpyt
Posts: 7
Joined: Mon 01 Dec 2014 20:51

MySQL and Tunneling, SQLite and encryption on OS X

Post by karolpyt » Thu 23 Apr 2015 20:57

Hello,

After upgrade UniDac to last version, tunneling to MySQL don't work.
My program connecting to server (via http tunnel) correct, but I can't execute any query. I have errors. Below are logs from my program:

/ ***ERROR: select * from bs_invoices limit 4 [Lost connection to MySQL server during query
Cannot retrieve content of HTTP packet]
/* 22:43:05 [0.00] */ **** Lost Connection *** - lost connection to mysql server during query
cannot retrieve content of http packet
...
Time to time the query are executed OK.

These problems are on Windows (32- and 64-bit).

On OS X I have exception "Input\Output error(5)"

Could You check these problems?

And second problem. When I try to use SQLite direct mode on OS X and encryption, I can't execute "insert" query becouse I have error with variants. Could You check this?

Best regards,
Karol

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: MySQL and Tunneling, SQLite and encryption on OS X

Post by ViktorV » Fri 24 Apr 2015 10:30

1. To solve the problem, try to increase the value of the TUniConnection.SpecificOptions.Values['ConnectionTimeout'] property. If this doesn't help, please enable logging in the tunnel.php file and send us the log file.
To enable logging in the tunnel.php, set the $LOG and $LOG_DEBUG variables to 1:
$LOG = 1;
$LOG_DEBUG = 1;
2. Please specify the text of the error message you are getting.

Post Reply