i tested it with mysqladmin and I get a result only till key number 9 altough 10 and greater are in the DB and are listed too. When importing from ca I get messages that newer entry already exist in the db.
I have an idea that the owner of those newer certificates is ca because I tried to use only one db and therefore switched ca to use the db on ra and then I to move back! :-|
Then I got confused by the rights!
Any solutions?
Nick
Michael Bell schrieb:
1. Did you test the last SQL query in mysql (e.g use mysqlcc)?
2. Does Apache's error_log report any additional problems?
Michael
Nicolaie Szabadkai wrote:Hi everybody,
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).
--
-------------------------------------------------------------------
Michael Bell Email: [EMAIL PROTECTED]
ZE Computer- und Medienservice Tel.: +49 (0)30-2093 2482
(Computing Centre) Fax: +49 (0)30-2093 2704
Humboldt-University of Berlin
Unter den Linden 6
10099 Berlin Email (private): [EMAIL PROTECTED]
Germany http://www.openca.org
------------------------------------------------------- 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
Mit freundlichen Gr��en
N. Szabadkai
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
