Zentyal Forum, Linux Small Business Server
Zentyal Server => Email and Groupware => Topic started 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
-
:)
To fix the issue you have detected:
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;
...
/* 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:
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)
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!
-
Hello, a great tutorial, it worked immediately, with this I can now create backups. Thank you very much !