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
