Support Requests item #436923, was opened at 2001-06-27 18:40
You can respond by visiting:
http://sourceforge.net/tracker/?func=detail&atid=203152&aid=436923&group_id=3152
Category: Scripting: Tcl/ADP
Group: aolserver3_4
Status: Open
Priority: 3
Submitted By: Tyge Cawthon (tyge)
Assigned to: Dossy Shiobara (dossy)
Summary: Segmentation fault when read db with tcl
Initial Comment:
I am able to put data into the database. When I try to
access the using TCL a get a Segmentation fault.
Attached are three files:
1. startup of AOL
2. db.adp - very similar to the examples
3. db2.adp - very similar to the examples
any help would be very much appreicated.
----------------------------------------------------------------------
>Comment By: Tyge Cawthon (tyge)
Date: 2001-07-10 19:05
Message:
Logged In: YES
user_id=217624
Dossy,
I suggest that we close this ticket since the original
problem has been solved. Thanks again for all the support.
I will be opening another ticket about tcl commands.
----------------------------------------------------------------------
Comment By: Tyge Cawthon (tyge)
Date: 2001-07-04 08:44
Message:
Logged In: YES
user_id=217624
Dossy, I just "hard coded" the name of the database table in
the two .adp files. I get the correct results. The problem
is in the .adp files, not aol or postgreSQL. I would
appreicate any help. Thanks
----------------------------------------------------------------------
Comment By: Tyge Cawthon (tyge)
Date: 2001-07-04 08:27
Message:
Logged In: YES
user_id=217624
Dossy, I download the new drivers and changed the path as
you had suggested. The segmentation fault is gone. Thanks.
[04/Jul/2001:10:13:32][27733.135540736][-main-] Notice:
modload: loading '/usr/local/aolserver/bin/postgres.so'
[04/Jul/2001:10:13:32][27733.135540736][-main-] Notice:
PostgreSQL loaded.
I have a new problem. It's got to be a simple solution. This
is the error message in the server/log file.
[04/Jul/2001:10:17:35][27733.135913472][-conn0-] Notice:
dbdrv: opening database 'postgres:localhost:5432:tyge'
[04/Jul/2001:10:17:35][27733.135913472][-conn0-] Notice:
Opening tyge on localhost
[04/Jul/2001:10:17:35][27733.135913472][-conn0-] Notice:
Ns_PgOpenDb(postgres): Openned connection to
localhost:5432:tyge.
[04/Jul/2001:10:17:35][27733.135913472][-conn0-] Error:
can't read "table": no such variable
can't read "table": no such variable
while executing
"set sql "select * from $table""
invoked from within chunk: 0 of adp:
/usr/local/aolserver/servers/server1/pages/db.adp
[04/Jul/2001:10:17:35][27733.136038400][-keepalive-] Notice:
keepalive: keepalive thread starting
Any suggestion? I am using the attached db.adp amd db2.adp
for my testing.
----------------------------------------------------------------------
Comment By: Dossy Shiobara (dossy)
Date: 2001-06-30 19:54
Message:
Logged In: YES
user_id=21885
What version of the AOLserver PostgreSQL driver are you
using? It appears as though you're using the older,
unsupported (known defective) PostgreSQL driver. I say
this, because this is what the newer driver outputs in the
server.log:
[29/Jun/2001:15:10:05][25900.1024][-main-] Notice:
modload: loading '/home/aolserver/bin/postgres.so'
[29/Jun/2001:15:10:05][25900.1024][-main-] Notice:
PostgreSQL loaded.
Yours shows:
[27/Jun/2001:20:32:52][14529.135540736][-main-] Notice:
modload: loading '/usr/local/aolserver/bin/nspostgres.so'
[27/Jun/2001:20:32:52][14529.135540736][-main-] Notice:
nspostgres: loaded 'PostgreSQL'
Try building the new PostgreSQL driver, available at the
OpenACS site at http://openacs.org/software.adp
labeled "AOLserver Postgres Driver (2.0.0)" or specifically
at:
http://openacs.org/sdm/download-package-release.tcl?
package_id=2&release_id=38
Once you switch to this driver, let me know if you are
still having problems. -- Dossy
----------------------------------------------------------------------
Comment By: Tyge Cawthon (tyge)
Date: 2001-06-28 17:27
Message:
Logged In: YES
user_id=217624
the attached log file is the log/server.log
O/S FreeBSD 4.3-stable
DataBase postgreSQL 7.0.2
AOLServer 3.4
I have also attached the startup config file
I am able to get data into the database.
----------------------------------------------------------------------
Comment By: Dossy Shiobara (dossy)
Date: 2001-06-27 19:21
Message:
Logged In: YES
user_id=21885
What database are you connecting to? What are the last 50
lines in your log/server.log before the segfault? What
OS/platform and AOLserver version are you using? -- Dossy
----------------------------------------------------------------------
You can respond by visiting:
http://sourceforge.net/tracker/?func=detail&atid=203152&aid=436923&group_id=3152
