Am Fri, Aug 06, 2021 at 08:09:03PM +0200 schrieb Matthias Apitz:
> The prototype is ready.
Nice. Now the elephant needs to fade into the background.
Karsten
--
GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B
El día sábado, agosto 07, 2021 a las 08:06:14p. m. +0200, Karsten Hilbert
escribió:
> Am Fri, Aug 06, 2021 at 08:09:03PM +0200 schrieb Matthias Apitz:
>
> > The prototype is ready.
>
> Nice. Now the elephant needs to fade into the background.
It is already in the background (done with libreoff
Readers,
Background: http://news-web.php.net/php.general/327600
Since further configuration, remain unable to connect to the php database.
Software system is debian, xfce, postgresql, php. Database created on local
machine with directory of web server content in extant normal user account.
The
On 8/7/21 11:46 AM, ourdiaspora wrote:
Readers,
Background: http://news-web.php.net/php.general/327600
Since further configuration, remain unable to connect to the php database.
Further configuration of what?
After the configuration change did you restart the server?
Is the pg_hba.conf file
On Sat, 7 Aug 2021 20:44:41 +0200
Matthias Apitz wrote:
> El día sábado, agosto 07, 2021 a las 08:06:14p. m. +0200, Karsten Hilbert
> escribió:
>
> > Am Fri, Aug 06, 2021 at 08:09:03PM +0200 schrieb Matthias Apitz:
> >
> > > The prototype is ready.
> >
> > Nice. Now the elephant needs to f
On Saturday, August 7th, 2021 at 8:23 PM, Adrian Klaver
wrote:
> > Since further configuration, remain unable to connect to the php database.
>
> Further configuration of what?
>
The postgresql configuration file:
SHOW hba_file;
/etc/postgresql/9.6/main/pg_hba.conf
SHOW config_file;
On 8/7/21 1:09 PM, ourdiaspora wrote:
On Saturday, August 7th, 2021 at 8:23 PM, Adrian Klaver
wrote:
Since further configuration, remain unable to connect to the php database.
Further configuration of what?
The postgresql configuration file:
SHOW hba_file;
/etc/postgresql/9.6/m
On Sat, Aug 7, 2021 at 2:48 PM Jehan-Guillaume de Rorthais
wrote:
> On Sat, 7 Aug 2021 20:44:41 +0200
> Matthias Apitz wrote:
>
> > El día sábado, agosto 07, 2021 a las 08:06:14p. m. +0200, Karsten Hilbert
> > escribió:
> >
> > > Am Fri, Aug 06, 2021 at 08:09:03PM +0200 schrieb Matthias Apitz:
>
On 8/7/21 1:09 PM, ourdiaspora wrote:
On Saturday, August 7th, 2021 at 8:23 PM, Adrian Klaver
wrote:
Changes were made to the function 'listen_addressess' to the configuration file
shown in above.
I should have asked in previous post, what was 'listen_addresses'
changed to?
--
A
On Saturday, August 7th, 2021 at 10:17 PM, Adrian Klaver
wrote:
> On 8/7/21 1:09 PM, ourdiaspora wrote:
>
> > On Saturday, August 7th, 2021 at 8:23 PM, Adrian Klaver
> > adrian.kla...@aklaver.com wrote:
>
> > Changes were made to the function 'listen_addressess' to the configuration
> > file
On 8/7/21 3:15 PM, ourdiaspora wrote:
On Saturday, August 7th, 2021 at 10:17 PM, Adrian Klaver
wrote:
On 8/7/21 1:09 PM, ourdiaspora wrote:
On Saturday, August 7th, 2021 at 8:23 PM, Adrian Klaver
adrian.kla...@aklaver.com wrote:
Changes were made to the function 'listen_addressess' to
ourdiaspora writes:
> The postgresql server was restarted, successfully.
> listen_addresses = 'localhost'
I believe on most machines, that would result in the postmaster
only listening on 127.0.0.1, and ::1 if you're IPv6-enabled.
If php is trying to connect to something else, like say the
machin
On Saturday, August 7th, 2021 at 11:20 PM, Adrian Klaver
wrote:
>
> 1. OS and version?
Same local machine as described
> 2. The contents of /etc/hosts
127.0.0.1 localhost
::1 localhost ip6-localhost ip6-loopback
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
>
On Sunday, August 8th, 2021 at 12:11 AM, Tom Lane wrote:
>
> If php is trying to connect to something else, like say the
>
> machine's external IP address, that could be your issue.
Excuse the ignorance, but if the instruction in the php file is:
"
...$dbconn = pg_connect("dbname=cpacweb user=cp
ourdiaspora writes:
> psql -d cpacweb -h 127.0.0.1 -U cpaca
> psql: could not connect to server: Connection refused
> Is the server running on host "127.0.0.1" and accepting
> TCP/IP connections on port 5432?
Hm --- this suggests that you've got a kernel packet filter (i.e.
software f
On Saturday, August 7, 2021, ourdiaspora wrote:
>
> SHOW hba_file;
> /etc/postgresql/9.6/main/pg_hba.conf
>
>
Please post the contents of this file. The one shown at the link is
invalid.
David J.
On Saturday, August 7, 2021, Tom Lane wrote:
> ourdiaspora writes:
> > psql -d cpacweb -h 127.0.0.1 -U cpaca
> > psql: could not connect to server: Connection refused
> > Is the server running on host "127.0.0.1" and accepting
> > TCP/IP connections on port 5432?
>
> Hm --- this sugg
On Sunday, August 8th, 2021 at 12:26 AM, Tom Lane wrote:
>
> Hm --- this suggests that you've got a kernel packet filter (i.e.
>
> software firewall) that is not passing traffic for 5432.
Don't know anything about that, so perhaps it can be assumed unchanged from
whatever the default system con
On Sunday, August 8th, 2021 at 12:50 AM, David G. Johnston
wrote:
> On Saturday, August 7, 2021, ourdiaspora wrote:
>
> > SHOW hba_file;
> >
> > /etc/postgresql/9.6/main/pg_hba.conf
>
> Please post the contents of this file. The one shown at the link is invalid.
local all
On Saturday, August 7, 2021, ourdiaspora wrote:
>
> On Sunday, August 8th, 2021 at 12:50 AM, David G. Johnston <
> david.g.johns...@gmail.com> wrote:
>
> > On Saturday, August 7, 2021, ourdiaspora
> wrote:
> >
> > > SHOW hba_file;
> > >
> > > /etc/postgresql/9.6/main/pg_hba.conf
> >
> >
On 8/7/21 4:11 PM, ourdiaspora wrote:
On Saturday, August 7th, 2021 at 11:20 PM, Adrian Klaver
wrote:
psql -d cpacweb -h 127.0.0.1 -U cpaca
psql: could not connect to server: Connection refused
Is the server running on host "127.0.0.1" and accepting
TCP/IP connections on
On Sunday, August 8th, 2021 at 1:02 AM, Adrian Klaver
wrote:
> What did you change listen_addresses from?
>
New line; same line had hash (#) to comment out.
> What if you do?:
>
> psql -d cpacweb -U cpaca
>
psql -d cpacweb -U cpaca
psql: FATAL: Peer authentication failed for user "cpaca"
On 8/7/21 5:36 PM, ourdiaspora wrote:
On Sunday, August 8th, 2021 at 1:02 AM, Adrian Klaver
wrote:
What did you change listen_addresses from?
New line; same line had hash (#) to comment out.
What if you do?:
psql -d cpacweb -U cpaca
psql -d cpacweb -U cpaca
psql: FATAL: Peer authen
ourdiaspora writes:
> psql -d cpacweb -U cpaca
> psql: FATAL: Peer authentication failed for user "cpaca"
The reason that's able to make a connection to the PG server
is that it's not going through TCP at all, but a Unix socket.
I'd guess at this point that your configuration never worked
for
24 matches
Mail list logo
