Hi Samuel Rios Carvalho schrieb: > > select status,dn,date(notafter),time(notafter) from certificate > where status = 'EXPIRED'; > > So cmdlistCerts doesn't seem to do the correct query. > I will try to fix that on this weekend. > You can download the fixed version of OpenCA::DBI.pm here:
http://www.ralf-hornik.de/pub/patches/openca/DBI.pm Please replace it with <openca_prefix>/modules/perl5/OpenCA/DBI.pm @Max. Since the status of expired certificates is being updated in DB, there is no need to use "handleExpiredCert" any more. I think it can be completely removed. Please test it and give a short feedback Regards Ralf ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Openca-Users mailing list Openca-Users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openca-users