Koozali.org: home of the SME Server

Horde -> Organizing -> Address Book -> Local LDAP

Offline mgic_box

  • ***
  • 52
  • +0/-0
Horde -> Organizing -> Address Book -> Local LDAP
« on: June 13, 2008, 04:13:47 PM »

  Hello,

  I don't know how, nor why, but the list of contacts on Horde, under Organizing -> Address Book -> Local LDAP, that should show all the LDAP users on the system, appears empty.

  Everything else, apparently, is working, all the users can read and send e-mails, on the SME control panel all of them appears listed there... and so on...

  SO, Is there something we can do, to recreate de contacts under Horde -> Organizing -> Address Book -> Local LDAP, from what is on the system?

  Thanks in advance.

 
« Last Edit: June 13, 2008, 04:16:22 PM by mgic_box »

Offline mrjhb3

  • *
  • 1,188
  • +0/-0
    • John Bennett Services
Re: Horde -> Organizing -> Address Book -> Local LDAP
« Reply #1 on: June 14, 2008, 03:25:09 AM »
Did you make any changes to turba/config/sources.php?  What does /var/log/messages show when you try to query address book?  Those entries are the users that have been added to SME.  You aren't trying to use SME8 are you?

John
......

Offline mgic_box

  • ***
  • 52
  • +0/-0
Re: Horde -> Organizing -> Address Book -> Local LDAP
« Reply #2 on: June 16, 2008, 11:46:52 AM »
Did you make any changes to turba/config/sources.php?  What does /var/log/messages show when you try to query address book?  Those entries are the users that have been added to SME.  You aren't trying to use SME8 are you?

John

 Hello, mrjhb3,

  Thank you fro tour reply.

  Can you tell me where is the "turba/config/sources.php", as I think the path you gave me was not the abssolute phat, and I do not know where to find it:


Code: [Select]

login as: root
root@mail's password:
Last login: Fri Jun 13 10:54:01 2008 from pc-00116.egasmoniz.edu.pt
[root@mira ~]# vi turba/config/sources.php
[root@mira ~]# cd /
[root@mira /]# vi turba/config/sources.php
[root@mira /]#



> What does /var/log/messages show

Code: [Select]
Jun 16 10:39:13 mira HORDE[7622]: [imp] Login success for jse@egasmoniz.edu.pt [192.168.1.17] to {localhost:143} [on line 154 of "/home/httpd/html/horde/imp/redirect.php"]
Jun 16 10:39:13 mira slapd[24862]: conn=378 fd=7 ACCEPT from IP=127.0.0.1:34064 (IP=0.0.0.0:389)
Jun 16 10:39:13 mira slapd[24862]: conn=378 op=0 BIND dn="" method=128
Jun 16 10:39:13 mira slapd[24862]: conn=378 op=0 RESULT tag=97 err=0 text=
Jun 16 10:39:14 mira slapd[24862]: conn=378 op=1 UNBIND
Jun 16 10:39:14 mira slapd[24862]: conn=378 fd=7 closed
Jun 16 10:39:21 mira slapd[24862]: conn=379 fd=7 ACCEPT from IP=127.0.0.1:34066 (IP=0.0.0.0:389)
Jun 16 10:39:21 mira slapd[24862]: conn=379 op=0 BIND dn="" method=128
Jun 16 10:39:21 mira slapd[24862]: conn=379 op=0 RESULT tag=97 err=0 text=
Jun 16 10:39:21 mira slapd[24862]: conn=379 op=1 SRCH base="dc=egas,dc=edu,dc=pt" scope=1 deref=0 filter="(|(objectClass=top)(objectClass=person)(objectClass=organizationalPerson)(objectClass=inetOrgPerson))"
Jun 16 10:39:21 mira slapd[24862]: conn=379 op=1 SRCH attr=dn uid cn mail homephone telephonenumber mobiletelephonenumber homepostaladdress sn
Jun 16 10:39:21 mira slapd[24862]: conn=379 op=1 SEARCH RESULT tag=101 err=0 nentries=1 text=
Jun 16 10:39:21 mira slapd[24862]: conn=379 op=2 UNBIND
Jun 16 10:39:21 mira slapd[24862]: conn=379 fd=7 closed
Jun 16 10:39:26 mira slapd[24862]: conn=380 fd=7 ACCEPT from IP=127.0.0.1:34069 (IP=0.0.0.0:389)
Jun 16 10:39:26 mira slapd[24862]: conn=380 op=0 BIND dn="" method=128
Jun 16 10:39:26 mira slapd[24862]: conn=380 op=0 RESULT tag=97 err=0 text=
Jun 16 10:39:26 mira slapd[24862]: conn=380 op=1 SRCH base="uid=lcs,dc=egas,dc=edu,dc=pt" scope=0 deref=0 filter="(|(objectClass=top)(objectClass=person)(objectClass=organizationalPerson)(objectClass=inetOrgPerson))"
Jun 16 10:39:26 mira slapd[24862]: conn=380 op=1 SRCH attr=dn uid cn mail homephone telephonenumber mobiletelephonenumber homepostaladdress sn
Jun 16 10:39:26 mira slapd[24862]: conn=380 op=1 SEARCH RESULT tag=101 err=0 nentries=1 text=
Jun 16 10:39:26 mira slapd[24862]: conn=380 op=2 UNBIND
Jun 16 10:39:26 mira slapd[24862]: conn=380 fd=7 closed
[root@mira ~]#



>Those entries are the users that have been added to SME. 

I can only see the (one) user I added recently, but I lost about 80 older users.

>You aren't trying to use SME8 are you?

 I Have SME server Version 7.

 Regrds ant Thank you.




Offline mrjhb3

  • *
  • 1,188
  • +0/-0
    • John Bennett Services
Re: Horde -> Organizing -> Address Book -> Local LDAP
« Reply #3 on: June 16, 2008, 02:22:27 PM »
/home/httpd/html/horde/turba/config/sources.php

Why do you have this showing up in your log for a turba search?  It looks like you have another source defined.

Jun 16 10:39:26 mira slapd[24862]: conn=380 op=1 SRCH base="uid=lcs,dc=egas,dc=edu,dc=pt" scope=0 deref=0 filter="(|(objectClass=top)(objectClass=person)(objectClass=organizationalPerson)(objectClass=inetOrgPerson))"

By default, you should have two default sources defined.  One a localsql for everyone's personal address book and one localldap for the server added users.  There is nothing defined by default that uses the above source base.  if you can't figure out the issue, please post your sources.php file and the output of /sbin/e-smith/audittools/templates

John
......

Offline mgic_box

  • ***
  • 52
  • +0/-0
Re: Horde -> Organizing -> Address Book -> Local LDAP
« Reply #4 on: June 16, 2008, 04:35:33 PM »
/home/httpd/html/horde/turba/config/sources.php

Why do you have this showing up in your log for a turba search?  It looks like you have another source defined.

Jun 16 10:39:26 mira slapd[24862]: conn=380 op=1 SRCH base="uid=lcs,dc=egas,dc=edu,dc=pt" scope=0 deref=0 filter="(|(objectClass=top)(objectClass=person)(objectClass=organizationalPerson)(objectClass=inetOrgPerson))"

By default, you should have two default sources defined.  One a localsql for everyone's personal address book and one localldap for the server added users.  There is nothing defined by default that uses the above source base.  if you can't figure out the issue, please post your sources.php file and the output of /sbin/e-smith/audittools/templates

John




Code: [Select]

login as: root
root@mail's password:
Last login: Mon Jun 16 14:07:47 2008 from xxxx
[root@mira ~]# cat /home/httpd/html/horde/turba/config/sources.php
<?php
/*
#------------------------------------------------------------
#&#160; &#160; &#160; &#160; &#160; &#160; &#160; !!DO NOT MODIFY THIS FILE!!
#
# Manual changes will be lost when this file is regenerated.
#
# Please read the developer's guide, which is available
# at http://www.contribs.org/development/
#
# Copyright (C) 1999-2006 Mitel Networks Corporation
#------------------------------------------------------------
*/

//00header
/**
 * $Horde: turba/config/sources.php.dist,v 1.97.6.21 2006/08/23 15:07:11 selsky Exp $
 */
//40LocalSQL
/**
 * A local address book in an SQL database. This implements a per-user
 * address book.
 *
 * Be sure to create a turba_objects table in your Horde database
 * from the schema in turba/scripts/db/turba.sql if you use
 * this source.
 */
$cfgSources['localsql'] = array(
&
#160; &#160; 'title' => _("My Address Book"),
&#160; &#160; 'type' => 'sql',
&#160; &#160; // The default connection details are pulled from the Horde-wide
&#160; &#160; // SQL connection configuration.
&#160; &#160; //
&#160; &#160; // The old example illustrates how to use an alternate database
&#160; &#160; // configuration.
&#160; &#160; //
&#160; &#160; // New Example:
&#160; &#160; 'params' => array_merge($conf['sql'], array('table' => 'turba_objects')),

&#160; &#160; // Old Example:
&#160; &#160; // 'params' => array(
&#160; &#160; //&#160; &#160;  'phptype' => 'mysql',
&#160; &#160; //&#160; &#160;  'hostspec' => 'localhost',
&#160; &#160; //&#160; &#160;  'username' => 'horde',
&#160; &#160; //&#160; &#160;  'password' => '*****',
&#160; &#160; //&#160; &#160;  'database' => 'horde',
&#160; &#160; //&#160; &#160;  'table' => 'turba_objects',
&#160; &#160; //&#160; &#160;  'charset' => 'iso-8859-1'
&#160; &#160; // ),
&#160; &#160; 'map' => array(
&#160; &#160; &#160; &#160; '__key' => 'object_id',
&#160; &#160; &#160; &#160; '__owner' => 'owner_id',
&#160; &#160; &#160; &#160; '__type' => 'object_type',
&#160; &#160; &#160; &#160; '__members' => 'object_members',
&#160; &#160; &#160; &#160; '__uid' => 'object_uid',
&#160; &#160; &#160; &#160; 'name' => 'object_name',
&#160; &#160; &#160; &#160; 'email' => 'object_email',
&#160; &#160; &#160; &#160; 'alias' => 'object_alias',
&#160; &#160; &#160; &#160; 'homeAddress' => 'object_homeaddress',
&#160; &#160; &#160; &#160; 'workAddress' => 'object_workaddress',
&#160; &#160; &#160; &#160; 'homePhone' => 'object_homephone',
&#160; &#160; &#160; &#160; 'workPhone' => 'object_workphone',
&#160; &#160; &#160; &#160; 'cellPhone' => 'object_cellphone',
&#160; &#160; &#160; &#160; 'fax' => 'object_fax',
&#160; &#160; &#160; &#160; 'title' => 'object_title',
&#160; &#160; &#160; &#160; 'company' => 'object_company',
&#160; &#160; &#160; &#160; 'notes' => 'object_notes',
&#160; &#160; &#160; &#160; 'pgpPublicKey' => 'object_pgppublickey',
&#160; &#160; &#160; &#160; 'smimePublicKey' => 'object_smimepublickey',
&#160; &#160; &#160; &#160; 'freebusyUrl' => 'object_freebusyurl'
&#160; &#160; ),
&#160; &#160; 'search' => array(
&#160; &#160; &#160; &#160; 'name',
&#160; &#160; &#160; &#160; 'email'
&#160; &#160; ),
&#160; &#160; 'strict' => array(
&#160; &#160; &#160; &#160; 'object_id',
&#160; &#160; &#160; &#160; 'owner_id',
&#160; &#160; &#160; &#160; 'object_type',
&#160; &#160; ),
&#160; &#160; 'export' => true,
&#160; &#160; 'browse' => true,
&#160; &#160; 'use_shares' => false,
);

//50LocalLDAP
if (Util::extensionExists('ldap')) {

$cfgSources['localldap'] = array(
&
#160; &#160; 'title' => 'Local LDAP',
&#160; &#160; 'type' => 'ldap',
&#160; &#160; 'params' => array(
&#160; &#160; &#160; &#160; 'server' => 'localhost',
&#160; &#160; &#160; &#160; 'port' => 389,
&#160; &#160; &#160; &#160; 'tls' => false,
&#160; &#160; &#160; &#160; 'root' => 'dc=egas,dc=edu,dc=pt',
&#160; &#160; &#160; &#160; 'sizelimit' => 200,
&#160; &#160; &#160; &#160; 'dn' => array('cn'),
&#160; &#160; &#160; &#160; 'objectclass' => array('top',
&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;  'person',
&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;  'organizationalPerson','inetOrgPerson'),
&#160; &#160; &#160; &#160; 'scope' => 'one',
&#160; &#160; &#160; &#160; 'charset' => 'UTF-8',
&#160; &#160; &#160; &#160; // check if all required attributes for an entry are set and add them
&#160; &#160; &#160; &#160; // if needed.
&#160; &#160; &#160; &#160; 'checkrequired' => false,
&#160; &#160; &#160; &#160; // string to put in missing required attributes.
&#160; &#160; &#160; &#160; 'checkrequired_string' => ' ',
&#160; &#160; &#160; &#160; 'version' => 3
&#160; &#160; ),
&#160; &#160; 'map' => array(
&#160; &#160; &#160; &#160; '__key' => 'dn',
&#160; &#160; &#160; &#160; '__uid' => 'uid',
&#160; &#160; &#160; &#160; 'name' => 'cn',
&#160; &#160; &#160; &#160; 'email' => 'mail',
&#160; &#160; &#160; &#160; 'homePhone' => 'homephone',
&#160; &#160; &#160; &#160; 'workPhone' => 'telephonenumber',
&#160; &#160; &#160; &#160; 'cellPhone' => 'mobiletelephonenumber',
&#160; &#160; &#160; &#160; 'homeAddress' => 'homepostaladdress'
&#160; &#160; &#160; &#160; #freebusy is currently not enabled.&#160; To enable - config setprop horde freebusy enabled
&#160; &#160; ),
&#160; &#160; 'search' => array(
&#160; &#160; &#160; &#160; 'name',
&#160; &#160; &#160; &#160; 'email',
&#160; &#160; &#160; &#160; 'homePhone',
&#160; &#160; &#160; &#160; 'workPhone',
&#160; &#160; &#160; &#160; 'cellPhone',
&#160; &#160; &#160; &#160; 'homeAddress'
&#160; &#160; ),
&#160; &#160; 'strict' => array(
&#160; &#160; &#160; &#160; 'dn',
&#160; &#160; ),
&#160; &#160; 'export' => true,
&#160; &#160; 'browse' => true,
);
}
?>

[root@mira ~]#


« Last Edit: June 16, 2008, 04:37:15 PM by mgic_box »

Offline mrjhb3

  • *
  • 1,188
  • +0/-0
    • John Bennett Services
Re: Horde -> Organizing -> Address Book -> Local LDAP
« Reply #5 on: June 16, 2008, 05:26:08 PM »
Your file looks the same as mine.  The only difference I see is that log entry showing your search base and all of the ldap objectClasses.  When I search my ldap I have this in my log:

Jun 16 10:11:03 sme slapd[3564]: conn=138 op=1 SRCH base="dc=thebennetthometest,dc=com" scope=1 deref=0 filter="(&(cn=* *))"
Jun 16 10:11:03 sme slapd[3564]: conn=138 op=1 SRCH attr=dn uid cn mail homephone telephonenumber mobiletelephonenumber homepostaladdress calFBURL sn

Did you install any updates recently that broke things?  What yum repo's do you have enabled - db yum_repositories show - will show you the repos, look at the ones that state enabled.  I'm reaching the end of what I think I can do to help you.

John
......

Offline mgic_box

  • ***
  • 52
  • +0/-0
Re: Horde -> Organizing -> Address Book -> Local LDAP
« Reply #6 on: June 16, 2008, 07:00:12 PM »
objectClasses.  When I search my ldap I have this in my log:

Did you install any updates recently that broke things?  What yum repo's do you have enabled - db yum_repositories show - will show you the repos, look at the ones that state enabled.  I'm reaching the end of what I think I can do to help you.

John

  I do NOT know. I got the system like this, from a previos network admin. who left the organisation withot notice.

  Now I Have just add. une new user, and is just this (and only this) new user that I get listed when I Go " Horde -> Organizing -> Address Book -> Local LDAP".

  I got the users complaining they do not heve entries unser " Horde -> Organizing -> Address Book -> Local LDAP" ...

  I have not done, yet, any update.

  I Only changed the ip and the name of the server.

  The version is 7.2

  I think, the LDAP is working. Don't?  I say this, because: 1 - when I go to the control pan.-> users I see all the users, and: 2 - becuse all the users can log on and use their e-mail.

  So, do you think, or have some way to test LDAP, so we can see if it is the LDAP that is not working...???

  Regrads.



Offline mrjhb3

  • *
  • 1,188
  • +0/-0
    • John Bennett Services
Re: Horde -> Organizing -> Address Book -> Local LDAP
« Reply #7 on: June 16, 2008, 08:31:40 PM »
OK, so I finally really read your post in full.  When I go to horde, address book, local ldap, I do have the same entry in my log as you do.  Plus, I do see all of my users.  If you click on horde, organizing, address book, then on the basic search tab, choose from local ldap and in the matching column, press your space bar and see if you get any users.

You can also from the main imp screen, click on address book and search the ldap database.  From the command line, you can type slapcat to see your ldap catalog.  You could also try doing a
Code: [Select]
signal-event post-upgrade ; signal-event reboot from the command line to reconfigure and reboot the server. 

One last thing, I just remembered.  Could it be possible that the users have been restricted from the ldap database via the horde permissions screen?  Check that by logging into webmail as admin, then administration, permissions.  What do you see there?  If you don't see anything go to the command line and type
Code: [Select]
config setprop horde Administration enabled ; signal-event email-update, then look and the permissions.

John

......

Offline mgic_box

  • ***
  • 52
  • +0/-0
Re: Horde -> Organizing -> Address Book -> Local LDAP
« Reply #8 on: June 17, 2008, 06:52:28 PM »
OK, so I finally really read your post in full.  When I go to horde, address book, local ldap, I do have the same entry in my log as you do.  Plus, I do see all of my users.  If you click on horde, organizing, address book, then on the basic search tab, choose from local ldap and in the matching column, press your space bar and see if you get any users.

You can also from the main imp screen, click on address book and search the ldap database.  From the command line, you can type slapcat to see your ldap catalog.  You could also try doing a
Code: [Select]
signal-event post-upgrade ; signal-event reboot from the command line to reconfigure and reboot the server. 

One last thing, I just remembered.  Could it be possible that the users have been restricted from the ldap database via the horde permissions screen?  Check that by logging into webmail as admin, then administration, permissions.  What do you see there?  If you don't see anything go to the command line and type
Code: [Select]
config setprop horde Administration enabled ; signal-event email-update, then look and the permissions.

John





>If you click on horde, organizing, address book, then on the basic search tab, choose from local ldap and in the matching column, press your space bar and see if you get any users.

I get the same user, that I get when I go to:

Horde -> Organizing -> Address Book -> Local LDAP

>From the command line, you can type slapcat to see your ldap catalog. 

 I think we have found the problem, it is not a Horde problem, but a LDAP problem.

 I only get the same (1 (one))  user.

 I am sorry for asking and posting the wrong question.

 I Think that I should close this topic, think, reformulate and Repost the question/problem.

 I do not have a Horde problem, It is a LDAP problem.

 Regards.
 

Offline mgic_box

  • ***
  • 52
  • +0/-0
Re: Horde -> Organizing -> Address Book -> Local LDAP
« Reply #9 on: June 18, 2008, 11:52:25 AM »



>From the command line, you can type slapcat to see your ldap catalog. 

 I think we have found the problem, it is not a Horde problem, but a LDAP problem.



 Solved!

 Restored /var/lib/ldap from a previous backup.

 Thanks for the help.