Branimir's Blog Archive

Installed OpenACS for branimir.com

Branimir.com now runs OpenACS! I've installed version 4.6.3. It wasn't as smooth as I hoped but hey - it's working. It uses Apache as reverse proxy for virtual hosting and SSL and Postgres.

BTW, I'm really impressed how db_source_sql_file works only thanks to the fact that db_get_pgbin is broken :-)

Here's what db_source_sql_file tries to do:

set fp [open "|[file join [db_get_pgbin] psql] $pghost $pgport $pguser -f $file_name [db_get_database] $pgpass" "r"]

Now, this works correctly only because db_get_pgbin always returns empty string so that psql from the PATH gets executed. Here's what db_get_pgbin does:

    set pool [lindex [nsv_get db_available_pools .] 0]
    set driver [ns_config ns/db/pool/$pool Driver]    
    return [ns_config ns/db/driver/$driver pgbin]

What this seems to be trying to do is find psql binary in a place like /usr/local/aolserver/bin. Fortunately the section name is misspelled in the last line (driver instead of drivers) so the proc returns empty string.

Posted by Branimir Dolicki at 04:51

# - G - Add comment