Keith, It works geat!!..I re-configured the AOL web server to look at Internal driver (iusid.so). Right now, I am able to access the data from Informix database. I have a question, though. Can I use all ns_** functions that provided by AOL web server? I have a error message when I tried to use ns_getrow function. Any ideas?
Thanks a lot!..I really appreciate your help. -Durga -----Original Message----- From: AOLserver Discussion [mailto:[EMAIL PROTECTED]]On Behalf Of Keith Paskett Sent: Thursday, November 21, 2002 6:09 PM To: [EMAIL PROTECTED] Subject: Re: [AOLSERVER] Informix Drivers For what it's worth I never got the external driver working. I don't remember what the issues were but I didn't spend much time on it because I really wanted the internal driver iusid.so Keith On Thu, Nov 21, 2002 at 10:06:55AM -0700, Durga wrote: > Thanks, Keith, Pete. > > Here is the information about my system: > > * Operating System: SunOS 5.7 Generic_106541-18 sun4u sparc SUNW,Ultra-1 > * Informix: Informix Dynamic Server Version 9.30.UC3 -- On-Line -- Up 1 > * AOL server: 3.5 > * tcl: 8.4b2 > * AOL server and Informix are on same machine. > > I have checked the /etc/services and $INFORMIXDIR/etc/sqlhosts, everything > is set as you mentioned. > > nsd.tcl - AOL config file: > > # Database drivers > ns_section "ns/db/drivers" > ns_param informix_driver nsext.so; > > ns_section "ns/db/driver/informix_driver" > ns_param localdaemon iuspd; > > ns_section "ns/db/pools" > ns_param informix_pool "Informix Pool"; > > ns_section "ns/db/pool/informix_pool" > ns_param driver informix_driver > ns_param datasource pmdb_tcp:pmdb > ns_param user www > ns_param password ****** > ns_param connections 1 > ns_param logsqlerrors true > ns_param verbose false > ns_param maxidle 600 > ns_param maxopen 3600 > > ns_section "ns/server/${servername}/db" > ns_param pools * > ns_param defaultpool informix_pool > > Also, in aolserver bin directory: > /users/WWW/AOL/aolserver_3.5$ ls -l bin > -rw-r--r-- 1 www www 2255 Oct 24 14:18 install-sh > -rwxrwxrwx 1 www www 30989 Nov 19 23:38 iusid.so > -rwxrwxrwx 1 www www 2124918 Nov 19 23:39 iuspd > -rwxrwxrwx 1 www www 115928 Oct 24 14:19 nscgi.so > -rwxrwxrwx 1 www www 95296 Oct 24 14:19 nscp.so > -rwxrwxrwx 1 www www 81724 Oct 24 14:19 nsd > -rwxrwxrwx 1 www www 143344 Oct 24 14:19 nsext.so > -rwxrwxrwx 1 www www 99016 Oct 24 14:19 nslog.so > -rwxrwxrwx 1 www www 116724 Oct 24 14:19 nsperm.so > -rwxrwxrwx 1 www www 102344 Oct 24 14:19 nssock.so > -rwxrwxrwx 1 www www 96000 Oct 24 14:18 nsthreadtest > -rwxr-xr-x 1 www www 6540 Oct 21 14:45 tclsh8.4 > -rwxrwxrwx 1 www www 7388 Nov 4 16:35 wish8.4 > > Is byte size looks normal for both "iusid.so" and "iuspd"? I did have some > problem while I was compiling this driver software, but they were just > syntax error's so changed them and then installation completed successfully. > I have used "gcc" and "gmake" to compile. > > I don't think it's a "gmake" problem. I already fixed that. > > -Durga > > -----Original Message----- > From: AOLserver Discussion [mailto:[EMAIL PROTECTED]]On Behalf > Of Keith paskett > Sent: Thursday, November 21, 2002 8:31 AM > To: [EMAIL PROTECTED] > Subject: Re: [AOLSERVER] Informix Drivers > > > Durga, > > It would help to know what your configuration is. > What version of Informix? Is it installed locally. How are you > authenticating > the user. > > Here's the configuration that works for me (Solaris 8 & 9). > > I'm accessing a remote Informix with the informix client software > installed in /usr/local/informix. I don't think the configuration > changes much if Informix is installed on the same box as AOLserver. > Unfortunately the Informix client software does not come with any way > to test the connection. So if you are accessing a remote server, it > is hard to know if failures are due to the AOLserver Informix driver > or the client installation / configuration. > > In /etc/services, you should have something like > soc1 1525/tcp #Informix data do not remove > > In /usr/local/informix/etc/sqlhosts, something like: > ids_eo_sun ontlitcp informixhost.your.domain soc1 > > I'm running ACS which uses Oracle but have hacked the ACS code so I can > access other databases (Informix and PostgreSQL) without interfering > with the way ACS gets database handles. > > Relevant sections of the AOS config file: > > ----- > # Datasource is of the form "connection:database" > # where connection is from /usr/local/informix/etc/sqlhosts > # User and Password are not used to authenticate (in our Informix setup) > # The user that AOLserver is running as needs to be authenticated > # in oracle without prompting for username and password. > ns_section ns/db/pool/noacs_eoffice > ns_param Driver informix > ns_param Connections 3 > ns_param DataSource "ids_eo_sun:eoffice" > ns_param User nsadmin > ns_param Password bogus > ns_param Verbose Off > ns_param LogSQLErrors On > > ns_section ns/db/pools > ns_param main main > ns_param subquery subquery > ns_param log log > ns_param noacs_pg1 noacs_pg1 > ns_param noacs_eoffice noacs_eoffice > > ns_section ns/server/$servicename/db > ns_param Pools main,subquery,log,noacs_pg1,noacs_eoffice > ns_param DefaultPool main > > ----- > > Since I'm using ACS, I've written procedures that match the functionality > of the ACS db_* procs and my test.tcl looks like the following. > Just use the ns_db procs instead of my nadb_* procs. > > -- > if [catch {ns_db gethandle noacs_eoffice} db] { > set eoffice_avail 0 > } else { > set eoffice_avail 1 > } > > if {$eoffice_avail} { > set sql "select value from test_table where id = 1" > nadb_string $db $sql -default "" > } else { > ... > } > > -- > > I'm only able to use one db hanldle in a page. You can get two handles > but you can't do an 'ns_db select' with handle2 in a loop that is using > 'ns_db getrow' to retrieve rows from an 'ns_db select' that used handle1. > > > Hope this helps. > Keith > > > | > |Now I have different ERROR message: > | > |************************ > |invoked from within chunk: 0 of adp: /pub/Pages/PM/TCL/web_example.adp > |[20/Nov/2002:15:24:34][1753.10][-keepalive-] Notice: keepalive: keepalive > |thread starting > |[20/Nov/2002:17:16:24][1753.25][-conn1-] Notice: dbdrv: opening database > |'informix_driver:pmdb_tcp:pmdb' > |[20/Nov/2002:17:16:25][1753.25][-conn1-] Error: exec: process 6534 exited > |from signal: 11 > |[20/Nov/2002:17:16:25][1753.25][-conn1-] Error: exec: process 6534 dumped > |core > |[20/Nov/2002:17:16:25][1753.25][-conn1-] Error: dbdrv: failed to open > |database 'informix_driver:pmdb_tcp:pmdb' > |[20/Nov/2002:17:16:25][1753.25][-conn1-] Error: > |could not allocate 1 handle from pool "informix_pool" > | while executing > |"ns_db gethandle" > | invoked from within chunk: 0 of adp: /pub/Pages/PM/TCL/web_example.adp > |************************* > | > |Any ideas? > | > |Thanks > |-Durga > | > |-----Original Message----- > |From: Durga [mailto:[EMAIL PROTECTED]] > |Sent: Wednesday, November 20, 2002 3:57 PM > |To: AOLserver Discussion > |Subject: RE: [AOLSERVER] Informix Drivers > | > | > |Thanks, Doosy. > | > |I did compile and install the driver software for Informix, and configured > |the AOLserver config file - nsd.tcl. However, I am not able to connect to > |database. I get the error message as: "ns_db is not enabled" > | > |Any ideas? > | > |Thanks, > |-Durga > > ------ > Keith Paskett [EMAIL PROTECTED] > Space Dynamics Laboratory PGP or GPG encrypted mail preferred > 1695 North Research Parkway 435-797-4195 > Logan, Utah 84341