[Obm] Installation problems

[Pierre Baudracco]

> My config:
> 
> - obm is installed in a box with php4, redhat 7.1, apache 1.3.24
> - obm database is installed in another box running Postgres 7.4.1.
> 
> These are the error messages I get:
> 
> 1) When running: install_obmdb_0.8.pgsql.sh
> 
> Obs -> I modified the script so that psql would use the -h
> 
> Default preferences propagation on created users
> 
> Warning: main(obminclude/global.inc) [http://www.php.net/function.main]: 
> failed to create stream: No
>  such file or directory in 
> /export/intranet/obm-0.8.3/php/admin_pref/admin_pref_index.php on line 23

Hi,

the obm root hasn't been set in your php.ini include_path.
For php in apache and for php on command line.
On debian for example there are 2 php.ini files.
I don't know on redhat 7.1
find all php.ini files and update the include_path so that it contains the obm
directory (eg :/var/www/obm)

> Warning: main() [http://www.php.net/function.main]: Failed opening 
> 'obminclude/global.inc' for inclu
> sion (include_path='.:/usr/local/lib/php') in 
> /export/intranet/obm-0.8.3/php/admin_pref/admin_pref_i
> ndex.php on line 23

same

> Warning: main(obminclude/global_pref.inc) 
> [http://www.php.net/function.main]: failed to create strea
> m: No such file or directory in 
> /export/intranet/obm-0.8.3/php/admin_pref/admin_pref_index.php on li
> ne 37

same

> Warning: main() [http://www.php.net/function.main]: Failed opening 
> 'obminclude/global_pref.inc' for
> inclusion (include_path='.:/usr/local/lib/php') in 
> /export/intranet/obm-0.8.3/php/admin_pref/admin_p
> ref_index.php on line 37
> -a -> $action=user_pref_update

same
 
> Fatal error: Call to undefined function:  debug_level_isset() in 
> /export/intranet/obm-0.8.3/php/admi
> n_pref/admin_pref_index.php on line 231

consequence
 
> ---------------------------
> 2) When accessing: http://obm/time/time_index.php

Normal there are still 2 modules that are not postgres compliant :
time and document modules

> Warning: pg_exec() [function.pg-exec]: Query failed: ERROR: function 
> unix_timestamp(timestamp without time zone) does not exist . in 
> /export/intranet/obm-0.8.3/obminclude/phplib/db_pgsql.inc on line 82
> Database error: Invalid SQL: select timetask_id, 
> UNIX_TIMESTAMP(timetask_date) as date_task, 
> UNIX_TIMESTAMP(timetask_timeupdate) as date_timeupdate, 
> UNIX_TIMESTAMP(timetask_timecreate) as date_timecreate, 
> concat(timetask_length,concat('/', 8)) as timetask_length, 
> ...

> --------------------------------------------
> 3) When accessing: 
>
http://obm/admin_data/admin_data_index.php?mode=html&action=data_show&module=document
> 
> 
> Warning: pg_exec() [function.pg-exec]: Query failed: ERROR: syntax error 
> at or near "CONCAT" at character 125 . in 
> /export/intranet/obm-0.8.3/obminclude/phplib/db_pgsql.inc on line 82
> Database error: Invalid SQL: select document_id, document_path, 
> document_name, document_kind from Document order by BINARY 
> CONCAT(document_path, document_name )
> PostgreSQL Error: 1 (ERROR: syntax error at or near "CONCAT" at 
> character 125 )
> 
> Warning: opendir(/var/www/obm/documents/) [function.opendir]: failed to 
> open dir: No such file or directory in 
> /export/intranet/obm-0.8.3/php/admin_data/admin_data_query.inc on line 129
> 
> Warning: readdir(): supplied argument is not a valid Directory resource 
> in /export/intranet/obm-0.8.3/php/admin_data/admin_data_query.inc on 
> line 131
> 
> Warning: closedir(): supplied argument is not a valid Directory resource 
> in /export/intranet/obm-0.8.3/php/admin_data/admin_data_query.inc on 
> line 137
> 
> Warning: pg_numrows(): supplied argument is not a valid PostgreSQL 
> result resource in 
> /export/intranet/obm-0.8.3/obminclude/phplib/db_pgsql.inc on line 201
> 
> Warning: current() [function.current]: Passed variable is not an array 
> or object in 
> /export/intranet/obm-0.8.3/php/admin_data/admin_data_display.inc on line 449
> 
> Warning: next() [function.next]: Passed variable is not an array or 
> object in 
> /export/intranet/obm-0.8.3/php/admin_data/admin_data_display.inc on line 560

OK, new bug opened
http://bugzilla.aliacom.fr/cgi-bin/bugzilla/show_bug.cgi?id=356

> ---------------------------------------------------
> 4) When accessing: 
>
http://obm/admin_data/admin_data_index.php?mode=html&action=data_update&module=document
> 
> 
> Warning: pg_exec() [function.pg-exec]: Query failed: ERROR: syntax error 
> at or near "CONCAT" at character 125 . in 
> /export/intranet/obm-0.8.3/obminclude/phplib/db_pgsql.inc on line 82
> Database error: Invalid SQL: select document_id, document_path, 
> document_name, document_kind from Document order by BINARY 
> CONCAT(document_path, document_name )
> PostgreSQL Error: 1 (ERROR: syntax error at or near "CONCAT" at 
> character 125 )

same

> ---------------------------------------------------
> 5) When accessing: http://obm/import/import_index.php
> 
> Not Found
> The requested URL /import/import_index.php was not found on this server.

The import module is not ready (this menu should not appear)

> Apache/1.3.24 Server at obm Port 80
> 
> Any ideas?
> thank you all

Hopes this helps
bye
 
> Rodrigo Filgueira Prates
> IT@CINTERFOR/OIT
> http://www.cinterfor.org.uy


-- 
Pierre Baudracco - Aliacom - 05 62 19 24 91 - www.aliacom.fr