Connecting via HTTP tunnel by PHP - libmysql.dll error

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
bocianl
Posts: 1
Joined: Tue 13 Apr 2010 15:26

The same problem

Post by bocianl » Tue 13 Apr 2010 15:29

We also have this problem. You know when will be the new version?
Top
Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Wed 14 Apr 2010 08:03

Please contact us by dmitryg*devart*com email and specify your developer license number and the version of Delphi. We will send you a custom build with the fix.
Top
Thomas
Posts: 2
Joined: Sun 11 Apr 2010 17:51

Post by Thomas » Mon 19 Apr 2010 19:42

Is the bug (http tunnel) fixed in new build of MyDAC version 5.90.0.57?
Top
dataquest
Posts: 10
Joined: Tue 06 Apr 2010 13:38

Post by dataquest » Tue 20 Apr 2010 06:40

Hi Dimon!
I sent you mail with my Developer License Number few days ago (04/14).
What about the new version of MyDac component?
Top
Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Tue 20 Apr 2010 07:40

Thomas wrote:Is the bug (http tunnel) fixed in new build of MyDAC version 5.90.0.57?
MyDAC 5.90.0.57 doesn't solve the problem with http tunnel. This fix will be included in the MyDAC build version 5.90.0.58.
Top
Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Tue 20 Apr 2010 07:43

dataquest wrote:I sent you mail with my Developer License Number few days ago (04/14).
What about the new version of MyDac component?
I have sent you a custom MyDAC build with the fix by e-mail.
Top
dataquest
Posts: 10
Joined: Tue 06 Apr 2010 13:38

Post by dataquest » Tue 20 Apr 2010 11:54

Now it works! Thanks!
Top
dataquest
Posts: 10
Joined: Tue 06 Apr 2010 13:38

Post by dataquest » Wed 21 Apr 2010 09:48

Hi!
I found one more problem.
When I try to run this query:

"select id from mytable where parent_id = 1 and lang_id = 1 order by id desc limit 1"

I get this error message:

"Lost connection to MySQL server during query
Invalid tunneling script parameter: 830 and lang_id = 1 order by id desc limit 1"

When I cut "limit 1" at the end of the query string - everything is OK.
This problem exists only if I use PHP tunnel.
Top
Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Wed 21 Apr 2010 15:08

I can not reproduce the problem. Please make sure that you use the new tunnel.php file.
Top
dataquest
Posts: 10
Joined: Tue 06 Apr 2010 13:38

Works slowly...

Post by dataquest » Tue 04 May 2010 05:39

Hi Dimon!
When I'm connecting using PHP tunnel every query seems to work slower than without tunnel (for example, if I connect using putty - plink ssh tunnel).
In particular, operations such as "update" and "insert".
"Select" works slower but well enough.

What could be the reason?
Top
Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Wed 05 May 2010 09:09

This behavior is connected with the work of the PHP tunnel, that receives HTTP data, unwrap it and resends it to a MySQL server. Speed of work is determined by PHP.
You can create a secure connection to MySQL server via SSH/SSL you should use the TMySSHIOHandler/TMySSLIOHandler component and SecureBridge components.
Top
Post Reply

Return to “MySQL Data Access Components”