]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.
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.
noviembre 21st, 2007 at 20:59
Hi Ivan,
Nice guide you have here, but i got a problem, maybe you can help me.
When i start the aolserver with:
/usr/sbin/aolserver4-nsd -f -t /web/projop/etc/config.tcl -u projop -g projop
I got the following Error:
[21/Nov/2007:17:56:13][3535.3084015296][-main-] Error: Ns_PgOpenDb(postgres): Could not connect to localhost::projop: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket “/var/run/postgresql/.s.PGSQL.5432″?
[21/Nov/2007:17:56:13][3535.3084015296][-main-] Error: dbdrv: failed to open database ‘postgres:localhost::projop’
[21/Nov/2007:17:56:13][3535.3084015296][-main-] Warning: Database API: couldn’t allocate a handle from database pool “pool2″.[21/Nov/2007:17:56:13][3535.3084015296][-main-] Error: Database API: RDBMS type could not be determined for any pool.
It seems that the server cant connect to my postgres database, but im sure that postgres is running and the projop database is created.
Thx for the help.
noviembre 22nd, 2007 at 14:45
Hi Bruno
Please, make sure you changee the settings on pg_hba.conf. You could also make sure your config.tcl is using the right user for connecting to database.
You can try su projop - (“projop” or the user you’ve created for the app), then try to psql projop (“projop” or the database name you’ve created for the code).
If you have a vanilla Debian and you follow this guide, you’ll surely get a working PO installation. If for any reason you’re using other settings or users, you’ll need to make sure you adjust all settings on the PO installation to your current system.
For postgreSQL you have to create a database and a owner user. The owner user must be the system user that owns the permissions of the app directory (/web/projop or wherever you moved it).
Ivan
noviembre 22nd, 2007 at 23:24
Hi,
After installation when running aolserver and project open I’ve got following error:
Warning: modload: could not load /usr/lib/aolserver4/bin//nspostgres.so: libnspostgres.so: cannot open shared object file: No such file or directory
[22/Nov/2007:22:31:03][13332.3083728560][-main-] Error: dbdrv: failed to load driver ‘postgres’
[22/Nov/2007:22:31:03][13332.3083728560][-main-] Error: dbinit: no such default pool ‘pool1′
Any ideas what’s wrong?
Thanks
noviembre 22nd, 2007 at 23:25
BTW there is no such file in whole system: libnspostgres.so
noviembre 23rd, 2007 at 01:21
And update…I’ve compiled nspostgres from sources and built libnspostgres. After copying it to aolserver lib directory – the same error message…no such file od directory ;(
noviembre 23rd, 2007 at 17:29
———————————–
apt-get install aolserver4 aolserver4-dev aolserver4-doc aolserver4-nscache aolserver4-nsopenssl aolserver4-nspostgres aolserver4-nssha1 aolserver4-nsxml tdom
———————————–
Please, update the system (apt-get update && apt-get upgrade) and install all these packages. I repeat: VANILLA DEBIAN ETCH 4.0. Not ubuntu, or kubuntu, or knoppix, or any other strange Debian mutation. If you want a functional ]PO[ erp working on a Debian system, this is your tutorial. Other things maybe won’t work with the instructions of this tuto.
Ivan
noviembre 23rd, 2007 at 22:52
I’ve managed to solve it – after recompiling nspostgres once again it started to work. yes, it’s not vanilla debian – it’s ubuntu – but still your guide is almost perfect! Thanks alot!
noviembre 24th, 2007 at 19:50
adamf, can you post the solution? I have the same problem trying to install on Ubuntu. Best regards, Andreas
noviembre 26th, 2007 at 14:00
adamf: thnks to you for your interest :-)
And like Andreas says, please, post your solution so all other users can use it heh
noviembre 26th, 2007 at 16:19
Hi again Ivan.
I solved my problem. :)
The problem is that my postmaster is running in the 5433 port instead of default 5432 (I dont know why).
Thx anyway, and keeping this nice work.
noviembre 26th, 2007 at 19:12
Ivan, thank you very much for the wonderful install guides and .deb packages. I created a checklist out of your previous guidelines with AOLServer 3.3 and PostgreSQL 8.0.13. It is available online and for download at http://www.venkatmangudi.com/index.php?option=com_content&task=view&id=18&Itemid=37
noviembre 27th, 2007 at 00:43
Hi Ivan,
Many thanks for your great install guides. I’ve been using it in a Debian Etch and everythings seem’s all right except when I start the aolserver with:
/usr/sbin/aolserver4-nsd -f -t /web/projop/etc/config.tcl -u projop -g projop
I’ve got the following message in Firefox :
“Server Error
The requested URL cannot be accessed due to a system error on this server.
AOLserver/4.0.10 on http://sd-12240:8000”
Any idea what’s wrong… ? Many thanks in advance for your help.
Pierre
noviembre 27th, 2007 at 14:29
Hi there Pierre
First of all, is it a Vanilla Debian system? If it’s your case… have you another app running on port 8000?
I’ve never seen any Aolserver Error (i never used it before this tuto heheh). What does syslog say (tail /var/log/syslog)? and Aolserver logs (look at /web/projop/log)?
Ivan
noviembre 27th, 2007 at 14:33
Hi Venkat
Nice work for Ubuntu ;-)
Maybe you should update it to use Aolserver 4 version, as I see you’re using my first version of the packages. Now I’m using PostgreSQL and AOLserver from official repos, and my only own package is the Project-Open one (which is what I was intended to do from the beginning).
Ivan
noviembre 27th, 2007 at 18:13
Hi Ivan,
Thanks a lot for your quick answer.
I’m using a Debian 4.0 Etch from an datacenter dedicated server.
I’ve checked app on port 8000 and nothing else apart the aolserver…
Regarding log’s here is the “error.log” (web/projop/log/error.log)
28/Nov/2007:00:00:00][5275.3074034608][-sched-] Notice: util::roll_server_log: Done rolling the server log.
[28/Nov/2007:00:00:00][5275.3074034608][-sched-] Debug: Done running scheduled proc util::roll_server_log.
[28/Nov/2007:00:00:00][5275.3074034608][-sched-] Notice: nslog: closing ‘/web/projop/log/projop.log’
[28/Nov/2007:00:00:00][5275.3074034608][-sched-] Error: rollfile: invalid max parameter ’1000′; must be > 0 and using default SQL
[28/Nov/2007:00:00:12][5275.3054422960][-sched:13-] Notice: Querying ‘
select message_id,
envelope_from,
envelope_to
from
acs_mail_queue_outgoing
LIMIT 700;’
[28/Nov/2007:00:00:12][5275.3054422960][-sched:13-] Notice: dbinit: sql(localhost::projop): ‘
select message_id,
envelope_from,
envelope_to
from
acs_mail_queue_outgoing
LIMIT 700
‘
[28/Nov/2007:00:00:12][5275.3054422960][-sched:13-] Notice: Querying ‘
select body_id from acs_mail_links where mail_link_id = ’20202′;’
[28/Nov/2007:00:00:12][5275.3054422960][-sched:13-] Notice: dbinit: sql(localhost::projop): ‘
select body_id from acs_mail_links where mail_link_id = ’20202′
‘
[28/Nov/2007:00:00:12][5275.3054422960][-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 = ’20199′;’
[28/Nov/2007:00:00:12][5275.3054422960][-sched:13-] Notice: dbinit: sql(localhost::projop): ‘
I’m not really experienced with this environnement… However, could it be something wrong with smtp or/and port 25… ?
Thanks for your help
Pierre
noviembre 30th, 2007 at 12:55
I’ve managed to solve it, I’ve done a new install in Etch and everything ok expcept the “search module”… pb with PG…
I’m trying to solve this pb and will let you now asap
Best regards
Pierre
diciembre 13th, 2007 at 18:43
I also tried to get ]po[ to work according to this tutorial
First on a machine running Debian Lenny (testing).
Here I also got the problem with “nspostgres.so”, but I couldn’t figure out how to solve it. Possibly someone has an idea, because I’d like to run it on that machine.
On another machine running ETCH, I could start it, but I cannot figure out, how to login into the system
By default user is “sysadmin@tigerpond.com”, but I don’t know how to start now.
BR, Thomas
diciembre 18th, 2007 at 01:47
Ivan Wrote:
>Nice work for Ubuntu ;-)
>Maybe you should update it to use Aolserver 4 version, as I see you’re using >my first version of the packages. Now I’m using PostgreSQL and AOLserver f>rom official repos, and my only own package is the Project-Open one (which >is what I was intended to do from the beginning).
Thank you, Ivan.
I am still trying to get the newer version running on Ubuntu. There is the common nspostgres.so problem. That was resolved by getting the AOLServer4-nspostgres_4.0-3_i386.deb. Looks like the newer Ubuntu repos have a later version. Because I did so many installs and uninstalls of PostgreSQL on my system, it is all confused now. When I get ]po[ up and running on Ubuntu, I will add another version to the checklist.
Everyone who are getting the libnspostgres.so error while starting AOL Server are probably using the 4.0.4 version of nspostgres. Seems to have some problems. I saw that quite a few people had that issue. The recommendation was to download the previous version .deb and install it independently rather than from the repos. It might work.
1. wget http://www.venkatmangudi.com/aolserver4-nspostgres_4.0-3_i386.deb
2. dpkg -i aolserver4-nspostgres_4.0-3_i386.deb
Do these between step 1 and 2 in Ivan’s tutorial. In step 2 of Ivan’s tutorial, do not install aolserver4-nspostgres. Hopefully, this will resolve the libnspostgres issues.
enero 5th, 2008 at 19:05
Hola Ivan,
Tiengo un AMD64. Acase teneis um deb propio para esso?
Gracias
enero 28th, 2008 at 06:53
Venkat Mangudi: Thanks for sharing your solution with everyone. It helped resolve my issues in getting OpenACS running under Ubuntu JeOS.
Kind regards,
Justis Peters
febrero 15th, 2008 at 17:17
what is the default user and password for administrator login?
Thanks!
febrero 27th, 2008 at 16:21
OK, I feel very stupid now, spent 10 minutes trying to work it out and found they are on the left. My eyes just thought it was some list of credits to the people who worked on the project!
febrero 27th, 2008 at 16:26
Gaz: I didn’t replay your post because I was away on a travel and I’ve seen it just today. But anyway, congrats for your discovery heheh
febrero 29th, 2008 at 21:23
Thanks a lot, Ivan!
I just tried it out, followed your instructions to the letter and got my ]po[ up and running in 1/2 hour. I think it saved me at least two days searching, swearing and tossing my hair out …
marzo 1st, 2008 at 06:10
Hey Andreas,
Nice to see my little tuto helps people. Thanx for your comment :-D
marzo 12th, 2008 at 21:25
I’m receiving this error (below) and not sure why. I did follow your instructions and the data has correctly been important (for a quick test of the system). Any ideas what is going on with this?
Thanks!
Pete
Server startup failed: Error during bootstrapping
No fullquery for dbqd.acs-tcl.tcl.apm-procs.apm_package_installed_p_not_cached.apm_package_installed_p and default SQL empty – query for statement missing
while executing
“error “No fullquery for $statement_name and default SQL empty – query for statement missing”"
(procedure “db_qd_replace_sql” line 10)
invoked from within
“db_qd_replace_sql $statement_name $pre_sql”
(procedure “db_exec” line 12)
invoked from within
“db_exec 0or1row $db $full_name $sql”
invoked from within
“set selection [db_exec 0or1row $db $full_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_name $sql]
}”
(procedure “db_string” line 8)
invoked from within
“db_string apm_package_installed_p {} -default 0″
(procedure “apm_package_installed_p_not_cached” line 2)
invoked from within
“apm_package_installed_p_not_cached $package_key”
(procedure “apm_package_installed_p” line 5)
invoked from within
“apm_package_installed_p acs-kernel”
(procedure “ad_verify_install” line 6)
invoked from within
“ad_verify_install”
marzo 17th, 2008 at 02:57
Gracias, Ivan.
Instalación perfecta en Debian etch.
Mi aporte: deben correr la ip de la maquina que sirve a p-o, en el puerto 8000
Atte.,
Antonio
marzo 17th, 2008 at 20:42
Pete: install the Postgresql-8.X-contrib package, it contais the tsearch2 module, needed to perform fulltextsearch queries.
Antonio: thx por la aportación :-)
Salu2!
Ivan
abril 3rd, 2008 at 16:18
Ivan, buenisimo tu tutorial, la verdad una joya. Me sirvio demasiado ya tengo andando el project open en debian ;).
Solo tengo dos consultas para hacerte, si por favor me las podes responder te haria un monumento por poco :P.
1. No logro descifrar como hacer para que el servidor me arranque con el arranque del sistema, me podes dar una mano con esto? debe ser facil calculo.
2. No se como hacer para configurar el acs-mail-lite. Tenes idea de esto como funciona?
Muchas Gracias, Saludos!
Nicolas
abril 4th, 2008 at 11:56
Hola Nicolás
Gracias, de verdad me alegro de que te haya servido el tuto :-)
Verás, de entrada debo decir que yo no formo parte del staffde Project-Open, ni siquiera soy usuario de Project-Open. SImplemente colaboré con ellos con esta documentación, porque necesitaba instalarlo en las oficinas de un cliente y no existía documentación ni paquetería para Debian, así que la hice yo.
Por ese motivo en realidad no sé mucho como funciona Project-Open por dentro, con lo cual la segunda cuestión no puedo resolvértela.
En cuanto a lanzar el servicio al arranque del sistema, el punto 4 del manual explica precisamente ésto. Podrías ejecutar el init script (/etc/init.2/aolserver4) y decirme si arranca el servicio o no?
Un saludo!
abril 4th, 2008 at 14:00
Hola Ivan, gracias por tu pronta respuesta, te comento que lo tengo todo hecho tal cual lo hiciste vos en el tutorial. Por eso no entiendo porque no arranca como servicio, te muestro:
NAME=aolserver4
#USER=www-data
#GROUP=www-data
#ADDRESS=127.0.0.1
USER=projop
GROUP=projop
ADDRESS=0.0.0.0
CONF=/web/projop/etc/config.tcl
PORT=80
PATH=/bin:/usr/bin:/sbin:/usr/sbin
DAEMON=/usr/sbin/aolserver4-nsd
PIDFILE=/var/run/aolserver4/$NAME.pid
#CONF=/etc/aolserver4/aolserver4.tcl
y tambien edite la fila 42 con lo que decis vos, y tampoco arranca al inicio, si reinicio la pc y trato de entrar via http me tira error.
:(
Te mando un saludo!
Nicolas
abril 6th, 2008 at 23:15
Hola Nicolas.
Ok, pero si ejecutas /etc/init.d/aolserver4 (equivoqué el comentario anterior haciendo referencia a /etc/init.2/…, disculpa) se ejecuta bien?
Si es asi entonces se trata de que no lo tienes bien enlazado en el init system.
SI arrancas con runlevel 2 (por defecto) entonces simplemente te basta con ejecutar:
update-rc.d aolserver4 defaults
Por eso te preguntaba antes. Si por el contrario no se ejecuta el servicio al lanzarlo con esa línea, entonces es porque el script no tiene permisos de ejecución:
chmod 755 /etc/init.d/aolserver4
Espero que te sirva de ayuda, un saludo!
abril 7th, 2008 at 14:46
Hola Ivan, no te quiero molestar, te muestro:
“aolserver:/# /etc/init.d/aolserver4
Usage: /etc/init.d/aolserver4 {start|stop|restart|reload|force-reload}
aolserver:/# /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!
aolserver:/# update-rc.d aolserver4 defaults
System startup links for /etc/init.d/aolserver4 already exist.
aolserver:/# chmod 755 /etc/init.d/aolserver4″
Luego de todo esto, me sigue tirando el mismo error igualmente.
Se entendio? Muchas Gracias!
Nico
abril 7th, 2008 at 20:15
Hola Nicolas
Creo que esta claro. Te falta el parámetro -t, que se especifica en la linea 42 (aprox).
Si el parámetro está bien puesto, entonces por lo que sea la variable $CONF no está bien seteada. Vigila que esté definida correctamente (ver punto 4 del manual), y comprueba que el fichero exista.
De todas formas, viendo tu comentario anterior en el que me muestras tu configuración, veo que la variable está bien definida. En ese caso te falta el parámetro -t en la línea 42 que es la que lanza el servicio.
Por favor comprueba los PATH’s, el nombre de las variables, la sintaxis de la línea… muchas veces nos pasan estas cosas por un simple punto, una coma, o un typo en un nombre de variable.
Un saludo
abril 8th, 2008 at 05:16
Thanks. Did a fresh vanilla Debian install and worked like a charm. Thanks for taking the time to post your instructions.
Mark.
abril 8th, 2008 at 11:00
Hello Mark
Thank you, I’m happy to see my work helps others ;-)
abril 9th, 2008 at 19:09
I had som problems, looking at
/var/log/mail.log
there were inabot 30 seconds of interval a lot of messages like:
warning: Illegal address syntax from localhost[127.0.0.1] in RCPT command:
and others. I solved it by doing a
$ su – projop
$ psql projop
projop=# delete from acs_mail_queue_outgoing ;
projop=# \q
abril 10th, 2008 at 16:36
Hi,
Thanks for the howto, I’ve installed it succesfully but got one problem. The tdom package is not available in Debian/Sid. I suppose this is why I encouter the following exception :
No fullquery for dbqd.acs-tcl.tcl.apm-procs.apm_package_installed_p_not_cached.apm_package_installed_p and default SQL empty – query for statement missing
while executing
“error “No fullquery for $statement_name and default SQL empty – query for statement missing”"
(procedure “db_qd_replace_sql” line 10)
invoked from within
I’ve installed tsearch2, so it seems to be the only thing missing. Any hint except recompiling tdom by hand to solve the problem ?
Thanks.
Didrik
abril 10th, 2008 at 20:23
Hi Didrik,
nice (nick).?name heheh
I would try with backports, i suppose they will contain an up-to-date tDom package.
abril 14th, 2008 at 16:36
hi,
i have the following error after this install when i want to create/get into some project: ERROR: No dictionary with name ‘en_stem’
do you know where can be the problem? thanks…
abril 15th, 2008 at 14:24
Hi Matej
No idea about this error, Never seen before. Sorry :-(
Is it on a fresh debian install?
abril 26th, 2008 at 01:55
Hola Iván,
He realizado todos los pasos y parece que todo va ok. Ahora tengo un problema de novato, por mucho que configuro el config.tcl, no va.
Podrías decirme una configuración básica para ver si funciona?
abril 26th, 2008 at 16:38
Hola Pablo
Yo he usado siempre la que viene por defecto con PO, cambiando solo lo que explico en el paso 3.
Podrias decirme el error que te da?
Salu2
abril 26th, 2008 at 18:22
Pues la verdad es que no lo sé,
Supuestamente no tengo que iniciar ningún servicio no?, la url podría ser localhost:8000/projop ?
el apache está en el puerto 80, no se si será problema con eso
abril 28th, 2008 at 11:19
que apache?
Te recomendaria que sigas el tutorial partiendo de un sistema Debian recién instalado. Si lo haces así y sigues las instrucciones al pie de la letra todo irá bien :-)
Un saludo
mayo 13th, 2008 at 16:02
Cordial Saludo..
he instalado project-open en ubuntu, pero al realizar apt-get update y actualizar el postgres me sale el siguiente error: alguna pista?? mil gracias
Request Error
Server startup failed: Error during bootstrapping
command “ns_db” is not enabled
while executing
“ns_db pools”
(procedure “db_bootstrap_set_db_type” line 61)
invoked from within
“db_bootstrap_set_db_type database_problem”
MIL GRACIAS POR EL APOYO
mayo 16th, 2008 at 17:17
Master, cuando trato de instalar las dependencies y el aolserver4 me dice:
E: No se pudo encontrar el paquete libreadline5-dev
Puede ser que esta en español? puede tener algo que ver?
Saludos!
Nicolas
mayo 17th, 2008 at 13:32
Es posible que te falte actualizar APT.
Edita el fichero /etc/apt/sources.list y añade los repositorios contrib y non-free, como sigue:
De hecho incluso puedes usar backports tambien, aunque no es necesario ya que las versiones de ETCH estan bastante bien para ]PO[
Después de guardar el fichero, actualiza APT con apt-get update. Supongo que entonces ya tendrás disponible ese paquete :-)
Salu2
mayo 22nd, 2008 at 03:15
The tutorial worked very well for me for a debian installation from scratch using the .deb installation file however I have tried twice now upgrading and I’m getting stuck with the cvs Version 3.3 of ]po[
I have the feeling that the postgresql database gets corrupted since some fields seem to be missing and ]po[ is throwing errors. I'm not quite sure whether this is a problem of the postgresql Version 8.1.11 or ]po[ but I will revert my VM for now to the 3.2.10.1 Version since I have spent way too much time on the issue :-)
Anyone else having similar problems upgrading or is it me being silly?
junio 24th, 2008 at 16:15
Hello,
i’m not able to run project open can anyone help me?
junio 27th, 2008 at 06:40
@davide,
Could you be more specific why you are not able to run Project Open?
Cheers,
Venkat
junio 27th, 2008 at 06:41
@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
julio 2nd, 2008 at 09:47
hello i have probalm this side
wget -c http://ivanhq.net/po/deb/project-open_3.2-1_i386.deb
http request sent, awaiting response… 416 Requested Range Not Satisfiable
this problam please solve
julio 2nd, 2008 at 12:13
how to install openproject windows systems and give the side in download the openproject exe.
thanks
devendra
julio 2nd, 2008 at 15:45
@devendra,
Guess your network timed out downloading the ]po[ deb file. It works well for me.
Please check out http://www.project-open.org/download/index.html for installation options. Your best bet is to use VMWare for Windows installation.
Cheers,
Venkat
julio 5th, 2008 at 14:00
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!!!!
julio 6th, 2008 at 01:59
http://localhost:8000
:)
julio 6th, 2008 at 23:51
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
julio 22nd, 2008 at 07:58
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
septiembre 4th, 2008 at 15:18
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
septiembre 9th, 2008 at 11:47
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.
septiembre 9th, 2008 at 11:50
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”
diciembre 4th, 2008 at 19:56
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;
diciembre 5th, 2008 at 10: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!
diciembre 5th, 2008 at 15:47
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!
diciembre 14th, 2008 at 20:17
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
diciembre 16th, 2008 at 12:34
Sorry walter, i’m not the developer, I only maintain Debian packages. Please, send this question to the ]PO[ devel team :-)
diciembre 19th, 2008 at 16:33
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
diciembre 20th, 2008 at 05:45
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 :-\
enero 16th, 2009 at 15:50
Thank you very much for your guide, it was a great help.
enero 27th, 2009 at 19:10
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…”
febrero 3rd, 2009 at 09:39
Bonjour,
Sorry, but for the sample data, what’s the login email and password ?
febrero 11th, 2009 at 17:02
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.
febrero 14th, 2009 at 17:10
Hi diogo,
Thanks for the advise… I’m updating the tuto right now.
febrero 20th, 2009 at 10:00
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
febrero 20th, 2009 at 12:24
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 :-)
febrero 20th, 2009 at 23:19
Hello Ivan,
Many thanks for your comments – the answer I was hoping for :)
I’ll let you know how I get on.
Cheers
Alex
febrero 21st, 2009 at 00:50
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
febrero 22nd, 2009 at 00:59
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
febrero 24th, 2009 at 00:10
Hey Alex!
I’m glad my packages are working for you. And thanks for your explanation about the apt issue on the arch ;-)
marzo 24th, 2009 at 04:50
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!
marzo 24th, 2009 at 10:38
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!
abril 30th, 2009 at 15:56
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
mayo 3rd, 2009 at 14:04
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???
mayo 4th, 2009 at 09:38
@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
mayo 11th, 2009 at 10:41
@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
mayo 23rd, 2009 at 07:22
Thanx, everthings works as written
julio 21st, 2009 at 12:27
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!
enero 21st, 2010 at 03:16
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…”
enero 21st, 2010 at 03:17
please i need to anyone help me for this issue …………… how to fix it !!!!!!
febrero 15th, 2010 at 09:13
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!!!”
febrero 15th, 2010 at 23:13
@Toro this site is not the official ]PO[ one, it’s only for hosting the Debian installation instructions and packages. Please, address your feedback to http://www.project-open.com
Thanks
febrero 24th, 2010 at 15:03
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!
marzo 19th, 2010 at 11:23
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
mayo 23rd, 2010 at 08:33
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.
junio 14th, 2010 at 22:19
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!
julio 12th, 2010 at 04:10
@Gromit
delete the database and create the database again…i encountered the same problem before…after created new database, it works!!!
agosto 3rd, 2010 at 23:52
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!!!!
octubre 26th, 2010 at 13:16
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.
diciembre 7th, 2010 at 08:04
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.
diciembre 12th, 2010 at 11:38
Hi Dann,
“ERROR, “ERROR: function to_date(timestamp with time zone, unknown) does not exist”
This is a problem of the version of Postgres you’re using (http://www.mkyong.com/database/to_date-function-between-postgresql-82-and-83/)
Try using 8.1 as mentioned in instalation manual on debian or maybe 8.2 will work fine.
Kind Regards
marzo 24th, 2011 at 11:32
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(’2011-03-20 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(’2011-03-20 00:00:00′, ‘YYYY-MM-DD HH24:MI:SS’) and to_date(’2011-03-26 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 2011-03-24 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…”
marzo 24th, 2011 at 12:16
Hi Ivan,
Are you still here because the latest post from you is quite old !
Febrero 15th, 2010 at 23:13.
I contact you because i’ve tried many install of Project Open and none of them work.
The problems are :
- Debian Etch it’s now out of date (Squeeze is the current release)
- Postgresql 8.1 is not available anymore
___
So It doesn’t work for all these reasons.
Do you have a repository where we can get those packages.
Do you plan to publish a new install tutorial.
Sincerly.
Thierry Forest