[Tickets #9467] horde_vfs with splitread MySQL

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/9467
------------------------------------------------------------------------------
  Ticket             | 9467
  Created By         | roderburg at uni-koeln.de
  Summary            | horde_vfs with splitread MySQL
  Queue              | Horde Groupware Webmail Edition
  Version            | 1.2.6
  Type               | Bug
  State              | Unconfirmed
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


roderburg at uni-koeln.de (2010-12-23 06:40) wrote:

We have activated the MySQL splitread feature in our Horde installation.

Relevant config parameters:

$conf['sql']['persistent'] = true;
$conf['sql']['username'] = 'horde';
$conf['sql']['password'] = '*******';
$conf['sql']['hostspec'] = 'mysqlgold.rrz.uni-koeln.de';
$conf['sql']['port'] = 3306;
$conf['sql']['protocol'] = 'tcp';
$conf['sql']['database'] = 'horde3';
$conf['sql']['charset'] = 'utf-8';
$conf['sql']['ssl'] = false;
$conf['sql']['read']['persistent'] = true;
$conf['sql']['read']['username'] = 'horde';
$conf['sql']['read']['password'] = '*******';
$conf['sql']['read']['hostspec'] = 'modulok.rrz.uni-koeln.de';
$conf['sql']['read']['port'] = 3306;
$conf['sql']['read']['protocol'] = 'tcp';
$conf['sql']['read']['database'] = 'horde3';
$conf['sql']['read']['charset'] = 'utf-8';
$conf['sql']['splitread'] = true;
$conf['sql']['phptype'] = 'mysql';

mysqlgold is the MySQL master, modulok the read-only MySql Slave.

$conf['prefs']['driver'] = 'sql';
$conf['alarms']['driver'] = 'sql';
$conf['datatree']['driver'] = 'sql';
$conf['group']['driver'] = 'sql';
$conf['perms']['driver'] = 'sql';
$conf['share']['driver'] = 'sql';
$conf['lock']['driver'] = 'sql';
$conf['token']['driver'] = 'sql';

All of these work as expected.

$conf['vfs']['type'] = 'sql';
$conf['vfs']['params']['driverconfig'] = 'horde';

The vfs system, however, has problems.
When it tries to write something into the DB, we get error messages  
like this in the imp log and the user gets a "DB Error: unknown error"

Dec 22 14:52:55 HORDE [error] [imp] DB Error: unknown error: INSERT  
INTO horde_vfs (vfs_id, vfs_type, vf _path, vfs_name, vfs_modified,  
vfs_owner) VALUES (1096, 2, '.horde/imp/attachments', 'nzaremeh',  
1293025 75, '') [nativecode=1290 ** The MySQL server is running with  
the --read-only option so it cannot execute this statement] [pid 1310  
on line 2678 of  
"/var/local/ukweb/webmail/docs/horde-3.3/imp/lib/Compose.php"]

which seem to indicate that the correct writeable MySQL host is not used.

Main place where this happens when "linked attachments" are used.