We've added Zarafa Server Management API code to @github. Find out how to connect other services to ZCP http://t.co/Aq6cWCCc9N
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:
Zarafa, the leading European provider of open source groupware and collaboration software, is pleased to announce its eighth presence at the CeBIT. The world's largest trade fair, showcasing digital IT and telecommunications solutions, will take place in Hanover, Germany from March 5-9, 2013.