RE: configuring sqlexecd for remote tcp connections.. problems

Too late ? You specifiled setlitcp on the SERVER. >localse_remote setlitcp coca 1526 But you specified ontlitcp on the Client. >localse_remote oltlitcp coca 1526 Change setlitcp on the client. -25507 means: You specified an unknown service name or protocol. Regards. -- Tsutomu Ogiwara from Tokyo Japan. >From: matthewlenz@gmail.com >Reply-To: matthewlenz@gmail.com >To: informix-list@iiug.org >Subject: configuring sqlexecd for remote tcp connections.. problems :( >Date: 2 Nov 2005 14:51:15 -0800 > >server: sco osr 5.0.6 >db server: informix 7.24.UC10 (output from dbaccess -v) > >client: debian sarge 3.1 linux >db client: informix clientsdk 2.90.UC3 > >database I wanna connect to is called 'local_se' when I use dbaccess >from the command line on the server. > >I'd like to verify my settings with you guys to see if you spot any >issues: > >here are the contents of the $INFORMIXDIR/etc/sqlhosts on the SERVER >after I added the last line: > >demo_on onipcshm on_hostname on_servername>demo_se seipcpip se_hostname sqlexec >tms_se sesoctcp coca sqlserv >local_se seipcpip coca sqlexec >localse_remote setlitcp coca 1526 > >I have no idea what the other entries before mine are about. 'coca' is >the alias in /etc/hosts for the system ip of the server. and I started >the sqlexecd with the following command in the $INFORMIXDIR/lib >directory: > >./sqlexecd localse_remote > >it started just fine and verified that it was running with a ps -Ae and >I could: > >telnet coca 1526 > >and see that it was establishing a tcp connection. > >.... > >here are the contents of my $INFORMIXDIR/etc/sqlhosts on the CLIENT >after I added the last line: > >demo_on onipcshm on_hostname on_servername>demo_se seipcpip se_hostname sqlexec >localse_remote oltlitcp coca 1526> >I'm using (perl) DBD::Informix (this problem doesn't seem DBD::Informix >related) and according to the docs it uses the TLI connect method. >Yes, I also added the coca alias to the /etc/hosts on the client as >well. > >$dbh = DBI->connect("dbi:Informix:local_se@localse_remote", "", "") > >is the only code I added and I'm getting errors about: > >-25596: The INFORMIXSERVER value is not listed in the sqlhosts file or>the Registry. > >so I set the INFORMIXSERVER value to 'localse_remote' and >INFORMIXSQLHOSTS value to "$INFORMIX/etc/sqlhosts" for good measure and >removed the @localse_remote from the connect command. Running the same >perl code again I then received: > >-25507: <Failed to locate SQL error message>> >my guess was this is just because i'm connecting to such an old version >of informix with the newest clientsdk. I did some searching and it >looks like its something along the same lines about not finding the >correct information in the sqlhosts file. > >What did I do wrong guys? I'd really appreciate any help you can offer. > >-Matt sending to informix-list