Greetings again,
So I've gotten as far as step 13.1 on
https://evergreen-ils.org/documentation/install/README_3_1.html#__configure_the_apache_web_server
I'm at the step of creating the evergreen user *createuser -s -P evergreen*
- but each time I get an error---
createuser: could not connect to database postgres: 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"?
looking at /var/run/postgresql/ there is in fact no .s.PGSQL.5432 - which
the forums suggested I run a purge and re-install which I already did once.
They also suggested running *sudo apt-get install --reinstall
postgresql-9.5* which did not create the .s.PGSQL.5432 socket, and when I
try and run *./pg_ctl reload *or *./pg_ctl restart *from the
/usr/lib/postgresql/9.5/bin location it tells me no database is specified.
And when I try to specify the location that *sudo -u postgres psql -c "show
data_directory;" *shows me on the alternate server which is
/var/lib/postgresql/9.3/main with *./pg_ctl restart -D
/var/lib/postgresql/9.5/main* it tells me it's not a database cluster
directory - and without the -D it tells me that environment variable PGDATA
is unset but so far I cannot find a command or config file that lets me set
it that works as I'm checking the working server and not finding where it
is set since postgresql.conf has the data_directory set and running
pg_config also displays them on the test server and running server. When I
try *./postgres -D /var/lib/postgresql/9.5/main *it says it cannot find the
postgresql.conf file which makes sense since it's in
/etc/postgresql/9.5/main. So should I just purge it again and re-re-install
postgres?
postgres is running - *ps axf | grep postgres* returns
8098 pts/0S+ 0:00 | \_ grep postgres
running *netstat -nltp | grep 5432 *and *netstat -nlp | grep 5432* as root
return nothing, no errors. IPTables -L shows nothing helpful -- I added
port 5432 to iptables.
Chain INPUT (policy ACCEPT)
target prot opt source destination
ACCEPT tcp -- sage.eou.edu anywhere tcp
dpt:postgresql
Chain FORWARD (policy ACCEPT)
target prot opt source destination
Chain OUTPUT (policy ACCEPT)
target prot opt source destination
I even tried creating a softlink in case it was looking at the wrong
location as suggested on a forum - no change. *ln -s /tmp/.s.PGSQL.5432
/var/run/postgresql/.s.PGSQL.543* - except the issue is that there is no
.s.PGSQL5432 in the /tmp/ folder either. Yes, I removed it when it did not
resolve the issue.
I've tried running *psql -U postgres -h localhost* to create the evergreen
user without success.
I changed the /etc/postgresql/9.5/main/postgresql.conf file to
*listen_addresses
= '*' *and added the test server's IP under IPv6 local connections like the
other servers have it in the /etc/postgresql/9.5/main/pg_hba.conf file.
They also had the following set:
# Database administrative login by Unix domain socket
local all postgrestrust
# "local" is for Unix domain socket connections only
local all all trust
I've tried it as both peer and trust without success.
I've restarted the postgres service after those changes.
When I go to /openils/bin/srfsh and ask for the ils version I get 3.1.1.
Suggestions?
-Jon
