Re: [SOGo] Login Problem on SOGO Fresh Instal

2013-09-09 Thread Christian Mack
Hello mrito


Am 2013-08-31 16:03, schrieb mr...@mail.altcladding.com.ph:
> Thanks for your help Christian. I just realized that I forgot to create a
> sogo database and that is the reason I am receiving the error message.
> 
> Going forward, I've created an ldap user test1 & test2 but when I login on
> my Sogo Portal it still do not allow me to login. Then as per checking on
> the log, I receive the following error messages:
> Aug 31 09:31:22 sogod [2207]: [ERROR] <0x0xb4d2f04c[LDAPSource]>
>  NAME:LDAPException REASON:operation bind failed:
> Invalid credentials (0x31) INFO:{login =
> "uid=sogo,ou=admin,dc=oc,dc=local"; }
> Aug 31 09:31:22 sogod [2207]: SOGoRootPage Login from '192.168.43.10' for
> user 'admin' might not have worked - password policy: 65535  grace: -1 
> expire: -1  bound: 0
< ... >
> 
> Below if my LDAP config on sogo.conf:
> /* LDAP authentication example */
>   SOGoUserSources = (
> {
>   type = ldap;
>   CNFieldName = cn;
>   UIDFieldName = uid;
>   IDFieldName = uid; // first field of the DN for direct binds
>   bindFields = (uid, mail); // array of fields to use for indirect binds
>   baseDN = "ou=people,dc=oc,dc=local";
>   //bindDN = "uid=test2,dc=oc,dc=local";
>   bindDN = "dc=oc,dc=local";
>   bindPassword = 1687056;
>   canAuthenticate = YES;
>   displayName = "Shared Addresses";
>   hostname = "ldap://127.0.0.1:389";;
>   id = public;
>   isAddressBook = YES;
> }
>   );
> 
> I would appreciate if you could help me again.
> 

Your setting in bindDN doesn't match the error message.
Your config states
bindDN = "dc=oc,dc=local";
which is obviously not a valid user in LDAP at all.

but your error message tells
"uid=sogo,ou=admin,dc=oc,dc=local"

bindDN must contain a valid user in LDAP, which has permissions to at
least read all users.
The password given in bindPassword has to match the user in bindDN.

Also I assume you didn't restart sogod after changing these settings.


Kind regards,
Christian Mack

-- 
Christian Mack
Gruppe Informationsdienste
Rechenzentrum Universität Konstanz
-- 
users@sogo.nu
https://inverse.ca/sogo/lists


Re: [SOGo] Login Problem on SOGO Fresh Instal

2013-08-31 Thread mrito
Thanks for your help Christian. I just realized that I forgot to create a
sogo database and that is the reason I am receiving the error message.

Going forward, I've created an ldap user test1 & test2 but when I login on
my Sogo Portal it still do not allow me to login. Then as per checking on
the log, I receive the following error messages:
Aug 31 09:31:22 sogod [2207]: [ERROR] <0x0xb4d2f04c[LDAPSource]>
 NAME:LDAPException REASON:operation bind failed:
Invalid credentials (0x31) INFO:{login =
"uid=sogo,ou=admin,dc=oc,dc=local"; }
Aug 31 09:31:22 sogod [2207]: SOGoRootPage Login from '192.168.43.10' for
user 'admin' might not have worked - password policy: 65535  grace: -1 
expire: -1  bound: 0
192.168.43.10 - - [31/Aug/2013:09:31:22 GMT] "POST /SOGo/connect HTTP/1.1"
403 34/60 0.025 - - 0
Aug 31 09:32:16 sogod [2206]: <0x0xb50bc31c[WOWatchDog]> Terminating with
SIGINT or SIGTERM
Aug 31 09:32:16 sogod [2206]: <0x0xb50cbe34[WOWatchDogChild]> sending
terminate signal to pid 2207
Aug 31 09:32:16 sogod [2206]: <0x0xb50bc31c[WOWatchDog]> Terminating with
SIGINT or SIGTERM
Aug 31 09:32:16 sogod [2206]: <0x0xb50bc31c[WOWatchDog]> Terminating with
SIGINT or SIGTERM
Aug 31 09:32:16 sogod [2206]: <0x0xb50cbe34[WOWatchDogChild]> child 2207
exited
Aug 31 09:32:16 sogod [2206]: <0x0xb50bc31c[WOWatchDog]> all children
exited. We now terminate.
Aug 31 09:32:17 sogod [2467]: version 2.0.7 (build root@shiva.inverse
201307220922) -- starting
Aug 31 09:32:17 sogod [2467]: vmem size check enabled: shutting down app
when vmem > 384 MB
Aug 31 09:32:17 sogod [2467]: <0x0xb66ac894[SOGoProductLoader]> SOGo
products loaded from '/usr/lib/GNUstep/SOGo':
Aug 31 09:32:17 sogod [2467]: <0x0xb66ac894[SOGoProductLoader]>  
MailPartViewers.SOGo, PreferencesUI.SOGo, Appointments.SOGo, Mailer.SOGo,
SchedulerUI.SOGo, MainUI.SOGo, Contacts.SOGo, AdministrationUI.SOGo,
MailerUI.SOGo, ContactsUI.SOGo, CommonUI.SOGo
Aug 31 09:32:17 sogod [2467]: <0x0xb65af314[WOWatchDog]> listening on *:2
Aug 31 09:32:17 sogod [2467]: <0x0xb65af314[WOWatchDog]> watchdog process
pid: 2467
Aug 31 09:32:17 sogod [2467]: <0x0x7a6940[WOWatchDogChild]> watchdog
request timeout set to 10 minutes
Aug 31 09:32:17 sogod [2467]: <0x0xb65af314[WOWatchDog]> preparing 1 children
Aug 31 09:32:17 sogod [2467]: <0x0xb65af314[WOWatchDog]> child spawned
with pid 2468
Aug 31 09:32:50 sogod [2468]: <0x0xb646d29c[SOGoCache]> Cache cleanup
interval set every 300.00 seconds
Aug 31 09:32:50 sogod [2468]: <0x0xb646d29c[SOGoCache]> Using host(s)
'localhost' as server(s)
Aug 31 09:32:50 sogod [2468]: [ERROR] [we-rm] did not find locale for
language: fil
Aug 31 09:32:50 sogod [2468]: [ERROR] [we-rm] did not find locale for
language: fil-PH
Aug 31 09:32:50 sogod [2468]: [ERROR] [we-rm] did not find locale for
language: Tagalog
2013-08-31 09:32:50.163 sogod[2468] Note(SoObject): SoDebugKeyLookup is
enabled!
2013-08-31 09:32:50.165 sogod[2468] Note(SoObject): SoDebugBaseURL is
enabled!
2013-08-31 09:32:50.166 sogod[2468] Note(SoObject): relative base URLs are
enabled.
2013-08-31 09:32:50.245 sogod[2468] WOCompoundElement: pool embedding is on.
2013-08-31 09:32:50.245 sogod[2468] WOCompoundElement: id logging is on.
2013-08-31 09:32:50.330 sogod[2468] WARNING(-[NSNull(misc) count]): called
NSNull -count (returns 0) !!!
192.168.43.10 - - [31/Aug/2013:09:32:50 GMT] "GET /SOGo/ HTTP/1.1" 200
3921/0 0.292 11829 66% 3M
Aug 31 09:32:57 sogod [2468]: [ERROR] [we-rm] did not find locale for
language: fil
Aug 31 09:32:57 sogod [2468]: [ERROR] [we-rm] did not find locale for
language: fil-PH
Aug 31 09:32:57 sogod [2468]: [ERROR] [we-rm] did not find locale for
language: Tagalog
Aug 31 09:32:57 sogod [2468]: [ERROR] <0x0xb64e704c[LDAPSource]> Could not
bind to the LDAP server ldap://127.0.0.1:389 (389) using the bind DN:
uid=test2,dc=oc,dc=local
Aug 31 09:32:57 sogod [2468]: [ERROR] <0x0xb64e704c[LDAPSource]>
 NAME:LDAPException REASON:operation bind failed:
Invalid credentials (0x31) INFO:{login = "uid=test2,dc=oc,dc=local"; }
Aug 31 09:32:57 sogod [2468]: SOGoRootPage Login from '192.168.43.10' for
user 'test2' might not have worked - password policy: 65535  grace: -1 
expire: -1  bound: 0
192.168.43.10 - - [31/Aug/2013:09:32:57 GMT] "POST /SOGo/connect HTTP/1.1"
403 34/40 0.045 - - 536K
Aug 31 09:32:59 sogod [2468]: [ERROR] [we-rm] did not find locale for
language: fil
Aug 31 09:32:59 sogod [2468]: [ERROR] [we-rm] did not find locale for
language: fil-PH
Aug 31 09:32:59 sogod [2468]: [ERROR] [we-rm] did not find locale for
language: Tagalog

Below if my LDAP config on sogo.conf:
/* LDAP authentication example */
  SOGoUserSources = (
{
  type = ldap;
  CNFieldName = cn;
  UIDFieldName = uid;
  IDFieldName = uid; // first field of the DN for direct binds
  bindFields = (uid, mail); // array of fields to use for indirect binds
  baseDN = "ou=people,dc=oc,dc=local";
  //bindDN = "uid=test2,dc=oc,dc=local";
  bindDN = "dc=oc,dc=local";
  bindPassword = 16870

Re: [SOGo] Login Problem on SOGO Fresh Instal

2013-08-31 Thread mrito
Thanks for your help Christian. I just realized that I forgot to create a
sogo database and that is the reason I am receiving the error message.

Going forward, I've created an ldap user test1 & test2 but when I login on
my Sogo Portal it still do not allow me to login. Then as per checking on
the log, I receive the following error messages:
Aug 31 09:31:22 sogod [2207]: [ERROR] <0x0xb4d2f04c[LDAPSource]>
 NAME:LDAPException REASON:operation bind failed:
Invalid credentials (0x31) INFO:{login =
"uid=sogo,ou=admin,dc=oc,dc=local"; }
Aug 31 09:31:22 sogod [2207]: SOGoRootPage Login from '192.168.43.10' for
user 'admin' might not have worked - password policy: 65535  grace: -1 
expire: -1  bound: 0
192.168.43.10 - - [31/Aug/2013:09:31:22 GMT] "POST /SOGo/connect HTTP/1.1"
403 34/60 0.025 - - 0
Aug 31 09:32:16 sogod [2206]: <0x0xb50bc31c[WOWatchDog]> Terminating with
SIGINT or SIGTERM
Aug 31 09:32:16 sogod [2206]: <0x0xb50cbe34[WOWatchDogChild]> sending
terminate signal to pid 2207
Aug 31 09:32:16 sogod [2206]: <0x0xb50bc31c[WOWatchDog]> Terminating with
SIGINT or SIGTERM
Aug 31 09:32:16 sogod [2206]: <0x0xb50bc31c[WOWatchDog]> Terminating with
SIGINT or SIGTERM
Aug 31 09:32:16 sogod [2206]: <0x0xb50cbe34[WOWatchDogChild]> child 2207
exited
Aug 31 09:32:16 sogod [2206]: <0x0xb50bc31c[WOWatchDog]> all children
exited. We now terminate.
Aug 31 09:32:17 sogod [2467]: version 2.0.7 (build root@shiva.inverse
201307220922) -- starting
Aug 31 09:32:17 sogod [2467]: vmem size check enabled: shutting down app
when vmem > 384 MB
Aug 31 09:32:17 sogod [2467]: <0x0xb66ac894[SOGoProductLoader]> SOGo
products loaded from '/usr/lib/GNUstep/SOGo':
Aug 31 09:32:17 sogod [2467]: <0x0xb66ac894[SOGoProductLoader]>  
MailPartViewers.SOGo, PreferencesUI.SOGo, Appointments.SOGo, Mailer.SOGo,
SchedulerUI.SOGo, MainUI.SOGo, Contacts.SOGo, AdministrationUI.SOGo,
MailerUI.SOGo, ContactsUI.SOGo, CommonUI.SOGo
Aug 31 09:32:17 sogod [2467]: <0x0xb65af314[WOWatchDog]> listening on *:2
Aug 31 09:32:17 sogod [2467]: <0x0xb65af314[WOWatchDog]> watchdog process
pid: 2467
Aug 31 09:32:17 sogod [2467]: <0x0x7a6940[WOWatchDogChild]> watchdog
request timeout set to 10 minutes
Aug 31 09:32:17 sogod [2467]: <0x0xb65af314[WOWatchDog]> preparing 1 children
Aug 31 09:32:17 sogod [2467]: <0x0xb65af314[WOWatchDog]> child spawned
with pid 2468
Aug 31 09:32:50 sogod [2468]: <0x0xb646d29c[SOGoCache]> Cache cleanup
interval set every 300.00 seconds
Aug 31 09:32:50 sogod [2468]: <0x0xb646d29c[SOGoCache]> Using host(s)
'localhost' as server(s)
Aug 31 09:32:50 sogod [2468]: [ERROR] [we-rm] did not find locale for
language: fil
Aug 31 09:32:50 sogod [2468]: [ERROR] [we-rm] did not find locale for
language: fil-PH
Aug 31 09:32:50 sogod [2468]: [ERROR] [we-rm] did not find locale for
language: Tagalog
2013-08-31 09:32:50.163 sogod[2468] Note(SoObject): SoDebugKeyLookup is
enabled!
2013-08-31 09:32:50.165 sogod[2468] Note(SoObject): SoDebugBaseURL is
enabled!
2013-08-31 09:32:50.166 sogod[2468] Note(SoObject): relative base URLs are
enabled.
2013-08-31 09:32:50.245 sogod[2468] WOCompoundElement: pool embedding is on.
2013-08-31 09:32:50.245 sogod[2468] WOCompoundElement: id logging is on.
2013-08-31 09:32:50.330 sogod[2468] WARNING(-[NSNull(misc) count]): called
NSNull -count (returns 0) !!!
192.168.43.10 - - [31/Aug/2013:09:32:50 GMT] "GET /SOGo/ HTTP/1.1" 200
3921/0 0.292 11829 66% 3M
Aug 31 09:32:57 sogod [2468]: [ERROR] [we-rm] did not find locale for
language: fil
Aug 31 09:32:57 sogod [2468]: [ERROR] [we-rm] did not find locale for
language: fil-PH
Aug 31 09:32:57 sogod [2468]: [ERROR] [we-rm] did not find locale for
language: Tagalog
Aug 31 09:32:57 sogod [2468]: [ERROR] <0x0xb64e704c[LDAPSource]> Could not
bind to the LDAP server ldap://127.0.0.1:389 (389) using the bind DN:
uid=test2,dc=oc,dc=local
Aug 31 09:32:57 sogod [2468]: [ERROR] <0x0xb64e704c[LDAPSource]>
 NAME:LDAPException REASON:operation bind failed:
Invalid credentials (0x31) INFO:{login = "uid=test2,dc=oc,dc=local"; }
Aug 31 09:32:57 sogod [2468]: SOGoRootPage Login from '192.168.43.10' for
user 'test2' might not have worked - password policy: 65535  grace: -1 
expire: -1  bound: 0
192.168.43.10 - - [31/Aug/2013:09:32:57 GMT] "POST /SOGo/connect HTTP/1.1"
403 34/40 0.045 - - 536K
Aug 31 09:32:59 sogod [2468]: [ERROR] [we-rm] did not find locale for
language: fil
Aug 31 09:32:59 sogod [2468]: [ERROR] [we-rm] did not find locale for
language: fil-PH
Aug 31 09:32:59 sogod [2468]: [ERROR] [we-rm] did not find locale for
language: Tagalog

Below if my LDAP config on sogo.conf:
/* LDAP authentication example */
  SOGoUserSources = (
{
  type = ldap;
  CNFieldName = cn;
  UIDFieldName = uid;
  IDFieldName = uid; // first field of the DN for direct binds
  bindFields = (uid, mail); // array of fields to use for indirect binds
  baseDN = "ou=people,dc=oc,dc=local";
  //bindDN = "uid=test2,dc=oc,dc=local";
  bindDN = "dc=oc,dc=local";
  bindPassword = 16870

Re: [SOGo] Login Problem on SOGO Fresh Instal

2013-08-28 Thread Christian Mack
Am 2013-08-28 13:14, schrieb Malvin Rito:
> Hi All,
> 
> I'm new to SOGO and I'm trying to setup SOGO new install on CentOS for
> the first time. I was able to launch now the Sogo http://localhost/SOGo
> but cannot login using my credentials on LDAP. I can see the following
> message on SOGO log:
> 
> Aug 28 07:10:50 sogod [6281]: <0x0x1938914[SOGoProductLoader]> SOGo
> products loaded from '/usr/lib/GNUstep/SOGo':
> Aug 28 07:10:50 sogod [6281]: <0x0x1938914[SOGoProductLoader]>  
> MailPartViewers.SOGo, PreferencesUI.SOGo, Appointments.SOGo,
> Mailer.SOGo, SchedulerUI.SOGo, MainUI.SOGo, Contacts.SOGo,
> AdministrationUI.SOGo, MailerUI.SOGo, ContactsUI.SOGo, CommonUI.SOGo
> Aug 28 07:10:50 sogod [6281]: <0x0x1a3b364[WOWatchDog]> listening on
> *:2
> Aug 28 07:10:50 sogod [6281]: <0x0x1a3b364[WOWatchDog]> watchdog process
> pid: 6281
> Aug 28 07:10:50 sogod [6281]: <0x0x71f940[WOWatchDogChild]> watchdog
> request timeout set to 10 minutes
> Aug 28 07:10:50 sogod [6281]: <0x0x1a3b364[WOWatchDog]> preparing 1
> children
> Aug 28 07:10:50 sogod [6281]: <0x0x1a3b364[WOWatchDog]> child spawned
> with pid 6282
> 2013-08-28 07:10:50.437 sogod[6282] could not open channel to
> sogo@localhost
> Aug 28 07:10:50 sogod [6282]: [ERROR] <0x0x19b419c[GCSChannelManager]>
> could not open channel <0x0x1a0081c[PostgreSQL72Channel]: not-connected>
> for URL: postgresql://sogo:1687056@localhost/sogo/sogo_user_profile
> Aug 28 07:10:50 sogod [6282]: [WARN] <0x0x19b419c[GCSChannelManager]>  
> will prevent opening of this channel 5 seconds after 2013-08-28 07:10:50
> -0400
> [root@sogo ~]#
> 

Is your postgresql database running on localhost?
Can you log into it with the given credentials user=sogo password=1687056 ?


Kind regards,
Christian Mack

PS:
Please don't hijack other threads by answering and modifying subjects!
Instead write a new email when starting a new topic.

-- 
Christian Mack
Gruppe Informationsdienste
Rechenzentrum Universität Konstanz
-- 
users@sogo.nu
https://inverse.ca/sogo/lists


[SOGo] Login Problem on SOGO Fresh Instal

2013-08-28 Thread Malvin Rito

Hi All,

I'm new to SOGO and I'm trying to setup SOGO new install on CentOS for 
the first time. I was able to launch now the Sogo http://localhost/SOGo 
but cannot login using my credentials on LDAP. I can see the following 
message on SOGO log:


Aug 28 07:10:50 sogod [6281]: <0x0x1938914[SOGoProductLoader]> SOGo 
products loaded from '/usr/lib/GNUstep/SOGo':
Aug 28 07:10:50 sogod [6281]: <0x0x1938914[SOGoProductLoader]>   
MailPartViewers.SOGo, PreferencesUI.SOGo, Appointments.SOGo, 
Mailer.SOGo, SchedulerUI.SOGo, MainUI.SOGo, Contacts.SOGo, 
AdministrationUI.SOGo, MailerUI.SOGo, ContactsUI.SOGo, CommonUI.SOGo

Aug 28 07:10:50 sogod [6281]: <0x0x1a3b364[WOWatchDog]> listening on *:2
Aug 28 07:10:50 sogod [6281]: <0x0x1a3b364[WOWatchDog]> watchdog process 
pid: 6281
Aug 28 07:10:50 sogod [6281]: <0x0x71f940[WOWatchDogChild]> watchdog 
request timeout set to 10 minutes

Aug 28 07:10:50 sogod [6281]: <0x0x1a3b364[WOWatchDog]> preparing 1 children
Aug 28 07:10:50 sogod [6281]: <0x0x1a3b364[WOWatchDog]> child spawned 
with pid 6282

2013-08-28 07:10:50.437 sogod[6282] could not open channel to sogo@localhost
Aug 28 07:10:50 sogod [6282]: [ERROR] <0x0x19b419c[GCSChannelManager]> 
could not open channel <0x0x1a0081c[PostgreSQL72Channel]: not-connected> 
for URL: postgresql://sogo:1687056@localhost/sogo/sogo_user_profile
Aug 28 07:10:50 sogod [6282]: [WARN] <0x0x19b419c[GCSChannelManager]>   
will prevent opening of this channel 5 seconds after 2013-08-28 07:10:50 
-0400

[root@sogo ~]#


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