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:20000 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 *:20000
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:20000 I can see it
in log file :
Oct 07 01:04:04 sogod: SOGo watchdog [4528]: <0x0x9bc90d8[SOGoCache]>
Cache cleanup interval set every 300.000000 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:[email protected]: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', '[email protected]');
mysql> INSERT INTO sogo_view VALUES ('bob', 'bob', MD5('secret'), 'Bob Smith',
'[email protected]');
mysql> INSERT INTO sogo_view VALUES ('chris', 'chris', MD5('secret'), 'Chris
Cooper', '[email protected]');
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]: SOGoRootPage Login for user
'alice' might not have worked - password policy: 65535 grace: -1
expire: -1 bound: 0
Did I do something wrong ?
Is my ".GNUstepDefaults " file correct ?
Thank you Ludovic,
Regards,
Guillaume.
Regards,
--
Ludovic Marcotte
[email protected] :: +1.514.755.3630 ::www.inverse.ca
Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence
(www.packetfence.org)
--
[email protected]
https://inverse.ca/sogo/lists
