hi all,
i've installed latest version of openca in ubuntu 11.04
everything works fine in installation
after ca certificate initialization when clicking on ca certificate serial
number in valid ca certificate list (viewcert command), i get an internal
server error in apache, perl gives buffer overflow and exits! after debugging i
found out that it tries to query CERTIFICATE table in data base not
CA_CERTIFICATE! (select * from certificate where (cert_key=?) order by rowid)
but i dont know why its doing this! the links are ok in ui, viewcert command
works fine for valid certificates but for ca certificate it tries to query
certificate table!
any help or point will be appreciated!
this is debug for DBI.PM
OpenCA::DBI->connect: connecting to database
OpenCA::DBI->connect: try to connect
Issuing rollback() due to DESTROY without explicit disconnect() of
DBD::mysql::db handle database=iransign;host=localhost;port=3306;mysql_ssl=0 at
/opt/Iransign.2.1/lib/iransign/perl_modules/perl5/OpenCA/DBI.pm line 900.
OpenCA::DBI->connect: Checking AutoCommit to be off ...
OpenCA::DBI->connect: AutoCommit is off
OpenCA::DBI->connect: Setting characterset if the database support it ...
OpenCA::DBI->Entering set_error ...
OpenCA::DBI->errno: gettext is defined
OpenCA::DBI->errno: new errorcode is 0
OpenCA::DBI->doQuery: entering function
OpenCA::DBI->doQuery: query: SET NAMES 'utf8'
OpenCA::DBI->doQuery: prepare statement
OpenCA::DBI->doQuery: execute statement
OpenCA::DBI->doQuery: execute succeeded (leaving function - 0E0)
OpenCA::DBI->Entering set_error ...
OpenCA::DBI->errno: gettext is defined
OpenCA::DBI->errno: old errno 11111 is present
OpenCA::DBI->errno: new errorcode is 11111
OpenCA::DBI->connect: Characterset fixed if possible
OpenCA::DBI->Entering set_error ...
OpenCA::DBI->errno: gettext is defined
OpenCA::DBI->errno: new errorcode is 0
OpenCA::DBI->searchItems: Entering function searchItems
OpenCA::DBI->searchItems: OpenCA::DBI::errno: 0
OpenCA::DBI->getArguments: entering function
OpenCA::DBI->getArguments: check:KEY=7b5ba3a7542b81b743e3fc4ca10647ee9e24f690
OpenCA::DBI->getArguments: check:DATATYPE=CERTIFICATE
OpenCA::DBI->getArguments: TABLE:CERTIFICATE
OpenCA::DBI->getArguments: MODE:
OpenCA::DBI->Entering set_error ...
OpenCA::DBI->errno: gettext is defined
OpenCA::DBI->errno: new errorcode is 0
OpenCA::DBI->Entering set_error ...
OpenCA::DBI->errno: gettext is defined
OpenCA::DBI->errno: old errno 11111 is present
OpenCA::DBI->errno: new errorcode is 11111
OpenCA::DBI->getArguments: attribute: KEY
OpenCA::DBI->getArguments: value: 7b5ba3a7542b81b743e3fc4ca10647ee9e24f690
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:
OpenCA::DBI->getArguments: attribute: EXPIRES_BEFORE
OpenCA::DBI->getArguments: value:
OpenCA::DBI->getArguments: attribute: EXPIRES_AFTER
OpenCA::DBI->getArguments: value:
OpenCA::DBI->getArguments: attribute: NOTBEFORE
OpenCA::DBI->getArguments: value:
OpenCA::DBI->getArguments: attribute: NOTAFTER
OpenCA::DBI->getArguments: value:
OpenCA::DBI->getArguments: attribute: SUSPENDED_AFTER
OpenCA::DBI->getArguments: value:
OpenCA::DBI->getArguments: attribute: REVOKED_AFTER
OpenCA::DBI->getArguments: value:
OpenCA::DBI->getArguments: attribute: INVALIDITY_REASON
OpenCA::DBI->getArguments: value:
OpenCA::DBI->getArguments: attribute: ROWID
OpenCA::DBI->getArguments: value:
OpenCA::DBI->getArguments: attribute: LOA
OpenCA::DBI->getArguments: value:
OpenCA::DBI->Entering set_error ...
OpenCA::DBI->errno: gettext is defined
OpenCA::DBI->errno: new errorcode is 0
OpenCA::DBI->getStatus: Entering function
OpenCA::DBI->getStatus: no status given using datatype: CERTIFICATE
OpenCA::DBI->getStatus: given mode is now:
OpenCA::DBI->getStatus: no status (leaving function)
OpenCA::DBI->Entering set_error ...
OpenCA::DBI->errno: gettext is defined
OpenCA::DBI->errno: old errno 11111 is present
OpenCA::DBI->errno: new errorcode is 11111
OpenCA::DBI->getArguments: no STATUS present
OpenCA::DBI->getArguments: completed successful
OpenCA::DBI->searchItems: OpenCA::DBI::errno: 0
OpenCA::DBI->searchItems: dbi-status:
OpenCA::DBI->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<<
OpenCA::DBI->EXPIRES_BEFORE =>
OpenCA::DBI->EXPIRES_AFTER =>
OpenCA::DBI->TABLE => CERTIFICATE
OpenCA::DBI->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<<
OpenCA::DBI->searchItems: query now: select * from certificate where
(cert_key=?)
OpenCA::DBI->Entering set_error ...
OpenCA::DBI->errno: gettext is defined
OpenCA::DBI->errno: new errorcode is 0
OpenCA::DBI->Entering set_error ...
OpenCA::DBI->errno: gettext is defined
OpenCA::DBI->errno: old errno 11111 is present
OpenCA::DBI->errno: new errorcode is 11111
OpenCA::DBI->searchItems: scan attribute: KEY
OpenCA::DBI->searchItems: scan attribute: STATUS
OpenCA::DBI->searchItems: scan attribute: DN
OpenCA::DBI->searchItems: scan attribute: CN
OpenCA::DBI->searchItems: scan attribute: EMAIL
OpenCA::DBI->searchItems: scan attribute: ROLE
OpenCA::DBI->searchItems: scan attribute: PUBKEY
OpenCA::DBI->searchItems: scan attribute: CSR_SERIAL
OpenCA::DBI->searchItems: scan attribute: EXPIRES_BEFORE
OpenCA::DBI->searchItems: scan attribute: EXPIRES_AFTER
OpenCA::DBI->searchItems: scan attribute: NOTBEFORE
OpenCA::DBI->searchItems: scan attribute: NOTAFTER
OpenCA::DBI->searchItems: scan attribute: SUSPENDED_AFTER
OpenCA::DBI->searchItems: scan attribute: REVOKED_AFTER
OpenCA::DBI->searchItems: scan attribute: INVALIDITY_REASON
OpenCA::DBI->searchItems: scan attribute: ROWID
OpenCA::DBI->searchItems: scan attribute: LOA
OpenCA::DBI->searchItems: query now: select * from certificate where
(cert_key=?) order by rowid
OpenCA::DBI->searchItems: arguments: 7b5ba3a7542b81b743e3fc4ca10647ee9e24f690
OpenCA::DBI->Entering set_error ...
OpenCA::DBI->errno: gettext is defined
OpenCA::DBI->errno: new errorcode is 0
OpenCA::DBI->doQuery: entering function
OpenCA::DBI->doQuery: query: select * from certificate where (cert_key=?) order
by rowid
OpenCA::DBI->doQuery: bind_values: 7b5ba3a7542b81b743e3fc4ca10647ee9e24f690
OpenCA::DBI->doQuery: prepare statement
------------------------------------------------------------------------------
The demand for IT networking professionals continues to grow, and the
demand for specialized networking skills is growing even more rapidly.
Take a complimentary Learning@Cisco Self-Assessment and learn
about Cisco certifications, training, and career opportunities.
http://p.sf.net/sfu/cisco-dev2dev
_______________________________________________
Openca-Users mailing list
Openca-Users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openca-users
