Re: [Openca-Users] Pending requests

[Michael B. <mic...@rz...>]

Hi,
sorry for the delay but the phone in my new flat don't work until yet.
So I can read my mail only if I'm at work (only twice a week because I
prepare an examen).

bal...@vt... wrote:
> LLLLLLLLLLLLLLLLLLLLLLLLLLLLLL.....### new function call ###
> Entering function searchItems

This function (searchItems) brings the real data

> ### new function call ###
> Entering getArguments
> attribute: KEY
> value:
> attribute: STATUS
> value:
> attribute: DN
> value:
> attribute: CN
> value:
> attribute: EMAIL
> value:
> attribute: RA
> value:
> attribute: OPERATOR
> value:
> attribute: ROLE
> value:
> ### new function call ###
> Entering getStatus
> no status given using datatype: PENDING_REQUEST
> given mode is: "PENDING"
> legal status
> ### leaving function successful ###
> status: PENDING
> completed successful
> ### leaving function getArguments ###
> dbi-status:PENDING
> query now:select * from request
> scan attribute: KEY
> scan attribute: STATUS
> attribute's content: PENDING
> scan attribute: DN
> scan attribute: CN
> scan attribute: EMAIL
> scan attribute: RA
> scan attribute: OPERATOR
> scan attribute: ROLE
> query:select * from request where (status like ?)

The query is correct.

> ### new function call ###
> Entering sub doConnect
> status: 0
> errors: 0
> connect never failed so using standard
> DSN STANDERD= dbi:Oracle:PKI1 Databasetype:Oracle
> try to connect
> function succeeded
> ### leaving function doConnect successfully ###
> ### new function call ###
> Entering sub doQuery
> query: select * from request where (status like ?)
> bind_values: 'PENDING'
> prepare statement
> statement nr.: 1
> execute statement
> execute succeeded
> ### leaving function doQuery successfully ###
> XXXXXXXXX 1 XXXXXXXXXXX state(false is OK):
> rows: 0

The database returns no results!

> baha baha baha baha function searchItems completed successful
> ### leaving function searchItems ###

Questions:
* are there any requests in the database (check this please
  directly via a databaseinterface)
* is status of a request in the database PENDING (-"-)
* are the table- or columnnames of Oracle casesensitive

Michael

P.S. is the DSN correct (dbi:Orcale:PKI1 Databasetype:Oracle)? The last
Oracle looks a little bit suspect - but I never seen an Oracle-DB. I
read my mail at least tomorrow :-D

-------------------------------------------------------------------------
Michael Bell                   Email: mic...@we...
Rechenzentrum - Datacenter     Email (work):
mic...@rz...
Humboldt-University of Berlin  Tel.(work): +49 (0)30-2093 2482
Unter den Linden 6             Fax.(work): +49 (0)30-2093 2959
10099 Berlin
Germany                                           [OpenCA Core
Developer]

http://openca.sourceforge.net