On Wed, Dec 28, 2005 at 03:18:18PM +0100, Johnny Gonzalez wrote: > Date: Wed, 28 Dec 2005 15:18:18 +0100 (CET) > From: Johnny Gonzalez <[EMAIL PROTECTED]> > To: Openca Users list <[email protected]> > Reply-To: [email protected] > Subject: [Openca-Users] Problems with DB (Postgresql) > > I have a proble with my db. I have to change my RA > machine, because a hardware problem, so I made a > backup of my RA configuration and my database too. So > to obtain my backup I did: pg_dump -f openra.sql > openra > > After that I restored it in the new machine with: > > createuser -A -d -P openca > createdb -U openca -W openra > > psql -f openra.sql -U openca openra > > > Until here everything is ok, If I connect to my RA > through the web interface I can see all certificates, > CSRs, CRRs, CA certs, etc. but If I click on the ID of > my ca certificate, I get this error message: > > Error 690 > Configuration Error. Error 0, unable > to get cert from dB! (Success (error 11111: Do not > commit if the database or the module itself fails.)).
Beside backing up DB, did you preserve files in /var/openca/ ? You could also use Dataexchange->Backup to save everything in the file. This is more suitable, if you are planning to upgrade openca. -- Alexei Chetroi Smile... Tomorrow will be worse. (c) Murphy's Law ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click _______________________________________________ Openca-Users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openca-users
