LedgerSMB
The foundation for your business
Hi
So another day another another experiments
Redid postgresql
New packages to be INSTALLED:
postgresql96-server: 9.6.3_1
postgresql96-contrib: 9.6.3
postgresql96-client: 9.6.3_2
postgresql96-plperl: 9.6.3_1
# TYPE DATABASE USER ADDRESS METHOD
local all postgres trust
local all all trust
host all postgres 127.0.0.1/32 reject
host all postgres ::1/128 reject
host postgres,template0,template1 lsmb_dbadmin
127.0.0.1/32 md5 host postgres,template0,template1
lsmb_dbadmin ::1/128 md5 host
postgres,template0,template1 all 127.0.0.1/32 reject
host postgres,template0,template1 all ::1/128
reject host all all 127.0.0.1/32 md5
host all all ::1/128 md5 # Allow
replication connections from localhost, by a user with the #
replication privilege. "/var/db/postgres/data96/pg_hba.conf" 96 lines,
4833 characters ledgersmb:/root@[20:28] # service postgresql restart
LOG: could not create IPv6 socket: Protocol not supported
LOG: ending log output to stderr
HINT: Future log output will go to log destination "syslog".
ledgersmb:/root@[20:28] # su postgres
$
$ createdb lsmb_access_test_db
$ psql -h localhost -U lsmb_dbadmin -d lsmb_access_test_db -c "select
version()" psql: FATAL: no pg_hba.conf entry for host "10.0.0.231",
user "lsmb_dbadmin", database "lsmb_access_test_db", SSL off
host "10.0.0.231" is the ip of the jail running Ledgersmb
/var/db/postgres/data96/postgresql.conf
listen_addresses = 'localhost'
and this did not make any difference
listen_addresses = '*'
In /var/db/postgres/data96/pg_hba.conf I have used "trust" instead of
"peer" Trust is FreeBSD default and I have had trouble in the past with
peer. Not that it mattered this time.
I ran various permutations of pg_hba.conf and each had the same
conclusion
Thanks
_______________________________________________
users mailing list
..hidden..
https://lists.ledgersmb.org/mailman/listinfo/users