We use sogo from 1 week with any problem, but yesterday we have an LDAP crash.
This is my sogod config 1.2.1 on Centos 5.4 with LDAP addressbook and ldap auth
NSGlobalDomain = {
};
sogod = {
NGUseUTF8AsURLEncoding = YES;
OCSFolderInfoURL =
"mysql://sogo:axnyz******g*********2xw+xoauz...@localhost/sogo/sogo_folder_info";
SOGoACLsSendEMailNotifications = NO;
SOGoAppointmentSendEMailNotifications = YES;
SOGoAppointmentSendEMailReceipts = YES;
SOGoAuthenticationMethod = LDAP;
SOGoDraftsFolderName = Drafts;
SOGoFoldersSendEMailNotifications = NO;
SOGoIMAPServer = localhost;
SOGoMailDomain = nethesis.it;
SOGoMailingMechanism = sendmail;
SOGoProfileURL =
"mysql://sogo:axny**********+xoauz...@localhost/sogo/sogo_user_profile";
SOGoSMTPServer = localhost;
SOGoSentFolderName = Sent;
SOGoSuperUsernames = (
admin
);
SOGoTimeZone = Europe/Rome;
SOGoTrashFolderName = Trash;
SOGoUserSources = (
{
CNFieldName = cn;
IDFieldName = uid;
UIDFieldName = uid;
baseDN = "ou=Users,dc=nethesis,dc=it";
bindFields = uid;
canAuthenticate = YES;
displayName = "Users";
hostname = localhost;
id = users;
isAddressBook = YES;
port = 389;
type = ldap;
},
{
CNFieldName = cn;
IDFieldName = cn;
UIDFieldName = cn;
baseDN = "ou=Groups,dc=nethesis,dc=it";
bindFields = cn;
canAuthenticate = YES;
displayName = "Groups";
hostname = localhost;
id = groups;
isAddressBook = YES;
port = 389;
type = ldap;
}
);
WOMessageUseUTF8 = YES;
WOParsersUseUTF8 = YES;
WOPort = 127.0.0.1:20000;
WOUseRelativeURLs = YES;
};
}
Yesterday sogo seems to make a lot of query to server LDAP for group tecnici,May 18 09:18:25
nethservice slapd[2781]: conn=576 op=1 SRCH base="ou=users,dc=nethesis,dc=it" scope=2 deref=0
filter="(uid=tecnici)"
See /var/log/sogo
localhost - - [17/May/2010:18:14:21 GMT] "PROPFIND /SOGo/dav/filippo/Calendar/personal/ HTTP/1.1"
207 314/123 0.057 - - 0
localhost - - [17/May/2010:18:15:48 GMT] "POST
/SOGo/so/filippo/Mail//filippo_A_localhost/folderINBOX/view?noframe=1&sort=date&asc=false HTTP/1.1"
200 3541/0 0.561 53180 93% 0
localhost - - [17/May/2010:18:15:48 GMT] "POST
/SOGo/so/filippo/Mail/filippo_A_localhost/statusFolders HTTP/1.1" 200 13/0 0.061 - - 0
2010-05-17 18:25:01.078 sogod[15077] WARNING(-[NSNull(misc) count]): called NSNull -count (returns
0) !!!
localhost - - [17/May/2010:18:25:01 GMT] "GET /SOGo/ HTTP/1.1" 200 2779/0 0.018
8151 65% 0
2010-05-17 18:25:07.151 sogod[15077] Scanner initialised with nil string
May 17 18:25:07 sogod: SOGo watchdog [15077]: SOGoRootPage failed login for
user 'al'
localhost - - [17/May/2010:18:25:07 GMT] "POST /SOGo/connect HTTP/1.1" 403 0/40
0.008 - - 0
2010-05-17 18:28:23.959 sogod[15077] Scanner initialised with nil string
May 17 18:28:23 sogod: SOGo watchdog [15077]: SOGoRootPage successful login for
user 'alessio'
localhost - - [17/May/2010:18:28:23 GMT] "POST /SOGo/connect HTTP/1.1" 204 0/48
0.007 - - 0
localhost - - [17/May/2010:18:28:23 GMT] "GET /SOGo/alessio HTTP/1.1" 302 0/0
0.011 - - 0
localhost - - [17/May/2010:18:28:24 GMT] "GET /SOGo/alessio/view HTTP/1.1" 302
0/0 0.038 - - 0
localhost - - [17/May/2010:18:28:24 GMT] "GET /SOGo/so/alessio/Calendar
HTTP/1.1" 302 0/0 0.006 - - 0
2010-05-17 18:28:24.126 sogod[15077] Scanner initialised with nil string
2010-05-17 18:28:24.136 sogod[15077] ERROR: MySQL4 field is marked unsigned (unsupported):
{columnName = c_folder_id; name = c_folder_id; }
2010-05-17 18:28:24.139 sogod[15077] members count (static group): 11
2010-05-17 18:28:24.139 sogod[15077] Scanner initialised with nil string
2010-05-17 18:28:24.146 sogod[15077] Scanner initialised with nil string
2010-05-17 18:28:24.152 sogod[15077] Scanner initialised with nil string
2010-05-17 18:28:24.159 sogod[15077] Scanner initialised with nil string
2010-05-17 18:28:24.165 sogod[15077] Scanner initialised with nil string
2010-05-17 18:28:24.172 sogod[15077] Scanner initialised with nil string
2010-05-17 18:28:24.178 sogod[15077] Scanner initialised with nil string
2010-05-17 18:28:24.184 sogod[15077] Scanner initialised with nil string
2010-05-17 18:28:24.191 sogod[15077] Scanner initialised with nil string
2010-05-17 18:28:24.199 sogod[15077] members count (static group): 11
2010-05-17 18:28:24.201 sogod[15077] members count (static group): 11
2010-05-17 18:28:24.202 sogod[15077] members count (static group): 11
2010-05-17 18:28:24.207 sogod[15077] ERROR: MySQL4 field is marked unsigned (unsupported):
{columnName = c_folder_id; name = c_folder_id; }
2010-05-17 18:28:24.211 sogod[15077] members count (static group): 11
2010-05-17 18:28:24.212 sogod[15077] members count (static group): 11
2010-05-17 18:28:24.214 sogod[15077] members count (static group): 11
and /var/log/messages
May 18 09:18:25 nethservice slapd[2781]: bdb(dc=nethesis,dc=it): Lock table is out of available
locker entries
May 18 09:18:25 nethservice last message repeated 3 times
May 18 09:18:25 nethservice slapd[2781]: conn=575 op=1 SEARCH RESULT tag=101 err=80 nentries=0
text=internal error
May 18 09:18:25 nethservice slapd[2781]: conn=576 fd=29 ACCEPT from
IP=127.0.0.1:33988 (IP=0.0.0.0:389)
May 18 09:18:25 nethservice slapd[2781]: conn=576 op=0 BIND dn="" method=128
May 18 09:18:25 nethservice slapd[2781]: conn=576 op=0 RESULT tag=97 err=0 text=
May 18 09:18:25 nethservice slapd[2781]: conn=576 op=1 SRCH base="ou=users,dc=nethesis,dc=it"
scope=2 deref=0 filter="(uid=tecnici)"
May 18 09:18:25 nethservice slapd[2781]: conn=576 op=1 SRCH attr=objectClass cn uid mail title
company o displayname modifytimestamp mozillahomestate mozillahomeurl homeurl st region
mozillacustom2 custom2 mozillahomecountryname description notes department departmentnumber ou
orgunit mobile cellphone carphone mozillacustom1 custom1 mozillanickname xmozillanickname
mozillaworkurl workurl fax facsimiletelephonenumber telephonenumber mozillahomestreet
mozillasecondemail xmozillasecondemail mozillacustom4 custom4 nsaimid nscpaimscreenname street
streetaddress postofficebox homephone cn commonname givenname mozillahomepostalcode
mozillahomelocalityname mozillaworkstreet2 mozillausehtmlmail xmozillausehtmlmail mozillahomestreet2
postalcode zip c countryname pager pagerphone mail sn surname mozillacustom3 custom3 l locality
birthyear serialnumber calfburl proxyaddresses member uniqueMember memberUid memberOf
Until LDAP is blocked and sogo can't make any search
2010-05-18 10:01:06.961 sogod[15077] Scanner initialised with nil string
2010-05-18 10:01:06.961 sogod[15077] Could not bind to the LDAP server localhost (389) using the
bind DN: (nil)
2010-05-18 10:01:06.962 sogod[15077] Could not bind to the LDAP server localhost (389) using the
bind DN: (nil)
Can you help me?
--
Alessio Fattorini ([email protected])
nethesis srl - Via degli Olmi 16/4 - 61100 Pesaro (PU)
tel. +39 0721 405516 - fax +39 0721 268147
www.nethesis.it - [email protected]
--
[email protected]
https://inverse.ca/sogo/lists
