#40 Postgresql and 0.7.4 is broken

[None]

It appears that 0.7.4 has broken postgresql support.

A few major problems I noticed:

1. The function mysql_fetch_array() is used instead of
pg_fetch_array() even when $db_type = "postgresql" is
set in lib/config.php. I noticed this in setup/index.php,
login/index.php, and login/chpass.php.

2. The function PASSWORD() is undefined on my
system even though it is used in several places (same
files as in above #1). I am assuming this function is
supposed to hash a users password so that it isn't
stored plaintext in the dbase. If so perhaps md5() should
be used instead?

3. I decided to drop my olbookmarks dbase and recreate
it using setup/database_setup_postgresql.sql. The
following error occured when I ran the file:

psql:database_setup_postgresql.sql:16: ERROR:
Type "datetime" does not exist

Just for the heck of it I changed every 'datetime'
to 'timestamp' and was able to get the script to run. I do
NOT yet know if the timestamp type is equivalent to
datetime.

My platform is:
- OpenBSD -current from cvs as of yesterday
- PHP 4.2.3 compiled from ports with only the pgsql
extension compiled and enabled
- Postgresql 7.3.2

It should be noted that this same system has been
running olbookmarks 0.7.2 perfectly so I think the above
is all related to the new multiuser login code found in
0.7.4. I will post a patch if I can get things working.

[Martin F. Krafft]

Logged In: YES
user_id=36552

I have exactly the same problems, and they still exist in
the current CVS. Is this being worked on, or has the project
died?

[Nobody/Anonymous]

Logged In: NO

The On-line demo has immediate errors:

Warning: session_start():
open(/home/groups/o/ol/olbookmarks/sessions/sess_570b577fc70a31100196902cbff52de5,
O_RDWR) failed: Read-only file system (30) in
/home/groups/o/ol/olbookmarks/htdocs/demo/olbookmarks/index.php
on line 30

Warning: session_start(): Cannot send session cookie -
headers already sent by (output started at
/home/groups/o/ol/olbookmarks/htdocs/demo/olbookmarks/index.php:30)
in
/home/groups/o/ol/olbookmarks/htdocs/demo/olbookmarks/index.php
on line 30

Warning: session_start(): Cannot send session cache limiter
- headers already sent (output started at
/home/groups/o/ol/olbookmarks/htdocs/demo/olbookmarks/index.php:30)
in
/home/groups/o/ol/olbookmarks/htdocs/demo/olbookmarks/index.php
on line 30

Warning: Cannot modify header information - headers already
sent by (output started at
/home/groups/o/ol/olbookmarks/htdocs/demo/olbookmarks/index.php:30)
in
/home/groups/o/ol/olbookmarks/htdocs/demo/olbookmarks/lib/libauth.php
on line 30

Warning: Unknown():
open(/home/groups/o/ol/olbookmarks/sessions/sess_570b577fc70a31100196902cbff52de5,
O_RDWR) failed: Read-only file system (30) in Unknown on line 0

Warning: Unknown(): Failed to write session data (files).
Please verify that the current setting of session.save_path
is correct (/home/groups/o/ol/olbookmarks/sessions) in
Unknown on line 0