Advanced
Mailing List Archive

Mailing List Archive

  1. Home >
  2. DAViCal>
  3. General
unable to connect to davical database (no password supplied)
mparchet at sunrise
Nov 20, 2015, 11:41 AM
Post #1 of 7 (2707 views)
Permalink
Hello,

I have installed davical with davical package on ubuntu 14.04 64 bit
LTS.. My postgres user is configured with a password. I have followed
the documentation but when I try to create database with the
create-database.sh or update-davical-database (see attachement because I
try to modify it to connect with localhost), I get this error :

/update-davical-database
DBI connect('dbname=davical;host=127.0.0.1','davical_dba',...) failed:
fe_sendauth: no password supplied at no update-davical-database line 244.
Can't connect to database davical at update-davical-database line 244.


Note update-davical-database is in /davical/dba/update-davical-database
of my root apache web server and the other file is in
/etc/postgresql/9.3/main/pg_hba.conf

My configuration is
ubuntu 14.04 LTS
Postgresql 9.3
davical 1.1.1 - 1

Could you help me please ?

Thanks for your support

Best regards

mparchet

ps Is DavIcal allways maintained and updated ?

Attached Files:

Re: unable to connect to davical database (no password supplied) [ In reply to ]
nikolai at lusan
Nov 20, 2015, 12:23 PM
Post #2 of 7 (2667 views)
Permalink
On Fri, 2015-11-20 at 20:41 +0100, Michael Parchet wrote:
> I have installed davical with davical package on ubuntu 14.04 64 bit
> LTS.. My postgres user is configured with a password. I have followed
> the documentation but when I try to create database with the
> create-database.sh or update-davical-database (see attachement
> because I
> try to modify it to connect with localhost), I get this error 
>
> /update-davical-database
> DBI connect('dbname=davical;host=127.0.0.1','davical_dba',...)
> failed:
> fe_sendauth: no password supplied at no update-davical-database line
> 244.
> Can't connect to database davical  at update-davical-database line
> 244.

Postgres is configured wrong ... the local directive tells it to use
the unix sockets. You might want to change or add a host directive.

host    all             all             127.0.0.1/32            md5

is a good start - anyone connecting via localhost IP will have to use a
password to access a DB. You can, of course, specify database and users
too.

--
Nikolai Lusan <nikolai@lusan.id.au>

Attached Files:

Re: unable to connect to davical database (no password supplied) [ In reply to ]
mparchet at sunrise
Nov 21, 2015, 7:43 AM
Post #3 of 7 (2663 views)
Permalink
Hello,

My file "/etc/postgresql/9.3/main/pg_hba.conf" is now configure like this

# trust davical
local davical davical_app trust
local davical davical_dba trust
host all all 127.0.0.1/32 md5


but when I run the file davical/dba/update-davical-database I get this
error :
DBI connect('dbname=davical;host=127.0.0.1','davical_dba',...) failed:
fe_sendauth: no password supplied at
/var/www/html/davical/dba/update-davical-database line 244.
Can't connect to database davical at
/var/www/html/davical/dba/update-davical-database line 244.

My question :
Is my file update-davical-databas correctly configured ? (see attachement) ?

Thanks by advance for your support

Best regards

mparchet


On 20/11/2015 21:23, Nikolai Lusan wrote:
> On Fri, 2015-11-20 at 20:41 +0100, Michael Parchet wrote:
>> I have installed davical with davical package on ubuntu 14.04 64 bit
>> LTS.. My postgres user is configured with a password. I have followed
>> the documentation but when I try to create database with the
>> create-database.sh or update-davical-database (see attachement
>> because I
>> try to modify it to connect with localhost), I get this error
>>
>> /update-davical-database
>> DBI connect('dbname=davical;host=127.0.0.1','davical_dba',...)
>> failed:
>> fe_sendauth: no password supplied at no update-davical-database line
>> 244.
>> Can't connect to database davical at update-davical-database line
>> 244.
> Postgres is configured wrong ... the local directive tells it to use
> the unix sockets. You might want to change or add a host directive.
>
> host all all 127.0.0.1/32 md5
>
> is a good start - anyone connecting via localhost IP will have to use a
> password to access a DB. You can, of course, specify database and users
> too.
>
>
>
> ------------------------------------------------------------------------------
>
>
> _______________________________________________
> Davical-general mailing list
> Davical-general@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/davical-general

Attached Files:

Re: unable to connect to davical database (no password supplied) [ In reply to ]
nikolai at lusan
Nov 21, 2015, 12:26 PM
Post #4 of 7 (2663 views)
Permalink
On Sat, 2015-11-21 at 16:43 +0100, Michael Parchet wrote:
>   # trust davical
>   local   davical davical_app     trust
>   local   davical davical_dba     trust
> host    all             all         127.0.0.1/32            md5
  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
All users connecting via localhost IP must provided a password.


> but when I run the file davical/dba/update-davical-database I get
> this
> error :
> DBI connect('dbname=davical;host=127.0.0.1','davical_dba',...)
> failed:
> fe_sendauth: no password supplied at
              ^^^^^^^^^^^^^^^^^^^^^^^

Did you read the error message? You are not providing a password in the
update script


> /var/www/html/davical/dba/update-davical-database line 244.
> Can't connect to database davical at
> /var/www/html/davical/dba/update-davical-database line 244.


--
Nikolai Lusan <nikolai@lusan.id.au>

Attached Files:

Re: unable to connect to davical database (no password supplied) [ In reply to ]
mparchet at sunrise
Nov 21, 2015, 1:11 PM
Post #5 of 7 (2659 views)
Permalink
> Le 21 nov. 2015 à 21:26, Nikolai Lusan <nikolai@lusan.id.au> a écrit :
>
>> On Sat, 2015-11-21 at 16:43 +0100, Michael Parchet wrote:
>> # trust davical
>> local davical davical_app trust
>> local davical davical_dba trust
>> host all all 127.0.0.1/32 md5
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> All users connecting via localhost IP must provided a password.
>
>
>> but when I run the file davical/dba/update-davical-database I get
>> this
>> error :
>> DBI connect('dbname=davical;host=127.0.0.1','davical_dba',...)
>> failed:
>> fe_sendauth: no password supplied at
> ^^^^^^^^^^^^^^^^^^^^^^^
>
> Did you read the error message? You are not providing a password in the
> update script

Which password should I put in my update script ? The Postgres admin password ?

Thanks for your support

Best regards

mparchet
>
>
>> /var/www/html/davical/dba/update-davical-database line 244.
>> Can't connect to database davical at
>> /var/www/html/davical/dba/update-davical-database line 244.
>
>
> --
> Nikolai Lusan <nikolai@lusan.id.au>
> ------------------------------------------------------------------------------
> _______________________________________________
> Davical-general mailing list
> Davical-general@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/davical-general

------------------------------------------------------------------------------
_______________________________________________
Davical-general mailing list
Davical-general@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/davical-general
Re: unable to connect to davical database (no password supplied) [ In reply to ]
nikolai at lusan
Nov 21, 2015, 1:24 PM
Post #6 of 7 (2664 views)
Permalink
On Sat, 2015-11-21 at 22:11 +0100, Michael Parchet wrote:
> 
> > > fe_sendauth: no password supplied at
> >               ^^^^^^^^^^^^^^^^^^^^^^^
> > Did you read the error message? You are not providing a password in
> > the
> > update script
>
> Which password should I put in my update script ? The Postgres admin
> password ?

The davical_dba password
--
Nikolai Lusan <nikolai@lusan.id.au>

Attached Files:

Re: unable to connect to davical database (no password supplied) [ In reply to ]
mparchet at sunrise
Nov 21, 2015, 1:58 PM
Post #7 of 7 (2662 views)
Permalink
> Le 21 nov. 2015 à 22:24, Nikolai Lusan <nikolai@lusan.id.au> a écrit :
>
>> On Sat, 2015-11-21 at 22:11 +0100, Michael Parchet wrote:
>>
>>>> fe_sendauth: no password supplied at
>>> ^^^^^^^^^^^^^^^^^^^^^^^
>>> Did you read the error message? You are not providing a password in
>>> the
>>> update script
>>
>> Which password should I put in my update script ? The Postgres admin
>> password ?
>
> The davical_dba password
> --
How could I defines the davical password because I Could not connect to the davical database

Could you help me please ?

Best regards

mparchet
> Nikolai Lusan <nikolai@lusan.id.au>
> ------------------------------------------------------------------------------
> _______________________________________________
> Davical-general mailing list
> Davical-general@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/davical-general

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

©2024 GT.net. A Gossamer Threads company.
5th Floor, 455 Granville St., Vancouver, BC V6C 1T1, Canada | Legal