Forum OpenACS Development: Bind Variables in Log

Posted by Raul Rodriguez on

Where can I find the value of the bind variables used in the queries from the error.log? In my /usr/local/ns/config-myserver.tcl file I have:

set debug true
set dev   true
set verboseSQL true

Thank you

2: Re: Bind Variables in Log (response to 1)
Posted by Gustaf Neumann on
Setting Tcl variables in the server's config file does not affect the configuration, only when these variables are used in configuration settings (e.g. ns_param).

furthermore, the config file of NaviServer is different from AOLserver, so when when you take an only config file, don't expect it to work (rather look at the openacs-config.tcl in the naviserver repository for a sample config file).

have you seen [1]?
all the best.


3: Re: Bind Variables in Log (response to 2)
Posted by Raul Rodriguez on
When I installed naviserver and openacs I used the installation scripts ( On Debian 9 I followed these instructions:
cd /usr/local/src
git clone
cd install-ns

sudo bash

bash build

bash build

After this, openacs started with the config.tcl file from the naviserver directory and /lib/systemd/system/example.service also used it:


On openacs I ran letsencrypt (/var/www/example/packages/acs-subsite/www/admin/letsencrypt.tcl) from On successful completion, /usr/local/ns/config-example.tcl was automatically updated to point to the new certificate.

Since then, I have been using /user/local/ns/config-example.tcl. Based on your reply I updated this file and am now able to see the values of the bind variables. Next I will move everything over to use /var/www/example/etc/config.tcl.

Thank you for your help