Can Not Connect To Some Server With Enterprise 5.2

[kasi]

I just upgraded to Enterprise 5.2:

I can not connect to 2 Servers using HTTP-Tunnel.

When I do Test Connection it is show 'Connection successful ' with the right MySQL Verson,

but when I try to Connect it shows me 'Error No. 3 SQLyog Enterprise tunne …'

showing TunnelVersion:5.2

I have seen that you use Connection:keep-alive in the request. Is it possible, that it is not working when the Server closes the connection? I don't have access to the Apache configuration at the moment, so I can not check the settings.

Thanks

KASI

[peterlaursen]

There is no (intentional) change in any such functionality introduced with 5.2.

Please answer:

1) Your are perfectly sure that this problem occured the very same moment as you upgrade?

2) What was the version that you used before?

[kasi]

peterlaursen wrote on Nov 24 2006, 06:36 AM:

Please answer:

1) Your are perfectly sure that this problem occured the very same moment as you upgrade?

2) What was the version that you used before?

Yes I am shure. I had the same problem with that server when upgrading to version 5.17, so I switched back to version 5.13

Just reinstalled version 5.13 and it works.

version 5.13 works fine

version 5.17 no Test Connection and no Connection

version 5.2 Test Connection ok Connection fails

it is not the connection:keep-alive thing, this has been changed

any ideas ??

thanks

KASI

[kasi]

I guess I found the problem.

Version 5.2 uses multiple connections to the webserver simulatinously and that is not allowed there.

I again checked version 5.13 and it uses only 1 connection. So something must have been changed between this version.

Question now is why does SQLyog do that and how can I change that??

thankes

kasi

[kasi]

Now I found the problem.

For reasons I don't know the webserver sends a newlinw char before each content: So you can reproduce my error, when you insert a “echo chr(10);” at the beginning of the Tunnel-script.

It looks like that the connection that asks for the tunnel-version, doing a

“POST /SQLyogTunnel.php?app=sqlyog&version=5.2 HTTP/1.0” and receiving a

“TunnelVersion:5.2” response, can not handle that!

I hope you can add some content trimming so that I can connect to that server using version 5.2.

thanks

KASI

[peterlaursen]

Thanks for your research into this!

We will discuss this later today.

Just for clarity:

The report that multiple connections are not allowed, was a 'hoax' then?

However – actually we did an important change in the 5.1x tree. before that change we got data as POST datas now it is RAW data.

Could we have temporary access to your server so that we can test this in depth?

We don't need any data – just a few small dummy tables!

You can create a ticket to discuss further.

ADDED: actually we now reproduced exactly as you described by inserting “echo chr(10);” into the tunneller.

[kasi]

The Problem is fixed now.

It wasn't the Apache Server but PHP. There was a “auto_prepend_file” defined in php.ini which had a closing ?> tag with a new line after that.

KASI

[Author]

Posts