[horde] MySQL and Horde Prefs...

Michael J. Pelletier mjpelletier at mjpelletier.com
Sun Dec 14 15:34:20 PST 2003


Hello,

When I set the preferences from "session" to "mysql" I get a white screen
with nothing in it. I have completly re-complied and re-installed MySQL
without better results. Here is my config:

Horde: HEAD
IMP: HEAD
PHP: 4.3.4
MySQL: 4.0.16
Here is the snippet from horde/config/conf.php

 ** Horde Database Settings
 **/

// If Horde uses a database, which database backend are we using? If
// you are not using a database for anything, you can ignore this
// entire section.
// Backends:
//   'mssql'  --  Microsoft SQL Server
//   'mysql'  --  MySQL
//   'oci8'   --  Oracle 8
//   'odbc'   --  ODBC
//   'pgsql'  --  PostgreSQL
$conf['sql']['phptype'] = 'mysql';

// Request persistent connections?
$conf['sql']['persistent'] = false;

// What protocol will we use to connect to the database.  The default
// is tcp, but if you wish to use UNIX sockets, change it to 'unix'.
$conf['sql']['protocol'] = 'tcp';

// If you are using UNIX sockets, you may need to specify the socket's
// location.
$conf['sql']['socket'] = '/usr/local/Servers/MySQL/misc/mysql.socket';

// What port is the database server running on? Not required for all
// databases.
$conf['sql']['port'] = 3306;

// What hostname is the database server running on, or what is the
// name of the system DSN to use?
$conf['sql']['hostspec'] = 'localhost';

// What username do we authenticate to the database server as?
$conf['sql']['username'] = 'horde';

// What password do we authenticate to the database server with?
$conf['sql']['password'] = '******';

// What database name/tablespace are we using?
$conf['sql']['database'] = 'horde';

// What charset does the database use internally?
$conf['sql']['charset'] = 'iso-8859-1';



// What preferences driver should we use?
// Drivers:
//   'none'     --  None. (Use system defaults and don't save any user
//                  preferences)
//   'ldap'     --  LDAP
//   'session'  --  PHP Sessions. (Preferences only persist during the
login)
//   'sql'      --  SQL Database
$conf['prefs']['driver'] = 'mysql';

// The size of the preferences field in your backend in bytes. Horde will
// reject any write to the preferences backend if its length exceeds this
// value. Leave null to skip this checking.
// e.g. MySQL stores the preference data in a LONGTEXT field. This field
// can hold 4294967295 bytes so most likely checking is not needed. However
// other DB installations may only have a storage size of 64 KB (65535
// bytes). These installations would want to turn checking on.
$conf['prefs']['maxsize'] = null;

// Any parameters that the preferences driver needs. For the list of
// required parameters needed for each driver, see
// horde/lib/Prefs/[drivername].php.
// $conf['prefs']['params'] = array();

Any thoughts?

Michael




More information about the horde mailing list