[horde] Can't log in to IMP Horde 5.0.4...

[Michael M Slusarz]

Quoting Michael Robinson <plug_1 at robinson-west.com>:

> I'm getting thrown back to the imp login screen.  An error that the mail
> server cannot be connected to is popping up.  I've tried pine on the
> server and connected to the dovecot 2 server no problem.  The frontend
> system with the web server is CentOS 6.x where the backend running the
> database is running Slackware 13.37.  The test.php script connects to
> dovecot no problem.  I think this is a database problem, but I'm not
> sure how to troubleshoot that.  Let me know if this information is not
> helpful or if more information is needed.  Thank you.
>
> Postgresql 8.4.13 error:

Try using a different backend for Horde_Cache (FWIW, a SQL database is  
not a good choice for a Horde_Cache backend).

> Apr 19 01:08:16 xerxes HORDE: [horde] SQL QUERY FAILED: SQLSTATE[22021]:
> Character not in repertoire: 7 ERROR:  invalid byte sequence for
> encoding "UTF8": 0x80#012HINT:  This error can also happen if the byte
> sequence does not match the encoding expected by the server, which is
> controlled by "client_encoding".  #012#011INSERT INTO horde_cache
> (cache_id, cache_timestamp, cache_expiration,#012#011  cache_data)
> VALUES ('296dac3fbcc72dff4fd030cf1acbcba3', 1366358895,#012#011
> 1366963695, '#037C:18:"Horde_Themes_Cache":31799:#016{a:5:{s:1:"a";s
> #001"h@,@#013#012#011  #023#005c";b:1 #027 #013#007d";a:832 at .
> 7:"ie8.css";i<80> #0259:"sounds/reminder.wav<E0> ') [pid 13423 on line
> 815 of "/usr/share/pear/Horde/Db/Adapter/Base.php"]

Are you sure you have updated the schema for horde_cache?  cache_data  
is a 'binary' field and, as such, there should be no charset checking.  
  You're not using a database from an older version of Horde, are you?

michael

___________________________________
Michael Slusarz [slusarz at horde.org]