General discussion on installation and configuration of SOGo

Text archives Help


[SOGo] Migrating/Merging SOGo database(s)


Chronological Thread 
  • From: "Sven Schwedas" ( ) < >
  • To:
  • Subject: [SOGo] Migrating/Merging SOGo database(s)
  • Date: Wed, 15 May 2019 11:48:37 +0200
  • Autocrypt: addr= ; prefer-encrypt=mutual; keydata= mQGNBE2DGqEBDADTslq9XMMMyx2Ibp1/pEfF1CqHiPObx8yNFksfXzTCOkzZ3jI+pp5Xht82 qtEBYwO4ovCOT8Re7GAFxk+by7Wu/4HcJjgBTK9N4XTDoj+4lEEonD/T0DkpfCGji6kncwnh Ix3P40gZ/9PPvOL05HxzYPSafmZaOlmdxkYO8tRoAd6/pzRAPav9+wvshNcFhV4jZAQ8Axjv 8sE4fP0qqrAISUyNiAev9RC4GvnaIi1rmVqC/Y1zrCzwgwIOWrn/YmA0dfdSo+vL2gvKXcTb 4ZHray9dGgWO4ag+QFYnSL8xRL6QZOC6i27imbKsUbQs9ur/G+yxVApIO4rscZlJlcQZ0JrO j0X2FmuMuwYtTCC+PlNMQFFNC1B7kRpH+9izILvPLlOA04RG3jSPICv3rt/rx4w/kaAclxSV Ea52DdHBi3VtoaQXVWd1BQ2slDB2qyP5uSCto+U7NFEBeZNFwhnh6fBsDCzZTDThsHnyWUXj yvg6QIdxTxAEDBwW+i0ANT0AEQEAAbQ1U3ZlbiBTY2h3ZWRhcyAoU2FtdWVsIENyZXNoYWwp IDxzdmVuLnNjaHdlZGFzQHRhby5hdD6JAbgEEwECACIFAk2DGqECGwMGCwkIBwMCBhUIAgkK CwQWAgMBAh4BAheAAAoJEGFKJ36biFJycKEL/2sDMzyqtdDumQ/zQ9W3eFQK3SxRMeyLo05N vF2ePhLS4+iXs+3zOoZF++epFDKtLcREvRoeRsUoWb/aGJotRmJDHB08yK1opSrpmD9cKvzP uN0qHZDIrpRv3k8Z44swq6enRBX516nH94FqDM71h6RNgcCDsKpg6HIx79tGqhPWa5iLf/23 qyaNwN8LVGFdVgT4jk7cS/zVR39+E7yrTPJSArA61Y4vPy0rVIZUhPiqrUMEEv7XiFSOdN5w qFfqj16aI6yPfvOdE5EPAwlwqsqcMMt00htx0StS0Wa/Xu6J/QEIA77x86+HvWrjwTJPyY/j kyqzpv04Vb7+Q2Mk8VBY3v3JHJ/HzpQvCW+y6+iVm8XmWzifBxcglM/70boYmHJSNU4vQWDj yt1DSKLEtDcGhVKoA/oER86vYh3eFm0R0cK+GOT3PAv+VzrWp2Fu56OAAG5oWXZuPN5rViZ3 vjQQQ67n8Pgdg6pbH4O8JD0hkjTusoOmBOX10H17jQHV9LkBjQRNgxqhAQwAvYdB3Yqv+3bL Udx7/wRsEFdii62r8TPrepeI7XNwsH/31+AAfcSxtuDM+w7DqZ2c5IO/bTL/qolVMFYtQoom 7Fl8x+jEvL2KdEQKvSgcmiryST+A+ypKO76JfZbSSVCmcBMbJIjm/ReWJuZ9rf9mLsM7QjyP GtC2Bp13awMjlKE5/V+dx4r1B109oqBhwi7FRRbw2YLZv1BSndsV2zEFn4aVNau5OagT1hMT vSFZDJ4Yt01rtUSU3q1RqqWzY1rLJ+wG8zEb/9ZIXM/W225Nl+jZoObc2ruzlM11G86+SWlw 236rX5qcIUglZrRIMST6XfdKWEM5Bfv5uleE4lwezMSSs1U1RHZkMKz3Scx2owuOCFvpca6d P5wpqudQogpWz9aPRBcbX9ZNcngF3WauKTF9iOM4aIQqXTMQJEqVXWykL+mP4vvz4T8MyisT UHyyZ609tim8O0DB2lzxz58qMDLSHGsg5ygK8uX6RjD4y1FdC4fWilrrKX4+BzqRVN6ZABEB AAGJAZ8EGAECAAkFAk2DGqECGwwACgkQYUonfpuIUnKVnAv+JTvNVLxPhhe580CrWHezNq0D MQcDhT7iY8cFlNln+2yhFwKT2VYVxLMqA61/K2ykraNqe7gyU2dN1gbSEXfV/nx3ndF27i/U MS9ljBHN8X3GpaErdOmTcY8G7droF0LCCahaFaXZQwDf3/YLUtT0OiDfXqRhoTrt3p3/SrdK 85hENKQug42Pzx4IwPNVQhf8uEzgq/d2AJhnoMxhDhEJlwc9/kBbt5jq0IiSqOenKg9SSHto OWcLS/K5eyNa64T6wlsgVGbx3X0WzTAuDss4FmstA1MBjolYLQSA5wbgeID8s41pLVGfUqc8 eFQUhKcRL1hqd4GweEdC2wJ14YBrWNhjMdww3aCyqU62Yhe9aFteeiZX2PXHcWGU/q4Nek9v HCUgx2dYRBmxN4z+oHypmU19/8fYMBtFteQobhro20ATHQo3a3R1doTMhI0js7P1txsxF9BC WlGC4WshxgRuhgOGJrv5l/4yn6KdGkqBpLTVaXH1wk44n8Nk5uBVDAxS
  • Dmarc-filter: OpenDMARC Filter v1.2.0 mail.inverse.ca DF6EB1DE5060
  • Openpgp: preference=signencrypt

Hi,

Currently, we have a SOGo setup where each branch office has their own
server, with separate databases, and users log into their respective
branch. This obviously leads to various problems (calendar subscriptions
across branches are a pain, etc.); so we want to merge it all into one
instance.

• Table names for each user are predictable and not randomized, so I can
take the user tables, the user's sogo_folder_info rows, and
sogo_user_profile row from the user's server and just merge them
together, correct?

• In sogo_folder_info, I need to update the c_*location columns to have
the correct new URIs; are any other changes needed?

• In particular, where/how are subscriptions tracked and do I need to
make any changes to make them work on the new instance?

--
Mit freundlichen Grüßen, / Best Regards,
Sven Schwedas, Systemadministrator


| ☎ +43 680 301 7167
TAO Digital | Teil der TAO Beratungs- & Management GmbH
Lendplatz 45 | FN 213999f/Klagenfurt, FB-Gericht Villach
A8020 Graz | https://www.tao-digital.at

Attachment: signature.asc
Description: OpenPGP digital signature




Archive powered by MHonArc 2.6.18.

Top of page