Ed Eden wrote: > 0.9.1-rc7 > > I used db2 as the database in older versions but now in the "issue the > certificate" in the initialization phase I get: > > DBD::DB2::db prepare failed: [IBM][CLI Driver][DB2/HPUX] SQL0440N No > function by the name "LIKE" having > compatible arguments was found in the function path. SQLSTATE=42884 > > looks like db2 has been desupported. DB2 is still supported. It looks like a bug in OpenCA::DBI which other databases can tolerate. Please do the following: 1. edit OPENCADIR/etc/databases/DBI.conf - DEBUG 0 + DEBUG 1 2. try to selfsign the CA-certificate again 3. send the debugging output to the list It looks like a problem with the used SQL-syntax. So I wait for the debugging output. Michael
Debugging is activated!
defining the class parameters
checking the configuration for enough data
preparing the database (vendor dependent)
DB2 detected
DB: dbi:DB2:openca
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: TABLE:REQUEST
OpenCA::DBI->getArguments: MODE:
OpenCA::DBI->getArguments: attribute: KEY
OpenCA::DBI->getArguments: value: 256
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: RA
OpenCA::DBI->getArguments: value:
OpenCA::DBI->getArguments: attribute: OPERATOR
OpenCA::DBI->getArguments: value:
OpenCA::DBI->getArguments: attribute: ROLE
OpenCA::DBI->getArguments: value:
OpenCA::DBI->getArguments: attribute: PUBKEY
OpenCA::DBI->getArguments: value:
### new function call ###
Entering getStatus
no status given using datatype: PENDING_REQUEST
given mode is now: "PENDING"
legal status
### leaving function successful ###
OpenCA::DBI->getArguments: status: PENDING
completed successful
### leaving function getArguments ###
OpenCA::DBI->getItem: data complete OpenCA::DBI->getItem: query: select * from request where (req_key=?) and (status like
'PENDING')
### new function call ###
Entering sub doQuery
query: select * from request where (req_key=?) and (status like 'PENDING')
bind_values: 256
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->getResultItem: ### new function call ###
OpenCA::DBI->getResultItem: Entering sub getResultItem
OpenCA::DBI->getResultItem: all params present
### new function call ###
Entering function getResultHash
column:REQUEST_SERIAL
value:256
column:FORMAT
value:PKCS#10
column:DATA
value:-----BEGIN HEADER----- TYPE = PKCS#10 SERIAL = 256 NOTBEFORE = Tue Dec 3 15:30:38 2002 GMT PIN =
82e19fa12aab7cfc718a002fc82c0f074bf070e7 RA = Trustcenter itself ROLE = CA Operator -----END HEADER----- -----BEGIN
CERTIFICATE REQUEST----- MIIBKzCB1gIBADBxMQswCQYDVQQGEwJVUzENMAsGA1UEChMEVVNEQTERMA8GA1UE
CxMISW50ZXJuZXQxETAPBgNVBAMTCHVzZGFPcGVyMS0wKwYJKoZIhvcNAQkBFh51
c2RhT3BlckBibHVlZDEucnVyYWwudXNkYS5nb3YwXDANBgkqhkiG9w0BAQEFAANL
ADBIAkEA3uLmMpw/zg6QudEI17Y8x+yMaR/Wt4GajA8H7i3ih3R/HDJK7dvq9ONp
IHAIE/mzOCIwlLQ1o60XN8oRiTeG3QIDAQABoAAwDQYJKoZIhvcNAQEEBQADQQB7
G+UvYhi8vi4hU0HH6HrQKtiqj0wb32vezNuWL1GP5KMXxy3tliV/0xbL5PMDm35s C8rFOy5T4iUqgprLmliP -----END CERTIFICATE
REQUEST----- -----BEGIN ENCRYPTED PRIVATE KEY-----
MIIBgTAbBgkqhkiG9w0BBQMwDgQIfeKgA//FM84CAggABIIBYIQnH/Lg4w9T0Qmw
njmXKSmldKXHoL1uLvtSKh4gah2TBpZk4YfZLJIU2ebJw0Q2CfsBSDe5SLgA8y7O
g6p6e7pFu0dd/Wvb1tkNgD6IP8lpVYfaCvs66Yar0Z6gb360mjI3zEK6dI71n3k9
jBk72aNdZf8fIdSvyDYwTdxbR/Gwu6zk38aXmdL+BctGZ2xBInbRMwY7ROfmDcW+
iasBY7PkOrOBKmcgZ89YP+DSxAbgELIsBEAjKtPSQQLGONIs14otQPBVm4kViJ2U
0+3TxCMZE4C6CyNVCLmfafckaFMd0ykbBh3zx4jGEYzhv2NZiOmOCMjTbC4j17/p
yXellPfJnjrWdAYqBew4Tla6R3cUm8xGQE8wZVnVyd8LEA/u12lASYvbIk9vWPHG
ctFHOLgNVUM6lMS2VJvUOpeWDOlOdm4M2Z58E/n1P+wR36IXIaYTthG/dI86XstT 1nmrYfo= -----END ENCRYPTED PRIVATE
KEY-----
column:DN
value:[EMAIL PROTECTED],CN=usdaOper,OU=Internet,O=USDA,C=US
column:CN
value:usdaOper
column:EMAIL
value:
column:RA
value:Trustcenter itself
column:Operator
value:
column:STATUS
value:PENDING
column:ROLE
value:CA Operator
column:PUBKEY
value:-----BEGIN PUBLIC KEY----- MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBAN7i5jKcP84OkLnRCNe2PMfsjGkf1reB
mowPB+4t4od0fxwySu3b6vTjaSBwCBP5szgiMJS0NaOtFzfKEYk3ht0CAwEAAQ== -----END PUBLIC KEY-----
### leaving function getResultHash ###
OpenCA::DBI->getResultItem: data:
-----BEGIN HEADER----- TYPE = PKCS#10 SERIAL = 256 NOTBEFORE = Tue Dec 3 15:30:38 2002 GMT PIN =
82e19fa12aab7cfc718a002fc82c0f074bf070e7 RA = Trustcenter itself ROLE = CA Operator -----END HEADER----- -----BEGIN
CERTIFICATE REQUEST----- MIIBKzCB1gIBADBxMQswCQYDVQQGEwJVUzENMAsGA1UEChMEVVNEQTERMA8GA1UE
CxMISW50ZXJuZXQxETAPBgNVBAMTCHVzZGFPcGVyMS0wKwYJKoZIhvcNAQkBFh51
c2RhT3BlckBibHVlZDEucnVyYWwudXNkYS5nb3YwXDANBgkqhkiG9w0BAQEFAANL
ADBIAkEA3uLmMpw/zg6QudEI17Y8x+yMaR/Wt4GajA8H7i3ih3R/HDJK7dvq9ONp
IHAIE/mzOCIwlLQ1o60XN8oRiTeG3QIDAQABoAAwDQYJKoZIhvcNAQEEBQADQQB7
G+UvYhi8vi4hU0HH6HrQKtiqj0wb32vezNuWL1GP5KMXxy3tliV/0xbL5PMDm35s C8rFOy5T4iUqgprLmliP -----END CERTIFICATE
REQUEST----- -----BEGIN ENCRYPTED PRIVATE KEY-----
MIIBgTAbBgkqhkiG9w0BBQMwDgQIfeKgA//FM84CAggABIIBYIQnH/Lg4w9T0Qmw
njmXKSmldKXHoL1uLvtSKh4gah2TBpZk4YfZLJIU2ebJw0Q2CfsBSDe5SLgA8y7O
g6p6e7pFu0dd/Wvb1tkNgD6IP8lpVYfaCvs66Yar0Z6gb360mjI3zEK6dI71n3k9
jBk72aNdZf8fIdSvyDYwTdxbR/Gwu6zk38aXmdL+BctGZ2xBInbRMwY7ROfmDcW+
iasBY7PkOrOBKmcgZ89YP+DSxAbgELIsBEAjKtPSQQLGONIs14otQPBVm4kViJ2U
0+3TxCMZE4C6CyNVCLmfafckaFMd0ykbBh3zx4jGEYzhv2NZiOmOCMjTbC4j17/p
yXellPfJnjrWdAYqBew4Tla6R3cUm8xGQE8wZVnVyd8LEA/u12lASYvbIk9vWPHG
ctFHOLgNVUM6lMS2VJvUOpeWDOlOdm4M2Z58E/n1P+wR36IXIaYTthG/dI86XstT 1nmrYfo= -----END ENCRYPTED PRIVATE
KEY-----
OpenCA::DBI->getResultItem: format: PKCS#10
OpenCA::DBI->getResultItem: have all data
OpenCA::DBI->getResultItem: data of item:
-----BEGIN HEADER----- TYPE = PKCS#10 SERIAL = 256 NOTBEFORE = Tue Dec 3 15:30:38 2002 GMT PIN =
82e19fa12aab7cfc718a002fc82c0f074bf070e7 RA = Trustcenter itself ROLE = CA Operator -----END HEADER----- -----BEGIN
CERTIFICATE REQUEST----- MIIBKzCB1gIBADBxMQswCQYDVQQGEwJVUzENMAsGA1UEChMEVVNEQTERMA8GA1UE
CxMISW50ZXJuZXQxETAPBgNVBAMTCHVzZGFPcGVyMS0wKwYJKoZIhvcNAQkBFh51
c2RhT3BlckBibHVlZDEucnVyYWwudXNkYS5nb3YwXDANBgkqhkiG9w0BAQEFAANL
ADBIAkEA3uLmMpw/zg6QudEI17Y8x+yMaR/Wt4GajA8H7i3ih3R/HDJK7dvq9ONp
IHAIE/mzOCIwlLQ1o60XN8oRiTeG3QIDAQABoAAwDQYJKoZIhvcNAQEEBQADQQB7
G+UvYhi8vi4hU0HH6HrQKtiqj0wb32vezNuWL1GP5KMXxy3tliV/0xbL5PMDm35s C8rFOy5T4iUqgprLmliP -----END CERTIFICATE
REQUEST----- -----BEGIN ENCRYPTED PRIVATE KEY-----
MIIBgTAbBgkqhkiG9w0BBQMwDgQIfeKgA//FM84CAggABIIBYIQnH/Lg4w9T0Qmw
njmXKSmldKXHoL1uLvtSKh4gah2TBpZk4YfZLJIU2ebJw0Q2CfsBSDe5SLgA8y7O
g6p6e7pFu0dd/Wvb1tkNgD6IP8lpVYfaCvs66Yar0Z6gb360mjI3zEK6dI71n3k9
jBk72aNdZf8fIdSvyDYwTdxbR/Gwu6zk38aXmdL+BctGZ2xBInbRMwY7ROfmDcW+
iasBY7PkOrOBKmcgZ89YP+DSxAbgELIsBEAjKtPSQQLGONIs14otQPBVm4kViJ2U
0+3TxCMZE4C6CyNVCLmfafckaFMd0ykbBh3zx4jGEYzhv2NZiOmOCMjTbC4j17/p
yXellPfJnjrWdAYqBew4Tla6R3cUm8xGQE8wZVnVyd8LEA/u12lASYvbIk9vWPHG
ctFHOLgNVUM6lMS2VJvUOpeWDOlOdm4M2Z58E/n1P+wR36IXIaYTthG/dI86XstT 1nmrYfo= -----END ENCRYPTED PRIVATE
KEY-----
OpenCA::DBI->getResultItem: return item
### new function call ###
Entering function searchItems
### new function call ###
Entering getArguments
OpenCA::DBI->getArguments: TABLE:CERTIFICATE
OpenCA::DBI->getArguments: MODE:
OpenCA::DBI->getArguments: attribute: KEY
OpenCA::DBI->getArguments: value:
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: 256
### new function call ###
Entering getStatus
no status given using datatype: CERTIFICATE
given mode is now: ""
illegal status or no status
### leaving function unsuccessful but without error ###
completed successful
### leaving function getArguments ###
dbi-status:
query now:select * from certificate
scan attribute: KEY
scan attribute: STATUS
scan attribute: DN
scan attribute: CN
scan attribute: EMAIL
scan attribute: ROLE
scan attribute: PUBKEY
scan attribute: CSR_SERIAL
attribute's content: 256
query:select * from certificate where (req_key like ?) order by cert_key
### new function call ###
Entering sub doQuery
query: select * from certificate where (req_key like ?) order by cert_key
bind_values: 256
prepare statement
statement nr.: 2
prepare failed
query: select * from certificate where (req_key like ?) order by cert_key
returned errorcode: 42884
OpenCA::DBI automatic rollback by destructor DESTROY
------------------------------------------------------- This SF.net email is sponsored by: Microsoft Visual Studio.NET comprehensive development tool, built to increase your productivity. Try a free online hosted session at: http://ads.sourceforge.net/cgi-bin/redirect.pl?micr0003en _______________________________________________ Openca-Users mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/openca-users
