[Webmin-maintainers] Bug#351936: Says: You do not have access to any databases.

[Stephan Struckmann]

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: LANG=de_DE at euro, LC_CTYPE=de_DE at euro (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"
LANG=de_DE at euro

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.