I don't think anyone said anything about ACS.... nsfreetds is an AOLServer module.
On 8/25/05, Mark Aufflick <[EMAIL PROTECTED]> wrote: > I know this is a late followup, but I was just reading up on > sybase/aolserver connectivity and came across this thread. > > Are you saying that you are trying to run ACS/OpenACS on Sybase/MSSQL ? > Classic ACS only runs on Oracle 8 and OpenACS only runs on Postgresql > 7.x or Oracle 8/9 (exact versions vary slightly betweeen ACS/OpenACS > releases). > > OpenACS has a cross-db framework to allow it to support multiple > databases but you would have *extreme* difficulties porting it to > Sybase or MSSQL! > > -- > Mark Aufflick > e: [EMAIL PROTECTED] > w: www.pumptheory.com (business) > w: mark.aufflick.com (personal) > p: +61 438 700 647 > f: +61 2 9436 4737 > > On 26/05/2005, at 11:29 PM, Cory Grimster wrote: > > > That's right. I found the line in the ACS bootstrapper that checks out > > all your database pools, and it is throwing the error. > > > > I tried to access the freetds database using the ns_db API and it works > > :) The ACS problems are another issue entirely. nsfreetds itself is > > working. > > > > Thanks very much to everyone who helped! > > > > -Cory > > > > > > Keith Paskett wrote: > >> I think this is from ACS or OpenACS which try to figure out what what > >> database is being used and call ns_oracle, ns_postgres, etc. instead > >> of ns_db. > >> > >> Vlad Seryakov wrote: > >> > >>> Who is logging this message, i could not find it in FReeTDS and AS? > >>> Is this your application? > >>> Notice: Database API: couldn't determine RDBMS type of database pool > >>> "pool4". > >>> > >>> Cory Grimster wrote: > >>> > >>>> ndsfreetds.so seems to load fine: > >>>> > >>>> Notice: Db_DriverInit(freetds): Loaded FreeTDS Driver v0.5, freetds > >>>> v0.63 > >>>> > >>>> It looks like the server is able to connect to the database, but > >>>> something goes wrong after that: > >>>> > >>>> Notice: dbdrv: opening database 'freetds:fooserver' > >>>> Notice: Db_Msg_Handler(osaka): Changed database context to bardb'. > >>>> Notice: Db_Msg_Handler(osaka): Changed language setting to > >>>> us_english. > >>>> Notice: Database API: couldn't determine RDBMS type of database pool > >>>> "pool4". > >>>> > >>>> > >>>> Vlad Seryakov wrote: > >>>> > >>>>> Do you have any errors at the server startup associated with > >>>>> nsfreetds? > >>>>> Also, every time i open nsdb with freetds, i issue "use database" > >>>>> to > >>>>> open appropriate > >>>>> SQL server database to use. > >>>>> > >>>>> Cory Grimster wrote: > >>>>> > >>>>>> I've tried FreeTDS 0.63 with Vlad's modified version of nsfreetds > >>>>>> and am > >>>>>> still getting a database configuration error page, this time > >>>>>> telling me > >>>>>> that ACS "could not determine the RDBMS type associated with pool > >>>>>> "pool4".". > >>>>>> > >>>>>> FreeTDS itself is configured correctly; after following Ian's > >>>>>> advice > >>>>>> (thanks!) about typing "go;" after each SQL command at the tsql > >>>>>> prompt, > >>>>>> I can select a database and run simple queries. > >>>>>> > >>>>>> I appreciate the advice and am happy to have tsql returning > >>>>>> results :) > >>>>>> If anyone has any further ideas on what might be keeping nsfreetds > >>>>>> from > >>>>>> working I'd love to hear them :) > >>>>>> > >>>>>> Thanks for all the help so far, > >>>>>> > >>>>>> -Cory > >>>>>> > >>>>>> > >>>>>> Vlad Seryakov wrote: > >>>>>> > >>>>>>> Try newest FreeTDS 0.63 with my modified nsfreetds driver. > >>>>>>> > >>>>>>> http://cvs.sourceforge.net/viewcvs.py/naviserver/modules/ > >>>>>>> nsfreetds/ > >>>>>>> > >>>>>>> It does not support interfaces anymore, use freetds.conf and > >>>>>>> describe > >>>>>>> datasource there. > >>>>>>> > >>>>>>> ---- nsd.tcl > >>>>>>> > >>>>>>> ns_section "ns/db/pool/cbill" > >>>>>>> ns_param driver freetds > >>>>>>> ns_param connections 10 > >>>>>>> ns_param user cbill > >>>>>>> ns_param password cbill > >>>>>>> ns_param datasource Billing > >>>>>>> ns_param verbose Off > >>>>>>> ns_param logsqlerrors On > >>>>>>> ns_param maxidle 31536000 > >>>>>>> > >>>>>>> ---- freetds.conf > >>>>>>> [Billing] > >>>>>>> host = cbill > >>>>>>> port = 1433 > >>>>>>> tds version = 7.0 > >>>>>>> > >>>>>>> Cory Grimster wrote: > >>>>>>> > >>>>>>>> Hi everyone, > >>>>>>>> > >>>>>>>> I'm having trouble getting nsfreetds running, and I'm hoping > >>>>>>>> that > >>>>>>>> someone can spot what I'm doing wrong. I noticed that several > >>>>>>>> people on > >>>>>>>> the list have gotten it working at various times, so I assume > >>>>>>>> it's > >>>>>>>> just me. > >>>>>>>> > >>>>>>>> I'm using nsfreetds 0.4 with FreeTDS 0.6.1.2 (newer versions of > >>>>>>>> FreeTDS > >>>>>>>> won't compile on this server) and AOLserver 4.0.10 > >>>>>>>> running on Mandrake 10.0. I'm trying to connect to Microsoft > >>>>>>>> SQLServer > >>>>>>>> Desktop Engine 2000 SP4 running on my Windows XP workstation. > >>>>>>>> I'm > >>>>>>>> getting the "could not allocate a handle from database pool > >>>>>>>> "pool4"" > >>>>>>>> error page when I hit my site. > >>>>>>>> > >>>>>>>> I can connect to the SQL server with tsql, though it doesn't > >>>>>>>> give me > >>>>>>>> any > >>>>>>>> output when I type in SQL commands. Not sure what that's about. > >>>>>>>> Authentication works fine, and it rejects me if I don't give it > >>>>>>>> the > >>>>>>>> correct credentials. Anyway, I'm assuming that it works for now > >>>>>>>> and am > >>>>>>>> trying to get nsfreetds working. > >>>>>>>> > >>>>>>>> The relevent sections from my config.tcl (copied from the > >>>>>>>> nsfreetds > >>>>>>>> FAQ) > >>>>>>>> are as follows: > >>>>>>>> > >>>>>>>> ns_section ns/db/drivers > >>>>>>>> ns_param freetds ${bindir}/nsfreetds.so > >>>>>>>> > >>>>>>>> ns_section ns/db/pools > >>>>>>>> ns_param pool4 "FreeTDS Pool" > >>>>>>>> > >>>>>>>> ns_section ns/db/pool/pool4 > >>>>>>>> ns_param maxidle 1000000000 > >>>>>>>> ns_param maxopen 1000000000 > >>>>>>>> ns_param connections 5 > >>>>>>>> ns_param verbose $debug > >>>>>>>> ns_param extendedtableinfo true > >>>>>>>> ns_param logsqlerrors $debug > >>>>>>>> > >>>>>>>> ns_param driver freetds > >>>>>>>> ns_param datasource fooserver [also tried > >>>>>>>> fooserver:bardb] > >>>>>>>> ns_param user sa > >>>>>>>> ns_param password bazpassword > >>>>>>>> > >>>>>>>> ns_section ns/server/${server}/db > >>>>>>>> ns_param pools "*" > >>>>>>>> ns_param defaultpool pool4 > >>>>>>>> > >>>>>>>> I have the SYBASE environment variable set to /usr/local/etc, > >>>>>>>> which is > >>>>>>>> where my interfaces file lives. It looks like this: > >>>>>>>> > >>>>>>>> fooserver > >>>>>>>> query tcp 8.0 192.168.42.107 1433 [I have tried protocol > >>>>>>>> version > >>>>>>>> 4.2 instead of 8.0 and it makes no difference] > >>>>>>>> > >>>>>>>> Hopefully someone can point me in the right direction. I've > >>>>>>>> been > >>>>>>>> banging my head against it for a few days now and I'm afraid > >>>>>>>> that > >>>>>>>> I'm > >>>>>>>> missing something obvious but am at a loss as to what it might > >>>>>>>> be. > >>>>>>>> > >>>>>>>> Thanks in advance, > >>>>>>>> > >>>>>>>> -Cory > >>>>>>>> > >>>>>>>> > >>>>>>>> -- > >>>>>>>> AOLserver - http://www.aolserver.com/ > >>>>>>>> > >>>>>>>> To Remove yourself from this list, simply send an email to > >>>>>>>> <[EMAIL PROTECTED]> with the > >>>>>>>> body of "SIGNOFF AOLSERVER" in the email message. You can leave > >>>>>>>> the > >>>>>>>> Subject: field of your email blank. > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> -- > >>>>>>> Vlad Seryakov > >>>>>>> 571 262-8608 office > >>>>>>> [EMAIL PROTECTED] > >>>>>>> http://www.crystalballinc.com/vlad/ > >>>>>>> > >>>>>>> > >>>>>>> -- > >>>>>>> AOLserver - http://www.aolserver.com/ > >>>>>>> > >>>>>>> To Remove yourself from this list, simply send an email to > >>>>>>> <[EMAIL PROTECTED]> with the > >>>>>>> body of "SIGNOFF AOLSERVER" in the email message. You can leave > >>>>>>> the > >>>>>>> Subject: field of your email blank. > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> -- > >>>>>> AOLserver - http://www.aolserver.com/ > >>>>>> > >>>>>> To Remove yourself from this list, simply send an email to > >>>>>> <[EMAIL PROTECTED]> with the > >>>>>> body of "SIGNOFF AOLSERVER" in the email message. You can leave > >>>>>> the > >>>>>> Subject: field of your email blank. > >>>>> > >>>>> > >>>>> > >>>>> > >>>>> > >>>>> -- > >>>>> Vlad Seryakov > >>>>> 571 262-8608 office > >>>>> [EMAIL PROTECTED] > >>>>> http://www.crystalballinc.com/vlad/ > >>>>> > >>>>> > >>>>> -- > >>>>> AOLserver - http://www.aolserver.com/ > >>>>> > >>>>> To Remove yourself from this list, simply send an email to > >>>>> <[EMAIL PROTECTED]> with the > >>>>> body of "SIGNOFF AOLSERVER" in the email message. You can leave the > >>>>> Subject: field of your email blank. > >>>> > >>>> > >>>> > >>>> > >>>> > >>>> -- > >>>> AOLserver - http://www.aolserver.com/ > >>>> > >>>> To Remove yourself from this list, simply send an email to > >>>> <[EMAIL PROTECTED]> with the > >>>> body of "SIGNOFF AOLSERVER" in the email message. You can leave the > >>>> Subject: field of your email blank. > >>> > >>> > >>> > >>> -- > >>> Vlad Seryakov > >>> 571 262-8608 office > >>> [EMAIL PROTECTED] > >>> http://www.crystalballinc.com/vlad/ > >>> > >>> > >>> -- > >>> AOLserver - http://www.aolserver.com/ > >>> > >>> To Remove yourself from this list, simply send an email to > >>> <[EMAIL PROTECTED]> with the > >>> body of "SIGNOFF AOLSERVER" in the email message. You can leave the > >>> Subject: field of your email blank. > >> > >> > >> -- > >> Keith Paskett [EMAIL PROTECTED] > >> Space Dynamics Laboratory Encrypted mail preferred > >> 1695 North Research Parkway 435-797-4195 > >> Logan, Utah 84341 > >> > >> > >> -- > >> AOLserver - http://www.aolserver.com/ > >> > >> To Remove yourself from this list, simply send an email to > >> <[EMAIL PROTECTED]> with the > >> body of "SIGNOFF AOLSERVER" in the email message. You can leave the > >> Subject: field of your email blank. > > > > > > -- > > AOLserver - http://www.aolserver.com/ > > > > To Remove yourself from this list, simply send an email to > > <[EMAIL PROTECTED]> with the > > body of "SIGNOFF AOLSERVER" in the email message. You can leave the > > Subject: field of your email blank. > > > > ======================================================================= > > = > > iBurst Wireless Broadband from $34.95/month www.platformnetworks.net > > Forward undetected SPAM to: [EMAIL PROTECTED] > > ======================================================================= > > = > > > > > -- > AOLserver - http://www.aolserver.com/ > > To Remove yourself from this list, simply send an email to <[EMAIL > PROTECTED]> with the > body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: > field of your email blank. > -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.
