psql in version 9.1 connect to server 9.3 get the same error as above.
=>
dpkg -l | grep libpq
ii libpq5 9.1.13-0wheezy1
amd64PostgreSQL C client library
the other I cant say, now thats
ii libpq5:amd64 9.4~beta1-2.pgdg70+1
amd64
On 07/16/2014 01:13 AM, basti wrote:
Yes all clusters, run on the same machine.
All packages are from pgdg.
libpq5 is version 9.3.4-1.pgdg70+1
That is not what a previous post indicated:
"dpkg -l | grep libpq
ii libpq5 9.1.13-0wheezy1
amd64PostgreSQL C cli
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of basti
> Sent: Mittwoch, 16. Juli 2014 10:14
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] php password authentication failed for use
Yes all clusters, run on the same machine.
All packages are from pgdg.
libpq5 is version 9.3.4-1.pgdg70+1
the problem is still the same,
The relevant database is only for testing and development,
I will downgrade to 9.1.
Thanks for helping.
Regards,
basti
Am 15.07.2014 16:46, schrieb Adrian Kla
On 07/15/2014 07:45 AM, basti wrote:
psql in version 9.1 connect to server 9.3 get the same error as above.
=>
dpkg -l | grep libpq
ii libpq5 9.1.13-0wheezy1
amd64PostgreSQL C client library
the other I cant say, now thats
ii libpq5:amd64
basti wrote:
> hostall all localhost md5
>
> then I get the following error:
>
> password authentication failed for user "testuser"
Aside from submitting a wrong password, a less obvious cause for this error
message is when the password is expired.
Not so long ago, th
On 07/15/2014 07:17 AM, basti wrote:
Hello Adrian,
Yes I use the correct cluster.
password authentication failed for user "testuser" ...
is a line from the postgres log
Yes I know what "trust" mean.
psql in version 9.3 can connect without error,
psql in version 9.1 connect to server 9.3 get t
psql in version 9.1 connect to server 9.3 get the same error as above.
=>
dpkg -l | grep libpq
ii libpq5 9.1.13-0wheezy1
amd64PostgreSQL C client library
the other I cant say, now thats
ii libpq5:amd64 9.4~beta1-2.pgdg70+1
amd64
On 07/15/2014 07:17 AM, basti wrote:
Hello Adrian,
Yes I use the correct cluster.
password authentication failed for user "testuser" ...
is a line from the postgres log
Yes I know what "trust" mean.
psql in version 9.3 can connect without error,
psql in version 9.1 connect to server 9.3 get t
Hello Adrian,
Yes I use the correct cluster.
password authentication failed for user "testuser" ...
is a line from the postgres log
Yes I know what "trust" mean.
psql in version 9.3 can connect without error,
psql in version 9.1 connect to server 9.3 get the same error as above.
I have done th
On 07/15/2014 05:52 AM, basti wrote:
The last days I have done some tests and it seems that postgres 9.3 and
php 5.4.4 can't work together.
I find that hard to believe.
Can someone please confirm:
";
$con = pg_connect("host=$host port=$port dbname=$db user=$user
password=$pass")
or die
The last days I have done some tests and it seems that postgres 9.3 and
php 5.4.4 can't work together.
Can someone please confirm:
";
$con = pg_connect("host=$host port=$port dbname=$db user=$user
password=$pass")
or die ("Could not connect to server\n");
print_r($con);
?>
work well with
hos
On Wed, Jul 9, 2014 at 5:37 AM, basti wrote:
> #hostall all 0.0.0.0 0.0.0.0 md5
> did not work.
>
>
If it really starts with a # like you show it above, it's just a comment
and pretty much guaranteed not to do anything.
Cheers,
Ken
--
AGENCY Software
A
Hi:
On Wed, Jul 9, 2014 at 2:37 PM, basti wrote:
> I don't know whats wrong there
> hostmydns mydnslocalhost trust
> works well and
> #hostall all 0.0.0.0 0.0.0.0 md5
> did not work.
> I use Postgres 9.3.4-1.pgdg70+1.
On Wed, Jul 9, 2014 at 6:37 AM, basti wrote:
> I don't know whats wrong there
> hostmydns mydnslocalhost trust
> works well and
>
> #hostall all 0.0.0.0 0.0.0.0 md5
> did not work.
>
> I use Postgres 9.3.4-1.pgdg70+1.
>
I don't know whats wrong there
hostmydns mydnslocalhost trust
works well and
#hostall all 0.0.0.0 0.0.0.0 md5
did not work.
I use Postgres 9.3.4-1.pgdg70+1.
Am 09.07.2014 14:04, schrieb basti:
> Here is the output of
On Wed, Jul 9, 2014 at 5:04 AM, basti wrote:
> Hello my pg_hab.conf has this entry:
>
> hostall all 127.0.0.1/32md5
>
> When I try to use PHP to connect to the Database I get
>
> "postgres password authentication failed for user ..."
>
> The PHP-code looks l
On 9 July 2014 15:10, basti wrote:
> There are other entrys in pg_hab.conf and yes the passwd is correct.
> (psql -p ... -h ... from command line runs well).
I do hope you're looking in a file named pg_hba.conf and not
pg_hab.conf? The latter is unknown to PG, you should throw that away
if it's t
Is there a simple md5 hash?
I also try to hash my passwd via md5.
There is sill the same error.
Am 09.07.2014 15:19, schrieb rob stone:
> Are you encrypting the password? If not, alter the pg_hba.conf file to
> "trust" instead of md5. If it's all running on localhost it's no big
> deal.
--
Sent
On 07/09/2014 06:19 AM, rob stone wrote:
You need to use "sslmode=require".
Are you encrypting the password? If not, alter the pg_hba.conf file to
"trust" instead of md5. If it's all running on localhost it's no big
deal.
AFAIK PHP, in the connect function, takes care of encrypting the
On 07/09/2014 06:10 AM, basti wrote:
There are other entrys in pg_hab.conf and yes the passwd is correct.
So what are the other entries and where are they relative to the line
that you think is causing the problem?
(psql -p ... -h ... from command line runs well).
In your first post you s
On Wed, 2014-07-09 at 14:01 +0200, basti wrote:
> Yes, there is the same problem.
> postgres logs also:
>
> "Connection matched pg_hba.conf line 93
> „hostall all 127.0.0.1/32md5“"
>
> Am 09.07.2014 13:14, schrieb Bill Moran:
> > On Wed, 09 Jul 2014 13:0
There are other entrys in pg_hab.conf and yes the passwd is correct.
(psql -p ... -h ... from command line runs well).
I don't know whats wrong there
hostmydns mydnslocalhost trust
works well and
#hostall all 0.0.0.0 0.0.0.0
On 07/09/2014 04:04 AM, basti wrote:
Hello my pg_hab.conf has this entry:
hostall all 127.0.0.1/32md5
Is that the only entry?
If not remember first matching entry wins, so is there another line
above this?
When I try to use PHP to connect to the Da
Here is the output of the echo.
host=127.0.0.1 user=mydns password=mypass sslmode=allow dbname=mydns
I have also try host=localhost and sslmode=require
Am 09.07.2014 13:47, schrieb Francisco Olarte:
> Hi:
>
> On Wed, Jul 9, 2014 at 1:04 PM, basti wrote:
>> Hello my pg_hab.conf has this entry:
Yes, there is the same problem.
postgres logs also:
"Connection matched pg_hba.conf line 93
„hostall all 127.0.0.1/32md5“"
Am 09.07.2014 13:14, schrieb Bill Moran:
> On Wed, 09 Jul 2014 13:04:19 +0200 basti wrote:
>
>> Hello my pg_hab.conf has this entry:
Hi:
On Wed, Jul 9, 2014 at 1:04 PM, basti wrote:
> Hello my pg_hab.conf has this entry:
> hostall all 127.0.0.1/32md5
> global $dbhost, $dbuser, $dbpass, $dbname, $use_pgsql, $dbconn;
...
> $connect = "host=$dbhost user=$dbuser password=$dbpass
On Wed, 09 Jul 2014 13:04:19 +0200 basti wrote:
> Hello my pg_hab.conf has this entry:
>
> hostall all 127.0.0.1/32md5
>
> When I try to use PHP to connect to the Database I get
>
> "postgres password authentication failed for user ..."
>
> The PHP-code
28 matches
Mail list logo
