[horde] Fwd: Encountering problems with Postgres.

[Chuck Hagenbuch]

Please keep discussion on the list.


----- Forwarded message from pvantony at singnet.com.sg -----
     Date: Wed, 03 Dec 2008 01:23:02 -0800
     From: "P.V.Anthony" <pvantony at singnet.com.sg>
  Subject: Re: [horde] Encountering problems with Postgres.
       To: Chuck Hagenbuch <chuck at horde.org>

Chuck Hagenbuch wrote:

> Please share some actual details about your problems, and we might  
> be able to help you.

Thank you very much for looking into this. Really needed the help and
you are willing to helping. Thank you.

Did a fresh clean install of Horde Groupware Webmail 1.2.

When doing the scripts/setup.php got the following error when creating
the tables.

----------------- start ---------------------------------------
Loading database module...
Creating database...
[ ERROR! ] Creating the tables failed. Please see the manual at docs/INSTALL
            for how to setup the database manually. Error messages:
MDB2 Error: unknown error
_doQuery: [Error message: Could not execute statement]
[Last executed query: CREATE  TABLE horde_alarms (alarm_id VARCHAR(255)
DEFAULT ' ' NOT NULL, alarm_uid VARCHAR(255) DEFAULT NULL, alarm_start
TIMESTAMP without time zone DEFAULT '0000-00-00 00:00:00' NOT NULL,
alarm_end TIMESTAMP without time zone DEFAULT '0000-00-00 00:00:00',
alarm_methods VARCHAR(255) DEFAULT NULL, alarm_params TEXT, alarm_title
VARCHAR(255) DEFAULT ' ' NOT NULL, alarm_text TEXT, alarm_snooze
TIMESTAMP without time zone DEFAULT '0000-00-00 00:00:00',
alarm_dismissed SMALLINT DEFAULT 0 NOT NULL, alarm_internal TEXT)]
[Native message: ERROR:  date/time field value out of range: "0000-00-00
00:00:00"
HINT:  Perhaps you need a different "datestyle" setting.]
------------------ end ----------------------------------------

Did some search on google and changed the '0000-00-00 00:00:00' to
'0000-01-01 00:00:00' at scripts/sql/create.xml

That solved the above error messages. Please let me know if this is the
right thing to do.

The following errors only happens when the "Request persistent
connections" is not set.

After logging into horde got the following error at the left menu,

------------------- start ----------------------------------------
Warning: pg_escape_string(): 180 is not a valid PostgreSQL link resource
in /var/www/localhost/htdocs/horde-webmail-1.2/pear/DB/pgsql.php on line 522
--------------------- end ----------------------------------------

Also got the following error at calender, tasks and notes.

----------------------- start --------------------------------
Warning: pg_escape_string(): 33 is not a valid PostgreSQL link resource
in /var/www/localhost/htdocs/horde-webmail-1.2/pear/DB/pgsql.php on line 522
----------------------- end ----------------------------------

In the logs at /tmp/horde.log got the following error.

------------------------- start ----------------------------------------
Dec 02 18:55:31 HORDE [error] [imp] DB Error: connect failed: SELECT
alarm_id, alarm_uid, alarm_start, alarm_end, alarm_methods,
alarm_params, alarm_title, alarm_text, alarm_snooze, alarm_internal FROM
horde_alarms WHERE alarm_dismissed = 0 AND ((alarm_snooze IS NULL AND
alarm_start <= '') OR alarm_snooze <= '') AND (alarm_end IS NULL OR
alarm_end >= '') AND (alarm_uid = '' OR alarm_uid = '') ORDER BY
alarm_start, alarm_end [nativecode=Database connection has been lost.]
[pid 25546 on line 303 of
"/var/www/localhost/htdocs/horde-webmail-1.2/lib/Horde/Alarm.php"]
------------------------- end ------------------------------------------

What am I doing wrong?

PosgresSQL version 8.0.15
php 5.2.6
horde Groupware Webmail 1.2
Linux Kernel 2.6.23
Apache 2.2.9

P.V.Anthony





----- End forwarded message -----


-chuck