On Mon, 2009-01-12 at 12:12 -0500, David W Blaine wrote:
> 
> Bump. 
> 
> Has anyone had this issue? 
> 
> -----------------------------------------------------------------
> DAVID BLAINE, GCIA , CISSP
> GDLS-C Lead Information Risk Manager (LIRM)
> CSC
> 
<snip>
Not sure what the original problem was but we did have a problem
initially signing CSRs.  We had to patch the src with the attached
patch.  As I've mentioned before on this list, I don't know a thing
about perl so this patch may be bad but it worked for us.  This is by no
means official OpenCA code!

It is applied within src/modules/openca-dbi with patch -p0 <
opencaDBI.pm-1.0.2.patch.  I don't know if this is your problem - John
-- 
John A. Sullivan III
Open Source Development Corporation
+1 207-985-7880
jsulli...@opensourcedevel.com

http://www.spiritualoutreach.com
Making Christianity intelligible to secular society
--- DBI.pm	2008-12-07 00:53:21.000000000 +0000
+++ DBI.fixed.pm	2008-12-06 21:52:16.000000000 +0000
@@ -2380,9 +2380,11 @@
     }
   }
 
-  ## order by key to support correct listings
-  $query.= " order by ".
-           $OpenCA::DBI::SQL->{VARIABLE}->{$arguments {TABLE}."_ORDERBY"}[0];
+  if ( $mode ne "count(*)" ) {
+      ## order by key to support correct listings
+      $query.= " order by ".
+             $OpenCA::DBI::SQL->{VARIABLE}->{$arguments {TABLE}."_ORDERBY"}[0];
+  }
 
   $self->debug ("searchItems: query: $query");
 
------------------------------------------------------------------------------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
_______________________________________________
Openca-Users mailing list
Openca-Users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openca-users

Reply via email to