I did some clean up regarding mysql and made probably some changes in the configuration :-((
After getting all working again I have problems with certificates generated after touching mysql.
The error-log looks like following:
Debugging is activated!
defining the class parameters
checking the configuration for enough data
preparing the database (vendor dependent)
mysql detected
DB: dbi:mysql:database=openca;host=localhost;port=3306;mysql_ssl=1
connecting to database
try to connect
Checking AutoCommit to be off ...
AutoCommit is off
OpenCA::DBI should now complete
Content-type: text/html OpenCA::DBI->getItem: ### new function call ###
OpenCA::DBI->getItem: Entering sub getItem
### new function call ###
Entering getArguments
OpenCA::DBI->getArguments: check: KEY=10
OpenCA::DBI->getArguments: check: DATATYPE=VALID_CERTIFICATE
OpenCA::DBI->getArguments: TABLE:CERTIFICATE
OpenCA::DBI->getArguments: MODE:
OpenCA::DBI->getArguments: attribute: KEY
OpenCA::DBI->getArguments: value: 10
OpenCA::DBI->getArguments: attribute: STATUS
OpenCA::DBI->getArguments: value:
OpenCA::DBI->getArguments: attribute: DN
OpenCA::DBI->getArguments: value:
OpenCA::DBI->getArguments: attribute: CN
OpenCA::DBI->getArguments: value:
OpenCA::DBI->getArguments: attribute: EMAIL
OpenCA::DBI->getArguments: value:
OpenCA::DBI->getArguments: attribute: ROLE
OpenCA::DBI->getArguments: value:
OpenCA::DBI->getArguments: attribute: PUBKEY
OpenCA::DBI->getArguments: value:
OpenCA::DBI->getArguments: attribute: CSR_SERIAL
OpenCA::DBI->getArguments: value:
### new function call ###
Entering getStatus
no status given using datatype: VALID_CERTIFICATE
given mode is now: "VALID"
legal status
### leaving function successful ###
OpenCA::DBI->getArguments: status: VALID
completed successful
### leaving function getArguments ###
OpenCA::DBI->getItem: data complete OpenCA::DBI->getItem: query: select * from certificate where (cert_key=?) and (status like 'VALID') and (notafter
20030619135039)### new function call ###
Entering sub doQuery
query: select * from certificate where (cert_key=?) and (status like 'VALID') and (notafter > 20030619135039)
bind_values: 10
prepare statement
statement nr.: 1
execute statement
execute succeeded
### leaving function doQuery successfully ###
OpenCA::DBI->getItem: query completed
OpenCA::DBI->getItem: check that there is a non-empty result
OpenCA::DBI->rollback
---------------------------------------------------------------------------- ----
Fehler 690
Konfigurationsfehler. Fehler 0, das Zertifikat kann nicht aus der Datenbank geladen werden! (Success).
Any ideas?
Nick
PgP-Fingerprint: 044B 65C4 07E3 F47C 9388 1CCE 3B43 038E 437C 1286
==================================================
------------------------------------------------------- This SF.Net email is sponsored by: INetU Attention Web Developers & Consultants: Become An INetU Hosting Partner. Refer Dedicated Servers. We Manage Them. You Get 10% Monthly Commission! INetU Dedicated Managed Hosting http://www.inetu.net/partner/index.php _______________________________________________ Openca-Users mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/openca-users
