hi on the ca side I click on CRLs and i get an error message form Netscape say that the document contains no data. here is the output of the DBI debug
Debugging is activated! defining the class parameters checking the configuration for enough data preparing the database (vendor dependent) Pg detected DB: dbi:Pg:dbname=rootca091;host=box176.pki.irm.vt.edu;port=5432 connecting to database try to connect Checking AutoCommit to be off ... AutoCommit is off OpenCA::DBI should now complete Content-type: text/html ### new function call ### Entering getArguments OpenCA::DBI->getArguments: TABLE:CRL 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: LAST_UPDATE OpenCA::DBI->getArguments: value: OpenCA::DBI->getArguments: attribute: NEXT_UPDATE OpenCA::DBI->getArguments: value: ### new function call ### Entering getStatus no status given using datatype: VALID_CRL given mode is now: "VALID" legal status ### leaving function successful ### OpenCA::DBI->getArguments: status: VALID completed successful ### leaving function getArguments ### ### new function call ### Entering function elements ### new function call ### Entering sub doQuery query: select count(*) from crl where status like ? bind_values: VALID prepare statement statement nr.: 1 execute statement execute succeeded ### leaving function doQuery successfully ### state: $rv= elements comleted successful ### leaving function elements ### ### new function call ### Entering function listItems ### new function call ### Entering getArguments OpenCA::DBI->getArguments: TABLE:CRL 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: LAST_UPDATE OpenCA::DBI->getArguments: value: OpenCA::DBI->getArguments: attribute: NEXT_UPDATE OpenCA::DBI->getArguments: value: ### new function call ### Entering getStatus no status given using datatype: VALID_CRL given mode is now: "VALID" legal status ### leaving function successful ### OpenCA::DBI->getArguments: status: VALID completed successful ### leaving function getArguments ### OpenCA::DBI->listItems: query: select * from crl where (status like ?) OpenCA::DBI->listItems: limited query: select * from crl where (status like ?) LIMIT 20 ### new function call ### Entering sub doQuery query: select * from crl where (status like ?) LIMIT 20 bind_values: VALID prepare statement statement nr.: 2 execute statement execute succeeded ### leaving function doQuery successfully ### 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:CRL_SERIAL value:f4c4d91f0b1711320f4a1f3f1a114c4f column:STATUS value:VALID column:FORMAT value:PEM column:DATA value:-----BEGIN HEADER----- -----END HEADER----- -----BEGIN X509 CRL----- MIIBqTCBkjANBgkqhkiG9w0BAQQFADBNMRMwEQYKCZImiZPyLGQBGRMDZWR1MRIw EAYKCZImiZPyLGQBGRMCdnQxIjAgBgNVBAMTGURFViBWaXJnaW5pYSBUZWNoIFJv b3QgQ0EXDTAyMTExNDE4MDY1MloXDTAzMDkxMzE4MDY1MlowFDASAgEEFw0wMjEx MTQxODA1MjNaMA0GCSqGSIb3DQEBBAUAA4IBAQA6MQ0nq3HyC9qP39kU3q8Hp3ZJ fm8sfBJbFJ7peJUYk/5NrhsZtMhyAQRryVxXl23QvuxYVmz+gV9c5HGO8Kd1JkSN Z03as7m6ze/3JCWhRkjNM9+0GANmPpMsNJzWr/JBEFfap2h2d2PFhYe1Xeg9/Wem zSACkqdXWpABd5T56YggAm42bw7yvCRQRyd+ktWHyq8jWNX6RoI55DVSWSG5/9eH IIPNh+pb7ueiRID4U6vI0k6gOs5YIlEm5YCF90ozo35VyfWuNJAF+WEUuWTjCHkR eexYuDwCdg3pPoqOzUy0SWLLlqehh7perlEnFD74xWU1zRNnGh7Y9R1TOYiq -----END X509 CRL----- column:LAST_UPDATE value: column:NEXT_UPDATE value: ### leaving function getResultHash ### OpenCA::DBI->getResultItem: data: -----BEGIN HEADER----- -----END HEADER----- -----BEGIN X509 CRL----- MIIBqTCBkjANBgkqhkiG9w0BAQQFADBNMRMwEQYKCZImiZPyLGQBGRMDZWR1MRIw EAYKCZImiZPyLGQBGRMCdnQxIjAgBgNVBAMTGURFViBWaXJnaW5pYSBUZWNoIFJv b3QgQ0EXDTAyMTExNDE4MDY1MloXDTAzMDkxMzE4MDY1MlowFDASAgEEFw0wMjEx MTQxODA1MjNaMA0GCSqGSIb3DQEBBAUAA4IBAQA6MQ0nq3HyC9qP39kU3q8Hp3ZJ fm8sfBJbFJ7peJUYk/5NrhsZtMhyAQRryVxXl23QvuxYVmz+gV9c5HGO8Kd1JkSN Z03as7m6ze/3JCWhRkjNM9+0GANmPpMsNJzWr/JBEFfap2h2d2PFhYe1Xeg9/Wem zSACkqdXWpABd5T56YggAm42bw7yvCRQRyd+ktWHyq8jWNX6RoI55DVSWSG5/9eH IIPNh+pb7ueiRID4U6vI0k6gOs5YIlEm5YCF90ozo35VyfWuNJAF+WEUuWTjCHkR eexYuDwCdg3pPoqOzUy0SWLLlqehh7perlEnFD74xWU1zRNnGh7Y9R1TOYiq -----END X509 CRL----- OpenCA::DBI->getResultItem: format: PEM OpenCA::DBI->getResultItem: have all data OpenCA::DBI->getResultItem: data of item: -----BEGIN HEADER----- -----END HEADER----- -----BEGIN X509 CRL----- MIIBqTCBkjANBgkqhkiG9w0BAQQFADBNMRMwEQYKCZImiZPyLGQBGRMDZWR1MRIw EAYKCZImiZPyLGQBGRMCdnQxIjAgBgNVBAMTGURFViBWaXJnaW5pYSBUZWNoIFJv b3QgQ0EXDTAyMTExNDE4MDY1MloXDTAzMDkxMzE4MDY1MlowFDASAgEEFw0wMjEx MTQxODA1MjNaMA0GCSqGSIb3DQEBBAUAA4IBAQA6MQ0nq3HyC9qP39kU3q8Hp3ZJ fm8sfBJbFJ7peJUYk/5NrhsZtMhyAQRryVxXl23QvuxYVmz+gV9c5HGO8Kd1JkSN Z03as7m6ze/3JCWhRkjNM9+0GANmPpMsNJzWr/JBEFfap2h2d2PFhYe1Xeg9/Wem zSACkqdXWpABd5T56YggAm42bw7yvCRQRyd+ktWHyq8jWNX6RoI55DVSWSG5/9eH IIPNh+pb7ueiRID4U6vI0k6gOs5YIlEm5YCF90ozo35VyfWuNJAF+WEUuWTjCHkR eexYuDwCdg3pPoqOzUy0SWLLlqehh7perlEnFD74xWU1zRNnGh7Y9R1TOYiq -----END X509 CRL----- OpenCA::DBI->getItem: try to create crl OpenCA::DBI->getResultItem: crl there OpenCA::DBI->getResultItem: return item OpenCA::DBI->listItems: added item f4c4d91f0b1711320f4a1f3f1a114c4f to result listItems completed successful ### leaving function successfully ### ### new function call ### Entering getArguments OpenCA::DBI->getArguments: TABLE:CRL 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: LAST_UPDATE OpenCA::DBI->getArguments: value: OpenCA::DBI->getArguments: attribute: NEXT_UPDATE OpenCA::DBI->getArguments: value: ### new function call ### Entering getStatus no status given using datatype: VALID_CRL given mode is now: "VALID" legal status ### leaving function successful ### OpenCA::DBI->getArguments: status: VALID completed successful ### leaving function getArguments ### OpenCA::DBI->getNextItem: query: select MIN(crl_key) from crl where (crl_key > ? ) and (status like ?) ### new function call ### Entering sub doQuery query: select MIN(crl_key) from crl where (crl_key > ? ) and (status like ?) bind_values: . bind_values: VALID prepare statement statement nr.: 3 execute statement execute succeeded ### leaving function doQuery successfully ### OpenCA::DBI->getItem: ### new function call ### OpenCA::DBI->getItem: Entering sub getItem ### new function call ### Entering getArguments OpenCA::DBI->getArguments: TABLE:CRL OpenCA::DBI->getArguments: MODE: OpenCA::DBI->getArguments: attribute: KEY OpenCA::DBI->getArguments: value: f4c4d91f0b1711320f4a1f3f1a114c4f OpenCA::DBI->getArguments: attribute: STATUS OpenCA::DBI->getArguments: value: OpenCA::DBI->getArguments: attribute: LAST_UPDATE OpenCA::DBI->getArguments: value: OpenCA::DBI->getArguments: attribute: NEXT_UPDATE OpenCA::DBI->getArguments: value: ### new function call ### Entering getStatus no status given using datatype: CRL given mode is now: "" illegal status or no status ### leaving function unsuccessful but without error ### completed successful ### leaving function getArguments ### OpenCA::DBI->getItem: data complete OpenCA::DBI->getItem: query: select * from crl where (crl_key=?) ### new function call ### Entering sub doQuery query: select * from crl where (crl_key=?) bind_values: f4c4d91f0b1711320f4a1f3f1a114c4f prepare statement statement nr.: 4 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:CRL_SERIAL value:f4c4d91f0b1711320f4a1f3f1a114c4f column:STATUS value:VALID column:FORMAT value:PEM column:DATA value:-----BEGIN HEADER----- -----END HEADER----- -----BEGIN X509 CRL----- MIIBqTCBkjANBgkqhkiG9w0BAQQFADBNMRMwEQYKCZImiZPyLGQBGRMDZWR1MRIw EAYKCZImiZPyLGQBGRMCdnQxIjAgBgNVBAMTGURFViBWaXJnaW5pYSBUZWNoIFJv b3QgQ0EXDTAyMTExNDE4MDY1MloXDTAzMDkxMzE4MDY1MlowFDASAgEEFw0wMjEx MTQxODA1MjNaMA0GCSqGSIb3DQEBBAUAA4IBAQA6MQ0nq3HyC9qP39kU3q8Hp3ZJ fm8sfBJbFJ7peJUYk/5NrhsZtMhyAQRryVxXl23QvuxYVmz+gV9c5HGO8Kd1JkSN Z03as7m6ze/3JCWhRkjNM9+0GANmPpMsNJzWr/JBEFfap2h2d2PFhYe1Xeg9/Wem zSACkqdXWpABd5T56YggAm42bw7yvCRQRyd+ktWHyq8jWNX6RoI55DVSWSG5/9eH IIPNh+pb7ueiRID4U6vI0k6gOs5YIlEm5YCF90ozo35VyfWuNJAF+WEUuWTjCHkR eexYuDwCdg3pPoqOzUy0SWLLlqehh7perlEnFD74xWU1zRNnGh7Y9R1TOYiq -----END X509 CRL----- column:LAST_UPDATE value: column:NEXT_UPDATE value: ### leaving function getResultHash ### OpenCA::DBI->getResultItem: data: -----BEGIN HEADER----- -----END HEADER----- -----BEGIN X509 CRL----- MIIBqTCBkjANBgkqhkiG9w0BAQQFADBNMRMwEQYKCZImiZPyLGQBGRMDZWR1MRIw EAYKCZImiZPyLGQBGRMCdnQxIjAgBgNVBAMTGURFViBWaXJnaW5pYSBUZWNoIFJv b3QgQ0EXDTAyMTExNDE4MDY1MloXDTAzMDkxMzE4MDY1MlowFDASAgEEFw0wMjEx MTQxODA1MjNaMA0GCSqGSIb3DQEBBAUAA4IBAQA6MQ0nq3HyC9qP39kU3q8Hp3ZJ fm8sfBJbFJ7peJUYk/5NrhsZtMhyAQRryVxXl23QvuxYVmz+gV9c5HGO8Kd1JkSN Z03as7m6ze/3JCWhRkjNM9+0GANmPpMsNJzWr/JBEFfap2h2d2PFhYe1Xeg9/Wem zSACkqdXWpABd5T56YggAm42bw7yvCRQRyd+ktWHyq8jWNX6RoI55DVSWSG5/9eH IIPNh+pb7ueiRID4U6vI0k6gOs5YIlEm5YCF90ozo35VyfWuNJAF+WEUuWTjCHkR eexYuDwCdg3pPoqOzUy0SWLLlqehh7perlEnFD74xWU1zRNnGh7Y9R1TOYiq -----END X509 CRL----- OpenCA::DBI->getResultItem: format: PEM OpenCA::DBI->getResultItem: have all data OpenCA::DBI->getResultItem: data of item: -----BEGIN HEADER----- -----END HEADER----- -----BEGIN X509 CRL----- MIIBqTCBkjANBgkqhkiG9w0BAQQFADBNMRMwEQYKCZImiZPyLGQBGRMDZWR1MRIw EAYKCZImiZPyLGQBGRMCdnQxIjAgBgNVBAMTGURFViBWaXJnaW5pYSBUZWNoIFJv b3QgQ0EXDTAyMTExNDE4MDY1MloXDTAzMDkxMzE4MDY1MlowFDASAgEEFw0wMjEx MTQxODA1MjNaMA0GCSqGSIb3DQEBBAUAA4IBAQA6MQ0nq3HyC9qP39kU3q8Hp3ZJ fm8sfBJbFJ7peJUYk/5NrhsZtMhyAQRryVxXl23QvuxYVmz+gV9c5HGO8Kd1JkSN Z03as7m6ze/3JCWhRkjNM9+0GANmPpMsNJzWr/JBEFfap2h2d2PFhYe1Xeg9/Wem zSACkqdXWpABd5T56YggAm42bw7yvCRQRyd+ktWHyq8jWNX6RoI55DVSWSG5/9eH IIPNh+pb7ueiRID4U6vI0k6gOs5YIlEm5YCF90ozo35VyfWuNJAF+WEUuWTjCHkR eexYuDwCdg3pPoqOzUy0SWLLlqehh7perlEnFD74xWU1zRNnGh7Y9R1TOYiq -----END X509 CRL----- OpenCA::DBI->getItem: try to create crl OpenCA::DBI->getResultItem: crl there OpenCA::DBI->getResultItem: return item ### new function call ### Entering getArguments OpenCA::DBI->getArguments: TABLE:CRL 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: LAST_UPDATE OpenCA::DBI->getArguments: value: OpenCA::DBI->getArguments: attribute: NEXT_UPDATE OpenCA::DBI->getArguments: value: ### new function call ### Entering getStatus no status given using datatype: VALID_CRL given mode is now: "VALID" legal status ### leaving function successful ### OpenCA::DBI->getArguments: status: VALID completed successful ### leaving function getArguments ### ### new function call ### Entering sub doQuery query: select MAX(crl_key) from crl where (crl_key< ? ) and (status=?) bind_values: } bind_values: VALID prepare statement statement nr.: 5 execute statement execute succeeded ### leaving function doQuery successfully ### OpenCA::DBI->getItem: ### new function call ### OpenCA::DBI->getItem: Entering sub getItem ### new function call ### Entering getArguments OpenCA::DBI->getArguments: TABLE:CRL 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: LAST_UPDATE OpenCA::DBI->getArguments: value: OpenCA::DBI->getArguments: attribute: NEXT_UPDATE OpenCA::DBI->getArguments: value: ### new function call ### Entering getStatus no status given using datatype: CRL given mode is now: "" illegal status or no status ### leaving function unsuccessful but without error ### completed successful ### leaving function getArguments ### OpenCA::DBI->getItem: data complete OpenCA::DBI->getItem: query: select * from crl where submit_date like (select MAX(submit_date) from crl) ### new function call ### Entering sub doQuery query: select * from crl where submit_date like (select MAX(submit_date) from crl) prepare statement statement nr.: 6 execute statement execute failed ### leaving function doQuery unsuccessfully ### OpenCA::DBI automatic rollback by destructor DESTROY OpenCA::DBI->rollback Thanks -- Bahaaldin Al-amood [EMAIL PROTECTED] Operations Specialist Virginia Polytechnic Institute And State University AISB 1700 Pratt Drive Blacksburg, VA, 24060 (540)231-2630 ------------------------------------------------------- This sf.net email is sponsored by: To learn the basics of securing your web site with SSL, click here to get a FREE TRIAL of a Thawte Server Certificate: http://www.gothawte.com/rd524.html _______________________________________________ Openca-Users mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/openca-users
