Re: [AOLSERVER] nsfreetds
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] Mass Virtual Hosting system for AolServer 4.0.x?
This is exactly what I was looking for... I just need to adapt it for LDAP and SQL... and add a callback to auto garbage collector old database stuff to get a TTL for cached hosts :) Well why don't you just change the cache type to timing out, just switch from Ns_CacheCreateSz() to Ns_CacheCreate() and it should work. Thanks for the advice... :) Now I just need to code the ldap part :) /Xavier -- 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] Mass Virtual Hosting system for AolServer 4.0.x?
Hi :) Please tell me how http request is handled by aolserver, in which files I have to dig and how can I add it nicely to, I hope, integrate this functionality on next aolserver version if it is possible... ? Well, you can have a look at nsdqe (not really sure where you'd find it (www.zoro2.org/nsdqe-1.0.tar.gz is where I put it temporarily). This is my module which does a pretty funky thing - it uses Tcl for fetching virtualhost's root directory and then caches it. Once you update the database all you do is 'dqe_vh flush' so that the cache is flushed. I consider that quite effective and you can write any Tcl proc to do massive vhosting. This is exactly what I was looking for... I just need to adapt it for LDAP and SQL... and add a callback to auto garbage collector old database stuff to get a TTL for cached hosts :) /Xavier -- 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] Mass Virtual Hosting system for AolServer 4.0.x?
You will find this exceedingly easy in AOLserver. I have written several myself. You could check out VAT: http://zmbh.com/vat/, Good which expanded on tclvhr: http://zmbh.com/tcllvhr/ This one seems to be now as 404... Anyone here have clues where I can find it ? or a very simple, file based system described in: http://zmbh.com/nsrewrite/doc/nsrewriteurl.html. Thanks :) The first two use the config file, so you would have to restart the server. The last only requires the creation of the host directory, and the ability to set DNS entries correctly for the new domain. In every case, you could easily add database storage to allow 'no restart' configuration. This is what I'd like to do, this is very interressing lecture and code. Now I have to understand it, and adapt it for mod_vhs compatible system :) As a matter of fact, if you ever heard of MyDomain.com, this was a perfect example of mass(ive) virtual hosting using AOLserver. The virtual hosting software consisted of a single, very short page, which looked up the configuration information. At one time they approached 500k domains in the system, which pushed AOLserver onto the Netcraft map. There were no local directories in the system, but it allowed users to redirect to their own website, or to wrap their page in a frame (done automatically) to pull up data stored anywhere on the internet. You could provide a home page, which was stored in the database. ;-) Good :) Bottom line: AOLserver is great for mass virtual hosting of the sort I have described: static, database dynamic or offsite redirects. It is less helpful for file based dynamic sites since you will likely have to rely on plain old CGI. The built in Tcl scripting and adp (AOLserver Dynamic Pages) share memory between requests and over the life of the server and system user/group. So you would need to carefully control what your users are allowed to run, otherwise they could mess with each other and with the server operation. Using separate AOLserver virtual hosts will not work on a massive scale since each virtual host requires a lot of memory, and requires time to start up. It also requires a restart to add virtual hosts. Yeah that's why I want to use it... and also to find a solution to drop the apache system needed for PHP... But this will be another story :) /Xavier -- 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] Mass Virtual Hosting system for AolServer 4.0.x?
Hello there, First I present myself :) I am Xavier Beaudouin, Caudium Webserver Maintainer. I'd like to port on AolServer a nice thing (or beast?) we did on Caudium : VHS. What is VHS ? It is a mass virtual hosting system that looks on a DB (mysql, psgsl, ...) or in an LDAP directory where is located the home directory of a host header named based webserver. It is 100% dynamic and allow handle a cluster and several webserver to be automagicaly configured without the need to update a conf file or even make special hashing system... Now since I am new on Aolserver, I am trying to understand how I can add such nice functionality to get a system that works like caudium vhs or even mod_vhs for apache that I have made too :-) Please tell me how http request is handled by aolserver, in which files I have to dig and how can I add it nicely to, I hope, integrate this functionality on next aolserver version if it is possible... ? Sincerly, Xavier -- Xavier Beaudouin - Unix System Administrator Projects Leader. President of Kazar Organization : http://www.kazar.net/ Please visit http://caudium.net/, home of Caudium Camas projects -- 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] Mass Virtual Hosting system for AolServer 4.0.x?
Hello, I am Xavier Beaudouin, Caudium Webserver Maintainer. I'd like to port on AolServer a nice thing (or beast?) we did on Caudium : VHS. Now since I am new on Aolserver, I am trying to understand how I can add such nice functionality to get a system that works like caudium vhs or even mod_vhs for apache that I have made too :-) I'm sure some folks will jump in with advice on where to look. But before they do that, I'm curious, why are you interested in doing this work, and what led you to AOLserver? Thanks :) Simple, the Caudium seems to die, not because it is less and less used, but because the language on which it is based (pike) is more and more unstable, difficult to deal with and in general not very well maintained. Imagine a language that between 2 version is not compatible with itself... (Like a perl script that can work only on perl 4 because most of low level call has changed names, place, or even way to call them). AOLServer has same basis about technology : eg high level language, some low level C modules, and threads as Caudium, so that's why I'd love to understand how it is working, and make things I like on this server. On other hands, I was very disspointed about Apache, that didn't changed a lot its api and still stay on 1990's even if Apache 2.0 has threads... but you still cannot play with connection object as I do on Caudium to make some unique features. Here is my 0,02c... :) /Xavier -- Xavier Beaudouin - Unix System Administrator Projects Leader. President of Kazar Organization : http://www.kazar.net/ Please visit http://caudium.net/, home of Caudium Camas projects -- 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.
