IDS10 ODBC

I sucessfully installed IDS10 on SLES9 Linux. I try to connect via ODBC to this engine but I always get an "Unknown network error". On the windows side I uses a client sdk 2.9 Is it correct that I didnt see an open port 9088 on the unix ids10 machine ? thomas

What do you see when you telnet <server> <port> - do you get a connection - if you don't then the engine is not listening on the port you think it is Try using the utility dbping Cheers Paul Paul Watson Tel: +1 913-400-2620 Mob: +1 913-387-7529 Web: www.oninit.com Failure is not as frightening as regret. If you want to improve, be content to be thought foolish and stupid. > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > MICHAEL MEIER > Sent: 11 January 2008 10:23 > To: ids@iiug.org > Subject: IDS10 ODBC [10891] > > I sucessfully installed IDS10 on SLES9 Linux. I try to connect via ODBC > to > this engine but I always get an "Unknown network error". On the windows > side I > uses a client sdk 2.9 > Is it correct that I didnt see an open port 9088 on the unix ids10 > machine ? > > thomas > > > *********************************************************************** > ******** > Forum Note: Use "Reply" to post a response in the discussion forum. > > See you at the IIUG Informix 2008 Conference > The Power Conference for Informix Professionals > April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas > http://www.iiug.org/conf > Registration Now Open!!

Maybe you did not activate a TCP listener ? By default, only shared memory access is configured. You have to add a line like <Server_tcp> onsoctcp <hostname> <port>to the sqlhosts file and list Server_tcp as DBSERVERALIASES in onconfig. Then restart the engine and you will have a listen to that port. Marcus -----Original Message----- From: MICHAEL MEIER [mailto:freudi_t@yahoo.de] Sent: Friday, January 11, 2008 5:23 PM To: ids@iiug.org Subject: IDS10 ODBC [10891] I sucessfully installed IDS10 on SLES9 Linux. I try to connect via ODBC to this engine but I always get an "Unknown network error". On the windows side I uses a client sdk 2.9 Is it correct that I didnt see an open port 9088 on the unix ids10 machine ? thomas ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!!

I did all that. But my machine name and Serveralias is all the same. Should I put the IP in the sqlhosts file ? dbaccess is working, But if I try telnet localhost 9088 I get a "conection refused". Same from a other pc. I also studied the docs the whole weekend. But I did'nt found an answer.

Tried this. I got a "conection refused". May be the Express Edition did'nt allow connections from the network ?

Hi, You misunderstood the comments. In IDS, the standard setup is to establish a shared memory listener, which is sufficient für running local applications. You have to configure a second listener to support tcp connections. The listener has to be set in the sqlhosts file with type onsoctcp. To activate the listener, you have to put it as dbserveralias in onconfig. The listeners must have unique names so we usually name the tcp listener instance_name_tcp. The selected port is up to your decision. The port can be a name from /etc/services or a numeric port. It has to be unique and unused for the machine/instance (in case you run many instances). Marcus -----Original Message----- From: MICHAEL MEIER [mailto:freudi_t@yahoo.de] Sent: Monday, January 14, 2008 12:42 PM To: ids@iiug.org Subject: Re: RE: IDS10 ODBC [10899] I did all that. But my machine name and Serveralias is all the same. Should I put the IP in the sqlhosts file ? dbaccess is working, But if I try telnet localhost 9088 I get a "conection refused". Same from a other pc. I also studied the docs the whole weekend. But I did'nt found an answer. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!!

In my sqlconfig I already had a onsoctcp entry. But I maded a new one now. It looks like sles9 onsoctcp sles9 9088 sles9_tcp onsoctcp sles9 9089 DBSERVERNAME sles9 DBSERVERALIASES sles9odbc In the IBM-Informix ODBC Driver Setup (on the windows pc) now I can choose the new sles9_tcp in "Server Name" listbox. I also get errors if I misstype the host or the username. So there must be a data exchange with the server. But when I put in everything correct an click on the Database-listbox I get a "System error occured in network function". BTW I takes about a minute until the message comes up. I did'nt found anything in the server nor the client logs. Is there any strategy to come closer to the error ? Can I switch tcp-logging options on on the server ?

Hi, Can you connect on your Suse machine with dbaccess using this port ? export INFORMIXSERVER=sles9_tcp dbaccess In this case, the Windows installation is the problem. Marcus -----Original Message----- From: MICHAEL MEIER [mailto:freudi_t@yahoo.de] Sent: Tuesday, January 15, 2008 2:00 PM To: ids@iiug.org Subject: Re: RE: Re: RE: IDS10 ODBC [10908] In my sqlconfig I already had a onsoctcp entry. But I maded a new one now. It looks like sles9 onsoctcp sles9 9088 sles9_tcp onsoctcp sles9 9089 DBSERVERNAME sles9 DBSERVERALIASES sles9odbc In the IBM-Informix ODBC Driver Setup (on the windows pc) now I can choose the new sles9_tcp in "Server Name" listbox. I also get errors if I misstype the host or the username. So there must be a data exchange with the server. But when I put in everything correct an click on the Database-listbox I get a "System error occured in network function". BTW I takes about a minute until the message comes up. I did'nt found anything in the server nor the client logs. Is there any strategy to come closer to the error ? Can I switch tcp-logging options on on the server ? ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!!

Yes I can. So windows should be the problem. But because it takes while and the odbc-client takes with the server, maybe a server log can help , too.

Is the Windows Firewall activated? regards, Joerg Volz @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ IT Handel und Beratung Jörg Volz Bernhard-Früh-Strasse 7 77855 Achern GERMANY SteuerNr: 01220/17000 Tel: +49 (0) 7841-681651 Fax: +49 (0) 7841-681654 Mobil: +49 (0) 170-2989757 http://www.it-volz.de <https://gate.it-volz.de/exchweb/bin/redir.asp?URL=http://www.it-volz.de>; ################################################# ________________________________ Von: ids-bounces@iiug.org im Auftrag von MICHAEL MEIER Gesendet: Di 15.01.2008 17:10 An: ids@iiug.org Betreff: Re: RE: Re: RE: Re: RE: IDS10 ODBC [10912] Yes I can. So windows should be the problem. But because it takes while and the odbc-client takes with the server, maybe a server log can help , too. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! IT Handel und Beratung Jörg Volz Bernhard-Früh-Str. 7 77855 Achern GERMANY Tel: 07841-681651 Fax: 07841-681654 Mobil: 0170-2989757 Ust-ID: DE201383541 http://www.it-volz.de

No. I used to have Zonealarm but I deactivated too. I just start to build a VM with a fresh WinXP SP2 Installation. Too that there is no Debug nor Logoption for the TCP connect in the server.

Hi Michael, Can you post this information: on suse box, as root enter Ifconfig command and post output. Next enter netstat -an | grep 908[89] and post output. Also, please check is firewall (ipchaiuns or iptables) running on suse box. For iptables enter command iptables -L and if you see list of rules - that means iptables firewall is running. Next, please post content of sqlhost file (NOT SQLCONFIG as you wrote) Next, as informix user please enter onstat -g nttand post output On win box, open cmd and type ipconfig /all and post ouput here. Next step is after you post this info Regards, Hrvoje -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of MICHAEL MEIER Sent: Wednesday, January 16, 2008 10:16 AM To: ids@iiug.org Subject: Re: AW: RE: Re: RE: Re: RE: IDS10 ODBC [10927] No. I used to have Zonealarm but I deactivated too. I just start to build a VM with a fresh WinXP SP2 Installation. Too that there is no Debug nor Logoption for the TCP connect in the server. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!!

Sorry for late answer, I tried some things in between and my internet provider cutted my DSL Line. Have some trouble... Unix: sqlhosts: sles9 onsoctcp sles9 9088 sles9odbc onsoctcp sles9 9089 ifconfig: eth0 Link encap:Ethernet HWaddr 00:0C:29:72:94:E7 inet addr:192.168.2.236 Bcast:192.168.2.255 Mask:255.255.255.0 inet6 addr: fe80::20c:29ff:fe72:94e7/64 Scope:Link UP BROADCAST NOTRAILERS RUNNING MULTICAST MTU:1500 Metric:1 RX packets:73 errors:0 dropped:0 overruns:0 frame:0 TX packets:80 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:9688 (9.4 Kb) TX bytes:9341 (9.1 Kb) Interrupt:10 Base address:0x1400 lo Link encap:Local Loopback inet addr:127.0.0.1 Mask:255.0.0.0 inet6 addr: ::1/128 Scope:Host UP LOOPBACK RUNNING MTU:16436 Metric:1 RX packets:115 errors:0 dropped:0 overruns:0 frame:0 TX packets:115 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:0 RX bytes:7637 (7.4 Kb) TX bytes:7637 (7.4 Kb) iptables: Chain INPUT (policy ACCEPT) target prot opt source destination Chain FORWARD (policy ACCEPT) target prot opt source destination Chain OUTPUT (policy ACCEPT) target prot opt source destination onstat as informix: IBM Informix Dynamic Server Version 10.00.UC7E -- On-Line -- Up 00:16:02 --19512 Kbytes global network information: #netscb connects read write q-free q-limits q-exceed alloc/max 3/ 3 0 0 0 0/ 0 134/ 10 0/ 0 0/ -1 Individual thread network information (times): netscb thread name sid open read write address 44b348d0 soctcplst 4 14:16:11 sles9|9089|soctcp 44b06cb0 soctcplst 3 14:16:11 sles9|9088|soctcp 44b078d0 soctcppoll 2 14:16:11 Windows: Freh installet WinXp with SP2, No other software, Windowsfirewall is off, Ican ping sles9 I'm using IBM Connect 3.0 Setnet 3.00 3.00.TC2DE Informixdir=C:\\\\Programme\\\\IBM\\\\Informix\\\\Connect\\\\ I also set this as enviroment variable Informixserver=sles9 User=Informix Password=password Connection TAB in IBM Informix ODBC Driver Servername sles9odbc Hostname sles9 Service 9089 Protocol onsoctcp User Id informix Password password If I click on Databaselistbox I got a 1 minute timeout and then [Informix][Informix ODBC Driver][Informix]System error occured in network function ipconfig: Windows-IP-Konfiguration Hostname. . . . . . . . . . . . . : VM Primäres DNS-Suffix . . . . . . . : Knotentyp . . . . . . . . . . . . : Unbekannt IP-Routing aktiviert. . . . . . . : Nein WINS-Proxy aktiviert. . . . . . . : Nein DNS-Suffixsuchliste . . . . . . . : vm-local Ethernetadapter LAN-Verbindung: Verbindungsspezifisches DNS-Suffix: vm-local Beschreibung. . . . . . . . . . . : VMware Accelerated AMD PCNet Adapter Physikalische Adresse . . . . . . : 00-0C-29-4F-1D-7F DHCP aktiviert. . . . . . . . . . : Ja Autokonfiguration aktiviert . . . : Ja IP-Adresse. . . . . . . . . . . . : 192.168.2.235 Subnetzmaske. . . . . . . . . . . : 255.255.255.0 Standardgateway . . . . . . . . . : 192.168.2.1 DHCP-Server . . . . . . . . . . . : 192.168.2.1 DNS-Server. . . . . . . . . . . . : 192.168.2.1 194.29.226.17 194.29.230.17 Lease erhalten. . . . . . . . . . : Freitag, 18. Januar 2008 13:13:42 Lease läuft ab. . . . . . . . . . : Freitag, 18. Januar 2008 15:13:42

Meanwhile I tried tcpdump on the unix machine.I saw only incomimg packages from the windows machine, no answers. But there are listener for the ports. netstat: tcp 0 0 sles9:9088 *:* LISTEN tcp 0 0 sles9:9089 *:* LISTEN tcp 0 0 sles9:svrloc *:* LISTEN udp 0 0 sles9:netbios-ns *:* udp 0 0 sles9:netbios-dgm *:* udp 0 0 sles9:svrloc *:* udp 0 0 sles9:mdns *:* should there be some configuration in which the allowed hosts are listed ???

anything in the online log file? DNS ist working for Server and PC? (and the same DNS server) Joerg Volz ________________________________ Von: ids-bounces@iiug.org im Auftrag von MICHAEL MEIER Gesendet: Fr 18.01.2008 14:32 An: ids@iiug.org Betreff: Re: RE: AW: RE: Re: RE: Re: RE: IDS10 ODBC [10984] Meanwhile I tried tcpdump on the unix machine.I saw only incomimg packages from the windows machine, no answers. But there are listener for the ports. netstat: tcp 0 0 sles9:9088 *:* LISTEN tcp 0 0 sles9:9089 *:* LISTEN tcp 0 0 sles9:svrloc *:* LISTEN udp 0 0 sles9:netbios-ns *:* udp 0 0 sles9:netbios-dgm *:* udp 0 0 sles9:svrloc *:* udp 0 0 sles9:mdns *:* should there be some configuration in which the allowed hosts are listed ??? ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! IT Handel und Beratung Jörg Volz Bernhard-Früh-Str. 7 77855 Achern GERMANY Tel: 07841-681651 Fax: 07841-681654 Mobil: 0170-2989757 Ust-ID: DE201383541 http://www.it-volz.de

MICHAEL MEIER wrote: Once a connection is established, IDS and the client communicate on a dynamically assigned port. The sqlhosts ports/services are only used for initial connection requests, so you'll only see LISTEN and CONNECT traffic on them. Art S. Kagel > Meanwhile I tried tcpdump on the unix machine.I saw only incomimg packages > from the windows machine, no answers. But there are listener for the ports. > > netstat: > tcp 0 0 sles9:9088 *:* LISTEN > tcp 0 0 sles9:9089 *:* LISTEN > tcp 0 0 sles9:svrloc *:* LISTEN > udp 0 0 sles9:netbios-ns *:* > udp 0 0 sles9:netbios-dgm *:* > udp 0 0 sles9:svrloc *:* > udp 0 0 sles9:mdns *:* > > should there be some configuration in which the allowed hosts are listed ??? > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > See you at the IIUG Informix 2008 Conference > The Power Conference for Informix Professionals > April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas > http://www.iiug.org/conf > Registration Now Open!! > > ================================================================================ =========== > Please access the attached hyperlink for an important electronic communications disclaimer: > > http://www.oninit.com/home/disclaimer.php > > ================================================================================ =========== > > ================================================================================ =========== Please access the attached hyperlink for an important electronic communications disclaimer: http://www.oninit.com/home/disclaimer.php ================================================================================ ===========

That's interesting. So I may have to analyze the tcpdump for a portnumber that it exchanged ? Or are there rules for the next portnumber ?

Thats one of my question. In the file /usr/informix/online.log I only have one msg: "Server started". In the ISA Web interface I have some more messages but none related to any tcp communication. Maybe I can switsch that on, but I did'nt found something in onconfig.

MICHAEL MEIER wrote: > That's interesting. So I may have to analyze the tcpdump for a portnumber that > it exchanged ? Or are there rules for the next portnumber ? > No rules that I'm aware of, though in my experience, they tend to be in the 22000+ range. Art S. Kagel Oninit > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > See you at the IIUG Informix 2008 Conference > The Power Conference for Informix Professionals > April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas > http://www.iiug.org/conf > Registration Now Open!! > > ================================================================================ =========== > Please access the attached hyperlink for an important electronic communications disclaimer: > > http://www.oninit.com/home/disclaimer.php > > ================================================================================ =========== > > ================================================================================ =========== Please access the attached hyperlink for an important electronic communications disclaimer: http://www.oninit.com/home/disclaimer.php ================================================================================ ===========

Please send us then output of: netstat -anp |grep 9089 netstat -anp |grep 9088 And try this: Add an asterisk (*) to sqlhosts: sles9_tcp onsoctcp *sles9 9089 Restart informix after changing this. Jairo Gubler (Brazil) Art S. Kagel (Oninit LLC) escreveu: MICHAEL MEIER wrote: That's interesting. So I may have to analyze the tcpdump for a portnumber that it exchanged ? Or are there rules for the next portnumber ? No rules that I'm aware of, though in my experience, they tend to be in the 22000+ range. Art S. Kagel Oninit ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas [1]http://www.iiug.org/conf Registration Now Open!! =============================================================================== ============ Please access the attached hyperlink for an important electronic communications disclaimer: [2]http://www.oninit.com/home/disclaimer.php =============================================================================== ============ =============================================================================== ============ Please access the attached hyperlink for an important electronic communications disclaimer: [3]http://www.oninit.com/home/disclaimer.php =============================================================================== ============ ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas [4]http://www.iiug.org/conf Registration Now Open!! -- Jairo Gubler Supervisor SIC - TBD - Tecnologia em Banco de Dados DÍGITRO TECNOLOGIA E-mail: [5]jairo.gubler@digitro.com.br Fone: +55 48 3281-7213 / +55 48 3281-7000 Fax: +55 48 3281-7299 Site: [6]www.digitro.com References 1. http://www.iiug.org/conf 2. http://www.oninit.com/home/disclaimer.php 3. http://www.oninit.com/home/disclaimer.php 4. http://www.iiug.org/conf 5. mailto:jairo.gubler@digitro.com.br 6. http://www.digitro.com/

At the server side the TCP port of the connection is the same as the LISTEN port. A TCP connection is identified with 2 pairs address:port. Sample: netstat -anp |grep 1525 tcp 0 0 0.0.0.0:1525 0.0.0.0:* LISTEN - tcp 0 0 192.168.166.74:1525 192.168.166.74:49732 ESTABLISHED - tcp 0 0 192.168.166.74:1525 192.168.170.147:49260 ESTABLISHED - tcp 0 0 192.168.166.74:1525 192.168.170.141:2330 ESTABLISHED Jairo Gubler Art S. Kagel (Oninit LLC) escreveu: MICHAEL MEIER wrote: That's interesting. So I may have to analyze the tcpdump for a portnumber that it exchanged ? Or are there rules for the next portnumber ? No rules that I'm aware of, though in my experience, they tend to be in the 22000+ range. Art S. Kagel Oninit ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas [1]http://www.iiug.org/conf Registration Now Open!! =============================================================================== ============ Please access the attached hyperlink for an important electronic communications disclaimer: [2]http://www.oninit.com/home/disclaimer.php =============================================================================== ============ =============================================================================== ============ Please access the attached hyperlink for an important electronic communications disclaimer: [3]http://www.oninit.com/home/disclaimer.php =============================================================================== ============ ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas [4]http://www.iiug.org/conf Registration Now Open!! -- Jairo Gubler Supervisor SIC - TBD - Tecnologia em Banco de Dados DÍGITRO TECNOLOGIA E-mail: [5]jairo.gubler@digitro.com.br Fone: +55 48 3281-7213 / +55 48 3281-7000 Fax: +55 48 3281-7299 Site: [6]www.digitro.com References 1. http://www.iiug.org/conf 2. http://www.oninit.com/home/disclaimer.php 3. http://www.oninit.com/home/disclaimer.php 4. http://www.iiug.org/conf 5. mailto:jairo.gubler@digitro.com.br 6. http://www.digitro.com/