View Issue Details

IDProjectCategoryView StatusLast Update
0003782SOGoWeb Address Bookpublic2016-12-29 17:54
Reporterjuanpablopwr Assigned Toludovic  
PrioritynormalSeverityminorReproducibilityhave not tried
Status closedResolutionno change required 
Product Version3.1.4 
Summary0003782: Backup and Restore not working?
Description

Hello! I am having a problem with the sogo-tool, command to make a backup of all my users fails for users that no longer exist

sogo-tool backup /Disk2/SOGobckp ALL
<0x0x2620d60[SOGoCache]> Cache cleanup interval set every 300.000000 seconds
<0x0x2620d60[SOGoCache]> Using host(s) '127.0.0.1' as server(s)
2016-07-26 15:24:19.553 sogo-tool[13667] user 'arovera@pamar.com.ar' unknown
2016-07-26 15:24:19.557 sogo-tool[13667] user 'diegoperl@pistasargentinas.com' unknown
2016-07-26 15:24:19.564 sogo-tool[13667] user 'jzalazar@pamar.com.ar' unknown
2016-07-26 15:24:19.568 sogo-tool[13667] user 'mng@integraba.com.ar' unknown
2016-07-26 15:24:19.571 sogo-tool[13667] user 'pablokotodij@pistasargentinas.com' unknown
2016-07-26 15:24:19.571 sogo-tool[13667] user 'postmaster@grupovcl.com' unknown
2016-07-26 15:24:19.574 sogo-tool[13667] user 'sergiocordoba@pistasargentinas.com' unknown

and when I want to do a restore the address book of a user gives the following error:

sogo-tool restore -f mycontacts /Disk2/SOGobckp noc@grupovcl.com
<0x0x1b0b4d0[SOGoCache]> Cache cleanup interval set every 300.000000 seconds
<0x0x1b0b4d0[SOGoCache]> Using host(s) '127.0.0.1' as server(s)
2016-07-26 15:27:58.897 sogo-tool[14352] no user table '/Users/noc@grupovcl.com/mycontacts' found

TagsNo tags attached.

Activities

ludovic

ludovic

2016-08-04 14:33

administrator   ~0010565

Show your sogo.conf file

juanpablopwr

juanpablopwr

2016-08-04 16:14

reporter   ~0010566

{
//
// - Official SOGo document: http://sogo.nu/support/index.html#/documentation
// - Mailing list: http://sogo.nu/support/index.html#/community
//

// Daemon address and port
WOPort = 127.0.0.1:20000;

// PID file
//WOPidFile = /var/run/sogo/sogo.pid;

// Log file
//WOLogFile = /var/log/sogo/sogo.log;

// Enable verbose logging. Reference:
// http://www.sogo.nu/nc/support/faq/article/how-to-enable-more-verbose-logging-in-sogo.html
//SOGoDebugRequests = YES;
//SOGoEASDebugEnabled = YES;
//ImapDebugEnabled = YES;
//LDAPDebugEnabled = YES;
//MySQL4DebugEnabled = YES;
//PGDebugEnabled = YES;

// set the maximum allowed size for content being sent to SOGo, this can
// also limit the file attachment size being uploaded to SOGo when
// composing a mail. Default is 0 or disabled (unlimit).
// The value is in kilobyte.
//WOMaxUploadSize = 0;

// Define the URL to online help for SOGo. When set, an additional icon
// will appear near the logout button in SOGo's web interface. The URL
// will always be open in a blank target.
//SOGoHelpURL = '';

// Performance Tuning
//
// The amount of instances of SOGo that will be spawned to handle multiple
// requests simultaneously. When started from the init script, that amount
// is overriden by the `PREFORK=` setting in /etc/sysconfig/sogo or
// /etc/default/sogo. A value of 3 is a reasonable default for low usage.
// The maximum value depends on the CPU and IO power provided by your
// machine: a value set too high will actually decrease performances under
// high load.
//
// You should have at least one child per EAS device configured to use
// &quot;push&quot;. You must also have more children than you have EAS devices
// configured to use &quot;push&quot; - in order to handle normal SOGo requests to
// its Web or DAV interfaces.
//
// Defaults to 1 when unset, increase it if you see below error message in
// sogo log file: 'No child available to handle incoming request'
//
// WARNING:
//      - on RHEL/CentOS, this setting is controlled by parameter
//        'PREFORK=' defined in /etc/default/sogo.
//      - on Debian/Ubuntu, this setting is controlled by parameter
//        'PREFORK=' defined in /etc/default/sogo.
WOWorkersCount = 10;

// Parameter used to set the maximum amount of time, in seconds, SOGo will
// wait before replying to a Ping command.
// If not set, it defaults to 10 seconds.
SOGoMaximumPingInterval = 3540;

// Parameter used to set the maximum amount of time, in seconds, SOGo will
// wait before replying to a Sync command.
// If not set, it defaults to 30 seconds.
SOGoMaximumSyncInterval = 3540;

// Parameter used to set the maximum amount of time, in seconds, SOGo will
// wait before doing an internal check for data changes (add, delete, and
// update). This parameter must be lower than SOGoMaximumSyncInterval and
// SOGoMaximumPingInterval.
// If not set, it defaults to 10 seconds.
SOGoInternalSyncInterval = 30;

// Specifies the number of minutes after which a busy child process will be
// killed by the parent process.
// Defaults to 10 (minutes).
WOWatchDogRequestTimeout = 60;

// Overwrite the maximum number of items returned during a Sync operation.
// Defaults to 0, which means no overwrite is performed.
// Setting this parameter to a value greater than 512 will have unexpected
// behaviour with various ActiveSync clients.
SOGoMaximumSyncWindowSize = 100;

// Overwrite the maximum response size during a Sync operation.
// The value is in kilobytes. Setting this to 512 means the response size
// will be of 524288 bytes or less (or a bit greater if needed for syncing
// one item). Note that if you set the value too low and a mail message
// (or any other object like calendar events, tasks and contacts) surpasses
// it, it will still be synced but only this item will be.
// Defaults to 0, which means no overwrite is performed.
//
// Say you have these five mails and you set the limit to 512KB:
//  1.  250 KB
//  2.  250 KB
//  3.   25 KB
//  4.  750 KB
//  5.   10 KB
// Sync iteration no. 1 will pick message 1, 2 and 3.
// Sync iteration no. 2 will pick message 4.
// Sync iteration no. 3 will pick message 5.
SOGoMaximumSyncResponseSize = 2048;

// The maximum amount of memory (in megabytes) that a child can use.
// Reaching that value will force children processes to restart, in order
// to preserve system memory.
//
// Error message when it reaches the value:
// &quot;terminating app, vMem size limit (xxx MB) has been reached (currently xxx MB)&quot;
//
// Defaults to 384.
//SxVMemLimit = 1024;

// IMAP connection pool.
// Your performance will slightly increase, as you won't open a new
// connection for every access to your IMAP server.
// But you will get a lot of simultaneous open connections to your IMAP
// server, so make sure he can handle them.
// For debugging it is reasonable to turn pooling off.
//NGImap4DisableIMAP4Pooling = NO;

SOGoProfileURL = &quot;mysql://sogo:08hz9kD5Xf9InDYHrN1ojlbvKrcgjP@127.0.0.1:3306/sogo/sogo_user_profile&quot;;
OCSFolderInfoURL = &quot;mysql://sogo:08hz9kD5Xf9InDYHrN1ojlbvKrcgjP@127.0.0.1:3306/sogo/sogo_folder_info&quot;;
OCSSessionsFolderURL = &quot;mysql://sogo:08hz9kD5Xf9InDYHrN1ojlbvKrcgjP@127.0.0.1:3306/sogo/sogo_sessions_folder&quot;;
OCSEMailAlarmsFolderURL = &quot;mysql://sogo:08hz9kD5Xf9InDYHrN1ojlbvKrcgjP@127.0.0.1:3306/sogo/sogo_alarms_folder&quot;;

// Default language in the web interface
SOGoLanguage = English;

// Specify which module to show after login: Calendar, Mail, Contacts.
SOGoLoginModule = Mail;

// Must login with full email address
SOGoForceExternalLoginWithEmail = YES;

// Allow user to change full name and email address.
SOGoMailCustomFromEnabled = YES;

// Enable email-based alarms on events and tasks.
SOGoEnableEMailAlarms = YES;

// IMAP server
//SOGoIMAPServer = &quot;imaps://127.0.0.1:143/?tls=YES&quot;;
// Local connection is considered as secure by Dovecot.
SOGoIMAPServer = &quot;imap://127.0.0.1:143/&quot;;

// Allow user to add other IMAP accounts that will be visible from the SOGo
// Webmail interface.
// Default is NO.
//SOGoMailAuxiliaryUserAccountsEnabled = YES;

// SMTP server
SOGoSMTPServer = 127.0.0.1;
SOGoMailingMechanism = smtp;
//SOGoSMTPAuthenticationType = PLAIN;

// Enable managesieve service
//
// WARNING: Sieve scripts generated by SOGo is not compatible with Roundcube
//          webmail, don't use sieve service in both webmails, otherwise
//          it will be messy.
//
SOGoSieveServer = sieve://127.0.0.1:4190;
SOGoSieveScriptsEnabled = YES;
SOGoVacationEnabled = YES;
SOGoForwardEnabled = YES;
SOGoSieveFolderEncoding = UTF-8;

// Memcached
SOGoMemcachedHost = 127.0.0.1;

// Parameter used to set which usernames require administrative privileges
// over all the users tables. For example, this could be used to post
// events in the users calendar without requiring the user to configure
// his/her ACLs. In this case you will need to specify those superuser's
// usernames like this :
// SOGoSuperUsernames = (&lt;username1>[,&lt;username2>, ...]);
//SOGoSuperUsernames = ();

SOGoTimeZone = &quot;America/New_York&quot;;

SOGoFirstDayOfWeek = 1;

SOGoRefreshViewCheck = every_5_minutes;
SOGoMailReplyPlacement = below;

SOGoAppointmentSendEMailNotifications = YES;
SOGoFoldersSendEMailNotifications = YES;
SOGoACLsSendEMailNotifications = YES;

// NOTE: PostgreSQL cannot update view in iRedMail
SOGoPasswordChangeEnabled = YES;

// Authentication using SQL

SOGoUserSources = (
    {
        type = sql;
        id = users;
        viewURL = &quot;mysql://sogo:08hz9kD5Xf9InDYHrN1ojlbvKrcgjP@127.0.0.1:3306/sogo/users&quot;;
        canAuthenticate = YES;

        // The algorithm used for password encryption when changing
        // passwords without Password Policies enabled.
        // Possible values are: plain, crypt, md5-crypt, ssha, ssha512.
        userPasswordAlgorithm = ssha512;
        prependPasswordScheme = YES;

        // Use `vmail.mailbox` as per-domain address book.
        isAddressBook = YES;
        displayName = &quot;Domain Address Book&quot;;
        SOGoEnableDomainBasedUID = YES;
        DomainFieldName = &quot;domain&quot;;
    },

    //{
    //    displayName = &quot;Global Address Book&quot;;
    //    type = sql;
    //    id = global_address_book;
    //    viewURL = &quot;mysql://sogo:08hz9kD5Xf9InDYHrN1ojlbvKrcgjP@127.0.0.1:3306/sogo/users&quot;;
    //    canAuthenticate = NO;
    //    isAddressBook = YES;
    //}
);

// Authentication using LDAP
/* LDAP backend
SOGoUserSources = (
    {
        type = ldap;
        hostname = &quot;PH_LDAP_URI&quot;;
        baseDN = &quot;PH_LDAP_BASEDN&quot;;
        //bindAsCurrentUser = YES;
        bindDN = &quot;PH_LDAP_ADMIN_DN&quot;;
        bindPassword = &quot;PH_LDAP_ADMIN_PW&quot;;
        filter = &quot;objectClass=mailUser AND accountStatus=active AND enabledService=mail AND enabledService=sogo&quot;;
        scope = SUB;

        // The algorithm used for password encryption when changing
        // passwords without Password Policies enabled.
        // Possible values are: plain, crypt, md5-crypt, ssha, ssha512.
        userPasswordAlgorithm = ssha512;

        IDFieldName = mail;
        bindFields = (mail);
        CNFieldName = cn;
        // value of UID field must be unique on whole server.
        UIDFieldName = mail;
        IMAPLoginFieldName = mail;
        SearchFieldNames = (cn, sn, displayName, telephoneNumber, mail, shadowAddress);
        canAuthenticate = YES;
        displayName = &quot;Global Address Book&quot;;
        id = ldap_auth;
        isAddressBook = YES;
    }
);
LDAP backend */

}

Christian Mack

Christian Mack

2016-08-24 08:15

developer   ~0010613

The problem here is, that those users are no longer in your LDAP.
sogo-tool needs infos out of the LDAP for the backup.

Issue History

Date Modified Username Field Change
2016-07-26 18:29 juanpablopwr New Issue
2016-08-04 14:33 ludovic Note Added: 0010565
2016-08-04 16:14 juanpablopwr Note Added: 0010566
2016-08-24 08:15 Christian Mack Note Added: 0010613
2016-12-29 17:54 ludovic Status new => closed
2016-12-29 17:54 ludovic Assigned To => ludovic
2016-12-29 17:54 ludovic Resolution open => no change required