[horde] SQL-based cache storage using Postgres

P.V.Anthony pvantony at singnet.com.sg
Sat Dec 6 13:56:51 UTC 2008


Hi,

After encountering errors with Postgresql 0.8.12, I upgraded to
Postgresql 8.2.7.

Still the errors are there when the presistan connection is not enabled.

Decided to activate presistance connections. Hope that is ok.

Now the problem is the SQL-based cache storage setting. After having
setup cache to use the horde database, horde_cache, the following errors
appear in horde.log.

------------- start -----------------------------
Dec 06 21:30:07 HORDE [error] [imp] DB Error: unknown error: INSERT INTO
horde_cache (cache_id, cache_timestamp, cache_expiration, cache_data)
VALUES ('4e152dcfd584070ae5fc65c06f4654f5', 1228570207, 1231162207,
'a:4:{i:21;s:395:"O:8:"stdClass":15:{s:7ubject";s@ tesiting at 4:"from@
10:"message_id@') [nativecode=ERROR:  invalid byte sequence for encoding
"UTF8": 0xe01320
HINT:  This error can also happen if the byte sequence does not match
the encoding expected by the server, which is controlled by
"client_encoding".] [pid 23965 on line 226 of
"/home/webmail/horde-webmail-1.2/lib/Horde/Cache/sql.php"]
Dec 06 21:30:08 HORDE [error] [imp] DB Error: unknown error: INSERT INTO
horde_cache (cache_id, cache_timestamp, cache_expiration, cache_data)
VALUES ('4e152dcfd584070ae5fc65c06f4654f5', 1228570208, 1231162208,
'a:21:{i:21;s:888:"O:8:"stdClass":15:{s:7ubject";s@ tesiting at 4:"from@
10:"message_id@') [nativecode=ERROR:  invalid byte sequence for encoding
"UTF8": 0xe01320
HINT:  This error can also happen if the byte sequence does not match
the encoding expected by the server, which is controlled by
"client_encoding".] [pid 23965 on line 226 of
"/home/webmail/horde-webmail-1.2/lib/Horde/Cache/sql.php"]
-------------- end ------------------------------

What am I doing wrong? Please advice.

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

P.V.Anthony



More information about the horde mailing list