Wapt1.5 & Debian 9

Questions about WAPT Server / Requests and help related to the WAPT server
Forum Rules
Community Forum Rules
* English support on www.reddit.com/r/wapt
* French community support is available on this forum
* Please prefix the topic title with [RESOLVED] if it is resolved.
* Please do not edit a topic that is tagged [RESOLVED]. Open a new topic referencing the old one.
* Specify the installed WAPT version, full version, and build number (2.2.1.11957 / 2.2.2.12337 / etc.) as well as the Enterprise/Discovery edition.
* Versions 1.8.2 and earlier are no longer supported. The only questions accepted regarding version 1.8.2 are related to upgrading to a supported version (2.1, 2.2, etc.).
* Specify the server OS (Linux/Windows) and version (Debian Buster/Bullseye - CentOS 7 - Windows Server 2012/2016/2019).
* Specify the OS of the administration/package creation machine and the machine with the problematic agent, if applicable (Windows 7/10/11/Debian 11/etc.).
* Avoid asking multiple questions when opening a topic, otherwise it may be ignored. If there are multiple topics, open separate topics, preferably one after the other and not all at the same time (i.e., do not spam the forum).
* Include code snippets, screenshots, and other images directly in the post. Links to Pastebin, Bitly, and other third-party sites will be systematically removed.
* As with any community forum, support is provided voluntarily by members. If you require commercial support, you can contact Tranquil IT's sales department at 02.40.97.57.55
Locked
spleen
Messages: 5
Registration: Sep 4, 2017 - 4:51 p.m.

January 22, 2018 - 5:29 PM

Good morning

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

result

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):
  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
User avatar
sfonteneau
WAPT Expert
Messages: 2318
Registered: July 10, 2014 - 11:52 PM
Contact :

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)
spleen
Messages: 5
Registration: Sep 4, 2017 - 4:51 p.m.

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.
User avatar
dcardon
WAPT Expert
Messages: 1929
Registration: June 18, 2014 - 09:58
Location: Saint Sébastien sur Loire
Contact :

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
Denis Cardon - Tranquil IT
Share your experiences on WAPT! Send us your blog and article URLs in the "Your Opinion of the forum, and we'll feature them on the WAPT
User avatar
sfonteneau
WAPT Expert
Messages: 2318
Registered: July 10, 2014 - 11:52 PM
Contact :

February 16, 2018 - 8:08 PM

Can you launch a:

Code: Select all

localectl status
and give us the result?
Locked