Postgresql install problem in Kali Linux

[Nieto-]

I try to install postgresql in kali linux in my samsung galaxy tab 2 10.1 and when i try to install with apt-get upgrade i recibe the next message:

root@localhost:~# apt-get upgrade Reading package lists... Done Building dependency tree Reading state information... Done 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 2 not fully installed or removed. After this operation, 0 B of additional disk space will be used. Do you want to continue [Y/n]? y Setting up postgresql-9.1 (9.1.9-1) ... [....] Starting PostgreSQL 9.1 database server: main[....] The PostgreSQL server failed to start. Please check the log output: 2013-04-24 13:33:29 CDT FATAL: co[FAILot access private key file "server.key": Permission denied ... failed! failed! invoke-rc.d: initscript postgresql, action "start" failed. dpkg: error processing postgresql-9.1 (--configure): subprocess installed post-installation script returned error exit status 1 dpkg: dependency problems prevent configuration of postgresql: postgresql depends on postgresql-9.1; however: Package postgresql-9.1 is not configured yet. dpkg: error processing postgresql (--configure): dependency problems - leaving unconfigured Errors were encountered while processing: postgresql-9.1 postgresql E: Sub-process /usr/bin/dpkg returned an error code (1) root@localhost:~

some suggest to correct this probblem?

[meefik]

See issue #13

[Nieto-]

is not working i have the same result

root@localhost:/home/android# usermod -G aid_inet postgres root@localhost:/home/android# apt-get upgrade Reading package lists... Done Building dependency tree Reading state information... Done 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 2 not fully installed or removed. After this operation, 0 B of additional disk space will be used. Do you want to continue [Y/n]? y Setting up postgresql-9.1 (9.1.9-1) ... [....] Starting PostgreSQL 9.1 database server: main[....] The PostgreSQL server failed to start. Please check the log output: 2013-04-24 14:22:13 CDT FATAL: co[FAILot access private key file "server.key": Permission denied ... failed! failed! invoke-rc.d: initscript postgresql, action "start" failed. dpkg: error processing postgresql-9.1 (--configure): subprocess installed post-installation script returned error exit status 1 dpkg: dependency problems prevent configuration of postgresql: postgresql depends on postgresql-9.1; however: Package postgresql-9.1 is not configured yet.

dpkg: error processing postgresql (--configure): dependency problems - leaving unconfigured Errors were encountered while processing: postgresql-9.1 postgresql E: Sub-process /usr/bin/dpkg returned an error code (1) root@localhost:/home/android#

i create acertificate signed for "server.key" but i get the same problem , i was reading the next "---------------------------------------------------------------------- (0000372) muts (administrator) - 2013-04-15 03:57

http://bugs.kali.org/view.php?id=264#c372

This is not bug. Postgresql wont install in a Linux Deploy chroot without first whitelisting it in update-rc.d.

Issue History Date Modified Username Field Change ================================================== ==================== 2013-04-14 11:51 clearday New Issue 2013-04-14 11:51 clearday File Added: attachments.zip 2013-04-15 03:57 muts Note Added: 0000372 2013-04-15 03:57 muts Status new => closed ================================================== ===================="

i try to do update-rc.d postgresql defaults or update-rc.d postgresql enable

but is the same problem i mean, how do i whitelisting it in update-rc.d ????

[freeload101]

I added postgres to all groups :) and just ran it manually

su postgres -c "/usr/lib/postgresql/9.1/bin/postgres -D /etc/postgresql/9.1/main/"

[driabich]

Hi there, I have the same problem... I have tried all methods above, but didn't work (including adding user postgres to all groups). I have noticed, that my directory /etc/postgresql/ is empty... Does anyone know how to fix it? (Running Kali on Android Linux Deploy)

[freelanceontime]

Iv got the same issue as all above have tried aswell haven't been able to come up with a fix but could the cause be dpkg package on root install? Please help

[freeload101]

Well with current linux deploy Kali build i had no issues first command I ran was 'apt-get install metasploit" and postres worked ..

• Linux Deploy 1.4.4
• T-Mobile T759 (Samsung Galaxy S4)
• Gummy-2.1-12-18-13-NIGHTLY-jfltetmo
• http://http.kali.org/kali/dists/kali/Release ( rootfs install armhf )
• Linux localhost 3.4.60-Elite-Kernel-g09f9029 #2 SMP PREEMPT Wed Dec 18 03:45:01 CET 2013 armv7l GNU/Linux

[freelanceontime]

Yeah that's what I expected because that's what it did on vm instalation however on Linux deploy

Error I get

" Skipping metasploit initialisation: postgres not running Update-rc.d: we have no instructions for the metasploit init script. Update-rc.d: it looks like a network service, we disable it. Insserv: warning: current start runlevel(s) (empty) of script 'metasploit' overrides LSB defaults (2 3 4 5). Insserv: warning: current stop runlevel(s) (0 1 2 3 4 5 6) of script 'metasploit' overrides LSB defaults (0 1 6) [FAIL] postgresql must be started before Metasploit... Failed! Invoke-rc.d: Initscript metasploit, action "start" failed. Dpkg: error processing metasploit (--configure): subprocess installed post-installation script returned error exit status 5

So all in all the simplest didn't work should I set up postgres database myself?

[freeload101]

jsut run it via comand line not some rc script ..  I could never get the RC scripts to work right

su postgres -c "/usr/lib/postgresql/9.1/bin/postgres -D /etc/postgresql/9.1/main/" &

     

-----==-=====--==-=====--==-=====--==- Tomorrow’s security today! http://rmccurdy.com -----==-=====--==-=====--==-=====--==-  

On Friday, March 7, 2014 7:10 PM, freelanceontime notifications@github.com wrote:

Yeah that's what I expected because that's what it did on vm instalation however on Linux deploy Error I get " Skipping metasploit initialisation: postgres not running Update-rc.d: we have no instructions for the metasploit init script. Update-rc.d: it looks like a network service, we disable it. Insserv: warning: current start runlevel(s) (empty) of script 'metasploit' overrides LSB defaults (2 3 4 5). Insserv: warning: current stop runlevel(s) (0 1 2 3 4 5 6) of script 'metasploit' overrides LSB defaults (0 1 6) [FAIL] postgresql must be started before Metasploit... Failed! Invoke-rc.d: Initscript metasploit, action "start" failed. Dpkg: error processing metasploit (--configure): subprocess installed post-installation script returned error exit status 5 So all in all the simplest didn't work should I set up postgres database myself? — Reply to this email directly or view it on GitHub.

[medworthy]

I am having a similar problem, I would like to use both metaspoilt and davical on my Nexus 7. I have created a chrooted install of Kali (via Linux Deploy) and after installing metaspoilt, davical and postgres, apt installed a directory called /etc/postgres (but no further directories / files) and when I tried to run /etc/init.d/postgres start the command does not give me any feedback and does not start the service.

[freeload101]

just start it from the command line people .. don't use the init scripts ... get it running first then get the init scripts working see command line above

[medworthy]

Tried that and got "/etc/postgresql/9.1/main" is not a valid data directory tried recreating that directory, after recreating the dir structure -- /etc/postgresql/9.1/main/ I wrote a blank vi file and chowned / chmod the dirs

Now, the initdb is displaying; File "/etc/postgresql/9.1/main/PG_VERSION" does not contain valid data.

I have uninstalled the postgres + extras and reinstalled (purged -- apt-get) . Still having the same problem..

For some reason Kali is not installing the full /etc directory structure, I viewed this with synaptic and don't see any mention of /etc/postgresql/9.1/ in any of the postgresql* packages.

Kali is installing the services (etc/init.d) but not any configuration, I am also using a copy of Webmin on this device.

After trying to configure using Webmin, I released that there was no pg-hba.conf.

So no configuration files, also I had to reactive the postgres user in the passwd.conf (account had no password and was disabled).

[freeload101]

Mmm I did nothing like that ... I did apt-get install metasploit on base kali image armHF and thats it ... on the new image aas of a week ago that is ... I think it even had postgres auto install .. I didnt have to setup anything or install anything   

     

-----==-=====--==-=====--==-=====--==- Tomorrow’s security today! http://rmccurdy.com -----==-=====--==-=====--==-=====--==-  

On Sunday, March 23, 2014 6:35 PM, medworthy notifications@github.com wrote:

Tried that and got "/etc/postgresql/9.1/main" is not a valid data directory tried recreating that directory, after recreating the dir structure -- /etc/postgresql/9.1/main/ I wrote a blank vi file and chowned / chmod the dirs Now, the initdb is displaying; File "/etc/postgresql/9.1/main/PG_VERSION" does not contain valid data. I have uninstalled the postgres + extras and reinstalled (purged -- apt-get) . Still having the same problem.. For some reason Kali is not installing the full /etc directory structure, I viewed this with synaptic and don't see any mention of /etc/postgresql/9.1/ in any of the postgresql* packages. Kali is installing the services (etc/init.d) but not any configuration, I am also using a copy of Webmin on this device. After trying to configure using Webmin, I released that there was no pg-hba.conf. So no configuration files, also I had to reactive the postgres user in the passwd.conf (had no password and was disabled). — Reply to this email directly or view it on GitHub.

[freeload101]

start with base image ARMHF Kali form inside of "linux deploy" apt-get install metasploit

I think thats all I did .. I dont think I even did apt-get update

     

-----==-=====--==-=====--==-=====--==- Tomorrow’s security today! http://rmccurdy.com -----==-=====--==-=====--==-=====--==-  

On , robert mccurdy freeload101@yahoo.com wrote:

Mmm I did nothing like that ... I did apt-get install metasploit on base kali image armHF and thats it ... on the new image aas of a week ago that is ... I think it even had postgres auto install .. I didnt have to setup anything or install anything   

     

-----==-=====--==-=====--==-=====--==- Tomorrow’s security today! http://rmccurdy.com -----==-=====--==-=====--==-=====--==-  

On Sunday, March 23, 2014 6:35 PM, medworthy notifications@github.com wrote:

Tried that and got "/etc/postgresql/9.1/main" is not a valid data directory tried recreating that directory, after recreating the dir structure -- /etc/postgresql/9.1/main/ I wrote a blank vi file and chowned / chmod the dirs Now, the initdb is displaying; File "/etc/postgresql/9.1/main/PG_VERSION" does not contain valid data. I have uninstalled the postgres + extras and reinstalled (purged -- apt-get) . Still having the same problem.. For some reason Kali is not installing the full /etc directory structure, I viewed this with synaptic and don't see any mention of /etc/postgresql/9.1/ in any of the postgresql* packages. Kali is installing the services (etc/init.d) but not any configuration, I am also using a copy of Webmin on this device. After trying to configure using Webmin, I released that there was no pg-hba.conf. So no configuration files, also I had to reactive the postgres user in the passwd.conf (had no password and was disabled). — Reply to this email directly or view it on GitHub.

[medworthy]

Tried that first, but still had no luck (run apt-get install metasploit davical)

[ghost]

^^ That's the point. You're not 'installing' anything, since that version of Metasploit is already installed. Using apt-get update checks to see if there is an update to packages, which there is for Metasploit. Thus, the problem isn't getting the old version to work, but to get the new version installed. To that end, the problem seems to be, according to the log files, that the server can't start because it's not allowed to open a socket.

This might has something to do with it... http://binkybear.wordpress.com/2013/07/18/postgresql-9-1-in-android-chroot/

[galiankabel]

This mine.. lol.. anyone help me?

root@localhost:/sbin# service postgresql start [....] Starting PostgreSQL 9.1 database server: main[....] The PostgreSQL server failed to start. Please check the log output: 2014-09-30 09:03:58 UTC LOG: could not create IPv4 socket: Permission denied 2014-09-30 09:03:58 UTC WARNING: could not create listen socket for "localhost" 2014-09-30 09:03:58 UTC FATAL: cou[FAILt create any TCP/IP sockets ... failed! failed!

[freeload101]

dude just run it by hand dont @#%^ with the stupid startup scripts .. su postgres -c "/usr/lib/postgresql/9.1/bin/postgres -D /etc/postgresql/9.1/main/" &

[newnafis]

please someone help......................... root@ghost:~# su postgres -c "/usr/lib/postgresql/9.1/bin/postgres -D /etc/postgresql/9.1/main/" & [1] 22683 root@ghost:~# 2015-01-17 00:57:07 IST LOG: could not bind IPv4 socket: Cannot assign requested address 2015-01-17 00:57:07 IST HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry. 2015-01-17 00:57:07 IST LOG: could not bind IPv6 socket: Cannot assign requested address 2015-01-17 00:57:07 IST HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry. 2015-01-17 00:57:07 IST WARNING: could not create listen socket for "localhost" 2015-01-17 00:57:07 IST FATAL: could not create any TCP/IP sockets

[twaik]

See https://github.com/meefik/linuxdeploy/issues/942#issuecomment-396513749