[Davical-general] unable to connect to davical database (no password supplied)

classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[Davical-general] unable to connect to davical database (no password supplied)

Michael Parchet
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 ?


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

_______________________________________________
Davical-general mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/davical-general

update-davical-database (19K) Download Attachment
pg_hba.conf (6K) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: unable to connect to davical database (no password supplied)

Nikolai Lusan
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 <[hidden email]>

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

_______________________________________________
Davical-general mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/davical-general

signature.asc (836 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: unable to connect to davical database (no password supplied)

Michael Parchet
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/davical-general


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

_______________________________________________
Davical-general mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/davical-general

update-davical-database (14K) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: unable to connect to davical database (no password supplied)

Nikolai Lusan
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 <[hidden email]>

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

_______________________________________________
Davical-general mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/davical-general

signature.asc (836 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: unable to connect to davical database (no password supplied)

Michael Parchet




> Le 21 nov. 2015 à 21:26, Nikolai Lusan <[hidden email]> 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 <[hidden email]>
> ------------------------------------------------------------------------------
> _______________________________________________
> Davical-general mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/davical-general

------------------------------------------------------------------------------
_______________________________________________
Davical-general mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/davical-general
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: unable to connect to davical database (no password supplied)

Nikolai Lusan
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 <[hidden email]>

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

_______________________________________________
Davical-general mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/davical-general

signature.asc (836 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: unable to connect to davical database (no password supplied)

Michael Parchet




> Le 21 nov. 2015 à 22:24, Nikolai Lusan <[hidden email]> 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 <[hidden email]>
> ------------------------------------------------------------------------------
> _______________________________________________
> Davical-general mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/davical-general

------------------------------------------------------------------------------
_______________________________________________
Davical-general mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/davical-general
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[Davical-general] Fwd: Re: unable to connect to davical database (no password supplied)

Michael Parchet


Hello,

I have set the davical password with this command



            alter user postgres with password 'davical_password';
           

And I put it in  update-davical-database on the my $dbpass = " line And the connection work.

Thanks lot for your suppport

Best regards

mparchet


Then, I have drop and recreate database with create-database.sh

  > Le 21 nov. 2015 à 22:24, Nikolai Lusan <[hidden email]> 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 <[hidden email]>
> ------------------------------------------------------------------------------
> _______________________________________________
> Davical-general mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/davical-general




------------------------------------------------------------------------------
_______________________________________________
Davical-general mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/davical-general
Loading...