[Pkg-postgresql-public] Bug#684429: closed by Christoph Berg <myon at debian.org> (Re: Bug#684429: postgresql 9.1 cant allow conection: port 5432 are not visible in any case)
PICCORO McKAY Lenz
mckaygerhard at gmail.com
Thu May 2 14:18:58 UTC 2013
Chris.. in every install of backported postgres 9.X i have to nstall first
postgres 8.X and then removed before install postgres 9.X, if not, the
instalation of postgres 9.X from backported could not work in networks..
port are ghosted and hidden.. always..
this bug are still happening...
i have a Presence system and in avery client something i have to re-install
postgres 9.x due thi bug.
Lenz McKAY Gerardo (PICCORO)
http://qglochekone.blogspot.com
On Thu, May 2, 2013 at 4:21 AM, Debian Bug Tracking System <
owner at bugs.debian.org> wrote:
> This is an automatic notification regarding your Bug report
> which was filed against the postgresql-9.1 package:
>
> #684429: postgresql 9.1 cant allow conection: port 5432 are not visible in
> any case
>
> It has been closed by Christoph Berg <myon at debian.org>.
>
> Their explanation is attached below along with your original report.
> If this explanation is unsatisfactory and you have not received a
> better one in a separate message then please contact Christoph Berg <
> myon at debian.org> by
> replying to this email.
>
>
> --
> 684429: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=684429
> Debian Bug Tracking System
> Contact owner at bugs.debian.org with problems
>
>
> ---------- Forwarded message ----------
> From: Christoph Berg <myon at debian.org>
> To: 684429-done at bugs.debian.org
> Cc:
> Date: Thu, 2 May 2013 10:47:26 +0200
> Subject: Re: Bug#684429: postgresql 9.1 cant allow conection: port 5432
> are not visible in any case
> Re: PICCORO McKAY Lenz 2012-09-10 <
> CALci+FSLxAgk1W3rcesq1gK7iq8woyODuzfjbSQyJJ1cHwMEVQ at mail.gmail.com>
> > 9.1) i can now connect susessfully from any host
> > 9.2) remove and force purge postgres 8.X unninstall
> > 9.3) again install backpor/9.1 postgres
> > 9.4) eureka! i see the port open, and work prefectly
>
> I'll interpret "sucessfully" and "works perfectly" as the problem you
> had reported being solved.
>
> Christoph
> --
> cb at df7cb.de | http://www.df7cb.de/
>
> ---------- Forwarded message ----------
> From: PICCORO McKAY Lenz <mckaygerhard at gmail.com>
> To: Debian Bug Tracking System <submit at bugs.debian.org>
> Cc:
> Date: Thu, 9 Aug 2012 17:00:20 -0430
> Subject: postgresql 9.1 cant allow conection: port 5432 are not visible in
> any case
> Package: postgresql-9.1
> Version: 9.1.4-2~bpo60+1
> Severity: important
>
> I have installed the backported version of postgresql,
> but if instaled this release first any user can connect by remote hosts,
> i mean from another computer connections are impossible, the port 5432
> are closed
> even if postgres, firewall and any thing are configured without
> security!!!!
> I put all information here and
> I described how i solved but tthis method are not the right ok:
>
> 1) i installed all components from backports in clean env,
> for postgres at today and sure there's no 8.X component instaled.
> 2) i have setup with trust for all users over local o remote,
> using default port and listen on all address.
>
> I cannot conect, also by scaning ports i can see the postgresql port open..
>
> the firewall are all gone, no firewall rules , no other services using the
> port.
>
> 3)i reinstaled older version 8.4 for squeeze and then i can connect again..
> in this process i also reinstall pgpool from 3 to 1.3
> 4)then back to newer backported included pgpool 3 and slony from testing
> and now port apears by magic!
>
> THIS ITS SERIOUSLY VERY RARE, i think postgresql 8.X let remaining some
> files
> and then postgresql 9.X use and base thems..
>
> sorry for no more information i not have more time for that.. but u must
> see
> if this are in wheeze , due are a important bug that let unusefully
> the DBMS 9.X in next stable!!!!
>
> ------- pg_hba.conf file dump:
> # Database administrative login by Unix domain socket
> local all postgres peer
> # TYPE DATABASE USER ADDRESS METHOD
>
> # "local" is for Unix domain socket connections only
> local all all trust
> # IPv4 local connections:
> host all all trust
>
> ------- line to listen are here:
> listen_addresses = '*' # what IP address(es) to listen on;
> # comma-separated list of
> addresses;
> # defaults to 'localhost', '*' =
> all
> # (change requires restart)
> port = 5432 # (change requires restart)
>
>
> ------- commands showing no ports available if host are used:
>
> root at sysdevel:/var/log# /etc/init.d/postgresql restart
> Restarting PostgreSQL 9.1 database server: main.
> root at sysdevel:/var/log# netstat -nxl | grep PGSQL
> unix 2 [ ACC ] STREAM LISTENING 940787
> /var/run/postgresql/.s.PGSQL.5433
> root at sysdevel:/var/log# nmap 37.10.254.20
>
> Starting Nmap 5.00 ( http://nmap.org ) at 2012-08-09 11:45 VET
> Interesting ports on 37.10.254.20:
> Not shown: 996 closed ports
> PORT STATE SERVICE
> 22/tcp open ssh
> 80/tcp open http
> 111/tcp open rpcbind
> 8080/tcp open http-proxy
>
> Nmap done: 1 IP address (1 host up) scanned in 5.55 seconds
> root at sysdevel:/var/log# ifconfig
> eth0 Link encap:Ethernet HWaddr bc:30:5b:e3:11:48
> inet addr:37.10.254.20 Bcast:37.10.254.255 Mask:255.255.255.0
> inet6 addr: fe80::be30:5bff:fee3:1148/64 Scope:Link
> UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
> RX packets:57963800 errors:0 dropped:0 overruns:0 frame:0
> TX packets:69683382 errors:0 dropped:0 overruns:0 carrier:0
> collisions:0 txqueuelen:1000
> RX bytes:37871383513 (35.2 GiB) TX bytes:84903352963 (79.0 GiB)
> Interrupt:16
>
> -- System Information:
> Debian Release: 6.1
> APT prefers stable-updates
> APT policy: (500, 'stable-updates'), (500, 'stable')
> Architecture: i386 (i686)
>
> Kernel: Linux 3.2.0-0.bpo.2-686-pae (SMP w/4 CPU cores)
> Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
> Shell: /bin/sh linked to /bin/dash
>
> Versions of packages postgresql-9.1 depends on:
> ii libc6 2.11.3-3 Embedded GNU C Library:
> Shared lib
> ii libcomerr2 1.41.12-4stable1 common error description
> library
> ii libgssapi-krb5-2 1.8.3+dfsg-4squeeze6 MIT Kerberos runtime
> libraries - k
> ii libkrb5-3 1.8.3+dfsg-4squeeze6 MIT Kerberos runtime libraries
> ii libldap-2.4-2 2.4.23-7.2 OpenLDAP libraries
> ii libpam0g 1.1.1-6.1+squeeze1 Pluggable Authentication
> Modules l
> ii libpq5 9.1.4-2~bpo60+1 PostgreSQL C client library
> ii libssl0.9.8 0.9.8o-4vnz1 SSL and crypto shared
> libraries
> ii libxml2 2.7.8.dfsg-2+squeeze5 GNOME XML library
> ii locales 2.11.3-3 Embedded GNU C Library:
> National L
> ii postgresql-client- 9.1.4-2~bpo60+1 front-end programs for
> PostgreSQL
> ii postgresql-common 130~bpo60+2 PostgreSQL database-cluster
> manage
> ii ssl-cert 1.0.28 simple debconf wrapper for
> OpenSSL
> ii tzdata 2012c-0squeeze1 time zone and daylight-saving
> time
>
> postgresql-9.1 recommends no packages.
>
> Versions of packages postgresql-9.1 suggests:
> pn locales-all <none> (no description available)
> pn oidentd | ident-server <none> (no description available)
>
>
>
> --
> Lenz McKAY Gerardo (PICCORO)
> http://qglochekone.blogspot.com
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.alioth.debian.org/pipermail/pkg-postgresql-public/attachments/20130502/8f091bce/attachment.html>
More information about the Pkg-postgresql-public
mailing list