[horde] remote mysql db for prefs

Michael J Barber mbarber at barbersweb.net
Thu Mar 4 09:35:07 PST 2004

  I am using the latest versions (downloaded 2 days ago) of horde/imp (best to
get the basics working first).  I have the setup running and I can get into my
mail and such.  However, I get an error:

A fatal error has occurred:

DB Error: connect failed

[line 108 of /var/www/mail_myinetmail_net/html/horde/lib/Prefs/sql.php]

Details have been logged for the administrator.

This is the settings I have made in horde.php in the config directory.

 ** Preference System Settings

// What preferences driver should we use? Valid values are 'none'
// (meaning use system defaults and don't save any user preferences),
// 'session' (preferences only persist during the login), 'ldap',
// and 'sql'.
$conf['prefs']['driver'] = 'sql';

// Any parameters that the preferences driver needs. This includes
// database or ldap server, username/password to connect with, etc. 
// $conf['prefs']['params'] = array();

// This is an example configuration for a MySQL preference backend.
// The SQL script to setup the preference database is placed in
// horde/scripts/db/prefs.sql.
$conf['prefs']['params']['phptype'] = 'mysql';
$conf['prefs']['params']['hostspec'] = '';
$conf['prefs']['params']['port'] = '3306';
$conf['prefs']['params']['username'] = '*****';
$conf['prefs']['params']['password'] = '*****';
$conf['prefs']['params']['database'] = 'horde';
$conf['prefs']['params']['table'] = 'horde_prefs';

I currently have the entire setup running on the remote box.. so I know it works
.  I really just wanted to move horde/imp to a dedicated webserver and let the
other machine do the mail and database work.

Michael J Barber
SUNY Plattsburgh
CMS Computer Labs Technician
116D Feinberg Library
Plattsburgh, NY 12901
This site run by Horde      http://www.horde.org
                 Apache     http://httpd.apache.org
                 PHP        http://www.php.net
                 PostgreSQL http://www.postgresql.org
                 MySQL      http://www.mysql.com
                 Postfix    http://www.postfix.org
                 Cyrus-Imap http://asg.web.cmu.edu/
and of course
        GNU Linux by RedHat http://www.redhat.com

More information about the horde mailing list