subject:"\[AOLSERVER\] nsfreetds"

Re: [AOLSERVER] nsfreetds

2005-08-25 Thread Ian Harding

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_paramdriver  freetds
> >>> ns_paramconnections 10
> >>> ns_paramusercbill
> >>> ns_parampasswordcbill
> >>> ns_paramdatasource  Billing
> >>> ns_paramverbose Off
> >>> ns_paramlogsqlerrorsOn
> >>> ns_parammaxidle 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 AOL

Re: [AOLSERVER] nsfreetds

2005-08-25 Thread Mark Aufflick

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_paramdriver  freetds
ns_paramconnections 10
ns_paramusercbill
ns_parampasswordcbill
ns_paramdatasource  Billing
ns_paramverbose Off
ns_paramlogsqlerrorsOn
ns_parammaxidle 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_paramfreetds${bindir}/nsfreetds.so

ns_section ns/db/pools
ns_parampool4  "FreeTDS Pool"

ns_section ns/db/pool/pool4
ns_parammaxidle10
ns_parammaxopen10
ns_paramconnections5
ns_paramverbose$debug
ns_paramextendedtableinfo  true
ns_paramlogsq

Re: [AOLSERVER] [Re: Re: [AOLSERVER] nsfreetds]

2005-06-06 Thread Ian Harding

One more thing I just ran into

I have a sybase function that I call with CALL keyword.  It does a few
updates, and returns.  After each update within the function, freetds
client receives a TDS_DONEINPROC_RESULT token.  The way nsfreetds is
written right now, the system seems to wait forever at some point (I
have not run that to ground) but commenting out TDS_DONEINPROC_RESULT
allows processing to continue until the function returns.  The result
of the function appears to be being processed correctly in the event
an error is thrown inside it.

I also fixed up my prior attempt at catching dead connections.

diff /home/iharding/nsfreetds.c ./nsfreetds.c
160c160,161
< Db_Cancel(handle);
---
> if (Db_Cancel(handle) == NS_ERROR)
> return NS_ERROR;
177,178c178,179
<
< Db_Cancel(handle);
---
> if (Db_Cancel(handle) == NS_ERROR)
> return NS_ERROR;
189d189
 if (Db_Cancel(handle) == NS_ERROR)
> return NS_ERROR;
268,269c269,278
< if(handle->fetchingRows) {
 if (IS_TDSDEAD(GET_TDS(handle))) {
> Ns_Log(Error, "Dead connection detected.");
> handle->statement = NULL;
> handle->fetchingRows = 0;
> handle->connected = NS_FALSE;
> return NS_ERROR;
> }
> if (handle->fetchingRows) {
> if (tds_process_simple_query(GET_TDS(handle)) == TDS_FAIL)
> Ns_Log(Error,"tds_process_simple_query failed!");
307a317
>


--
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.

Re: [AOLSERVER] nsfreetds

2005-05-31 Thread Ian Harding

OK, I got nsfreetds to do what I want it to do, but with a seeming
clumsy hack.  I honestly don't have any idea what I am doing.

MSSQL Server, using TDS 7.0 works great when a database connection
goes dead.  Sybase, using TDS 4.2 does not.  It merrily goes on trying
to talk to the server over the dead connection and keeps telling me it
can't write to the socket.

I noticed that tds_process_default_tokens notices the dead connection,
but the return code from tds_process_simple_query is ignored in
Db_Cancel which is called from Db_Flush which is called from Db_Exec
before anything else.  I just check the return code, and set
handle->connected to NS_FALSE and return an error.  It makes the first
query fail, but AOLServer gets a new connection with the next request
and things are fine.

# diff /home/iharding/nsfreetds.c ./nsfreetds.c
160c160,161
< Db_Cancel(handle);
---
> if (Db_Cancel(handle) == NS_ERROR)
> return NS_ERROR;
177,178c178,179
<
< Db_Cancel(handle);
---
> if (Db_Cancel(handle) == NS_ERROR)
> return NS_ERROR;
261c262,263
< Db_Cancel(handle);
---
> if (Db_Cancel(handle) == NS_ERROR)
> return NS_ERROR;
269c271,278
 /* Check return code, detect dead connections here.  */
> if (tds_process_simple_query(GET_TDS(handle)) == TDS_FAIL) {
> Ns_Log(Error,"Must be dead connection!  Bail out!!");
> handle->statement = NULL;
> handle->fetchingRows = 0;
> handle->connected = NS_FALSE;
> return NS_ERROR;
> }
307a317
>

- Ian

On 5/27/05, Ian Harding <[EMAIL PROTECTED]> wrote:
> Vlad,
>
> I am crosssposting to freetds.
>
> I use a Sybase server that times out connections after a certain
> amount of time.  Whenever this happens, the nsfreetds handle becomes
> useless as you can see in the TDS dump.  The sequence of events was,
> issue query, break connection, issue query, issue query.  The first
> query after connection was broken says "Read...failed" and the second
> (and all subsequent) say "Write...failed."
>
> I am not smart enough to fix this, but it seems like nsfreetds should
> detect the dead connection, return an error and tell AOLServer the
> connection handle is no good.  I assume that the query would return
> the error, but it could be submitted again (get a new connection) and
> it would succeed.  It looks like freetds is just trying to "flush" the
> handle but not kill it.
>
> What do you think?
>
> util.c:277:Starting log file for FreeTDS 0.64.dev.20050526
> on 2005-05-27 10:08:06 with debug flags 0x4fff.
> iconv.c:198:names for ISO-8859-1: ISO-8859-1
> iconv.c:198:names for UTF-8: UTF-8
> iconv.c:198:names for UCS-2LE: UCS-2LE
> iconv.c:198:names for UCS-2BE: UCS-2BE
> iconv.c:364:iconv to convert client-side data to the "ISO-8859-1" character 
> set
> iconv.c:517:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
> net.c:164:Connecting to 192.103.155.48 port 2638.
> net.c:667:Sending packet
>  02 00 02 00 00 00 00 00-41 4f 4c 73 65 72 76 65 | AOLserve|
> 0010 72 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |r... |
> 0020 00 00 00 00 00 00 09 69-61 68 00 00 00 00 00 00 |.|
> 0030 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 | |
> 0040 00 00 00 00 00 03 65 6c-76 69 73 00 00 00 00 00 |...|
> 0050 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 | |
> 0060 00 00 00 00 05 33 37 38-37 36 00 00 00 00 00 00 |.378 76..|
> 0070 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 | |
> 0080 00 00 00 05 03 01 06 0a-09 01 00 00 00 00 00 00 | |
> 0090 00 00 00 00 6e 73 66 72-65 65 74 64 73 00 00 00 |nsfr eetds...|
> 00a0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 | |
> 00b0 00 00 09 65 6e 76 69 73-69 6f 6e 00 00 00 00 00 |...envis ion.|
> 00c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 | |
> 00d0 00 08 00 05 65 6c 76 69-73 00 00 00 00 00 00 00 |...|
> 00e0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 | |
> 00f0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 | |
> 0100 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 | |
> 0110 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 | |
> 0120 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 | |
> 0130 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 | |
> 0140 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 | |
> 0150 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 | |
> 0160 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 | |
> 0170 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 | |
> 0180 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 | |
> 0190 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 | |
> 01a0 00 0

Re: [AOLSERVER] nsfreetds

2005-05-27 Thread Ian Harding

Vlad,

I am crosssposting to freetds.

I use a Sybase server that times out connections after a certain
amount of time.  Whenever this happens, the nsfreetds handle becomes
useless as you can see in the TDS dump.  The sequence of events was,
issue query, break connection, issue query, issue query.  The first
query after connection was broken says "Read...failed" and the second
(and all subsequent) say "Write...failed."

I am not smart enough to fix this, but it seems like nsfreetds should
detect the dead connection, return an error and tell AOLServer the
connection handle is no good.  I assume that the query would return
the error, but it could be submitted again (get a new connection) and
it would succeed.  It looks like freetds is just trying to "flush" the
handle but not kill it.

What do you think?

util.c:277:Starting log file for FreeTDS 0.64.dev.20050526
on 2005-05-27 10:08:06 with debug flags 0x4fff.
iconv.c:198:names for ISO-8859-1: ISO-8859-1
iconv.c:198:names for UTF-8: UTF-8
iconv.c:198:names for UCS-2LE: UCS-2LE
iconv.c:198:names for UCS-2BE: UCS-2BE
iconv.c:364:iconv to convert client-side data to the "ISO-8859-1" character set
iconv.c:517:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
net.c:164:Connecting to 192.103.155.48 port 2638.
net.c:667:Sending packet
 02 00 02 00 00 00 00 00-41 4f 4c 73 65 72 76 65 | AOLserve|
0010 72 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |r... |
0020 00 00 00 00 00 00 09 69-61 68 00 00 00 00 00 00 |.|
0030 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 | |
0040 00 00 00 00 00 03 65 6c-76 69 73 00 00 00 00 00 |...|
0050 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 | |
0060 00 00 00 00 05 33 37 38-37 36 00 00 00 00 00 00 |.378 76..|
0070 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 | |
0080 00 00 00 05 03 01 06 0a-09 01 00 00 00 00 00 00 | |
0090 00 00 00 00 6e 73 66 72-65 65 74 64 73 00 00 00 |nsfr eetds...|
00a0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 | |
00b0 00 00 09 65 6e 76 69 73-69 6f 6e 00 00 00 00 00 |...envis ion.|
00c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 | |
00d0 00 08 00 05 65 6c 76 69-73 00 00 00 00 00 00 00 |...|
00e0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 | |
00f0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 | |
0100 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 | |
0110 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 | |
0120 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 | |
0130 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 | |
0140 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 | |
0150 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 | |
0160 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 | |
0170 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 | |
0180 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 | |
0190 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 | |
01a0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 | |
01b0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 | |
01c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 | |
01d0 00 07 05 00 00 00 54 44-53 2d 4c 69 62 72 61 72 |..TD S-Librar|
01e0 0a 05 00 00 00 00 0d 11-75 73 5f 65 6e 67 6c 69 | us_engli|
01f0 73 68 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |sh.. |

net.c:667:Sending packet
 02 01 00 61 00 00 00 00-00 00 00 00 00 00 0a 00 |...a |
0010 00 00 00 00 00 00 00 00-00 00 00 00 00 69 73 6f | .iso|
0020 5f 31 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |_1.. |
0030 00 00 00 00 00 00 00 00-00 00 00 05 01 32 30 34 | .204|
0040 38 00 00 04 00 00 00 00-e2 16 00 01 09 00 00 06 |8... |
0050 6d 7f ff ff ff fe 02 09-00 00 00 00 0a 68 00 00 |m... .h..|
0060 00 -|.|

token.c:309:tds_process_login_tokens()
net.c:454:Received header
 04 01 00 5a 00 00 00 00-|...Z|

net.c:548:Received packet
 e3 08 00 03 05 69 73 6f-5f 31 00 ad 22 00 05 05 |.iso _1.."...|
0010 00 00 00 18 41 64 61 70-74 69 76 65 20 53 65 72 |Adap tive Ser|
0020 76 65 72 20 41 6e 79 77-68 65 72 65 08 00 00 00 |ver Anyw here|
0030 e2 16 00 01 09 00 00 06-61 01 ff ff fe e6 02 09 | a...|
0040 00 00 07 fe ea 68 00 00-0a fd 00 00 01 00 00 00 |.h.. |
0050 00 00  -|..|

token.c:313:looking for login token, got  e3(ENVCHANGE)
token.c:105:tds_process_default_tokens() marker is e3(ENVCHANGE)
read.c:178:tds_get_string: reading 5 from wire to give 5 to client.
token.c:313:looking for login token, got  ad(LOGINACK)
read.c:178:tds_get_str

Re: [AOLSERVER] nsfreetds

2005-05-26 Thread Vlad Seryakov


We used to run native sybase driver using proxy a while ago then
switched to nsfreetds. It used to run fine, but it did not support MS
SQL servers, so nsfreetds was the only choice. Now we've been using
nsfreetds for several years with MS SQL 2000.

Bas Scheffers wrote:

And drawbacks? Like compatibility, reliability?

Vlad Seryakov said:


"real" sybase driver is external driver working via db proxy, much
slower and spawns separate process for every new DB connection.

Bas Scheffers wrote:


Just out of curiosity, what is the advantage of using nsfreetds for
Sybase
over the "real" sybase driver?

Cheers,
Bas.


--
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.

Re: [AOLSERVER] nsfreetds

2005-05-26 Thread Bas Scheffers

And drawbacks? Like compatibility, reliability?

Vlad Seryakov said:
> "real" sybase driver is external driver working via db proxy, much
> slower and spawns separate process for every new DB connection.
>
> Bas Scheffers wrote:
>> Just out of curiosity, what is the advantage of using nsfreetds for
>> Sybase
>> over the "real" sybase driver?
>>
>> Cheers,
>> Bas.
>>
>>
>> --
>> 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.

Re: [AOLSERVER] nsfreetds

2005-05-26 Thread Vlad Seryakov


"real" sybase driver is external driver working via db proxy, much
slower and spawns separate process for every new DB connection.

Bas Scheffers wrote:

Just out of curiosity, what is the advantage of using nsfreetds for Sybase
over the "real" sybase driver?

Cheers,
Bas.


--
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.

Re: [AOLSERVER] nsfreetds

2005-05-26 Thread Bas Scheffers

Just out of curiosity, what is the advantage of using nsfreetds for Sybase
over the "real" sybase driver?

Cheers,
Bas.


--
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.

Re: [AOLSERVER] nsfreetds

2005-05-26 Thread Ian Harding

It seems to work great.  I will test it a bit more and see if it fixes
my other problem, which has to do with Sybase and connection timeouts.
 The first attempt at a query after connection timeout crashes
AOLServer.  I can live with that, but hope it goes away!  We are
leaving Sybase this summer anyway.

Thank you very much!

On 5/26/05, Vlad Seryakov <[EMAIL PROTECTED]> wrote:
> Thank you, i was experimenting yesterday and i think i got it working
> right, but with 0.64+ version.
> With versions 0.63+ DB_Cancel should call
> tds_process_simple_query to clear pending results, tds_freeall_resulst
> does not do this.
>
> Ian Harding wrote:
> > Sorry, that was not really right.
> >
> > "The severity level of an error message provides an indication of the
> > type of problem that Microsoft(r) SQL Serverï¾™ 2000 has encountered.
> >
> >  Severity level 10 messages are informational  and indicate problems
> > caused by mistakes in the information you have entered. Severity
> > levels from 11 through 16 are generated by the user, and can be
> > corrected by the user."
> >
> > I remember experimenting and finding that it was safe to consider
> > error levels 1 - 10 "Notice" information and > 10 always indicating a
> > real "Error" that should be returned to the caller.
> >
> > On 5/25/05, Ian Harding <[EMAIL PROTECTED]> wrote:
> >
> >>>10 indicates a critical error.
> >>
> >>On 5/25/05, Vlad Seryakov <[EMAIL PROTECTED]> wrote:
> >>
> >>>Why msg_level > 10, why 10, and not 0?
> >>>
> >>>Ian Harding wrote:
> >>>
> Vlad,
> 
> I installed 0.63 and compiled and installed your module.
> 
> It seems to work fine, but has a glitch I ran into as well which is
> that it doesn't return error codes when something went wrong with the
> query itself.  For example, with my hack I get this
> 
> SQL:
> 
> SELECT cast('foo' as int)
> 
> Results:
> 
> error: Database operation "exec" failed (exception NSDB, "Syntax
> error converting the varchar value 'foo' to a column of data type
> int.")
> 
> Rows affected: -1
> 
> With your version I get
> 
> SQL:
> 
> SELECT cast('foo' as int)
> 
> Results:
> 
> Rows affected: -1
> 
> While the log indicates
> [25/May/2005:12:46:20][17746.1090534320][-conn:server1::0] Notice:
> Db_Msg_Handler(fundware): Syntax error converting the varchar value
> 'foo' to a column of data type int.
> 
> This has to do with a fundamental change in error handling where
> non-network communication errors are not errors to freetds anymore.
> They are simply passed back to the application for it to handle.
> 
> Here is my hack which seems to work but may be terribly wrong for other 
> reasons.
> 
> int
> Ns_FreeTDS_Msg_Handler(TDSCONTEXT *ctx, TDSSOCKET *tds, TDSMESSAGE *msg)
> {
> Ns_DbHandle *handle = (Ns_DbHandle *) tds->parent;
> 
> Ns_Log(Notice, "nsfreetds: Ns_FreeTDS_Msg_Handler(%s): %s",
> handle->datasource, msg->message);
> 
> // Begin hack
> if ( msg->msg_level > 10 )
> Ns_DbSetException(handle, "NSDB", msg->message);
> // End hack
> 
> return 0;
> }
> 
> 
> 
> 
> On 5/25/05, Vlad Seryakov <[EMAIL PROTECTED]> 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_paramdriver  freetds
> >ns_paramconnections 10
> >ns_paramusercbill
> >ns_parampasswordcbill
> >ns_paramdatasource  Billing
> >ns_paramverbose Off
> >ns_paramlogsqlerrorsOn
> >ns_parammaxidle 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""
> >>erro

Re: [AOLSERVER] nsfreetds

2005-05-26 Thread Cory Grimster


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_paramdriver  freetds
ns_paramconnections 10
ns_paramusercbill
ns_parampasswordcbill
ns_paramdatasource  Billing
ns_paramverbose Off
ns_paramlogsqlerrorsOn
ns_parammaxidle 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_paramfreetds${bindir}/nsfreetds.so

ns_section ns/db/pools
ns_parampool4  "FreeTDS Pool"

ns_section ns/db/pool/pool4
ns_parammaxidle10
ns_parammaxopen10
ns_paramconnections5
ns_paramverbose$debug
ns_paramextendedtableinfo  true
ns_paramlogsqlerrors   $debug

ns_paramdriver freetds
ns_paramdatasource fooserver [also tried
fooserver:bardb]
ns_paramuser   sa
ns_parampassword   bazpassword

ns_section ns/server/${server}/db
ns_parampools  "*"
ns_paramdefaultpoolpool4

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 somethi

Re: [AOLSERVER] nsfreetds

2005-05-26 Thread Vlad Seryakov


Thank you, i was experimenting yesterday and i think i got it working
right, but with 0.64+ version.
With versions 0.63+ DB_Cancel should call
tds_process_simple_query to clear pending results, tds_freeall_resulst
does not do this.

Ian Harding wrote:

Sorry, that was not really right.

"The severity level of an error message provides an indication of the
type of problem that Microsoft(r) SQL Serverï¾™ 2000 has encountered.

 Severity level 10 messages are informational  and indicate problems
caused by mistakes in the information you have entered. Severity
levels from 11 through 16 are generated by the user, and can be
corrected by the user."

I remember experimenting and finding that it was safe to consider
error levels 1 - 10 "Notice" information and > 10 always indicating a
real "Error" that should be returned to the caller.

On 5/25/05, Ian Harding <[EMAIL PROTECTED]> wrote:


10 indicates a critical error.


On 5/25/05, Vlad Seryakov <[EMAIL PROTECTED]> wrote:


Why msg_level > 10, why 10, and not 0?

Ian Harding wrote:


Vlad,

I installed 0.63 and compiled and installed your module.

It seems to work fine, but has a glitch I ran into as well which is
that it doesn't return error codes when something went wrong with the
query itself.  For example, with my hack I get this

SQL:

   SELECT cast('foo' as int)

Results:

   error: Database operation "exec" failed (exception NSDB, "Syntax
error converting the varchar value 'foo' to a column of data type
int.")

Rows affected: -1

With your version I get

SQL:

   SELECT cast('foo' as int)

Results:

Rows affected: -1

While the log indicates
[25/May/2005:12:46:20][17746.1090534320][-conn:server1::0] Notice:
Db_Msg_Handler(fundware): Syntax error converting the varchar value
'foo' to a column of data type int.

This has to do with a fundamental change in error handling where
non-network communication errors are not errors to freetds anymore.
They are simply passed back to the application for it to handle.

Here is my hack which seems to work but may be terribly wrong for other reasons.

int
Ns_FreeTDS_Msg_Handler(TDSCONTEXT *ctx, TDSSOCKET *tds, TDSMESSAGE *msg)
{
   Ns_DbHandle *handle = (Ns_DbHandle *) tds->parent;

   Ns_Log(Notice, "nsfreetds: Ns_FreeTDS_Msg_Handler(%s): %s",
   handle->datasource, msg->message);

// Begin hack
   if ( msg->msg_level > 10 )
   Ns_DbSetException(handle, "NSDB", msg->message);
// End hack

   return 0;
}




On 5/25/05, Vlad Seryakov <[EMAIL PROTECTED]> 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_paramdriver  freetds
ns_paramconnections 10
ns_paramusercbill
ns_parampasswordcbill
ns_paramdatasource  Billing
ns_paramverbose Off
ns_paramlogsqlerrorsOn
ns_parammaxidle 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_paramfreetds${bindir}/nsfreetds.so

ns_section ns/db/pools
  ns_parampool4  "FreeTDS Pool"

ns_section ns/db/pool/pool4
  ns_parammaxidle10
  ns_parammaxopen10
  ns_paramconnections5
  ns_paramverbose$debug
  ns_paramextendedtableinfo  true
  ns_paramlogsqlerrors   $debug

  ns_paramdriver freetds
  ns_paramdatasource fooserver [also tried fooserver:bardb]
  ns_paramuser   sa
  ns_parampassword   bazpassword

ns_section ns/server/${server}/db
  ns_parampools  "*"
  ns_paramdefaultpoolpool4

I have the SYBASE en

Re: [AOLSERVER] nsfreetds

2005-05-25 Thread Ian Harding

Sorry, that was not really right.

"The severity level of an error message provides an indication of the
type of problem that Microsoft(r) SQL Server™ 2000 has encountered.

 Severity level 10 messages are informational  and indicate problems
caused by mistakes in the information you have entered. Severity
levels from 11 through 16 are generated by the user, and can be
corrected by the user."

I remember experimenting and finding that it was safe to consider
error levels 1 - 10 "Notice" information and > 10 always indicating a
real "Error" that should be returned to the caller.

On 5/25/05, Ian Harding <[EMAIL PROTECTED]> wrote:
> >10 indicates a critical error.
>
> On 5/25/05, Vlad Seryakov <[EMAIL PROTECTED]> wrote:
> > Why msg_level > 10, why 10, and not 0?
> >
> > Ian Harding wrote:
> > > Vlad,
> > >
> > > I installed 0.63 and compiled and installed your module.
> > >
> > > It seems to work fine, but has a glitch I ran into as well which is
> > > that it doesn't return error codes when something went wrong with the
> > > query itself.  For example, with my hack I get this
> > >
> > > SQL:
> > >
> > > SELECT cast('foo' as int)
> > >
> > > Results:
> > >
> > > error: Database operation "exec" failed (exception NSDB, "Syntax
> > > error converting the varchar value 'foo' to a column of data type
> > > int.")
> > >
> > > Rows affected: -1
> > >
> > > With your version I get
> > >
> > > SQL:
> > >
> > > SELECT cast('foo' as int)
> > >
> > > Results:
> > >
> > > Rows affected: -1
> > >
> > > While the log indicates
> > > [25/May/2005:12:46:20][17746.1090534320][-conn:server1::0] Notice:
> > > Db_Msg_Handler(fundware): Syntax error converting the varchar value
> > > 'foo' to a column of data type int.
> > >
> > > This has to do with a fundamental change in error handling where
> > > non-network communication errors are not errors to freetds anymore.
> > > They are simply passed back to the application for it to handle.
> > >
> > > Here is my hack which seems to work but may be terribly wrong for other 
> > > reasons.
> > >
> > > int
> > > Ns_FreeTDS_Msg_Handler(TDSCONTEXT *ctx, TDSSOCKET *tds, TDSMESSAGE *msg)
> > > {
> > > Ns_DbHandle *handle = (Ns_DbHandle *) tds->parent;
> > >
> > > Ns_Log(Notice, "nsfreetds: Ns_FreeTDS_Msg_Handler(%s): %s",
> > > handle->datasource, msg->message);
> > >
> > > // Begin hack
> > > if ( msg->msg_level > 10 )
> > > Ns_DbSetException(handle, "NSDB", msg->message);
> > > // End hack
> > >
> > > return 0;
> > > }
> > >
> > >
> > >
> > >
> > > On 5/25/05, Vlad Seryakov <[EMAIL PROTECTED]> 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_paramdriver  freetds
> > >>ns_paramconnections 10
> > >>ns_paramusercbill
> > >>ns_parampasswordcbill
> > >>ns_paramdatasource  Billing
> > >>ns_paramverbose Off
> > >>ns_paramlogsqlerrorsOn
> > >>ns_parammaxidle 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_paramfreetds${bindir}/nsfreetds.so
> > >>>
> > >>>ns_section ns/db/pools
> > >>>ns_parampool4  "FreeTDS Pool"
> > >>>
> > >>>ns_section ns/db/pool/pool4
> > >>>ns_parammaxidle10
> > >>>ns_para

Re: [AOLSERVER] nsfreetds

2005-05-25 Thread Ian Harding

>10 indicates a critical error.

On 5/25/05, Vlad Seryakov <[EMAIL PROTECTED]> wrote:
> Why msg_level > 10, why 10, and not 0?
>
> Ian Harding wrote:
> > Vlad,
> >
> > I installed 0.63 and compiled and installed your module.
> >
> > It seems to work fine, but has a glitch I ran into as well which is
> > that it doesn't return error codes when something went wrong with the
> > query itself.  For example, with my hack I get this
> >
> > SQL:
> >
> > SELECT cast('foo' as int)
> >
> > Results:
> >
> > error: Database operation "exec" failed (exception NSDB, "Syntax
> > error converting the varchar value 'foo' to a column of data type
> > int.")
> >
> > Rows affected: -1
> >
> > With your version I get
> >
> > SQL:
> >
> > SELECT cast('foo' as int)
> >
> > Results:
> >
> > Rows affected: -1
> >
> > While the log indicates
> > [25/May/2005:12:46:20][17746.1090534320][-conn:server1::0] Notice:
> > Db_Msg_Handler(fundware): Syntax error converting the varchar value
> > 'foo' to a column of data type int.
> >
> > This has to do with a fundamental change in error handling where
> > non-network communication errors are not errors to freetds anymore.
> > They are simply passed back to the application for it to handle.
> >
> > Here is my hack which seems to work but may be terribly wrong for other 
> > reasons.
> >
> > int
> > Ns_FreeTDS_Msg_Handler(TDSCONTEXT *ctx, TDSSOCKET *tds, TDSMESSAGE *msg)
> > {
> > Ns_DbHandle *handle = (Ns_DbHandle *) tds->parent;
> >
> > Ns_Log(Notice, "nsfreetds: Ns_FreeTDS_Msg_Handler(%s): %s",
> > handle->datasource, msg->message);
> >
> > // Begin hack
> > if ( msg->msg_level > 10 )
> > Ns_DbSetException(handle, "NSDB", msg->message);
> > // End hack
> >
> > return 0;
> > }
> >
> >
> >
> >
> > On 5/25/05, Vlad Seryakov <[EMAIL PROTECTED]> 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_paramdriver  freetds
> >>ns_paramconnections 10
> >>ns_paramusercbill
> >>ns_parampasswordcbill
> >>ns_paramdatasource  Billing
> >>ns_paramverbose Off
> >>ns_paramlogsqlerrorsOn
> >>ns_parammaxidle 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_paramfreetds${bindir}/nsfreetds.so
> >>>
> >>>ns_section ns/db/pools
> >>>ns_parampool4  "FreeTDS Pool"
> >>>
> >>>ns_section ns/db/pool/pool4
> >>>ns_parammaxidle10
> >>>ns_parammaxopen10
> >>>ns_paramconnections5
> >>>ns_paramverbose$debug
> >>>ns_paramextendedtableinfo  true
> >>>ns_paramlogsqlerrors   $debug
> >>>
> >>>ns_paramdriver freetds
> >>>ns_paramdatasource fooserver [also tried fooserver:bardb]
> >>>ns_paramuser   sa
> >>>ns_parampassword   bazpassword
> >>>
> >>>ns_section ns/server/${server}/db
> >>>ns_parampools  "*"
> >>>ns_paramdefaultpoolpool4
> >>>
> >>>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

Re: [AOLSERVER] nsfreetds

2005-05-25 Thread Keith Paskett


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_paramdriver  freetds
ns_paramconnections 10
ns_paramusercbill
ns_parampasswordcbill
ns_paramdatasource  Billing
ns_paramverbose Off
ns_paramlogsqlerrorsOn
ns_parammaxidle 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_paramfreetds${bindir}/nsfreetds.so

ns_section ns/db/pools
ns_parampool4  "FreeTDS Pool"

ns_section ns/db/pool/pool4
ns_parammaxidle10
ns_parammaxopen10
ns_paramconnections5
ns_paramverbose$debug
ns_paramextendedtableinfo  true
ns_paramlogsqlerrors   $debug

ns_paramdriver freetds
ns_paramdatasource fooserver [also tried
fooserver:bardb]
ns_paramuser   sa
ns_parampassword   bazpassword

ns_section ns/server/${server}/db
ns_parampools  "*"
ns_paramdefaultpoolpool4

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 o

Re: [AOLSERVER] nsfreetds

2005-05-25 Thread Vlad Seryakov


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_paramdriver  freetds
ns_paramconnections 10
ns_paramusercbill
ns_parampasswordcbill
ns_paramdatasource  Billing
ns_paramverbose Off
ns_paramlogsqlerrorsOn
ns_parammaxidle 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_paramfreetds${bindir}/nsfreetds.so

ns_section ns/db/pools
ns_parampool4  "FreeTDS Pool"

ns_section ns/db/pool/pool4
ns_parammaxidle10
ns_parammaxopen10
ns_paramconnections5
ns_paramverbose$debug
ns_paramextendedtableinfo  true
ns_paramlogsqlerrors   $debug

ns_paramdriver freetds
ns_paramdatasource fooserver [also tried
fooserver:bardb]
ns_paramuser   sa
ns_parampassword   bazpassword

ns_section ns/server/${server}/db
ns_parampools  "*"
ns_paramdefaultpoolpool4

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 PRO

Re: [AOLSERVER] nsfreetds

2005-05-25 Thread Vlad Seryakov


Why msg_level > 10, why 10, and not 0?

Ian Harding wrote:

Vlad,

I installed 0.63 and compiled and installed your module.

It seems to work fine, but has a glitch I ran into as well which is
that it doesn't return error codes when something went wrong with the
query itself.  For example, with my hack I get this

SQL:

SELECT cast('foo' as int)

Results:

error: Database operation "exec" failed (exception NSDB, "Syntax
error converting the varchar value 'foo' to a column of data type
int.")

Rows affected: -1

With your version I get

SQL:

SELECT cast('foo' as int)

Results:

Rows affected: -1

While the log indicates
[25/May/2005:12:46:20][17746.1090534320][-conn:server1::0] Notice:
Db_Msg_Handler(fundware): Syntax error converting the varchar value
'foo' to a column of data type int.

This has to do with a fundamental change in error handling where
non-network communication errors are not errors to freetds anymore.
They are simply passed back to the application for it to handle.

Here is my hack which seems to work but may be terribly wrong for other reasons.

int
Ns_FreeTDS_Msg_Handler(TDSCONTEXT *ctx, TDSSOCKET *tds, TDSMESSAGE *msg)
{
Ns_DbHandle *handle = (Ns_DbHandle *) tds->parent;

Ns_Log(Notice, "nsfreetds: Ns_FreeTDS_Msg_Handler(%s): %s",
handle->datasource, msg->message);

// Begin hack
if ( msg->msg_level > 10 )
Ns_DbSetException(handle, "NSDB", msg->message);
// End hack

return 0;
}




On 5/25/05, Vlad Seryakov <[EMAIL PROTECTED]> 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_paramdriver  freetds
ns_paramconnections 10
ns_paramusercbill
ns_parampasswordcbill
ns_paramdatasource  Billing
ns_paramverbose Off
ns_paramlogsqlerrorsOn
ns_parammaxidle 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_paramfreetds${bindir}/nsfreetds.so

ns_section ns/db/pools
   ns_parampool4  "FreeTDS Pool"

ns_section ns/db/pool/pool4
   ns_parammaxidle10
   ns_parammaxopen10
   ns_paramconnections5
   ns_paramverbose$debug
   ns_paramextendedtableinfo  true
   ns_paramlogsqlerrors   $debug

   ns_paramdriver freetds
   ns_paramdatasource fooserver [also tried fooserver:bardb]
   ns_paramuser   sa
   ns_parampassword   bazpassword

ns_section ns/server/${server}/db
   ns_parampools  "*"
   ns_paramdefaultpoolpool4

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 e

Re: [AOLSERVER] nsfreetds

2005-05-25 Thread Cory Grimster


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_paramdriver  freetds
ns_paramconnections 10
ns_paramusercbill
ns_parampasswordcbill
ns_paramdatasource  Billing
ns_paramverbose Off
ns_paramlogsqlerrorsOn
ns_parammaxidle 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_paramfreetds${bindir}/nsfreetds.so

ns_section ns/db/pools
ns_parampool4  "FreeTDS Pool"

ns_section ns/db/pool/pool4
ns_parammaxidle10
ns_parammaxopen10
ns_paramconnections5
ns_paramverbose$debug
ns_paramextendedtableinfo  true
ns_paramlogsqlerrors   $debug

ns_paramdriver freetds
ns_paramdatasource fooserver [also tried
fooserver:bardb]
ns_paramuser   sa
ns_parampassword   bazpassword

ns_section ns/server/${server}/db
ns_parampools  "*"
ns_paramdefaultpoolpool4

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

Re: [AOLSERVER] nsfreetds

2005-05-25 Thread Ian Harding

Vlad,

I installed 0.63 and compiled and installed your module.

It seems to work fine, but has a glitch I ran into as well which is
that it doesn't return error codes when something went wrong with the
query itself.  For example, with my hack I get this

SQL:

SELECT cast('foo' as int)

Results:

error: Database operation "exec" failed (exception NSDB, "Syntax
error converting the varchar value 'foo' to a column of data type
int.")

Rows affected: -1

With your version I get

SQL:

SELECT cast('foo' as int)

Results:

Rows affected: -1

While the log indicates
[25/May/2005:12:46:20][17746.1090534320][-conn:server1::0] Notice:
Db_Msg_Handler(fundware): Syntax error converting the varchar value
'foo' to a column of data type int.

This has to do with a fundamental change in error handling where
non-network communication errors are not errors to freetds anymore.
They are simply passed back to the application for it to handle.

Here is my hack which seems to work but may be terribly wrong for other reasons.

int
Ns_FreeTDS_Msg_Handler(TDSCONTEXT *ctx, TDSSOCKET *tds, TDSMESSAGE *msg)
{
Ns_DbHandle *handle = (Ns_DbHandle *) tds->parent;

Ns_Log(Notice, "nsfreetds: Ns_FreeTDS_Msg_Handler(%s): %s",
handle->datasource, msg->message);

// Begin hack
if ( msg->msg_level > 10 )
Ns_DbSetException(handle, "NSDB", msg->message);
// End hack

return 0;
}




On 5/25/05, Vlad Seryakov <[EMAIL PROTECTED]> 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_paramdriver  freetds
> ns_paramconnections 10
> ns_paramusercbill
> ns_parampasswordcbill
> ns_paramdatasource  Billing
> ns_paramverbose Off
> ns_paramlogsqlerrorsOn
> ns_parammaxidle 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_paramfreetds${bindir}/nsfreetds.so
> >
> > ns_section ns/db/pools
> > ns_parampool4  "FreeTDS Pool"
> >
> > ns_section ns/db/pool/pool4
> > ns_parammaxidle10
> > ns_parammaxopen10
> > ns_paramconnections5
> > ns_paramverbose$debug
> > ns_paramextendedtableinfo  true
> > ns_paramlogsqlerrors   $debug
> >
> > ns_paramdriver freetds
> > ns_paramdatasource fooserver [also tried fooserver:bardb]
> > ns_paramuser   sa
> > ns_parampassword   bazpassword
> >
> > ns_section ns/server/${server}/db
> > ns_parampools  "*"
> > ns_paramdefaultpoolpool4
> >
> > 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.
>
> --
>

Re: [AOLSERVER] nsfreetds

2005-05-25 Thread Vlad Seryakov


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_paramdriver  freetds
ns_paramconnections 10
ns_paramusercbill
ns_parampasswordcbill
ns_paramdatasource  Billing
ns_paramverbose Off
ns_paramlogsqlerrorsOn
ns_parammaxidle 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_paramfreetds${bindir}/nsfreetds.so

ns_section ns/db/pools
ns_parampool4  "FreeTDS Pool"

ns_section ns/db/pool/pool4
ns_parammaxidle10
ns_parammaxopen10
ns_paramconnections5
ns_paramverbose$debug
ns_paramextendedtableinfo  true
ns_paramlogsqlerrors   $debug

ns_paramdriver freetds
ns_paramdatasource fooserver [also tried
fooserver:bardb]
ns_paramuser   sa
ns_parampassword   bazpassword

ns_section ns/server/${server}/db
ns_parampools  "*"
ns_paramdefaultpoolpool4

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.

Re: [AOLSERVER] nsfreetds

2005-05-25 Thread Cory Grimster


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_paramdriver  freetds
ns_paramconnections 10
ns_paramusercbill
ns_parampasswordcbill
ns_paramdatasource  Billing
ns_paramverbose Off
ns_paramlogsqlerrorsOn
ns_parammaxidle 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_paramfreetds${bindir}/nsfreetds.so

ns_section ns/db/pools
ns_parampool4  "FreeTDS Pool"

ns_section ns/db/pool/pool4
ns_parammaxidle10
ns_parammaxopen10
ns_paramconnections5
ns_paramverbose$debug
ns_paramextendedtableinfo  true
ns_paramlogsqlerrors   $debug

ns_paramdriver freetds
ns_paramdatasource fooserver [also tried fooserver:bardb]
ns_paramuser   sa
ns_parampassword   bazpassword

ns_section ns/server/${server}/db
ns_parampools  "*"
ns_paramdefaultpoolpool4

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.

Re: [AOLSERVER] nsfreetds

2005-05-25 Thread Vlad Seryakov


It is a fork, see ChangeLog for more info, no website or any formal info
at this point yet.

Xavier Beaudouin wrote:

Humm

What is the difference between naviserver and aolserver... ?

/Xavier
Le 25 mai 05 Ã  20:25, Vlad Seryakov a Ã©crit :


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_paramdriver  freetds
ns_paramconnections 10
ns_paramusercbill
ns_parampasswordcbill
ns_paramdatasource  Billing
ns_paramverbose Off
ns_paramlogsqlerrorsOn
ns_parammaxidle 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_paramfreetds${bindir}/nsfreetds.so

ns_section ns/db/pools
ns_parampool4  "FreeTDS Pool"

ns_section ns/db/pool/pool4
ns_parammaxidle10
ns_parammaxopen10
ns_paramconnections5
ns_paramverbose$debug
ns_paramextendedtableinfo  true
ns_paramlogsqlerrors   $debug

ns_paramdriver freetds
ns_paramdatasource fooserver [also tried
fooserver:bardb]
ns_paramuser   sa
ns_parampassword   bazpassword

ns_section ns/server/${server}/db
ns_parampools  "*"
ns_paramdefaultpoolpool4

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.

Re: [AOLSERVER] nsfreetds

2005-05-25 Thread Xavier Beaudouin


Humm

What is the difference between naviserver and aolserver... ?

/Xavier
Le 25 mai 05 à 20:25, Vlad Seryakov a écrit :


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_paramdriver  freetds
ns_paramconnections 10
ns_paramusercbill
ns_parampasswordcbill
ns_paramdatasource  Billing
ns_paramverbose Off
ns_paramlogsqlerrorsOn
ns_parammaxidle 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_paramfreetds${bindir}/nsfreetds.so

ns_section ns/db/pools
ns_parampool4  "FreeTDS Pool"

ns_section ns/db/pool/pool4
ns_parammaxidle10
ns_parammaxopen10
ns_paramconnections5
ns_paramverbose$debug
ns_paramextendedtableinfo  true
ns_paramlogsqlerrors   $debug

ns_paramdriver freetds
ns_paramdatasource fooserver [also tried
fooserver:bardb]
ns_paramuser   sa
ns_parampassword   bazpassword

ns_section ns/server/${server}/db
ns_parampools  "*"
ns_paramdefaultpoolpool4

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.

Re: [AOLSERVER] nsfreetds

2005-05-25 Thread Cory Grimster


Actually the example freetds.conf file uses "tds version = 8.0" for
Microsoft SQL Server 2000.  But I understand that version 4.2 is the
most stable and I'll use that while I'm trying to get it running.

At any rate, changing the protocol version to 4.2 in the interfaces file
hasn't changed my situation.  Any additional suggestions would be geatly
appreciated :)

-Cory


Dossy Shiobara wrote:

On 2005.05.25, Cory Grimster <[EMAIL PROTECTED]> wrote:


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]



Instead of 8.0, use "tds4.2" or possibly "tds7.0" -- I don't think
there is a "tds8.0" yet.

-- Dossy

--
Dossy Shiobara   mail: [EMAIL PROTECTED]
Panoptic Computer Network web: http://www.panoptic.com/
  "He realized the fastest way to change is to laugh at your own
folly -- then you can let go and quickly move on." (p. 70)


--
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.

Re: [AOLSERVER] nsfreetds

2005-05-25 Thread Ian Harding

tsql should return results if everything is configured right.  You
might need to type

go;

after your SQL statement.  Also, I use Version 7.0 with MS SQL Server
2000.  I don't know if it will make a difference.

nsfreetds is very version dependent on freetds.  Dossy might be able
to get you an older version that worked with that freetds version.  I
have butchered it to work with a 6.4 development snapshot and that's
what I use.

Good luck!

- Ian

On 5/25/05, Cory Grimster <[EMAIL PROTECTED]> 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_paramfreetds${bindir}/nsfreetds.so
>
> ns_section ns/db/pools
>  ns_parampool4  "FreeTDS Pool"
>
> ns_section ns/db/pool/pool4
>  ns_parammaxidle10
>  ns_parammaxopen10
>  ns_paramconnections5
>  ns_paramverbose$debug
>  ns_paramextendedtableinfo  true
>  ns_paramlogsqlerrors   $debug
>
>  ns_paramdriver freetds
>  ns_paramdatasource fooserver [also tried fooserver:bardb]
>  ns_paramuser   sa
>  ns_parampassword   bazpassword
>
> ns_section ns/server/${server}/db
>  ns_parampools  "*"
>  ns_paramdefaultpoolpool4
>
> 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.
>


--
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.

Re: [AOLSERVER] nsfreetds

2005-05-25 Thread Vlad Seryakov


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_paramdriver  freetds
ns_paramconnections 10
ns_paramusercbill
ns_parampasswordcbill
ns_paramdatasource  Billing
ns_paramverbose Off
ns_paramlogsqlerrorsOn
ns_parammaxidle 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_paramfreetds${bindir}/nsfreetds.so

ns_section ns/db/pools
ns_parampool4  "FreeTDS Pool"

ns_section ns/db/pool/pool4
ns_parammaxidle10
ns_parammaxopen10
ns_paramconnections5
ns_paramverbose$debug
ns_paramextendedtableinfo  true
ns_paramlogsqlerrors   $debug

ns_paramdriver freetds
ns_paramdatasource fooserver [also tried fooserver:bardb]
ns_paramuser   sa
ns_parampassword   bazpassword

ns_section ns/server/${server}/db
ns_parampools  "*"
ns_paramdefaultpoolpool4

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.

Re: [AOLSERVER] nsfreetds

2005-05-25 Thread Dossy Shiobara

On 2005.05.25, Cory Grimster <[EMAIL PROTECTED]> wrote:
> 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]

Instead of 8.0, use "tds4.2" or possibly "tds7.0" -- I don't think
there is a "tds8.0" yet.

-- Dossy

--
Dossy Shiobara   mail: [EMAIL PROTECTED]
Panoptic Computer Network web: http://www.panoptic.com/
  "He realized the fastest way to change is to laugh at your own
folly -- then you can let go and quickly move on." (p. 70)

--
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] nsfreetds

2005-05-25 Thread Cory Grimster


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_paramfreetds${bindir}/nsfreetds.so

ns_section ns/db/pools
ns_parampool4  "FreeTDS Pool"

ns_section ns/db/pool/pool4
ns_parammaxidle10
ns_parammaxopen10
ns_paramconnections5
ns_paramverbose$debug
ns_paramextendedtableinfo  true
ns_paramlogsqlerrors   $debug

ns_paramdriver freetds
ns_paramdatasource fooserver [also tried fooserver:bardb]
ns_paramuser   sa
ns_parampassword   bazpassword

ns_section ns/server/${server}/db
ns_parampools  "*"
ns_paramdefaultpoolpool4

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.

Re: [AOLSERVER] nsfreetds-0.2 released on 06/04/2002

2002-06-04 Thread Dossy


On 2002.06.04, Ian Harding <[EMAIL PROTECTED]> wrote:
> I have played with it and will start using it in production as soon as
> our Sybase gets upgraded (this summer).

Cool, let me know how it goes!

Otherwise, how have things been?  Haven't heard from you in ages!

-- Dossy

--
Dossy Shiobara   mail: [EMAIL PROTECTED]
Panoptic Computer Network web: http://www.panoptic.com/
  "He realized the fastest way to change is to laugh at your own
folly -- then you can let go and quickly move on." (p. 70)

Re: [AOLSERVER] nsfreetds-0.2 released on 06/04/2002

2002-06-04 Thread Ian Harding


I have played with it and will start using it in production as soon as our Sybase gets 
upgraded (this summer).

Ian A. Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
(253) 798-3549
mailto: [EMAIL PROTECTED]

Fast, Cheap, Good:  Choose two.

>>> [EMAIL PROTECTED] 06/03/02 10:06PM >>>
All,

Thanks to help and prodding from Vlad Seryakov <[EMAIL PROTECTED]>
and Sean Redmond <[EMAIL PROTECTED]>, nsfreetds-0.2 has
been released (over a year after nsfreetds-0.1-pre, heh).

Fixed some long-standing bugs (converting INTEGER results to strings)
as well as fixed nsfreetds to build against FreeTDS 0.53, which is
the latest stable FreeTDS release.

nsfreetds-0.2 can be gotten from:

  http://panoptic.com/wiki/aolserver/nsfreetds

Or, directly from:

  http://ftp.panoptic.com/pub/nsfreetds-v0_2.tar.gz

If you were using the 0.1-pre driver, I strongly urge you to
upgrade.  0.2 should be fully backwards-compatible with 0.1-pre
(except you will most likely need to also upgrade to FreeTDS 0.53
from 0.51).

If you're using the nsfreetds driver, I'd really appreciate an
email letting me know.  I'm curious how many folks are using it,
or are trying to use it.

As usual, please email any problems, issues, or enhancements to
me at <[EMAIL PROTECTED]>.

Thanks,

-- Dossy

--
Dossy Shiobara   mail: [EMAIL PROTECTED]
Panoptic Computer Network web: http://www.panoptic.com/
  "He realized the fastest way to change is to laugh at your own
folly -- then you can let go and quickly move on." (p. 70)

[AOLSERVER] nsfreetds-0.2 released on 06/04/2002

2002-06-03 Thread Dossy


All,

Thanks to help and prodding from Vlad Seryakov <[EMAIL PROTECTED]>
and Sean Redmond <[EMAIL PROTECTED]>, nsfreetds-0.2 has
been released (over a year after nsfreetds-0.1-pre, heh).

Fixed some long-standing bugs (converting INTEGER results to strings)
as well as fixed nsfreetds to build against FreeTDS 0.53, which is
the latest stable FreeTDS release.

nsfreetds-0.2 can be gotten from:

  http://panoptic.com/wiki/aolserver/nsfreetds

Or, directly from:

  http://ftp.panoptic.com/pub/nsfreetds-v0_2.tar.gz

If you were using the 0.1-pre driver, I strongly urge you to
upgrade.  0.2 should be fully backwards-compatible with 0.1-pre
(except you will most likely need to also upgrade to FreeTDS 0.53
from 0.51).

If you're using the nsfreetds driver, I'd really appreciate an
email letting me know.  I'm curious how many folks are using it,
or are trying to use it.

As usual, please email any problems, issues, or enhancements to
me at <[EMAIL PROTECTED]>.

Thanks,

-- Dossy

--
Dossy Shiobara   mail: [EMAIL PROTECTED]
Panoptic Computer Network web: http://www.panoptic.com/
  "He realized the fastest way to change is to laugh at your own
folly -- then you can let go and quickly move on." (p. 70)

[AOLSERVER] nsfreetds-0.1pre (an internal TDS-based database driver) up for testing

2001-05-14 Thread Dossy


All,

This is to announce the release of nsfreetds-0.1pre, an internal
database driver that uses TDS to connect to both Microsoft SQL
Server and Sybase databases.  It uses the FreeTDS 0.51 implementation
of the TDS protocol for connectivity.

The driver has been tested with AOLserver 3.3.1 on both x86 Linux
and SPARC Solaris 2.6, connecting to Sybase 11 running on SPARC
Solaris 2.6, and Microsoft SQL Server 7 and 2000 running on both
WinNT 4.0 and Win2000.

The home for nsfreetds is at:

  http://panoptic.com/wiki/aolserver/nsfreetds

nsfreetds-0.1pre is available at:

  ftp://ftp.panoptic.com/pub/nsfreetds/nsfreetds-0.1pre.tar.gz

The nsfreetds FAQ is at:

  http://panoptic.com/wiki/aolserver/nsfreetdsFAQ


I invite everyone interested to download nsfreetds and try it out,
and provide me with any feedback.  It would also be nice if people
using the driver would send me an email and let me know if they
were able to get the driver working and describe what configuration
they used with it (both AOLserver and database version and platform
information).

I'd also like to see if someone could benchmark the nsfreetds driver
against the nssybpd and nsodbc drivers, to get an idea of the difference
between an internal vs. external (in the case of nssybpd) and a
native TDS driver vs. an ODBC driver (in the case of nsodbc).

- Dossy

--
Dossy Shiobara   mail: [EMAIL PROTECTED]
Panoptic Computer Network web: http://www.panoptic.com/

Re: [AOLSERVER] nsfreetds

Re: [AOLSERVER] nsfreetds

Re: [AOLSERVER] [Re: Re: [AOLSERVER] nsfreetds]

Re: [AOLSERVER] nsfreetds

Re: [AOLSERVER] nsfreetds

Re: [AOLSERVER] nsfreetds

Re: [AOLSERVER] nsfreetds

Re: [AOLSERVER] nsfreetds

Re: [AOLSERVER] nsfreetds

Re: [AOLSERVER] nsfreetds

Re: [AOLSERVER] nsfreetds

Re: [AOLSERVER] nsfreetds

Re: [AOLSERVER] nsfreetds

Re: [AOLSERVER] nsfreetds

Re: [AOLSERVER] nsfreetds

Re: [AOLSERVER] nsfreetds

Re: [AOLSERVER] nsfreetds

Re: [AOLSERVER] nsfreetds

Re: [AOLSERVER] nsfreetds

Re: [AOLSERVER] nsfreetds

Re: [AOLSERVER] nsfreetds

Re: [AOLSERVER] nsfreetds

Re: [AOLSERVER] nsfreetds

Re: [AOLSERVER] nsfreetds

Re: [AOLSERVER] nsfreetds

Re: [AOLSERVER] nsfreetds

Re: [AOLSERVER] nsfreetds

[AOLSERVER] nsfreetds

Re: [AOLSERVER] nsfreetds-0.2 released on 06/04/2002

Re: [AOLSERVER] nsfreetds-0.2 released on 06/04/2002

[AOLSERVER] nsfreetds-0.2 released on 06/04/2002

[AOLSERVER] nsfreetds-0.1pre (an internal TDS-based database driver) up for testing

32 matches

Site Navigation

Mail list logo

Footer information