Package: webmin-postgresql
Version: 1.200-1
Severity: important
Tags: patch l10n



-- System Information:
Debian Release: testing/unstable
  APT prefers testing
  APT policy: (500, 'testing'), (500, 'stable')
Architecture: i386 (i686)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.12-1-k7
Locale: [EMAIL PROTECTED], [EMAIL PROTECTED] (charmap=ISO-8859-15)

Versions of packages webmin-postgresql depends on:
ii  perl                          5.8.7-10   Larry Wall's Practical Extraction 
ii  postgresql                    7.5.15     object-relational SQL database man
ii  webmin                        1.230-1    web-based administration toolkit

webmin-postgresql recommends no packages.

-- no debconf information
The file postgresql-lib.pl does some tricky IPC with psql before it contacts db 
over DBI (always, even if nodbi=0).
This code waits for some messages in english (password, user name). At least in 
my /etc/environment the following variables
are set:

LANGUAGE="de_DE:de:en_GB:en"
[EMAIL PROTECTED]

The latter one must also be set somewhere else (I didn't find out where). This 
results in German messages from psql (it's 
called with su to sneak ident-authification). This results in the message named 
in Subject.

/etc/passwd:
[...]
postgres:x:106:106:PostgreSQL administrator,,,:/var/lib/postgresql:/bin/bash
[...]

An example for the l10n-dependent code:
postgresql-lib.pl:
[...]
                } while($line =~ /^(username|password|user name):/i ||
[...]                   

I tried some workarounds with:
                        /var/lib/postgresql/.bashrc
                        unset LANGUAGE
                        unset LANG
                        export LANGUAGE LANG
Those don't work (LANG is besetting).

Finally I found the following workaround:

* Create a file safepsql.sh somewhere (root / resp. webmin-user execution 
rights)
safesql.sh ----- begin -----
#!/bin/bash
unset LANG
unset LANGUAGE
/usr/bin/psql "$@"
safesql.sh ------ end ------
* In the module-settings from webmin-postgresql set that program (with path) 
for Path to psql command.

Afterwards it should work. I'll post that bug to Debian and Webmin also, so You 
can discuss how to solve the problem. Maybe
Webmin should do I think.


-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

Reply via email to