Hi Howard Thanks for the response >Sounds like you're inserting data from SQL, and not using back-ndb itself Yes i insert date through mysql procedures, i only use openldap with back-ndb for retrieving data in LDAP fromat. Could this cause any problems? Thanks Panagiotis
________________________________ Απο: Howard Chu <[email protected]> Προς: Παναγιώτης Ψαρράκος <[email protected]> Κοιν.: Peter Gietz <[email protected]>; "[email protected]" <[email protected]> Στάλθηκε: 7:17 μ.μ. Τρίτη, 9 Οκτωβρίου 2012 Θεμα: Re: Σχετ: LDAP Search Question (use of * in search filter) Παναγιώτης Ψαρράκος wrote: > I changed the syntax of the ldapserach query and moved the filters at the end > of the command but i got error that there is "No such object (32)" > i.e. > ldapsearch -h 10.117.1.244 -LLL -x -b 'dc=cosmote,dc=ro' -D > "cn=pcrfuser,dc=cosmote,dc=ro" -w pcrfuser123 > "(&(billtype=PREPAID)(msisdn=*))" > I am worried that maybe i have not constructed properly the table OL_dn2id or > i use a wrong conifuguration mapping for my data and that is why my ldap > search query does not work Sounds like you're inserting data from SQL, and not using back-ndb itself? > do you have any reference in order to understand the role and structure of > table OL_dn2id? Google "openldap ndb cluster"... http://www.openldap.org/lists/openldap-devel/200810/msg00094.html http://assets.en.oreilly.com/1/event/21/LDAP%20for%20MySQL%20Cluster%20-%20back-ndb%20Presentation.pdf > Thanks > Panagiotis > > *Απο:* Peter Gietz <[email protected]> > *Προς:* Παναγιώτης Ψαρράκος <[email protected]> > *Κοιν.:* "[email protected]" <[email protected]> > *Στάλθηκε:* 2:14 μ.μ. Δευτέρα, 8 Οκτωβρίου 2012 > *Θεμα:* 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 <mailto:usertable@top> | ro | mydb | >> msisdn=40765111111 | billtype=prepaid | null (all other columns are null) >> ------------------------------------------------------------------------------------------------------------------------------------------ >> 2 | usertable@top <mailto: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. -- -- Howard Chu CTO, Symas Corp. http://www.symas.com/ Director, Highland Sun http://highlandsun.com/hyc/ Chief Architect, OpenLDAP http://www.openldap.org/project/
