[Openca-Users] problem with search certificates

[<nm...@ce...>]

Hello list, i have been working around the following problem.

Before a go deep, i must say that i search in mailing list for this 
problem and nothing apears.

Basically the problem is when i use the public interface to do some 
search over certificates attributes.

Always the result of the search is empty.

I start to read de code to the function searchItems of OpenCA::DB.pm  file.

in this function it enter in the following section

  foreach ( $self->getSearchAttributes( $dataType )) {
                                next if( not exists $keys->{$_} or 
$keys->{$_} eq "" );
                                $key = $keys->{$_};

                                ## Get results for this search attribute

                                @dupList = 
$self->{dbms_search}->get_dup($key);


and then process the list @dupList, but this list always came empty.


I notice that the key used to pass to get_dup is, for example the name 
used to search the certificate, lets say "Tom", but the key used in 
get_dup function that belongs to DB_File is the complete key of the 
btree used. something like this 
serialNumber=10,emailAddress=to...@my... 
<mailto:emailAddress=pv...@in...>,CN=Tom 
Ridle,L=XXX,OU=YYY,O=ZZZ,C=AR

in fact, if i use this complete key, the search work fine.

I don't know why i can do search with Name only, like the demo site does.

another cuestion is that a change the format of my certificates, so when 
i search with "Tom", i see that searchItems is called from 
..RA/OpenCA/lib/cmd/search which the following parameters: 
KEY  CN Tom DATATYPE CERTIFICATE ROLE  DN  EMAILADDRESS

and the attributes used to search by searchItems are:  DN CN EMAIL 
KEY_DIGEST PUBKEY CSR_SERIAL

obviously i have a problem with configuration of EMAIL field name, but 
by Name (in the GUI) or CN it should work.

i have the following modules version
Module 	Version
OpenSSL 	0.9.135.2.11
Tools 	0.4.3
DB 	2.0.5
Configuration 	1.5.3
TRIStateCGI 	1.5.5
REQ 	0.9.61.2.1
X509 	0.9.57
CRL 	0.9.24.2.1
PKCS7 	0.9.19.2.5



I will apreciate any help.
Thanks
Nicolás Macia