Problem with fresh installation (Debian 10)

Hi all,

thank you for providing your forum. I installed a pretty new Debian 10 Linux server that will serve my zammad instance. I just followed the instructions using " Install on Debian via DEB" in the zammod documentation, but I did not get success with it.

All installation steps will run through, but there are some errors. If I try to access the nginx server, I get an 502 Bad Gateway response. This is because there is no open socket on Port 3000, which is the configured port for the nginx upstream. Reading the installation logs carefully it turned out that I have problems with the locale and PostgreSQL. Just hopefully anyone could help me to complete my installation.

I will try to support you with any information which is helpful to support me.

Locale:
sebastian@manner:~$ locale
locale: Cannot set LC_CTYPE to default locale: No such file or directory
locale: Cannot set LC_MESSAGES to default locale: No such file or directory
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_US.UTF-8”
LC_TIME=“en_US.UTF-8”
LC_COLLATE=“en_US.UTF-8”
LC_MONETARY=“en_US.UTF-8”
LC_MESSAGES=“en_US.UTF-8”
LC_PAPER=“en_US.UTF-8”
LC_NAME=“en_US.UTF-8”
LC_ADDRESS=“en_US.UTF-8”
LC_TELEPHONE=“en_US.UTF-8”
LC_MEASUREMENT=“en_US.UTF-8”
LC_IDENTIFICATION=“en_US.UTF-8”
LC_ALL=

sebastian@manner:~$ sudo apt-get install apt-transport-https locales sudo wget
[sudo] password for sebastian:
Reading package lists… Done
Building dependency tree
Reading state information… Done
locales is already the newest version (2.28-10).
sudo is already the newest version (1.8.27-1+deb10u2).
wget is already the newest version (1.20.1-1.1).
apt-transport-https is already the newest version (1.8.2.1).
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
sebastian@manner:~$ sudo locale-gen en_US.UTF-8
Generating locales (this might take a while)…
de_DE.UTF-8… done
Generation complete.
sebastian@manner:~$ sudo echo “LANG=en_US.UTF-8” > /etc/default/locale
-bash: /etc/default/locale: Permission denied
sebastian@manner:~$ sudo -i
root@manner:~# sudo echo “LANG=en_US.UTF-8” > /etc/default/locale
root@manner:~# cat /etc/default/locale
LANG=en_US.UTF-8

Zammad installation:

sebastian@manner:~$ sudo apt-get reinstall zammad
Reading package lists… Done
Building dependency tree
Reading state information… Done
0 upgraded, 0 newly installed, 1 reinstalled, 0 to remove and 0 not upgraded.
Need to get 0 B/123 MB of archives.
After this operation, 0 B of additional disk space will be used.
apt-listchanges: Can’t set locale; make sure $LC_* and $LANG are correct!
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LANGUAGE = (unset),
LC_ALL = (unset),
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_CTYPE to default locale: No such file or directory
locale: Cannot set LC_MESSAGES to default locale: No such file or directory
locale: Cannot set LC_ALL to default locale: No such file or directory
(Reading database … 62098 files and directories currently installed.)
Preparing to unpack …/zammad_3.3.0-1590268478.93eb8b7c.buster_amd64.deb …
Unpacking zammad (3.3.0-1590268478.93eb8b7c.buster) over (3.3.0-1590268478.93eb8b7c.buster) …
Setting up zammad (3.3.0-1590268478.93eb8b7c.buster) …

(Re)creating init scripts

Nothing to do.
Nothing to do.
Nothing to do.

Enabling Zammad on boot

Stopping Zammad

database.yml found. Updating db…

rake aborted!
PG::ConnectionBad: 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”?

     3: from /opt/zammad/vendor/bundle/ruby/2.5.0/gems/activerecord-5.2.4.3/lib/active_record/connection_adapters/postgresql_adapter.rb:692:in `connect'
     2: from /opt/zammad/vendor/bundle/ruby/2.5.0/gems/pg-0.21.0/lib/pg.rb:56:in `connect'
     1: from /opt/zammad/vendor/bundle/ruby/2.5.0/gems/pg-0.21.0/lib/pg.rb:56:in `new'

/opt/zammad/vendor/bundle/ruby/2.5.0/gems/pg-0.21.0/lib/pg.rb:56:in `initialize’: could not connect to server: No such file or directory (PG::ConnectionBad)
Is the server running locally and accepting
connections on Unix domain socket “/var/run/postgresql/.s.PGSQL.5432”?

Starting Zammad

Creating webserver bootstart

Synchronizing state of nginx.service with SysV service script with /lib/systemd/systemd-sysv-install.
Executing: /lib/systemd/systemd-sysv-install enable nginx

Restarting webserver nginx

####################################################################################

Add your fully qualified domain name or public IP to servername directive of
nginx, if this installation is done on a remote server. You have to change:
/etc/nginx/sites-available/zammad.conf and restart nginx process.
Otherwise just open http://localhost/ in your browser to start using Zammad.

####################################################################################

Could please anyone help?

Kind regards,
Sebastian.

Your main issue is this:

The installation does not complete successfully.
Ensure that your postgresql server is running and working.

If it doesn’t, check it’s logfiles on why it doesn’t want to start or talk to Zammad.

If you fixed that issue, run /opt/zammad/contrib/packager.io/postinstall.sh again to ensure the installation finished successfully.

This topic was automatically closed 120 days after the last reply. New replies are no longer allowed.