Backtrack5的Postpresql的使用
在使用Backtrack5的Postpresql时发现没法正常连接进去,出现如下错误
-----------------------------------------------------------------------------------------------------
msf > db_connect postgres:toor@127.0.0.1/msfbook
[-] Error while running command db_connect: Failed to connect to the database: 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?
-----------------------------------------------------------------------------------------------------
从这里我们看出
db_connect命令
默认去连接
5432接口,而我们可以通过多种方式看到开启的端口其实是
7337
【1】
root@bt:~# ps -ef|grep post
root 3554 1 0 19:50 tty1 00:00:13 gedit /opt/metasploit/postgresql/data/pg_hba.conf
postgres 4980 1 0 21:11 pts/2 00:00:00 /opt/metasploit/postgresql/bin/postgres.bin -D /opt/metasploit/postgresql/data -p 7337
【2】/opt/metasploit/postgresql/data/postgresql.conf文件里有
# CONNECTIONS AND AUTHENTICATION
#------------------------------------------------------------------------------
# - Connection Settings -
listen_addresses = '*'# what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to 'localhost', '*' = all
# (change requires restart)
#port = 7377# (change requires restart)
max_connections = 100# (change requires restart)
【3】/etc/init.d/metasploit-postgres restart
LOG: received smart shutdown request
LOG: autovacuum launcher shutting down
LOG: shutting down
LOG: database system is shut down
/opt/metasploit/postgresql/scripts/ctl.sh : postgresql stopped
LOG: database system was shut down at 2013-03-02 20:45:52 CST
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
/opt/metasploit/postgresql/scripts/ctl.sh : postgresql started at port 7337
------------------------------------------------------------------------------
接着用psql连接去连接发现
root@bt:~# psql
程序“psql”尚未安装。 您可以使用以下命令安装:
-----------------------------------------------------------------------------
然后安装
root@bt:~# apt-get install postgresql-client-common
----------------------------------------------------------------------------
安装完后发现还是有问题
Error: You must install at least one postgresql-client-<version> package.
奇怪了,这个时候去查看安装的依赖包关系
root@bt:~# apt-get install postgresql libpq-dev
下列软件包有未满足的依赖关系:
libpq-dev: 依赖: libpq5 (= 8.4.8-0ubuntu0.10.04) 但是 8.4.12-0ubuntu10.04 正要被安装
被打败了。。。。。果断执行
root@bt:~# sudo apt-get install postgresql-8.4 postgresql-client-8.4
--------------------------------------------------------------------------------
这个时候发现其实已经重装好了postgresql了,版本是8.4
用命令重新启动:/etc/init.d/postgresql-8.4 restart
root@bt:/etc/init.d# sudo su postgres -c psql
psql (8.4.8)
Type "help" for help.
postgres=# ALTER USER postgres WITH PASSWORD 'Test12345';
ALTER ROLE
postgres-# \q
could not save history to file "/home/postgres/.psql_history": No such file or directory
root@bt:/etc/init.d# sudo passwd -d postgres
passwd: password expiry information changed.
root@bt:/etc/init.d# sudo su postgres -c passwd
Enter new UNIX password:
Retype new UNIX password:
passwd: password updated successfully
----------------------------------------------------------------------------------------------------------
root@bt:/etc/init.d# update-alternatives --config ruby
There are 2 choices for the alternative ruby (providing /usr/bin/ruby).
Selection Path Priority Status
------------------------------------------------------------
0 /usr/bin/ruby1.8 500 auto mode
1 /usr/bin/ruby1.8 500 manual mode
* 2 /usr/bin/ruby1.9.2 400 manual mode
Press enter to keep the current choice[*], or type selection number: 0
update-alternatives: using /usr/bin/ruby1.8 to provide /usr/bin/ruby (ruby) in auto mode.
root@bt:/etc/init.d# gem install pg
Building native extensions. This could take a while...
Successfully installed pg-0.11.0
1 gem installed
Installing ri documentation for pg-0.11.0...
Installing RDoc documentation for pg-0.11.0...
-----------------------------------------------------------
最后一步,连接注意是
msf > db_connect postgres:"test12345"@127.0.0.1/postgres
相关推荐
1.2 BACKTRACK5汉化 5 1.3 系统启动自动进入图形界面 6 1.4 安装中文输入法SCIM 6 1.5 设置SCIM支持万能输入法 6 1.6 安装FIREFOX中文版 7 1.7 安装OPENOFFICE 7 1.8 设置OPENOFFICE支持中文输入法 8 1.9 安装虚拟机...
BackTrack5 BackTrack5 BackTrack5 BackTrack5 BackTrack5 BackTrack5 BackTrack5 BackTrack5 BackTrack5
backtrack5破解无线网络。详细的教程资料
BackTrack5(BT5)汉化
2.3 BackTrack5设置启动自动进入图形界面 5 2.4 安装中文输入法SCIM 5 2.5 设置SCIM支持万能输入法 5 2.6 安装Firefox中文版 6 2.7 安装OpenOffice 6 2.8 设置OpenOffice支持中文输入法 7 2.9 安装虚拟机工具...
BackTrack5(BT5)硬盘安装。教你如何安装BT5
BackTrack5 BT5 Web 测试 教程,全书131P,采用BT5为平台,展开各种BT5工具使用的教学。
《BackTrack 5 Cookbook中文版——渗透测试实用技巧荟萃》分为10章,以示例方式讲解了BackTack中很多流行工具的使用方法,其内容涵盖了BackTrack的安装和配置、BackTrack的调整、信息采集、漏洞识别、漏洞利用、提...
backtrack5从入门到精通
BackTrack5+中文指南【最新版】 需要的同学赶快下了
绝对最完整的BackTrack5 中文指南 官方的中文文档.约 63M,总共138页。
BackTrack5 中文指南.zip
BackTrack5中文指南.pdf
著名的backtrack5发布了,这里包括32位和64位以及虚拟机和arm架构的bt5
BT5R3-GNOME-64.torrent (md5: 8cd98b693ce542b671edecaed48ab06d) BT5R3-GNOME-32.torrent (md5: aafff8ff5b71fdb6fccdded49a6541a0) BT5R3-KDE-64.torrent (md5: 981b897b7fdf34fb1431ba84fe93249f) BT5R3-KDE-32....
Backtrack 5 R1 最新发布!
backtrack5是什么就不多做介绍了,实乃黑客和网络渗透测试师必备武器。这是目前最新最全的中文指南,加入了各种工具的使用说明,绝对超值!
虚拟机下安装BackTrack5 (BT5)教程