Re: [SOGo] Login on Sogo webinterface

2010-10-07 Thread g . duale
   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

Hi,
ok thanks, I will try this evening :)
Guillaume.

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


Re: [SOGo] Login on Sogo webinterface

2010-10-07 Thread Guillaume Dualé

On 07/10/2010 13:45, g.du...@otasc.org wrote:

   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
 

Hi,
ok thanks, I will try this evening :)
Guillaume.

   

Hi,
thanks for your help !
I can login in Sogo now :)
Thanks Ludovic !
Guillaume.
--
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