]Project-open[ on Debian ETCH

These are the instructions and the packages for installing ]Project-open[ on a Debian ETCH. You’ll surely find another way, but this works for me, and I hope maybe it will help you too.

Lots of thanks to Martin Van Es for his help on updating to PostgreSQL 8.1 and Aolserver4.
NOTE: As seen in a comment, don’t use PostgreSQL version 8.3 because it’s still not working well with ]PO[. You should use 8.1 for now.

po-mini.jpg

1. Packages

Install system dependencies for ]PO[

apt-get install libreadline5-dev zlib1g-dev tcl8.4 tcl8.4-dev tk8.4-dev bison flex cdbs libpam0g-dev libperl-dev python2.4-dev python-dev x-dev

2. Aolserver

Install Aolserver4, needed modules and tdom

apt-get install aolserver4 aolserver4-dev aolserver4-doc aolserver4-nscache aolserver4-nsopenssl aolserver4-nspostgres aolserver4-nssha1 aolserver4-nsxml tdom

3. PostgreSQL

Install PostgreSQL and the contrib package (contains tsearch2, needed for fulltextsearch feature)

apt-get install postgresql-8.1 postgresql-contrib-8.1

Need to change some behaviour on PostgreSQL config. Edit /etc/postgresql/8.1/main/postgresql.conf. Look for VERSION/PLATFORM COMPATIBILITY section, and enable these variables as follows

add_missing_from = on
regex_flavor = extended
default_with_oids = on

Edit /etc/postgresql/8.1/main/pg_hba.conf. Look for the local IPv4 local connections section, and change md5 auth with ident as follows

# IPv4 local connections:
#host    all         all         127.0.0.1/32          md5
host    all         all         127.0.0.1/32          ident sameuser

Restart postgresql

/etc/init.d/postgresql-8.1 restart

3. ]Project-open[

Download and install ]PO[ package

wget -c http://ivanhq.net/po/deb/project-open_3.2-1_i386.deb
dpkg -i project-open_3.2-1_i386.deb

Create a user and a group for running ]po[

groupadd projop
useradd -g projop -d /web/projop -s /bin/bash projop

Create a log dir and change permissions on the website for the new user

mkdir /web/projop/log
chown -R projop:projop /web/projop

Create a new database for ]PO[ (default postgres charset is latin9, set it to utf8)

su - postgres
createuser -a -d projop
createdb --owner=projop projop -E UTF8
createlang plpgsql projop
exit

Load demo data into the new database

su - projop
cd /web/projop/packages/intranet-core/preconf
gzip -d project-open-3.2.sql.gz
psql projop -f project-open-3.2.sql

Check the data has been correctly imported

psql projop
 
projop=# select count(*) from users;
 count
-------
   196
(1 row)
 
projop=# \\q

Edit config file (/web/projop/etc/config.tcl) and change main path settings

#set homedir                   /usr/local/aolserver
#set bindir                    [file dirname [ns_info nsd]]

set homedir                   /usr/lib/aolserver4
set bindir                    /usr/lib/aolserver4/bin

Launch the server to see if it works okay

/usr/sbin/aolserver4-nsd -f -t /web/projop/etc/config.tcl -u projop -g projop

# Ctrl+C to stop

Exit user projop

exit

4. Init system

Edit default Aolserver4 init script /etc/init.d/aolserver4 and change next parameters

#USER=www-data
#GROUP=www-data
#ADDRESS=127.0.0.1
#CONF=/etc/aolserver4/aolserver4.tcl

USER=projop
GROUP=projop
ADDRESS=0.0.0.0
CONF=/web/projop/etc/config.tcl

Change next line (about line 42, remove -s main)

#-u $USER -g $GROUP -b $ADDRESS:$PORT -s main -t $CONF >/dev/null 2>&1
-u $USER -g $GROUP -b $ADDRESS:$PORT -t $CONF >/dev/null 2>&1

Test everything works

reboot

BE PATIENT, ]po[ can take up to 1 min to start after rebooting.

5. Config

Look into config file (/web/projop/etc/config.tcl) for tuning your server sitename, listening port, etc

6. Enjoy

Again, spacial thanks to Martin Van Es for mailing me with the tips on this update.

105 thoughts on “]Project-open[ on Debian ETCH”

  1. @matej,

    This means tsearch2 is not installed properly. I saw similar issues on a couple of installs. It had a lot to do with the locale and the proper install of tsearch2.

    Cheers,
    Venkat

  2. how to install openproject windows systems and give the side in download the openproject exe.

    thanks
    devendra

  3. Dear all:

    I finished all operations listed in the aforementioned guide on a debian system.

    I didn’t see any error information. it’s so exciting, coz i see some error on ubuntu and couldn’t correctly configure that.

    Please tell me how to browse my po site?

    what should i type in my browser address bar?

    i’m a greenhand.

    http://localhost shows a apache ‘it works!’ page.

    thanks!!!!

  4. Hola como estan!!..
    Les cuento que he tratado de instalar project – open en ubuntu gusty y todo va bien, hasta que doy clic en la pesta;a home y me paraece un herror. lo mismo me pasa otras pesta;as.
    Yo instale la version 8.3 de postgresql. Sera este el problema? Donde puedo descargarme postgresql 8.1 (como dice en el tutorial)
    Gracias por su ayudo
    saludos,

    Juan

  5. Hi,
    Am able to set up on ubuntu but getting error in the log about sec_session_timeout
    could you please guide me on this

  6. Hi @ all
    i ve installed everything but under localhost:8800 i only get:
    Server Error
    The requested URL cannot be accessed due to a system error on this server.

    AOLserver/4.5.0 on http://projectopen:8000

    i think it is something with the aol server but i cant figure out what exactly

  7. hi

    I made all the steps to install project-open on Hardy.
    I get the error message:

    Server Error
    The requested URL cannot be accessed due to a system error on this server.
    AOLserver/4.5.0 on http://asus:8000

    like Subbu I suppose.
    The projop error log (in /web/projop/log) has same errors.
    1)

    I suppose this is the reason to killall aolserver4-nsd (the pid file is present only after installation, than is erased (I’m not sure).
    2) some similar errors like the following:

    3) finally

    I hope someone could help me, because I did many attempts without good results.
    Thx a lot, R. D.

  8. Excuse me for the double message: I quoted the error messages, but they are cutted off. I report them here. Please excuse me.
    1)
    Error: pidfile: failed to open pid file ‘/usr/lib/aolserver4/log/nspid.projop’: ‘No such file or directory’
    2)
    insert into secret_tokens(token_id, token, token_timestamp)
    values(sec_security_token_id_seq.nextval, ‘7AD7E6B8EE761A83A5F8C9CFCD4B7BB2E89A674B’, now());’
    [09/Sep/2008:12:29:41][16061.3082970800][-main-] Error: Ns_PgExec: result status: 7 message: ERROR: missing FROM-clause entry for table “sec_security_token_id_seq”
    LINE 4: values(sec_security_token_id_seq.nextval, ‘7AD7E6B8EE76…
    3)
    [09/Sep/2008:12:30:10][16061.3060898704][-conn:0-] Error: Tcl exception:
    invalid command name “sec_session_timeout”
    while executing
    “sec_session_timeout”
    (procedure “sec_generate_session_id_cookie” line 17)
    invoked from within
    “sec_generate_session_id_cookie”
    (procedure “sec_setup_session” line 61)
    invoked from within
    “sec_setup_session $untrusted_user_id $auth_level $account_status”
    (procedure “sec_login_handler” line 53)
    invoked from within
    “sec_login_handler”
    (procedure “sec_handler” line 13)
    invoked from within
    “sec_handler”
    (procedure “rp_filter” line 137)
    invoked from within
    “rp_filter preauth”

  9. Hola Ivan tengo un problemita…. he configurado tod al pie de la letra pero al momento de correr el servidor se queda en un loop y me muesdrta esto vez tras vez pero nunca termina, agradezco tu ayuda

    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Debug: acs-mail: encode: starting 20140
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Debug: PLPGSQL: bypassed anon function
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Notice: Querying ‘

    select acs_mail_multipart__multipart_p (‘20140′);’
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Notice: dbinit: sql(localhost::projop): ‘

    select acs_mail_multipart__multipart_p (‘20140’);


    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Debug: acs-mail: encode: one part 20140
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Debug: PLPGSQL: using anonymous function
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Debug: NO FULLQUERY FOR dbqd.acs-tcl.tcl.00-database-procs.db_nextval.nextval_sequence –> using default SQL
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Notice: Querying ‘
    select nextval(‘anon_func_seq’) as nextval
    where (select relkind
    from pg_class
    where relname = ‘anon_func_seq’) = ‘S’;’
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Notice: dbinit: sql(localhost::projop): ‘
    select nextval(‘anon_func_seq’) as nextval
    where (select relkind
    from pg_class
    where relname = ‘anon_func_seq’) = ‘S’

    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Debug: db_nextval: sequence(anon_func_seq) is not a real sequence. perhaps it uses the view hack.
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Debug: NO FULLQUERY FOR dbqd.acs-tcl.tcl.00-database-procs.db_nextval.nextval_view –> using default SQL
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Notice: Querying ‘select nextval from anon_func_seq;’
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Notice: dbinit: sql(localhost::projop): ‘select nextval from anon_func_seq’
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Debug: PLPGSQL: converted:

    begin
    return content_item__get_latest_revision ( :content_item_id );
    end;

    to: select __exec_1559669_get_latest_revision ()
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Notice: Querying ‘create function __exec_1559669_get_latest_revision () returns varchar as ‘

    begin
    return content_item__get_latest_revision ( ”20140” );
    end;

    ‘ language ‘plpgsql’;’
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Notice: dbinit: sql(localhost::projop): ‘create function __exec_1559669_get_latest_revision () returns varchar as ‘

    begin
    return content_item__get_latest_revision ( ”20140” );
    end;

    ‘ language ‘plpgsql”
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Notice: Querying ‘select __exec_1559669_get_latest_revision ();’
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Notice: dbinit: sql(localhost::projop): ‘select __exec_1559669_get_latest_revision ()’
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Notice: Querying ‘drop function __exec_1559669_get_latest_revision ();’
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Notice: dbinit: sql(localhost::projop): ‘drop function __exec_1559669_get_latest_revision ()’
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Notice: Querying ‘

    select storage_type from cr_items
    where item_id = ‘20140’;’
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Notice: dbinit: sql(localhost::projop): ‘

    select storage_type from cr_items
    where item_id = ‘20140’


    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Notice: Querying ‘

    select content, mime_type as v_content_type
    from cr_revisions
    where revision_id = ‘20141’;’
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Notice: dbinit: sql(localhost::projop): ‘

    select content, mime_type as v_content_type
    from cr_revisions
    where revision_id = ‘20141’


    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Debug: acs-mail: encode: one part hit 20140
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Notice: Querying ‘

    select header_name, header_content from acs_mail_body_headers
    where body_id = ‘20139’;’
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Notice: dbinit: sql(localhost::projop): ‘

    select header_name, header_content from acs_mail_body_headers
    where body_id = ‘20139’


    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Notice: acs_mail_process_queue: to_send_2={maria antonietta_de tord figueras@freenet.es} frank.bergmann@project-open.com {Assignment: Complete RFQ Form Fraber Workflow Testproject} {You have been assigned to a task.

    Case : Fraber Workflow Testproject
    Task : Complete RFQ Form
    Task website: http://pcdev32.dnsalias.com//workflow/task?task_id=63
    } d453
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Notice: acs_mail_process_queue: failure: Expected a 250 status line; got:
    501 : “@” or “.” expected after “maria”
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Notice: Querying ‘

    select body_id from acs_mail_links where mail_link_id = ‘20154’;’
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Notice: dbinit: sql(localhost::projop): ‘

    select body_id from acs_mail_links where mail_link_id = ‘20154’


    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Notice: Querying ‘

    select header_message_id, header_reply_to, header_subject,
    header_from, header_to, content_item_id
    from acs_mail_bodies
    where body_id = ‘20151’;’
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Notice: dbinit: sql(localhost::projop): ‘

    select header_message_id, header_reply_to, header_subject,
    header_from, header_to, content_item_id
    from acs_mail_bodies
    where body_id = ‘20151’


    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Debug: acs-mail: encode: starting 20152
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Debug: PLPGSQL: bypassed anon function
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Notice: Querying ‘

    select acs_mail_multipart__multipart_p (‘20152′);’
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Notice: dbinit: sql(localhost::projop): ‘

    select acs_mail_multipart__multipart_p (‘20152’);


    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Debug: acs-mail: encode: one part 20152
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Debug: PLPGSQL: using anonymous function
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Debug: NO FULLQUERY FOR dbqd.acs-tcl.tcl.00-database-procs.db_nextval.nextval_sequence –> using default SQL
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Notice: Querying ‘
    select nextval(‘anon_func_seq’) as nextval
    where (select relkind
    from pg_class
    where relname = ‘anon_func_seq’) = ‘S’;’
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Notice: dbinit: sql(localhost::projop): ‘
    select nextval(‘anon_func_seq’) as nextval
    where (select relkind
    from pg_class
    where relname = ‘anon_func_seq’) = ‘S’

    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Debug: db_nextval: sequence(anon_func_seq) is not a real sequence. perhaps it uses the view hack.
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Debug: NO FULLQUERY FOR dbqd.acs-tcl.tcl.00-database-procs.db_nextval.nextval_view –> using default SQL
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Notice: Querying ‘select nextval from anon_func_seq;’
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Notice: dbinit: sql(localhost::projop): ‘select nextval from anon_func_seq’
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Debug: PLPGSQL: converted:

    begin
    return content_item__get_latest_revision ( :content_item_id );
    end;

    to: select __exec_1559670_get_latest_revision ()
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Notice: Querying ‘create function __exec_1559670_get_latest_revision () returns varchar as ‘

    begin
    return content_item__get_latest_revision ( ”20152” );
    end;

    ‘ language ‘plpgsql’;’
    [04/Dec/2008:08:46:37][4524.163851][-sched:13-] Notice: dbinit: sql(localhost::projop): ‘create function __exec_1559670_get_latest_revision () returns varchar as ‘

    begin
    return content_item__get_latest_revision ( ”20152” );
    end;

  10. Hola Diego

    Qué versión de PostgreSQL has usado? Le has instalado el paquete de contrib para poder habilitar tsearch2?
    Es una Debian ETCH vanilla? es decir, vacía?

    Tengo que actualizar el tuto a Lenny, porque con ETCH al final se acabará quedando obsoleto…. a ver si tengo un rato estas navidades y me pongo :-)

    Salu2!

  11. Hola Ivan :

    No pues era simplemente bajar el apache porue estaba corriendo en el mismo puerto y ya…………………………… lo que aun lo he logrado es correr el servidor como un proceso del inittab……………….. edite el aolserver4 del init.d pero nada………

    de antemano gracias!!!!!!!!!!!!!!!!!!!!!!
    pregunta… de donde eres????

    /etc/init.d/aolserver4 start
    Starting web server: aolserver4
    Error: required -t option not specified

    Usage: /usr/sbin/aolserver4-nsd [-h|V] [-i|f] [-u ] [-g ] [-r ] [-b |-B ] [-s ] -t

    -h help (this message)
    -V version and release information
    -i inittab mode
    -f foreground mode
    -d debugger-friendly mode (ignore SIGINT)
    -u run as
    -g run as
    -r chroot to
    -b bind
    -B bind address:port list from
    -s use server named in config file
    -t read config from (REQUIRED)

    failed!

  12. Hi Ivan ,

    thanks for ur guidelines . it helped me a lot. I got ]po[ running , but the problem now is ,when I want to clean the demo data , it shows me the following error report :

    no encoding for type “text/html”
    while executing
    “ns_startcontent -type $content_type”
    (procedure “ad_return_top_of_page” line 7)
    invoked from within
    “ad_return_top_of_page “[im_header]\n[im_navbar]””
    (“uplevel” body line 47)
    invoked from within
    “uplevel {
    # /packages/intranet-core/www/admin/pg_dump.tcl

    ad_page_contract {
    Performs a PostgreSQL pg_dump command to backup
    all data …”
    (procedure “code::tcl::/web/projop/packages/intranet-core/www/admin/back…” line 2)
    invoked from within
    “code::tcl::$__adp_stub”
    invoked from within
    “if { [file exists $__adp_stub.tcl] } {

    # ensure that data source preparation procedure exists and is up-to-date
    adp_init tcl $__adp_stub
    …”
    (“uplevel” body line 3)
    invoked from within
    “uplevel {

    if { [file exists $__adp_stub.tcl] } {

    # ensure that data source preparation procedure exists and is up-to-date
    adp_init t…”
    (procedure “adp_prepare” line 2)
    invoked from within
    “adp_prepare ”
    (procedure “template::adp_parse” line 30)
    invoked from within
    “template::adp_parse [file root [ad_conn file]] {}”
    (procedure “adp_parse_ad_conn_file” line 5)
    invoked from within
    “$handler”
    (“uplevel” body line 2)
    invoked from within
    “uplevel $code”
    invoked from within
    “ad_try {
    $handler
    } ad_script_abort val {
    # do nothing
    }”
    invoked from within
    “rp_serve_concrete_file [ad_conn file]”
    (procedure “rp_serve_abstract_file” line 60)
    invoked from within
    “rp_serve_abstract_file “$root/$path””
    (“uplevel” body line 2)
    invoked from within
    “uplevel $code”
    invoked from within
    “ad_try {
    rp_serve_abstract_file “$root/$path”
    set tcl_url2file([ad_conn url]) [ad_conn file]
    set tcl_url2path_info…”

    for postgres backup option on the admin site .
    Showing also errors when I am trying to delete demo users and so on.
    Any ideas ?
    Thanks in advance …
    Walter

  13. Sorry walter, i’m not the developer, I only maintain Debian packages. Please, send this question to the ]PO[ devel team :-)

  14. Hi Ivan ,

    thanks anyway . One short question : could this error message relate somehow to debian lenny ? Because I found out that I installed by accident lenny and not etch.
    Thanks again .
    Walter

  15. Hi walter, never installed on Lenny, so I’m not sure. You could try on a fresh Etch install.
    Anyway, ]PO[ is coded in TCL, and i only know php, a little python and ruby, so for me it’s very difficult to trace this kind of errors.

    I’m sorry I can’t help you much more :-\

  16. Before I start sorry for the long post. It is a long error message I get :-) And I am quite a newbie with Linux so I don’t know what is important or not.

    Onwards with the post:

    Ivan, thanks for the great work. I have installed it in Ubuntu Intrepid in about 30 minutes. It was a great tutorial. And I am newbie to Linux.

    I do have a problem though. When I access the 0.0.0.0:8000, I get to the login page.

    I login with

    sysadmin@tigerpond.com
    system

    And I get the following error:

    wrong # args: should be “AcsSc.auth_authentication.authenticate.local username username password password parameters parameters authority_id authority_id”

    But if I click on the Projects tab above I am logged in the system.

    But then if I click on the Home tab, I get this error:

    There was a server error processing your request. We apologize.

    Please contribute to remove this error by pressing the button below:

    Here is a detailed dump of what took place at the time of the error, which may assist a programmer in tracking down the problem:

    Database operation “select” failed

    (exception ERROR, “ERROR: function to_date(timestamp with time zone, unknown) does not exist

    LINE 14: , (to_date(start_date,’YYYY-MM-DD HH24:MI:SS’) – to_date…

    ^

    HINT: No function matches the given name and argument types. You might need to add explicit type casts.

    “)

    pqerror was: “ERROR: function to_date(timestamp with time zone, unknown) does not exist

    LINE 14: , (to_date(start_date,’YYYY-MM-DD HH24:MI:SS’) – to_date…

    ^

    HINT: No function matches the given name and argument types. You might need to add explicit type casts.

    (Status of PQexec call: PGRES_FATAL_ERROR)

    SQL:

    select

    to_char(start_date, ‘YYYY-MM-DD HH24:MI:SS’) as ansi_start_date,

    to_char(end_date, ‘YYYY-MM-DD HH24:MI:SS’) as ansi_end_date,

    to_number(to_char(start_date,’HH24′),’90’) as start_hour,

    to_number(to_char(end_date,’HH24′),’90’) as end_hour,

    to_number(to_char(end_date,’MI’),’90’) as end_minutes,

    coalesce(e.name, a.name) as name,

    coalesce(e.status_summary, a.status_summary) as status_summary,

    e.event_id as item_id,

    cit.type as item_type,

    cals.calendar_id,

    cals.calendar_name

    , (to_date(start_date,’YYYY-MM-DD HH24:MI:SS’) – to_date(‘2009-01-25 00:00:00’, ‘YYYY-MM-DD HH24:MI:SS’)) as day_of_week

    from

    acs_activities a,

    acs_events e,

    timespans s,

    time_intervals t,

    calendars cals,

    cal_items ci left join

    cal_item_types cit on cit.item_type_id = ci.item_type_id

    where

    e.timespan_id = s.timespan_id

    and s.interval_id = t.interval_id

    and e.activity_id = a.activity_id

    and start_date between

    to_date(‘2009-01-25 00:00:00’, ‘YYYY-MM-DD HH24:MI:SS’) and to_date(‘2009-01-31 00:00:00’, ‘YYYY-MM-DD HH24:MI:SS’)

    and ci.cal_item_id= e.event_id

    and cals.calendar_id = ci.on_which_calendar

    and acs_permission__permission_p (cals.calendar_id, ‘624’, ‘read’) = ‘t’

    and e.event_id = ci.cal_item_id

    and ((cals.package_id = ‘21531’ and cals.private_p = ‘f’)

    or (cals.private_p = ‘t’ and cals.owner_id = ‘624’))

    order by to_char(start_date, ‘J’), to_char(start_date,’HH24:MI’)

    while executing

    “ns_pg_bind select nsdb1 {

    select

    to_char(start_date, ‘YYYY-MM-DD HH24:MI:SS’) as ansi_start_date,

    to_char(end_date, ‘YYYY-MM-DD HH24:MI:SS’) as a…”

    (“uplevel” body line 1)

    invoked from within

    “uplevel $ulevel [list ns_pg_bind $type $db $sql]”

    (“postgresql” arm line 2)

    invoked from within

    “switch $driverkey {

    oracle {

    return [uplevel $ulevel [list ns_ora $type $db $sql] $args]

    }

    …”

    invoked from within

    “db_exec select $db $full_statement_name $sql”

    invoked from within

    “set selection [db_exec select $db $full_statement_name $sql]”

    (“uplevel” body line 2)

    invoked from within

    “uplevel 1 $code_block ”

    invoked from within

    “db_with_handle -dbn $dbn db {

    set selection [db_exec select $db $full_statement_name $sql]

    set counter 0

    while { [db_getrow $…”

    (procedure “db_foreach” line 36)

    invoked from within

    “db_foreach dbqd.calendar.www.views.select_items {} {

    # Replace $ (variable dollars) by harmless “X”

    regsub {\$} $name X name

    # Convert f…”

    (“uplevel” body line 73)

    invoked from within

    “uplevel {

    if {[info exists url_stub_callback]} {

    # This parameter is only set if this file is called from .LRN.

    # This way I make sure …”

    (procedure “code::tcl::/web/projop/packages/calendar/www/view-week-displ…” line 2)

    invoked from within

    “code::tcl::$__adp_stub”

    invoked from within

    “if { [file exists $__adp_stub.tcl] } {

    # ensure that data source preparation procedure exists and is up-to-date

    adp_init tcl $__adp_stub

    …”

    (“uplevel” body line 3)

    invoked from within

    “uplevel {

    if { [file exists $__adp_stub.tcl] } {

    # ensure that data source preparation procedure exists and is up-to-date

    adp_init t…”

    (procedure “adp_prepare” line 2)

    invoked from within

    “adp_prepare ”

    (procedure “template::adp_parse” line 30)

    invoked from within

    “template::adp_parse /web/projop/packages/calendar/www/view-week-display {base_url /calendar/ date 2009-01-27 package_id 21531 show_calendar_name_p 0 r…”

    (“uplevel” body line 1)

    invoked from within

    “uplevel [list template::adp_parse [template::util::url_to_file $template [ad_conn file]] $template_params]”

    (procedure “ad_parse_template” line 15)

    invoked from within

    “ad_parse_template -params $params “/packages/calendar/www/view-week-display””

    (procedure “im_calendar_home_component” line 10)

    invoked from within

    “im_calendar_home_component”

    (“uplevel” body line 1)

    invoked from within

    “uplevel 1 $component_tcl”

    invoked from within

    “set component_html [uplevel 1 $component_tcl]”

    (“uplevel” body line 8)

    invoked from within

    “uplevel 1 $code_block ”

    (“1” arm line 1)

    invoked from within

    “switch $errno {

    0 {

    # TCL_OK

    }

    1 {

    # TCL_ERROR

    …”

    (“while” body line 20)

    invoked from within

    “while { [db_getrow $db $selection] } {

    incr counter

    if { [info exists array_val] } {

    unset array_val

    …”

    (“uplevel” body line 5)

    invoked from within

    “uplevel 1 $code_block ”

    invoked from within

    “db_with_handle -dbn $dbn db {

    set selection [db_exec select $db $full_statement_name $sql]

    set counter 0

    while { [db_getrow $…”

    (procedure “db_foreach” line 36)

    invoked from within

    “db_foreach get_plugins $plugin_sql {

    if {$any_perms_set_p > 0 && “f” == $perm} { continue }

    if {“” == $sort_order} { set sort_order $default_sort…”

    (procedure “im_component_bay” line 71)

    invoked from within

    “im_component_bay left”

    invoked from within

    “append __adp_output [im_component_bay left] ”

    (“uplevel” body line 24)

    invoked from within

    “uplevel {

    set __adp_output “”

    set __adp_master [template::util::url_to_file “[ad_parameter -package_id [ad_conn subsite_id] DefaultMaster …”

    (procedure “template::code::adp::/web/projop/packages/intranet-core/www/…” line 2)

    invoked from within

    “template::code::${template_extension}::$__adp_stub”

    (procedure “template::adp_parse” line 68)

    invoked from within

    “template::adp_parse [file root [ad_conn file]] {}”

    (procedure “adp_parse_ad_conn_file” line 5)

    invoked from within

    “$handler”

    (“uplevel” body line 2)

    invoked from within

    “uplevel $code”

    invoked from within

    “ad_try {

    $handler

    } ad_script_abort val {

    # do nothing

    }”

    invoked from within

    “rp_serve_concrete_file [ad_conn file]”

    (procedure “rp_serve_abstract_file” line 60)

    invoked from within

    “rp_serve_abstract_file “$root/$path””

    (“uplevel” body line 2)

    invoked from within

    “uplevel $code”

    invoked from within

    “ad_try {

    rp_serve_abstract_file “$root/$path”

    set tcl_url2file([ad_conn url]) [ad_conn file]

    set tcl_url2path_info…”

  17. Be aware everyone that is installing Project-Open on Debian, that it only works flawlessly with postgresql-8.1. So if you install any version above that (namely postgresql-8.3) it will not work.

  18. Hi Ivan,

    Do you know if your Debian package will work on a PowerPC? I have a Mac G4 PowerPC running Debian 4.0 etch.

    I’ve run through you install instructions so far, but I’ve a feeling your “project-open_3.2-1_i386.deb” is x86 and won’t work on PPC.

    Would you be able to confirm for me.

    Would I be able to compile something similar for Debian PPC?

    Best regards,

    Alex

  19. Hello Alex

    I don’t know if PPC packages have a different structure than x86 ones, for uncompression and installation. The ]PO[ package is only TCL source code and configuracion files, so I think it should work on any platform, because the TCL interpreter is the one you have on your system, compiled for your platform.

    Please let us know if it works for you, thanks :-)

  20. Hello Ivan,

    Many thanks for your comments – the answer I was hoping for :)

    I’ll let you know how I get on.

    Cheers
    Alex

  21. Hi Ivan,

    I’ve just created a clean install of Debian etch, then gone through your install instructions again. I downloaded your package using wget, then ran:

    dpkg -i project-open_3.2-1_i386.deb

    But got the following error:

    dpkg: error processing dpkg -i project-open_3.2-1_i386.deb (–install)
    package architecture (i386) does not match system (powerpc)

    and exited.

    As you know I’m running Debian etch on a PowerPC (Mac G4).

    Does it get the package architecture information from the filename? i.e. the i386 bit of the package filename? If so I wondering if I can fool dpkg and change ‘i386’ partion of the filename for ‘powerpc’.

    What are your thoughts for getting all the tcl and configuration files on to my system in the correct place? Would there be any other ways?

    Kind regards,
    Alex

  22. Hi Ivan,

    Ignore my post (78). I realised I should try dpkg –force-architecture, this worked!

    Then proceeded with the rest of your install instructions, had a wierd problem with removal of -s main in line 42 of /etc/init.d/aolserver4 that made aolserver fail to start on boot. (maybe the way I formed the new line in the config file, so just removed -s main out of original line (though strange because both lines looked identical, just one was commented out). Anyway then booted fine.

    Looged on and have the project-open demo log-in page! So looks like so far, so good on Debian under PowerPC.

    Many thanks Ivan for your great instructions.

    Alex

  23. Thanks for the detailed instructions and .deb files!

    I did run into one problem. Your instructions tell me to modify the file /etc/init.d/aolserver4, making this change:

    #-u $USER -g $GROUP -b $ADDRESS:$PORT -s main -t $CONF >/dev/null 2>&1
    -u $USER -g $GROUP -b $ADDRESS:$PORT -t $CONF >/dev/null 2>&1

    Perhaps this should have been obvious, but leaving in the commented-out line caused problems. When I restarted aolserver4 (/etc/init.d/aolserver4 restart) it gave error messages about not having a required “-t” parameter. Looking closer, I see that the line 42 is a continuation of line 41. Having the extra line in between I assume caused problems. After deleting the commented line, everything works.

    Thanks again!

  24. Hi there Chris, nice to see it worked for you too :-)
    About the line 42, this is because of the aol4 package version. When I wrote this tuto line 42 was a complete one.

    I’ll correct the document, thanks!

  25. Hi All!

    Thanks for the great work. We’re slowly but surely preparing for the release of V3.4 (official release: September 2009), so I’m checking how things are going here.

    My question: What would you Debian guys expect from us ]po[ guys in terms of support for Debian? Iván, would you be interested to prepare a .deb package for V3.4 and/or provide support for such a package?

    As I said, there are still 4-5 month until the release, so we are definitely not in a hurry… Also, we’d like to release several Alpha and Beta versions before the final release.

    Bests,
    Frank

  26. Hi Venkat,
    When I try to install AOL server
    with the command below
    apt-get install aolserver4 aolserver4-dev aolserver4-doc aolserver4-nscache aolserver4-nsopenssl aolserver4-nspostgres aolserver4-nssha1 aolserver4-nsxml tdom
    I get;
    Package aolserver4-nscache is not available, but is referred to by another package.
    This may mean that the package is missing, has been obsoleted, or
    is only available from another source
    E: Package aolserver4-nscache has no installation candidate
    Please help me, where can I find the aol packes???

  27. @Frank

    Of course you can count on me for mantaining the deb packages :-)

    Maybe we can meet again some day for lunch, and talk about the project. I’m curious to see wha’t new in 3.4… maybe you can show me something in advance heheh

  28. @murat

    I had the same problem as well. I downloaded the nscache package from the Ubuntu repositories. But it has to be downloaded from the hardy repo and installed manually. Having said that, I am having issues working with aolserver4 on ubuntu. will post back when I find a solution for this.

    Venkat

  29. Hi Ivan

    I’ve installed po as you said. but I have the same error as some ppl above and I didn’t find any solution here…:
    the aolserver log says:
    Error: Tcl exception:
    invalid command name “sec_session_timeout”
    while executing
    “sec_session_timeout”
    (procedure “sec_generate_session_id_cookie” line 17)
    invoked from within
    “sec_generate_session_id_cookie”
    (procedure “sec_setup_session” line 61)
    invoked from within
    “sec_setup_session $untrusted_user_id $auth_level $account_status”
    (procedure “sec_login_handler” line 53)
    invoked from within
    “sec_login_handler”
    (procedure “sec_handler” line 13)
    invoked from within
    “sec_handler”
    (procedure “rp_filter” line 137)
    invoked from within
    “rp_filter preauth”

    This error occures, when I try to access the webpage. Do you might know anything about that?
    I’ve already asked in the po forums on sf, but they don’t reponse…

    thx!

  30. i have this error when opening any project has tasks or allowed to add tasks

    Database operation “select” failed
    (exception ERROR, “ERROR: relation “im_biz_object_tree_status” does not exist
    “)

    while executing
    “ns_pg_bind select nsdb1 {
    select child.project_id as child_id
    from im_projects child,
    im_projects parent
    where parent.project_id in (
    select o…”
    (“uplevel” body line 1)
    invoked from within
    “uplevel $ulevel [list ns_pg_bind $type $db $sql]”
    invoked from within
    “db_exec select $db $full_statement_name $sql”
    (“uplevel” body line 2)
    invoked from within
    “uplevel 1 $code_block ”
    invoked from within
    “db_with_handle -dbn $dbn db {
    set selection [db_exec select $db $full_statement_name $sql]

    set counter 0
    while { [db_getrow $…”
    (procedure “db_foreach” line 36)
    invoked from within
    “db_foreach oc_sub $oc_sub_sql {
    set closed_projects_hash($child_id) 1
    }”
    (procedure “im_timesheet_task_list_component” line 286)
    invoked from within
    “im_timesheet_task_list_component -restrict_to_project_id $project_id -max_entries_per_page 10 -view_name im_timesheet_task_list_short”
    (“uplevel” body line 1)
    invoked from within
    “uplevel 1 $component_tcl”
    (“uplevel” body line 8)
    invoked from within
    “uplevel 1 $code_block ”
    (“uplevel” body line 1)
    invoked from within
    “uplevel 1 $code_block ”
    invoked from within
    “db_with_handle -dbn $dbn db {
    set selection [db_exec select $db $full_statement_name $sql]

    set counter 0
    while { [db_getrow $…”
    (procedure “db_foreach” line 36)
    invoked from within
    “db_foreach get_plugins $plugin_sql {

    if {$any_perms_set_p > 0 && “f” == $perm} { continue }

    if {“” == $sort_order} { set sort_order $default_sort…”
    (procedure “im_component_bay” line 59)
    invoked from within
    “im_component_bay left”
    (“uplevel” body line 31)
    invoked from within
    “uplevel {
    set __adp_output “”

    set __adp_master [template::util::url_to_file “../master” “$__adp_stub”]
    set __adp_properties(title) “[ad_qu…”
    (procedure “template::code::adp::c:/project-open/servers/projop/packages…” line 2)
    invoked from within
    “template::code::${template_extension}::$__adp_stub”
    (procedure “template::adp_parse” line 68)
    invoked from within
    “template::adp_parse [file root [ad_conn file]] {}”
    (procedure “adp_parse_ad_conn_file” line 5)
    invoked from within
    “$handler”
    (“uplevel” body line 2)
    invoked from within
    “uplevel $code”
    invoked from within
    “ad_try {
    $handler
    } ad_script_abort val {
    # do nothing
    }”
    invoked from within
    “rp_serve_concrete_file [ad_conn file]”
    (procedure “rp_serve_abstract_file” line 60)
    invoked from within
    “rp_serve_abstract_file “$root/$path””
    (“uplevel” body line 2)
    invoked from within
    “uplevel $code”
    invoked from within
    “ad_try {
    rp_serve_abstract_file “$root/$path”
    set tcl_url2file([ad_conn url]) [ad_conn file]
    set tcl_url2path_info…”

  31. this is the worst software ever, worst web interface, it has bugs all around, it appears that the far they go into development and releases, we get more errors.
    We tried to find a simple alternative for sharepoint project server. sharepoint project server make some problems in installing, but once installed, it works like charm. it has integration that works flawlessly with all microsoft programs.
    now this server, install easy, so it tricks you, but once installed, it will sit there and throws at you irrelevant database bugs, and detailed tcl dumps… i mean “create a new project->type software development-> BUG!!!”

  32. Toro right! Its trickly soft – we started used it for our company and faced with same errors – we cant type in that system no one project and category without bug page!

  33. Dear Toro – Dear Vikont

    please make sure your are using the most recent version of ]po[. There are dozens of installers out there, some with outdated versions of ]po[.

    Please update your install as described here:
    http://www.project-open.org/documentation/tutorial_updates
    and also study the manuals before configuring ]po[. Do not delete categories, rather disable them.

    Next time please first consult the community forum: https://sourceforge.net/projects/project-open/forums/forum/295937 and see if somebody else run into the same problem as you did. Make a new post only if you can’t find anything.

    Also consider contact us directly and we are happy to help!

    ./klaus

  34. Hye…I’m new to Project-open..I already installed p-o on ubuntu 10.04 LTS…It works!!!however I encountered some problems. There are some buttons when i click it shows an error. For example, when i click the timesheet button, the errors are as below:

    Here is a detailed dump of what took place at the time of the error, which may assist a programmer in tracking down the problem:

    Database operation “0or1row” failed
    (exception ERROR, “ERROR: function to_date(timestamp with time zone, unknown) does not exist
    LINE 1: select to_date(date_trunc(‘month’,add_months( $1 ,1)),’YYYY-…
    ^
    HINT: No function matches the given name and argument types. You might need to add explicit type casts.
    QUERY: select to_date(date_trunc(‘month’,add_months( $1 ,1)),’YYYY-MM-DD’) – 1
    CONTEXT: PL/pgSQL function “last_day” line 6 at SQL statement
    “)
    pqerror was: “ERROR: function to_date(timestamp with time zone, unknown) does not exist
    LINE 1: select to_date(date_trunc(‘month’,add_months( $1 ,1)),’YYYY-…
    ^
    HINT: No function matches the given name and argument types. You might need to add explicit type casts.
    QUERY: select to_date(date_trunc(‘month’,add_months( $1 ,1)),’YYYY-MM-DD’) – 1
    CONTEXT: PL/pgSQL function “last_day” line 6 at SQL statement

    (Status of PQexec call: PGRES_FATAL_ERROR)
    SQL: select to_char(trunc(to_date(‘2010-05-23’, ‘yyyy-mm-dd’), ‘Month’), ‘fmMonth’) as month,
    to_char(trunc(to_date(‘2010-05-23’, ‘yyyy-mm-dd’), ‘Month’), ‘YYYY’) as year,
    to_char(trunc(to_date(‘2010-05-23’, ‘yyyy-mm-dd’), ‘Month’), ‘J’) as first_julian_date_of_month,
    to_char(last_day(to_date(‘2010-05-23’, ‘yyyy-mm-dd’)), ‘DD’) as num_days_in_month,
    to_char(trunc(to_date(‘2010-05-23’, ‘yyyy-mm-dd’), ‘Month’), ‘D’) as first_day_of_month,
    to_char(last_day(to_date(‘2010-05-23’, ‘yyyy-mm-dd’)), ‘DD’) as last_day,
    trunc(add_months(to_date(‘2010-05-23’, ‘yyyy-mm-dd’), 1),’Day’) as next_month,
    trunc(add_months(to_date(‘2010-05-23’, ‘yyyy-mm-dd’), -1),’Day’) as prev_month,
    trunc(to_date(‘2010-05-23’, ‘yyyy-mm-dd’), ‘year’) as beginning_of_year,
    to_char(last_day(add_months(to_date(‘2010-05-23’, ‘yyyy-mm-dd’), -1)), ‘DD’) as days_in_last_month,
    to_char(add_months(to_date(‘2010-05-23’, ‘yyyy-mm-dd’), 1), ‘fmMonth’) as next_month_name,
    to_char(add_months(to_date(‘2010-05-23’, ‘yyyy-mm-dd’), -1), ‘fmMonth’) as prev_month_name
    from dual

    while executing
    “ns_pg_bind 0or1row nsdb0 -bind d11 {select to_char(trunc(to_date(:the_date, ‘yyyy-mm-dd’), ‘Month’), ‘fmMonth’) as month,
    to_char(trunc(to_date(:…”
    (“eval” body line 1)
    invoked from within
    “eval [list ns_pg_bind $type $db -bind $bind $sql]”
    (“postgresql” arm line 2)
    invoked from within
    “switch $driverkey {
    oracle {
    return [eval [list ns_ora $type $db -bind $bind $sql] $args]
    …”
    invoked from within
    “db_exec 0or1row $db $full_statement_name $sql”
    invoked from within
    “set selection [db_exec 0or1row $db $full_statement_name $sql]”
    (“uplevel” body line 2)
    invoked from within
    “uplevel 1 $code_block ”
    invoked from within
    “db_with_handle -dbn $dbn db {
    set selection [db_exec 0or1row $db $full_statement_name $sql]
    }”
    (procedure “db_0or1row” line 23)
    invoked from within
    “db_0or1row calendar_get_information {select to_char(trunc(to_date(:the_date, ‘yyyy-mm-dd’), ‘Month’), ‘fmMonth’) as month,
    to_char(trunc(to_date(…”
    (“uplevel” body line 1)
    invoked from within
    “uplevel db_0or1row $args”
    (procedure “db_1row” line 2)
    invoked from within
    “db_1row calendar_get_information $month_info_query -bind $bind_vars -column_set calendar_info_set”
    (procedure “calendar_get_info_from_db” line 31)
    invoked from within
    “calendar_get_info_from_db $date”
    (“uplevel” body line 116)
    invoked from within
    “uplevel {
    # /packages/intranet-timesheet2/www/hours/index.tcl
    #
    # Copyright (C) 1998-2004 various parties
    # The code is based on ArsDigita ACS …”
    (procedure “code::tcl::/web/projop/packages/intranet-timesheet2/www/hour…” line 2)
    invoked from within
    “code::tcl::$__adp_stub”
    invoked from within
    “if { [file exists $__adp_stub.tcl] } {

    # ensure that data source preparation procedure exists and is up-to-date
    adp_init tcl $__adp_stub
    …”
    (“uplevel” body line 3)
    invoked from within
    “uplevel {

    if { [file exists $__adp_stub.tcl] } {

    # ensure that data source preparation procedure exists and is up-to-date
    adp_init t…”
    (procedure “adp_prepare” line 2)
    invoked from within
    “adp_prepare ”
    (procedure “template::adp_parse” line 30)
    invoked from within
    “template::adp_parse [file root [ad_conn file]] {}”
    (procedure “adp_parse_ad_conn_file” line 5)
    invoked from within
    “$handler”
    (“uplevel” body line 2)
    invoked from within
    “uplevel $code”
    invoked from within
    “ad_try {
    $handler
    } ad_script_abort val {
    # do nothing
    }”
    invoked from within
    “rp_serve_concrete_file [ad_conn file]”
    (procedure “rp_serve_abstract_file” line 60)
    invoked from within
    “rp_serve_abstract_file “$root/$path””
    (“uplevel” body line 2)
    invoked from within
    “uplevel $code”
    invoked from within
    “ad_try {
    rp_serve_abstract_file “$root/$path”
    set tcl_url2file([ad_conn url]) [ad_conn file]
    set tcl_url2path_info…”

    *So i would like to if u guys ever encountered the same problem. I updated the latest p-o but it’s the same. Thank you so much.

  35. Hola Ivan,

    e instalado P-O en Ubuntu 10.04 LTS todo iba bien hasta que intenté hacer loggin con el usuario: sysadmin@tigerpond.com y contraseña: system, cuándo hago click en el botón de loggin me aparece el siguiente error:
    wrong # args: should be “AcsSc.auth_authentication.authenticate.local username username password password parameters parameters authority_id authority_id”, el log de la aplicación indica el siguiente error:
    [14/Jun/2010:16:15:54][2673.18446744072864536336][-default:6-] Error: Error invoking CanRetrievePassword operation for authority_id 9:
    wrong # args: should be “AcsSc.auth_password.canretrievepassword.local parameters parameters”
    while executing
    “AcsSc.auth_password.canretrievepassword.local {}”
    (“uplevel” body line 1)
    invoked from within
    “uplevel $func_and_args”
    (procedure “apply” line 3)
    invoked from within
    “apply $proc_name $arguments”
    (procedure “acs_sc_call” line 6)
    invoked from within
    “acs_sc_call -error=$error_p $contract $operation $call_args $impl”
    (procedure “acs_sc::invoke” line 17)
    invoked from within
    “acs_sc::invoke -error -contract “auth_password” -impl_id $impl_id -operation CanRetrievePassword -call_args [list $parameters]”
    (procedure “auth::password::CanRetrievePassword” line 11)
    invoked from within
    “auth::password::CanRetrievePassword -authority_id $authority_id”
    invoked from within
    “set result_p [auth::password::CanRetrievePassword -authority_id $authority_id]”
    (“uplevel” body line 2)
    invoked from within
    “uplevel $body

    Gracias por tu ayuda!

  36. @Gromit

    delete the database and create the database again…i encountered the same problem before…after created new database, it works!!!

  37. Hi,

    thank you for the guide, which I followed and made things work (apart from the fact that my etch installation had the wrong repositories….)

    I have a problem: can’t establish a connection to the server at 62.75.157.119:8000

    I have updated the config file, the correct server, localhost etc… and I’m running out of ideas..!

    any help is welcomed!!!!

  38. I need some help getting this thing to work on lenny.
    I followed this tut step by step, but it does not work.
    Just “Server Error – The requested URL cannot be accessed due to a system error on this server.”

    projop.log :
    10.0.0.62 – – [26/Oct/2010:13:41:44 +0200] “GET / HTTP/1.1” 500 538 “” “Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.9.2.11) Gecko/20101012 Firefox/3.6.11 ( .NET CLR 3.5.30729)” “ad_user_login=624%2c1288082965%2c0367B9B91+%7b967+0+B3F50C598071AAE1546029B90DC206965386A3D2%7d”
    10.0.0.62 – – [26/Oct/2010:13:49:24 +0200] “GET / HTTP/1.1” 500 538 “” “Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.9.2.11) Gecko/20101012 Firefox/3.6.11 ( .NET CLR 3.5.30729)” “ad_user_login=624%2c1288082965%2c0367B9B91+%7b967+0+B3F50C598071AAE1546029B90DC206965386A3D2%7d”
    10.0.0.62 – – [26/Oct/2010:13:54:15 +0200] “GET / HTTP/1.1” 500 538 “” “Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.9.2.11) Gecko/20101012 Firefox/3.6.11 ( .NET CLR 3.5.30729)” “ad_user_login=624%2c1288082965%2c0367B9B91+%7b967+0+B3F50C598071AAE1546029B90DC206965386A3D2%7d”
    10.0.0.62 – – [26/Oct/2010:13:55:38 +0200] “GET / HTTP/1.1” 500 538 “” “Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.9.2.11) Gecko/20101012 Firefox/3.6.11 ( .NET CLR 3.5.30729)” “ad_user_login=624%2c1288082965%2c0367B9B91+%7b967+0+B3F50C598071AAE1546029B90DC206965386A3D2%7d”

    error.log :
    [26/Oct/2010:13:43:07][1975.3074558144][-main-] Notice: driver: stopped: nssock
    [26/Oct/2010:13:43:07][1975.3059415952][-shutdown-] Notice: nslog: closing ‘/web/projop/log/projop.log’
    [26/Oct/2010:13:43:07][1975.3074558144][-main-] Error: pidfile: failed to remove ‘/usr/lib/aolserver4/log/nspid.projop’: ‘No such file or directory’
    [26/Oct/2010:13:43:07][1975.3074558144][-main-] Notice: nsmain: AOLserver/4.5.0 exiting

    Both logs do not really give any information on this problem.

    The server output sais : Tcl exception : invalid command name “sec_session_timeout” …

    Maybe somebody can help.
    This tuorial is a bit out of date, because postgresql 8.1 is not available.
    The repositories have been deleted, and postgres, google etc. do not have it.

  39. Hi ,
    i ma new to projectopen.
    after installing i am experiencing following error:-
    projop@ubuntu:/$ /usr/sbin/aolserver4-nsd -f -t /home/abhinav/web/projop/etc/config.tcl -u projop -g projop
    [07/Dec/2010:12:29:25][2878.1256097536][-main-] Notice: nsd.tcl: starting to read config file…
    [07/Dec/2010:12:29:30][2878.1256097536][-main-] Notice: nsd.tcl: finished reading config file.
    [07/Dec/2010:12:29:30][2878.1256097536][-main-] Notice: nsmain: AOLserver/4.5.1 starting
    [07/Dec/2010:12:29:30][2878.1256097536][-main-] Notice: nsmain: security info: uid=1001, euid=1001, gid=1002, egid=1002
    [07/Dec/2010:12:29:30][2878.1256097536][-main-] Notice: nsmain: max files: FD_SETSIZE = 1024, rl_cur = 1024, rl_max = 1024
    [07/Dec/2010:12:29:30][2878.1256097536][-main-] Error: pidfile: failed to open pid file ‘/usr/lib/aolserver4/log/nspid.projop’: ‘Permission denied’
    [07/Dec/2010:12:29:30][2878.1256097536][-main-] Notice: encoding: loaded: utf-8
    [07/Dec/2010:12:29:30][2878.1256097536][-main-] Notice: fastpath[projop]: mapped GET /
    [07/Dec/2010:12:29:30][2878.1256097536][-main-] Notice: fastpath[projop]: mapped HEAD /
    [07/Dec/2010:12:29:30][2878.1256097536][-main-] Notice: fastpath[projop]: mapped POST /
    [07/Dec/2010:12:29:30][2878.1256097536][-main-] Notice: adp[projop]: mapped GET /*.adp
    [07/Dec/2010:12:29:30][2878.1256097536][-main-] Notice: adp[projop]: mapped HEAD /*.adp
    [07/Dec/2010:12:29:30][2878.1256097536][-main-] Notice: adp[projop]: mapped POST /*.adp
    [07/Dec/2010:12:29:30][2878.1256097536][-main-] Notice: modload: loading ‘/usr/lib/aolserver4/bin/nssock.so’
    [07/Dec/2010:12:29:30][2878.1256097536][-main-] Notice: modload: loading ‘/usr/lib/aolserver4/bin/nslog.so’
    [07/Dec/2010:12:29:30][2878.1256097536][-main-] Warning: modload: could not load /usr/lib/aolserver4/bin/nslog.so: /usr/lib/aolserver4/bin/nslog.so: file too short
    [07/Dec/2010:12:29:30][2878.1256097536][-main-] Fatal: modload: failed to load module ‘/usr/lib/aolserver4/bin/nslog.so’

    Kindly respond.

Leave a Reply

Your email address will not be published.