Tunnelling On Shared Host: Extension Xml Was Not Found

[topherz]

Hello,

I am trying to use the tunneling feature to connect to a windows shared hosting account at godaddy.com.

When i try to connect from the trial version of SQLYOG enterprise I get the following response from the tunneling php page:

“

Error: Extension XML was not found compiled and loaded in the PHP interpreter. SQLyog requires this extensionto work properly.

Tunnel version: 5.25.

“

I would like to ask the sysadmin at godaddy to add this extension, but i dont know enough about PHP (Im using asp) to know the proper request to make.

My phpinfo page is here:

http://www.sourcevisuals.com/test.php

Could you please tell me what I should request from the godaddy.com sysadmin such that this feature works?

Thanks for your help!

-topher

[Sabyasachi Ruj]

Sometimes we are having this problem with an “IIS web server and PHP” combination. And ofcourse we intend to solve this issue.

From the phpinfo() you have given, I can see that you are having an IIS web server on a WIN NT platform.

It would be very nice if we get to see what the problem is in your case. And if you can give us a TEST database on your mysql setup it will be the best. You dont have to expose any data. So IF YOU WANT you can create a new database and a new user having privileges ONLY TO THAT NEW DATABASE.

In case, if you can have only one database on your host server, you can create a new table and a new user.

Do not post those access details here. Please use our ticket system/support system instead.

Sabayasachi.

[topherz]

Thank you Sabayasachi,

I have posted a ticket to the support system (#2559).

I have created a database for you and posted the info in the support ticket.

I hope this helps you track down the problem. Please contact me via the email in the support ticket if I can be of assistance.

-topher

Sabyasachi Ruj wrote on Mar 23 2007, 11:55 PM:

Sometimes we are having this problem with an “IIS web server and PHP” combination. And ofcourse we intend to solve this issue.

From the phpinfo() you have given, I can see that you are having an IIS web server on a WIN NT platform.

It would be very nice if we get to see what the problem is in your case. And if you can give us a TEST database on your mysql setup it will be the best. You dont have to expose any data. So IF YOU WANT you can create a new database and a new user having privileges ONLY TO THAT NEW DATABASE.

In case, if you can have only one database on your host server, you can create a new table and a new user.

Do not post those access details here. Please use our ticket system/support system instead.

Sabayasachi.

[peterlaursen]

We got the details.

We will continue the discussion in the ticket!

[krowllaw]

I am having the same problem:

Error: Extension MySQL was not found compiled and loaded in the PHP interpreter. SQLyog requires this extension to work properly.

Tunnel version: 5.17.

and with a different version of SQLYog:

Error: Extension php_mysqli or php_mysql was not found compiled and loaded in the PHP interpreter. SQLyog requires one of these these extensionsto work properly.

Tunnel version: 5.25.

Windows Server 2003, PHP5, and mySQL5.

Was there a resolution?

[peterlaursen]

@krollaw

I think the error messages tell allt what there is to tell! PHP on your host is not configured to connect to MySQL. Only the SysAdmin/support can solve that! You will have to contact your ISP!

Now it is very unusual that PHP runs without MySQL support! So probably it is a silly mistake during PHP compilation or configuration!

Do you know about the PHP version?

If you create a simple PHP file with the single command

Code:

phpinfo();

.. you can connect to it with a browser and verify that no mysql or mysqli extension is loaded! If phpinfo() tells that the extension is loaded or if you know positively that some other PHP-script can connect to mysql, then we will have to deeper into details …

[krowllaw]

MySQL Support enabled

Active Persistent Links 0

Active Links 0

Client API version 5.0.37

Directive Local Value Master Value

mysql.allow_persistent On On

mysql.connect_timeout 60 60

mysql.default_host no value no value

mysql.default_password no value no value

mysql.default_port no value no value

mysql.default_socket no value no value

mysql.default_user no value no value

mysql.max_links Unlimited Unlimited

mysql.max_persistent Unlimited Unlimited

mysql.trace_mode Off Off

from phpinfo()

Does that leave you with the impression that mysql and php are configured properly?

[peterlaursen]

Yes, it is my 'impresssion' .. but I do not understand how you think your reply should help us to help you?

Still: are you able to connect to MySQL with any other PHP-script/application?

(Even if phpinfo() tells the extension is enabled it may not be functional.)

There also could be some issue related to some setting in Windows Server 2003. Is the webserver IIS or Apache (or something more 'exotic') ?

Actually we would like to see the complete phpinfo() response ourselves. Also if possible we would like to connect to the tunneller from inside a debugging environment. From such we can trace exactly what does not match the response that we expect.

I suggest that you create a ticket here

http://www.webyog.com/support/ttx.cgi

… so that your details can remain confidential.

… and do not forget to tell the EXACT SQLyog program versions that you tried! And if you did not try LATEST (6.04 or 6.05 beta) please try this too.

[peterlaursen]

hi …

did 6.x solve the issue or do you need more help on this?

[sheppoor]

peterlaursen wrote on Jul 15 2007, 04:03 AM:

did 6.x solve the issue or do you need more help on this?

The problem remains with godaddy.com and everyone using their windows shared hosting accounts.

I am a registered user of version 4.1 and it works correctly. I am also a registered user of 5.22 and it does not work. I've just tried version 6.15 (trial version) and it fails as well. Same errors as the posters above. FYI, The godaddy.com Linux accounts work just fine with all versions of SQLyog, but unfortunately I need to use windows-based hosting for some of my clients.

Version 6.15 (trial) tunneling returns the following message:

Error: Extension XML was not found compiled and loaded in the PHP interpreter. SQLyog requires this extensionto work properly.

Tunnel version: 6.0.

This PHP page exposes the MySQL API as a set of webservices.

This page allows SQLyog to manage a MySQL server even if the MySQL port is blocked or remote access to MySQL is not allowed.

Visit Webyog to get more details about SQLyog.

I see two possible solutions. The first is to have godaddy.com properly install the XML components required for PHP. The other option is to allow the old non-XML version SQLyogTunnel to operate in the latest version of SQLyog.

Since you are now partnering with godaddy.com to sell SQLyog monthly subscriptions to Linux hosted users, do you have any sway to get them to support the Windows platform properly? If not, can you publish a non-XML version of SQLyogTunnel?

If you need any further details please let me know.

[peterlaursen]

hmm ……

I agree that this is not very impresssing how GoDaddy supports a product (in case SQLyog) that is distributed through their own channels.

We will discuss tomorrow morning how to handle this.

[peterlaursen]

Actually we had a discussion about this With Godaddy about 6 monts ago.

They explain

“The basic problem is that our PHP4 on Windows includes an older MySQL client library that only work or MySQL <= 4.0. Currently, all new MySQL databases in our system are 4.1 or 5.0, although we still have many 4.0 that exist. (Our Windows Shared hosting customers who want to use MySQL [vs MSSQL] use other languages than PHP4 [e.g. ASP, ASP.NET, Cold Fusion.]) We did try to comment all references to extension_loaded() in the tunnel, and when trying to connect to a MySQL 4.1 database, we experienced the “Client does not supprt authentication protocol” PHP error mentioned in http://forge.mysql.com/wiki/PHP_FAQ.

While the tunnel on our Windows PHP4 should work fine with any MySQL 4.0 databases in our system, the fact that our Windows PHP4 simply can't connect to MySQL 4.1/5.0 databases is the key problem.”

So currently GoDaddy will not support PHP on Windows hosting. It works in your case with SQLyog 4.x, but that must be because you have an older setup (“… although we still have many 4.0 that exist”) than what they do today.

To support MySQL 4.1 and 5.x features we need full XML support. SQLyog 4.x was designed for 3.23 and 4.0 basically! We cannot release that.

There have been discussion that Godaddy should update their PHP configuration (but it probably is not easy as it has a lot of dependencies!) or we should provide an ASP based tunneller. No conclusion yet.

[sheppoor]

Thank you for the update. I really appreciate knowing what the issues are.

[sheppoor]

Solution! (a follow-up for anyone who finds themselves in the same boat)

In GoDaddy you need to upgrade your hosted account to IIS 7. This will give you full PHP 5.0, not the old stripped down version GoDaddy used to give us with IIS 6 and 5.

Warning, going to IIS 7 is a pain; first you need to move any older 4.0 mySQL databases to 5.0 (4.1 is apparently ok but I've not tested) and ditch any MS SqlServer dbs completely. Once you've got your apps working again with the new connection strings, then you can start the IIS upgrade – which then takes 48 hours. The IIS upgrade will first move all your MySQL databases to yet another new server so you will have new connection strings again. Do this connection string upgrade immediately, you will have a short window before you will be temporarily locked out. It will then move you site, and if have a static IP then that will change too. Expect to be unable to connect via FTP for 48 hours, including direct FTP to a static IP address. Also, you may need to change they way you send automated emails under IIS 7.

But, when all is said and done you will be able to connect via the tunnel, and the best part is direct connections to the new GoDaddy MySQL db locations works as well – I'm shocked that GoDaddy allows it now, but I'm happy.

I'm a happy up-to-date SQLyog customer again, no more ancient versions for me. Thanks!

[Author]

Posts