At 09:29 PM 10/1/2001 +0200, Michael Bell wrote:
>OpenCA::DBI uses a debuggingswitch in DBI.conf. So if there are problems
>please use the switch and send the output to me. This will help a lot.
Here's some more. I installed openca/openca-dbi from cvs, and updated to
the latest DBI and DBD-Pg. RA initialization worked fine, but upon
submission of a cert request I got the following. I noticed that the bind
variable is an integer, but the field being compared in the select is
'text'; does DBI do the right thing in this case?
--bob
defining the class parameters checking the configuration for enough data
checking for the tools preparing the remote and local databases
(vendor dependent) Pg detected for remoteDB remoteDB:
dbi:Pg:dbname=opencara;host=localhost;port=5432 localDB: try to get a
consistent
operationmode set standard and backup databases OpenCA::DBI should now
complete ### new function call ###
Entering function storeItem
### new function call ###
Entering storeItem_getArguments
table: REQUEST
attribute: KEY
value:
attribute: STATUS
value:
attribute: DN
value: [EMAIL PROTECTED], CN=foo bar, OU=OpenCA User, OU=Internet,
O=OpenCA Organization, C=IT
attribute: CN
value: foo bar
attribute: EMAIL
value: [EMAIL PROTECTED]
attribute: RA
value: City Municipality
attribute: OPERATOR
value:
attribute: ROLE
value:
### new function call ###
Entering getStatus
no status given using datatype: PENDING_REQUEST
given mode is: "PENDING"
legal status
### leaving function successful ###
status: PENDING
inform: SPKAC
format: SPKAC
converted: -----BEGIN HEADER----- RA = City Municipality TYPE = SPKAC
NOTBEFORE = Mon Oct 1 21:17:06 CDT 2001 SERIAL
= 5167 PIN = foobarfoobar -----END HEADER----- EMAIL = [EMAIL PROTECTED] CN
= foo bar 1.OU = OpenCA User 2.OU = Internet
O = OpenCA Organization C = IT SPKAC =
MIIBQTCBqzCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAuC+dCsVQHRWp8sc8h2IijB0I9xrVg0htjzrZWAhstJ/CiNd0lQi2pOFqdn2yLBMwJMWsY+hU3/dw8lhM3OKrtgNiMSAHzh5VwvfEeMck7k36gdsiU7wEyiX/mrKDiaFEGaEVnuyDb+UogsOh3oezL5rwcjUaV7PwfS+VQTltEkkCAwEAARYHcGFzc3dkMTANBgkqhkiG9w0BAQQFAAOBgQCUED/YsUqSgUA4GajDW1oyntiaphkLvJk0KHlxB5DD40YFu7hx83ZJXFRqscsI2iyA7YCXETZlJJY765rncFt6yXwLRf3SBABUaIxuw0LiRrUnKdz0qnDjsdupRSQMs6ZZE79l0bkiTMv80et4umCfJcd//ZsYKoqxBqcFvSRrTw==
object->getParsed hash:
object-attribute:SIG_ALGORITHM
object-value:md5WithRSAEncryption
object-attribute:SPKAC
object-value:MIIBQTCBqzCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAuC+dCsVQHRWp8sc8h2IijB0I9xrVg0htjzrZWAhstJ/CiNd0lQi2pOFqdn2yLBMwJMWsY+hU3/dw8lhM3OKrtgNiMSAHzh5VwvfEeMck7k36gdsiU7wEyiX/mrKDiaFEGaEVnuyDb+UogsOh3oezL5rwcjUaV7PwfS+VQTltEkkCAwEAARYHcGFzc3dkMTANBgkqhkiG9w0BAQQFAAOBgQCUED/YsUqSgUA4GajDW1oyntiaphkLvJk0KHlxB5DD40YFu7hx83ZJXFRqscsI2iyA7YCXETZlJJY765rncFt6yXwLRf3SBABUaIxuw0LiRrUnKdz0qnDjsdupRSQMs6ZZE79l0bkiTMv80et4umCfJcd//ZsYKoqxBqcFvSRrTw==
object-attribute:ITEM
object-value:-----BEGIN HEADER----- RA = City Municipality TYPE = SPKAC
NOTBEFORE = Mon Oct 1 21:17:06 CDT 2001
SERIAL = 5167 PIN = foobarfoobar -----END HEADER----- EMAIL =
[EMAIL PROTECTED] CN = foo bar 1.OU = OpenCA User 2.OU =
Internet O = OpenCA Organization C = IT SPKAC =
MIIBQTCBqzCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAuC+dCsVQHRWp8sc8h2IijB0I9xrVg0htjzrZWAhstJ/CiNd0lQi2pOFqdn2yLBMwJMWsY+hU3/dw8lhM3OKrtgNiMSAHzh5VwvfEeMck7k36gdsiU7wEyiX/mrKDiaFEGaEVnuyDb+UogsOh3oezL5rwcjUaV7PwfS+VQTltEkkCAwEAARYHcGFzc3dkMTANBgkqhkiG9w0BAQQFAAOBgQCUED/YsUqSgUA4GajDW1oyntiaphkLvJk0KHlxB5DD40YFu7hx83ZJXFRqscsI2iyA7YCXETZlJJY765rncFt6yXwLRf3SBABUaIxuw0LiRrUnKdz0qnDjsdupRSQMs6ZZE79l0bkiTMv80et4umCfJcd//ZsYKoqxBqcFvSRrTw==
object-attribute:O
object-value:OpenCA Organization
object-attribute:HEADER
object-value:HASH(0x8347bfc)
object-attribute:EXPONENT
object-value:65537
object-attribute:C
object-value:IT
object-attribute:VERSION
object-value:1
object-attribute:PK_ALGORITHM
object-value:rsaEncryption
object-attribute:OU
object-value:ARRAY(0x8347ca4)
object-attribute:CN
object-value:foo bar
object-attribute:KEYSIZE
object-value:1024
object-attribute:EMAIL
object-value:[EMAIL PROTECTED]
object-attribute:TYPE
object-value:SPKAC
object-attribute:DN
object-value:[EMAIL PROTECTED], CN=foo bar, OU=OpenCA User,
OU=Internet, O=OpenCA Organization, C=IT
object-attribute:SIGNATURE
object-value:
object-attribute:BODY
object-value:EMAIL = [EMAIL PROTECTED] CN = foo bar 1.OU = OpenCA User 2.OU
= Internet O = OpenCA Organization C = IT
SPKAC =
MIIBQTCBqzCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAuC+dCsVQHRWp8sc8h2IijB0I9xrVg0htjzrZWAhstJ/CiNd0lQi2pOFqdn2yLBMwJMWsY+hU3/dw8lhM3OKrtgNiMSAHzh5VwvfEeMck7k36gdsiU7wEyiX/mrKDiaFEGaEVnuyDb+UogsOh3oezL5rwcjUaV7PwfS+VQTltEkkCAwEAARYHcGFzc3dkMTANBgkqhkiG9w0BAQQFAAOBgQCUED/YsUqSgUA4GajDW1oyntiaphkLvJk0KHlxB5DD40YFu7hx83ZJXFRqscsI2iyA7YCXETZlJJY765rncFt6yXwLRf3SBABUaIxuw0LiRrUnKdz0qnDjsdupRSQMs6ZZE79l0bkiTMv80et4umCfJcd//ZsYKoqxBqcFvSRrTw==
KEY:5167
### function storeITem_getArguments succesfully finished ###
table: REQUEST
### new function call ###
Entering storeItem_checkData
data is complete
### leaving function storeItem_checkData successfully ###
initializes db_hash
starting DBLOOP
try to connect
### new function call ###
Entering sub doConnect
status: 0
errors: 0
connect never failed so using standard
Databasetype:Pg
dsn stuff: 'dbi:Pg:dbname=opencara;host=localhost;port=5432', 'opencara',
'opencara'
try to connect
function succeeded
### leaving function doConnect successfully ###
Databasetype:Pg
check for existence of item
is not a CRL
doQuery: select * from request where req_key=?
### new function call ###
Entering sub doQuery
query: select * from request where req_key=?
bind_values: 5167
prepare statement
statement nr.: 1
execute statement
execute failed
### leaving function doQuery unsuccessfully ###
doQuery failure detected by function storeItem -> retry
try to connect
### new function call ###
Entering sub doConnect
status: 1
errors: 20080
connect never failed so using standard
Databasetype:Pg
dsn stuff: 'dbi:Pg:dbname=opencara;host=localhost;port=5432', 'opencara',
'opencara'
try to connect
function succeeded
### leaving function doConnect successfully ###
Databasetype:Pg
check for existence of item
is not a CRL
doQuery: select * from request where req_key=?
### new function call ###
Entering sub doQuery
query: select * from request where req_key=?
bind_values: 5167
prepare statement
statement nr.: 2
execute statement
execute failed
### leaving function doQuery unsuccessfully ###
doQuery failure detected by function storeItem -> retry
try to connect
### new function call ###
Entering sub doConnect
status: 2
errors: 20080
second connect failed
Error 340
General Submission Error. Error while storing REQ
(/usr/local/RAServer/dB)!.
© 1998-2001 by Massimiliano Pala and
OpenCA Group
Netscape Request Manager - Version 0.5.1a
_______________________________________________
OpenCA-Devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/openca-devel
