Re: [SOGo] SOGo EXCEPTION on login

2012-03-19 Thread Покотиленко Константин Александрович
В Птн, 16/03/2012 в 17:50 +0200, Покотиленко Константин Александрович
пишет: 
> В Птн, 16/03/2012 в 16:23 +0200, Покотиленко Константин Александрович
> пишет: 
> > В Птн, 16/03/2012 в 13:10 +0200, Покотиленко Константин Александрович
> > пишет: 
> > > В Чтв, 15/03/2012 в 13:34 -0400, Ludovic Marcotte пишет: 
> > > > On 15/03/12 11:57, Покотиленко Константин Александрович wrote:
> > > > > I've googled and found one post with exactly same error, the author 
> > > > > said
> > > > > he solved the problem by "fixing" LDAP configuration and did not
> > > > > provided any details.
> > > > Show your complete SOGo configuration.
> > > 
> > > Here is .GNUstepDefaults:
> > 
> > I've found my problem.
> > 
> > > MailFieldNames
> > > mail
> > 
> > First, MailFieldNames should be array and since it defaults to mail I
> > just removed this block.
> > 
> > Second, It was not working until I explicitly specified type=ldap for
> > SOGoUserSources. It's not clear in the docs that it should be specified,
> > docs doesn't mention "type" in "defaults write sogod
> > SOGoUserSources ..." command, but mentions it in config samples.
> > 
> > And third, I have to TRUNCATE all SOGo tables in MySQL to get rid of
> > SOGo EXCEPTION.
> 
> Actually, problem not solved.
> 
> After some time being logged in I get "internal server error" if I'm
> logged in and "An unhandled error occurred." if I try to login with this
> log messages:
> 
> =
> 2012-03-16 17:22:31.127 sogod[3445] WARNING(-[NSNull(misc) count]):
> called NSNull -count (returns 0) !!!
> 192.168.*.* - - [16/Mar/2012:17:22:31 GMT] "GET /SOGo/so/ HTTP/1.1" 200
> 5126/0 0.025 14845 65% 12K
> 2012-03-16 17:36:31.361 sogod[3445] WARNING(-[NSNull(misc) count]):
> called NSNull -count (returns 0) !!!
> 192.168.*.* - - [16/Mar/2012:17:36:31 GMT] "GET /SOGo/so/ HTTP/1.1" 200
> 5126/0 0.031 14845 65% 0
> Mar 16 17:37:46 sogod [3445]: SOGoRootPage successful login for user
> 'casper' - expire = -1  grace = -1
> EXCEPTION:  NAME:NSInvalidArgumentException
> REASON:NSDataMalloc(instance) does not recognize
> stringByReplacingString:withString: INFO:(null)
> Mar 16 17:37:46 sogod [27289]: <0x0x1f2b208[WOWatchDogChild]> child 3445
> exited
> Mar 16 17:37:46 sogod [27289]: <0x0x1f2b208[WOWatchDogChild]>
> (terminated due to signal 6)
> Mar 16 17:37:46 sogod [27289]: <0x0x1d66968[WOWatchDog]> child spawned
> with pid 8424
> =
> 
> If I remove profile of my user
> 
> DELETE FROM `sogo`.`sogo_user_profile` WHERE `sogo_user_profile`.`c_uid`
> = 'casper'
> 
> I'm able to login and use SOGo for some time and then it happens again.

Found similar bug report and a solution. Changed mysql database and it's
table's collation from utf8_bin to utf8_unicode_ci. And now it's working
without exceptions.


-- 
users@sogo.nu
https://inverse.ca/sogo/lists


Re: [SOGo] SOGo EXCEPTION on login

2012-03-16 Thread Покотиленко Константин Александрович
В Птн, 16/03/2012 в 16:23 +0200, Покотиленко Константин Александрович
пишет: 
> В Птн, 16/03/2012 в 13:10 +0200, Покотиленко Константин Александрович
> пишет: 
> > В Чтв, 15/03/2012 в 13:34 -0400, Ludovic Marcotte пишет: 
> > > On 15/03/12 11:57, Покотиленко Константин Александрович wrote:
> > > > I've googled and found one post with exactly same error, the author said
> > > > he solved the problem by "fixing" LDAP configuration and did not
> > > > provided any details.
> > > Show your complete SOGo configuration.
> > 
> > Here is .GNUstepDefaults:
> 
> I've found my problem.
> 
> > MailFieldNames
> > mail
> 
> First, MailFieldNames should be array and since it defaults to mail I
> just removed this block.
> 
> Second, It was not working until I explicitly specified type=ldap for
> SOGoUserSources. It's not clear in the docs that it should be specified,
> docs doesn't mention "type" in "defaults write sogod
> SOGoUserSources ..." command, but mentions it in config samples.
> 
> And third, I have to TRUNCATE all SOGo tables in MySQL to get rid of
> SOGo EXCEPTION.

Actually, problem not solved.

After some time being logged in I get "internal server error" if I'm
logged in and "An unhandled error occurred." if I try to login with this
log messages:

=
2012-03-16 17:22:31.127 sogod[3445] WARNING(-[NSNull(misc) count]):
called NSNull -count (returns 0) !!!
192.168.*.* - - [16/Mar/2012:17:22:31 GMT] "GET /SOGo/so/ HTTP/1.1" 200
5126/0 0.025 14845 65% 12K
2012-03-16 17:36:31.361 sogod[3445] WARNING(-[NSNull(misc) count]):
called NSNull -count (returns 0) !!!
192.168.*.* - - [16/Mar/2012:17:36:31 GMT] "GET /SOGo/so/ HTTP/1.1" 200
5126/0 0.031 14845 65% 0
Mar 16 17:37:46 sogod [3445]: SOGoRootPage successful login for user
'casper' - expire = -1  grace = -1
EXCEPTION:  NAME:NSInvalidArgumentException
REASON:NSDataMalloc(instance) does not recognize
stringByReplacingString:withString: INFO:(null)
Mar 16 17:37:46 sogod [27289]: <0x0x1f2b208[WOWatchDogChild]> child 3445
exited
Mar 16 17:37:46 sogod [27289]: <0x0x1f2b208[WOWatchDogChild]>
(terminated due to signal 6)
Mar 16 17:37:46 sogod [27289]: <0x0x1d66968[WOWatchDog]> child spawned
with pid 8424
=

If I remove profile of my user

DELETE FROM `sogo`.`sogo_user_profile` WHERE `sogo_user_profile`.`c_uid`
= 'casper'

I'm able to login and use SOGo for some time and then it happens again.

How could I further debug on this?

-- 
users@sogo.nu
https://inverse.ca/sogo/lists


Re: [SOGo] SOGo EXCEPTION on login

2012-03-16 Thread Покотиленко Константин Александрович
В Птн, 16/03/2012 в 13:10 +0200, Покотиленко Константин Александрович
пишет: 
> В Чтв, 15/03/2012 в 13:34 -0400, Ludovic Marcotte пишет: 
> > On 15/03/12 11:57, Покотиленко Константин Александрович wrote:
> > > I've googled and found one post with exactly same error, the author said
> > > he solved the problem by "fixing" LDAP configuration and did not
> > > provided any details.
> > Show your complete SOGo configuration.
> 
> Here is .GNUstepDefaults:

I've found my problem.

> MailFieldNames
> mail

First, MailFieldNames should be array and since it defaults to mail I
just removed this block.

Second, It was not working until I explicitly specified type=ldap for
SOGoUserSources. It's not clear in the docs that it should be specified,
docs doesn't mention "type" in "defaults write sogod
SOGoUserSources ..." command, but mentions it in config samples.

And third, I have to TRUNCATE all SOGo tables in MySQL to get rid of
SOGo EXCEPTION.

Well, each time I install SOGo I'm getting certain that SOGo itself is a
great software, BUT Gnustep configuration is a nightmare b/c it's hard
to debug.

Thanks.

-- 
users@sogo.nu
https://inverse.ca/sogo/lists


Re: [SOGo] SOGo EXCEPTION on login

2012-03-16 Thread Christian Rößner
Hi,

>> On 15/03/12 11:57, Покотиленко Константин Александрович wrote:
>>> I've googled and found one post with exactly same error, the author said
>>> he solved the problem by "fixing" LDAP configuration and did not
>>> provided any details.
>> Show your complete SOGo configuration.
> 
I had the same problem with LDAP and also found the same "solution". In my case 
it was easy:

The problem came up, when I copied the SOGo-Keys from the PDF document and 
inserted it into the terminal. This seems to make trouble! Delete the key and 
insert it by type it manually.

In my case it was the IMAPLoginFieldName key that produced the exception.


-Christian

---
Roessner-Network-Solutions
Bachelor of Science Informatik
Nahrungsberg 81, 35390 Gießen
F: +49 641 5879091, M: +49 176 93118939
USt-IdNr.: DE225643613
http://www.roessner-network-solutions.com

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] SOGo EXCEPTION on login

2012-03-16 Thread Покотиленко Константин Александрович
В Чтв, 15/03/2012 в 13:34 -0400, Ludovic Marcotte пишет: 
> On 15/03/12 11:57, Покотиленко Константин Александрович wrote:
> > I've googled and found one post with exactly same error, the author said
> > he solved the problem by "fixing" LDAP configuration and did not
> > provided any details.
> Show your complete SOGo configuration.

Here is .GNUstepDefaults:


http://www.gnustep.org/plist-0_9.xml";>


NSGlobalDomain


sogod

OCSFolderInfoURL
mysql://sogo:sogo:3306/sogo/sogo_folder_info
OCSSessionsFolderURL
mysql://sogo:sogo@localhost:3306/sogo/sogo_sessions_folder
OGoIMAPServer
imap.mydomain.com
OGoTrashFolderName
Trash
SOGoACLsSendEMailNotifications
YES
SOGoAppointmentSendEMailNotifications
YES
SOGoDraftsFolderName
Draft
SOGoFoldersSendEMailNotifications
YES
SOGoForceIMAPLoginWithEmail
YES
SOGoLanguage
Russian
SOGoMailDomain
mydomain.com
SOGoMailingMechanism
smtp
SOGoProfileURL
mysql://sogo:sogo@localhost:3306/sogo/sogo_user_profile
SOGoSMTPServer
smtp.mydomain.com
SOGoSentFolderName
Sent
SOGoSuperUsernames

casper

SOGoTimeZone
Europe/Kyiv
SOGoUserSources


CNFieldName
cn
IMAPLoginFieldName
mail
MailFieldNames
mail
UIDFieldName
sAMAccountName
baseDN

ou=users&admins,dc=office,dc=mydomain,dc=com
bindAsCurrentUser
YES
bindDN
cn=authman,ou=users&admins,dc=office,dc=mydomain,dc=com
bindFields

sAMAccountName

bindPassword
ldappass
canAuthenticate
YES
displayName
Active Directory
hostname
192.168.*.*
id
AD
isAddressBook
YES
port
3268







-- 
users@sogo.nu
https://inverse.ca/sogo/lists


Re: [SOGo] SOGo EXCEPTION on login

2012-03-15 Thread Ludovic Marcotte

On 15/03/12 11:57, Покотиленко Константин Александрович wrote:

I've googled and found one post with exactly same error, the author said
he solved the problem by "fixing" LDAP configuration and did not
provided any details.

Show your complete SOGo configuration.

--
Ludovic Marcotte
+1.514.755.3630  ::  www.inverse.ca
Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence 
(www.packetfence.org)

--
users@sogo.nu
https://inverse.ca/sogo/lists


[SOGo] SOGo EXCEPTION on login

2012-03-15 Thread Покотиленко Константин Александрович
I've just installed SOGo 1.3.12c from yum repository for RHEL6.
Auth is set to AD LDAP, database is mysql.

When I try to login I get "An unhandled error occurred." and this is in
the sogo.log:


2012-03-15 17:39:09.140 sogod[19754] WARNING(-[NSNull(misc) count]):
called NSNull -count (returns 0) !!!
192.168.*.* - - [15/Mar/2012:17:39:09 GMT] "GET /SOGo/ HTTP/1.1" 200
5125/0 0.094 14842 65% 4M
Mar 15 17:39:13 sogod [19754]: SOGoRootPage successful login for user
'casper' - expire = -1  grace = -1
EXCEPTION:  NAME:NSInvalidArgumentException
REASON:GSCInlineString(instance) does not recognize stringsWithFormat:
INFO:(null)
Mar 15 17:39:13 sogod [19733]: <0x0x26daf08[WOWatchDogChild]> child
19754 exited
Mar 15 17:39:13 sogod [19733]: <0x0x26daf08[WOWatchDogChild]>
(terminated due to signal 6)
Mar 15 17:39:13 sogod [19733]: <0x0x2522988[WOWatchDog]> child spawned
with pid 20157


So it says "successful login for user 'casper'" and drop an exception
just after.

I've googled and found one post with exactly same error, the author said
he solved the problem by "fixing" LDAP configuration and did not
provided any details.

My baseDN and bindDN contain an amp sing (...ou=users&admins,dc=...), I
wonder whether this is my problem.

Also, this SOGo version depend on libmemcached.so.7 which is available
from sogo-rhel6 repository, but rhel6 comes with libmemcached.so.2 and
php memcached extension requires libmemcached.so.2, so I was not able to
update. I just made symlink from libmemcached.so.2 to libmemcached.so.7
and now wonder if this would cause problems.


-- 
users@sogo.nu
https://inverse.ca/sogo/lists


[SOGo] SOGo EXCEPTION on login

2012-03-15 Thread Покотиленко Константин Александрович
I've just installed SOGo 1.3.12c from yum repository for RHEL6.
Auth is set to AD LDAP, database is mysql.

When I try to login I get "An unhandled error occurred." and this is in
the sogo.log:


2012-03-15 17:39:09.140 sogod[19754] WARNING(-[NSNull(misc) count]):
called NSNull -count (returns 0) !!!
192.168.*.* - - [15/Mar/2012:17:39:09 GMT] "GET /SOGo/ HTTP/1.1" 200
5125/0 0.094 14842 65% 4M
Mar 15 17:39:13 sogod [19754]: SOGoRootPage successful login for user
'casper' - expire = -1  grace = -1
EXCEPTION:  NAME:NSInvalidArgumentException
REASON:GSCInlineString(instance) does not recognize stringsWithFormat:
INFO:(null)
Mar 15 17:39:13 sogod [19733]: <0x0x26daf08[WOWatchDogChild]> child
19754 exited
Mar 15 17:39:13 sogod [19733]: <0x0x26daf08[WOWatchDogChild]>
(terminated due to signal 6)
Mar 15 17:39:13 sogod [19733]: <0x0x2522988[WOWatchDog]> child spawned
with pid 20157


So it says "successful login for user 'casper'" and drop an exception
just after.

I've googled and found one post with exactly same error, the author said
he solved the problem by "fixing" LDAP configuration and did not
provided any details.

My baseDN and bindDN contain an amp sing
(...ou=users&admins,dc=...), I wonder whether this is my problem.

Also, this SOGo version depend on libmemcached.so.7 which is available
from sogo-rhel6 repository, but rhel6 comes with libmemcached.so.2 and
php memcached extension requires libmemcached.so.2, so I was not able to
update. I just made symlink from libmemcached.so.2 to libmemcached.so.7
and now wonder if this would cause problems.



-- 
users@sogo.nu
https://inverse.ca/sogo/lists