Michael,
I think that there is now a dependancy on Perl 5.8.* for OpenCA 0.9.2.
I was having errors of this nature until I upgraded my perl.
It is nice that one core developer knows this but I don't know it ;-D
Do you have any errors or ideas what did we do to create this dependancy? It was not my intention to create such a Perl dependancy. It is a mistake which happens because I use a Perl 5.8 on my SuSE box. I'm really sorry about this :(
I brought this to the attention of the devel list on 6/12/2004 with the following set of posts entitled:
"Problem Staring OpenCA with MySQL"
Here are the posts I sent and the replies I received.
Chris...
----------------------------
Guys,
I have got round my pproblems by upgradinng my perl version to the latest (5.8.6 along with recompiling DBI and DBD-MySQL)
This is probably a bit of an issue, as it seems to me that we now have a dependancy on the perl version, i.e. must be greater than 5.6.1. Have other people managed to install using earlier versions of perl ?
Chris...
Chris Covell wrote:
> Guys,
>
> sorry for cross posting this to Devel too, but I have had to do some code changes....
>
> In order to get the OpenCA server started on this RedHat Enterprise 2.1 server with Perl 5.6.1 I have had to edit "OpenCA/DBI.pm". I have replaced the line:
>
> use POSIX qw(setlocale LC_MESSAGES);
>
> with the lines:
>
> use Locale::Messages qw(LC_MESSAGES)
> use POSIX ('setlocale');
> setlocale (LC_MESSAGES, '');
>
> I have got this code from "http://www.cpan.org/modules/by-module/Crypt/GUIDO/libintl-perl-1.00.readme"; as the locale catagory LC_MESSAGES is not exported bu the POSIX module on older Perl versions.
>
> Now, this seems to have fixed my problem, as the openca server now starts with openca_start with no error messages.
>
> The only trouble is I now get the error:
>
> "DBD::mysql::st execute failed: You have an error in your SQL syntax near 'NAMES'utf-8'' at line 1 at ../OpenCA/DBI.pm line 2587."
>
> Am I fighting a loosing battle here because of the Perl version I am using ? Or is this an error people have seen before ?
>
> Chris...
>
> Chris Covell wrote:
>
>> OK, so I have piinned in down a bit.
>>
>> When you use a DBI the fnction initDBI is called, this in turn calls OpenCA/DBI.pm which has the line:
>>
>>
>> use POSIX qw(setlocale LC_MESSAGES);
>>
>> which in turn calls POSIX.pm and it is the import subroutine in side here that fails.
>>
>> So is some sort of environment variablle not getting set somewhere ?
>>
>> Chris...
>>
>> Chris Covell wrote:
>>
>>> Alfonso,
>>>
>>> Alfonso Sparano wrote:
>>>
>>>> Do you have installed DBD::mysql perl module?
>>>>
>>>> Try: perl -MCPAN -e'install DBD::mysql'
>>>
>>>
>>>
>>>
>>>
>>> yes, I am in a Red hat environment so I installed the module via rpm.
>>>
>>> # rpm -q perl-DBD-MySQL
>>> # perl-DBD-MySQL-1.2216-4
>>>
>>> I also have the perl-DBI module installed.
>>>
>>> It is strange, as I am sure the POSIX.pm is to do with text translation, so i don't understand why it gives the error with the mysql...
------------------------------------------------------- This SF.Net email is sponsored by: NEC IT Guy Games. Get your fingers limbered up and give it your best shot. 4 great events, 4 opportunities to win big! Highest score wins.NEC IT Guy Games. Play to win an NEC 61 plasma display. Visit http://www.necitguy.com/?r=20 _______________________________________________ Openca-Users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openca-users
