Attempting to connect to mysql database via a citrix connection

Hi!

I installed a mysql server on a windows 7 machine and then installed HeidiSQL on the same machine and was able to access the mysql server from heidisql just fine using both ports 3306 and 33070 (one at a time obviously).

I then logged in to my organization's citrix environment, downloaded Heidi SQL, and ran it. It started fine, but when I put in exactly the same credentials except for the TCP/IP port (which I obtained from the first machine using ipconfig) I received an error message from the session manager saying "Can't create TCP/IP socket (10022)". I checked msdn and found the following:

"WSAEINVAL 10022 Invalid argument. Some invalid argument was supplied (for example, specifying an invalid level to the setsockopt function). In some instances, it also refers to the current state of the socket—for instance, calling accept on a socket that is not listening."

I've identified a couple of possibilities:

• a firewall on the citrix (virtual) machine or server
• virus checking on the same
• a bug?

Unfortunately I do not have ability to access either of these.

One possibility I have thought of to work around this is to use putty but do not have any experience with this (I've used SSH on linux for both the client and the server but not on windows) but need some answers to some questions to do so:

• Would I need an ssh server for the machine hosting mysql?

• Do I need putty or is this already built into Heidi SQL?

THANKS . . .

Phil Troy

You can use the built in SSH tunnel network type in HeidiSQL. You don't need Putty for that, but Plink.exe, from the same website. Just download plink.exe and place it somewhere on your harddisk.

Then you need an SSH server on the machine where the database server runs. On Windows systems, you can use the free freeSSHd which I also used on a Windows 7 machine.

When you have that installed and running, you need to configure a HeidiSQL session on your client machine, using "MySQL (SSH tunnel)" network type. On the "SSH tunnel" tab, type in the path to your plink.exe file. On the same tab, put in the SSH credentials and the port (mostly 22). Some more help can be found in the help section for connecting.

Hi!

I am totally stuck getting the portable version to work. I am not using Citrix now, and at one point in time I got it working but cannot do so again.

I have gone through the following sequence of steps:

• Unistalled Heidisql (windows 7 64 bit) using the control panel

• Reinstalled it

• Opened Heidisql (note that the uninstall did not clear out the registry

  • my former session name was still there)

• Opened the former session name successfully

• Exported the setting files to p2.txt

• Clean installed the portable version by extracting all from the zip file

• Opened the portable version by double clicking on it

• Imported p2.txt as session file

• Opened the session and got "can't crate tcp/itp socket (10022)

I am attaching the portable_settings.txt file below with the password removed

Thanks . . .

Phil

Hi!

I have successfully created a portable installation on the C drive so that when I open the program and then open the session it works. When I copy that folder to the F drive it no longer works and I get the 10022 error.

For the circumstances in which I am not supposed to use the C drive.

FYI I checked the registry to make sure there were no "heidi" entries

Thanks in advance . . .

Phil Troy

What about the idea with an SSH tunnel?

Hi

Thanks for responding.

On two userids, without ssh, everything works fine on the F drive, which is a mapped network drive. The system administrator indicated that he did not turn off virus checking or firewall on these userids. On the third userid I get 10022 error. I am going to double check with him about the firewall and virus checking, but I am otherwise totally confused.

With respect to using ssh, it is clearly not needed in two of the userids so I shouldn't need it for the third. My strong preference is to be consistent in how I am accessing the database.

I know that there are issues for networked mapped drives when virus checking is turned on for the mysql client and I am pretty sure that heidisql is using the myclient dll so it is not an issue with heidisql. However if you have any suggestions I would very much appreciate them.

THANKS . . .

Phil Troy