Hello,
I installed a new CA (0.9.2.2) with PostgreSQL 8.03 on a
FreeBSD 5.4 System and down loaded 2 CSRs from the Public
Interface. When I try to list the CSR on the CA WEB interface
following error message appears.
(Active CSRs - New)
Error 700
General Error Database failed with errorcode 20032. SELECT_FAILED
PostgreSQL
----------------------------------------------------
openca=> select req_key,cn,status from request;
req_key | cn | status
---------+-----------+--------
1056 | Student-1 | NEW
1568 | Student-7 | NEW
openca=> select req_key,cn,status from request where (req_key=1056);
req_key | cn | status
---------+-----------+--------
1056 | Student-1 | NEW
PostgreSQL Log:
----------------------------------------------------
LOG: connection received: host=::1 port=53468
LOG: connection authorized: user=openca database=openca
LOG: statement: begin
LOG: duration: 0.536 ms
LOG: statement: SET NAMES 'ISO8859-1'
LOG: duration: 0.903 ms
LOG: statement: select count(*) from request where status like $1
LOG: statement: select * from request where (req_key >= $1 ) and (status like
$2) order by req_key LIMIT 20
LOG: statement: select MIN(req_key) from request where (status like $1)
LOG: statement: select * from request where (req_key=$1)
^^^-- Why??
Does anybody know, why a wrong select command is been generated?
Thanks in advance
Niels Peuyn
-------------------------------------------------------
This SF.Net email is sponsored by: NEC IT Guy Games. How far can you shotput
a projector? How fast can you ride your desk chair down the office luge track?
If you want to score the big prize, get to know the little guy.
Play to win an NEC 61" plasma display: http://www.necitguy.com/?r=20
_______________________________________________
Openca-Users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openca-users
