Zentyal Forum, Linux Small Business Server

Zentyal Server => Email and Groupware => Topic started by: mkugler on January 06, 2020, 04:50:44 pm

Title: Backup Mails over SOGo [Solved]
Post by: mkugler on January 06, 2020, 04:50:44 pm
Hi, I have a question about Mail - Zentyal 6.1 - the access to mail via mobile devices like iPad - iPhone etc. works fine with the Exchange Connector. If I now go through MACOS and try to use the Exchange Connector there, I can't get a connection to the server. Via IMAP email and notes work correctly, but I can't access calendar and contacts via "dav", here I always get the message that the user or password is wrong, I have tested both - 1x the username and 1x the email address.

Additionally I would like to backup the email database, I tried: sudo -u sogo Logo-tools /home/administrator ALL, but I get the message that there is no access to the database

Unfortunately I can't get any further here, can someone help me, thank you very much in advance.

I would not like to use a thirdparty product like Thunderbird.

M. Kugler

--------------


Here are some Information about the messages of sogo-tool for the user Michaela Kugler:

administrator@srvdc01:/automnt/Backup/Email$ sogo-tool backup /automnt/Backup/Email/ ALL
2020-01-07 11:19:02.471 sogo-tool[12826:12826] ERROR(+[GCSFolderManager defaultFolderManager]): default 'OCSFolderInfoURL' is not configured.
<0x0x55b1de80bcc0[SOGoUserManager]> No authentication sources defined - nobody will be able to login. Check your defaults.
2020-01-07 11:19:02.474 sogo-tool[12826:12826] ERROR(+[GCSFolderManager defaultFolderManager]): default 'OCSFolderInfoURL' is not configured.
<0x0x55b1de7faeb0[SOGoCache]> Cache cleanup interval set every 300.000000 seconds
<0x0x55b1de7faeb0[SOGoCache]> Using host(s) 'localhost' as server(s)
2020-01-07 11:19:02.476 sogo-tool[12826:12826] user 'ALL' unknown

administrator@srvdc01:/automnt/Backup/Email$ sogo-tool backup /automnt/Backup/Email/ mkugler02
2020-01-07 11:24:04.920 sogo-tool[13256:13256] ERROR(+[GCSFolderManager defaultFolderManager]): default 'OCSFolderInfoURL' is not configured.
<0x0x5559b6e5ecc0[SOGoUserManager]> No authentication sources defined - nobody will be able to login. Check your defaults.
<0x0x5559b6e4deb0[SOGoCache]> Cache cleanup interval set every 300.000000 seconds
<0x0x5559b6e4deb0[SOGoCache]> Using host(s) 'localhost' as server(s)
2020-01-07 11:24:04.921 sogo-tool[13256:13256] user 'mkugler02' unknown

administrator@srvdc01:/automnt/Backup/Email$ sogo-tool backup /automnt/Backup/Email/ michaela.kugler@kuglerm.de
2020-01-07 11:24:48.913 sogo-tool[13336:13336] ERROR(+[GCSFolderManager defaultFolderManager]): default 'OCSFolderInfoURL' is not configured.
<0x0x5626c786fcf0[SOGoUserManager]> No authentication sources defined - nobody will be able to login. Check your defaults.
<0x0x5626c785eee0[SOGoCache]> Cache cleanup interval set every 300.000000 seconds
<0x0x5626c785eee0[SOGoCache]> Using host(s) 'localhost' as server(s)
2020-01-07 11:24:48.915 sogo-tool[13336:13336] user 'michaela.kugler' unknown

administrator@srvdc01:/automnt/Backup/Email$ sogo-tool backup /automnt/Backup/Email/ "Michaela Kugler"
2020-01-07 11:25:30.551 sogo-tool[13374:13374] ERROR(+[GCSFolderManager defaultFolderManager]): default 'OCSFolderInfoURL' is not configured.
<0x0x55dd7abeccc0[SOGoUserManager]> No authentication sources defined - nobody will be able to login. Check your defaults.
<0x0x55dd7abdbeb0[SOGoCache]> Cache cleanup interval set every 300.000000 seconds
<0x0x55dd7abdbeb0[SOGoCache]> Using host(s) 'localhost' as server(s)
2020-01-07 11:25:30.552 sogo-tool[13374:13374] user 'Michaela Kugler' unknown
Title: Re: SOGo and MACOS Mail Client - Backup Mails over SOGo
Post by: doncamilo on January 07, 2020, 03:00:34 pm
 :)

To fix the issue you have detected:

Code: [Select]
root@zen61:~# mkdir -p /etc/zentyal/stubs/sogo
root@zen61:~# cp /usr/share/zentyal/stubs/sogo/sogo.conf.mas /etc/zentyal/stubs/sogo/

Edit /etc/zentyal/stubs/sogo/sogo.conf.mas and do this change: from "IDFieldName = cn;" to "IDFieldName = sAMAccountName" only in the first section id = sambaLogin;

Code: [Select]
...
/* LDAP authentication */
  SOGoUserSources = (
      {
          type = ldap;
          id = sambaLogin;
          displayName = "SambaLogin";
          canAuthenticate = YES;
          CNFieldName = cn;
          IDFieldName = sAMAccountName;
          UIDFieldName = sAMAccountName;
          hostname = "<% $sambaHost %>";
          baseDN = "<% $sambaBaseDN %>";
          bindDN = "<% $sambaBindDN %>";
          bindPassword = "<% $sambaBindPwd %>";
          bindFields = (sAMAccountName, mail);
          filter = "(mail='*')";
          MailFieldNames = (mail, otherMailbox);
      },...

So:

Code: [Select]
root@zen61:~# zs sogo restart
root@zen61:/tmp/sogo# sogo-tool -v backup /tmp/sogo ALL
<0x0x562f00930b60[SOGoCache]> Cache cleanup interval set every 300.000000 seconds
<0x0x562f00930b60[SOGoCache]> Using host(s) 'localhost' as server(s)
root@zen61:/tmp/sogo# ls /tmp/sogo/
bilbo  frodo


The content of the files is (for instance cat /tmp/sogo/bilbo)

Code: [Select]
root@zen61:/tmp/sogo# cat /tmp/sogo/frodo
{
    "ldif_record" = "dn: cn=frodo baggings,cn=users,dc=lab61,dc=lan
sn: Baggings
instancetype: 4
pwdlastset: 132209664055927540
samaccounttype: 805306368
description: zenadmin
countrycode: 0
jabberuid: frodo
accountexpires: 9223372036854775807
logoncount: 2
mailbox: lab61.lan/frodo/
c_emails: frodo@lab61.lan
lastlogontimestamp: 132224493502136570
name: Frodo Baggings
objectcategory: CN=Person,CN=Schema,CN=Configuration,DC=lab61,DC=lan
mailhomedirectory: /var/vmail/
lastlogoff: 0
quota: 500
uidnumber: 65536
primarygroupid: 513
c_name: frodo
codepage: 0
givenname: Frodo
usnchanged: 4066
c_uid: frodo
objectclass: top
objectclass: fetchmailUser
objectclass: posixAccount
objectclass: userZentyalMail
objectclass: person
objectclass: userJabberAccount
objectclass: systemQuotas
objectclass: organizationalPerson
objectclass: user
usermaildirsize: 0
mail: frodo@lab61.lan
homedirectory: \\\\zen61.LAB61.LAN\\frodo
c_cn: Frodo Baggings
whencreated: 20191216104004.0Z
gidnumber: 2513
badpasswordtime: 0
cn: Frodo Baggings
displayname: Frodo Baggings
userprincipalname: frodo@LAB61.LAN
usncreated: 3813
badpwdcount: 0
whenchanged: 20200107132434.0Z
jabberadmin: FALSE
distinguishedname: CN=Frodo Baggings,CN=Users,DC=lab61,DC=lan
c_info: zenadmin
homedrive: H:
samaccountname: frodo
useraccountcontrol: 512
mailquota: 0
lastlogon: 132224496466477730
";
    preferences = (
{
    SOGoAlternateAvatar = none;
    SOGoAnimationMode = normal;
    SOGoCalendarCategories = (
Trabajo,
Llamadas,
Favoritos,
"Reuni\U00F3n",
Ideas,
Varios,
"Cumplea\U00F1os",
Aniversario,
Vacaciones,
Viajes,
Proyectos,
Proveedores,
Regalos,
Clientes,
Asuntos,
Negocios,
Fiestas,
Personal,
Estado,
"Competici\U00F3n",
Seguimiento,
"Vacaciones p\U00FAblicas"
    );
    SOGoCalendarCategoriesColors = {
Aniversario = "#9F44D3";
Asuntos = "#3677FF";
Clientes = "#E96D71";
"Competici\U00F3n" = "#6018DC";
"Cumplea\U00F1os" = "#28C76F";
Estado = "#002661";
Favoritos = "#EA5455";
Fiestas = "#0E197D";
Ideas = "#32CCBC";
Llamadas = "#0396FF";
Negocios = "#FA016D";
Personal = "#DE4313";
Proveedores = "#9708CC";
Proyectos = "#8C1BAB";
Regalos = "#736EFE";
"Reuni\U00F3n" = "#7367F0";
Seguimiento = "#D939CD";
Trabajo = "#F8D800";
Vacaciones = "#623AA2";
"Vacaciones p\U00FAblicas" = "#E80505";
Varios = "#F6416C";
Viajes = "#F55555";
    };
    SOGoCalendarDefaultReminder = NONE;
    SOGoCalendarEventsDefaultClassification = PUBLIC;
    SOGoCalendarTasksDefaultClassification = PUBLIC;
    SOGoCalendarWeekdays = (
SU,
MO,
TU,
WE,
TH,
FR,
SA
    );
    SOGoContactsCategories = (
" Amigo",
" Cliente",
" Competidor",
" Familia",
" Prensa",
" Proveedor",
" Socio",
" VIP",
Colega
    );
    SOGoDayEndTime = "18:00";
    SOGoDayStartTime = "08:00";
    SOGoDefaultCalendar = selected;
    SOGoFirstDayOfWeek = <*I0>;
    SOGoFirstWeekOfYear = January1;
    SOGoGravatarEnabled = <*I0>;
    SOGoLanguage = SpanishSpain;
    SOGoLoginModule = Mail;
    SOGoLongDateFormat = "%A, %B %d, %Y";
    SOGoMailAddOutgoingAddresses = <*I0>;
    SOGoMailAutoSave = 5;
    SOGoMailComposeFontSize = 0;
    SOGoMailComposeMessageType = html;
    SOGoMailDisplayRemoteInlineImages = never;
    SOGoMailLabelsColors = {
"$label1" = (
    Importante,
    "#FF0000"
);
"$label2" = (
    Trabajo,
    "#FF9900"
);
"$label3" = (
    Personal,
    "#009900"
);
"$label4" = (
    "Por hacer",
    "#3333FF"
);
"$label5" = (
    "M\U00E1s tarde",
    "#993399"
);
"$mdnsent" = (
    "Return Receipt Sent",
    "#006600"
);
    };
    SOGoMailMessageForwarding = inline;
    SOGoMailReplyPlacement = below;
    SOGoMailSignaturePlacement = below;
    SOGoRefreshViewCheck = manually;
    SOGoSelectedAddressBook = collected;
    SOGoShortDateFormat = "%d-%b-%y";
    SOGoTimeFormat = "%H:%M";
    SOGoTimeZone = "Europe/Madrid";
},
{
    Calendar = {
    };
}
    );
    tables = {
"/Users/frodo/Calendar/personal" = {
    acl = {
    };
    displayname = "Calendario personal";
    records = (
    );
};
"/Users/frodo/Contacts/personal" = {
    acl = {
    };
    displayname = "Libreta personal de direcciones";
    records = (
    );
};
    };
}root@zen61:/tmp/sogo#

Cheers!
Title: Re: SOGo and MACOS Mail Client - Backup Mails over SOGo
Post by: mkugler on January 07, 2020, 03:47:49 pm
Hello, a great tutorial, it worked immediately, with this I can now create backups. Thank you very much !