Getting nspostgres running with AOLserver4.5.2 under OSX Mountain Lion

[Jamie Ross]

Hello everyone!  Once again I am building a aolserver system and looking at the alternatives and relearning all the build issues (last time was in 2005).  I have built nspostgres and it seems to install correctly but I am not seeing it load in the log in spite of following all of the config files.  I have my postgresql 9.2 sitting under /Library/postgresql/9.2 and compiled against that with the aolserver in /usr/local/aolserver.

As you can see below, I don't see it loading and of course it fails when I make a ns_db call from my adp code

Does anyone have any suggestions?

thanks

Jamie Ross

[13/Feb/2013:14:47:35][24260.2093064576][-main-] Notice: config.tcl: starting to read config file...

[13/Feb/2013:14:47:35][24260.2093064576][-main-] Warning: config.tcl: nsssl not loaded -- key/cert files do not exist.

[13/Feb/2013:14:47:35][24260.2093064576][-main-] Notice: config.tcl: finished reading config file.

[13/Feb/2013:14:47:35][24260.2093064576][-main-] Notice: nsmain: AOLserver/4.5.2 starting

[13/Feb/2013:14:47:35][24260.2093064576][-main-] Notice: nsmain: security info: uid=501, euid=501, gid=20, egid=20

[13/Feb/2013:14:47:35][24260.2093064576][-main-] Notice: nsmain: max files: FD_SETSIZE = 1024, rl_cur = 10240, rl_max = -1

[13/Feb/2013:14:47:35][24260.2093064576][-main-] Warning: nsmain: rl_max > FD_SETSIZE

[13/Feb/2013:14:47:35][24260.2093064576][-main-] Notice: fastpath[server1]: mapped GET /

[13/Feb/2013:14:47:35][24260.2093064576][-main-] Notice: fastpath[server1]: mapped HEAD /

[13/Feb/2013:14:47:35][24260.2093064576][-main-] Notice: fastpath[server1]: mapped POST /

[13/Feb/2013:14:47:35][24260.2093064576][-main-] Notice: adp[server1]: mapped GET /*.adp

[13/Feb/2013:14:47:35][24260.2093064576][-main-] Notice: adp[server1]: mapped HEAD /*.adp

[13/Feb/2013:14:47:35][24260.2093064576][-main-] Notice: adp[server1]: mapped POST /*.adp

[13/Feb/2013:14:47:35][24260.2093064576][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nssock.so'

[13/Feb/2013:14:47:35][24260.2093064576][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nslog.so'

[13/Feb/2013:14:47:35][24260.2093064576][-main-] Notice: nslog: opened '/usr/local/aolserver/servers/server1/modules/nslog/access.log'

[13/Feb/2013:14:47:35][24260.2093064576][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nscgi.so'

[13/Feb/2013:14:47:35][24260.2093064576][-main-] Notice: nscgi: GET /cgi -> /usr/local/aolserver/cgi

[13/Feb/2013:14:47:35][24260.2093064576][-main-] Notice: nscgi: POST /cgi -> /usr/local/aolserver/cgi

[13/Feb/2013:14:47:35][24260.2093064576][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nscp.so'

[13/Feb/2013:14:47:35][24260.2093064576][-main-] Notice: nscp: listening on 127.0.0.1:9999

[13/Feb/2013:14:47:35][24260.2093064576][-main-] Notice: nscp: added user: nsadmin

[13/Feb/2013:14:47:35][24260.2093064576][-main-] Notice: conf: [ns/server/server1]enabletclpages = 1

[13/Feb/2013:14:47:35][24260.2093064576][-main-] Notice: tcl: enabling .tcl pages

[13/Feb/2013:14:47:35][24260.2093064576][-main-] Notice: default thread pool: minthreads 0 maxthreads 10 idle 0 current 0 maxconns 0 queued 0 timeout 30 spread 20

[13/Feb/2013:14:47:35][24260.2093064576][-main-] Notice: nsmain: AOLserver/4.5.2 running

[13/Feb/2013:14:47:35][24260.2093064576][-main-] Notice: nsmain: security info: uid=501, euid=501, gid=20, egid=20

[13/Feb/2013:14:47:35][24260.2093064576][-main-] Notice: driver: starting: nssock

[13/Feb/2013:14:47:35][24260.71671808][-socks-] Notice: socks: starting

[13/Feb/2013:14:47:35][24260.71454720][-sched-] Notice: sched: starting

[13/Feb/2013:14:47:35][24260.72175616][-nssock:driver-] Notice: starting

[13/Feb/2013:14:47:35][24260.72175616][-nssock:driver-] Notice: nssock: listening on 192.168.2.25:15000

[13/Feb/2013:14:47:43][24260.69791744][-default:0-] Notice: random: generating 1 seed

[13/Feb/2013:14:47:44][24260.69791744][-default:0-] Notice: encoding: loaded: iso8859-1

[13/Feb/2013:14:47:44][24260.69791744][-default:0-] Error: Tcl exception:

invalid command name "ns_db"

    while executing

"ns_db gethandle  $pool"

    at line 12 of adp file "/usr/local/aolserver/servers/server1/pages/databasetest.adp"

    while processing connection #0:

[Jamie Ross]

Hey, thank you for the quick responses.  The problem *was* in the config file (I did get nspostgres to compile and install ok).  Unfortunately I didn't have any of my previous code so I forgot that you needed to put nsdb in the modules

ns_param   nsdb            nsdb.so

This isn't actually in annotated config file or any of the files on aolserver.com so I didn't see it missing.  Once I added that, the postgres driver fired up and all was good!

thanks again

Jamie

[Cesáreo García Rodicio]

Hi!

Are your sure that nspostgres.so has been built? Check at
/usr/local/aolserver/bin/

I did my last build using postgres 8.3 (not pg 9.2) and I had to use
this shortcut:

http://openacs.org/forums/message-view?message_id=1539251

Best
Cesáreo


El 13/febrero/13 16:49, Jamie Ross escribió:

> ------------------------------------------------------------------------------
> Free Next-Gen Firewall Hardware Offer
> Buy your Sophos next-gen firewall before the end March 2013
> and get the hardware for free! Learn more.
> http://p.sf.net/sfu/sophos-d2d-feb
>
>
>
> _______________________________________________
> aolserver-talk mailing list
> aolserv...@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/aolserver-talk
>