Hi Max,
Thanks for the response. Yes, MySQL was running. The error message was a
valid "Access Denied" response from the database server, because the
password wasn't being sent in the response.
I had to edit the DBI.pm and hard-code the password in order to get the
openca_start to run and the database to initialize.
Here is a diff of my working version of DBI.pm from that contained in a
pristine source (version 1.1.1). At line 783 I set the password to that
I'd given to the database and hey presto, it logged in, created the
database structure and started working.
> user@host:~/src/pristine/openca-base-1.1.1/src/modules/openca-dbi$
> diff DBI.pm /usr/local/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm
> 724,725c724,725
> < DEBUG => 0,
> < DEBUG_STDERR => 0,
> ---
> > DEBUG => 1,
> > DEBUG_STDERR => 1,
> 782c782,783
> < $self->{DB_Passwd} = $keys->{DB_Passwd};
> ---
> > ## $self->{DB_Passwd} = $keys->{DB_Passwd};
> > $self->{DB_Passwd} = 'mypassword';
> 3214c3215
> < $datatype =~ s/_.*//g;
> ---
> > $datatype =~ s/_.*/0/g;
Strangely, I didn't make that change at line 3214/3215 but I did make
the other two.
Anyway, I've got past this problem now.
My current problem is that openca-configure isn't updating any of the
files when I run it.
It looks like other people have had a similar problem (e.g.
http://sourceforge.net/mailarchive/message.php?msg_id=13820977) but I
haven't been able to find out exactly why it's happening yet.
The config.xml seems syntactically correct; I've upgraded my version of
Perl, so I'm trying to think of other things to try before wiping it and
starting again.
Thanks again,
Ben
On 08/07/11 18:54, Massimiliano Pala wrote:
> Hi,
>
> you might want to check that mysql is responding on localhost port 3306
> by doing:
>
> $ telnet localhost 3306
>
> if it works, great. If it does not, you need to check the mysql config.
> If, instead you need to change the default configuration in openca,
> remember to change the .template files, not the .xml files as they
> get over-written when openca starts!
>
> Let me know if you managed to fix the issue.
>
> Cheers,
> Max
>
>
> On 07/08/2011 10:23 AM, Ben Tullis wrote:
>> Hi,
>>
>> I'm trying to create a new instance of an OpenCA version 1.1.1. I've
>> installed it from source on Debian 5.0.8
>>
>> My problem occurs when trying to start the openca service and initialize
>> the MySQl database.
>>
------------------------------------------------------------------------------
AppSumo Presents a FREE Video for the SourceForge Community by Eric
Ries, the creator of the Lean Startup Methodology on "Lean Startup
Secrets Revealed." This video shows you how to validate your ideas,
optimize your ideas and identify your business strategy.
http://p.sf.net/sfu/appsumosfdev2dev
_______________________________________________
Openca-Users mailing list
Openca-Users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openca-users
