RE: [Openca-Users] Error 700 in attempting to initialize database

2004-08-18 Thread Tiller, Robert

yeah,  sorry about that...I need to fix my options on the exchange
server.  Here is the configure script again that I used to create
the ca:
#!/bin/sh
./configure \
  --with-prefix=/usr/local/openca \
  --with-openca-prefix=/usr/local/openca \
  --with-etc-prefix=/usr/local/openca/etc \
  --with-lib-prefix=/usr/local/openca/lib \
  --with-var-prefix=/usr/local/openca/var \
  --with-httpd-fs-prefix=/srv/www \
  --with-htdocs-fs-prefix=/srv/www/htdocs \
  --with-node-prefix=ca-node \
  --with-module-prefix=/usr/local/openca/modules \
  --with-cgi-fs-prefix=/srv/www/cgi-bin \
  --with-openssl-prefix=/usr/local/ssl \
  --with-httpd-port=80 \
  --with-web-host=localhost \
  --with-engine=no \
  --with-httpd-user=wwwrun \
  --with-httpd-group=www \
  --with-openca-user=openca \
  --with-openca-group=pki

here is the Configure.ra:
#!/bin/sh
./configure \
  --with-prefix=/usr/local/openra \
  --with-openca-prefix=/usr/local/openra \
  --with-etc-prefix=/usr/local/openra/etc \
  --with-lib-prefix=/usr/local/openra/lib \
  --with-var-prefix=/usr/local/openra/var \
  --with-module-prefix=/usr/local/openra/modules \
  --with-httpd-fs-prefix=/srv/www \
  --with-htdocs-fs-prefix=/srv/www/htdocs \
  --with-node-prefix=ra-node \
  --with-cgi-fs-prefix=/srv/www/cgi-bin \
  --with-openssl-prefix=/usr/local/ssl \
  --with-httpd-port=80 \
  --with-web-host=localhost \
  --with-engine=no \
  --enable-scep \
  --enable-ocspd \
  --with-httpd-user=wwwrun \
  --with-httpd-group=www \
  --with-openca-user=openca \
  --with-openca-group=pki

You have to install 0.9.7c openssl and then openca.
Do a make clean between the ca and ra build.
Let me know if this helps.  

Robert

-Original Message-
From:   [EMAIL PROTECTED] on behalf of Kevin
Sent:   Wed 8/18/2004 6:32 PM
To: [EMAIL PROTECTED]
Cc: 
Subject:RE: [Openca-Users] Error 700 in attempting to initialize database
On Wed, 2004-08-18 at 19:02, Tiller, Robert wrote:
> here is the config file for ca
> 
> 

Thanks, Robert.  I see a binary attachment named winmail.dat and when I
less through it, I see what looks like a ./configure line for openca
hidden in amongst alot of binary stuff.  Should I take that to mean that
you think I should start over with this as a set of configure options to
use?  Thanks for your reply.

-Kevin




---
SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
___
Openca-Users mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/openca-users



<>

RE: [Openca-Users] Error 700 in attempting to initialize database

2004-08-18 Thread Kevin
On Wed, 2004-08-18 at 19:02, Tiller, Robert wrote:
> here is the config file for ca
> 
> 

Thanks, Robert.  I see a binary attachment named winmail.dat and when I
less through it, I see what looks like a ./configure line for openca
hidden in amongst alot of binary stuff.  Should I take that to mean that
you think I should start over with this as a set of configure options to
use?  Thanks for your reply.

-Kevin




---
SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
___
Openca-Users mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/openca-users


RE: [Openca-Users] Error 700 in attempting to initialize database

2004-08-18 Thread Tiller, Robert
here is the config file for ca


-Original Message-
From:   [EMAIL PROTECTED] on behalf of Kevin
Sent:   Wed 8/18/2004 5:44 PM
To: [EMAIL PROTECTED]
Cc: 
Subject:Re: [Openca-Users] Error 700 in attempting to initialize database
On Wed, 2004-08-18 at 16:37, Ives Steglich wrote:
> Tiller, Robert wrote:
> > I don't know if this is the same error I had, but some earlier versions of
> > openca had a permission error on the db files.  Mainly DBM files not
> > SQL.  You might check the file permissions.
> >
> but this would not be good - i thought we solved those problems before 
> rc6... could be it was afterwards... but acutally it shouldn't happend 
> anymore - at least with cvs ,o)
> 
> yes - check file permissions in var/db/ if its not your 
> apacheuser:apachegroup just delete the files (there should be none 
> before initialization) or change the ownerchip to the apache stuff
> 

I have no files in /usr/local/open[cr]a/openca/var/db, and the ownership
of each directory itself is apacheuser:apachegroup.

Based on the error message, I was thinking that this error would be a
code problem, no?  Perhaps related to configuration?  But I'm really
without a clue.

I had to make some adjustments to the aliases that I used in httpd.conf
because I configured with --with-node-prefix=online-ra-node and
--with-node-prefix=offline-ca-node instead of the cookbook recommended
--with-node-prefix=[cr]a-node.  I just did it to help me keep straight
in my mind which was online and which was offline, but I found that it
threw a couple of small wrenches into my configuration.  I think I
ferreted them all out, but perhaps this problem is another result of
that minor change I made.

Thanks dalani and Robert for your replies though.  Any other thoughts? 
Should I simply start over from scratch?  Perhaps with a new SuSE 9.0 or
9.1 box?  I'm trying to compile OpenCA on Gentoo, but seem to have a
problem with my perl setup (see thread, Problem compiling:
XML::Parser-2.23 important vice 2.34?) so I can't make a comparison
there either---I can't even complete the make step.

Again, thanks for being so patient with an OpenCA newbie.

-Kevin




---
SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
___
Openca-Users mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/openca-users




<>

Re: [Openca-Users] Error 700 in attempting to initialize database

2004-08-18 Thread Kevin
On Wed, 2004-08-18 at 16:37, Ives Steglich wrote:
> Tiller, Robert wrote:
> > I don't know if this is the same error I had, but some earlier versions of
> > openca had a permission error on the db files.  Mainly DBM files not
> > SQL.  You might check the file permissions.
> >
> but this would not be good - i thought we solved those problems before 
> rc6... could be it was afterwards... but acutally it shouldn't happend 
> anymore - at least with cvs ,o)
> 
> yes - check file permissions in var/db/ if its not your 
> apacheuser:apachegroup just delete the files (there should be none 
> before initialization) or change the ownerchip to the apache stuff
> 

I have no files in /usr/local/open[cr]a/openca/var/db, and the ownership
of each directory itself is apacheuser:apachegroup.

Based on the error message, I was thinking that this error would be a
code problem, no?  Perhaps related to configuration?  But I'm really
without a clue.

I had to make some adjustments to the aliases that I used in httpd.conf
because I configured with --with-node-prefix=online-ra-node and
--with-node-prefix=offline-ca-node instead of the cookbook recommended
--with-node-prefix=[cr]a-node.  I just did it to help me keep straight
in my mind which was online and which was offline, but I found that it
threw a couple of small wrenches into my configuration.  I think I
ferreted them all out, but perhaps this problem is another result of
that minor change I made.

Thanks dalani and Robert for your replies though.  Any other thoughts? 
Should I simply start over from scratch?  Perhaps with a new SuSE 9.0 or
9.1 box?  I'm trying to compile OpenCA on Gentoo, but seem to have a
problem with my perl setup (see thread, Problem compiling:
XML::Parser-2.23 important vice 2.34?) so I can't make a comparison
there either---I can't even complete the make step.

Again, thanks for being so patient with an OpenCA newbie.

-Kevin




---
SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
___
Openca-Users mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/openca-users


Re: [Openca-Users] Error 700 in attempting to initialize database

2004-08-18 Thread Ives Steglich
Tiller, Robert wrote:
I don't know if this is the same error I had, but some earlier versions of
openca had a permission error on the db files.  Mainly DBM files not
SQL.  You might check the file permissions.
but this would not be good - i thought we solved those problems before 
rc6... could be it was afterwards... but acutally it shouldn't happend 
anymore - at least with cvs ,o)

yes - check file permissions in var/db/ if its not your 
apacheuser:apachegroup just delete the files (there should be none 
before initialization) or change the ownerchip to the apache stuff

greetings
dalini
--
Ives SteglichEmail: [EMAIL PROTECTED]
System AdministrationTel.:  +49 (0)3677 - 69 4382/4383
 Fax:   +49 (0)3677 - 69 4399
Fraunhofer Institute for Digital Media Technology
Langewiesener Strasse 22
98693 IlmenauEmail (private): [EMAIL PROTECTED]
Germany  http://www.openca.org
---
SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
___
Openca-Users mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/openca-users


RE: [Openca-Users] Error 700 in attempting to initialize database

2004-08-18 Thread Tiller, Robert

I don't know if this is the same error I had, but some earlier versions of
openca had a permission error on the db files.  Mainly DBM files not
SQL.  You might check the file permissions.

thanks!
Robert


-Original Message-
From:   [EMAIL PROTECTED] on behalf of Kevin
Sent:   Wed 8/18/2004 11:23 AM
To: [EMAIL PROTECTED]
Cc: 
Subject:[Openca-Users] Error 700 in attempting to initialize database
At the risk of getting yelled at, I have another question... (sorry...)

This time I've read both the cookbook and the relevant portions of the
guide.  As usual, I've also searched the list archives, searched through
the entire guide for this particular error, and double-checked the steps
I performed in the cookbook.  I'm not finding anything to help me solve
this.  That said, however, it's true that I have not read the guide from
cover to cover.  If I'm wrong for asking a question here in such
circumstances, someone please feel free to correct me.  I promise I
won't take offense.

I'm following the steps exactly in the cookbook:
Series of tabs should be visible.  Select General->Initialization
 Phase I
Initialize the Certification Authority
Initialize Database
 
initialize-> intialize DB .(reports sucess, but a slurry of error messages 
about table not found may appear on the console)

Anyway, when I attempt to initialize the database, I get this error:
Error 700
General Error. The compilation of the command cmdGenDB failed. Can't
call method "prepare" on an undefined value at
/usr/local/openca/modules/perl5/OpenCA/DBI.pm line 2518.

When I look at line 2518 of said file, I see:
   2515   ## prepare
   2516   $self->debug ("doQuery: prepare statement");
   2517   $self->debug ("doQuery: statement nr.: ".(scalar (@
   2517 {$self->{STH}}) +1));
   2518   $self->{STH}[scalar (@{$self->{STH}})] = $self->{DB
   2518 H}->prepare ($query);
   2519   if ( (my $h = $self->{STH}[scalar (@{$self->{STH}})
   2519  -1]->state) != 0) {
   2520 $self->debug ("doQuery: prepare failed");
   2521 $self->debug ("doQuery: query: $query");
   2522 $self->debug ("doQuery: returned errorcode: $h");
   2523 $self->errno ( $OpenCA::DBI::ERROR->{PREPARE_FAIL
   2523 ED} );
   2524 return undef;
   2525   }

Not being very clueful on perl in general, I'm definitely out of my
league trying to interpret perl code.

Can anyone offer suggestions on how to resolve this?  I suppose I must
have screwed up something in my config files.  Should I post those?  If
so, just say so and I will.

Sorry to be such a pain, guys.

Thanks for any help.

-Kevin




---
SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
___
Openca-Users mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/openca-users



<>

[Openca-Users] Error 700 in attempting to initialize database

2004-08-18 Thread Kevin
At the risk of getting yelled at, I have another question... (sorry...)

This time I've read both the cookbook and the relevant portions of the
guide.  As usual, I've also searched the list archives, searched through
the entire guide for this particular error, and double-checked the steps
I performed in the cookbook.  I'm not finding anything to help me solve
this.  That said, however, it's true that I have not read the guide from
cover to cover.  If I'm wrong for asking a question here in such
circumstances, someone please feel free to correct me.  I promise I
won't take offense.

I'm following the steps exactly in the cookbook:
Series of tabs should be visible.  Select General->Initialization
 Phase I
Initialize the Certification Authority
Initialize Database
 
initialize-> intialize DB .(reports sucess, but a slurry of error messages 
about table not found may appear on the console)

Anyway, when I attempt to initialize the database, I get this error:
Error 700
General Error. The compilation of the command cmdGenDB failed. Can't
call method "prepare" on an undefined value at
/usr/local/openca/modules/perl5/OpenCA/DBI.pm line 2518.

When I look at line 2518 of said file, I see:
   2515   ## prepare
   2516   $self->debug ("doQuery: prepare statement");
   2517   $self->debug ("doQuery: statement nr.: ".(scalar (@
   2517 {$self->{STH}}) +1));
   2518   $self->{STH}[scalar (@{$self->{STH}})] = $self->{DB
   2518 H}->prepare ($query);
   2519   if ( (my $h = $self->{STH}[scalar (@{$self->{STH}})
   2519  -1]->state) != 0) {
   2520 $self->debug ("doQuery: prepare failed");
   2521 $self->debug ("doQuery: query: $query");
   2522 $self->debug ("doQuery: returned errorcode: $h");
   2523 $self->errno ( $OpenCA::DBI::ERROR->{PREPARE_FAIL
   2523 ED} );
   2524 return undef;
   2525   }

Not being very clueful on perl in general, I'm definitely out of my
league trying to interpret perl code.

Can anyone offer suggestions on how to resolve this?  I suppose I must
have screwed up something in my config files.  Should I post those?  If
so, just say so and I will.

Sorry to be such a pain, guys.

Thanks for any help.

-Kevin




---
SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
___
Openca-Users mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/openca-users