2007/02/14
IRC [01:28] *** holycow parted the chat.
IRC [01:42] *** holycow joined the chat.
IRC [03:53] *** holycow parted the chat.
IRC [10:21] *** partymola joined the chat.
IRC [10:21] <partymola> hi Dossy
IRC [10:22] <partymola> i've found a problem building AOLServer HEAD on Ubuntu 6.10
IRC [10:22] <partymola> scripts at utils are missing the 1st "shebang" line
IRC [10:22] <partymola> so i have had to insert it manually
IRC [10:22] <partymola> "#!/usr/bin/tclsh"
IRC [11:00] <Dossy> no, you don't--you need to read the README
IRC [11:00] <Dossy> :)
IRC [11:01] <Dossy> the configure script needs to know where your tclsh is
IRC [11:01] <Dossy> and it'll invoke the scripts with it explicitly.
IRC [11:49] *** jim joined the chat.
IRC [11:50] <jim> Hi... once again... who maintains nspostgres? I have stuff for you
IRC [11:57] <jim> frankie: you by any chance?
IRC [12:12] *** holycow joined the chat.
IRC [15:28] <Dossy> jim: not sure who is the official maintainer for nspostgres these days.
IRC [15:28] <Dossy> Do you want to be? :)
IRC [15:52] <jim> well maybe :)
IRC [15:53] <jim> but for one thing I have something you asked for...
IRC [15:53] <jim> after I said...
IRC [15:53] <jim> howbout nspg build use pg_config?
IRC [15:53] <jim> you said...
IRC [15:53] <jim> good, also let me specify by path which pg_config to use.
IRC [15:54] <jim> done.
IRC [15:56] <jim> for another, I noticed that the functions that use a local NsPgConn pointer had about 2-3 different names (one of which was nsConn, which I would confuse with the brower connection)
IRC [15:56] <jim> so
IRC [15:56] <jim> I renamed that pointer in each function to nspgConn
IRC [15:57] <jim> hopefully people will appreciate that, and find the overall driver source a bit easier to maintain
IRC [15:57] <jim> (btw, you here?)
IRC [16:06] <jim> the main reason I got into the C part was I wanted to expose the PQexec status whenever the driver output an error message
IRC [16:08] <Dossy> cool.
IRC [16:08] <Dossy> yeah, sorry--busy organizing my buddy list
IRC [16:08] <jim> anyway daveb suggested I get commit right for nspostgres... or do you want to do that differently?
IRC [16:08] <Dossy> just installed GAIM 2--comparing it to Trillian, heh
IRC [16:08] <Dossy> nope, I'll gladly give you commit privs--what's your SF username?
IRC [16:08] <jim> jwl I belive
IRC [16:09] <Dossy> can you try logging into the sf website and make sure?
IRC [16:09] <jim> sure
IRC [16:10] <jim> I;m in
IRC [16:11] <jim> jwl, definitely
IRC [16:16] <jim> bbs... sushi run :)
IRC [16:30] <Dossy> ok, jim--you're added
IRC [16:59] <jim> back
IRC [20:00] *** holycow parted the chat.
IRC [22:12] <jim> there, done with all commits I have for nspostgres.
IRC [22:12] <jim> now... let's test the dogcrap out of it :)
IRC [22:13] <partymola> lol
IRC [22:13] <partymola> jim: have you done important changes to nsportgres?
IRC [22:13] <partymola> i use it :)
IRC [22:13] <jim> well, I think they're important, yet
IRC [22:13] <jim> yes
IRC [22:13] <partymola> is it worth upgrading to the latest version?
IRC [22:14] <jim> a lot of my changes alter the build system
IRC [22:14] <partymola> previous build system didn't work correctly... lol
IRC [22:14] <partymola> have you tested your build system on BSD & Linux?
IRC [22:14] <jim> for example, I allow you to use pg_config to tell the nspostgres build where things are
IRC [22:14] <jim> I have no bsd :)
IRC [22:14] <partymola> i do :)
IRC [22:14] <jim> but linux, yes
IRC [22:14] <partymola> if you want, i can help u :)
IRC [22:14] <jim> please do
IRC [22:15] <partymola> okies
IRC [22:15] <partymola> where can i download source code for nspostgres?
IRC [22:15] <jim> I put my stuff in separate commits, so that you could see the chronology of what I did
IRC [22:15] <jim> from cvs.
IRC [22:15] <partymola> and... where is cvs? lol
IRC [22:16] <jim> the aolserver cvs
IRC [22:16] <jim> cvs -d:pserver:anonymous@aolserver.cvs.sourceforge.net:/cvsroot/aolserver login
IRC [22:16] <jim> then:
IRC [22:17] <jim> I think if it asks for a password, it's blank
IRC [22:17] <jim> then you do:
IRC [22:17] <partymola> ok
IRC [22:17] <jim> cvs -z3 -d:pserver:anonymous@aolserver.cvs.sourceforge.net:/cvsroot/aolserver co -P nspostgres
IRC [22:17] <partymola> logged in
IRC [22:18] <partymola> In file included from nspostgres.c:32:
IRC [22:18] <partymola> nspostgres.h:48:22: libpq-fe.h: No such file or directory
IRC [22:18] <jim> ok, try:
IRC [22:18] <jim> wait...
IRC [22:18] <jim> show me your make command
IRC [22:19] <partymola> i have that file at /usr/local/include
IRC [22:19] <partymola> [xel@peter ~/temp/nspostgres] gmake
IRC [22:19] <partymola> cc -pipe -DBIND_EMULATION -I/usr/include/pgsql -O -Wall -Wno-implicit-int -fno-strict-aliasing -fPIC -O -pipe -march=pentium3 -I/usr/local/aolserver/include -I/usr/local/include/tcl8.4 -DNO_CONST -DNO_VALUES_H=1 -DHAVE_LIMITS_H=1 -DHAVE_ ...
IRC [22:19] <jim> so you just did gmake
IRC [22:19] <partymola> of course, make doesn't work
IRC [22:20] <jim> ok, where is your aolserver install? /usr/local/aolserver?
IRC [22:20] <partymola> yes
IRC [22:20] <jim> now, try this: which pg_config
IRC [22:21] <partymola> /usr/local/bin/pg_config
IRC [22:21] <jim> ok good, so you used /usr/local as --prefix
IRC [22:21] <partymola> just a thing: i manually executed the same make line, but adding -I/usr/local/include , and then it worked :)
IRC [22:21] <jim> you can also do this:
IRC [22:22] <jim> run gmake clean first... and then
IRC [22:22] <jim> make POSTGRES=PG_CONFIG
IRC [22:22] <jim> err
IRC [22:22] <jim> ==G==make POSTGRES=PG_CONFIG
IRC [22:22] *** holycow joined the chat.
IRC [22:22] <jim> not used to that :P
IRC [22:23] <partymola> ok, it worked now
IRC [22:23] <partymola> gmake POSTGRES=PG_CONFIG <- worked
IRC [22:23] <jim> ok, good... and you didn't have to add anything?
IRC [22:23] <partymola> nothing
IRC [22:23] <partymola> it just worked
IRC [22:23] <partymola> it compiled all
IRC [22:23] <jim> ok, that's good...
IRC [22:23] <partymola> without problems
IRC [22:23] <partymola> please, add that to readme ;)
IRC [22:23] <jim> now you can do make install
IRC [22:23] <partymola> so FreeBSD users can know that XD
IRC [22:24] <partymola> perfect, it's installed now
IRC [22:24] <jim> ok, while watching your aolserver error log...
IRC [22:24] <jim> restart your aolserver
IRC [22:24] <jim> you an openacs user?
IRC [22:25] <partymola> [15/Feb/2007:04:24:35][2489.134561792][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nspostgres.so'
IRC [22:25] <partymola> [15/Feb/2007:04:24:35][2489.134561792][-main-] Warning: modload: could not find Ns_DbDriverInit in /usr/local/aolserver/bin/nspostgres.so
IRC [22:25] <partymola> [15/Feb/2007:04:24:35][2489.134561792][-main-] Error: dbdrv: failed to load driver 'postgres_driver'
IRC [22:25] <partymola> [15/Feb/2007:04:24:35][2489.134561792][-main-] Error: dbinit: no such default pool 'postgres_pool'
IRC [22:25] <partymola> no, i don't use openacs
IRC [22:26] <jim> ok
IRC [22:26] <jim> try this:
IRC [22:26] <jim> gmake clean
IRC [22:26] <partymola> done
IRC [22:27] <jim> gmake AOLSERVER=/usr/local/aolserver INST=/usr/local/aolserver POSTGRES=PG_CONFIG
IRC [22:27] <partymola> done
IRC [22:27] <jim> gmake install
IRC [22:27] <partymola> done
IRC [22:28] <partymola> restarted aolserver and:
IRC [22:28] <jim> now try restarting
IRC [22:28] <partymola> [15/Feb/2007:04:27:49][2576.134561792][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nspostgres.so'
IRC [22:28] <partymola> [15/Feb/2007:04:27:49][2576.134561792][-main-] Warning: modload: could not find Ns_DbDriverInit in /usr/local/aolserver/bin/nspostgres.so
IRC [22:28] <partymola> [15/Feb/2007:04:27:49][2576.134561792][-main-] Error: dbdrv: failed to load driver 'postgres_driver'
IRC [22:28] <partymola> [15/Feb/2007:04:27:49][2576.134561792][-main-] Error: dbinit: no such default pool 'postgres_pool'
IRC [22:28] <partymola> again :|
IRC [22:28] <partymola> file is compiled, and it's put in the right place
IRC [22:29] <jim> I've gotten that message before, I know rudamentarilly what it's saying... but I don't presently know why it would do that
IRC [22:29] <jim> oh, which aolserver do you have?
IRC [22:30] <partymola> [xel@peter /usr/local/aolserver/bin] ./nsd -V
IRC [22:30] <partymola> AOLserver/4.5.0 (aolserver4_5)
IRC [22:30] <partymola> CVS Tag: $Name: $
IRC [22:30] <partymola> Built: Dec 16 2006 at 11:27:22
IRC [22:30] <partymola> Tcl version: 8.4
IRC [22:30] <partymola> Platform: freebsd
IRC [22:30] <jim> ok... do you have the original driver?
IRC [22:30] <jim> if no, it's easy to getr
IRC [22:31] <partymola> i am gonna take a look at my wiki
IRC [22:31] <partymola> i have how to install original driver there XD
IRC [22:31] <jim> all you should have to do,
IRC [22:31] <jim> is cd into the nspostgres dir
IRC [22:32] <jim> then do:
IRC [22:32] <jim> cvs update -Pd -r v4.0
IRC [22:32] <jim> err no
IRC [22:32] <jim> cvs update -Pd -r v4_0
IRC [22:32] <jim> that one
IRC [22:33] <partymola> done
IRC [22:33] <jim> take a look at your ChangeLog, show me the first line
IRC [22:33] <jim> head -1 ChangeLog
IRC [22:34] <partymola> 2004-02-04 Lamar Owen <lowen@pari.edu>
IRC [22:35] <jim> ok, perfect... you just downgraded the driver to version 4.0
IRC [22:35] <jim> now, gmake clean
IRC [22:35] <jim> build it
IRC [22:35] <jim> and it should work
IRC [22:36] <partymola> ok
IRC [22:36] <partymola> no, it doesn't work
IRC [22:36] * Dossy is playing with MinGW/MSYS tonight.
IRC [22:36] <Dossy> I might try to produce a Win32 build of AOLserver using MinGW.
IRC [22:36] <jim> also I'm curious to see the link step, the line that produces nspostgres.so from the .o and libs
IRC [22:36] <partymola> but i know how to fish that
IRC [22:36] <partymola> jim: i have one thing noted @ my wiki
IRC [22:36] <partymola> pay attention
IRC [22:36] <partymola> steps to build:
IRC [22:36] <partymola> gmake POSTGRES=/usr/local
IRC [22:37] <partymola> ld -shared -x -o nspostgres.so -L/usr/local/lib -lpq -L. -lnspostgres -L/usr/local/aolserver/lib -lnsd -lnsthread -L/usr/local/lib -ltcl84 -lm -rpath /usr/local/aolserver/lib -rpath /lib nspostgres.o
IRC [22:37] <partymola> gmake POSTGRES=/usr/local install
IRC [22:37] <partymola> and it works now
IRC [22:37] <partymola> [15/Feb/2007:04:36:10][2765.134561792][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nspostgres.so'
IRC [22:37] <partymola> [15/Feb/2007:04:36:10][2765.134561792][-main-] Notice: PostgreSQL loaded.
IRC [22:37] <jim> ok, so something is wrong...
IRC [22:37] <partymola> yeah
IRC [22:38] <partymola> it seems my pal discovered the linking problem and annotated it @ wiki
IRC [22:38] <partymola> let's work to fix it :)
IRC [22:38] <jim> ohh, I see... so he added a link step
IRC [22:38] <partymola> yep
IRC [22:39] <partymola> it seems that linking as Makefile dictates doesn't work correctly
IRC [22:39] <jim> but what I don't understand is why he's not linking with nsdb
IRC [22:39] <partymola> so he put to execute that "ld" statement right after building
IRC [22:40] <jim> Dossy: is there something in 4.5 I need to know that's different from 4.0.10 wrt not linking to nsdb?
IRC [22:41] <Dossy> no
IRC [22:41] <Dossy> not that I know of, anyway
IRC [22:42] <jim> ok... I'll work on this
IRC [22:42] <Dossy> what is that -lnspostgres doing? is there really a libnspostgres.so ... ?
IRC [22:42] <partymola> jim: i am using last CVS version of nspostgres driver doing that "special linking" step, and it works now
IRC [22:42] <jim> partymola: oh, ok
IRC [22:42] <partymola> it seems linking is what fails @ FBSD
IRC [22:43] <jim> try a failed select with it, and see what the error message says
IRC [22:43] <partymola> a select that returns nothing?
IRC [22:43] <jim> we'll have to see how it works under solaris
IRC [22:43] <jim> or a select that selects a nonexistant table or column
IRC [22:44] <jim> and watch your aolserver err log
IRC [22:44] <partymola> that's what i am doing
IRC [22:44] <partymola> wait a sec
IRC [22:44] <jim> ok
IRC [22:45] <jim> select barf from beertruck limit none;
IRC [22:45] <partymola> [15/Feb/2007:04:45:14][2843.134804992][-conn:0-] Notice: Ns_PgOpenDb(postgres_driver): Openned connection to 127.0.0.1:5432:web-so.
IRC [22:45] <partymola> [15/Feb/2007:04:45:14][2843.134804992][-conn:0-] Error: Ns_PgExec: result status: 7 message: ERROR: column "a" does not exist
IRC [22:45] <partymola> [15/Feb/2007:04:45:14][2843.134804992][-conn:0-] Error: dbinit: error(127.0.0.1:5432:web-so,ERROR: column "a" does not exist
IRC [22:45] <partymola> ): 'SELECT url,titulo,autor,a from ensayos order by creado_en desc limit 1'
IRC [22:45] <partymola> [15/Feb/2007:04:45:14][2843.134804992][-conn:0-] Error: Tcl exception:
IRC [22:45] <partymola> Database operation "1row" failed (exception ERROR, "ERROR: column "a" does not exist
IRC [22:45] <partymola> ")
IRC [22:45] <partymola> it works ok
IRC [22:46] *** Dossy_ joined the chat.
IRC [22:46] <jim> what was the exact tcl command you did there?
IRC [22:47] <Dossy_> heh, cool--gaim's IRC client isn't too bad
IRC [22:48] <jim> hey! I have a voice now!
IRC [22:48] <Dossy_> yeah, since you identified via nickserv
IRC [22:48] <partymola> set sql "SELECT url,titulo,autor,a from ensayos order by creado_en desc limit 1"
IRC [22:48] <Dossy_> although, I'm surprised you were able to get "jim"
IRC [22:48] <partymola> set row [ns_db 1row $db $sql]
IRC [22:48] *** Dossy_ parted the chat.
IRC [22:49] <jim> ok, try:
IRC [22:49] <jim> ns_db dmo $db $sql
IRC [22:49] <jim> err
IRC [22:49] <jim> sorry
IRC [22:49] <jim> ns_db dml $db $sql
IRC [22:49] <holycow> hey cool
IRC [22:50] <jim> Dossy, that happened a very long time ago :)
IRC [22:50] <partymola> [15/Feb/2007:04:50:12][2843.134805504][-conn:1-] Error: Ns_PgExec: result status: 7 message: ERROR: column "a" does not exist
IRC [22:50] <partymola> [15/Feb/2007:04:50:12][2843.134805504][-conn:1-] Error: dbinit: error(127.0.0.1:5432:web-so,ERROR: column "a" does not exist
IRC [22:50] <partymola> ): 'SELECT url,titulo,autor,a from ensayos order by creado_en desc limit 1'
IRC [22:50] <partymola> [15/Feb/2007:04:50:12][2843.134805504][-conn:1-] Error: Tcl exception:
IRC [22:50] <partymola> Database operation "dml" failed (exception ERROR, "ERROR: column "a" does not exist
IRC [22:50] <partymola> ")
IRC [22:50] <jim> hey! you got a voice, I got a voice... we got two voices!
IRC [22:50] <jim> ok,
IRC [22:50] <holycow> can i talk now?
IRC [22:50] <holycow> wow!
IRC [22:50] <holycow> *cough*
IRC [22:51] <partymola> clear your voice , holycow ;)
IRC [22:51] <holycow> Dossy, offtopic, bro we need to ditch the aim bot spam dude
IRC [22:51] <holycow> :)
IRC [22:51] <partymola> it's a very special moment
IRC [22:51] <jim> hmm, it's not adding my addition
IRC [22:51] <partymola> what did you add, jim?
IRC [22:51] <holycow> if #debian and #ubuntu don't need it with their 2k worth of users surely we could do sith a simple topic post :)
IRC [22:52] <jim> hmm, ok, try a correct sql with the 1row
IRC [22:53] <partymola> no error, jim
IRC [22:53] <partymola> no messages
IRC [22:53] <jim> ok, now just change 1row to dml
IRC [22:54] <partymola> [15/Feb/2007:04:53:54][2843.135254016][-conn:3-] Error: Tcl exception:
IRC [22:54] <partymola> Database operation "dml" failed (exception NSDB, "Query was not a DML or DDL command.")
IRC [22:54] <partymola> while executing
IRC [22:54] <partymola> etc....
IRC [22:54] <jim> ohh, where the heck is that in the driver...
IRC [22:54] <jim> well it is working... at least there's that
IRC [22:55] <partymola> lol
IRC [22:57] <jim> wait, here it is
IRC [22:57] <partymola> don't worry, i will wait XD
IRC [22:58] <partymola> be right back, time to get some biscuits
IRC [23:00] <partymola> i am back :D
IRC [23:00] * partymola has brought a cake
IRC [23:00] <partymola> anybody wants a piece of cake? ;)
IRC [23:00] <jim> let me try a coupla things here
IRC [23:29] <jim> hey, ya still here? :)
IRC [23:29] <partymola> yeah
IRC [23:30] <jim> I been talking to the tcl gurus... and we came up with a few things to try
IRC [23:30] <partymola> ok
IRC [23:35] <partymola> and what did they say?
IRC [23:36] <partymola> magic words came out from their mouth?
IRC [23:36] <jim> that result message that you get "operation "dml" failed ..." has newlines in it... so I'm removing them to see what happens
IRC [23:38] <jim> ok, you can run the update now
IRC [23:41] <partymola> running
IRC [23:42] <jim> ok, run first the good query with 1row
IRC [23:44] <partymola> [15/Feb/2007:05:43:54][3118.134804992][-conn:0-] Notice: dbdrv: opening database 'postgres_driver:127.0.0.1:5432:web-so'
IRC [23:44] <partymola> [15/Feb/2007:05:43:54][3118.134804992][-conn:0-] Notice: Opening web-so on 127.0.0.1, port 5432
IRC [23:44] <partymola> [15/Feb/2007:05:43:55][3118.134804992][-conn:0-] Notice: Ns_PgOpenDb(postgres_driver): Openned connection to 127.0.0.1:5432:web-so.
IRC [23:44] <partymola> ok, worked
IRC [23:45] <jim> ok now try the same query with dml instead of 1row
IRC [23:46] <partymola> [15/Feb/2007:05:46:03][3118.134805504][-conn:2-] Error: Tcl exception:
IRC [23:46] <partymola> Database operation "dml" failed (exception NSDB, "Query was not a DML or DDL command.")
IRC [23:46] <partymola> while executing
IRC [23:46] <partymola> "ns_db dml $db $sql"
IRC [23:46] <jim> ok, so it was the same
IRC [23:46] <jim> one more test
IRC [23:47] <partymola> tell me
IRC [23:48] <jim> try same thing again, exactly like a min ago
IRC [23:49] <jim> I'll brb
IRC [23:49] <partymola> [15/Feb/2007:05:48:09][3118.134807040][-conn:3-] Error: Tcl exception:
IRC [23:49] <partymola> Database operation "dml" failed (exception NSDB, "Query was not a DML or DDL command.")
IRC [23:49] <partymola> while executing
IRC [23:49] <partymola> "ns_db dml $db $sql"
IRC [23:50] <partymola> same result
IRC [23:55] <jim> ok, I'll move it once again
IRC [23:56] <partymola> okee