RE: [SOGo] Error in sogo.conf, SOGoUserSources

2014-10-31 Thread DOUTEAUX Guillaume
Ok, i test it.

How to use this command ?

Just do : plparse /etc/sogo/sogo.conf

Parsing '/etc/sogo/sogo.conf' - Parse failed  - Parse failed at line 1 (char 
16) - extra data after parsed string
Ligne 1 is :
SOGoProfileURL = 
mysql://xxx:x...@smtp.xxx.local:3306/sogodb/sogo_user_profile;


-Message d'origine-
De : users-requ...@sogo.nu [mailto:users-requ...@sogo.nu] De la part de Jens 
Erat
Envoyé : vendredi 31 octobre 2014 13:22
À : users@sogo.nu; gdoute...@fede76.admr.org
Objet : Re: [SOGo] Error in sogo.conf, SOGoUserSources

The snippet seems valid on first sight. `plparse` sometimes helps at
finding the problem by giving more detailed messages on the syntax error
location.

Am 31.10.2014 um 13:14 schrieb mar...@netson.sk:
 For me this was happening when = symbol was missing in one of my config 
 statements. 
 
 Odoslané z iPhonu
 
 Dňa 31.10.2014, o 12:25, gdoute...@fede76.admr.org 
 gdoute...@fede76.admr.org napísal:
 
 Hi,

 I have a problem with my configuration.

 When i start SOGo i have this error :

 File NSDictionary.m: 625. In -[NSDictionary initWithContentsOfFile:] Contents
 of file '/etc/sogo/sogo.conf' does not contain a dictionary
 0x0xb95b7cd8[SOGoStartupLogger] Cannot read configuration from '/etc/sogo/
 sogo.conf'. Aborting

 When i comment this in the config SOGo start.

 SOGoUserSources = (
{
  type = sql;
  id = postfixadmin;
  viewURL =
 mysql://xxx:x...@smtp..local:3306/postfixadmin/sogo_users;
  canAuthenticate = YES;
  isAddressBook = YES;
  userPasswordAlgorithm = md5-crypt;
  displayName = Messagerie;
  DomainFieldName = domain;
  IMAPLoginFieldName = c_name;
  LoginFieldNames = (
  c_uid,
  c_name
  );
}
  );

 I don't find my error can you help me ??
 -- 
 users@sogo.nu
 https://inverse.ca/sogo/lists


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

[SOGo] unsuscribe

2012-09-03 Thread Guillaume JULLIEN

  
  

-- 
  
   Guillaume JULLIEN




  

  Mobile
  06 24 68 25 24


  Fax
  05 57 96 83 58


  Mail  
  g.jull...@aquilog.fr


  Web
  www.aquilog.fr

  

  

  



[SOGo] Configuration

2012-08-28 Thread Guillaume JULLIEN

  
  
Hello,

New to sogo I'm trying to make it work on ubuntu 12.04
I installed sogo 1.3.17-1 from apt-get
database is postgresql 9.1
auhentification is on openldap

If I try to log on web interface, I get "bad user name or password"

In sogo.log, I have :
===
Aug 28 20:10:35 sogod [8463]: version 1.3.17 (build
@vizzini.inverse.ca 201207251926) -- starting
Aug 28 20:10:35 sogod [8463]: vmem size check enabled: shutting down
app when vmem  384 MB
Aug 28 20:10:35 sogod [8463]: 0x0x95b17f0[SOGoProductLoader]
SOGo products loaded from '/usr/lib/GNUstep/SOGo':
Aug 28 20:10:35 sogod [8463]:
0x0x95b17f0[SOGoProductLoader] Appointments.SOGo,
MainUI.SOGo, MailerUI.SOGo, Mailer.SOGo, ContactsUI.SOGo,
MailPartViewers.SOGo, CommonUI.SOGo, SchedulerUI.SOGo,
PreferencesUI.SOGo, Contacts.SOGo, AdministrationUI.SOGo
Aug 28 20:10:35 sogod [8463]: 0x0x96d4290[WOWatchDog]
listening on *:2
Aug 28 20:10:35 sogod [8463]: 0x0x96d4290[WOWatchDog]
watchdog process pid: 8463
Aug 28 20:10:35 sogod [8463]: 0x0xb74feda0[WOWatchDogChild]
watchdog request timeout set to 10 minutes
Aug 28 20:10:35 sogod [8463]: 0x0x96d4290[WOWatchDog]
preparing 1 children
Aug 28 20:10:35 sogod [8463]: 0x0x96d4290[WOWatchDog] child
spawned with pid 8466
2012-08-28 20:11:11.104 sogod[8466] Note: Using UTF-8 as URL
encoding in NGExtensions.
Aug 28 20:11:11 sogod [8466]: 0x0x983e7e0[SOGoCache] Cache
cleanup interval set every 300.00 seconds
Aug 28 20:11:11 sogod [8466]: 0x0x983e7e0[SOGoCache] Using
host(s) 'localhost' as server(s)
2012-08-28 20:11:11.105 sogod[8466] Note(SoObject): SoDebugKeyLookup
is enabled!
2012-08-28 20:11:11.105 sogod[8466] Note(SoObject): SoDebugBaseURL
is enabled!
2012-08-28 20:11:11.105 sogod[8466] Note(SoObject): relative base
URLs are enabled.
2012-08-28 20:11:11.108 sogod[8466] ERROR(-[NGBundleManager
bundleWithPath:]): could not create bundle for path:
'/usr/share/GNUstep/Libraries/gnustep-base/Versions/1.22/Resources/SSL.bundle'
2012-08-28 20:11:11.114 sogod[8466] WOxElemBuilder: could not locate
builders: WOxExtElemBuilder,WOxExtElemBuilder
2012-08-28 20:11:11.114 sogod[8466] WOCompoundElement: pool
embedding is on.
2012-08-28 20:11:11.114 sogod[8466] WOCompoundElement: id logging is
on.
Aug 28 20:11:11 sogod [8466]: SOGoRootPage Login for user 'myuser'
might not have worked - password policy: 65535 grace: -1 expire:
-1 bound: 0
localhost - - [28/Aug/2012:20:11:11 GMT] "POST /SOGo/connect
HTTP/1.1" 403 34/68 0.016 - - 2M
==

File :
/usr/share/GNUstep/Libraries/gnustep-base/Versions/1.22/Resources/SSL.bundle
is not there.

Can you help me ?

Best regards,

    -- 
      
   Guillaume JULLIEN




  

  Mobile
  06 24 68 25 24


  Fax
  05 57 96 83 58


  Mail
  g.jull...@aquilog.fr


  Web
  www.aquilog.fr

  

  

  



[SOGo] SOGoRootPage Login for user 'myuser' might not have worked - password policy: 65535 grace: -1 expire: -1 bound: 0

2012-06-03 Thread Guillaume JULLIEN

Hello,

No way to login on web interface.

Can you help me ? I could find any working solution to my problem.

Platform : ubuntu Ubuntu 11.04
SOGo : 1.3.15
Postgresql : 8.4
openldap : 2.4.23

*In /etc/ldap/slapd.conf, I have*
...
suffix dc=domain,dc=fr
rootdn   cn=manager,dc=domain,dc=fr
...

*Here is a user ldap account :*
26 cn=John Doe,ou=users,dc=domain,dc=fr
objectClass: sambaSamAccount
objectClass: posixAccount
objectClass: inetOrgPerson
objectClass: organizationalPerson
objectClass: person
...
uid: myuser
cn: John Doe
uidNumber: 5040
mail: j...@domain.fr
sn: Doe
givenName: John

*And my (sogo) GNUstep/Defaults/.GNUstepDefaults configuration file :*
...
keySOGoUserSources/key
array
dict
keyCNFieldName/key
stringcn/string
keyIDFieldName/key
stringcn/string
keyIMAPHostFieldName/key
stringmailHost/string
keyUIDFieldName/key
stringuid/string
keybaseDN/key
stringou=users,dc=domain,dc=fr/string
keybindDN/key
stringcn=manager,dc=domain,dc=fr/string
keybindPassword/key
stringsecret/string
keycanAuthenticate/key
stringYES/string
keydisplayName/key
stringShared adresses/string
keyhostname/key
stringlocalhost/string
keyid/key
stringpublic/string
keyisAddressBook/key
stringYES/string
keyport/key
string389/string
/dict
/array
...

Thanks in advance,

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

Re: [SOGo] ANN: SOGo v2.0.0rc1 with Native Outlook Compatibility

2012-04-13 Thread Guillaume
On 04/12/12 00:07, Fabian Rodriguez wrote:
 Le 12-04-11 05:03 PM, Martin Rabl a écrit :
 [...]

 P.S.: will there be a package for Ubuntu 10.04 LTS in future?
 
 Maybe someone can fund Jeroen's work in Debian?:
 http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=584073
 
 I'd love to see proper packaging for Debian+derivatives, but it's not
 going to happen anytime soon, specially the way SOGo relies on
 unsupported, manually-installed packages both in ZEG and the regular
 releases. This prevents any type of vendor-provided (ie. Canonical,etc.)
 commercial support and ties your production systems to Inverse's support
 which I was told would change its model but hasn't in a while.
 
 Perhaps Ludovic can provide an update on this situation?
 
 F.

Some Unix have done their homework

http://openports.se/www/sogo

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


[SOGo] DB structure documentation

2011-10-19 Thread Guillaume Van der Schueren
Dear All,

Is there any database structure documentation for sogo ? I couldn't find
anything on sogo's websites nor on mtn. Sorry in advance if I missed
something.
I'm thinking of resurrecting the z-push backend for sogo. Diving into
reverse engineering can be fun but it's unproductive...

Best regards,

-- 
Guillaume Van der Schueren

IT-Optics s.a.
Boulevard Initialis, 28
7000 Mons
TVA: BE473274282 /  RC: MONS 143271

-- 
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 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