Tickets :: Comment on [#9467] horde_vfs with splitread MySQL

* Your Email Address
* Spam protection	Enter the letters below: \ /.__ .__..__ . . >< \| \\| \|\| \\|\/\| / \\|__/\|__\\|__/\| \|
Comment	> 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. >
Attachment
Watch this ticket

Saved Queries