using visual dba/ingres net on home wireless network

[schma01]

Hi:

I work from home and use a linksys wireless router for my home wireless network. I am trying to hook up Visual Dba and SquirrelSQL (which I have running on windows) to an installation I have running on Fedora.

I've tried setting up a node w/ netutil, but when I test it, it hangs for awhile then says this:

I get "Unable to establish network connection"

The error log shows this:
Mon Mar 15 14:16:52 2010 E_CL2781_GC_CONNECT_FAIL An attempted network connection failed
SCHMA01-D620 ::[EW\COMSVR\b898 , 47256 , 00000001]: connect() failed with operating system error 1232 (The network location cannot be reached. For information about network troubleshooting, see Windows Help.)

I can ping the linux box from my windows machine just fine. I've also verified that rmcmd is running on the linux box.

I've messed with this before and it seems it has been suggested that I have some sort of firewall issue.

I really don't know that much about netowrking. Has anyone else tried this at home in a similar configuration. I would appreciate any ideas.

Thanks,
Mary

[paulfwhite]

Hi Mary,
If you have used the default installation code II, then ingres net will be trying to use port 21064.

From your PC try using telnet to connect the the DBMS server.
First click Start, Run, then type cmd and press Enter.
In the DOS Command window type
telnet 10.10.10.123 21064
You should get a blank screen. Press Enter and the dos prompt will return.

As a comparison try using a different port say 21065. the message should read sopmething like this:
Connecting To 10.10.10.123...Could not open connection to the host, on port 21065: Connect failed

Do you know if you are running a firewall on linux?
What firewall are you running on your PC?
Do you know how to look at the firewall logs?

Paul

[schma01]

Thanks for all the hints!

I was able to get things working by disabling the linux firewall.

My installation code is actually EW. How does one calculate the port number based on the installation code?

Thanks for any information.

Mary

[thoda04]

Hi Mary,

You can look at the Ingres log on installation start-up and it will display the number of each of the ports as the Ingres servers listen on.

Hope this helps,
Dave

[bilgihan]

Once you have configured the listen address, you can get related tcp_ip port from errlog.log:
grep E_GC2815 $II_SYSTEM/ingres/files/errlog.log | grep ew | tail -1
..... E_GC2815_NTWK_OPEN Network open complete for protocol TCP_IP, port ew (19128).

[teresa]

Hi Mary,

In addition to finding this info from the errlog.log, information about mapping Ingres installation codes to ports is available at Ingres TCP Ports - Ingres Community Wiki - this is linked from Ingres Articles - Ingres Community Wiki

Hope this helps.

Teresa