Hi Michael,
Before you complete RC3 I have one more issue for you:
When I am issuing certificate I get the following error message:
DBD::Pg::st execute failed: ERROR: Bad int8 external representation "" at /usr/lib/perl5/site_perl/5.6.1/i386-linux/OpenCA/DBI.pm line 3076.
General Error Trapped 6781: Error while storing 04.pem cert in dB!
The database returns errorcode 20128 (INSERT_FAILED). at /usr/local/openca/OpenCA/lib/functions/misc-utils.lib line 38.
Compilation failed in require at /var/www/cgi-ca/ca line 194.
The Posgress error log is as follows:
DEBUG: ProcessQuery
DEBUG: CommitTransactionCommand
DEBUG: StartTransactionCommand
DEBUG: query: select last_value from openca_log_sequence
DEBUG: ProcessQuery
DEBUG: CommitTransactionCommand
DEBUG: StartTransactionCommand
DEBUG: query: update log set datatype='CERTIFICATE', moduletype='UNKNOWN', module='UNKNOWN MODULETYPE AND UNKNOWN MODULE', log_submit_date='2002-07-02 13:38:32', format='PEM', data='-----BEGIN HEADER-----
PIN_SIGNATURE=
-----BEGIN ATTRIBUTE-----
-----BEGIN PKCS7-----
MIII3gYJKoZIhvcNAQcCoIIIzzCCCMsCAQExCzAJBgUrDgMCGgUAMDcGCSqGSIb3
DQEHAaAqBCgyODQzYzVmZDViYzFhZDE4NTcxYTZhODEzYzUxYjk4ZjIyZjAwYzYw
oIIGSjCCBkYwggUuoAMCAQICAQAwDQYJKoZIhvcNAQEEBQAwgaMxCzAJBgNVBAYT
AkNBMSIwIAYDVQQKExlTaWVycmEgU3lzdGVtcyBHcm91cCBJbmMuMRUwEwYDVQQL
EwxDQSBBdXRob3JpdHkxLTArBgNVBAMTJFNpZXJyYSBTeXN0ZW1zIENlcnRpZmlj
YXRlIEF1dGhvcml0eTEqMCgGCSqGSIb3DQEJARYbY2FtYW5hZ2VyQHNpZXJyYXN5
c3RlbXMuY29tMB4XDTAyMDgwMTE1NTAzOFoXDTA0MDczMTE1NTAzOFowgaMxCzAJ
BgNVBAYTAkNBMSIwIAYDVQQKExlTaWVycmEgU3lzdGVtcyBHcm91cCBJbmMuMRUw
EwYDVQQLEwxDQSBBdXRob3JpdHkxLTArBgNVBAMTJFNpZXJyYSBTeXN0ZW1zIENl
cnRpZmljYXRlIEF1dGhvcml0eTEqMCgGCSqGSIb3DQEJARYbY2FtYW5hZ2VyQHNp
ZXJyYXN5c3RlbXMuY29tMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA
tuMRmFIFWFVH3a5yAoy68nbQDW+LDn++q5Hukcan/NTntPnCMUZ4DlC5T1SCYgzY
lKaQdbNQYQ+wjCquTR2alnYhIjQAf4HY0dHpw+x2jg7/Wvvc3qx9B1Ra3qqCzWgZ
a33zSuoPlML5zgOUibKIqGz4Txn6ExWAQbF6m9RUnnpjfwEpODZwBDd3DBYEE9pL
eauCyvoPw5AGI2y/RS15LI/OPd+4cKe2IObdKfTGEixVwp5gxJpjqP4gjPoGExGB
haVd7RdCRszKC+mzneaTAqet77kMRqjPMnu6ZSf+WU1feSbxAVlP66qna/MHt6CL
FQP3S5WhGToug+t7c0U0EQIDAQABo4ICgTCCAn0wDwYDVR0TAQH/BAUwAwEB/zAd
BgNVHQ4EFgQUTxgYSDZoQ8RG0jWzbFAFp2x3HAcwgdAGA1UdIwSByDCBxYAUTxgY
SDZoQ8RG0jWzbFAFp2x3HAehgamkgaYwgaMxCzAJBgNVBAYTAkNBMSIwIAYDVQQK
ExlTaWVycmEgU3lzdGVtcyBHcm91cCBJbmMuMRUwEwYDVQQLEwxDQSBBdXRob3Jp
dHkxLTArBgNVBAMTJFNpZXJyYSBTeXN0ZW1zIENlcnRpZmljYXRlIEF1dGhvcml0
eTEqMCgGCSqGSIb3DQEJARYbY2FtYW5hZ2VyQHNpZXJyYXN5c3RlbXMuY29tggEA
MAsGA1UdDwQEAwIBxjAmBgNVHREEHzAdgRtjYW1hbmFnZXJAc2llcnJhc3lzdGVt
cy5jb20wJgYDVR0SBB8wHYEbY2FtYW5hZ2VyQHNpZXJyYXN5c3RlbXMuY29tMBEG
CWCGSAGG+EIBAQQEAwIABzBMBglghkgBhvhCAQ0EPxY9U2llcnJhIFN5c3RlbXMg
R3JvdXAgSW5jLiBDZXJ0aWZpY2F0aW9uIEF1dGhvcml0eSBDZXJ0aWZpY2F0ZTA+
BgNVHR8ENzA1MDOgMaAvhi1odHRwczovL2h0dHA6Ly93c3ZhbjUxNC9jZ2ktYmlu
L2NybC9jYWNybC5jcmwwPAYJYIZIAYb4QgEEBC8WLWh0dHBzOi8vaHR0cDovL3dz
dmFuNTE0L2NnaS1iaW4vY3JsL2NhY3JsLmNybDA8BglghkgBhvhCAQMELxYtaHR0
cHM6Ly9odHRwOi8vd3N2YW41MTQvY2dpLWJpbi9jcmwvY2FjcmwuY3JsMA0GCSqG
SIb3DQEBBAUAA4IBAQBR/oMIIhEGTSx861bmPHiUbV4bWlpDcluomL0nw2sB3xK/
Poz7P4+ls+Fz5y8QkJqrCljs1TaplywBmd2oflqbW4dZkalukTiy09yhSzgKqGWo
EY5KNCx7aot4ubBxL7ThCXik8ogEv51lmNiHD8GY/9EBm+9UZarnoztJYZQdS0zs
SmA1V+aO2+5WkM0P/vd2E+0cd4sp2bOPX4eSlS4NOO46LybTd9Di6hXnAAh3+BTp
tiwuGORP1elaICh5rfgsZ3flCU6gWozHE1pBY26OU4kDf/VeEgprdVklzN46RBx6
+QBjgWnMaOvI2SQkxII4jS0aD52KCikATVLIhG5eMYICMDCCAiwCAQEwgakwgaMx
CzAJBgNVBAYTAkNBMSIwIAYDVQQKExlTaWVycmEgU3lzdGVtcyBHcm91cCBJbmMu
MRUwEwYDVQQLEwxDQSBBdXRob3JpdHkxLTArBgNVBAMTJFNpZXJyYSBTeXN0ZW1z
IENlcnRpZmljYXRlIEF1dGhvcml0eTEqMCgGCSqGSIb3DQEJARYbY2FtYW5hZ2Vy
QHNpZXJyYXN5c3RlbXMuY29tAgEAMAkGBSsOAwIaBQCgXTAYBgkqhkiG9w0BCQMx
CwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0wMjA4MDIxMzM4MzJaMCMGCSqG
SIb3DQEJBDEWBBRr5lgRBh05/3w0Hr3f1NbSppzNXDANBgkqhkiG9w0BAQEFAASC
AQAb6P0T+LVbx2jNiKk312ao6ZZokcwUhD8slaSAE1tVTdDQ1uT/jjdVJNiUvr38
zMhVwpPylp8g2Wdd6Hgk4WTCdyoYyFQqKyAU1iWN1JBn8N9FzVBk8IK+2c6B4Ow2
npJ0eknx/t3Tj7P7uoBcPsgZhpuA6o1rINIvor0E0l5O2WQXe7eAd8njev7YOObS
AETQWAriD7/6Eti/Z5bi9j3utS0SBw8Mbgn0agi3cUee+wVcd2/XpgzPbCPwsCIf
llEcnQWALhwf0+VBreO7Kpm4cLSLCLN3L6ZXe9NKLRZJugg5src3SzSDmYKZMqYg
CC6zfooC1+AtWSuVrqVvfCaf
-----END PKCS7-----
-----END ATTRIBUTE-----
ROLE_SIGNATURE=
-----BEGIN ATTRIBUTE-----
-----BEGIN PKCS7-----
MIIIvQYJKoZIhvcNAQcCoIIIrjCCCKoCAQExCzAJBgUrDgMCGgUAMBYGCSqGSIb3
DQEHAaAJBAcwNApVc2VyoIIGSjCCBkYwggUuoAMCAQICAQAwDQYJKoZIhvcNAQEE
BQAwgaMxCzAJBgNVBAYTAkNBMSIwIAYDVQQKExlTaWVycmEgU3lzdGVtcyBHcm91
cCBJbmMuMRUwEwYDVQQLEwxDQSBBdXRob3JpdHkxLTArBgNVBAMTJFNpZXJyYSBT
eXN0ZW1zIENlcnRpZmljYXRlIEF1dGhvcml0eTEqMCgGCSqGSIb3DQEJARYbY2Ft
YW5hZ2VyQHNpZXJyYXN5c3RlbXMuY29tMB4XDTAyMDgwMTE1NTAzOFoXDTA0MDcz
MTE1NTAzOFowgaMxCzAJBgNVBAYTAkNBMSIwIAYDVQQKExlTaWVycmEgU3lzdGVt
cyBHcm91cCBJbmMuMRUwEwYDVQQLEwxDQSBBdXRob3JpdHkxLTArBgNVBAMTJFNp
ZXJyYSBTeXN0ZW1zIENlcnRpZmljYXRlIEF1dGhvcml0eTEqMCgGCSqGSIb3DQEJ
ARYbY2FtYW5hZ2VyQHNpZXJyYXN5c3RlbXMuY29tMIIBIjANBgkqhkiG9w0BAQEF
AAOCAQ8AMIIBCgKCAQEAtuMRmFIFWFVH3a5yAoy68nbQDW+LDn++q5Hukcan/NTn
tPnCMUZ4DlC5T1SCYgzYlKaQdbNQYQ+wjCquTR2alnYhIjQAf4HY0dHpw+x2jg7/
Wvvc3qx9B1Ra3qqCzWgZa33zSuoPlML5zgOUibKIqGz4Txn6ExWAQbF6m9RUnnpj
fwEpODZwBDd3DBYEE9pLeauCyvoPw5AGI2y/RS15LI/OPd+4cKe2IObdKfTGEixV
wp5gxJpjqP4gjPoGExGBhaVd7RdCRszKC+mzneaTAqet77kMRqjPMnu6ZSf+WU1f
eSbxAVlP66qna/MHt6CLFQP3S5WhGToug+t7c0U0EQIDAQABo4ICgTCCAn0wDwYD
VR0TAQH/BAUwAwEB/zAdBgNVHQ4EFgQUTxgYSDZoQ8RG0jWzbFAFp2x3HAcwgdAG
A1UdIwSByDCBxYAUTxgYSDZoQ8RG0jWzbFAFp2x3HAehgamkgaYwgaMxCzAJBgNV
BAYTAkNBMSIwIAYDVQQKExlTaWVycmEgU3lzdGVtcyBHcm91cCBJbmMuMRUwEwYD
VQQLEwxDQSBBdXRob3JpdHkxLTArBgNVBAMTJFNpZXJyYSBTeXN0ZW1zIENlcnRp
ZmljYXRlIEF1dGhvcml0eTEqMCgGCSqGSIb3DQEJARYbY2FtYW5hZ2VyQHNpZXJy
YXN5c3RlbXMuY29tggEAMAsGA1UdDwQEAwIBxjAmBgNVHREEHzAdgRtjYW1hbmFn
ZXJAc2llcnJhc3lzdGVtcy5jb20wJgYDVR0SBB8wHYEbY2FtYW5hZ2VyQHNpZXJy
YXN5c3RlbXMuY29tMBEGCWCGSAGG+EIBAQQEAwIABzBMBglghkgBhvhCAQ0EPxY9
U2llcnJhIFN5c3RlbXMgR3JvdXAgSW5jLiBDZXJ0aWZpY2F0aW9uIEF1dGhvcml0
eSBDZXJ0aWZpY2F0ZTA+BgNVHR8ENzA1MDOgMaAvhi1odHRwczovL2h0dHA6Ly93
c3ZhbjUxNC9jZ2ktYmluL2NybC9jYWNybC5jcmwwPAYJYIZIAYb4QgEEBC8WLWh0
dHBzOi8vaHR0cDovL3dzdmFuNTE0L2NnaS1iaW4vY3JsL2NhY3JsLmNybDA8Bglg
hkgBhvhCAQMELxYtaHR0cHM6Ly9odHRwOi8vd3N2YW41MTQvY2dpLWJpbi9jcmwv
Y2FjcmwuY3JsMA0GCSqGSIb3DQEBBAUAA4IBAQBR/oMIIhEGTSx861bmPHiUbV4b
WlpDcluomL0nw2sB3xK/Poz7P4+ls+Fz5y8QkJqrCljs1TaplywBmd2oflqbW4dZ
kalukTiy09yhSzgKqGWoEY5KNCx7aot4ubBxL7ThCXik8ogEv51lmNiHD8GY/9EB
m+9UZarnoztJYZQdS0zsSmA1V+aO2+5WkM0P/vd2E+0cd4sp2bOPX4eSlS4NOO46
LybTd9Di6hXnAAh3+BTptiwuGORP1elaICh5rfgsZ3flCU6gWozHE1pBY26OU4kD
f/VeEgprdVklzN46RBx6+QBjgWnMaOvI2SQkxII4jS0aD52KCikATVLIhG5eMYIC
MDCCAiwCAQEwgakwgaMxCzAJBgNVBAYTAkNBMSIwIAYDVQQKExlTaWVycmEgU3lz
dGVtcyBHcm91cCBJbmMuMRUwEwYDVQQLEwxDQSBBdXRob3JpdHkxLTArBgNVBAMT
JFNpZXJyYSBTeXN0ZW1zIENlcnRpZmljYXRlIEF1dGhvcml0eTEqMCgGCSqGSIb3
DQEJARYbY2FtYW5hZ2VyQHNpZXJyYXN5c3RlbXMuY29tAgEAMAkGBSsOAwIaBQCg
XTAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0wMjA4
MDIxMzM4MzFaMCMGCSqGSIb3DQEJBDEWBBTePhnxfALjiqDkMjLq92zR/FsEMDAN
BgkqhkiG9w0BAQEFAASCAQCAX8O0ApBtHNW6Q8FvfsWoJ9kpHpwL5spY+Y9UUfzm
lhWeZ31QYjs//KWw1ElTifLCyhs1/MPq3SlfPlJldExRZO0JTaNSkfgQFGeyWNY5
JeJ4BShrZNSUAd76yxdhlIEWoqLStGlrGLiRd/RtsN9HaKtZrz2oP1Oo7IdB9MZv
Ri3F4dm9TP4FMX8TbzuPE1Q/5GgB8GbjRrQF1gx0urwiYveaYeLk4LsyJviM0dSR
xWjZb6Ifo4jx3YqJk7cR7ZBi9bycZ+bFIKUeBQ1pElJn9nsDZxsgjKWI5bk07DK0
jmdPbDsw+Uyvqk+/cnLKsX3oR7VdQg8lSpZVum1ZMfyP
-----END PKCS7-----
-----END ATTRIBUTE-----
ROLE=User
CSR_SERIAL=1056
PIN=2843c5fd5bc1ad18571a6a813c51b98f22f00c60
-----END HEADER-----
-----BEGIN CERTIFICATE-----
MIIFYjCCBEqgAwIBAgIBBDANBgkqhkiG9w0BAQUFADCBozELMAkGA1UEBhMCQ0Ex
IjAgBgNVBAoTGVNpZXJyYSBTeXN0ZW1zIEdyb3VwIEluYy4xFTATBgNVBAsTDENB
IEF1dGhvcml0eTEtMCsGA1UEAxMkU2llcnJhIFN5c3RlbXMgQ2VydGlmaWNhdGUg
QXV0aG9yaXR5MSowKAYJKoZIhvcNAQkBFhtjYW1hbmFnZXJAc2llcnJhc3lzdGVt
cy5jb20wHhcNMDIwODAyMTMzODMwWhcNMDMwODAyMTMzODMwWjBVMQswCQYDVQQG
EwJDQTEiMCAGA1UEChMZU2llcnJhIFN5c3RlbXMgR3JvdXAgSW5jLjEPMA0GA1UE
CxMGcGVvcGxlMREwDwYDVQQDEwhEZWphbiBLSzCBnzANBgkqhkiG9w0BAQEFAAOB
jQAwgYkCgYEAt/TZWYGXhZeBqFaHMA7pXjaJIo5guviRa3TuLaD6jGRPCrHpSjM7
Hx5tCSle7PaZrqPhdnr8qkUJYpKxSOgXfy+0IrXegl70wqnNrjC/2S4AzWOjYUpI
Xs4BrMZ8qg1gcm0cLBdDJk329XCwjFtAPVOmr1kjbHn+RIoTKhXUcR0CAwEAAaOC
AnAwggJsMAkGA1UdEwQCMAAwEQYJYIZIAYb4QgEBBAQDAgWgMAsGA1UdDwQEAwIF
4DA8BglghkgBhvhCAQ0ELxYtVXNlciBDZXJ0aWZpY2F0ZSBvZiBTaWVycmEgU3lz
dGVtcyBHcm91cCBJbmMuMB0GA1UdDgQWBBT4F39ClVD/kpj/y3bhm0E7EeAlJTCB
0AYDVR0jBIHIMIHFgBRPGBhINmhDxEbSNbNsUAWnbHccB6GBqaSBpjCBozELMAkG
A1UEBhMCQ0ExIjAgBgNVBAoTGVNpZXJyYSBTeXN0ZW1zIEdyb3VwIEluYy4xFTAT
BgNVBAsTDENBIEF1dGhvcml0eTEtMCsGA1UEAxMkU2llcnJhIFN5c3RlbXMgQ2Vy
dGlmaWNhdGUgQXV0aG9yaXR5MSowKAYJKoZIhvcNAQkBFhtjYW1hbmFnZXJAc2ll
cnJhc3lzdGVtcy5jb22CAQAwKwYDVR0RBCQwIoEgZGVqYW5rdWxwaW5za2lAc2ll
cnJhc3lzdGVtcy5jb20wJgYDVR0SBB8wHYEbY2FtYW5hZ2VyQHNpZXJyYXN5c3Rl
bXMuY29tMDwGCWCGSAGG+EIBBAQvFi1odHRwczovL2h0dHA6Ly93c3ZhbjUxNC9j
Z2ktYmluL2NybC9jYWNybC5jcmwwPAYJYIZIAYb4QgEDBC8WLWh0dHBzOi8vaHR0
cDovL3dzdmFuNTE0L2NnaS1iaW4vY3JsL2NhY3JsLmNybDA+BgNVHR8ENzA1MDOg
MaAvhi1odHRwczovL2h0dHA6Ly93c3ZhbjUxNC9jZ2ktYmluL2NybC9jYWNybC5j
cmwwDQYJKoZIhvcNAQEFBQADggEBAAToV99qB3pLz2zNwyZctDDdQidEHMpE2Wso
WKsc2J7Y78cjGXaVewTeGK3PSglrPyBVr0lZ7TAxDSA9p9EldQAwC6dUVUj2NCca
CqTMD7KcOKyK+9YsFql9yEGoutAyxp0G3NiMgykPW7f9s8r/sJy6fAY2aqcoN9xY
cTRC6bwNqmKijzqLZt1Od6c0tX8cntdhKhd5UMfNGNkLoNK/qW/4jC5nZ7BIRrnE
9pUbGiLc8jcMbfwqKyLzu5gzg2rWMgtulMdgoSNUbqffNEkol2qmzodTFL+KwlRv
eW4wCZd2QaFdFO36YzBYkaiv/ny5aqFPQmHMbClINKyjozCcIXs=
-----END CERTIFICATE-----
', mykey='4', status='VALID', dn='CN=Dejan KK,OU=people,O=Sierra Systems Group Inc.,C=CA', cn='', email='', role='User', public_key='-----BEGIN PUBLIC KEY-----
MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQC39NlZgZeFl4GoVocwDuleNoki
jmC6+JFrdO4toPqMZE8KselKMzsfHm0JKV7s9pmuo+F2evyqRQlikrFI6Bd/L7Qi
td6CXvTCqc2uML/ZLgDNY6NhSkhezgGsxnyqDWBybRwsF0MmTfb1cLCMW0A9U6av
WSNsef5EihMqFdRxHQIDAQAB
-----END PUBLIC KEY-----', req_key='', notafter='20030802133830' where action_number=2
ERROR: Bad int8 external representation ""
DEBUG: AbortCurrentTransaction
DEBUG: StartTransactionCommand
DEBUG: query: rollback
DEBUG: ProcessUtility: rollback
DEBUG: CommitTransactionCommand
DEBUG: StartTransactionCommand
DEBUG: query: begin
DEBUG: ProcessUtility: begin
DEBUG: CommitTransactionCommand
DEBUG: StartTransactionCommand
DEBUG: query: rollback
DEBUG: ProcessUtility: rollback
DEBUG: CommitTransactionCommand
DEBUG: proc_exit(0)
DEBUG: shmem_exit(0)
DEBUG: exit(0)
DEBUG: reaping dead processes
DEBUG: child process (pid 25594) exited with exit code 0
DEBUG: proc_exit(0)
DEBUG: shmem_exit(0)
DEBUG: exit(0)
DEBUG: reaping dead processes
DEBUG: child process (pid 25639) exited with exit code 0
DEBUG: proc_exit(0)
DEBUG: shmem_exit(0)
DEBUG: exit(0)
DEBUG: reaping dead processes
DEBUG: child process (pid 25501) exited with exit code 0
The problem is that you are trying to write an empty string into int8 field (req_key field, log table). I had this problem before, but I just forgot about it, becuase I dissabled the line causing the problem. The problem occurs when you try to update the log entry in DBI::storeItem, line 1171.
Thanx for all the help,
Dejan
-----Original Message-----
From: Michael Bell [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 02, 2002 7:53 AM
To: [EMAIL PROTECTED]
Subject: [OpenCA-Devel] RC 3
Hi,
actually there are no complete open issues for RC 3 but we have to wait
for a comment on the DBI-bugfix for PostgreSQL. I will build a RC3 but
it is not the official one until the DBI-problem is fixed.
The bugfix has priority because the bug-reporter has OpenCA in real use.
Michael
--
-------------------------------------------------------------------
Michael Bell Email (private): [EMAIL PROTECTED]
Rechenzentrum - Datacenter Email: [EMAIL PROTECTED]
Humboldt-University of Berlin Tel.: +49 (0)30-2093 2482
Unter den Linden 6 Fax: +49 (0)30-2093 2959
10099 Berlin
Germany http://www.openca.org
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
OpenCA-Devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/openca-devel
