Need Help Getting Started With Sqlyog

[DBnewb]

Ok, so I've read through the forums, trying to educate myself. But I don't think I have the understanding to accomplish my task.

Here is my scenario: Coldfusion site using MSSQL database. I am trying to convert the MSSQL database to a MYSQL database for use with a new content management system. My host blocks remote connections to the MSSQL database.

The first problem I have is establishing a connection.

I have uploaded the php file to my site's root.

The file is accessible.

When I try to access with tunneling, I get “error no. 1 error in tunneling. Please send the HTTP respone to http://www.webyog.com/support”

However, the HTTP response is just a blank dialog box.

I am a complete newcomer to DB management, but am willing to learn. My background is in building websites and networking. This project is certainly a learning experience.

Thanks in advance

[Aparna]

Hi,

Does this URL http://www.yourdomain.com/SQLyogTunnel.php (please replace http://www.yourdomain.com with the IP address where you have uploaded the PHP page) work when you open it in a browser?

In the HTTP tab you will find an option that says advanced. Please click on that option and check the option at the bottom that reads Always use base 64 encoding for data stream. After selecting this option please also try with different content type options available in the drop down.

[DBnewb]

'Aparna' wrote:

Hi,

Does this URL http://www.yourdomain.com/SQLyogTunnel.php (please replace http://www.yourdomain.com with the IP address where you have uploaded the PHP page) work when you open it in a browser?

Yes, the URL works and returns:

Tunnel version: 8.21.

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.

Quote:

In the HTTP tab you will find an option that says advanced. Please click on that option and check the option at the bottom that reads Always use base 64 encoding for data stream. After selecting this option please also try with different content type options available in the drop down.

I followed your instructions, but I get “Error 2003, Can't connect to MySQL server on localhost” when I click “test connection”

Just want to confirm 2 things, since I'm new at this:

Am I supposed to do something else on the MySQL tab?

I am trying to connect to a MSSQL database at this point, right?

[peterlaursen]

You can connect to the tunneller but PHP cannot connect to MySQL.

I can think of three reasons for this:

1) PHP is not configured to connect to MySQL at all. Do you know if any other PHP script will connect? 'any other PHP script' includes phpMyAdmin.

2) MySQL on this server uses a non-standard UNIX-socket.  In that case we will be able to 'patch' the tunneler for you.

3) MySQL and webserver is not running on the same host and you don't specify the hostname of the MySQL server

What do you specify as 'mysql host' in the 'MySQL' tab of connections manager.  If you use 'localhost' please try '127.0.0.1' instead – or read http://www.webyog.co…at-an-isp.html.  You will need to specif the MySQL host 'relative to the webserver'. If it is not 'localhsot' or '127.0.01' only your ISP support can tel what it is.  It is impossible for us to tell.

If you are sure that the MySQL hostname is entered correctly we need phpinfo() from this server.  To get it create a small file reading: 

Code:

phpinfo(); 
?>

Save as 'info.php' and upload to same place as the SQLyog tunneler.  Now connect to it from a browser and paste the full return here (or save as a 'web archive' and attach or paste the full link to ..info.php).  Note that if you want privacy you can create a support ticket at http://webyog.com/support.

[Author]

Posts