Re: [SOGo] Login on Sogo webinterface
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
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
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
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
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
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