AOLserver Chat Logs

2007/02/15

IRC [00:00] <jim> try again
IRC [00:00] <jim> (of course remember to gmake clean)
IRC [00:01] <partymola> kk :)
IRC [00:04] <partymola> [15/Feb/2007:06:03:59][3488.134804992][-conn:0-] Notice: Opening web-so on 127.0.0.1, port 5432
IRC [00:04] <partymola> [15/Feb/2007:06:03:59][3488.134804992][-conn:0-] Notice: Ns_PgOpenDb(postgres_driver): Openned connection to 127.0.0.1:5432:web-so.
IRC [00:04] <partymola> [15/Feb/2007:06:03:59][3488.134804992][-conn:0-] Error: Tcl exception:
IRC [00:04] <partymola> Database operation "dml" failed (exception NSDB, "Query was not a DML or DDL command.")
IRC [00:04] <partymola> while executing
IRC [00:04] <partymola> "ns_db dml $db $sql"
IRC [00:05] <jim> could you restart the server and show where it first loads the driver?
IRC [00:05] <partymola> okee
IRC [00:05] <partymola> [15/Feb/2007:06:05:44][3535.134561792][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nspostgres.so'
IRC [00:05] <partymola> [15/Feb/2007:06:05:44][3535.134561792][-main-] Notice: PostgreSQL loaded.
IRC [00:07] <jim> ok, when you last did the make, what gmake (after the gmake clean) did you do?
IRC [00:07] <partymola> gmake POSTGRES=PG_CONFIG
IRC [00:07] <partymola> later the ld thing
IRC [00:08] <partymola> and finally gmake POSTGRES=PG_CONFIG install
IRC [00:08] <jim> ok, like to have you do these:
IRC [00:08] <jim> gmake clean
IRC [00:09] <jim> gmake INST=/usr/local/aolserver POSTGRES=PG_CONFIG
IRC [00:09] <jim> do your ld thing
IRC [00:09] <jim> then
IRC [00:09] <jim> gmake INST=/usr/local/aolserver POSTGRES=PG_CONFIG install
IRC [00:10] <partymola> [xel@peter ~/temp/nspostgres] sudo gmake INST=/usr/local/aolserver POSTGRES=PG_CONFIG install
IRC [00:10] <partymola> /usr/local/aolserver -d /usr/local/aolserver/bin -e nspostgres.so
IRC [00:10] <partymola> gmake: execvp: /usr/local/aolserver: Permission denied
IRC [00:10] <partymola> gmake: *** [install-mod] Error 127
IRC [00:10] <partymola> weird :S
IRC [00:11] <jim> aha... so, you don't have perm to write there for some reason...'
IRC [00:11] <partymola> i do
IRC [00:11] <partymola> the problem is the command that it tries to execute lol
IRC [00:11] <partymola> /usr/local/aolserver -d /usr/local/aolserver/bin -e nspostgres.so
IRC [00:11] <partymola> that's not a valid command at all!!
IRC [00:13] <jim> yeah, that's true
IRC [00:13] <jim> ok, so copy the nspostgres.so to /usr/local/aolserver/bin
IRC [00:13] <partymola> ok
IRC [00:14] <jim> and then try restarting &etc
IRC [00:15] <partymola> [15/Feb/2007:06:14:59][3656.134804992][-conn:0-] Notice: dbdrv: opening database 'postgres_driver:127.0.0.1:5432:web-so'
IRC [00:15] <partymola> [15/Feb/2007:06:14:59][3656.134804992][-conn:0-] Notice: Opening web-so on 127.0.0.1, port 5432
IRC [00:15] <partymola> [15/Feb/2007:06:14:59][3656.134804992][-conn:0-] Notice: Ns_PgOpenDb(postgres_driver): Openned connection to 127.0.0.1:5432:web-so.
IRC [00:15] <partymola> ok
IRC [00:15] <partymola> that's a valid 1row request
IRC [00:15] <partymola> [15/Feb/2007:06:15:36][3656.134804992][-conn:0-] Error: Tcl exception:
IRC [00:15] <partymola> Database operation "dml" failed (exception NSDB, "Query was not a DML or DDL command.")
IRC [00:15] <partymola> while executing
IRC [00:15] <partymola> "ns_db dml $db $sql"
IRC [00:15] <partymola> that's the invalid one
IRC [00:16] <jim> I'm not quite sure what to say here :)
IRC [00:16] <partymola> why?
IRC [00:17] <jim> because no matter what we do, the message doesn't change, and I'm trying to add to that message
IRC [00:17] <partymola> :S
IRC [00:17] <jim> plus the fact that the install target isn't working properly is kinda weird
IRC [00:18] <jim> one final test. the last one tonite.
IRC [00:19] <jim> first, rm nspostgres.o
IRC [00:19] <jim> one sec...
IRC [00:19] <partymola> ok
IRC [00:19] <jim> could you show me head -2 ChangeLog?
IRC [00:21] <partymola> [xel@peter ~/temp/nspostgres] head -2 ChangeLog
IRC [00:21] <partymola> 2007-02-14 Jim Lynch <jim@jam.sessionsnet.org>
IRC [00:21] <partymola> it didn't, so now I'm moving the message inside the quotation marks
IRC [00:21] <jim> ok, good
IRC [00:21] <jim> gmake INST=/usr/local/aolserver POSTGRES=PG_CONFIG
IRC [00:22] <partymola> done
IRC [00:22] <jim> run your ld invocation
IRC [00:22] <partymola> done
IRC [00:22] <jim> could you show that btw?
IRC [00:22] <partymola> [xel@peter ~/temp/nspostgres] 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 [00:22] <partymola> [xel@peter ~/temp/nspostgres]
IRC [00:24] <jim> out of curiousity... do you have an aolserver whose prefix is /usr/local and another one at /usr/local/aolserver?
IRC [00:24] <jim> could that be possible?
IRC [00:24] <partymola> no, prefix is /usr/local
IRC [00:25] <partymola> so aolserver is at /usr/local/aolserver
IRC [00:25] <jim> hmm...
IRC [00:26] <partymola> [xel@peter ~/temp/nspostgres] tree -d -L 1 /usr/local/
IRC [00:26] <partymola> /usr/local/
IRC [00:26] <partymola> |-- aolserver
IRC [00:26] <partymola> |-- bin
IRC [00:26] <partymola> |-- build-1
IRC [00:26] <partymola> |-- cmucl
IRC [00:26] <jim> is there a /usr/local/bin/nsd?
IRC [00:26] <partymola> etc ...
IRC [00:26] <partymola> [xel@peter ~/temp/nspostgres] tree -d -L 1 /usr/local/aolserver/
IRC [00:26] <partymola> /usr/local/aolserver/
IRC [00:26] <partymola> |-- bin
IRC [00:26] <partymola> |-- include
IRC [00:26] <partymola> |-- lib
IRC [00:26] <partymola> |-- log
IRC [00:26] <partymola> |-- modules
IRC [00:26] <partymola> `-- servers
IRC [00:26] <jim> that's an install of aolserver
IRC [00:26] <partymola> [xel@peter /usr/local/bin] ls -l /usr/local/bin/nsd
IRC [00:26] <partymola> ls: /usr/local/bin/nsd: No such file or directory
IRC [00:26] <jim> ok
IRC [00:26] <partymola> aolserver is at /usr/local/aolserver
IRC [00:27] <partymola> no copies in any other place :)
IRC [00:27] <jim> ok, do you have /usr/local/aolserver/bin/nsd?
IRC [00:28] <partymola> [xel@peter /usr/local/bin] ls -l /usr/local/aolserver/bin/nsd
IRC [00:28] <partymola> -rwxr-xr-x 1 root simpleoption 8113 Dec 16 11:27 /usr/local/aolserver/bin/nsd
IRC [00:28] <partymola> yeah
IRC [00:28] <partymola> that's the aolserver i run
IRC [00:28] <jim> ok. your aolserver installation is definitely in /usr/local/aolserver
IRC [00:29] <jim> and the server itself (nsd) is in /usr/local/aolserver/bin/nsd
IRC [00:29] <partymola> yep
IRC [00:32] <jim> ok... cp nspostgres.so /usr/local/aolserver/bin/
IRC [00:33] <partymola> done
IRC [00:33] <jim> and restart... pls. show the module loading too
IRC [00:34] <partymola> [15/Feb/2007:06:34:24][3795.134561792][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nspostgres.so'
IRC [00:34] <partymola> [15/Feb/2007:06:34:24][3795.134561792][-main-] Notice: PostgreSQL loaded.
IRC [00:34] <jim> good... now try the good query twice
IRC [00:34] <jim> you should see the db open once
IRC [00:35] <partymola> [15/Feb/2007:06:35:32][3795.134804992][-conn:0-] Notice: dbdrv: opening database 'postgres_driver:127.0.0.1:5432:web-so'
IRC [00:35] <partymola> [15/Feb/2007:06:35:32][3795.134804992][-conn:0-] Notice: Opening web-so on 127.0.0.1, port 5432
IRC [00:35] <partymola> [15/Feb/2007:06:35:32][3795.134804992][-conn:0-] Notice: Ns_PgOpenDb(postgres_driver): Openned connection to 127.0.0.1:5432:web-so.
IRC [00:35] <partymola> yep
IRC [00:35] <partymola> that's all i see
IRC [00:36] <jim> so the second time you don't see that logging, any of it... right?
IRC [00:36] <partymola> yes, i see nothing
IRC [00:36] <partymola> only that message when doing the 1st good query
IRC [00:36] <partymola> with 2nd query, nothing is logged
IRC [00:37] <partymola> going for the dml query?
IRC [00:37] <jim> ok, now do good query with dml
IRC [00:38] <partymola> [15/Feb/2007:06:37:55][3795.134805504][-conn:2-] Error: Tcl exception:
IRC [00:38] <partymola> Database operation "dml" failed (exception NSDB, "Query was not a DML or DDL command.")
IRC [00:38] <partymola> while executing
IRC [00:38] <partymola> "ns_db dml $db $sql"
IRC [00:38] <jim> ok, all done for now...
IRC [00:38] <partymola> ok
IRC [00:38] <jim> I'll get to the bottom of this in a few days
IRC [00:38] <partymola> what did you expect to show?
IRC [00:39] <jim> something like:
IRC [00:40] <jim> (exception NSDB, "Query was not a DML or DDL command. ((Status of PQexec call: PQEXEC_COMMAND_OK)")
IRC [00:41] <partymola> ok :S
IRC [00:41] <partymola> does it work that way on your computer?
IRC [00:42] <jim> I haven't been trying that specific test... so actual fact, I'm not sure... I have a small suspicion it works like yours is
IRC [00:42] <partymola> ok
IRC [00:42] <jim> but other calls do show the result status code
IRC [00:43] <partymola> ok, i'll be around here most of the time
IRC [00:43] <partymola> if you need to speak to me
IRC [00:43] <partymola> say my name anytime
IRC [00:43] <jim> cool, thanks very much for testing
IRC [00:43] <partymola> well, at this time u use to be sleeping
IRC [00:44] <partymola> since it's 6.47 am here at the moment X'D
IRC [00:44] <partymola> i use*
IRC [00:45] <partymola> no problem, i use nspostgres everyday, so spending time on making it better is more than ok :)
IRC [00:45] <jim> oh, oops
IRC [00:45] <jim> well what's your tz offset?]
IRC [00:45] <partymola> GMT+1
IRC [00:46] <partymola> my sleeping offset uses to be GMT-3 X'D
IRC [00:46] <partymola> approx.
IRC [00:46] <jim> ok, I'm out and thanks again
IRC [00:46] <partymola> no problem at all
IRC [00:46] <partymola> have a nice day/night
IRC [00:46] <partymola> and thanks for your hard work ;)
IRC [01:22] <holycow> jim rocks :)
IRC [06:00] *** holycow parted the chat.
IRC [09:09] *** partymola parted the chat.
IRC [11:00] *** holycow joined the chat.
IRC [11:04] <Dossy> :)
IRC [11:04] *** Dossy_ joined the chat.
IRC [11:10] <Dossy_> ah, gaim's tcl plugin works. :)
IRC [11:11] <Dossy_> hey, can you add a jabber chat room to your gaim buddy list?
IRC [11:12] <Dossy_> so I don't have to keep typing in all the information every time I want to join/rejoin
IRC [11:18] <Dossy> woops, w/w
IRC [12:32] *** Dossy_ parted the chat.
IRC [12:33] *** Dossy_ joined the chat.
IRC [13:28] <jim> hi
IRC [13:33] <jim> anyone here?
IRC [13:39] <jim> Your mail to 'aolserver-commits' with the subject "nspostgres ChangeLog,1.20,1.21 Makefile,1.15,1.16 README,1.3,1.4" Is being held until the list moderator can review it for approval. Reason, not member.
IRC [13:42] <Dossy_> yeah--that's typical
IRC [13:42] <Dossy_> don't sweat it--after your first commit, you get on the accept-list
IRC [13:42] <Dossy_> you should have seen your commit messages on aolserver-sf@ list by now
IRC [13:43] <Dossy_> you have no idea how much spam gets sent to the aolserver-commits list
IRC [13:43] <Dossy_> so, it's "everything moderated by default"
IRC [13:43] <jim> ok
IRC [13:43] <Dossy_> thus, none of the spam actually gets through
IRC [13:43] <jim> I'm talking on #tcl about the possibility of using object return values
IRC [13:45] <jim> it turns out that once aolserver moved to later tcls... that that's been happening anyway
IRC [13:45] <jim> I think, like tcl-8.anything
IRC [13:47] <jim> I'm being told that one advantage to going in this direction, is we can give access to the error content to programmers, and open up the format of error messages... this in turn could allow things like internationalization of error messages even though the modules that produce those messages are compiled
IRC [13:48] <jim> I'm also being told that just because this approach will have been tried with one tcl command from an aolserver module or from aolserver itself, doesn't force this to be changed on every command all at once
IRC [14:03] <Dossy_> huh?
IRC [14:03] <Dossy_> not exactly sure what you're getting at...
IRC [14:03] <Dossy_> but yah, the nsdb interface needs serious rework for modern db's
IRC [14:21] *** partymola joined the chat.
IRC [14:21] <partymola> hi
IRC [14:22] <jim> Dossy_: plus, if you take a look at bind variable implementations... you have that in every database driver... why not factor?
IRC [14:50] *** partymola parted the chat.
IRC [15:47] *** partymola joined the chat.
IRC [16:06] *** partymola parted the chat.
IRC [17:30] *** partymola joined the chat.
IRC [17:30] <partymola> Dossy
IRC [17:30] <partymola> are you there?
IRC [17:30] <partymola> I have just seen this: http://www.panoptic.com/wiki/aolserver/Nssession_specification
IRC [17:30] <partymola> is that working correctly?
IRC [17:31] <partymola> i mean, can that be used?
IRC [17:41] <Dossy_> i don't recall
IRC [17:41] <Dossy_> I think so
IRC [17:41] <Dossy_> but it's not fully baked
IRC [17:41] <Dossy_> i'd like to start shipping an official nssession module w/ AOLserver 4.5.x
IRC [17:44] <partymola> ok
IRC [17:44] <partymola> then i think i will do the session thing with TCL >_>
IRC [18:07] <partymola> ..... has anyone got BerkeleyDB running with AOLServer?
IRC [18:14] <Dossy_> BDB isn't thread-safe
IRC [18:14] <Dossy_> so, be careful.
IRC [18:23] <partymola> not even for reading? :|
IRC [18:53] <Dossy_> not sure
IRC [18:54] <partymola> kk ... going for PSQL
IRC [18:54] <partymola> ... as always lol
IRC [20:57] <partymola> another question! :D
IRC [20:57] <partymola> is there some place where i can read about preventing SQL Injection with PostgreSQL & AOLServer ?
IRC [20:59] <jim> hi
IRC [20:59] <partymola> hi jim :)
IRC [20:59] <jim> so...
IRC [20:59] <jim> I keep thinking about this situatiuon of yours...
IRC [21:00] <jim> and I spoke to the tcl people and checked up on the details of throwing error messages and such
IRC [21:01] <jim> it turns out that this -really- should work... details on request, but I eventually want to check this process of yours very carefully
IRC [21:01] <jim> it might boil down to that extra link step
IRC [21:02] <partymola> first you should make sure it works on your machine :)
IRC [21:02] <jim> it does
IRC [21:02] <partymola> and after that... we'll test on mine
IRC [21:02] <partymola> oh
IRC [21:02] <jim> well see if this makes sense to you
IRC [21:02] <jim> :
IRC [21:03] <jim> the normal build process as run by make &etc probably locates the files it reads and writes by fully qualified paths
IRC [21:04] <jim> my -guess- here... is that we're picking up the wrong nspostgres.o (not .so)
IRC [21:04] <jim> could that be possible?
IRC [21:04] <partymola> oh
IRC [21:04] <partymola> well, i checked dates for files
IRC [21:05] <partymola> and they were updated after each building & installing
IRC [21:05] <partymola> i used to do ls -l against them
IRC [21:05] <jim> ok
IRC [21:05] <partymola> and they had date updated
IRC [21:05] <jim> ok, that does sound reasonable
IRC [21:05] <jim> but let me ask you this... if you do find $HOME -name nspostgres.o
IRC [21:06] <jim> how many hits do you get (note, I'm assuming you build somewhere off your home dir
IRC [21:06] <jim> )
IRC [21:07] <holycow> are you guys at it again?
IRC [21:07] <holycow> holy sheize :)
IRC [21:07] <partymola> let me see
IRC [21:07] <holycow> jim, so whats the dealio, its like you are on fire or something these last few weeks
IRC [21:08] <jim> I did extensive testing and mucking around with the message, and (as mentioned) I spoke to the tcl people about -EXACTLY- how the error throwing process worked
IRC [21:08] <jim> holycow: not sure, I think it might be more gooder stuff in my diet
IRC [21:09] <jim> s/more/some/
IRC [21:09] <partymola> [xel@peter ~] find $HOME -name nspostgres.o
IRC [21:09] <partymola> /home/xel/temp/nspostgres/nspostgres.o
IRC [21:10] <jim> so you're building in /home/xel/temp/nspostgres/?
IRC [21:10] <jim> and not another place too?
IRC [21:11] <jim> if you're running X... pull up a shell, su - root and run almost the same find
IRC [21:11] <jim> except use find /
IRC [21:11] <jim> not $HOME
IRC [21:11] <jim> and let it chug while we do other stuff
IRC [21:13] <jim> more oranges, more bananas, pears, that kind of thing
IRC [21:14] <jim> you'll get that one again, plus any nspostgres.o you have anywhere on your drive
IRC [21:15] <partymola> yes, i know
IRC [21:15] <partymola> the funny thing is that i run updatedb daily
IRC [21:15] <partymola> it was supposed to run 30 minutes ago...
IRC [21:15] <partymola> but i used it to locate all nspostgres.o matches... and it said that i had not that file on my hd lol
IRC [21:16] <jim> not at all?
IRC [21:16] <jim> that's not so surprising
IRC [21:16] <jim> curious about something else... ld --version
IRC [21:19] <partymola> wait, wait
IRC [21:19] <jim> holycow: now that you';re here...
IRC [21:19] <partymola> it's starting to find files
IRC [21:19] <partymola> locate didn't but find does
IRC [21:19] * jim hunts for more guinea pigs :)
IRC [21:19] <partymola> quite strange :S
IRC [21:19] <jim> partymola: how many?
IRC [21:19] <jim> just the one?
IRC [21:19] <partymola> at the moment, only one, but it's still finding
IRC [21:19] <jim> ok
IRC [21:20] <partymola> it's a laptop, so it's slow
IRC [21:20] <jim> is it the same one you already found?
IRC [21:20] <partymola> yes, the same @ my home
IRC [21:20] <partymola> but, for your information:
IRC [21:20] <partymola> [xel@peter ~] ls -l /usr/local/aolserver/bin/nspostgres.so
IRC [21:20] <partymola> -rwxr-xr-x 1 root simpleoption 14198 Feb 15 06:33 /usr/local/aolserver/bin/nspostgres.so
IRC [21:20] * jim will eventually want a laptop with an internal scsi drive
IRC [21:21] <jim> partymola: well we expected that one
IRC [21:21] <jim> that's the actual module
IRC [21:21] <partymola> yep
IRC [21:21] <partymola> let's see if there is a third one lol
IRC [21:21] <partymola> when i did the make install step
IRC [21:21] <jim> as you know, I was looking for the object file (the .o)
IRC [21:21] <partymola> i checked 2-3 times that files were being saved into the correct directory
IRC [21:21] <partymola> ah, true lol
IRC [21:21] <partymola> ok, i'll shut up xD
IRC [21:22] <partymola> <---- FAILED!
IRC [21:22] <jim> nonoNO
IRC [21:22] <jim> don't shut up
IRC [21:22] <jim> that doesn't help me one bit
IRC [21:22] <jim> well when you did the find, you did -name nspostgres.o?
IRC [21:31] <jim> umm wha happened? whered everybody go?
IRC [21:36] <holycow> i have a meeting to go to jim
IRC [21:36] <holycow> :/
IRC [21:36] <jim> oh ok... let me ask you this tho... do you have an aolserver build started somewhere?
IRC [21:38] <holycow> i did but had to wipe the vmware image for another config. after the meeting i'm setting up another image however
IRC [21:39] <jim> bascaly I want to see if you can build nspostgres without incident now
IRC [21:39] <jim> - get it from cvs
IRC [21:39] <jim> - do the make
IRC [21:39] <holycow> ah ... i can try my buildscripts over the weekend if you like
IRC [21:39] <jim> works? or not works?
IRC [21:39] <holycow> maltes stuff pulls from cvs if i remember correctly
IRC [21:39] *** partymola parted the chat.
IRC [21:40] <holycow> i figured it all out last time *nod*
IRC [21:40] <jim> do you know if he's pulling nspostgres from the cvs without specifying a tag (aka, pulling from HEAD)
IRC [21:41] <jim> ?
IRC [21:52] <holycow> back
IRC [21:52] <holycow> holy fuck
IRC [21:53] <holycow> phone call at 7 pm
IRC [21:53] <holycow> every time jim :)
IRC [21:53] <jim> it doesn't have to be today
IRC [21:53] <holycow> jim, not offhand let me look
IRC [21:57] <holycow> guess what?
IRC [21:57] <holycow> another call
IRC [21:57] <holycow> wow
IRC [21:57] <jim> yer in demand :)
IRC [22:04] <holycow> no dude
IRC [22:05] <holycow> its jus tyou
IRC [22:05] <holycow> lol!
IRC [22:05] <holycow> :)
IRC [22:05] <jim> so, at least let's see if you can pull down the code
IRC [22:05] <jim> if you have time that is
IRC [22:05] <holycow> i don't have time for a pull i just can take a look at his script
IRC [22:05] <holycow> sec
IRC [22:06] <holycow> cvs -z3 -d:pserver:anonymous@aolserver.cvs.sourceforge.net:/cvsroot/aolserver co nspostgres
IRC [22:06] <holycow> directly from sourceforge
IRC [22:07] <holycow> # Install nspostgres
IRC [22:07] <holycow> cd ../nspostgres
IRC [22:07] <holycow> export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:${PG}/lib
IRC [22:07] <holycow> make install POSTGRES=${PG} ACS=1 NSHOME=${NS}
IRC [22:07] <jim> no tags, so you'd get HEAD which is where my changes are
IRC [22:07] <holycow> ah!
IRC [22:07] <holycow> okay *nod*
IRC [22:07] <jim> well this time...
IRC [22:07] <jim> you would instead do:
IRC [22:08] <jim> make install POSTGRES=PG_CONFIG ACS=1 NSHOME=${NS}
IRC [22:08] <holycow> interesting
IRC [22:08] <jim> because it's a little better to let postgres tell you where it is
IRC [22:08] <holycow> okay i'll haveto bug you that over the weekend
IRC [22:08] <holycow> thx jim
IRC [22:08] <holycow> ttyl
IRC [22:08] <jim> yep
IRC [22:08] *** holycow parted the chat.
IRC [22:08] <jim> cya
IRC [22:12] *** jim parted the chat.