Re: [SOGo] Moving a SOGo installation to another server?
And, the "restore" commands completed successfully! HOWEVER, looking at the web interface, I don't see the calendar entries, although I saw them restored Both "vcf" and "ics" entries were restored (which I presume are "address book" and "calendar" entries) I'm suspecting I may have to reset the sharing of the calendar before I "see" it, but I believe it's restored. I'll work on that. On 12/28/2014 05:47 PM, Ludovic Marcotte wrote: On 28/12/2014 17:43, stev...@cinergymetro.net wrote: Am I to create such a table in MySQL by the name, "sogo_folder_info?" The first time you start SOGo, it'll create it. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Moving a SOGo installation to another server?
'sogo' is running (and has been) HOWEVER, reviewing '/var/log/sogo/sogo.log1,' I believe I see the problem. Initially, I had a difficulty creating 'sogo'@'localhost' in MySQL but 'sogo' created successfully. That meant I was left with TWO users in MySQL both having access to SOGo, and 'sogo'@'localhost' took preference. I found that it was clashing with 'sogo'@'localhost' and I could not grant ALL privileges, so dropped it. In '/var/log/sogo/sogo.log.1,' I found the error . . . 2014-12-23 15:34:27.349 sogod[1839] ERROR: could not open MySQL4 connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using password: YES) And, it occurred to me that I had not restarted all services after dropping 'sogo'@'localhost' in MySQL After a quick reboot, I found the following in '/var/log/sogo/sogo.log' (NOT sogo.log1) Dec 28 18:18:11 sogod [2035]: |SOGo| table 'sogo_user_profile' successfully created! Dec 28 18:18:12 sogod [2035]: <0x0x7f9858b33358[GCSSessionsFolder]> sessions folder table 'sogo_sessions_folder' successfully created! Dec 28 18:18:12 sogod [2034]: |SOGo| table 'sogo_folder_info' successfully created! So, I am convinced at this point that user 'sogo' is now opening the channel with MySQL I should now be able to do 'sogo-tool restore -f ALL output-directory username' . . . HOWEVER, I still find an error when logging into the web interface . . . 2014-12-28 18:20:36.850 sogod[2034] Note: Using UTF-8 as URL encoding in NGExtensions. 192.168.121.179 - - [28/Dec/2014:18:20:36 GMT] "POST /SOGo/connect HTTP/1.1" 200 27/45 0.339 - - 1M 192.168.121.179 - - [28/Dec/2014:18:20:36 GMT] "GET /SOGo/steve HTTP/1.1" 302 0/0 0.007 - - 16K 192.168.121.179 - - [28/Dec/2014:18:20:37 GMT] "GET /SOGo/steve/view HTTP/1.1" 302 0/0 0.028 - - 0 192.168.121.179 - - [28/Dec/2014:18:20:37 GMT] "GET /SOGo/so/steve/Mail HTTP/1.1" 302 0/0 0.006 - - 0 2014-12-28 18:20:37.317 sogod[2034] WARNING: IMAP4 connection pooling is disabled! Dec 28 18:20:37 sogod [2034]: [ERROR] <0x0x7f9859332958[NGImap4ConnectionManager]> IMAP4 login failed: *IMAP4 connection pooling is disabled* and *IMAP4 login failed* I'll need to review my IMAP settings (Postfix, Dovecot -- Dovecot appears to be connecting/creating) All of this is prelude to syncing the IMAP folders of my "old" server with the "new" Thanks, Ludovic for the quick response, and thanks for prompting me to think! On 12/28/2014 05:47 PM, Ludovic Marcotte wrote: On 28/12/2014 17:43, stev...@cinergymetro.net wrote: Am I to create such a table in MySQL by the name, "sogo_folder_info?" The first time you start SOGo, it'll create it. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Moving a SOGo installation to another server?
On 28/12/2014 17:43, stev...@cinergymetro.net wrote: Am I to create such a table in MySQL by the name, "sogo_folder_info?" The first time you start SOGo, it'll create it. -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: http://inverse.ca Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence (http://packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: Re: [SOGo] Moving a SOGo installation to another server?
In the Installation Guide, pg 33, there's discussion of an SQL view/ table . . . Certain database columns must be present in the view/table, such as: ▪ c_uid – will be used for authentication – it’s the username or usern...@domain.tld ▪ c_name – which can be identical to c_uid – will be used to uniquely identify entries ▪ c_password – password of the user, plain-text, md5 or sha encoded for now ▪ c_cn – the user’s common name – such as "John Doe" ▪ mail – the user’s mail address Am I to create such a table in MySQL by the name, "sogo_folder_info?" Or, is there another template to follow for MySQL or another way to create "sogo_folder_info?" -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Moving a SOGo installation to another server?
I used the backup/restore instructions in the FAQ http://www.sogo.nu/english/nc/support/faq/article/how-can-i-backuprestore-my-user-data.html Here's the output of 'sogo-tool restore -l' for one user . . . root@sogo:~# sogo-tool restore -l output-directory/ steve <0x0x2661448[SOGoCache]> Cache cleanup interval set every 300.00 seconds <0x0x2661448[SOGoCache]> Using host(s) '127.0.0.1' as server(s) 2014-12-27 18:39:45.955 sogo-tool[14906] Restorable folders: 2014-12-27 18:39:45.958 sogo-tool[14906] Calendar/personal (Personal Calendar) 2014-12-27 18:39:45.958 sogo-tool[14906] Contacts/collected (Collected Address Book) 2014-12-27 18:39:45.958 sogo-tool[14906] Contacts/personal (Personal Address Book) Here's the output of 'sogo-tool -f ALL' for one user (truncated) . . . root@sogo:~# sogo-tool restore -f ALL output-directory/ steve <0x0x205f508[SOGoCache]> Cache cleanup interval set every 300.00 seconds <0x0x205f508[SOGoCache]> Using host(s) '127.0.0.1' as server(s) <0x0x1f802a8[GCSFolderManager]> ERROR(-[GCSFolderManager performSQL:]): cannot execute SQL 'SELECT c_folder_id, c_path, c_location, c_quick_location, c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'steve' AND c_path3 = 'Contacts' AND c_path4 = 'personal'': NAME:ExecutionFailed REASON:*Table 'sogo.sogo_folder_info' doesn't exist* I've created user 'sogo' and the 'sogo' database, and I've granted ALL However, I've not created any tables in the 'sogo' database. Question: *How can I properly create the 'sogo.sogo_folder_info' table?* Thanks. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Moving a SOGo installation to another server?
thx On 12/23/2014 09:12 PM, Ludovic Marcotte wrote: On 23/12/2014 21:04, Steve Ankeny wrote: *Question*: How do I export mail from cyrus mailboxes then import it into dovecot? Thx Use imapsync - http://imapsync.lamiral.info/ -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 ::http://inverse.ca Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence (http://packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Moving a SOGo installation to another server?
On 23/12/2014 21:04, Steve Ankeny wrote: *Question*: How do I export mail from cyrus mailboxes then import it into dovecot? Thx Use imapsync - http://imapsync.lamiral.info/ -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: http://inverse.ca Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence (http://packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Moving a SOGo installation to another server?
I just realized IF I am reading this correctly, this will backup user preferences ONLY (i.e., user details and preferences, mail filter rules, addressbook entries, SOGo calendar, etc.) but NOT mailboxes! I am ready to transfer my data from my "old" server to my "new', however, the "old" server has mail in cyrus mailboxes, and the "new" server is using dovecot, and, I do not know how to transfer the actual mailboxes. *Question*: How do I export mail from cyrus mailboxes then import it into dovecot? Thx The "old" server user ldap for user source information. I am not using ldap in my "new" server. I have created samba, openchange users on my "new" server with empty mailboxes, and I have performed the backup discussed below and transferred it (though not restored it or imported it into the "new" server) I need now to know how to transfer (export/import) the mailboxes. Thanks, again. On 12/17/2014 08:22 AM, Christian Mack wrote: Hello Michael Vogel Am 2014-12-17 um 08:01 schrieb Michael Vogel: I want to move my SOGo installation to another server (with a different MySql-, IMAP- and SMTP-server) Of course I want to keep the calendar and addressbook entries, as well as the mail filter rules. How can I do that? 1) make a backup on the old server with BACKUPDIR="./backup" sogo-tool backup ${BACKUPDIR} ALL 2) shutdown old server 3) move the backup to your new server 4) startup new server 5) restore all data BACKUPDIR="./backup" for USER in `ls ${BACKUPDIR}/*` do sogo-tool restore -p ${BACKUPDIR} `basename ${USER}` sogo-tool restore -f ALL ${BACKUPDIR} `basename ${USER}` done Kind regards, Christian Mack -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Moving a SOGo installation to another server?
great, Christian . . . I'm moving from openldap to mysql/Samba I had thought I'd create users in Samba (Samba has a mysql db) there's only a few, so it's not too difficult to do it manually, and other than address books, calendars and mail, there's very little to transfer really only one office calendar and 6-8 users with mailboxes, so not too difficult to duplicate we're moving from Ubuntu 12.04.1 to 14.04.1 and replacing openldap with Samba domain On 12/17/2014 11:08 AM, Christian Mack wrote: Hello Steve Ankeny This will move all data related to SOGo settings, calendars and address books. Your user source information and postbox/IMAP content is not included. How you transport that, depends on the kind of source you use. LDAP: 1) stop openldap on old server 2) export with slapcat -n 0 -l ldapConfig.ldif slapcat -n 1 -l userBackup.ldif 3) move these 2 files to the new server 4) import them on the new serverwith slapadd -n 0 -l ldapConfig.ldif slapadd -n 1 -l userBackup.ldif 5) start openldap on new server Mysql: 1) get a dump with mysqldump --opt ${USER_DATABASE} > userBackup.sql 2) Move this to the new server 3) import it with mysql < userBackup.sql Also don't forget to move your sogo.conf to the new server;-) (And change your settings for MySQL, IMAP and SMTP according to your new setup.) Kind regards, Christian Mack -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Moving a SOGo installation to another server?
Hello Steve Ankeny This will move all data related to SOGo settings, calendars and address books. Your user source information and postbox/IMAP content is not included. How you transport that, depends on the kind of source you use. LDAP: 1) stop openldap on old server 2) export with slapcat -n 0 -l ldapConfig.ldif slapcat -n 1 -l userBackup.ldif 3) move these 2 files to the new server 4) import them on the new serverwith slapadd -n 0 -l ldapConfig.ldif slapadd -n 1 -l userBackup.ldif 5) start openldap on new server Mysql: 1) get a dump with mysqldump --opt ${USER_DATABASE} > userBackup.sql 2) Move this to the new server 3) import it with mysql < userBackup.sql Also don't forget to move your sogo.conf to the new server ;-) (And change your settings for MySQL, IMAP and SMTP according to your new setup.) Kind regards, Christian Mack Am 2014-12-17 um 14:34 schrieb Steve Ankeny: > > I knew you'd give a good answer! > > Should we create users on the new server first or will the restore do > that for us? > > On 12/17/2014 08:22 AM, Christian Mack wrote: >> Hello Michael Vogel >> >> Am 2014-12-17 um 08:01 schrieb Michael Vogel: >>> I want to move my SOGo installation to another server (with a different >>> MySql-, IMAP- and SMTP-server) >>> >>> Of course I want to keep the calendar and addressbook entries, as well >>> as the mail filter rules. >>> >>> How can I do that? >> >> 1) make a backup on the old server with >> BACKUPDIR="./backup" >> sogo-tool backup ${BACKUPDIR} ALL >> 2) shutdown old server >> 3) move the backup to your new server >> 4) startup new server >> 5) restore all data >> BACKUPDIR="./backup" >> for USER in `ls ${BACKUPDIR}/*` >> do >> sogo-tool restore -p ${BACKUPDIR} `basename ${USER}` >> sogo-tool restore -f ALL ${BACKUPDIR} `basename ${USER}` >> done >> >> >> Kind regards, >> Christian Mack >> > -- Christian Mack Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung Basisdienste 78457 Konstanz +49 7531 88-4416 smime.p7s Description: S/MIME Cryptographic Signature
Re: [SOGo] Moving a SOGo installation to another server?
alright, thx On 12/17/2014 10:23 AM, Igor Vitorac wrote: If you are using users from MySQL on the same server, then you need to handle that separately. Process explained by Christian Mack transfers only calendar and calendar entries! Following is assumed for the new server: - install clean SOGo and prepare same (or similar) sogo config. - prepare user source, if using MySQL as user source on the new server - ensure that SOGo is working by creating one user and login into SOGo After that you can proceed with the import. Regards, Igor Steve Ankeny wrote on 17/12/2014 14:34: thx, Christian . . . I knew you'd give a good answer! Should we create users on the new server first or will the restore do that for us? -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Moving a SOGo installation to another server?
If you are using users from MySQL on the same server, then you need to handle that separately. Process explained by Christian Mack transfers only calendar and calendar entries! Following is assumed for the new server: - install clean SOGo and prepare same (or similar) sogo config. - prepare user source, if using MySQL as user source on the new server - ensure that SOGo is working by creating one user and login into SOGo After that you can proceed with the import. Regards, Igor Steve Ankeny wrote on 17/12/2014 14:34: thx, Christian . . . I knew you'd give a good answer! Should we create users on the new server first or will the restore do that for us? On 12/17/2014 08:22 AM, Christian Mack wrote: Hello Michael Vogel Am 2014-12-17 um 08:01 schrieb Michael Vogel: I want to move my SOGo installation to another server (with a different MySql-, IMAP- and SMTP-server) Of course I want to keep the calendar and addressbook entries, as well as the mail filter rules. How can I do that? 1) make a backup on the old server with BACKUPDIR="./backup" sogo-tool backup ${BACKUPDIR} ALL 2) shutdown old server 3) move the backup to your new server 4) startup new server 5) restore all data BACKUPDIR="./backup" for USER in `ls ${BACKUPDIR}/*` do sogo-tool restore -p ${BACKUPDIR} `basename ${USER}` sogo-tool restore -f ALL ${BACKUPDIR} `basename ${USER}` done Kind regards, Christian Mack -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Moving a SOGo installation to another server?
thx, Christian . . . I knew you'd give a good answer! Should we create users on the new server first or will the restore do that for us? On 12/17/2014 08:22 AM, Christian Mack wrote: Hello Michael Vogel Am 2014-12-17 um 08:01 schrieb Michael Vogel: I want to move my SOGo installation to another server (with a different MySql-, IMAP- and SMTP-server) Of course I want to keep the calendar and addressbook entries, as well as the mail filter rules. How can I do that? 1) make a backup on the old server with BACKUPDIR="./backup" sogo-tool backup ${BACKUPDIR} ALL 2) shutdown old server 3) move the backup to your new server 4) startup new server 5) restore all data BACKUPDIR="./backup" for USER in `ls ${BACKUPDIR}/*` do sogo-tool restore -p ${BACKUPDIR} `basename ${USER}` sogo-tool restore -f ALL ${BACKUPDIR} `basename ${USER}` done Kind regards, Christian Mack -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Moving a SOGo installation to another server?
Hello Michael Vogel Am 2014-12-17 um 08:01 schrieb Michael Vogel: > > I want to move my SOGo installation to another server (with a different > MySql-, IMAP- and SMTP-server) > > Of course I want to keep the calendar and addressbook entries, as well > as the mail filter rules. > > How can I do that? 1) make a backup on the old server with BACKUPDIR="./backup" sogo-tool backup ${BACKUPDIR} ALL 2) shutdown old server 3) move the backup to your new server 4) startup new server 5) restore all data BACKUPDIR="./backup" for USER in `ls ${BACKUPDIR}/*` do sogo-tool restore -p ${BACKUPDIR} `basename ${USER}` sogo-tool restore -f ALL ${BACKUPDIR} `basename ${USER}` done Kind regards, Christian Mack -- Christian Mack Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung Basisdienste 78457 Konstanz +49 7531 88-4416 smime.p7s Description: S/MIME Cryptographic Signature
[SOGo] Moving a SOGo installation to another server?
Hi! I want to move my SOGo installation to another server (with a different MySql-, IMAP- and SMTP-server) Of course I want to keep the calendar and addressbook entries, as well as the mail filter rules. How can I do that? Thanks! Michael -- users@sogo.nu https://inverse.ca/sogo/lists