← Back to team overview

desktop-packages team mailing list archive

[Bug 1382774] Re: Postgresql installation for MAAS fails on locales missing language packs

 

Seems like the workaround described in #7 is not working, and it's
nothing to do with dbconfig-common:

ubuntu@darby:~$ locale
locale: Cannot set LC_ALL to default locale: No such file or directory
LANG=en_US.UTF-8
LANGUAGE=
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC=en_GB.UTF-8
LC_TIME=en_GB.UTF-8
LC_COLLATE="en_US.UTF-8"
LC_MONETARY=en_GB.UTF-8
LC_MESSAGES="en_US.UTF-8"
LC_PAPER=en_GB.UTF-8
LC_NAME=en_GB.UTF-8
LC_ADDRESS=en_GB.UTF-8
LC_TELEPHONE=en_GB.UTF-8
LC_MEASUREMENT=en_GB.UTF-8
LC_IDENTIFICATION=en_GB.UTF-8
LC_ALL=
ubuntu@darby:~$ cat /etc/environment 
PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games"
ubuntu@darby:~$ locale -a
C
C.UTF-8
en_US.utf8
POSIX
ubuntu@darby:~$ sudo apt-get install postgresql-9.3
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following extra packages will be installed:
  libpq5 postgresql-client-9.3 postgresql-client-common postgresql-common
  ssl-cert
Suggested packages:
  oidentd ident-server locales-all postgresql-doc-9.3 openssl-blacklist
The following NEW packages will be installed:
  libpq5 postgresql-9.3 postgresql-client-9.3 postgresql-client-common
  postgresql-common ssl-cert
0 upgraded, 6 newly installed, 0 to remove and 0 not upgraded.
Need to get 3677 kB of archives.
After this operation, 15.4 MB of additional disk space will be used.
Do you want to continue? [Y/n] 
Get:1 http://us.archive.ubuntu.com//ubuntu/ trusty-updates/main libpq5 amd64 9.3.5-0ubuntu0.14.04.1 [80.6 kB]
Get:2 http://us.archive.ubuntu.com//ubuntu/ trusty/main postgresql-client-common all 154 [25.4 kB]
Get:3 http://us.archive.ubuntu.com//ubuntu/ trusty-updates/main postgresql-client-9.3 amd64 9.3.5-0ubuntu0.14.04.1 [782 kB]
Get:4 http://us.archive.ubuntu.com//ubuntu/ trusty/main ssl-cert all 1.0.33 [16.6 kB]
Get:5 http://us.archive.ubuntu.com//ubuntu/ trusty/main postgresql-common all 154 [103 kB]
Get:6 http://us.archive.ubuntu.com//ubuntu/ trusty-updates/main postgresql-9.3 amd64 9.3.5-0ubuntu0.14.04.1 [2670 kB]
Fetched 3677 kB in 0s (22.6 MB/s)       
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
        LANGUAGE = (unset),
        LC_ALL = (unset),
        LC_TIME = "en_GB.UTF-8",
        LC_MONETARY = "en_GB.UTF-8",
        LC_ADDRESS = "en_GB.UTF-8",
        LC_TELEPHONE = "en_GB.UTF-8",
        LC_NAME = "en_GB.UTF-8",
        LC_MEASUREMENT = "en_GB.UTF-8",
        LC_IDENTIFICATION = "en_GB.UTF-8",
        LC_NUMERIC = "en_GB.UTF-8",
        LC_PAPER = "en_GB.UTF-8",
        LANG = "en_US.UTF-8"
    are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
locale: Cannot set LC_ALL to default locale: No such file or directory
Preconfiguring packages ...
Selecting previously unselected package libpq5.
(Reading database ... 56021 files and directories currently installed.)
Preparing to unpack .../libpq5_9.3.5-0ubuntu0.14.04.1_amd64.deb ...
Unpacking libpq5 (9.3.5-0ubuntu0.14.04.1) ...
Selecting previously unselected package postgresql-client-common.
Preparing to unpack .../postgresql-client-common_154_all.deb ...
Unpacking postgresql-client-common (154) ...
Selecting previously unselected package postgresql-client-9.3.
Preparing to unpack .../postgresql-client-9.3_9.3.5-0ubuntu0.14.04.1_amd64.deb ...
Unpacking postgresql-client-9.3 (9.3.5-0ubuntu0.14.04.1) ...
Selecting previously unselected package ssl-cert.
Preparing to unpack .../ssl-cert_1.0.33_all.deb ...
Unpacking ssl-cert (1.0.33) ...
Selecting previously unselected package postgresql-common.
Preparing to unpack .../postgresql-common_154_all.deb ...
Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common'
Unpacking postgresql-common (154) ...
Selecting previously unselected package postgresql-9.3.
Preparing to unpack .../postgresql-9.3_9.3.5-0ubuntu0.14.04.1_amd64.deb ...
Unpacking postgresql-9.3 (9.3.5-0ubuntu0.14.04.1) ...
Processing triggers for man-db (2.6.7.1-1ubuntu1) ...
Processing triggers for ureadahead (0.100.0-16) ...
Setting up libpq5 (9.3.5-0ubuntu0.14.04.1) ...
Setting up postgresql-client-common (154) ...
Setting up postgresql-client-9.3 (9.3.5-0ubuntu0.14.04.1) ...
update-alternatives: using /usr/share/postgresql/9.3/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode
Setting up ssl-cert (1.0.33) ...
locale: Cannot set LC_ALL to default locale: No such file or directory
Setting up postgresql-common (154) ...
locale: Cannot set LC_ALL to default locale: No such file or directory
Adding user postgres to group ssl-cert

Creating config file /etc/logrotate.d/postgresql-common with new version
Building PostgreSQL dictionaries from installed myspell/hunspell packages...
Removing obsolete dictionary files:
 * No PostgreSQL clusters exist; see "man pg_createcluster"
Processing triggers for ureadahead (0.100.0-16) ...
Setting up postgresql-9.3 (9.3.5-0ubuntu0.14.04.1) ...
Error: The locale requested by the environment is invalid.
Error: could not create default cluster. Please create it manually with

  pg_createcluster 9.3 main --start

or a similar command (see 'man pg_createcluster').
update-alternatives: using /usr/share/postgresql/9.3/man/man1/postmaster.1.gz to provide /usr/share/man/man1/postmaster.1.gz (postmaster.1.gz) in auto mode
 * No PostgreSQL clusters exist; see "man pg_createcluster"
Processing triggers for libc-bin (2.19-0ubuntu6.3) ...


** Changed in: postgresql-common (Ubuntu)
       Status: Invalid => Confirmed

** Changed in: dbconfig-common (Ubuntu)
       Status: New => Invalid

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to postgresql-common in Ubuntu.
https://bugs.launchpad.net/bugs/1382774

Title:
  Postgresql installation for MAAS fails on locales missing language
  packs

Status in MAAS:
  Confirmed
Status in “dbconfig-common” package in Ubuntu:
  Invalid
Status in “maas” package in Ubuntu:
  Confirmed
Status in “postgresql-common” package in Ubuntu:
  Confirmed

Bug description:
  Ubuntu 14.04 with all updates as of time of the writing.

  MAAS - 1.5.4+bzr2294-0ubuntu1.1

  # apt-get install maas
  ...
  Setting up maas-dns (1.5.4+bzr2294-0ubuntu1.1) ...
   * Stopping domain name service... bind9                                                                                                                                                                             waiting for pid 29580 to die
                                                                                                                                                                                                                [ OK ]
   * Starting domain name service... bind9                                                                                                                                                                      [ OK ] 
  Setting up maas-region-controller (1.5.4+bzr2294-0ubuntu1.1) ...
  locale: Cannot set LC_ALL to default locale: No such file or directory
  Considering dependency proxy for proxy_http:
  Module proxy already enabled
  Module proxy_http already enabled
  Module expires already enabled
  Module wsgi already enabled
  rsyslog stop/waiting
  rsyslog start/running, process 32763
  squid-deb-proxy stop/waiting
  squid-deb-proxy start/running, process 349
   * Restarting message broker rabbitmq-server                                                                                                                                                                  [ OK ] 
  Creating user "maas_longpoll" ...
  ...done.
  Creating vhost "/maas_longpoll" ...
  ...done.
  Setting permissions for user "maas_longpoll" in vhost "/maas_longpoll" ...
  ...done.
  Creating user "maas_workers" ...
  ...done.
  Creating vhost "/maas_workers" ...
  ...done.
  Setting permissions for user "maas_workers" in vhost "/maas_workers" ...
  ...done.
   * No PostgreSQL clusters exist; see "man pg_createcluster"
  dbconfig-common: writing config to /etc/dbconfig-common/maas-region-controller.conf

  Creating config file /etc/dbconfig-common/maas-region-controller.conf with new version
  unable to connect to postgresql server.
  error encountered creating user:
  psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
  /usr/bin/locale: Cannot set LC_ALL to default locale: No such file or directory

  Here's the environment:
  # export
  declare -x HOME="/root"
  declare -x LANG="en_US.UTF-8"
  declare -x LANGUAGE="en_US:en"
  declare -x LC_ADDRESS="hr_HR.UTF-8"
  declare -x LC_IDENTIFICATION="hr_HR.UTF-8"
  declare -x LC_MEASUREMENT="hr_HR.UTF-8"
  declare -x LC_MONETARY="hr_HR.UTF-8"
  declare -x LC_NAME="hr_HR.UTF-8"
  declare -x LC_NUMERIC="hr_HR.UTF-8"
  declare -x LC_PAPER="hr_HR.UTF-8"
  declare -x LC_TELEPHONE="hr_HR.UTF-8"
  declare -x LC_TIME="hr_HR.UTF-8"
  declare -x LESSCLOSE="/usr/bin/lesspipe %s %s"
  declare -x LESSOPEN="| /usr/bin/lesspipe %s"
  declare -x LOGNAME="root"
  declare -x LS_COLORS="rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.lz=01;31:*.xz=01;31:*.bz2=01;31:*.bz=01;31:*.tbz=01;31:*.tbz2=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.war=01;31:*.ear=01;31:*.sar=01;31:*.rar=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.webm=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=00;36:*.au=00;36:*.flac=00;36:*.mid=00;36:*.midi=00;36:*.mka=00;36:*.mp3=00;36:*.mpc=00;36:*.ogg=00;36:*.ra=00;36:*.wav=00;36:*.axa=00;36:*.oga=00;36:*.spx=00;36:*.xspf=00;36:"
  declare -x MAIL="/var/mail/root"
  declare -x OLDPWD
  declare -x PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin"
  declare -x PWD="/root"
  declare -x SHELL="/bin/bash"
  declare -x SHLVL="1"
  declare -x SUDO_COMMAND="/bin/bash"
  declare -x SUDO_GID="1000"
  declare -x SUDO_UID="1000"
  declare -x SUDO_USER="ubuntu"
  declare -x TERM="xterm"
  declare -x USER="root"
  declare -x USERNAME="root"

  After installing language-pack-hr package, I was successful at
  installing MAAS. To fix it, I had to purge maas.* and postgresql.*
  packages and then install maas package again.

  This could easily be postgresql packaging bug, but it also renders
  MAAS uninstallable.

To manage notifications about this bug go to:
https://bugs.launchpad.net/maas/+bug/1382774/+subscriptions