Hello I am in the process of upgrading from Horde 2.2.9/IMP 3.2.8/Turba 1.2.2 to Webmail Groupware Edition (1.0.1) and would like make some corrections to the documents and give some tips...
So you've installed Webmail Groupware Edition on a 'test' server and got it working and now would like to transfer the Address Book and user Preferences database for the new server... In 'horde/turba/scripts/upgrades' the 1.2_to_2.0.sql script is missing two object columns, object_members and object_type, the script should now be this: ALTER TABLE turba_objects ADD COLUMN object_uid VARCHAR(255); ALTER TABLE turba_objects ADD COLUMN object_freebusyurl VARCHAR(255); ALTER TABLE turba_objects ADD COLUMN object_smimepublickey TEXT; ALTER TABLE turba_objects ADD COLUMN object_pgppublickey TEXT; ALTER TABLE turba_objects ADD COLUMN object_members LONGTEXT; ALTER TABLE turba_objects ADD COLUMN object_type VARCHAR(255); I use MySQL and am moving to a new database so, I need to do a dump of the turba address book database: oldserver: mysqldump -u horde -p horde turba_objects > /var/tmp/turba.exp Enter password: which produces the export file: -- MySQL dump 8.21 -- -- Host: localhost Database: horde --------------------------------------------------------- -- Server version 3.23.49-log -- -- Table structure for table 'turba_objects' -- CREATE TABLE turba_objects ( object_id varchar(32) NOT NULL default '', owner_id varchar(255) NOT NULL default '', object_name varchar(255) default NULL, object_alias varchar(32) default NULL, object_email varchar(255) default NULL, object_homeAddress varchar(255) default NULL, object_workAddress varchar(255) default NULL, object_homePhone varchar(25) default NULL, object_workPhone varchar(25) default NULL, object_cellPhone varchar(25) default NULL, object_fax varchar(25) default NULL, object_title varchar(32) default NULL, object_company varchar(32) default NULL, object_notes text, PRIMARY KEY (object_id) ) TYPE=MyISAM; etc... [data follows] Then in the new HORDE database create and import this turba_objects table (by dropping the one that is already there if there is one) and then upgrade it with the ALTER scripts above (which extends the table with the new columns). newserver: mysql -u horde -p horde < /var/tmp/turba.exp Enter password: newserver: webmysql# mysql -u horde -p horde < /var/tmp/new.1.2_to_2.0.sql Enter password: This is the Address Book done. Next the user preferences. I found that the preferences messes a few things once imported into the new Webmail. This might not be an issue to you but you might want to take note. The preferences transfer is done in the same way, with an export and import... oldserver: mysqldump -u horde -p horde horde_prefs > /var/tmp/prefs.exp Enter password: newserver: mysql -u horde -p horde < /var/tmp/prefs.exp Enter password: So for me the 'last login' message always says 'never' once I perform the preferences transfer, so I need to delete all 'last login' entries from this table: newserver: mysql -u horde -p horde Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 161 to server version: 5.0.27 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> delete from horde_prefs where pref_name = 'last_login'; Query OK, 21664 rows affected (3.70 sec) mysql> Sorry that this message is a little long but I hope it helps. Let me know if any of this is wrong... Regards, Son Truong -- Son V Truong * Unix System Programmer * Systems Group LIS: IT Services * University of St Andrews 01334 462373 * [EMAIL PROTECTED] Sent from Son's Work PC! -- IMP mailing list - Join the hunt: http://horde.org/bounties/#imp Frequently Asked Questions: http://horde.org/faq/ To unsubscribe, mail: [EMAIL PROTECTED]
