[Date Prev][Date Next] [Chronological] [Thread] [Top]

Re: LDAP Search Question (use of * in search filter)

Am 08.10.2012 12:45, schrieb Παναγιώτης Ψαρράκος:
Dear all
My environment consist of a mySWL Cluster database that use ndbcluster storage engine. I have install openLDAP using back ndb in otder to expose my database in LDAP fromat. The main table of LDAP is the table OL_dn2id.
Entries in this table have the following format
eid | object_class     | a0       | a1       | a2                              | a3                       | a4 | a5 ... | a15
1    | usertable@top  | ro       | mydb  | msisdn=40765111111 | billtype=prepaid  | null (all other columns are null)
2    | usertable@top  | ro       | mydb  | msisdn=40765111112 | billtype=postpaid | null (all other columns are null)
My database definition in slapd.conf is the following
database ndb
suffix "dc=mydb,dc=ro"
rootdn "cn=Manager,dc=mydb,dc=ro"
I want to execute ldap search queries based on msisdn or billtype attribute. I am trying to this using the command
i.e. return all postpaid user msisdns - i ma trying to use the * in the filter in order to have all msisdns
ldapsearch -h localhost -LLL -x -s sub -d 32 -b bill=postpaid,msisdn=*,dc=cosmote,dc=ro

You are not using * in a filter but in the basedn which does not conform to dn syntax.

I am not sure, how your filter should look like, but it should be stated at the end of your ldapsearch, e.g.
...  -b dc=cosmote,dc=ro "(&(bill=postpaid)(msisdn=*))"

This depends on how the data are modelled ldap-wise and not ndb-wise.



The output of this command:
Invalid DN syntax (34)
Additional information: invalid DN
Any help on this would be very usefull
With Regards
Panagiotis Psarrakos


Peter Gietz (CEO)
DAASI International GmbH                   phone: +49 7071 407109-0
Europaplatz 3                              Fax:   +49 7071 407109-9
D-72072 Tübingen                           mail:  peter.gietz@daasi.de
Germany                                    Web:   www.daasi.de

DAASI International GmbH, Tübingen
Geschäftsführer Peter Gietz, Amtsgericht Stuttgart HRB 382175