[SOGo] warnings in logs

2010-10-06 Thread Anton Popov
 Hi,

Does anyone know what this is and if/how I should fix it? Entries like
this appear quite often in my logs and since my clients get a lot of

HTTP/1.1 502 Proxy Error
CalDAVAccoutRefreshQueueableOperations

in iCal I was wondering if any of these may be related. I can see no
other funny entries in the logs.


Oct 06 09:39:06 sogod: SOGo watchdog [14565]: [WARN]
0x0x17abcdc0[SOGoWebDAVAclManager] entry '{DAV:}write' already exists
in DAV permissions table
Oct 06 09:39:06 sogod: SOGo watchdog [14565]: [WARN]
0x0x17abcdc0[SOGoWebDAVAclManager] entry '{DAV:}write-properties'
already exists in DAV permissions table
Oct 06 09:39:06 sogod: SOGo watchdog [14565]: [WARN]
0x0x17abcdc0[SOGoWebDAVAclManager] entry '{DAV:}write-content' already
exists in DAV permissions table
Oct 06 09:39:06 sogod: SOGo watchdog [14564]: [WARN]
0x0x17abcab0[SOGoWebDAVAclManager] entry '{DAV:}write' already exists
in DAV permissions table
Oct 06 09:39:06 sogod: SOGo watchdog [14564]: [WARN]
0x0x17abcab0[SOGoWebDAVAclManager] entry '{DAV:}write-properties'
already exists in DAV permissions table
Oct 06 09:39:06 sogod: SOGo watchdog [14564]: [WARN]
0x0x17abcab0[SOGoWebDAVAclManager] entry '{DAV:}write-content' already
exists in DAV permissions table


2010-10-06 09:40:51.287 sogod[14562] WARNING(-[SaxXMLReaderFactory
_loadBundlePath:infoDictionary:nameMap:typeMap:]): multiple parsers
available for MIME type 'text/x-vcard', using 'VSvCardSaxDriver' as
default for type text/x-vcard.
2010-10-06 09:40:51.287 sogod[14562] WARNING(-[SaxXMLReaderFactory
_loadBundlePath:infoDictionary:nameMap:typeMap:]): multiple parsers
available for MIME type 'text/calendar', using 'VSiCalSaxDriver' as
default for type text/calendar.



Oct 06 09:40:59 sogod: SOGo watchdog [14562]: 0x0x1791fd80[SOGoCache]
an error occurred when caching value for key 'jdoe +attributes': CLIENT
ERROR
Oct 06 09:40:59 sogod: SOGo watchdog [14562]: 0x0x1791fd80[SOGoCache]
an error occurred when caching value for key 'jdoe
@domain.com+attributes': CLIENT ERROR
Oct 06 09:40:59 sogod: SOGo watchdog [14562]: 0x0x1791fd80[SOGoCache]
an error occurred when caching value for key 'jdoe +settings': CLIENT
ERROR
Oct 06 09:40:59 sogod: SOGo watchdog [14562]: 0x0x1791fd80[SOGoCache]
an error occurred when caching value for key 'jdoe +defaults': CLIENT
ERROR
-- memcache is running and I only get this error for 1 user.


2010-10-06 09:39:49.073 sogod[14563] File NSKeyValueCoding.m: 892. In
[SOGoAppointmentInboxFolder -valuesForKeys:] This method is deprecated,
use -dictionaryWithValuesForKeys:


Thanks a lot,

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


Re: [SOGo] SOGoCache error

2010-10-06 Thread Alan Bover
try that:

Get sure that memcached is working:

 ps -aux | grep memcached

if its not running, start it:

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


Re[2]: [SOGo] SOGoCache error

2010-10-06 Thread Imo Graf
thanks it works  


-- orginal Nachricht --
From: Alan Bover alan.bo...@upcnet.es
To: users@sogo.nu
Sent: 06.10.2010 12:33:53
Subject: Re: [SOGo] SOGoCache error

try that:

Get sure that memcached is working:




ps -aux | grep memcached




if its not running, start it:




memcached -u sogo -d



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





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

Re: [SOGo] Tasks color on Ubuntu

2010-10-06 Thread Alessio Fattorini

Il 06/08/2010 14:29, Alessio Fattorini ha scritto:

Sorry for question regard lightning, but in Ubuntu Lucid theme Ambience 
(default), tasks list is
unusable. The color is white over white, i can't read and use anything. I must 
change theme in
Radiance for use it, it's not a great solution :-|
Can anyone help me? Can i change lightning css?


Anyone on this?

--
Alessio Fattorini (alessio.fattor...@nethesis.it)

nethesis srl - Via degli Olmi 16/4 - 61100 Pesaro (PU)
tel. +39 0721 405516 - fax +39 0721 268147
www.nethesis.it - i...@nethesis.it
--
users@sogo.nu
https://inverse.ca/sogo/lists


Re: [SOGo] SOGo WARNING called NSNull -length

2010-10-06 Thread Wolfgang Sourdeau

Hi Imo,

2010-10-06 10:41:55.165 sogod[4534] WARNING(-[NSNull(misc) length]): 
called NSNull -length (returns 0) !!!
2010-10-06 10:41:55.165 sogod[4534] WARNING(-[NSNull(misc) length]): 
called NSNull -length (returns 0) !!!
2010-10-06 10:41:55.165 sogod[4534] WARNING(-[NSNull(misc) length]): 


As explained many times already, this can be safely ignored. We cannot 
do much about it as this is generated by GNUstep.


--
Wolfgang Sourdeau  ::  +1 (514) 447-4918 ext. 125  ::  wsourd...@inverse.ca
Inverse inc. Leaders behind SOGo (sogo.nu) and PacketFence 
(www.packetfence.org)

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


Re: [SOGo] Tasks color on Ubuntu

2010-10-06 Thread Wolfgang Sourdeau

Alessio Fattorini wrote:

Il 06/08/2010 14:29, Alessio Fattorini ha scritto:
Sorry for question regard lightning, but in Ubuntu Lucid theme 
Ambience (default), tasks list is
unusable. The color is white over white, i can't read and use 
anything. I must change theme in

Radiance for use it, it's not a great solution :-|
Can anyone help me? Can i change lightning css?


Anyone on this?



Please fill a bugreport for this in the Mozilla bts.

--
Wolfgang Sourdeau  ::  +1 (514) 447-4918 ext. 125  ::  wsourd...@inverse.ca
Inverse inc. Leaders behind SOGo (sogo.nu) and PacketFence 
(www.packetfence.org)

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


Re: [SOGo] warnings in logs

2010-10-06 Thread Wolfgang Sourdeau

Anton Popov wrote:

 Hi,

Does anyone know what this is and if/how I should fix it? Entries like
this appear quite often in my logs and since my clients get a lot of

HTTP/1.1 502 Proxy Error
CalDAVAccoutRefreshQueueableOperations

in iCal I was wondering if any of these may be related. I can see no
other funny entries in the logs.


Oct 06 09:39:06 sogod: SOGo watchdog [14565]: [WARN]
0x0x17abcdc0[SOGoWebDAVAclManager] entry '{DAV:}write' already exists
in DAV permissions table
Oct 06 09:39:06 sogod: SOGo watchdog [14565]: [WARN]
0x0x17abcdc0[SOGoWebDAVAclManager] entry '{DAV:}write-properties'
already exists in DAV permissions table
Oct 06 09:39:06 sogod: SOGo watchdog [14565]: [WARN]
0x0x17abcdc0[SOGoWebDAVAclManager] entry '{DAV:}write-content' already
exists in DAV permissions table
Oct 06 09:39:06 sogod: SOGo watchdog [14564]: [WARN]
0x0x17abcab0[SOGoWebDAVAclManager] entry '{DAV:}write' already exists
in DAV permissions table
Oct 06 09:39:06 sogod: SOGo watchdog [14564]: [WARN]
0x0x17abcab0[SOGoWebDAVAclManager] entry '{DAV:}write-properties'
already exists in DAV permissions table
Oct 06 09:39:06 sogod: SOGo watchdog [14564]: [WARN]
0x0x17abcab0[SOGoWebDAVAclManager] entry '{DAV:}write-content' already
exists in DAV permissions table


You can ignore those.


2010-10-06 09:40:51.287 sogod[14562] WARNING(-[SaxXMLReaderFactory
_loadBundlePath:infoDictionary:nameMap:typeMap:]): multiple parsers
available for MIME type 'text/x-vcard', using 'VSvCardSaxDriver' as
default for type text/x-vcard.
2010-10-06 09:40:51.287 sogod[14562] WARNING(-[SaxXMLReaderFactory
_loadBundlePath:infoDictionary:nameMap:typeMap:]): multiple parsers
available for MIME type 'text/calendar', using 'VSiCalSaxDriver' as
default for type text/calendar.


These too.



Oct 06 09:40:59 sogod: SOGo watchdog [14562]: 0x0x1791fd80[SOGoCache]
an error occurred when caching value for key 'jdoe +attributes': CLIENT
ERROR
Oct 06 09:40:59 sogod: SOGo watchdog [14562]: 0x0x1791fd80[SOGoCache]
an error occurred when caching value for key 'jdoe
@domain.com+attributes': CLIENT ERROR
Oct 06 09:40:59 sogod: SOGo watchdog [14562]: 0x0x1791fd80[SOGoCache]
an error occurred when caching value for key 'jdoe +settings': CLIENT
ERROR
Oct 06 09:40:59 sogod: SOGo watchdog [14562]: 0x0x1791fd80[SOGoCache]
an error occurred when caching value for key 'jdoe +defaults': CLIENT
ERROR
-- memcache is running and I only get this error for 1 user.


This is not a serious issue but it seems like your user has a space 
ending his username. Is that possible?



2010-10-06 09:39:49.073 sogod[14563] File NSKeyValueCoding.m: 892. In
[SOGoAppointmentInboxFolder -valuesForKeys:] This method is deprecated,
use -dictionaryWithValuesForKeys:


You can ignore that one.

--
Wolfgang Sourdeau  ::  +1 (514) 447-4918 ext. 125  ::  wsourd...@inverse.ca
Inverse inc. Leaders behind SOGo (sogo.nu) and PacketFence 
(www.packetfence.org)

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


Re: [SOGo] warnings in logs

2010-10-06 Thread Anton Popov
 On 10/06/2010 03:54 PM, Wolfgang Sourdeau wrote:
 Oct 06 09:40:59 sogod: SOGo watchdog [14562]: 0x0x1791fd80[SOGoCache]
 an error occurred when caching value for key 'jdoe +defaults': CLIENT
 ERROR
 -- memcache is running and I only get this error for 1 user.


 This is not a serious issue but it seems like your user has a space
 ending his username. Is that possible?



Yes! That was the problem. Thank you very much.
-- 
users@sogo.nu
https://inverse.ca/sogo/lists


Re: [SOGo] SOGo WARNING called NSNull -length

2010-10-06 Thread Helge Hess
On Oct 6, 2010, at 6:51 AM, Wolfgang Sourdeau wrote:
 2010-10-06 10:41:55.165 sogod[4534] WARNING(-[NSNull(misc) length]): called 
 NSNull -length (returns 0) !!!
 2010-10-06 10:41:55.165 sogod[4534] WARNING(-[NSNull(misc) length]): called 
 NSNull -length (returns 0) !!!
 2010-10-06 10:41:55.165 sogod[4534] WARNING(-[NSNull(misc) length]): 
 
 As explained many times already, this can be safely ignored. We cannot do 
 much about it as this is generated by GNUstep.

Thats incorrect, this is generated by a category in SOPE. It points out an 
issue with NSNull not being properly used in higher layers (essentially NSNull 
should only live in generic collections, if its retrieved via KVC, it should be 
replaced with nil. Hence in regular code you would never send arbitrary 
messages to NSNull).

You can get rid of that by removing the respective methods in 
SOPE/NSObject+misc. (but that doesn't solve the core issue, which should be 
fixed instead ...)

hh

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

Re: [SOGo] SOGo WARNING called NSNull -length

2010-10-06 Thread Wolfgang Sourdeau

Hi Helge,


Long time no see!

The problem of seeing those warnings in the logfile is still not serious 
per se. It doesn't cause SOGo to crash nor data to be lost. It's just 
aesthetic and in that sense will be fixed some day.


--
Wolfgang Sourdeau  ::  +1 (514) 447-4918 ext. 125  ::  wsourd...@inverse.ca
Inverse inc. Leaders behind SOGo (sogo.nu) and PacketFence 
(www.packetfence.org)

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


Re: [SOGo] Re: TB 3.1+Lightning 1.0b2 (Inverse Nightly)+CalDAV via https: Calendars disappear

2010-10-06 Thread Martin Lehmann

 Hi Ludovic,

I installed the nightlies from today but it still doesn't work.

I also created a complete new thunderbird-profile and installed the 
nightly sogo extensions and nothing else.

Same effect. It doesn't work!

It's possible to create and delete google events but it's not possible 
to edit them.


Anything else I can try?

Thx
Martin

Am 05.10.2010 21:19, schrieb Ludovic Marcotte:

 On 04/10/10 7:04 PM, Martin Lehmann wrote:

 Problem still exists.

  but that minor nit will be fixed tomorrow.

This citation is from 09/16/2010.

No comments? No solution?


We pushed a fix - try http://inverse.ca/downloads/extensions/nightly/


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


[SOGo] Login on Sogo webinterface

2010-10-06 Thread Guillaume Dualé

Hi there,
I'm trying Sogo with the most simple configuration as possible.

OS : Debian Lenny
Sogo installed with aptitude
Databse : MySQL
Authentification : With MySQL

When I go to http://192.168.0.13:2 I can't login, even with nobody 
user.

He always say: An unhandled error occurred.

So, in log file, /var/log/sogo/sogo.log I can see it when I restart the 
service with /etc/init.d/sogo restart :


Oct 07 01:03:17 sogod: SOGo watchdog [4439]: 0x0x9f5f5f0[WOWatchDog] 
Terminating with signal 15
Oct 07 01:03:17 sogod: SOGo watchdog [4439]: 
0x0x9f7b748[WOWatchDogChild] sending terminate signal to pid 4440
Oct 07 01:03:18 sogod: SOGo watchdog [4439]: 
0x0x9f7b748[WOWatchDogChild] child 4440 exited
Oct 07 01:03:18 sogod: SOGo watchdog [4439]: 0x0x9f5f5f0[WOWatchDog] 
all children exited. We now terminate.
Oct 07 01:03:18 sogod: SOGo watchdog [4527]: [WARN] 
0x0x9a0f960[WOWatchDog] 'WOHttpAllowHost' is ignored in watchdog mode, 
use a real firewall instead
Oct 07 01:03:18 sogod: SOGo watchdog [4527]: 0x0x9a0f960[WOWatchDog] 
listening on *:2
Oct 07 01:03:18 sogod: SOGo watchdog [4527]: 0x0x9a0f960[WOWatchDog] 
watchdog process pid: 4527
Oct 07 01:03:18 sogod: SOGo watchdog [4527]: 0x0x9a0f960[WOWatchDog] 
preparing 1 children
Oct 07 01:03:18 sogod: SOGo watchdog [4528]: 
0x0x9b6a370[SOGoProductLoader] SOGo products loaded from 
'/usr/lib/GNUstep/SOGo':
Oct 07 01:03:18 sogod: SOGo watchdog [4528]: 
0x0x9b6a370[SOGoProductLoader]   MainUI.SOGo, Contacts.SOGo, 
CommonUI.SOGo, MailerUI.SOGo, Appointments.SOGo, PreferencesUI.SOGo, 
Mailer.SOGo, ContactsUI.SOGo, SchedulerUI.SOGo, MailPartViewers.SOGo, 
AdministrationUI.SOGo
Oct 07 01:03:18 sogod: SOGo watchdog [4527]: 0x0x9a0f960[WOWatchDog] 
child spawned with pid 4528
Oct 07 01:03:18 sogod: SOGo watchdog [4528]: |SOGo| version 1.3.2 (build 
@vizzini.inverse.ca 201009211534) -- starting
Oct 07 01:03:18 sogod: SOGo watchdog [4528]: |SOGo| vmem size check 
enabled: shutting down app when vmem  384 MB



And when I access to this url http://192.168.0.13:2 I can see it in 
log file :


Oct 07 01:04:04 sogod: SOGo watchdog [4528]: 0x0x9bc90d8[SOGoCache] 
Cache cleanup interval set every 300.00 seconds
Oct 07 01:04:04 sogod: SOGo watchdog [4528]: 0x0x9bc90d8[SOGoCache] 
Using host(s) 'localhost' as server(s)
Oct 07 01:04:04 sogod: SOGo watchdog [4528]: [ERROR] 
0x0x9982128[SOGoUserManager] No authentication sources defined - 
nobody will be able to login. Check your defaults.
2010-10-07 01:04:04.913 sogod[4528] ERROR(-[NGBundleManager 
bundleWithPath:]): could not create bundle for path: 
'/usr/share/GNUstep/Libraries/gnustep-base/Versions/1.16/Resources/SSL.bundle' 

2010-10-07 01:04:04.958 sogod[4528] WARNING(-[NSNull(misc) count]): 
called NSNull -count (returns 0) !!!



Here is a dump of my /home/sogo/GNUstep/Defaults/.GNUstepDefaults
{
NSGlobalDomain = {
};
SOGoUserSources = (
{
canAuthenticate = YES;
id = directory;
isAddressBook = YES;
type = sql;
userPasswordAlgorithm = md5;
viewURL = mysql://root:r...@127.0.0.1:3306/sogo/sogo_view;
}
);
sogod = {
OCSFolderInfoURL = 
mysql://sogo:s...@localhost:3306/sogo/sogo_folder_info;

SOGoACLsSendEMailNotifications = YES;
SOGoAppointmentSendEMailNotifications = YES;
SOGoDraftsFolderName = Drafts;
SOGoFoldersSendEMailNotifications = YES;
SOGoIMAPServer = localhost;
SOGoLanguage = French;
SOGoMailDomain = tazou.dyndns.org;
SOGoMailingMechanism = smtp;
SOGoProfileURL = 
mysql://sogo:s...@localhost:3306/sogo/sogo_user_profile;

SOGoSMTPServer = localhost;
SOGoSentFolderName = Sent;
SOGoTimeZone = Europe/Paris;
SOGoTrashFolderName = Trash;
};
}


For MySQL configuration, I did :
mysql -p
create database sogo CHARSET='UTF8';
CREATE USER 'sogo'@'localhost' IDENTIFIED BY 'sogo';
GRANT ALL PRIVILEGES ON `sogo`.* TO 'sogo'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;

I don't know how to try...
Thanks for your help :)
Guillaume.
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Login on Sogo webinterface

2010-10-06 Thread Ludovic Marcotte

 On 10-10-06 6:05 PM, Guillaume Dualé wrote:

Hi there,
I'm trying Sogo with the most simple configuration as possible.

OS : Debian Lenny
Sogo installed with aptitude
Databse : MySQL
Authentification : With MySQL

How about Apache?


When I go to http://192.168.0.13:2 I can't login, even with 
nobody user.

Never do that, use Apache in front of SOGo.

He always say: An unhandled error occurred.

So, in log file, /var/log/sogo/sogo.log I can see it when I restart 
the service with /etc/init.d/sogo restart :


Oct 07 01:03:17 sogod: SOGo watchdog [4439]: 0x0x9f5f5f0[WOWatchDog] 
Terminating with signal 15
Oct 07 01:03:17 sogod: SOGo watchdog [4439]: 
0x0x9f7b748[WOWatchDogChild] sending terminate signal to pid 4440
Oct 07 01:03:18 sogod: SOGo watchdog [4439]: 
0x0x9f7b748[WOWatchDogChild] child 4440 exited
Oct 07 01:03:18 sogod: SOGo watchdog [4439]: 0x0x9f5f5f0[WOWatchDog] 
all children exited. We now terminate.
Oct 07 01:03:18 sogod: SOGo watchdog [4527]: [WARN] 
0x0x9a0f960[WOWatchDog] 'WOHttpAllowHost' is ignored in watchdog 
mode, use a real firewall instead
Oct 07 01:03:18 sogod: SOGo watchdog [4527]: 0x0x9a0f960[WOWatchDog] 
listening on *:2
Oct 07 01:03:18 sogod: SOGo watchdog [4527]: 0x0x9a0f960[WOWatchDog] 
watchdog process pid: 4527
Oct 07 01:03:18 sogod: SOGo watchdog [4527]: 0x0x9a0f960[WOWatchDog] 
preparing 1 children
Oct 07 01:03:18 sogod: SOGo watchdog [4528]: 
0x0x9b6a370[SOGoProductLoader] SOGo products loaded from 
'/usr/lib/GNUstep/SOGo':
Oct 07 01:03:18 sogod: SOGo watchdog [4528]: 
0x0x9b6a370[SOGoProductLoader]   MainUI.SOGo, Contacts.SOGo, 
CommonUI.SOGo, MailerUI.SOGo, Appointments.SOGo, PreferencesUI.SOGo, 
Mailer.SOGo, ContactsUI.SOGo, SchedulerUI.SOGo, MailPartViewers.SOGo, 
AdministrationUI.SOGo
Oct 07 01:03:18 sogod: SOGo watchdog [4527]: 0x0x9a0f960[WOWatchDog] 
child spawned with pid 4528
Oct 07 01:03:18 sogod: SOGo watchdog [4528]: |SOGo| version 1.3.2 
(build @vizzini.inverse.ca 201009211534) -- starting
Oct 07 01:03:18 sogod: SOGo watchdog [4528]: |SOGo| vmem size check 
enabled: shutting down app when vmem  384 MB



And when I access to this url http://192.168.0.13:2 I can see it 
in log file :


Oct 07 01:04:04 sogod: SOGo watchdog [4528]: 0x0x9bc90d8[SOGoCache] 
Cache cleanup interval set every 300.00 seconds
Oct 07 01:04:04 sogod: SOGo watchdog [4528]: 0x0x9bc90d8[SOGoCache] 
Using host(s) 'localhost' as server(s)
Oct 07 01:04:04 sogod: SOGo watchdog [4528]: [ERROR] 
0x0x9982128[SOGoUserManager] No authentication sources defined - 
nobody will be able to login. Check your defaults.
2010-10-07 01:04:04.913 sogod[4528] ERROR(-[NGBundleManager 
bundleWithPath:]): could not create bundle for path: 
'/usr/share/GNUstep/Libraries/gnustep-base/Versions/1.16/Resources/SSL.bundle' 

2010-10-07 01:04:04.958 sogod[4528] WARNING(-[NSNull(misc) count]): 
called NSNull -count (returns 0) !!!



Here is a dump of my /home/sogo/GNUstep/Defaults/.GNUstepDefaults
{
NSGlobalDomain = {
};
SOGoUserSources = (
{
canAuthenticate = YES;
id = directory;
isAddressBook = YES;
type = sql;
userPasswordAlgorithm = md5;
viewURL = mysql://root:r...@127.0.0.1:3306/sogo/sogo_view;
}
);
sogod = {
OCSFolderInfoURL = 
mysql://sogo:s...@localhost:3306/sogo/sogo_folder_info;

SOGoACLsSendEMailNotifications = YES;
SOGoAppointmentSendEMailNotifications = YES;
SOGoDraftsFolderName = Drafts;
SOGoFoldersSendEMailNotifications = YES;
SOGoIMAPServer = localhost;
SOGoLanguage = French;
SOGoMailDomain = tazou.dyndns.org;
SOGoMailingMechanism = smtp;
SOGoProfileURL = 
mysql://sogo:s...@localhost:3306/sogo/sogo_user_profile;

SOGoSMTPServer = localhost;
SOGoSentFolderName = Sent;
SOGoTimeZone = Europe/Paris;
SOGoTrashFolderName = Trash;
};
}


For MySQL configuration, I did :
mysql -p
create database sogo CHARSET='UTF8';
CREATE USER 'sogo'@'localhost' IDENTIFIED BY 'sogo';
GRANT ALL PRIVILEGES ON `sogo`.* TO 'sogo'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;

What about sogo_view? It won't be created and populated with the right 
information automagically. Something like that might help:


mysql  USE sogo;
mysql  CREATE TABLE sogo_view (c_uid VARCHAR(10) PRIMARY KEY, c_name 
VARCHAR(10), c_password VARCHAR(32), c_cn VARCHAR(128), mail VARCHAR(128));
mysql  INSERT INTO sogo_view VALUES ('alice', 'alice', MD5('secret'), 'Alice 
Thompson', 'al...@acme.com');
mysql  INSERT INTO sogo_view VALUES ('bob', 'bob', MD5('secret'), 'Bob Smith', 
'b...@acme.com');
mysql  INSERT INTO sogo_view VALUES ('chris', 'chris', MD5('secret'), 'Chris 
Cooper', 'ch...@acme.com');


Regards,

--
Ludovic Marcotte
lmarco...@inverse.ca  ::  +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

Re: [SOGo] Login on Sogo webinterface

2010-10-06 Thread Guillaume Dualé

On 07/10/2010 01:41, Ludovic Marcotte wrote:

On 10-10-06 6:05 PM, Guillaume Dualé wrote:

Hi there,
I'm trying Sogo with the most simple configuration as possible.

OS : Debian Lenny
Sogo installed with aptitude
Databse : MySQL
Authentification : With MySQL

How about Apache?


When I go to http://192.168.0.13:2 I can't login, even with 
nobody user.

Never do that, use Apache in front of SOGo.

Ok, I didn't know.
Now Apache2 with SSL is in front of Sogo, and I have now a pretty nice 
homepage for SOGo :)



He always say: An unhandled error occurred.

So, in log file, /var/log/sogo/sogo.log I can see it when I restart 
the service with /etc/init.d/sogo restart :


Oct 07 01:03:17 sogod: SOGo watchdog [4439]: 
0x0x9f5f5f0[WOWatchDog] Terminating with signal 15
Oct 07 01:03:17 sogod: SOGo watchdog [4439]: 
0x0x9f7b748[WOWatchDogChild] sending terminate signal to pid 4440
Oct 07 01:03:18 sogod: SOGo watchdog [4439]: 
0x0x9f7b748[WOWatchDogChild] child 4440 exited
Oct 07 01:03:18 sogod: SOGo watchdog [4439]: 
0x0x9f5f5f0[WOWatchDog] all children exited. We now terminate.
Oct 07 01:03:18 sogod: SOGo watchdog [4527]: [WARN] 
0x0x9a0f960[WOWatchDog] 'WOHttpAllowHost' is ignored in watchdog 
mode, use a real firewall instead
Oct 07 01:03:18 sogod: SOGo watchdog [4527]: 
0x0x9a0f960[WOWatchDog] listening on *:2
Oct 07 01:03:18 sogod: SOGo watchdog [4527]: 
0x0x9a0f960[WOWatchDog] watchdog process pid: 4527
Oct 07 01:03:18 sogod: SOGo watchdog [4527]: 
0x0x9a0f960[WOWatchDog] preparing 1 children
Oct 07 01:03:18 sogod: SOGo watchdog [4528]: 
0x0x9b6a370[SOGoProductLoader] SOGo products loaded from 
'/usr/lib/GNUstep/SOGo':
Oct 07 01:03:18 sogod: SOGo watchdog [4528]: 
0x0x9b6a370[SOGoProductLoader]   MainUI.SOGo, Contacts.SOGo, 
CommonUI.SOGo, MailerUI.SOGo, Appointments.SOGo, PreferencesUI.SOGo, 
Mailer.SOGo, ContactsUI.SOGo, SchedulerUI.SOGo, MailPartViewers.SOGo, 
AdministrationUI.SOGo
Oct 07 01:03:18 sogod: SOGo watchdog [4527]: 
0x0x9a0f960[WOWatchDog] child spawned with pid 4528
Oct 07 01:03:18 sogod: SOGo watchdog [4528]: |SOGo| version 1.3.2 
(build @vizzini.inverse.ca 201009211534) -- starting
Oct 07 01:03:18 sogod: SOGo watchdog [4528]: |SOGo| vmem size check 
enabled: shutting down app when vmem  384 MB



And when I access to this url http://192.168.0.13:2 I can see it 
in log file :


Oct 07 01:04:04 sogod: SOGo watchdog [4528]: 0x0x9bc90d8[SOGoCache] 
Cache cleanup interval set every 300.00 seconds
Oct 07 01:04:04 sogod: SOGo watchdog [4528]: 0x0x9bc90d8[SOGoCache] 
Using host(s) 'localhost' as server(s)
Oct 07 01:04:04 sogod: SOGo watchdog [4528]: [ERROR] 
0x0x9982128[SOGoUserManager] No authentication sources defined - 
nobody will be able to login. Check your defaults.
2010-10-07 01:04:04.913 sogod[4528] ERROR(-[NGBundleManager 
bundleWithPath:]): could not create bundle for path: 
'/usr/share/GNUstep/Libraries/gnustep-base/Versions/1.16/Resources/SSL.bundle' 

2010-10-07 01:04:04.958 sogod[4528] WARNING(-[NSNull(misc) count]): 
called NSNull -count (returns 0) !!!



Here is a dump of my /home/sogo/GNUstep/Defaults/.GNUstepDefaults
{
NSGlobalDomain = {
};
SOGoUserSources = (
{
canAuthenticate = YES;
id = directory;
isAddressBook = YES;
type = sql;
userPasswordAlgorithm = md5;
viewURL = mysql://root:r...@127.0.0.1:3306/sogo/sogo_view;
}
);
sogod = {
OCSFolderInfoURL = 
mysql://sogo:s...@localhost:3306/sogo/sogo_folder_info;

SOGoACLsSendEMailNotifications = YES;
SOGoAppointmentSendEMailNotifications = YES;
SOGoDraftsFolderName = Drafts;
SOGoFoldersSendEMailNotifications = YES;
SOGoIMAPServer = localhost;
SOGoLanguage = French;
SOGoMailDomain = tazou.dyndns.org;
SOGoMailingMechanism = smtp;
SOGoProfileURL = 
mysql://sogo:s...@localhost:3306/sogo/sogo_user_profile;

SOGoSMTPServer = localhost;
SOGoSentFolderName = Sent;
SOGoTimeZone = Europe/Paris;
SOGoTrashFolderName = Trash;
};
}


For MySQL configuration, I did :
mysql -p
create database sogo CHARSET='UTF8';
CREATE USER 'sogo'@'localhost' IDENTIFIED BY 'sogo';
GRANT ALL PRIVILEGES ON `sogo`.* TO 'sogo'@'localhost' WITH GRANT 
OPTION;

FLUSH PRIVILEGES;

What about sogo_view? It won't be created and populated with the right 
information automagically. Something like that might help:


mysql  USE sogo;
mysql  CREATE TABLE sogo_view (c_uid VARCHAR(10) PRIMARY KEY, c_name 
VARCHAR(10), c_password VARCHAR(32), c_cn VARCHAR(128), mail VARCHAR(128));
mysql  INSERT INTO sogo_view VALUES ('alice', 'alice', MD5('secret'), 'Alice 
Thompson', 'al...@acme.com');
mysql  INSERT INTO sogo_view VALUES ('bob', 'bob', MD5('secret'), 'Bob Smith', 
'b...@acme.com');
mysql  INSERT INTO sogo_view VALUES ('chris', 'chris', MD5('secret'), 'Chris 
Cooper', 'ch...@acme.com');
I do it, and now the logs are not the same, when I login with alice 
and secret, the logs say :


Oct 07 05:32:03 sogod: SOGo watchdog [2162]: 

Re: [SOGo] Login on Sogo webinterface

2010-10-06 Thread Ludovic Marcotte

 On 10-10-06 9:38 PM, Guillaume Dualé wrote:


Did I do something wrong ?

Is my .GNUstepDefaults  file correct ?


No, your SOGoUserSources is not in the sogod domain.

--
Ludovic Marcotte
lmarco...@inverse.ca  ::  +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] BTS activities for Wednesday, October 06 2010

2010-10-06 Thread SOGo reporter
Title: BTS activities for Wednesday, October 06 2010





  
BTS Activities

  Home page: http://www.sogo.nu/bugs
  Project: SOGo
  For the period covering: Wednesday, October 06 2010

  
  
idlast updatestatus (resolution)categorysummary
	
	
	  
	
888
	2010-10-06 08:46:38
	new (open)
	GUI
	Authentication with MySQL
	
	  
	
881
	2010-10-06 02:13:14
	new (open)
	Web Address Book
	Export Address Book
	
	  
	
886
	2010-10-06 05:44:53
	new (open)
	Web Mail
	Need button to change encoding
	
	  
	
887
	2010-10-06 05:43:44
	new (open)
	Web Mail
	Need button to change encoding
	
	  
	
756
	2010-10-06 16:03:59
	feedback (reopened)
	Backend Calendar
	Groups are not usable in practice