Re: [AOLSERVER] compilation of nspostgres4.1 fails (Solved)
All, This was solved in the meantime. The README file in the nspostgres driver tarball, which I downloaded from sourceforge didn't have the information that INST changed its meaning in 4.5. After I fixed that, everything went smooth and I have my server up and running the way I like it. Wll document this for myself plus the extra steps I had to do in OpenBSD to get it to start at boot. Thanks. --- On Thu, 5/7/09, Dino Vliet dino_vl...@yahoo.com wrote: From: Dino Vliet dino_vl...@yahoo.com Subject: [AOLSERVER] compilation of nspostgres4.1 fails To: AOLSERVER@LISTSERV.AOL.COM Date: Thursday, May 7, 2009, 10:02 PM Good evening, I'm experiencing problems compiling nspostgres4.1 on openbsd 4.5 My command sequence is: gmake POSTGRES=/var/postgresql PGLIB=/usr/local/lib/postgresql/ PGINC=/usr/local/include/postgresql/ INST=/usr/local/aolserver/bin/nsd NSHOME=/usr/local/aolserver AOLSERVER=/usr/local/aolserver And then gmake POSTGRES=/var/postgresql PGLIB=/usr/local/lib/postgresql/ PGINC=/usr/local/include/postgresql/ INST=/usr/local/aolserver/bin/nsd NSHOME=/usr/local/aolserver AOLSERVER=/usr/local/aolserver install And the result of the last command is: /usr/local/aolserver/bin/nsd -d /usr/local/aolserver/bin -e nspostgres.so /usr/local/aolserver/bin/nsd: can't load library 'libnsd.so' gmake: *** [install-mod] Error 4 If I look in my /usr/local/aolserver/bin directory, I see, ini2tcl.tcl install-sh nscgi.so nsd nsinstall-man.sh nslog.so nsopenssl.so nsremove.tcl nssock.so nsthreadtest init.tcl nscache.so nscp.so nsdb.so nsinstall.tcl nsmakeall.tcl nsperm.so nssha1.so nstclsh tcl2ini.tcl What do I have wrong? -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to lists...@listserv.aol.com 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 lists...@listserv.aol.com 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 lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
[AOLSERVER] compilation of nspostgres4.1 fails
Good evening, I'm experiencing problems compiling nspostgres4.1 on openbsd 4.5 My command sequence is: gmake POSTGRES=/var/postgresql PGLIB=/usr/local/lib/postgresql/ PGINC=/usr/local/include/postgresql/ INST=/usr/local/aolserver/bin/nsd NSHOME=/usr/local/aolserver AOLSERVER=/usr/local/aolserver And then gmake POSTGRES=/var/postgresql PGLIB=/usr/local/lib/postgresql/ PGINC=/usr/local/include/postgresql/ INST=/usr/local/aolserver/bin/nsd NSHOME=/usr/local/aolserver AOLSERVER=/usr/local/aolserver install And the result of the last command is: /usr/local/aolserver/bin/nsd -d /usr/local/aolserver/bin -e nspostgres.so /usr/local/aolserver/bin/nsd: can't load library 'libnsd.so' gmake: *** [install-mod] Error 4 If I look in my /usr/local/aolserver/bin directory, I see, ini2tcl.tcl install-sh nscgi.so nsd nsinstall-man.sh nslog.so nsopenssl.so nsremove.tcl nssock.so nsthreadtest init.tcl nscache.so nscp.so nsdb.so nsinstall.tcl nsmakeall.tcl nsperm.so nssha1.so nstclsh tcl2ini.tcl What do I have wrong? -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
[AOLSERVER] example database configuration wit nspostgres on aolserver 4.5
Hi peeps, can someone provide me an example of a configuration from aolserver 4.5? I'm especially interested in the database parts so what has to go exactly into the ns/db parts and what modules to use. I'm particular confused if the nsdbo.so has to be loaded or not in the modules section. According to this link, http://panoptic.com/wiki/aolserver/Annotated_AOLserver_Configuration_Reference, it doesn't have to load but I don't get any response from my efforts. The server loads without database driver and thats frustating. Hope you can help me out __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- 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] example database configuration wit nspostgres on aolserver 4.5
So why is this happening to me:-(
Hi folks,
my sample-config looks like:
# Database drivers
ns_section ns/db/drivers
ns_param postgres_drivernspostgres.so;
ns_section ns/db/pools
ns_param postgres_pool Postgres_pool
ns_section ns/db/pool/postgres_pool
ns_param driver postgres_driver
ns_param datasource 192.168.1.102:5432:foodmartdb
ns_param user foodmart
ns_param password foodmart
ns_param connections1
ns_param logsqlerrors true;
ns_param verbosefalse;
ns_param maxidle600;
ns_param maxopen3600;
ns_section ns/server/${servername}/db
ns_param pools * ;
ns_param defaultpoolpostgres_pool;
ns_section ns/server/${servername}/modules
ns_param nssock ${bindir}/nssock.so
ns_param nslog ${bindir}/nslog.so
ns_param nsopenssl ${bindir}/nsopenssl.so
# ns_param nsexample ${bindir}/nsexample.so
# ns_param nssha1 ${bindir}/nssha1.so
ns_param nsdb${bindir}/nsdb.so
#ns_param nscgi ${bindir}/nscgi.so
# ns_param nsperm ${bindir}/nsperm.so
And when I do:
bash-3.00$ bin/nsd -ft sample-config.tcl
I get:
[25/Oct/2006:19:35:00][26219.2272153600][-main-]
Notice: nsopenssl (server1): default SSL context for
server is users
[25/Oct/2006:19:35:00][26219.2272153600][-main-]
Notice: default server SSL context: users
[25/Oct/2006:19:35:00][26219.2272153600][-main-]
Notice: nsopenssl (server1): loading 'users_drv' SSL
driver
[25/Oct/2006:19:35:00][26219.2272153600][-main-]
Notice: nsopenssl (server1): loading 'admins_drv' SSL
driver
[25/Oct/2006:19:35:00][26219.2272153600][-main-]
Notice: modload: loading
'/usr/local/aolserver4/bin/nsdb.so'
[25/Oct/2006:19:35:00][26219.2272153600][-main-]
Notice: modload: loading
'/usr/local/aolserver4/bin/nspostgres.so'
bash-3.00$
bash-3.00$
The server quits and when I use gdb bin/nsd and run
-fdt sample-config.tcl I get:
[25/Oct/2006:19:36:54][26506.2196135936][-main-]
Notice: nsopenssl (server1): loading 'users_drv' SSL
driver
[25/Oct/2006:19:36:54][26506.2196135936][-main-]
Notice: nsopenssl (server1): loading 'admins_drv' SSL
driver
[25/Oct/2006:19:36:54][26506.2196135936][-main-]
Notice: modload: loading
'/usr/local/aolserver4/bin/nsdb.so'
[25/Oct/2006:19:36:54][26506.2196135936][-main-]
Notice: modload: loading
'/usr/local/aolserver4/bin/nspostgres.so'
Program exited with code 04.
(gdb)
What could be wrong?
--- Bas Scheffers [EMAIL PROTECTED] wrote:
You load nsdb in the server's modules section:
ns_section ns/server/${servername}/modules
ns_param nssock ${bindir}/nssock.so
ns_param nslog ${bindir}/nslog.so
ns_param nsperm ${bindir}/nsperm.so
ns_param nsdb ${bindir}/nsdb.so
ns_param nssession ${bindir}/nssession.so
ns_param nscp ${bindir}/nscp.so
# Then load the postgres driver:
ns_section ns/db/drivers
ns_param postgres_driver nspostgres.so
# Create a pool:
ns_section ns/db/pools
ns_param sativoSativo Pool
# define the pool:
ns_section ns/db/pool/sativo
ns_param driver postgres_driver
ns_param datasource
localhost:5432:sativo2
ns_param usernsd
ns_param passwordxx
ns_param connections 20
ns_param logsqlerrorstrue ;# Verbose
SQL query error logging
ns_param verbose false ;# Verbose
error logging
ns_param maxidle 600 ;# Max time
to keep idle db conn
open
ns_param maxopen 3600
# Give the server access to pools:
ns_section ns/server/${servername}/db
ns_param pools *;# Wildcard
gives access to all
ns_param defaultpoolsativo
And that should do the trick!
Bas.
On Thursday, October 26, 2006 8:50, Dino Vliet said:
Hi peeps,
can someone provide me an example of a
configuration
from aolserver 4.5? I'm especially interested in
the
database parts so what has to go exactly into the
ns/db parts and what modules to use.
I'm particular confused if the nsdbo.so has to be
loaded or not in the modules section. According to
this link,
http://panoptic.com/wiki/aolserver/Annotated_AOLserver_Configuration_Reference,
it doesn't have to load but I don't get any
response
from my efforts. The server loads without database
driver and thats frustating.
Hope you can help me out
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam
protection around
http://mail.yahoo.com
--
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
[AOLSERVER] problems loading nspostgres
Hi folks,
my sample-config looks like:
# Database drivers
ns_section ns/db/drivers
ns_param postgres_drivernspostgres.so;
ns_section ns/db/pools
ns_param postgres_pool Postgres_pool
ns_section ns/db/pool/postgres_pool
ns_param driver postgres_driver
ns_param datasource 192.168.1.102:5432:foodmartdb
ns_param user foodmart
ns_param password foodmart
ns_param connections1
ns_param logsqlerrors true;
ns_param verbosefalse;
ns_param maxidle600;
ns_param maxopen3600;
ns_section ns/server/${servername}/db
ns_param pools * ;
ns_param defaultpoolpostgres_pool;
ns_section ns/server/${servername}/modules
ns_param nssock ${bindir}/nssock.so
ns_param nslog ${bindir}/nslog.so
ns_param nsopenssl ${bindir}/nsopenssl.so
# ns_param nsexample ${bindir}/nsexample.so
# ns_param nssha1 ${bindir}/nssha1.so
ns_param nsdb${bindir}/nsdb.so
#ns_param nscgi ${bindir}/nscgi.so
# ns_param nsperm ${bindir}/nsperm.so
And when I do:
bash-3.00$ bin/nsd -ft sample-config.tcl
I get:
[25/Oct/2006:19:35:00][26219.2272153600][-main-]
Notice: nsopenssl (server1): default SSL context for
server is users
[25/Oct/2006:19:35:00][26219.2272153600][-main-]
Notice: default server SSL context: users
[25/Oct/2006:19:35:00][26219.2272153600][-main-]
Notice: nsopenssl (server1): loading 'users_drv' SSL
driver
[25/Oct/2006:19:35:00][26219.2272153600][-main-]
Notice: nsopenssl (server1): loading 'admins_drv' SSL
driver
[25/Oct/2006:19:35:00][26219.2272153600][-main-]
Notice: modload: loading
'/usr/local/aolserver4/bin/nsdb.so'
[25/Oct/2006:19:35:00][26219.2272153600][-main-]
Notice: modload: loading
'/usr/local/aolserver4/bin/nspostgres.so'
bash-3.00$
bash-3.00$
The server quits and when I use gdb bin/nsd and run
-fdt sample-config.tcl I get:
[25/Oct/2006:19:36:54][26506.2196135936][-main-]
Notice: nsopenssl (server1): loading 'users_drv' SSL
driver
[25/Oct/2006:19:36:54][26506.2196135936][-main-]
Notice: nsopenssl (server1): loading 'admins_drv' SSL
driver
[25/Oct/2006:19:36:54][26506.2196135936][-main-]
Notice: modload: loading
'/usr/local/aolserver4/bin/nsdb.so'
[25/Oct/2006:19:36:54][26506.2196135936][-main-]
Notice: modload: loading
'/usr/local/aolserver4/bin/nspostgres.so'
Program exited with code 04.
(gdb)
What could be wrong?
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
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] nsopensslv3 is loaded but I can't access no page
THAT simple:-) Thanks, it works.phew, I thought I was going crazy. Cheers --- Dossy Shiobara [EMAIL PROTECTED] wrote: On 2006.03.22, Dino Vliet [EMAIL PROTECTED] wrote: I can connect on port 8000, my normal http port, but not on my https port 8443. [...] [23/Mar/2006:01:31:35][26734.2097325056][-conn:server1::0] Error: nsopenssl (server1): SSL read error: http request How are you trying to access the site using SSL? Based on this error message, it sounds like you're doing: http://hostname:8443/ That won't work; you're telling it to do HTTP to your SSL port. You need to use the https scheme: https://hostname:8443/ ^^^ -- Dossy -- Dossy Shiobara | [EMAIL PROTECTED] | http://dossy.org/ Panoptic Computer Network | http://panoptic.com/ He realized the fastest way to change is to laugh at your own folly -- then you can let go and quickly move on. (p. 70) -- 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. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- 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] nsopensslv3 is loaded but I can't access no page
Hi people,
I've configured aolserver 4 on openbsd 3.8 and have
compiled nsopensslv3 with the server.
I used GOOGLE to set up my nsd.tcl config file and
everything looks fine according to my serverlog.
I can connect on port 8000, my normal http port, but
not on my https port 8443.
Look at the last part of my server.log file:
[23/Mar/2006:01:31:35][26734.2097325056][-conn:server1::0]
Notice: nsopenssl (server1): trace (0x7fa67a08):
1211 secs: before/accept initialization
[23/Mar/2006:01:31:35][26734.2097325056][-conn:server1::0]
Notice: nsopenssl (server1): trace (0x7fa67a08):
692 secs: before/accept initialization
[23/Mar/2006:01:31:35][26734.2097325056][-conn:server1::0]
Notice: nsopenssl (server1): trace (0x7fa67a08):
571 secs: SSLv2/v3 read client hello A
[23/Mar/2006:01:31:35][26734.2097325056][-conn:server1::0]
Error: nsopenssl (server1): SSL read error: http
request
I have included my server.log file and my nsd.tcl
file.
Hope somebody can help me with this.
Brgds
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
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.#
# The contents of this file are subject to the AOLserver Public License
# Version 1.1 (the License); you may not use this file except in
# compliance with the License. You may obtain a copy of the License at
# http://aolserver.com/.
#
# Software distributed under the License is distributed on an AS IS
# basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See
# the License for the specific language governing rights and limitations
# under the License.
#
# The Original Code is AOLserver Code and related documentation
# distributed by AOL.
#
# The Initial Developer of the Original Code is America Online,
# Inc. Portions created by AOL are Copyright (C) 1999 America Online,
# Inc. All Rights Reserved.
#
# Alternatively, the contents of this file may be used under the terms
# of the GNU General Public License (the GPL), in which case the
# provisions of GPL are applicable instead of those above. If you wish
# to allow use of your version of this file only under the terms of the
# GPL and not to allow others to use your version of this file under the
# License, indicate your decision by deleting the provisions above and
# replace them with the notice and other provisions required by the GPL.
# If you do not delete the provisions above, a recipient may use your
# version of this file under either the License or the GPL.
#
#
# $Header: /cvsroot/aolserver/aolserver/sample-config.tcl,v 1.11.2.2 2004/08/11 19:40:59 dossy Exp $
#
#
# sample-config.tcl -- Example config script.
#
# This script is an AOLserver configuration script with
# several example sections. To use:
#
# % cp sample-config.tcl myconfig.tcl
# % vi myconfig.tcl (edit as needed)
# % bin/nsd -ft myconfig.tcl (test in foreground)
# % bin/nsd -t myconfig.tcl (run in background)
# % gdb bin/nsd
# (gdb) run -fdt myconfig.tcl (run in debugger)
#
#
# Set some Tcl variables that are commonly used throughout this file.
#
set httpport 8000
set httpsport 8443
# The hostname and address should be set to actual values.
#set hostname [ns_info hostname]
#set address[ns_info address]
set hostname 192.168.1.102
set address 192.168.1.102
set servername server1
set serverdesc Server Name
set homedir[file dirname [ns_info config]]
set bindir [file dirname [ns_info nsd]]
set pageroot ${homedir}/servers/${servername}/pages
set directoryfile index.adp,index.html,index.htm,index.xhtml,index.xht
# nsssl: Only loads if keyfile.pem and certfile.pem exist.
#set sslmodule nsssl.so ;# Domestic 128-bit/1024-bit SSL.
set sslmodule nsssle.so ;# Exportable 40-bit/512-bit SSL.
set sslkeyfile ${homedir}/servers/${servername}/modules/nsssl/keyfile.pem
set sslcertfile ${homedir}/servers/${servername}/modules/nsssl/certfile.pem
#
# Global server parameters
#
ns_section ns/parameters
ns_param home$homedir
ns_param debug false
#
# I18N Parameters
#
#ns_param HackContentType false ;# automatic adjustment of response
# content-type header to include charset
# This defaults to True.
ns_param OutputCharset iso8859-1;# Default output charset. When none specified,
# no character encoding of output is performed.
ns_param URLCharset iso8859-1;# Default Charset for Url Encode/Decode.
# When none specified, no character set
[AOLSERVER] tcl or adp style database driven web apps
Hi there folks, first of all, thanks for your nice product...it's being appreciated!! I want to know what the preferred method is for developing database driven web apps with aolserver. Is it through TCL (files ending with .tcl and with the enabletclpages=1) or is it through adp's? I'm asking this because I stumbled accross a site where somebody said that working with .tcl files was falling out of favor in the community (I think due to security reasons). What can you tell me about this? My database model is designed and so I'm ready to start coding. However, I am also thinking of the security implications. I'm visioning using openBSD as a webserver and a FreeBSD database backend. I will prepare some load balancing with pf so I can add more webservers if needed. Also I will make use of openssl if I need to secure form logins. Can someone react on this planned implementation? Especially security wise. (or is the information given too brief? This bings me to another question I have with regard to the database. I'm using the database to store userid's and passwords. That's ok right? For the curious between you:-) This application will support some local users in my country who want to book a festival we are organizing in another country. On the site, we will also give these clients the ability to see the status of their reservations. We need this because we have to have reliable data about who is booking our festival and how to handle things when the festival starts. I hope some of you can respond to my questions. Thanks again for this product. Brgds Dino Vliet __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- 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] when starting nsd nspostgres doesn't load libpq.so.4 error
But still as root, I'm getting another error when
executing the following command:
./bin/nsd -fzt ./nsd.tcl -u nsadmin
[15/Oct/2005:14:08:16][14927.18446744072291651328][-main-]
Notice: modload: loading
'/usr/local/aolserver/bin/nspostgres.so'
[15/Oct/2005:14:08:16][14927.18446744072291651328][-main-]
Warning: modload: could not load
/usr/local/aolserver/bin/nspostgres.so:
/usr/local/aolserver/bin/nspostgres.so: undefined
symbol: Ns_DbGetRow
[15/Oct/2005:14:08:16][14927.18446744072291651328][-main-]
Fatal: modload: failed to load module
'/usr/local/aolserver/bin/nspostgres.so'
Some Ns_DbGetRow error.
cat nsd.tcl | grep postgres gives:
ns_param postgres_driver nspostgres.so ;
ns_param postgres_pool Postgres Pool
ns_section ns/db/pool/postgres_pool
ns_param driver postgres_driver
ns_param user postgres
ns_param nsdb ${bindir}/nspostgres.so
What is wrong?
--- C. R. Oldham [EMAIL PROTECTED] wrote:
Dino,
Warning: modload: could not load
/usr/local/aolserver/bin/nspostgres.so:
libpq.so.4:
cannot open shared object file: No such file or
directory
You are missing the postgres client libraries on
your machine, or
AOLserver can't find them.
On my Debian 3.1 box these files are in the
postgresql-dev package.
--cro
--
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.
__
Start your day with Yahoo! - Make it your home page!
http://www.yahoo.com/r/hs
--
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] when starting nsd nspostgres doesn't load libpq.so.4 error
Works as a charm!!
Thanks.
What I did wrong was that I loaded the nspostgres in
the modules part of the nsd.tcl file and I should have
done that only in the database section as described
below:
Keep in mind nspostgres is a database driver and not
a typical AOLserver module. It should load in the
database driver section of nsd.tcl (aolserver config
file) and not the modules section.
--- Jean-Fabrice RABAUTE [EMAIL PROTECTED] wrote:
Hi,
Be sure to add nsdb.so in the
ns/server/your_server/modules section of
the tcl config file.
Regards / Cordialement
Jean-Fabrice Rabaute
CORE SERVICES :: Software/Web development
Consulting services
http://www.core-services.fr - {Enjoy the future
today}
http://www.debugbar.com : The most advanced WEB
development tool for
Internet Explorer
-Message d'origine-
De : AOLserver Discussion
[mailto:[EMAIL PROTECTED] la part
de Dino Vliet
Envoyé : samedi 15 octobre 2005 14:19
À : AOLSERVER@LISTSERV.AOL.COM
Objet : Re: [AOLSERVER] when starting nsd
nspostgres doesn't load
libpq.so.4 error
But still as root, I'm getting another error when
executing the following command:
./bin/nsd -fzt ./nsd.tcl -u nsadmin
[15/Oct/2005:14:08:16][14927.18446744072291651328][-main-]
Notice: modload: loading
'/usr/local/aolserver/bin/nspostgres.so'
[15/Oct/2005:14:08:16][14927.18446744072291651328][-main-]
Warning: modload: could not load
/usr/local/aolserver/bin/nspostgres.so:
/usr/local/aolserver/bin/nspostgres.so: undefined
symbol: Ns_DbGetRow
[15/Oct/2005:14:08:16][14927.18446744072291651328][-main-]
Fatal: modload: failed to load module
'/usr/local/aolserver/bin/nspostgres.so'
Some Ns_DbGetRow error.
cat nsd.tcl | grep postgres gives:
ns_param postgres_driver nspostgres.so ;
ns_param postgres_pool Postgres Pool
ns_section ns/db/pool/postgres_pool
ns_param driver postgres_driver
ns_param user postgres
ns_param nsdb ${bindir}/nspostgres.so
What is wrong?
--- C. R. Oldham [EMAIL PROTECTED] wrote:
Dino,
Warning: modload: could not load
/usr/local/aolserver/bin/nspostgres.so:
libpq.so.4:
cannot open shared object file: No such file
or
directory
You are missing the postgres client libraries on
your machine, or
AOLserver can't find them.
On my Debian 3.1 box these files are in the
postgresql-dev package.
--cro
--
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.
__
Start your day with Yahoo! - Make it your home
page!
http://www.yahoo.com/r/hs
--
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.
--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.14/130 -
Release Date:
12/10/2005
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.14/130 -
Release Date: 12/10/2005
--
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.
__
Yahoo! Music Unlimited
Access over 1 million songs. Try it free.
http://music.yahoo.com/unlimited/
--
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] when starting nsd nspostgres doesn't load libpq.so.4 error
Dear users, can somebody help me with starting aolserver with nspostgres? When I issue the following command: ./bin/nsd -fzt ./nsd.tcl -u nsadmin I get this error: [14/Oct/2005:23:54:46][9395.18446744072291651328][-main-] Warning: modload: could not load /usr/local/aolserver/bin/nspostgres.so: libpq.so.4: cannot open shared object file: No such file or directory [14/Oct/2005:23:54:46][9395.18446744072291651328][-main-] Fatal: modload: failed to load module '/usr/local/aolserver/bin/nspostgres.so' When I did a ldd I saw: ldd bin/nspostgres.so libpq.so.4 = not found libnsthread.so = /usr/local/aolserver//lib/libnsthread.so (0x2abdc000) libnsd.so = /usr/local/aolserver//lib/libnsd.so (0x2ace4000) libtcl8.4.so = /usr/local/lib/libtcl8.4.so (0x2ae43000) libdl.so.2 = /lib64/libdl.so.2 (0x2b005000) libpthread.so.0 = /lib64/tls/libpthread.so.0 (0x2b108000) libm.so.6 = /lib64/tls/libm.so.6 (0x2b21e000) libz.so.1 = /lib64/libz.so.1 (0x2b375000) libgcc_s.so.1 = /lib64/libgcc_s.so.1 (0x2b488000) libc.so.6 = /lib64/tls/libc.so.6 (0x2b594000) /lib64/ld-linux-x86-64.so.2 (0x4000) I'm using aolserver 4.0.10 together with nspostgres4 and postgresql8 on suse 9.3 amd64. What could be wrong here? When I issue the same command when logged in directly as root (so NOT a SU as was the case above), I get the following result: Warning: modload: could not load /usr/local/aolserver/bin/nspostgres.so: /usr/loical/aolserver/bin/nspostgres.so: undefined symbol: Ns_DbGetRow Fatal: modload: failed to load module /usr/local/aolserver/bin/nspostgres.so The ldd command shows nothing strange and even libpq.so.4 can be linked. What is the case here? __ Yahoo! Music Unlimited Access over 1 million songs. Try it free. http://music.yahoo.com/unlimited/ -- 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] aolserver 3.4.2 configuration questions
It is very strange but I don't see no 'Notice: tcl:
enabling .tcl pages'...
And it also seems that my enabbletcl true statement in
my config file has no influence!!
I can change that string to everything I want..the
server just starts and doesn't complain about even
wrong things I enter there...
Still not a clue as to what is happening. My log file
contains nothing about it.
--- Mark Page [EMAIL PROTECTED] wrote:
On the running .tcl pages part (there are others who
can comment better
on your postgres questions);
Try looking at what shows up in the server log file.
This file will
either be flowing to standard-out, or to the
configured 'serverlog' path
(defaults to $homedir/log/server.log; you've
specified homedir ==
/home/rgilaard/).
You should see a 'Notice: tcl: enabling .tcl pages'
message near the
start confirming that .tcl pages have been correctly
enabled.
Also, there may be something else going awry, which
could be identified
by entries in this log, perhaps associated with
trying to service the
.tcl page request.
Dino Vliet wrote on 1/20/2004, 11:00 AM:
Dear all,
I've installed aoserver 3.4.2 on my freebsd 4.9
laptop
for developing and testing some web applications
I'm
planning to create. The installation went ok and
I can
serve static pages. However, when I try to feed
my
system some .tcl pages under pageroot I get the
whole
page as text and not the results of the tcl
statements
I wrote.
For instance, this little hello world tcl program
doesn't appear as expected in the browser.
hello.tcl
ns_return 200 text/html html
head
titleTesting/title
/head
body
pHello, world/p
/body
/html
The output of this when I put the commands in a
.tcl
file under pageroot is:
ns_return 200 text/html html
head
titleTesting/title
/head
body
pHello, world/p
/body
/html
I then tried something similar but the results
were
the same:
ns_write HTTP/1.0 200 OK
MIME-Version: 1.0
Content-Type: text/html
ns_write html
head
titleTesting/title
/head
body
pHello, world/p
/body
/html
I also have a question regarding database access
with
the postgres driver. I have installed postgres
7.3.4
and it works fine. However, I wasn't able to find
no
postgres.so file in any directory on my system. I
thought aolserver would install it somewhere and
I
could use that location to find it. What I did
find
was a /usr/local/lib/postgresql/plpgsql.so file,
and I
added it to db section, but I don't think this
will do
the trick:-)
Here is my nsd configuration file:
# $Header:
/cvsroot/aolserver/aolserver/nsd/sample-config.tcl,v
1.2 2000/12/13 21:50:27 kriston Exp $
ns_log notice config.tcl: starting to read
config
file...
#
# Set some Tcl variables that are commonly used
throughout this file.
#
set httpport 8000
set httpsport 8443
# The hostname and address should be set to
actual
values.
set hostname localhost
set address127.0.0.1
set servername server1
set serverdesc Server Name
set homedir/home/rgilaard/
set bindir
/usr/local/aolserver/bin/
set pageroot
${homedir}/servers/${servername}/pages/
set directoryfile
index.adp,index.html,index.htm
set ext [info sharedlibextension]
# nsssl: Only loads if keyfile.pem and
certfile.pem
exist.
#set sslmodule nsssl${ext} ;#
Domestic
128-bit/1024-bit SSL.
set sslmodule nsssle${ext} ;#
Exportable
40-bit/512-bit SSL.
set sslkeyfile
${homedir}/servers/${servername}/modules/nsssl/keyfile.pem
set sslcertfile
${homedir}/servers/${servername}/modules/nsssl/certfile.pem
# nscp: Uncomment the sample password and log in
with
nsadmin, password x,
# type ns_crypt newpassword salt and put
the
encrypted string below.
set nscp_port
set nscp_addr 127.0.0.1
set nscp_user
#set nscp_user nsadmin:t2GqvvaiIUbF2: ;# sample
user=nsadmin, pw=x.
#
# Global server parameters
#
ns_section ns/parameters
ns_param home$homedir
ns_param debug false
#
# Thread library (nsthread) parameters
#
ns_section ns/threads
ns_param mutexmeter true ;# measure
lock
contention
#ns_param stacksize [expr 128*1024] ;#
Per-thread
stack size.
#
# MIME types.
#
# Note: AOLserver already has an exhaustive list
of
MIME types, but in
# case something is missing you can add it here.
#
ns_section ns/mimetypes
ns_param default */* ;# MIME type
for
unknown extension.
=== message truncated ===
__
Do you Yahoo!?
Yahoo! Hotjobs
[AOLSERVER] aolserver 3.4.2 configuration questions
an ADP or a Tcl proc to
generate them.
#ns_param directoryadp$pageroot/dirlist.adp ;#
Choose one or the other.
#ns_param directoryproc _ns_dirlist ;#
...but not both!
#ns_param directorylisting simple ;#
Can be simple or fancy.
#
# ADP (AOLserver Dynamic Page) configuration
#
ns_section ns/server/${servername}/adp
ns_param map /*.adp ;# Extensions to
parse as ADP's.
#ns_param map /*.html ;# Any extension
can be mapped.
ns_param enableexpirefalse ;# Set Expires:
now on all ADP's.
ns_param enabledebug false ;# Allow Tclpro
debugging with ?debug.
# ADP special pages
#ns_param errorpage ${pageroot}/errorpage.adp
;# ADP error page.
#
# ADP custom parsers -- see adp.c
#
ns_section ns/server/${servername}/adp/parsers
ns_param adp .adp;# adp is the
default parser.
#
# Socket driver module (HTTP) -- nssock
#
ns_section ns/server/${servername}/module/nssock
ns_param port$httpport
ns_param hostname$hostname
ns_param address $address
#
# Socket driver module (HTTPS) -- nsssl
#
# nsssl does not load unless sslkeyfile/sslcertfile
exist (above).
#
ns_section ns/server/${servername}/module/nsssl
ns_param port$httpsport
ns_param hostname$hostname
ns_param address $address
ns_param keyfile $sslkeyfile
ns_param certfile$sslcertfile
#
# Control port -- nscp
#
# nscp does not load unless nscp_user is a valid
user.
#
ns_section ns/server/${servername}/module/nscp
ns_param port$nscp_port
ns_param address $nscp_addr
ns_section ns/server/${servername}/module/nscp/users
ns_param user$nscp_user
#
# Access log -- nslog
#
ns_section ns/server/${servername}/module/nslog
ns_param rolllog true ;# Should we roll
log?
ns_param rollonsignaltrue ;# Roll log on
SIGHUP.
ns_param rollhour0 ;# Time to roll
log.
ns_param maxbackup 5 ;# Max number to
keep around when rolling.
#
# CGI interface -- nscgi
#
# WARNING: These directories must not live under
pageroot.
#
ns_section ns/server/${servername}/module/nscgi
#ns_param map GET /cgi /usr/local/cgi ;# CGI
script file dir (GET).
#ns_param map POST /cgi /usr/local/cgi ;# CGI
script file dir (POST).
ns_section ns/db/drivers
ns_param postgres
/usr/local/lib/postgresql/plpgsql.so ;#Volgens doc
niet de juiste
ns_section ns/db/pools
ns_param main Intranet Pool
ns_section ns/db/pool/main
ns_param Driver postgres
ns_param Connections 20
ns_param DataSource localhost:5432:vogels
ns_param User rgilaard
ns_param Verbose Off
ns_param LogSQLErrors On
ns_param ExtendedTableInfo On
ns_param MaxOpen 10
ns_param MaxIdle 10
ns_section ns/server/${servername}/db
ns_param Pools *
ns_param DefaultPool main
#
# Modules to load
#
ns_section ns/server/${servername}/modules
ns_param nssock ${bindir}/nssock${ext}
ns_param nslog ${bindir}/nslog${ext}
#ns_param nscgi ${bindir}/nscgi${ext} ;#
Map the paths before using.
#ns_param nsperm ${bindir}/nsperm${ext} ;#
Edit passwd before using.
#
# nsssl: Only loads if sslcertfile and sslkeyfile
exist (see above).
#
if { [file exists $sslcertfile] [file exists
$sslkeyfile] } {
ns_param nsssl ${bindir}/${sslmodule}
} else {
ns_log warning config.tcl: nsssl not loaded --
key/cert files do not exist.
}
#
# nscp: Only loads if nscp_user is set (see above).
#
if { $nscp_user != } {
if ![string match 127.0.0.1 $nscp_addr] {
# Anything but 127.0.0.1 is not recommended.
ns_log warning config.tcl: nscp listening on
${nscp_addr}:${nscp_port}
}
ns_param nscp ${bindir}/nscp${ext}
} else {
ns_log warning config.tcl: nscp not loaded --
user/password is not set.
}
ns_log notice config.tcl: finished reading config
file.
Can anyone be of assistence? I'm new to this aolserver
thing but I really want to get going and develop some
applications with it.
Brgds
Dino Vliet
__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
--
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.
