[horde] Dreaded "DB Error: unknown error" on IMP 4.1.2 attachments > 1MB
Robert Sink
sinkr at cbl.umces.edu
Tue Jun 27 15:57:08 PDT 2006
Hello--
I've seen a few threads on this, but most seem to have gone
unresolved or worked using something that I have tried below:
Solaris 8 SPARC
- Zend Performance Suite v2.2.1 (previously v2.1.2)
- Horde-3.1.1
- IMP-4.1.2 (previously v4.1.2)
+gcc-3.0.4 compiled (32 bit)
- Apache 2.2.2 (previously 2.2.0)
- MySQL 5.0.22
- PHP-5.1.4 (linked both w/ 4.1.x libmysqlclient & 5.0.22)
+ PHP is running as a DSO in Apache2.
php.ini settings:
- upload_max_filesize = 1073741824 (verified in IMP compose window)
- post_max_size = 1073741824
- file_uploads = On
my.cnf settings: (Horde DB is InnoDB)
- max_allowed_packet = 1024M
+ The horde MySQL user has full access privs. to the Horde
database
horde-3.1/config/conf.php settings:
$conf['sql']['persistent'] = true; // I've tried false as well.
$conf['sql']['hostspec'] = 'localhost';
$conf['sql']['username'] = 'REMOVED';
$conf['sql']['password'] = 'REMOVED';
$conf['sql']['socket'] = '/tmp/mysql.sock';
$conf['sql']['protocol'] = 'unix';
$conf['sql']['database'] = 'horde3';
$conf['sql']['charset'] = 'iso-8859-1';
$conf['sql']['phptype'] = 'mysql';
$conf['vfs']['params']['driverconfig'] = 'horde';
$conf['vfs']['type'] = 'sql';
horde-3.1/imp/config/conf.php settings:
$conf['compose']['allow_cc'] = true;
$conf['compose']['allow_bcc'] = true;
$conf['compose']['allow_receipts'] = true;
$conf['compose']['special_characters'] = true;
$conf['compose']['use_vfs'] = true;
$conf['compose']['link_all_attachments'] = false;
$conf['compose']['link_attachments_notify'] = true;
$conf['compose']['link_attachments'] = true;
Attachment submission attempted from:
Win32 Firefox 1.5.0.4
Win32 Internet Explorer 6.0.2900.2180.xpsp_sp2_gdr.050301-1519
Pertinent PEAR_LOG_DEBUG snippet:
Jun 27 16:56:19 HORDE [debug] [imp] DB Error: unknown error: INSERT INTO horde_vfs (vfs_id, vfs_type, vfs_path, vfs_name, vfs_modified, vfs_owner, vfs_data) VALUES (54, 1, '.horde/imp/compose', 'fc67a55749b56f131cb373bd2611e2f2', 1151441779, '', 'MZ~P\0^C\0\0\0^D\0\0\0ÿÿ\0\0¸\0\0\0\0\0\0\0@\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0ø\0\0\0^N^_º^N\0´ Í!¸^ALÍ!This program cannot be run in DOS mode.\r\r\n$\0\0\0\0\0\0\0ÌnÖ«~H^O¸ø~H^O¸ø~H
Pertinent mysqld.log snippet:
56 Connect horde3 at localhost on horde3
57 Connect horde3 at localhost on horde3
57 Init DB horde3
57 Query SELECT pref_scope, pref_name, pref_value FROM horde_prefs WHERE pref_uid = 'test' AND (pref_scope = 'imp' OR pref_scope = 'horde') ORDER BY pref_scope
58 Connect horde3 at localhost on horde3
58 Init DB horde3
58 Query DELETE FROM horde_tokens WHERE token_timestamp < 1151362203
58 Init DB horde3
58 Query SELECT token_id FROM horde_tokens WHERE token_address = 'MTMxLjExOC4yMjQuMjQ3' AND token_id = 'ceb17863a881c0fa37aa78562df0795b'
58 Init DB horde3
58 Query INSERT INTO horde_tokens (token_address, token_id, token_timestamp) VALUES ('MTMxLjExOC4yMjQuMjQ3', 'ceb17863a881c0fa37aa78562df0795b', 1151448603)
59 Connect horde3 at localhost on horde3
59 Init DB horde3
59 Query SELECT pref_scope, pref_name, pref_value FROM horde_prefs WHERE pref_uid = 'test' AND (pref_scope = 'gollem' OR pref_scope = 'horde') ORDER BY pref_scope
60 Connect horde3 at localhost on horde3
61 Connect horde3 at localhost on horde3
61 Init DB horde3
61 Query SELECT pref_scope, pref_name, pref_value FROM horde_prefs WHERE pref_uid = 'test' AND (pref_scope = 'imp' OR pref_scope = 'horde') ORDER BY pref_scope
62 Connect horde3 at localhost on horde3
63 Connect horde3 at localhost on horde3
63 Init DB horde3
63 Query SELECT pref_scope, pref_name, pref_value FROM horde_prefs WHERE pref_uid = 'test' AND (pref_scope = 'gollem' OR pref_scope = 'horde') ORDER BY pref_scope
64 Connect horde3 at localhost on horde3
65 Connect horde3 at localhost on horde3
65 Init DB horde3
65 Query SELECT pref_scope, pref_name, pref_value FROM horde_prefs WHERE pref_uid = 'test' AND (pref_scope = 'imp' OR pref_scope = 'horde') ORDER BY pref_scope
66 Connect horde3 at localhost on horde3
66 Init DB horde3
66 Query DELETE FROM horde_tokens WHERE token_timestamp < 1151362213
66 Init DB horde3
66 Query SELECT token_id FROM horde_tokens WHERE token_address = 'MTMxLjExOC4yMjQuMjQ3' AND token_id = '73ff15a3339e07c8306351cf30606ba1'
66 Init DB horde3
66 Query INSERT INTO horde_tokens (token_address, token_id, token_timestamp) VALUES ('MTMxLjExOC4yMjQuMjQ3', '73ff15a3339e07c8306351cf30606ba1', 1151448613)
67 Connect horde3 at localhost on horde3
67 Init DB horde3
67 Query SELECT vfs_id FROM horde_vfs WHERE vfs_path = '.horde/imp/compose' AND vfs_name = '937feb739a7ddd5f819cd1c372cb868d'
67 Init DB horde3
67 Query SELECT vfs_name, vfs_type, vfs_data, vfs_modified, vfs_owner FROM horde_vfs WHERE vfs_path = '.horde/imp'
67 Init DB horde3
67 Query UPDATE horde_vfs_seq SET id = LAST_INSERT_ID(id + 1)
67 Init DB horde3
68 Connect horde3 at localhost on horde3
68 Init DB horde3
68 Query SELECT pref_scope, pref_name, pref_value FROM horde_prefs WHERE pref_uid = 'test' AND (pref_scope = 'gollem' OR pref_scope = 'horde') ORDER BY pref_scope
69 Connect horde3 at localhost on horde3
70 Connect horde3 at localhost on horde3
70 Init DB horde3
70 Query SELECT pref_scope, pref_name, pref_value FROM horde_prefs WHERE pref_uid = 'test' AND (pref_scope = 'imp' OR pref_scope = 'horde') ORDER BY pref_scope
71 Connect horde3 at localhost on horde3
72 Connect horde3 at localhost on horde3
72 Init DB horde3
72 Query SELECT pref_scope, pref_name, pref_value FROM horde_prefs WHERE pref_uid = 'test' AND (pref_scope = 'gollem' OR pref_scope = 'horde') ORDER BY pref_scope
I've tried just about everything I can think of and keep running up
against the same result "DB error..." It's important to note that I
get the same error inside of Gollem when trying to save files to the
same MySQL-backed store.
I've emptied the horde_vfs and horde_vfs_seq tables, dropped and re-added
them as well.
I've tried different user accounts....
So, if anyone has any suggestions above and beyond what I've done, I'd
appreciate it, because save an epiphany, I have no idea...
More information about the horde
mailing list