NethServer Version: 7.3.1611
Module: Sogo
Hello Everyone,
I’m a linux lover but i’m new to Nethserver.
We are plannig to use it for our organisation and i have as you should have guess an issue with it.
My issue is about Sogo integration when a local AD is setup.
The Sogo service refuse to start and i have no issue accessing a user account with Roundcube.
I pass some hours on yours wiki/community website and the outer web space whitout finding anything.
Would you be kind enough to give me a hand with this situation 
Here are some infos about my situation:
------config show -----
DomainName=toto.fr
MinUid=5000
MySQL-asteriskcdrdb=odbc
Database=asteriskcdrdb
Description=ODBC on asteriskcdrdb
Driver=MySQL
Port=3306
Server=localhost
OrganizationContact=configuration
City=Hometown
Company=Example Org
CountryCode=
Department=Main
PhoneNumber=575-1685
State=
Street=123 Main Street
SystemName=mail-dev
TimeZone=Europe/Brussels
admins=configuration
group=domain admins
user=admin
amavisd=service
AdminNotificationStatus=disabled
AvailableDecoders=mail,asc,uue,hqx,ync,F,Z,gz,bz2,lzo,rpm,cpio,tar,deb,zip,7z,rar,arj,arc,zoo,lha,doc,cab,tnef,exe
BlockAttachmentClassList=Exec
BlockAttachmentCustomList=doc,odt
BlockAttachmentCustomStatus=disabled
BlockAttachmentStatus=enabled
EnabledDecoders=mail,asc,uue,hqx,ync,F,Z,gz,bz2,lzo,rpm,cpio,tar,deb,zip,7z,rar,arj,arc,zoo,lha,doc,cab,tnef,exe
MaxProcesses=4
RecipientWhiteList=
SenderBlackList=
SenderWhiteList=
SpamCheckStatus=enabled
SpamDsnLevel=20
SpamKillLevel=15.0
SpamSubjectPrefixStatus=enabled
SpamSubjectPrefixString=***SPAM***
SpamTag2Level=5.0
SpamTagLevel=2.0
TCPPorts=
VirusCheckStatus=enabled
status=enabled
asterisk=service
AllowExternalIAX=disabled
AllowExternalSIPS=enabled
AllowExternalWebRTC=enabled
TCPPorts=5060,5038,8088,8089
UDPPorts=4569,5036,5060,5160,10000:20000
access=green
status=enabled
backup-config=configuration
HistoryLength=3
notify=never
notifyFrom=
notifyTo=admin@localhost
status=enabled
backup-data=configuration
BackupTime=1:00
CleanupOlderThan=never
FullDay=0
LogFile=/var/log/last-backup.log
Mount=/mnt/backup
NFSHost=
NFSShare=
Program=duplicity
SMBHost=
SMBLogin=
SMBPassword=
SMBShare=
Type=incremental
USBLabel=
VFSType=
VolSize=250
WebDAVLogin=
WebDAVPassword=
WebDAVUrl=
notify=error
notifyFrom=
notifyTo=root@localhost
status=disabled
cgp=configuration
alias=ad8057070018708f45d42e6a878488c4fd9d42bf
chronyd=service
NTPServer=pool.ntp.org
UDPPort=123
access=green
status=enabled
collectd=service
PingHosts=
status=enabled
dns=configuration
NameServers=8.8.8.8
dnsmasq=service
CacheSize=4000
TCPPort=53
UDPPorts=53,67,69
access=green
dhcp-boot=
except-interface=virbr0
status=enabled
tftp-status=enabled
dovecot=service
AdminIsMaster=disabled
DeletedToTrash=disabled
FtsLuceneStatus=enabled
ImapMaxLineLenght=2048
ImapStatus=enabled
KrbKeytabPath=/var/lib/dovecot/krb5.keytab
KrbPrimaryList=smtp,imap,pop
KrbStatus=enabled
LmtpInetListenerStatus=disabled
LogActions=disabled
MaxProcesses=400
MaxUserConnectionsPerIp=12
PopStatus=enabled
QuotaDefaultSize=20
QuotaStatus=disabled
SharedMailboxesStatus=enabled
SpamFolder=Junk
SpamRetentionTime=15d
TCPPorts=110,143,4190,993,995
TlsSecurity=required
access=green,red
status=enabled
firewall=configuration
CheckIP=8.8.8.8,208.67.222.222
Docker=disabled
ExternalPing=enabled
HairpinNat=disabled
MACValidation=disabled
MACValidationPolicy=drop
MaxNumberPacketLoss=5
MaxPercentPacketLoss=10
NotifyWan=disabled
NotifyWanFrom=root@localhost
NotifyWanTo=root@localhost
PingInterval=5
Policy=permissive
WanMode=balance
nfqueue=disabled
tc=Simple
fstab=configuration
httpd=service
SSLCipherSuite=HIGH:MEDIUM:!aNULL:!MD5:!SEED:!IDEA
TCPPorts=80,443
access=green,red
status=enabled
httpd-admin=service
ForcedLoginModule=
SSL=enabled
TCPPort=980
access=green,red
colors=
favicon=favicon.png
headerBackground=
logo=
menuBackground=
status=enabled
httpd-fpbx=service
ValidFrom=10.47.175.79/255.255.0.0,172.0.0.0/255.255.255.0
access=green
status=enabled
janus-gateway=service
access=green
status=enabled
libvirtd=service
status=enabled
logrotate=configuration
Compression=disabled
Rotate=weekly
Times=4
lsm=service
status=disabled
maxAcctNameLength=31
maxGroupNameLength=31
memcached=service
status=enabled
mysqld=service
LocalNetworkingOnly=no
MaxAllowedPacket=16M
TCPPort=3306
access=
status=enabled
nsdc=service
IpAddress=10.47.175.101
ProvisionType=newdomain
bridge=br0
status=enabled
nsswitch=configuration
aliases=files nisplus
automount=files nisplus
bootparams=nisplus [NOTFOUND=return] files
ethers=files
group=files
hosts=files dns
netgroup=nisplus
netmasks=files
networks=files
passwd=files
protocols=files
publickey=nisplus
rpc=files
services=files
shadow=files
passwordstrength=configuration
MaxPassAge=180
MinPassAge=0
PassExpires=no
PassWarning=7
Users=strong
phone-home=configuration
status=disabled
uuid=c54ef028-7a94-4cc5-854f-faa5845480a6
php=configuration
DateTimezone=UTC
ExposePhp=
MaxExecutionTime=
MemoryLimit=
PostMaxSize=
ShortOpenTag=
UploadMaxFilesize=
pki=configuration
CertificateDuration=3650
ChainFile=
CommonName=
CountryCode=
CrtFile=
EmailAddress=
KeyFile=
LetsEncrypt=disabled
LetsEncryptDomains=
LetsEncryptMail=
LetsEncryptRenewDays=30
Locality=
Organization=
OrganizationalUnitName=
State=
SubjectAltName=
postfix=service
AccessBypassList=
AccessPolicies=
AdsGroupsDeliveryType=copy
AdsMapUserPrincipalStatus=enabled
AlwaysBccAddress=
AlwaysBccStatus=disabled
ConnectionsLimit=0
ConnectionsLimitPerIp=0
HeloHost=
KrbStatus=enabled
MessageQueueLifetime=4
MessageSizeMax=20000000
MessageSizeMin=1048576
MxRecordStatus=enabled
RblServers=
RblStatus=disabled
SmartHostName=
SmartHostPassword=
SmartHostPort=25
SmartHostStatus=disabled
SmartHostTlsStatus=enabled
SmartHostUsername=
SpfStatus=disabled
SystemUserRecipientStatus=disabled
TCPPorts=25,465,587
access=green,red
status=enabled
proxy=configuration
host=
password=
port=
user=
rh-php56-php-fpm=service
TCPPorts=9000
access=
status=enabled
root=configuration
EmailAddress=
KeepMessageCopy=yes
roundcubemail=configuration
PluginsList=managesieve,markasjunk
Server=localhost
access=public
rsyslog=service
LogAll2VT6=no
status=enabled
shorewall=service
status=enabled
smartd=service
status=enabled
sogod=service
ActiveSync=enabled
AdminUsers=admin
AdsCredentials=*********************
Certificate=
Dav=enabled
DraftsFolder=Drafts
MailAuxiliaryUserAccountsEnabled=YES
Notifications=Appointment,EMail
SOGoInternalSyncInterval=30
SOGoMaximumPingInterval=3540
SOGoMaximumSyncInterval=3540
SOGoMaximumSyncResponseSize=2048
SOGoMaximumSyncWindowSize=100
SentFolder=Sent
SessionDuration=1440
SxVMemLimit=512
TrashFolder=Trash
VirtualHost=
WOWatchDogRequestTimeout=60
WOWorkersCount=10
status=enabled
spamassassin=service
TCPPort=783
access=
status=enabled
sshd=service
LoginGraceTime=2m
MaxAuthTries=6
PasswordAuthentication=yes
PermitRootLogin=yes
Protocol=2
TCPPort=22
UsePAM=yes
access=green,red
status=enabled
sssd=service
AdDns=10.47.175.101
LdapURI=
Provider=ad
Realm=AD.toto.fr
Workgroup=TOTO
status=enabled
sysconfig=configuration
Copyright=
DefaultLanguage=en_US.utf8
ProductName=NethServer
Release=Final
Version=7.3.1611
unbound=service
UDPPort=10053
access=
status=enabled
webvirtmgr=service
Password=****************
TCPPort=8000
User=admin
access=green
status=disabled
webvirtmgr-console=service
TCPPorts=5900:5950,16509,6080
access=green
status=disabled
------account-provider-test dump -------
"BindDN" : "TOTO\\MAIL-DEV$",
"LdapURI" : "ldaps://ad.TOTO.fr",
"StartTls" : "",
"port" : 636,
"host" : "ad.TOTO.fr",
"isAD" : "1",
"isLdap" : "",
"UserDN" : "dc=ad,dc=TOTO,dc=fr",
"GroupDN" : "dc=ad,dc=TOTO,dc=fr",
"BindPassword" : "ܴ澵べ땭녀긢됃놷涟⸉㳨딊爙ױ竍纵딱㶀냾ꋕ☵ꍂ猎㚗ꊟ烼ⴘ竻憁⿑ⷋ兀뒪炊烫각꿇㣥㓧悚瓂ꓱ溚꾉㊆꾗ߡﲻ̷⯥が狀맣牨⢮炢㘉㵑た扟榰死㓲㥦밪澄﨑㎏溅╆⹊땬暤眀䀘덕ﺄ≸괼귱⹋껤ꉔꊶ篢普ꧼ떭ꮕ눋떢뻟ﰁⱁ洛曏ﰻメۡ畓歌⤫㗟롊掄痦痝뾡ꠊ桺獫﵃ォ꡵딩뒶닀籞ꃏ㑵☷综땆㴎煡擕獗Ⱇ㋭⭐뀒ܬ뒅櫆㵏㍸Ⰰㇰ掬릫ˇרּ温⚩睿뻝㰮ㄡ⪨⸇뼫枴DŽꋾ딖㤲ⷎ㩡潼湖㶰棜㝑犫扎㡮ﯰ眊랥꭫ꭾ㏾ㄑ㻕煇獢릪ꋶ㦕㩓榶獏⩼띟₎חﳎŚ歷簡＾笗烲ꩰ⠫",
"BaseDN" : "dc=ad,dc=TOTO,dc=fr",
"LdapUriDn" : "ldap:///dc%3Dad%2Cdc%3DTOTO%2Cdc%3Dfr"
--------sogo.conf--------
/* **************** DO NOT MODIFY THIS FILE **************** *
*
* Manual changes will be lost when this file is regenerated.
*
* ********************************************************** */
/* 10 Database configuration (mysql) */
SOGoProfileURL = "mysql://sogo:VZUOIxFaUItfOX2M@localhost/sogo/sogo_user_profile";
OCSFolderInfoURL = "mysql://sogo:VZUOIxFaUItfOX2M@localhost/sogo/sogo_folder_info";
OCSSessionsFolderURL = "mysql://sogo:VZUOIxFaUItfOX2M@localhost/sogo/sogo_sessions_folder";
OCSEMailAlarmsFolderURL = "mysql://sogo:VZUOIxFaUItfOX2M@localhost/sogo/sogo_alarms_folder";
/* 20 Mail */
SOGoDraftsFolderName = "Drafts";
SOGoSentFolderName = "Sent";
SOGoTrashFolderName = "Trash";
SOGoJunkFolderName = "Junk";
SOGoIMAPServer = "localhost";
SOGoSieveServer = "sieve://localhost:4190";
SOGoSMTPServer = "127.0.0.1:587";
SOGoMailDomain = "toto.fr";
SOGoMailingMechanism = "smtp";
NGImap4ConnectionStringSeparator = "/";
/* 30 Notifications */
SOGoFoldersSendEMailNotifications = NO;
SOGoACLsSendEMailNotifications = NO;
SOGoAppointmentSendEMailNotifications = YES;
SOGoEnableEMailAlarms = YES;
/* 40 Authentication */
//SOGoPasswordChangeEnabled = YES;
/* 45 AD authentication */
SOGoUserSources =(
{
id = AD_Users;
type = ldap;
CNFieldName = cn;
IDFieldName = sAMAccountName;
UIDFieldName = sAMAccountName;
IMAPLoginFieldName = userPrincipalName;
canAuthenticate = YES;
bindDN = "TOTO\\MAIL-DEV$";
bindPassword = "ܴ澵べ땭녀긢됃놷涟⸉㳨딊爙ױ竍纵딱㶀냾ꋕ☵ꍂ猎㚗ꊟ烼ⴘ竻憁⿑ⷋ兀뒪炊烫각꿇㣥㓧悚瓂ꓱ溚꾉㊆꾗ߡﲻ̷⯥が狀맣牨⢮炢㘉㵑た扟榰死㓲㥦밪澄﨑㎏溅╆⹊땬暤眀䀘덕ﺄ≸괼귱⹋껤ꉔꊶ篢普ꧼ떭ꮕ눋떢뻟ﰁⱁ洛曏ﰻメۡ畓歌⤫㗟롊掄痦痝뾡ꠊ桺獫﵃ォ꡵딩뒶닀籞ꃏ㑵☷综땆㴎煡擕獗Ⱇ㋭⭐뀒ܬ뒅櫆㵏㍸Ⰰㇰ掬릫ˇרּ温⚩睿뻝㰮ㄡ⪨⸇뼫枴DŽꋾ딖㤲ⷎ㩡潼湖㶰棜㝑犫扎㡮ﯰ眊랥꭫ꭾ㏾ㄑ㻕煇獢릪ꋶ㦕㩓榶獏⩼띟₎חﳎŚ歷簡＾笗烲ꩰ⠫";
baseDN = "dc=ad,dc=TOTO,dc=org";
bindFields = (
sAMAccountName,
userPrincipalName
);
hostname = ldaps://ad.toto.fr;
filter = "(objectClass='user')";
MailFieldNames = ("userPrincipalName");
scope = SUB;
displayName = "toto.fr users";
isAddressBook = YES;
},
{
id = AD_Groups;
type = ldap;
CNFieldName = name;
IDFieldName = sAMAccountName;
UIDFieldName = sAMAccountName;
canAuthenticate = YES;
bindDN = "TOTO\\MAIL-DEV$";
bindPassword = "ܴ澵べ땭녀긢됃놷涟⸉㳨딊爙ױ竍纵딱㶀냾ꋕ☵ꍂ猎㚗ꊟ烼ⴘ竻憁⿑ⷋ兀뒪炊烫각꿇㣥㓧悚瓂ꓱ溚꾉㊆꾗ߡﲻ̷⯥が狀맣牨⢮炢㘉㵑た扟榰死㓲㥦밪澄﨑㎏溅╆⹊땬暤眀䀘덕ﺄ≸괼귱⹋껤ꉔꊶ篢普ꧼ떭ꮕ눋떢뻟ﰁⱁ洛曏ﰻメۡ畓歌⤫㗟롊掄痦痝뾡ꠊ桺獫﵃ォ꡵딩뒶닀籞ꃏ㑵☷综땆㴎煡擕獗Ⱇ㋭⭐뀒ܬ뒅櫆㵏㍸Ⰰㇰ掬릫ˇרּ温⚩睿뻝㰮ㄡ⪨⸇뼫枴DŽꋾ딖㤲ⷎ㩡潼湖㶰棜㝑犫扎㡮ﯰ眊랥꭫ꭾ㏾ㄑ㻕煇獢릪ꋶ㦕㩓榶獏⩼띟₎חﳎŚ歷簡＾笗烲ꩰ⠫";
baseDN = "dc=ad,dc=TOTO,dc=org";
hostname = ldaps://ad.toto.fr;
filter = "(objectClass='group') AND (sAMAccountType=268435456)";
MailFieldNames = ("userPrincipalName");
scope = SUB;
displayName = "toto.fr groups";
isAddressBook = YES;
}
);
/* 50 Web Interface */
SOGoVacationEnabled = YES;
SOGoForwardEnabled = YES;
SOGoSieveScriptsEnabled = YES;
SOGoMailAuxiliaryUserAccountsEnabled = YES;
SOGoMailCustomFromEnabled = YES;
//SOGoFirstDayOfWeek = 1;
//SOGoMailReplyPlacement = "above";
//SOGoMailSignaturePlacement = "above";
/* 60 General */
SOGoTimeZone = Europe/Brussels;
SOGoSuperUsernames = (admin); // This is an array - keep the parens!
SOGoMemcachedHost = "127.0.0.1";
SxVMemLimit = 512;
SOGoEnablePublicAccess = YES;
/* From Nethesis GNUStep configuration
Undocumented in sogo instalation manual */
SOGoAppointmentSendEMailReceipts = YES;
/* 70 Active Sync options and tuning */
SOGoMaximumPingInterval = 3540;
SOGoMaximumSyncInterval = 3540;
SOGoInternalSyncInterval = 30;
SOGoMaximumSyncResponseSize = 2048;
SOGoMaximumSyncWindowSize = 100;
WOWatchDogRequestTimeout = 60;
WOWorkersCount = 10;
/* 80 Debug */
//SOGoDebugRequests = YES;
//SoDebugBaseURL = YES;
//ImapDebugEnabled = YES;
LDAPDebugEnabled = YES;
//PGDebugEnabled = YES;
//MySQL4DebugEnabled = YES;
//SOGoUIxDebugEnabled = YES;
//WODontZipResponse = YES;
SOGoEASDebugEnabled = YES;
WOLogFile = "/var/log/sogo/sogo.log";
------LOG SOGO START ------------------------
Oct 19 12:31:43 mail-dev systemd: Starting SOGo is a groupware server...
Oct 19 12:31:43 mail-dev sogod: 2017-10-19 12:31:43.169 sogod[16609:16609] File NSString.m: 1507. In -[NSString initWithContentsOfFile:] Contents of f
ile '/etc/sogo/sogo.conf' are not string data
Oct 19 12:31:43 mail-dev sogod: <0x0x55706f92edd0[SOGoStartupLogger]> Cannot read configuration from '/etc/sogo/sogo.conf'. Aborting
Oct 19 12:31:43 mail-dev systemd: sogod.service: control process exited, code=exited status=1
Oct 19 12:31:43 mail-dev systemd: Failed to start SOGo is a groupware server.
Oct 19 12:31:43 mail-dev systemd: Unit sogod.service entered failed state.
Oct 19 12:31:43 mail-dev systemd: sogod.service failed.
What i don’t understand is why i’m getting Chinese Characters on my sogo.conf…
Anyway
Thank for any hins letting me fix this situation.
Zwordi
