Mailing List Archive: installing davical in debian jessie

hi,

im not sure, but i guess the davical database has been created:
postgres=# \list
List of databases
Name | Owner | Encoding | Collate | Ctype |
Access privileges
-----------+-------------+----------+-------------+-------------+-----------------------
davical | davical_dba | UTF8 | en_US.UTF-8 | en_US.UTF-8 |

but now i get in apache2 error.log:
[Mon Aug 24 16:07:35.906417 2015] [:error] [pid 28697] [client
::1:58064] Unable to connect to database: SQLSTATE[08006] [7] FATAL:
Peer authentication failed for user "davical_app"
[Mon Aug 24 16:07:35.906459 2015] [:error] [pid 28697] [client
::1:58064] PHP Fatal error: PDO connection error 'pgsql:dbname=davical
user=davical_app': SQLSTATE[08006] [7] FATAL: Peer authentication failed
for user "davical_app" in /usr/share/awl/inc/AwlDBDialect.php on line 103

but since i added:

local davical davical_dba trust
local davical davical_app trust

to: /etc/postgresql/9.4/main/pg_hba.conf
and restarted the server...what did i miss?

greetings

------------------------------------------------------------------------------
_______________________________________________
Davical-general mailing list
Davical-general@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/davical-general

peter schreef op 2015-08-24 16:12:

> but since i added:
>
> local davical davical_dba trust
> local davical davical_app trust
>
> to: /etc/postgresql/9.4/main/pg_hba.conf
> and restarted the server...what did i miss?

2 possible causes:
1. The user 'davical_app' was not created for some reason
2. The place where you added those two lines inside the pg_hba.conf is
important - do not just add them to the bottom of the file (ooth I add
them after the first, by default uncommented, line)

(and of course reload your configuration after you make any changes, but
you already knew that)

Kr,
Vincent
--
Vincent Van Houtte
Advocaat
Advocatenkantoor Suy, Van Baeveghem & Van Houtte
Brusselsestraat 108
9200 Dendermonde
T 052 52 06 05
T 052 77 90 05
F 052 52 06 46
W http://synergylaw.be

------------------------------------------------------------------------------
_______________________________________________
Davical-general mailing list
Davical-general@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/davical-general