Mailing List Archive: database problem

Hi

I have been trying to set up a sever for a day or 2, and I can not work
out how to get past a problem.

As far as i can I have set every thing up be right and I get:-

from the web page:-

Database Error

Could not connect to PostgreSQL database

from postgresql-8.4-main.log ;-

2009-11-28 11:22:37 GMT LOG: provided username (www-data) and
authenticated username (davical_app) don't match
2009-11-28 11:22:37 GMT FATAL: Ident authentication failed for user
"davical_app"

from apache access.log
192.168.1.64 - - [28/Nov/2009:14:39:07 +0000] "GET /cal/ HTTP/1.1" 200
426 "-" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.5)
Gecko/20091102 Firefox/3.5.5 GTB5 (.NET CLR 3.5.30729)"

from apache error.log
[Sat Nov 28 12:39:40 2009] [error] [client 192.168.1.64] DAViCal: ***:
ERROR:Connection failed: >>0<< = >>dbname=davical port=5432
user=davical_app host=tv<<
[Sat Nov 28 14:39:03 2009] [error] [client 192.168.1.64] DAViCal: ***:
ERROR:Connection failed: >>0<< = >>dbname=davical port=5432
user=davical_app host=tv<<
[Sat Nov 28 14:39:07 2009] [error] [client 192.168.1.64] DAViCal: ***:
ERROR:Connection failed: >>0<< = >>dbname=davical port=5432
user=davical_app host=tv<<

any ideas?

Roger

On Sat, 2009-11-28 at 14:41 +0000, Roger wrote:
> Hi
>
> I have been trying to set up a sever for a day or 2, and I can not work
> out how to get past a problem.
>
> As far as i can I have set every thing up be right and I get:-
>
> from the web page:-
>
>
> Database Error
>
>
> Could not connect to PostgreSQL database
>
>
>
> from postgresql-8.4-main.log ;-
>
> 2009-11-28 11:22:37 GMT LOG: provided username (www-data) and
> authenticated username (davical_app) don't match
> 2009-11-28 11:22:37 GMT FATAL: Ident authentication failed for user
> "davical_app"

Hi Roger,

When you edited the pg_hba.conf file which controls how PostgreSQL
database users can connect to the database, you may have put the
configuration line for the davical_app user at the end of the file,
rather than at the beginning.

Alternatively you may simply not have reloaded the database process
after changing that file.

Regards,
Andrew McMillan.

------------------------------------------------------------------------
http://andrew.mcmillan.net.nz/ Porirua, New Zealand
Twitter: _karora Phone: +64(272)DEBIAN
I have not seen high-discipline processes succeed in commercial
settings. - Alistair Cockburn

------------------------------------------------------------------------

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part
URL: <http://lists.morphoss.com/pipermail/davical-users/attachments/20091129/4488038f/attachment.pgp>
-------------- next part --------------