RT @campainl: Another successful #Zarafa Administrator training given by @campainl at Dutch municipality Edam-Volendam! @zarafagroupware
The Best Open Source Email & Collaboration Software
To upgrade a single company to a multicompany environment where all existing users are placed into the same company, the following actions must be taken:
Make a backup of the Zarafa database. Enable multicompany in the Zarafa configuration files. Restart the Zarafa server. Create a new company, using LDAP or the zarafa-admin tool.
Use zarafa-admin --list-companies to make sure the new company is visible in the new environment. Stop the Zarafa server.
Note: The following 3 queries are only needed when the server has version 6.1x or 6.2x.
Execute the following SQL queries in the Zarafa database:
UPDATE users SET company = (SELECT id FROM users WHERE object_type=4)
WHERE (object_type = 1 OR object_type = 2 OR object_type = 5) AND id > 2;
UPDATE stores SET company = (SELECT id FROM users WHERE object_type=4)
WHERE user_id > 2;
UPDATE stores SET user_id = (SELECT id FROM users WHERE object_type=4) ,
user_name = (SELECT externid FROM users WHERE object_type=4) WHERE user_id = 1;
Note: The following query needs to be executed for every multicompany version (6.1x and up).
When using the DB plugin, the following query is also required:
SELECT p.value FROM object AS o JOIN objectproperty AS p ON o.id=p.objectid
WHERE o.objecttype = 4 AND p.propname='companyname'
INSERT INTO objectproperty (objectid, propname, `value`) SELECT id,
'companyid', (SELECT p.value FROM object AS o JOIN objectproperty AS p ON
o.id=p.objectid WHERE o.objecttype = 4 AND p.propname='companyname') FROM
object WHERE objecttype != 4;
After this the Zarafa server can be started again, and the users should be, once again, visible with: