Re: Weird linux DBI::Informix problem !!!!
Posted in 2000
Topics: Installation, Setup & Upgrades, Connectivity: ESQL/C, 4GL & Embedded SQL, Security, Permissions & Auditing, Networking & sqlhosts Configuration, Platform-Specific Issues, Third-Party Tools & Monitoring
ok, I found the problem ....
I have to use "onsoctcp" nettype ... Maybe TLI (is that sun's Transport
Level Interface ???) is not ported to linux ...
uh....my boss gets quiet...
> hi all ...
>
> here is my problem : I downloaded the csdk for linux (intraware.com) to
> install it on my box, and i *always* get this fuc... message when
> running "perl Makefile.PL"
> SQL: 25507: The specified service name or protocol is unknown.
>
> Fuck ! the service typed in sqlhosts is present in /etc/services, and it
> is good !!!! WHY THAT !!! spent a whole day on day on that and I cannot
> get it to work ...... PLEASE I DO NEED HELP, or I won't be paied !
>
> the conf is :
> IDS2K (IUS 9.21) on a sun ( uname -a = SunOS soleil1 5.7
> Generic_106541-04 sun4u sparc SUNW,UltraSPARC-IIi-cEngine)
> my box is: Linux eq_047 2.2.15-4mdk #1 Wed May 10 15:31:30 CEST 2000
> i686 unknown
> Perl v5.6.0 built for i386-linux
> DBD-Informix-1.00.PC1
> DBI-1.14
>
> ~informix/etc/sqlhosts:
> soleil1_ids2k ontlitcp 192.168.1.41 equoddbs
> soleil1_sdi2k onipcshm 192.168.1.41 equodshm>
> /etc/services:
> [...]
> equoddbs 1543/tcp # Informix data server soleil1
> cockpit 1547/tcp # Informix monitoring tool
>
> And, before all that, I source the following file: (bash)
> export INFORMIXDIR=/opt/informix
> export INFORMIXSERVER=soleil1_ids2k> export
> PATH=${PATH}:/opt/informix/bin:/opt/informix/lib:/opt/informix/lib/esql
> export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:${PATH}> export LD_RUN_PATH=${LD_LIBRARY_PATH}
> export SHLIB_PATH=${PATH}
> export LIBPATH=${SHLIB_PATH}
> export DBI_DBNAME=test@soleil1_ids2k
> export DBD_INFORMIX_DATABASE=test
> export DBD_INFORMIX_USERNAME=informix
> export DBD_INFORMIX_PASSWORD=<try to guess>
> export DBD_INFORMIX_DATABASE2=test2
> export DBD_INFORMIX_USERNAME2=hgouhier
> export DBD_INFORMIX_PASSWORD2=<you wont get it too...>
>
> Please ! my boss is really pissing me off !
>
> Thanks !