perfSONAR User Q&A and Other Discussion

["Hitch, Ryan R CIV SPAWARSYSCEN-PACIFIC, 53629" <>]

Not sure if this is related yet, but the following error appears installing 
the postgresql-init-9.5-1 dependency:



Installing : postgresql-init-9.5-1.el7.centos.noarch                        
78/279

grep: /etc/systemd/system/multi-user.target.wants/postgresql-9.5.service: No 
such file or directory

Unable to find PGDATA at

Running in chroot, ignoring request.

failed to find PGDATA setting in postgresql-9.5.service

Created symlink 
/etc/systemd/system/multi-user.target.wants/postgresql-9.5.service, pointing 
to /usr/lib/systemd/system/postgresql-9.5.service.



Followed by a bunch of other errors when installing pscheduler-server:

Installing : pscheduler-server-1.0.0.4-1.el7.centos.noarch      208/279

Can't open /var/lib/pgsql/9.5/data/postgresql.conf: No such file or directory



Running in chroot, ignoring request.

Unable to determine PostgreSQL user.

....and a whole lot more...



________________________________
From: 

 
[]
 on behalf of Hitch, Ryan R CIV SPAWARSYSCEN-PACIFIC, 53629 
[]
Sent: Monday, June 12, 2017 12:52 PM
To: perfsonar-user
Subject: [Non-DoD Source] [perfsonar-user] RE: pscheduler and postgresql-9.5 
are not working with perfSONAR v4.0

I am seeing the same thing on a fresh minimal install of CentOS 7.3 and then 
a "yum install perfsonar-testpoint".

Neither postgresql-9.5 nor pscheduler will start. SELinux is permissive.



Thanks,

Ryan



________________________________
From: 

 
[]
 on behalf of Daniel Manzo 
[]
Sent: Wednesday, June 07, 2017 1:46 PM
To: perfsonar-user
Subject: [Non-DoD Source] [perfsonar-user] pscheduler and postgresql-9.5 are 
not working with perfSONAR v4.0

Hi all,

After upgrading my server from RHEL 6.8 to 7.3, I needed to re-install 
perfSONAR (going from 3.5 to 4.0) on my machine. After installation, 
postgresql-9.5 will not start and all pscheduler tasks are reported as 
“active (running)” but throw errors. The errors from each are shown below:

Pscheduler

Jun  7 13:35:06 by0ok5 journal: safe_run/ticker ERROR    Restarting
Jun  7 13:35:06 by0ok5 journal: safe_run/ticker ERROR    Program threw an 
exception after 0:00:00.000908
Jun  7 13:35:06 by0ok5 journal: safe_run/ticker ERROR    Exception: IOError: 
[Errno 13] Permission denied: 
'/etc/pscheduler/database/database-dsn'#012Traceback (most recent call 
last):#012  File "/usr/lib/python2.7/site-packages/pscheduler/saferun.py", 
line 41, in safe_run#012    function()#012  File 
"/usr/libexec/pscheduler/daemons/ticker", line 153, in <lambda>#012    
pscheduler.safe_run(lambda: main_program())#012  File 
"/usr/libexec/pscheduler/daemons/ticker", line 123, in main_program#012    db 
= pscheduler.pg_connection(dsn)#012  File 
"/usr/lib/python2.7/site-packages/pscheduler/db.py", line 28, in 
pg_connection#012    dsn = string_from_file(dsn)#012  File 
"/usr/lib/python2.7/site-packages/pscheduler/filestring.py", line 23, in 
string_from_file#012    with open(path, 'r') as content:#012IOError: [Errno 
13] Permission denied: '/etc/pscheduler/database/database-dsn'
Jun  7 13:35:06 by0ok5 journal: safe_run/ticker ERROR    Waiting 60.0 seconds 
before restarting

Postgresql-9.5

â postgresql-9.5.service - PostgreSQL 9.5 database server
   Loaded: loaded (/usr/lib/systemd/system/postgresql-9.5.service; enabled; 
vendor preset: disabled)
   Active: failed (Result: exit-code) since Mon 2017-06-05 11:10:05 EDT; 2 
days ago
  Process: 31031 ExecStartPre=/usr/pgsql-9.5/bin/postgresql95-check-db-dir 
${PGDATA} (code=exited, status=1/FAILURE)

Jun 05 11:10:05 by0ok5.na.bayer.cnb systemd[1]: Starting PostgreSQL 9.5 
database server...
Jun 05 11:10:05 by0ok5.na.bayer.cnb systemd[1]: postgresql-9.5.service: 
control process exited, code=exited status=1
Jun 05 11:10:05 by0ok5.na.bayer.cnb systemd[1]: Failed to start PostgreSQL 
9.5 database server.
Jun 05 11:10:05 by0ok5.na.bayer.cnb systemd[1]: Unit postgresql-9.5.service 
entered failed state.
Jun 05 11:10:05 by0ok5.na.bayer.cnb systemd[1]: postgresql-9.5.service failed.

I think that the two problems are related, but I’m not sure what needs to be 
done in order to fix the errors. To fix the ‘Permission denied’ error, I have 
tried changing the owner and group of /etc/pscheduler/database/ to 
‘pscheduler’ instead of ‘root’ and changed file permissions. This did not 
work, and I am running out of ideas. Any and all help is greatly appreciated.

Thank you,
Dan Manzo