LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 06-22-2014, 05:02 AM   #1
jrahma
Member
 
Registered: Oct 2011
Posts: 39

Rep: Reputation: Disabled
disable SSH Tunnel on MySQL


Hi,

I am new Linux. I just installed CentOS. I am now able to connect to MySQL using NaviCat with the SSH Tunnel enabled but my business application (.NET based) is now not working.. I guess because of the SSH. I am getting (unable to connect to any of the specified mysql hosts).

I have remove the openssh-server using yum remove but I am still having the same problem!

Kindly help..


Thanks,
Jassim
 
Old 06-22-2014, 05:55 AM   #2
pingu
Senior Member
 
Registered: Jul 2004
Location: Skuttunge SWEDEN
Distribution: Debian preferably
Posts: 1,350

Rep: Reputation: 127Reputation: 127
Too little information, my friend. Please always be precise as to details or we won't be able to help you.

Let's see what we have:
CentOS - your workstation, a server for mysql, or both?
A .NET based application - running on a Windows I suppose?
With ssh server on your CentOS your application cannot connect and you "guess because of the SSH". How did you come to that conclusion? What steps have you taken to troubleshoot the issue?
Are there any error messages, if so please post them.

I'm guessing now, you run Navicat on your workstation, mysql on CentOS server, .NET application on some Windows machine.
If this is correct:
Are all these in the same subnet? What's your network setup?
What username do you use when connecting with Navicat?
What username do you use when connecting from application, how is mysql host defined?
 
Old 06-22-2014, 06:59 AM   #3
jrahma
Member
 
Registered: Oct 2011
Posts: 39

Original Poster
Rep: Reputation: Disabled
hmm

sorry for the little information which I thought it was enought

Yes you are right.

CentOS is my server. Windows is my client and my application is running on .NET on the client. and I am also using NaviCat on the client.

I am getting an error on my application when trying to run it. The error is: unable to connect to any of the specified mysql but at the same time I am able to ping and I am able to connect using third-party application NaviCat which I must enable the SSH tunnel in order to connect.


Now answering your questions:

Are all these in the same subnet? What's your network setup?
Yes all under 255.255.255.0. My client IP is 10.0.0.137 and my server IP is 10.0.0.148

What username do you use when connecting with Navicat?
Do you mean the MySQL user? it's root and in the SSH tunnel tab I am using the root of linux.

What username do you use when connecting from application, how is mysql host defined?
I am also using root and this is my connection string:
server=xx;port=xx;database=xx;uid=xx;pwd=xx;connection timeout=xx
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
SSH Reverse Tunnel - ~/.ssh/config - PHP marcelp1 Linux - Newbie 1 05-28-2014 01:49 AM
MySQL Cannot start SSH tunnel manager?? michaelinux Linux - Software 4 09-20-2012 08:47 AM
Initiate ssh tunnel to connect to ssh? brianmcgee Linux - Security 2 09-07-2011 11:07 AM
Strange problem - mysql not working through ssh tunnel ganz_friedrich Linux - Software 0 03-31-2006 09:45 AM


All times are GMT -5. The time now is 08:47 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration