Bug#641913: gforge-db-postgresql: Cannot create PostgreSQL database: problem with system local (de_DE@euro)
tag 641913 + wontfix retitle 641913 gforge-db-postgresql requires an Unicode locale (or C) thanks Andreas Karnetzki, 2011-09-17 15:04:27 +0200 : When trying to create the postgresSQL database for the package the post install script reports this failure: [...] CREATE DATABASE's STDOUT: SET CREATE DATABASE's STDERR: ERROR: encoding UTF8 does not match locale de_DE@euro DETAIL: The chosen LC_CTYPE setting requires encoding LATIN9. Yes, that's because FusionForge is a multi-lingual application, and therefore needs an Unicode database (with UTF-8 encoding). This can only be created if the system locale is either C, POSIX, or an UTF-8 locale. When the system locale that has a different encoding (such as Latin-9 in your case), new databases can only be created with that same encoding (see [1] for details). I don't think there's any sane way around that in the FusionForge packaging; your best bet would be to either upgrade your system locale (and database templates) to Unicode-aware, or to create a new dedicated PostgreSQL cluster on a different port, with a Unicode locale. [1] http://www.postgresql.org/docs/current/static/sql-createdatabase.html Roland. -- Roland Mas When you have a hammer in your hand, most things look like a nail. -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#641913: gforge-db-postgresql: Cannot create PostgreSQL database: problem with system local (de_DE@euro)
On Fri, 2 Dec 2011, Roland Mas wrote: [ A PostgreSQL database with UTF-8 encoding can ] only be created if the system locale is either C, POSIX, or an UTF-8 locale. When the system locale that has a different encoding (such as Eh, why? Latin-9 in your case), new databases can only be created with that same encoding (see [1] for details). Can’t we “just” force C then? (For lc_messages anyway, and maybe for lc_collate too… oh but for lc_ctype we definitively need a UTF-8 locale or C.UTF-8 which is wheezy-specific though.) Hrm. So PostgreSQL seems to only support Unicode when the OS below does? (Consider a Recommends, or even Depends, on locales-all?) bye, //mirabilos -- tarent solutions GmbH Rochusstraße 2-4, D-53123 Bonn • http://www.tarent.de/ Tel: +49 228 54881-393 • Fax: +49 228 54881-314 HRB AG Bonn 5168 • USt-ID (VAT): DE122264941 Geschäftsführer: Boris Esser, Elmar Geese -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#641913: gforge-db-postgresql: Cannot create PostgreSQL database: problem with system local (de_DE@euro)
Thorsten Glaser, 2011-12-02 11:37:48 +0100 : On Fri, 2 Dec 2011, Roland Mas wrote: [ A PostgreSQL database with UTF-8 encoding can ] only be created if the system locale is either C, POSIX, or an UTF-8 locale. When the system locale that has a different encoding (such as Eh, why? I don't know. Ask PostgreSQL guys, I'm just a lowly user :-) Latin-9 in your case), new databases can only be created with that same encoding (see [1] for details). Can’t we “just” force C then? (For lc_messages anyway, and maybe for lc_collate too… oh but for lc_ctype we definitively need a UTF-8 locale or C.UTF-8 which is wheezy-specific though.) My understanding is that the locale that is considered is the one that the PostgreSQL daemon runs under; that means the whole cluster, and I'm not comfortable changing settings that affect unrelated databases. Hrm. So PostgreSQL seems to only support Unicode when the OS below does? (Consider a Recommends, or even Depends, on locales-all?) Not sure on the details, but that would seem logical. I'm not sure the dependencies are warranted, though, since it can run even on a locale-less system, and people who need a language-aware database will probably have the appropriate locale already. Roland. -- Roland Mas La menace de la baffe pèse plus lourd que la baffe elle-même. -- in Sri Raoul le petit yogi (Gaudelette) -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#641913: gforge-db-postgresql: Cannot create PostgreSQL database: problem with system local (de_DE@euro)
On Fri, 2 Dec 2011, Roland Mas wrote: My understanding is that the locale that is considered is the one that the PostgreSQL daemon runs under; that means the whole cluster, and I'm Ouch, okay. We can’t affect that from FF. bye, //mirabilos -- tarent solutions GmbH Rochusstraße 2-4, D-53123 Bonn • http://www.tarent.de/ Tel: +49 228 54881-393 • Fax: +49 228 54881-314 HRB AG Bonn 5168 • USt-ID (VAT): DE122264941 Geschäftsführer: Boris Esser, Elmar Geese -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#641913: gforge-db-postgresql: Cannot create PostgreSQL database: problem with system local (de_DE@euro)
Package: gforge-db-postgresql Version: 5.1-6 Severity: important Tags: l10n When trying to create the postgresSQL database for the package the post install script reports this failure: Replacing config file /etc/postgresql/9.1/main/pg_hba.conf with new version Reloading PostgreSQL 9.1 database server: main. Cannot create PostgreSQL database... This shouldn't have happened. Maybe a problem in your PostgreSQL configuration? Please report a bug to the Debian bug tracking system Please include the following output: CREATE DATABASE's STDOUT: SET CREATE DATABASE's STDERR: ERROR: encoding UTF8 does not match locale de_DE@euro DETAIL: The chosen LC_CTYPE setting requires encoding LATIN9. -- System Information: Debian Release: wheezy/sid APT prefers testing APT policy: (500, 'testing') Architecture: amd64 (x86_64) Kernel: Linux 3.0.0-1-amd64 (SMP w/2 CPU cores) Locale: LANG=de_DE@euro, LC_CTYPE=de_DE@euro (charmap=ISO-8859-15) Shell: /bin/sh linked to /bin/dash Versions of packages gforge-db-postgresql depends on: ii debconf [debconf-2.0] 1.5.40 ii debianutils 4.0.2 ii gforge-common 5.1-6 ii libdbd-pg-perl 2.18.1-1 ii libdbi-perl 1.616-1+b1 ii libhtml-parser-perl 3.68-1+b1 ii libmail-sendmail-perl 0.79.16-1 ii libsort-versions-perl 1.5-4 ii libtext-autoformat-perl 1.669002-1 ii perl [libmime-base64-perl] 5.12.4-4 ii php5-cli5.3.8-1 ii php5-pgsql 5.3.8-1 ii postgresql 9.1+121 ii ucf 3.0025+nmu2 gforge-db-postgresql recommends no packages. gforge-db-postgresql suggests no packages. -- debconf information: fusionforge/shared/db_user: fusionforge fusionforge/shared/system_name: FusionForge * fusionforge/ucfchangeprompt: install_new fusionforge/shared/statsadmin_groupid: 3 fusionforge/shared/db_name: fusionforge fusionforge/shared/server_admin: webmaster@pirlipat.private fusionforge/shared/peerrating_groupid: 4 fusionforge/shared/domain_name: pirlipat.private fusionforge/shared/sys_lang: English fusionforge/shared/users_host: users.pirlipat.private fusionforge/shared/db_host: 127.0.0.1 fusionforge/shared/shell_host: shell.pirlipat.private fusionforge/shared/ip_address: 127.0.1.1 fusionforge/shared/download_host: download.pirlipat.private fusionforge/shared/newsadmin_groupid: 2 fusionforge/shared/sys_theme: gforge fusionforge/shared/lists_host: lists.pirlipat.private -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org