Hi Mary, I have checked the locale variable of my system, it's LANG=en_US.UTF-8. So I think this value is correct for Postgresql. I have the same on my CentOS where Fossology is working well (even if the release of Postgresql is only the 8.1 on my CentOS if I don't do mistakes).
Then I am a little busy these next days, I use now CentOS for Fossology, I'm so sorry to don't have enough time to help you to fix this problem on Ubuntu 8.04 now. Best regards, Jonathan 2009/8/14 Laser, Mary <[email protected]> > Hi Jonathan, > I've done some research on your inability to create the fossology database > with SQL_ASCII encoding. According to the PostgreSQL documentation, > SQL_ASCII encoding is supported when the database character set is > compatible with the server's locale setting.( > http://www.postgresql.org/docs/8.3/interactive/multibyte.html) > > From the PostgreSQL documentation page on Locale Support ( > http://www.postgresql.org/docs/8.3/interactive/locale.html): > > > Locale support is automatically initialized when a database cluster is > created using initdb. initdb will initialize the database cluster with the > locale setting of its execution environment by default, so if your system is > already set to use the locale that you want in your database cluster then > there is nothing else you need to do. If you want to use a different locale > (or you are not sure which locale your system is set to), you can instruct > initdb exactly which locale to use by specifying the --locale option. > > What locale is your system set to? (Try examining the LANG or LC_ALL > environment variables). > > Also, you might want to try recreating your database cluster using the > --locale option. After you have done that, see if you can create a test > database with SQL_ASCII encoding. > > Good Luck! I hope this helps. > Mary > > > ------------------------------ > *From:* Jonathan Parès [mailto:[email protected]] > *Sent:* Monday, August 10, 2009 8:48 PM > *To:* Laser, Mary > *Cc:* [email protected] > *Subject:* Re: [FOSSology] Fossology installation troubles : ERROR: Unable > to initialize. > > Dear Mary, > > I have read this in the Postegresql wiki page of the French Ubuntu > community about the release 8.3 : > > "Il est important de remarquer que lors de l'installation, les bases de > données sont créées en unicode et qu'à cause de cela, il ne sera pas > possible de créer une base de données dans un autre encodage." > > that means in English : > > "It's important to notice that during the installation, the database > schemes are created with the unicode encoding and due to this, it will not > possible to create an other scheme with an other encoding." > > Best regards, > > Jonathan > > -- ---------------------------------------------------- Jonathan Parès, Software engineer, Qualipso project, O-Engine/GMRC, Open Source Competence Center (China), Guangzhou China.
_______________________________________________ fossology mailing list [email protected] http://fossology.org/mailman/listinfo/fossology
