Hello, all. I've hit a problem right away while trying to use OpenCA 1.0.2 running on CentOS 5.2 with PostgreSQL 8.1.11. I installed separate online and offline systems, i.e., CA/node and then RA/node/Pub. When retrieving the list of new CSRs under RA Operations, I receive the following error:
Database failed with errorcode 20032. SELECT_FAILED (error 20016: EXECUTE_FAILED (error 11111: Do not commit if the database or the module itself fails.)) The entry in var/openca/log/stderr.log makes it look like a bug. Here is the error: DBD::Pg::st execute failed: ERROR: column "request.req_key" must appear in the GROUP BY clause or be used in an aggregate function DBD::Pg::st execute failed: ERROR: current transaction is aborted, commands ignored until end of transaction block The installation, initialization, and configuration import went fine. I then used the pub interface to create a browser request using server side key generation. After submitting the request, I went to the RA, successfully logged in using LDAP password authentication, chose RA Operations, Certificate Requests, New. I left all fields set to All and clicked Search. I then receive the above errors. I also tried searching with all fields explicitly set and received the same results. If I manually connect to the database as the openca user and query the request table, I can see the request in the database. Am I doing something wrong? Is there a fix? This has us stopped in our tracks for now. Thanks - John -- John A. Sullivan III Open Source Development Corporation +1 207-985-7880 [EMAIL PROTECTED] http://www.spiritualoutreach.com Making Christianity intelligible to secular society ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Openca-Users mailing list Openca-Users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openca-users
