RE: [Openca-Users] Error 700 in attempting to initialize database
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
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
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
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
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
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
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