[Spacewalk-list] UTF8 Character encoding (Oracle)

[Ward, Ashley]

Hi Eric,

        I don't have an answer for the implications of making the change, but I was the similar situation where our DBAs refused to change the character set... so I was forced to:

edit /usr/lib/perl5/vendor_perl/5.8.8/Spacewalk/Setup.pm

change

     my @ALLOWED_CHARSETS = qw/UTF8 AL32UTF8/;

to

     my @ALLOWED_CHARSETS = qw/WE8ISO8859P15/;
     # my @ALLOWED_CHARSETS = qw/UTF8 AL32UTF8/;

        (obviously yours would read something like @ALLOWED_CHARSETS = qw/WE8MSWIN1252/; )

        Hope this helps.

Cheers,

Ashley

-----Original Message-----
From: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Eric
Sent: 05 March 2010 14:27
To: spacewalk-list at redhat.com
Subject: [Spacewalk-list] UTF8 Character encoding (Oracle)

Hello,

I was able to install all the packages needed via YUM to install and setup Spacewalk 0.8.
However, I just found out that our Database is not UTF-8 encoded, but WE8MSWIN1252.

What are the implications of bypassing that check in the spacewalk-setup? It is my understanding
that some characters may get garbled, but I expect most of them to be 7bit ascii characters.

Also there should be some note that the db_password cannot contain a '#' or they will be truncated.
It took me awhile to figure out that the database password was getting truncated in
/usr/share/rhn/common/rhnConfig.py (spacewalk 0.8) around Line 483.

# Strip out any comments.
i = string.find(line, '#')
if i == 0:
    return (None, None)
line = string.strip(line)
if not line:
    return (None, None)

I would fix the code but I am a complete novice when it comes to writing Python code.

Thanks in advance,

-Eric





_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

-----------------------------------------
Information in this email including any attachments may be
privileged, confidential and is intended exclusively for the
addressee. The views expressed may not be official policy, but the
personal views of the originator. If you have received it in error,
please notify the sender by return e-mail and delete it from your
system. You should not reproduce, distribute, store, retransmit,
use or disclose its contents to anyone.

Please note we reserve the right to monitor all e-mail
communication through our internal and external networks.

SKY and the SKY marks are trade marks of British Sky Broadcasting
Group plc and are used under licence. British Sky Broadcasting
Limited (Registration No. 2906991), Sky Interactive Limited
(Registration No. 3554332), Sky-In-Home Service Limited
(Registration No. 2067075) and Sky Subscribers Services Limited
(Registration No. 2340150) are direct or indirect subsidiaries of
British Sky Broadcasting Group plc (Registration No. 2247735). All
of the companies mentioned in this paragraph are incorporated in
England and Wales and share the same registered office at Grant
Way, Isleworth, Middlesex TW7 5QD.