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.
