Continuation of "Problems about multi-bytes language contents"
|
View:
New views
6 Messages
—
Rating Filter:
Alert me
|
 |
Continuation of "Problems about multi-bytes language contents"
by f u
::
Rate this Message:
Hi, people. I have installed Openca 1.0.2 and have one essential problem with it.
I need to have certificates with russian characters in CN (=Вася Пупкин for ex.). The problem was introduced in "Problems about multi-bytes language contents" subject mail. There was a workaround, but it doesn't works for me. Workaround: Re: Problems about multi-bytes language contents Click to flag this post by wking Dec 04, 2008; 12:07pm :: Rate this Message: - Use ratings to moderate (?) Reply | Reply to Author | Print | View Threaded | Show Only this Message Hi, all, After a week's day and night debug, I find out the cause at last. It's caused by a mis-decoding of parameters which is going to persistent into database from utf-8. I modified the OpenCA/DBI.pm of perl module. from Line 3085: # my @obind_values = @{$keys->{BIND_VALUES}} if ($keys->{BIND_VALUES}); my @bind_values; foreach my $help ( @{$keys->{BIND_VALUES}}){ # if the bind value is still in utf-8 , I decode it here. :) if(Encode::is_utf8($help)){ $help=Encode::decode_utf8($help); } $bind_values[ scalar( @bind_values)]=$help; } $self->debug ("doQuery: query: $query"); END of workaround. The problem is strange. I've set debug flag in DBI.pm, So in logs i can see normal Russian characters, but in the database it looks like it's not utf-8: "РуÑÑкий ЯÐ?ык" Database postgresql 8.3 full unicode. OS: FreeBSD 7.2 Please say me: where to dig?! Thank You! ------------------------------------------------------------------------------ Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects _______________________________________________ Openca-Users mailing list Openca-Users@... https://lists.sourceforge.net/lists/listinfo/openca-users |
|
|
Re: Continuation of "Problems about multi-bytes language contents"
by Sergei Vyshenski-3
::
Rate this Message:
Dear Fu,
Version OpenCA-0.9.2 is still as perfect as it could be about utf-8 stuff you need, and you can always downgrade to it unless you know why you should not. Also a couple of old HowTo's about uft-8 in OpenCA and in popular databases could be of help: http://www.openxpki.org/legacy/docs.html All the best, Sergei f u wrote: > Hi, people. I have installed Openca 1.0.2 and have one essential problem with it. > I need to have certificates with russian characters in CN (=Вася Пупкин for ex.). > The problem was introduced in "Problems about multi-bytes language contents" subject mail. > There was a workaround, but it doesn't works for me. > > Workaround: > Re: Problems about multi-bytes language contents > Click to flag this post > > by wking Dec 04, 2008; 12:07pm :: Rate this Message: - Use ratings to moderate (?) > > Reply | Reply to Author | Print | View Threaded | Show Only this Message > Hi, all, > > After a week's day and night debug, I find out the cause at last. It's caused by a mis-decoding of parameters which is going to persistent into database from utf-8. > > I modified the OpenCA/DBI.pm of perl module. > > from Line 3085: > > # my @obind_values = @{$keys->{BIND_VALUES}} if ($keys->{BIND_VALUES}); > my @bind_values; > > foreach my $help ( @{$keys->{BIND_VALUES}}){ > # if the bind value is still in utf-8 , I decode it here. :) > if(Encode::is_utf8($help)){ > $help=Encode::decode_utf8($help); > } > $bind_values[ scalar( @bind_values)]=$help; > } > > > $self->debug ("doQuery: query: $query"); > > END of workaround. > > The problem is strange. I've set debug flag in DBI.pm, > So in logs i can see normal Russian characters, but in the database it looks like it's not utf-8: "РуÑÑкий ЯÐ?ык" > > Database postgresql 8.3 full unicode. > OS: FreeBSD 7.2 > > Please say me: where to dig?! > Thank You! > > ------------------------------------------------------------------------------ > Crystal Reports - New Free Runtime and 30 Day Trial > Check out the new simplified licensing option that enables unlimited > royalty-free distribution of the report engine for externally facing > server and web deployment. > http://p.sf.net/sfu/businessobjects > _______________________________________________ > Openca-Users mailing list > Openca-Users@... > https://lists.sourceforge.net/lists/listinfo/openca-users > ------------------------------------------------------------------------------ Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects _______________________________________________ Openca-Users mailing list Openca-Users@... https://lists.sourceforge.net/lists/listinfo/openca-users |
|
|
Continuation of "Problems about multi-bytes languagecontents"
by f u
::
Rate this Message:
> Dear Fu,
> > Version OpenCA-0.9.2 is still as perfect as it could be about utf-8 > stuff you need, and you can always downgrade to it unless you know why > you should not. But I want 1.0.2 for now! All I need is correct data insertion into Pg db. I don't think it will be very hard to find this bug. > Also a couple of old HowTo's about uft-8 in OpenCA and in popular > databases could be of help: Thank You. I'm running 3 copies (pub-ra-CA) of 0.9.3 in pilot mode. It's not so good as it could... I need something better. > http://www.openxpki.org/legacy/docs.html Is it alive? ( I mean 'openxpki' FreeBSD port was market as broken long time ago...) > All the best, Sergei Thanks in advance. > f u wrote: > > Hi, people. I have installed Openca 1.0.2 and have one essential problem with it. > > I need to have certificates with russian characters in CN (=Вася Пупкин for ex.). > > The problem was introduced in "Problems about multi-bytes language contents" subject mail. > > There was a workaround, but it doesn't works for me. > > > > Workaround: > > Re: Problems about multi-bytes language contents > > Click to flag this post > > > > by wking Dec 04, 2008; 12:07pm :: Rate this Message: - Use ratings to moderate (?) > > > > Reply | Reply to Author | Print | View Threaded | Show Only this Message > > Hi, all, > > > > After a week's day and night debug, I find out the cause at last. It's caused by a mis-decoding of parameters which is going to persistent into database from utf-8. > > > > I modified the OpenCA/DBI.pm of perl module. > > > > from Line 3085: > > > > # my @obind_values = @{$keys->{BIND_VALUES}} if ($keys->{BIND_VALUES}); > > my @bind_values; > > > > foreach my $help ( @{$keys->{BIND_VALUES}}){ > > # if the bind value is still in utf-8 , I decode it here. :) > > if(Encode::is_utf8($help)){ > > $help=Encode::decode_utf8($help); > > } > > $bind_values[ scalar( @bind_values)]=$help; > > } > > > > > > $self->debug ("doQuery: query: $query"); > > > > END of workaround. > > > > The problem is strange. I've set debug flag in DBI.pm, > > So in logs i can see normal Russian characters, but in the database it looks like it's not utf-8: "РуÑÑкий ЯÐ?ык" > > > > Database postgresql 8.3 full unicode. > > OS: FreeBSD 7.2 > > > > Please say me: where to dig?! > > Thank You! ------------------------------------------------------------------------------ Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects _______________________________________________ Openca-Users mailing list Openca-Users@... https://lists.sourceforge.net/lists/listinfo/openca-users |
|
|
Re: Continuation of "Problems about multi-bytes languagecontents"
by Sergei Vyshenski-3
::
Rate this Message:
f u wrote:
>> Version OpenCA-0.9.2 is still as perfect as it could be about utf-8 >> stuff you need, and you can always downgrade to it unless you know why >> you should not. >> > But I want 1.0.2 for now! > All I need is correct data insertion into Pg db. > I don't think it will be very hard to find this bug > Good that you know what you want. Simple fact. Once a developer, which was highly concerned about utf-8 support in OpenCA, has touched the code of the OpenCA. Last time this happened _before_ release 0.9.2. So you may have to search hard for those who will look for bugs upon your wise directions. >> Also a couple of old HowTo's about uft-8 in OpenCA and in popular >> databases could be of help: >> http://www7.openxpki.org/legacy/docs.html >> > Is it alive? ( I mean 'openxpki' FreeBSD port was market as broken long time ago...) > 1. Bold shit. OpenXPKI ports distributed with FreeBSD: http://www.freebsd.org/cgi/ports.cgi?query=openxpki&stype=name Nightly builds of the OpenXPKI FreeBSD ports: http://www7.openxpki.org/lastmidnight/index.html 2 Learn to read. Reference given by me was about old _OpenCA_ documentation and not about OpenXPKI project. ------------------------------------------------------------------------------ Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects _______________________________________________ Openca-Users mailing list Openca-Users@... https://lists.sourceforge.net/lists/listinfo/openca-users |
|
|
|
|
|
|
| Free embeddable forum powered by Nabble | Forum Help |
