Welcome to the VanDyke Software Forums

Join the discussion today!


Go Back   VanDyke Software Forums > General

Notices

Reply
 
Thread Tools Display Modes
  #1  
Old 04-25-2008, 12:29 AM
Karebac Karebac is offline
Registered User
 
Join Date: Apr 2008
Posts: 10
making first connection

I have a windows xp at the office, and an identical computer at home.

The office machine has mysql server. A second office computer has successfully accessed that server on peer 2 peer. I want my home computer to be able to log into the office computer, so my excel vba app can access the mysql in the office.

I have a trial version of securecrt on the office server machine, and one on my home machine. at home, i used westell to configure a static pass through address. I use logmein.com to test the office computer from home.

I have no success in getting securecrt to talk to either machine in any way. Is there some kind of more explicit guidance. I know that mysql server uses localhost, 127.0.0.1, and port 3306.

Where could I find ANY sort of tutorial example to get securecrt to work and talk to ANYTHING on either machine.

Thanks!
Reply With Quote
  #2  
Old 04-25-2008, 09:46 AM
tnygren's Avatar
tnygren tnygren is offline
Registered User
 
Join Date: May 2005
Posts: 1,408
Hi Karebac,

I just have a couple questions.

You mentioned that SecureCRT is installed on both machine but no mention of a server on either machine for SecureCRT to connect to.

Are there any SSH2 or telnet servers on the machines?

Were you needing a remote desktop type connection or just command line access?
__________________
Thanks,

Teresa

Teresa Nygren
Reply With Quote
  #3  
Old 04-26-2008, 11:26 AM
Karebac Karebac is offline
Registered User
 
Join Date: Apr 2008
Posts: 10
connecting from home to office, excel vba myodbc

Here is my situation:

At work, in the office, we have Verizon DSL, with a Westel modem, and two Dell Windows XP(professional), connected peer to peer. The mysql server is on my desktop. By the way, I can successfully log into that machine from my home dell xp using logmein.

What I want is to have an excel vba application at home connect to the mysql server at work. I gather from reading that it is through port 3306.

I have used canyouseeme.org on both server machine and client machine, to see the actual ip address. On my home machine I have used Westell 192.168.1.1 to enable a static ip address.

I have disabled the Zonealarm fire wall on the office machine.

I have googled for many articles on setting up tunneling with products like SecureCRT, Putty, etc.

I find it VERY confusing to understand which machine (home or office) I am supposed to configure what and how, and which IP addresses I should be using.

But, when I simply use the Microsoft ODBC utility to define a DSN for my odbc, I can see that the connection is being refused by the remote machine.

I also found a commandline TCP command which will test the actual port (e.g. 192.99.0.6:3306 making up an example quad address).

I am guessing that on both machines, home and office, I must configure the Westel modem to allow a fixed IP address. But I suspect that there are other obscure places in the operating system, where I should be allowing or enabling something.

I would be most happy if I could find a host for mysql, which would allow remote access via myodbc in vba.

It would be helpful to see a step by step instructions, explicitly saying:

ON THE OFFICE (mysql server machine), you configure SecureCRT in THIS fashion (and clearly state which machines IP address is referenced, or whether it is 127.0.0.1 local host).

ON THE HOME (client odbc excel app), you configure SecureCRT in SOME OTHER FASHION, being very clear about where to put which ip address of which machine.

The instructions that I do manage to find in google seem to address themselves to an audience which is already highly skilled and versed in various terminology.

What I am trying to accomplish should not be rocket science, I should think. I mean, products like logmein.com seem to install in a snap of easiness.

Someone should create a wizard of sorts, to configure a remote and a server machine, so that the average man in the street might be able to do these things without hours of struggling.

Thanks so much in advance, for any help or suggestions.
Reply With Quote
  #4  
Old 04-26-2008, 11:30 AM
Karebac Karebac is offline
Registered User
 
Join Date: Apr 2008
Posts: 10
Quote:
Originally Posted by tnygren
Hi Karebac,

I just have a couple questions.

You mentioned that SecureCRT is installed on both machine but no mention of a server on either machine for SecureCRT to connect to.

Are there any SSH2 or telnet servers on the machines?

Were you needing a remote desktop type connection or just command line access?
I am not knowledgeable enough to understand your question. To my knowledge no such server is installed. Should I be installing some other kind of software as well?
Reply With Quote
  #5  
Old 04-28-2008, 05:23 AM
Karebac Karebac is offline
Registered User
 
Join Date: Apr 2008
Posts: 10
I did find some solution to 3306 mysql

I have not yet been able to get securecrt or tunneling to my desktops to work, but I did find a free mysql host who allows remote access to one's mysql through port 3306. That got my Excel VBA working easily via myodbc. I would post the site, but I know forums like this would consider it spaming. I did find a few hosts who offer remote 3306 port access to mysql. I shall continue to try to get tunneling to work.

Thanks for whatever advice you may provide.
Reply With Quote
  #6  
Old 04-28-2008, 09:19 AM
tnygren's Avatar
tnygren tnygren is offline
Registered User
 
Join Date: May 2005
Posts: 1,408
Hi Karebac,

Thanks for all the information!

In order to establish a SSH2 connection, there needs to be both a SSH2 client (like SecureCRT) to initiate the SSH2 connection and a SSH2 server on the remote machine (like VShell) to accept the connection.

In this case, there isn't a SSH2 server on the remote machine to accept the connection from SecureCRT. This is why the connection refused error occurring.

If a SSH2 server is installed on the remote machine, does the connection from SecureCRT succeed?
__________________
Thanks,

Teresa

Teresa Nygren
Reply With Quote
  #7  
Old 04-28-2008, 11:15 PM
Karebac Karebac is offline
Registered User
 
Join Date: Apr 2008
Posts: 10
Quote:
Originally Posted by tnygren
Hi Karebac,

Thanks for all the information!

In order to establish a SSH2 connection, there needs to be both a SSH2 client (like SecureCRT) to initiate the SSH2 connection and a SSH2 server on the remote machine (like VShell) to accept the connection.

In this case, there isn't a SSH2 server on the remote machine to accept the connection from SecureCRT. This is why the connection refused error occurring.

If a SSH2 server is installed on the remote machine, does the connection from SecureCRT succeed?
You are helping me to see that I need somthing on both machines, but I am slightly confused now. OK suppose I have secureCRT running on my home desktop.

Should I also have secureCRT running on the office machine, where the mysql server is. You confuse me by mentioning VShell.

Next confusion: How exactly would I configer Vshell or securecrt on the office machine? What parameters would I set.

I have been playing with various sofwares and machines for hours at a time, for days now. I contacted my Verizon DSL support to see if there is some way I could reconfigure the Westell modem. I totally uninstalled the firewall I had, which helped in certain things.

As a side note, I did find a free mysql host which allows me to remotely log in to their server through port 3306, which allows me to do exactly what I want, namely remove access mysql with excel vba as a front end. But I would still like to see if I could do it with an office machine.

So, I shall be hunting aroung for this VSHELL of which you speak. Each new shred of information brings me a little closer to possibly having success.

I also, today, subscribed to one of those no-ip services, but I have not seen any improvement from it.

So, you are saying that if I intall VSHELL on the office mysql server, and securecrt on my home machine, then, my home machine using excel vba odbc can access port 3306 on the office machine. Any step by step details would greatly help.
Reply With Quote
Reply

Thread Tools
Display Modes

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 On
HTML code is Off

Forum Jump


All times are GMT -6. The time now is 12:47 PM.