Tranquil IT Forum

Published: **January 22, 2018 - 5:29 PM**

Good morning

After
/usr/bin/python /opt/wapt/waptserver/scripts/postconf.py

result

making a backup copy of the configuration file
Synchronizing state of postgresql.service with SysV service script with /lib/systemd/systemd-sysv-install.
Executing: /lib/systemd/systemd-sysv-install enable postgresql
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"?
Traceback (most recent call last):
  File "/opt/wapt/waptserver/scripts/postconf.py", line 523, in <module>
    main()
  File "/opt/wapt/waptserver/scripts/postconf.py", line 337, in main
    ensure_postgresql_db()
  File "/opt/wapt/waptserver/scripts/postconf.py", line 177, in ensure_postgresql_db
    val = run(""" sudo -u postgres psql template1 -c " select usename from pg_catalog.pg_user where usename='wapt';"  """, cwd='/opt/wapt')
  File "/opt/wapt/waptserver/scripts/postconf.py", line 65, in run
    return subprocess.check_output(*args, shell=True, **kwargs)
  File "/usr/lib/python2.7/subprocess.py", line 219, in check_output
    raise CalledProcessError(retcode, cmd, output=output)
subprocess.CalledProcessError: Command ' sudo -u postgres psql template1 -c " select usename from pg_catalog.pg_user where usename='wapt';"  ' returned non-zero exit status 2

Does anyone have an idea?

THANKS

Published: **January 22, 2018 - 10:07 PM**

Do you have a specific version of version 1.5 installed? Is

the PostgreSQL service starting? (

service postgresql start)

(service postgresql status)

Published: **January 23, 2018 - 1:36 PM**

Hello,

Thank you for your feedback

. For the installation, I followed the procedure

apt-get update && apt-get upgrade
apt-get install apt-transport-https lsb-release
wget -O - https://wapt.tranquil.it/debian/tiswapt-pub.gpg | apt-key add -
echo "deb https://wapt.tranquil.it/debian/wapt-1.5/ $(lsb_release -c -s) main" > /etc/apt/sources.list.d/wapt.list

then

apt-get update
apt-get install tis-waptserver tis-waptrepo tis-waptsetup

when I type
service postgresql status

console

postgresql.servicePostgreSQL RDBMS
Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor prese
Active: active (exited) since Mon 2018-01-22 17:01:25 CET; 20h ago
Main PID: 2560 (code=exited, status=0/SUCCESS)
Tasks: 0 (limit: 4915)
CGroup: /system.slice/postgresql.service

Jan 22 17:01:25 swapt.yyy.xxx.fr systemd[1]: Starting PostgreSQL RDBMS...
Jan 22 17:01:25 swapt.yyy.xxx.fr systemd[1]: Started PostgreSQL RDBMS.

When I run the configuration script, I still get the same error.

Do you have any ideas?

Thank you for your help.

Published: **February 6, 2018 - 7:51 PM**

spleen wrote: ↑Jan 22, 2018 - 5:29 PM

Code: Select all

making a backup copy of the configuration file
Synchronizing state of postgresql.service with SysV service script with /lib/systemd/systemd-sysv-install.
Executing: /lib/systemd/systemd-sysv-install enable postgresql
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"?
Traceback (most recent call last):
[/quote]

Est ce que la socket /var/run/postgresql/.s.PGSQL.5432 existe bien?
Est ce que vous avez du selinux/apparmor activé
Qu'est ce que vous obtenez quand vous lancer 
[code]
sudo -u wapt ls -l /var/run/postgresql/.s.PGSQL.5432

Denis

Published: **February 16, 2018 - 8:08 PM**

Can you launch a:

Code: Select all

localectl status

and give us the result?

Tranquil IT Forum

Wapt1.5 & Debian 9

Wapt1.5 & Debian 9

Re: Wapt1.5 & Debian 9

Re: Wapt1.5 & Debian 9

Re: Wapt1.5 & Debian 9

Re: Wapt1.5 & Debian 9