2006/12/30
IRC [00:34] *** robamauan joined the chat.
IRC [00:35] <robamauan> hola a tosos
IRC [00:35] <robamauan> ;)
IRC [00:36] <robamauan> alguen que quiera paticar
IRC [00:36] *** robamauan parted the chat.
IRC [03:21] *** jeremy_c joined the chat.
IRC [03:22] <jeremy_c> Anyone around that can help with nspostgres or nsmysql? nspostgres fails to load saying: Could not find Ns_DbDriverInit in ... path to nspostgres.so
IRC [03:23] <jeremy_c> nsmysql fails to load: Warning: modload: could not load /usr/home/jeremy/projects/aolserver/tcl/bin/nsmysql.so: /usr/home/jeremy/projects /aolserver/tcl/lib/libnsmysql.so: Undefined symbol "mysql_field_count"
IRC [03:24] <jeremy_c> That's a problem with nsmysql being for 3.x when I have 5.x installed. I bbelieve I can fix that by editing the source and updating the module to work with 5.x, but didn't want to have to do it if it's not necessary.
IRC [03:24] <jeremy_c> Any thoughts?
IRC [08:46] <Dossy> hold on.
IRC [08:46] <Dossy> Just woke up -- let me re-read what you asked. :)
IRC [08:47] <Dossy> I think you're right about nsmysql--it needs to be updated for the 5.x client lib.
IRC [08:48] <Dossy> The nspostgres error--are you loading nsdb.so?
IRC [08:48] <Dossy> And when compiling, make sure "-lnsdb" is in the link phase command.
IRC [10:55] <jeremy_c> Ok, I'll give it a try with the postgresql fix.
IRC [10:56] <jeremy_c> About the mysql 5.x... If I copy the current nsmysql and make a nsmysql5, would anyone want it as a new module or no?
IRC [10:58] <jeremy_c> Oh, nsdb.so is loaded, I am unsure if nspostgresql linked against it or not. That's what I'll go check
IRC [11:09] <jeremy_c> Same problem with postgres... Here is the output of my compile and load of nsd: http://paste.lisp.org/display/33705
IRC [11:13] <jeremy_c> hm, somethings is not working right in the linking. libnspostgres.so is 13k while nspostgres.so is 1.5k, is that right?
IRC [11:17] <jeremy_c> got it. Instead of ld -Bshareable ... I did my own: gcc -shared -o nspostgres.so nspostgres.o -L/usr/home/jeremy/projects/aolserver/tcl/lib -L/usr/local/lib -lpq -lnsdb -lnsd -lnsthread -ltcl8.4 -lpthread -lm -rpath /usr/home/jeremy/projects/aolserver/tcl/lib ... that caused it to load
IRC [11:58] <Dossy> Cool.
IRC [11:58] <Dossy> Puzzling why it didn't do that to begin with.
IRC [11:59] <Dossy> something wrong with that pastebin URL, too--
IRC [11:59] <Dossy> I get a 502 Bad Gateway ... ?
IRC [11:59] <Dossy> I don't know if a nsmysql5 is the right answer here.
IRC [11:59] <Dossy> I'd rather use some intelligent/conditional code.
IRC [12:00] <Dossy> Or, maybe not... maybe it is the right thing to do.
IRC [12:00] <Dossy> However, suppose mysql 6.x comes out--then what? Clone nsmysql5 and name it nsmysql6 ... ?
IRC [12:00] <Dossy> Versioning hell is just that. :-)
IRC [12:03] <jeremy_c> Dossy, you are right about the versioning.
IRC [12:03] <jeremy_c> About the URL, I just loaded it myself, from a fresh browser start. Weird it's not working for you.
IRC [12:04] <jeremy_c> I am on FreeBSD, I wonder if it need a different compile or something for it's shared libraries?
IRC [12:04] <jeremy_c> On compile time, I am unsure of how to detect what mysql lib I would be linking against.
IRC [12:06] <jeremy_c> I've never done anything like that with mysql. I obviously know how to use the preprocessor to handle #ifdef MYSQL3, or MYSQL5, etc...
IRC [12:07] <Dossy> #define MYSQL_VERSION_ID 40111
IRC [12:07] <Dossy> look in <mysql_version.h>
IRC [12:07] <jeremy_c> Dossy: well, that made things easy :-D
IRC [12:07] <Dossy> Of course, this means that one compiled nsmysql.so might expect one version of libmysqlclient_r.so than another would.
IRC [12:07] <Dossy> :)
IRC [12:07] <Dossy> So, yeah, you might #if MYSQL_VERSION_ID > 50000
IRC [12:08] <jeremy_c> I think the incompatible changes happened in 4.x, I'd have to go back and look.
IRC [12:39] <Dossy> yeah, 3.x and 4.x seem to be okay, 4.x and 5.x is where things diverge.
IRC [14:41] <jeremy_c> Can I not do <% while {[get_stuff] > 1} { %> html display <% } %> in adp pages?
IRC [16:01] <Dossy> AOLserver 4.5?
IRC [16:01] <jeremy_c> yes
IRC [16:06] <Dossy> In the server config, in the server's "adp" config section, set "ns_param singlescript true"
IRC [16:10] <jeremy_c> Thats much better, thanks
IRC [16:54] <Dossy> :)