Bug#724573: postgresql: postgresql init could not create IPv4 socket. permission denied
On Tue, 08 Oct 2013 09:24:57 +0300 John Proios wrote: > Selinux is not active. > > The configuration is the default one. It is a typical installation of > postgres. I think the problem lies in the after deb rules First of all, please don't post five megabyte logs as whole when the interesting part is in the final 100 lines. Seeing that you have an ARM CPU, you wouldn't happen to be running an Android-ish kernel? Particularly one with the option CONFIG_ANDROID_PARANOID_NETWORK set? -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Bug#724573: postgresql: postgresql init could not create IPv4 socket. permission denied
Re: John Proios 2013-10-08 <5253a539.2050...@snigel.gr>
> Tnks Christoph for reply
>
> Selinux is not active.
>
> The configuration is the default one. It is a typical installation of
> postgres. I think the problem lies in the after deb rules
Hi John,
could you try the following, while postgresql is stopped:
sudo -u postgres strace /usr/lib/postgresql/9.1/bin/postgres -D
/etc/postgresql/9.1/main
It should output something like this:
socket(PF_INET6, SOCK_STREAM, IPPROTO_IP) = 3
setsockopt(3, SOL_SOCKET, SO_REUSEADDR, [1], 4) = 0
setsockopt(3, SOL_IPV6, IPV6_V6ONLY, [1], 4) = 0
bind(3, {sa_family=AF_INET6, sin6_port=htons(5432), inet_pton(AF_INET6, "::1",
&sin6_addr), sin6_flowinfo=0, sin6_scope_id=0}, 28) = 0
listen(3, 208) = 0
socket(PF_INET, SOCK_STREAM, IPPROTO_IP) = 4
setsockopt(4, SOL_SOCKET, SO_REUSEADDR, [1], 4) = 0
bind(4, {sa_family=AF_INET, sin_port=htons(5432),
sin_addr=inet_addr("127.0.0.1")}, 16) = 0
listen(4, 208) = 0
If bind() fails, you need to investigate which resource/permission
setting in your kernel is responsible for this.
Christoph
--
c...@df7cb.de | http://www.df7cb.de/
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Bug#724573: postgresql: postgresql init could not create IPv4 socket. permission denied
Tnks Christoph for reply Selinux is not active. The configuration is the default one. It is a typical installation of postgres. I think the problem lies in the after deb rules Sorry for the delay Regard John > Control: tags -1 moreinfo > > Re: John Proios 2013-09-25 > <20130925054914.4143.77423.report...@hit-nxdomain.opendns.com> >> 2013-09-25 08:46:13 EEST LOG: could not create IPv4 socket: permission >> denied >> 2013-09-25 08:46:13 EEST WARNING: could not create listen socket for >> "127.0.0.1" >> 2013-09-25 08:46:13 EEST LOG: could not create IPv4 socket: permission >> denied >> 2013-09-25 08:46:13 EEST WARNING: could not create listen socket for >> "192.168.1.98" > > Hi John, > > is this with SElinux active, or some capabilities removed from root or > the postgres user? "permission denied" for port 5432 is a very unusual > error. Is 5432 what you have in the config? > > Christoph > -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Bug#724573: postgresql: postgresql init could not create IPv4 socket. permission denied
Control: tags -1 moreinfo Re: John Proios 2013-09-25 <20130925054914.4143.77423.report...@hit-nxdomain.opendns.com> > 2013-09-25 08:46:13 EEST LOG: could not create IPv4 socket: permission denied > 2013-09-25 08:46:13 EEST WARNING: could not create listen socket for > "127.0.0.1" > 2013-09-25 08:46:13 EEST LOG: could not create IPv4 socket: permission denied > 2013-09-25 08:46:13 EEST WARNING: could not create listen socket for > "192.168.1.98" Hi John, is this with SElinux active, or some capabilities removed from root or the postgres user? "permission denied" for port 5432 is a very unusual error. Is 5432 what you have in the config? Christoph -- c...@df7cb.de | http://www.df7cb.de/ -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Bug#724573: postgresql: postgresql init could not create IPv4 socket. permission denied
Package: postgresql Version: 9.1+134wheezy3 Severity: normal Dear Maintainer, after install postgresql with apt-get have one error : PostgreSQL 9.1 database server: mainThe PostgreSQL server failed to start. Please check the log output: 2013-09-25 07:30:57 EEST LOG: could not create IPv6 socket: permission denied 2013-09-25 07:30:57 EEST LOG: could not create IPv4 socket: permission denied 2013-09-25 07:30 :57 EEST WARNING: could not create listen socket for "localhost" 2013-09-25 07:30:57 EEST FATAL : could not create any TCP/IP sockets ... failed! run server with debug : /usr/lib/postgresql/9.1/bin/postgres -d 3 --config-file=/etc/postgresql/9.1/main/postgresql.conf have this : 2013-09-25 05:46:11 GMT DEBUG: postgres: PostmasterMain: initial environment dump: 2013-09-25 05:46:11 GMT DEBUG: - 2013-09-25 05:46:11 GMT DEBUG: SHELL=/bin/bash 2013-09-25 05:46:11 GMT DEBUG: TERM=screen 2013-09-25 05:46:11 GMT DEBUG: XDG_SESSION_COOKIE=93b40e375bb1a9f054986b2b04dd-1380085423.923787-851719110 2013-09-25 05:46:11 GMT DEBUG: USER=postgres 2013-09-25 05:46:11 GMT DEBUG: MAIL=/var/mail/postgres 2013-09-25 05:46:11 GMT DEBUG: PATH=/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games 2013-09-25 05:46:11 GMT DEBUG: LC_MESSAGES=el_GR.UTF-8 2013-09-25 05:46:11 GMT DEBUG: PWD=/var/lib/postgresql 2013-09-25 05:46:11 GMT DEBUG: LANG=en_GB.UTF-8 2013-09-25 05:46:11 GMT DEBUG: SHLVL=1 2013-09-25 05:46:11 GMT DEBUG: HOME=/var/lib/postgresql 2013-09-25 05:46:11 GMT DEBUG: LOGNAME=postgres 2013-09-25 05:46:11 GMT DEBUG: _=/usr/lib/postgresql/9.1/bin/postgres 2013-09-25 05:46:11 GMT DEBUG: PGLOCALEDIR=/usr/share/locale 2013-09-25 05:46:11 GMT DEBUG: PGSYSCONFDIR=/etc/postgresql-common 2013-09-25 05:46:11 GMT DEBUG: LC_COLLATE=en_GB.UTF-8 2013-09-25 05:46:11 GMT DEBUG: LC_CTYPE=en_GB.UTF-8 2013-09-25 05:46:11 GMT DEBUG: LC_MONETARY=C 2013-09-25 05:46:11 GMT DEBUG: LC_NUMERIC=C 2013-09-25 05:46:11 GMT DEBUG: LC_TIME=C 2013-09-25 05:46:11 GMT DEBUG: - 2013-09-25 08:46:13 EEST LOG: could not create IPv4 socket: permission denied 2013-09-25 08:46:13 EEST WARNING: could not create listen socket for "127.0.0.1" 2013-09-25 08:46:13 EEST LOG: could not create IPv4 socket: permission denied 2013-09-25 08:46:13 EEST WARNING: could not create listen socket for "192.168.1.98" 2013-09-25 08:46:13 EEST FATAL: could not create any TCP/IP sockets 2013-09-25 08:46:13 EEST DEBUG: shmem_exit(1): 0 callbacks to make 2013-09-25 08:46:13 EEST DEBUG: proc_exit(1): 1 callbacks to make 2013-09-25 08:46:13 EEST DEBUG: exit(1) 2013-09-25 08:46:13 EEST DEBUG: shmem_exit(-1): 0 callbacks to make 2013-09-25 08:46:13 EEST DEBUG: proc_exit(-1): 0 callbacks to make -- System Information: Debian Release: 7.1 APT prefers stable APT policy: (500, 'stable') Architecture: armhf (armv7l) Kernel: Linux 3.3.0+ (SMP w/2 CPU cores; PREEMPT) Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Versions of packages postgresql depends on: ih postgresql-9.1 9.1.9-1 postgresql recommends no packages. postgresql suggests no packages. -- no debconf information -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
