On Wed, 09 Jul 2014 13:04:19 +0200 basti <mailingl...@unix-solution.de> wrote:
> Hello my pg_hab.conf has this entry: > > host all all 127.0.0.1/32 md5 > > When I try to use PHP to connect to the Database I get > > "postgres password authentication failed for user ..." > > The PHP-code looks like > > > global $dbhost, $dbuser, $dbpass, $dbname, $use_pgsql, $dbconn; > > if ($use_pgsql) > { > $connect = "host=$dbhost user=$dbuser password=$dbpass > dbname=$dbname"; > echo $connect; > if (!($dbconn = pg_connect($connect))) > { > open_page(); > ErrSQL("Unable to connect to database."); > } > > When I try to connect via > psql -U user -h localhost -W database > I can connect without error. > > I also use SSL connections, is this the problem? or in other words is > there a way to connect php via (postgres) ssl? Have you tried using sslmode or requiressl in the $connect string? -- Bill Moran <wmo...@potentialtech.com> -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general