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

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