]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.
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.


Miércoles, 21 Noviembre 2007, a las 8:59 pm
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.
Jueves, 22 Noviembre 2007, a las 2:45 pm
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
Jueves, 22 Noviembre 2007, a las 11:24 pm
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
Jueves, 22 Noviembre 2007, a las 11:25 pm
BTW there is no such file in whole system: libnspostgres.so
Viernes, 23 Noviembre 2007, a las 1:21 am
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 ;(
Viernes, 23 Noviembre 2007, a las 5:29 pm
———————————–
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
Viernes, 23 Noviembre 2007, a las 10:52 pm
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!
Sábado, 24 Noviembre 2007, a las 7:50 pm
adamf, can you post the solution? I have the same problem trying to install on Ubuntu. Best regards, Andreas
Lunes, 26 Noviembre 2007, a las 2:00 pm
adamf: thnks to you for your interest
And like Andreas says, please, post your solution so all other users can use it heh
Lunes, 26 Noviembre 2007, a las 4:19 pm
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.
Lunes, 26 Noviembre 2007, a las 7:12 pm
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
Martes, 27 Noviembre 2007, a las 12:43 am
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
Martes, 27 Noviembre 2007, a las 2:29 pm
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
Martes, 27 Noviembre 2007, a las 2:33 pm
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
Martes, 27 Noviembre 2007, a las 6:13 pm
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
Viernes, 30 Noviembre 2007, a las 12:55 pm
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
Jueves, 13 Diciembre 2007, a las 6:43 pm
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
Martes, 18 Diciembre 2007, a las 1:47 am
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.
Sábado, 5 Enero 2008, a las 7:05 pm
Hola Ivan,
Tiengo un AMD64. Acase teneis um deb propio para esso?
Gracias
Lunes, 28 Enero 2008, a las 6:53 am
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
Viernes, 15 Febrero 2008, a las 5:17 pm
what is the default user and password for administrator login?
Thanks!
Miércoles, 27 Febrero 2008, a las 4:21 pm
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!
Miércoles, 27 Febrero 2008, a las 4:26 pm
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
Viernes, 29 Febrero 2008, a las 9:23 pm
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 …
Sábado, 1 Marzo 2008, a las 6:10 am
Hey Andreas,
Nice to see my little tuto helps people. Thanx for your comment
Miércoles, 12 Marzo 2008, a las 9:25 pm
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
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”
Lunes, 17 Marzo 2008, a las 2:57 am
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
Lunes, 17 Marzo 2008, a las 8:42 pm
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
Jueves, 3 Abril 2008, a las 4:18 pm
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
Viernes, 4 Abril 2008, a las 11:56 am
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!
Viernes, 4 Abril 2008, a las 2:00 pm
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
Domingo, 6 Abril 2008, a las 11:15 pm
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!
Lunes, 7 Abril 2008, a las 2:46 pm
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
Lunes, 7 Abril 2008, a las 8:15 pm
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
Martes, 8 Abril 2008, a las 5:16 am
Thanks. Did a fresh vanilla Debian install and worked like a charm. Thanks for taking the time to post your instructions.
Mark.
Martes, 8 Abril 2008, a las 11:00 am
Hello Mark
Thank you, I’m happy to see my work helps others
Miércoles, 9 Abril 2008, a las 7:09 pm
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
Jueves, 10 Abril 2008, a las 4:36 pm
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
Jueves, 10 Abril 2008, a las 8:23 pm
Hi Didrik,
nice (nick).?name heheh
I would try with backports, i suppose they will contain an up-to-date tDom package.
Lunes, 14 Abril 2008, a las 4:36 pm
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…
Martes, 15 Abril 2008, a las 2:24 pm
Hi Matej
No idea about this error, Never seen before. Sorry
Is it on a fresh debian install?
Sábado, 26 Abril 2008, a las 1:55 am
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?
Sábado, 26 Abril 2008, a las 4:38 pm
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
Sábado, 26 Abril 2008, a las 6:22 pm
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
Lunes, 28 Abril 2008, a las 11:19 am
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
Martes, 13 Mayo 2008, a las 4:02 pm
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
Viernes, 16 Mayo 2008, a las 5:17 pm
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
Sábado, 17 Mayo 2008, a las 1:32 pm
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
Jueves, 22 Mayo 2008, a las 3:15 am
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?
Martes, 24 Junio 2008, a las 4:15 pm
Hello,
i’m not able to run project open can anyone help me?
Viernes, 27 Junio 2008, a las 6:40 am
@davide,
Could you be more specific why you are not able to run Project Open?
Cheers,
Venkat
Viernes, 27 Junio 2008, a las 6:41 am
@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
Miércoles, 2 Julio 2008, a las 9:47 am
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
Miércoles, 2 Julio 2008, a las 12:13 pm
how to install openproject windows systems and give the side in download the openproject exe.
thanks
devendra
Miércoles, 2 Julio 2008, a las 3:45 pm
@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
Sábado, 5 Julio 2008, a las 2:00 pm
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!!!!
Domingo, 6 Julio 2008, a las 1:59 am
http://localhost:8000
Domingo, 6 Julio 2008, a las 11:51 pm
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
Martes, 22 Julio 2008, a las 7:58 am
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
Jueves, 4 Septiembre 2008, a las 3:18 pm
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
Martes, 9 Septiembre 2008, a las 11:47 am
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.
Martes, 9 Septiembre 2008, a las 11:50 am
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”