Metasploit mailing list archives
postgresql database problems
From: tothakosh at gmail.com (Akos Toth)
Date: Thu, 7 May 2009 19:08:00 +0200
Hi Simen, A while ago I also had some issues getting autopwn to work with Postgres, and I made a log of the install when finally succeded. As this was a long time ago I can't remember how I went about it, but maybe you will find something applicable to your problem in the log. Akos On 5/7/09, Simen Bjelke <s.bjelke at online.no> wrote:
Hi guys, Although this isn't a metasploit specific question it is relevant, and maybe someone else out there might also benefit from the answer. So here we go. Having some issues setting up the postgresql database to use for autopwn option. I did the "gem install [postgresql] -> 1 gem installed", and verified with "ruby -e 'require "rubygems"; require "postgres";'" But initdb command isn't there. I've talked to some of the guys in #postgresql and they blame ruby for this issue. What do you guys think and where should I start? This is on Backtrack 4 - Beta PS: Why are there no people on the silc channel, seems kinda redundant to even promote it on the website when it's not in use. Wouldn't it be better to start an IRC channel on freenode or something. I know some people get chills even when they hear the word IRC, but I do believe it would gather a larger crowd and essentially build a better community around the tool. Regards Simen Bjelke _______________________________________________ https://mail.metasploit.com/mailman/listinfo/framework
-------------- next part -------------- MOUNT NTFS on Fedora 7 mount -t cifs -o username=admin,password=Pcmker98 //192.168.2.100/TEMP /mnt/winstuff UPDATE RUBY, INSTALL RUBYGEMS [root at localhost rubygems-0.9.5]# ruby setup.rb ./lib/rubygems/custom_require.rb:27:in `gem_original_require': no such file to load -- rdoc/rdoc (LoadError) from ./lib/rubygems/custom_require.rb:27:in `require' from setup.rb:23 [root at localhost rubygems-0.9.5]# which ruby /usr/bin/ruby [root at localhost rubygems-0.9.5]# yum update ruby Loading "installonlyn" plugin Setting up Update Process fedora 100% |=========================| 2.1 kB 00:00 primary.sqlite.bz2 100% |=========================| 3.8 MB 00:32 updates 100% |=========================| 2.3 kB 00:00 Resolving Dependencies --> Running transaction check ---> Package ruby.i386 0:1.8.6.111-1.fc7 set to be updated filelists.sqlite.bz2 100% |=========================| 4.4 MB 00:36 --> Processing Dependency: ruby-libs = 1.8.6.111-1.fc7 for package: ruby --> Restarting Dependency Resolution with new changes. --> Running transaction check ---> Package ruby-libs.i386 0:1.8.6.111-1.fc7 set to be updated Dependencies Resolved ============================================================================= Package Arch Version Repository Size ============================================================================= Updating: ruby i386 1.8.6.111-1.fc7 updates 512 k Updating for dependencies: ruby-libs i386 1.8.6.111-1.fc7 updates 1.7 M Transaction Summary ============================================================================= Install 0 Package(s) Update 2 Package(s) Remove 0 Package(s) Total download size: 2.2 M Is this ok [y/N]: y Downloading Packages: (1/2): ruby-libs-1.8.6.11 100% |=========================| 1.7 MB 00:20 (2/2): ruby-1.8.6.111-1.f 100% |=========================| 512 kB 00:05 warning: rpmts_HdrFromFdno: Header V3 DSA signature: NOKEY, key ID 4f2a6fd2 Importing GPG key 0x4F2A6FD2 "Fedora Project <fedora at redhat.com>" from /etc/pki/rpm-gpg/RPM-GPG-KEY-fedora Is this ok [y/N]: y Running Transaction Test Finished Transaction Test Transaction Test Succeeded Running Transaction Updating : ruby-libs ######################### [1/4] Updating : ruby ######################### [2/4] Cleanup : ruby ######################### [3/4] Cleanup : ruby-libs ######################### [4/4] Updated: ruby.i386 0:1.8.6.111-1.fc7 Dependency Updated: ruby-libs.i386 0:1.8.6.111-1.fc7 Complete! [root at localhost rubygems-0.9.5]# ruby setup.rb ./lib/rubygems/custom_require.rb:27:in `gem_original_require': no such file to load -- rdoc/rdoc (LoadError) from ./lib/rubygems/custom_require.rb:27:in `require' from setup.rb:23 [root at localhost rubygems-0.9.5]# yum install rubygems Loading "installonlyn" plugin Setting up Install Process Parsing package install arguments Resolving Dependencies --> Running transaction check ---> Package rubygems.noarch 0:0.9.4-1.fc7 set to be updated --> Processing Dependency: ruby-rdoc for package: rubygems --> Restarting Dependency Resolution with new changes. --> Running transaction check ---> Package ruby-rdoc.i386 0:1.8.6.111-1.fc7 set to be updated --> Processing Dependency: ruby-irb = 1.8.6.111-1.fc7 for package: ruby-rdoc --> Restarting Dependency Resolution with new changes. --> Running transaction check ---> Package ruby-irb.i386 0:1.8.6.111-1.fc7 set to be updated Dependencies Resolved ============================================================================= Package Arch Version Repository Size ============================================================================= Installing: rubygems noarch 0.9.4-1.fc7 updates 498 k Installing for dependencies: ruby-irb i386 1.8.6.111-1.fc7 updates 70 k ruby-rdoc i386 1.8.6.111-1.fc7 updates 135 k Transaction Summary ============================================================================= Install 3 Package(s) Update 0 Package(s) Remove 0 Package(s) Total download size: 702 k Is this ok [y/N]: y Downloading Packages: (1/3): ruby-rdoc-1.8.6.11 100% |=========================| 135 kB 00:01 (2/3): rubygems-0.9.4-1.f 100% |=========================| 498 kB 00:03 (3/3): ruby-irb-1.8.6.111 100% |=========================| 70 kB 00:00 Running Transaction Test Finished Transaction Test Transaction Test Succeeded Running Transaction Installing: ruby-irb ######################### [1/3] Installing: ruby-rdoc ######################### [2/3] Installing: rubygems ######################### [3/3] Installed: rubygems.noarch 0:0.9.4-1.fc7 Dependency Installed: ruby-irb.i386 0:1.8.6.111-1.fc7 ruby-rdoc.i386 0:1.8.6.111-1.fc7 Complete! [root at localhost rubygems-0.9.5]# INSTALL ACTIVERECORD [root at localhost rubygems-0.9.5]# gem install activerecord Bulk updating Gem source index for: http://gems.rubyforge.org ERROR: While executing gem ... (Gem::GemNotFoundException) Could not find activerecord (> 0) in any repository [root at localhost rubygems-0.9.5]# ruby setup.rb install -c -m 0644 ubygems.rb /usr/lib/ruby/site_ruby/1.8/ubygems.rb install -c -m 0644 rbconfig/datadir.rb /usr/lib/ruby/site_ruby/1.8/rbconfig/datadir.rb install -c -m 0644 rubygems.rb /usr/lib/ruby/site_ruby/1.8/rubygems.rb install -c -m 0644 rubygems/install_update_options.rb /usr/lib/ruby/site_ruby/1.8/rubygems/install_update_options.rb install -c -m 0644 rubygems/gem_runner.rb /usr/lib/ruby/site_ruby/1.8/rubygems/gem_runner.rb install -c -m 0644 rubygems/remote_installer.rb /usr/lib/ruby/site_ruby/1.8/rubygems/remote_installer.rb install -c -m 0644 rubygems/rubygems_version.rb /usr/lib/ruby/site_ruby/1.8/rubygems/rubygems_version.rb install -c -m 0644 rubygems/digest/sha2.rb /usr/lib/ruby/site_ruby/1.8/rubygems/digest/sha2.rb install -c -m 0644 rubygems/digest/digest_adapter.rb /usr/lib/ruby/site_ruby/1.8/rubygems/digest/digest_adapter.rb install -c -m 0644 rubygems/digest/sha1.rb /usr/lib/ruby/site_ruby/1.8/rubygems/digest/sha1.rb install -c -m 0644 rubygems/digest/md5.rb /usr/lib/ruby/site_ruby/1.8/rubygems/digest/md5.rb install -c -m 0644 rubygems/remote_fetcher.rb /usr/lib/ruby/site_ruby/1.8/rubygems/remote_fetcher.rb install -c -m 0644 rubygems/local_remote_options.rb /usr/lib/ruby/site_ruby/1.8/rubygems/local_remote_options.rb install -c -m 0644 rubygems/indexer.rb /usr/lib/ruby/site_ruby/1.8/rubygems/indexer.rb install -c -m 0644 rubygems/open-uri.rb /usr/lib/ruby/site_ruby/1.8/rubygems/open-uri.rb mkdir -p /usr/lib/ruby/site_ruby/1.8/rubygems/ext install -c -m 0644 rubygems/ext/configure_builder.rb /usr/lib/ruby/site_ruby/1.8/rubygems/ext/configure_builder.rb install -c -m 0644 rubygems/ext/ext_conf_builder.rb /usr/lib/ruby/site_ruby/1.8/rubygems/ext/ext_conf_builder.rb install -c -m 0644 rubygems/ext/rake_builder.rb /usr/lib/ruby/site_ruby/1.8/rubygems/ext/rake_builder.rb install -c -m 0644 rubygems/ext/builder.rb /usr/lib/ruby/site_ruby/1.8/rubygems/ext/builder.rb install -c -m 0644 rubygems/doc_manager.rb /usr/lib/ruby/site_ruby/1.8/rubygems/doc_manager.rb install -c -m 0644 rubygems/installer.rb /usr/lib/ruby/site_ruby/1.8/rubygems/installer.rb install -c -m 0644 rubygems/ext.rb /usr/lib/ruby/site_ruby/1.8/rubygems/ext.rb install -c -m 0644 rubygems/config_file.rb /usr/lib/ruby/site_ruby/1.8/rubygems/config_file.rb install -c -m 0644 rubygems/validator.rb /usr/lib/ruby/site_ruby/1.8/rubygems/validator.rb install -c -m 0644 rubygems/gem_open_uri.rb /usr/lib/ruby/site_ruby/1.8/rubygems/gem_open_uri.rb install -c -m 0644 rubygems/custom_require.rb /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb install -c -m 0644 rubygems/package.rb /usr/lib/ruby/site_ruby/1.8/rubygems/package.rb install -c -m 0644 rubygems/platform.rb /usr/lib/ruby/site_ruby/1.8/rubygems/platform.rb install -c -m 0644 rubygems/specification.rb /usr/lib/ruby/site_ruby/1.8/rubygems/specification.rb install -c -m 0644 rubygems/server.rb /usr/lib/ruby/site_ruby/1.8/rubygems/server.rb install -c -m 0644 rubygems/requirement.rb /usr/lib/ruby/site_ruby/1.8/rubygems/requirement.rb install -c -m 0644 rubygems/dependency_list.rb /usr/lib/ruby/site_ruby/1.8/rubygems/dependency_list.rb install -c -m 0644 rubygems/format.rb /usr/lib/ruby/site_ruby/1.8/rubygems/format.rb install -c -m 0644 rubygems/gem_openssl.rb /usr/lib/ruby/site_ruby/1.8/rubygems/gem_openssl.rb install -c -m 0644 rubygems/command.rb /usr/lib/ruby/site_ruby/1.8/rubygems/command.rb install -c -m 0644 rubygems/security.rb /usr/lib/ruby/site_ruby/1.8/rubygems/security.rb install -c -m 0644 rubygems/dependency.rb /usr/lib/ruby/site_ruby/1.8/rubygems/dependency.rb install -c -m 0644 rubygems/version.rb /usr/lib/ruby/site_ruby/1.8/rubygems/version.rb install -c -m 0644 rubygems/source_index.rb /usr/lib/ruby/site_ruby/1.8/rubygems/source_index.rb install -c -m 0644 rubygems/old_format.rb /usr/lib/ruby/site_ruby/1.8/rubygems/old_format.rb install -c -m 0644 rubygems/commands/cert_command.rb /usr/lib/ruby/site_ruby/1.8/rubygems/commands/cert_command.rb install -c -m 0644 rubygems/commands/specification_command.rb /usr/lib/ruby/site_ruby/1.8/rubygems/commands/specification_command.rb install -c -m 0644 rubygems/commands/outdated_command.rb /usr/lib/ruby/site_ruby/1.8/rubygems/commands/outdated_command.rb install -c -m 0644 rubygems/commands/contents_command.rb /usr/lib/ruby/site_ruby/1.8/rubygems/commands/contents_command.rb install -c -m 0644 rubygems/commands/fetch_command.rb /usr/lib/ruby/site_ruby/1.8/rubygems/commands/fetch_command.rb install -c -m 0644 rubygems/commands/check_command.rb /usr/lib/ruby/site_ruby/1.8/rubygems/commands/check_command.rb install -c -m 0644 rubygems/commands/server_command.rb /usr/lib/ruby/site_ruby/1.8/rubygems/commands/server_command.rb install -c -m 0644 rubygems/commands/cleanup_command.rb /usr/lib/ruby/site_ruby/1.8/rubygems/commands/cleanup_command.rb install -c -m 0644 rubygems/commands/install_command.rb /usr/lib/ruby/site_ruby/1.8/rubygems/commands/install_command.rb install -c -m 0644 rubygems/commands/generate_index_command.rb /usr/lib/ruby/site_ruby/1.8/rubygems/commands/generate_index_command.rb install -c -m 0644 rubygems/commands/list_command.rb /usr/lib/ruby/site_ruby/1.8/rubygems/commands/list_command.rb install -c -m 0644 rubygems/commands/mirror_command.rb /usr/lib/ruby/site_ruby/1.8/rubygems/commands/mirror_command.rb install -c -m 0644 rubygems/commands/pristine_command.rb /usr/lib/ruby/site_ruby/1.8/rubygems/commands/pristine_command.rb install -c -m 0644 rubygems/commands/environment_command.rb /usr/lib/ruby/site_ruby/1.8/rubygems/commands/environment_command.rb install -c -m 0644 rubygems/commands/unpack_command.rb /usr/lib/ruby/site_ruby/1.8/rubygems/commands/unpack_command.rb install -c -m 0644 rubygems/commands/sources_command.rb /usr/lib/ruby/site_ruby/1.8/rubygems/commands/sources_command.rb install -c -m 0644 rubygems/commands/dependency_command.rb /usr/lib/ruby/site_ruby/1.8/rubygems/commands/dependency_command.rb install -c -m 0644 rubygems/commands/which_command.rb /usr/lib/ruby/site_ruby/1.8/rubygems/commands/which_command.rb install -c -m 0644 rubygems/commands/query_command.rb /usr/lib/ruby/site_ruby/1.8/rubygems/commands/query_command.rb install -c -m 0644 rubygems/commands/uninstall_command.rb /usr/lib/ruby/site_ruby/1.8/rubygems/commands/uninstall_command.rb install -c -m 0644 rubygems/commands/update_command.rb /usr/lib/ruby/site_ruby/1.8/rubygems/commands/update_command.rb install -c -m 0644 rubygems/commands/build_command.rb /usr/lib/ruby/site_ruby/1.8/rubygems/commands/build_command.rb install -c -m 0644 rubygems/commands/rdoc_command.rb /usr/lib/ruby/site_ruby/1.8/rubygems/commands/rdoc_command.rb install -c -m 0644 rubygems/commands/help_command.rb /usr/lib/ruby/site_ruby/1.8/rubygems/commands/help_command.rb install -c -m 0644 rubygems/commands/lock_command.rb /usr/lib/ruby/site_ruby/1.8/rubygems/commands/lock_command.rb install -c -m 0644 rubygems/commands/search_command.rb /usr/lib/ruby/site_ruby/1.8/rubygems/commands/search_command.rb mkdir -p /usr/lib/ruby/site_ruby/1.8/rubygems/indexer install -c -m 0644 rubygems/indexer/marshal_index_builder.rb /usr/lib/ruby/site_ruby/1.8/rubygems/indexer/marshal_index_builder.rb install -c -m 0644 rubygems/indexer/quick_index_builder.rb /usr/lib/ruby/site_ruby/1.8/rubygems/indexer/quick_index_builder.rb install -c -m 0644 rubygems/indexer/abstract_index_builder.rb /usr/lib/ruby/site_ruby/1.8/rubygems/indexer/abstract_index_builder.rb install -c -m 0644 rubygems/indexer/master_index_builder.rb /usr/lib/ruby/site_ruby/1.8/rubygems/indexer/master_index_builder.rb install -c -m 0644 rubygems/timer.rb /usr/lib/ruby/site_ruby/1.8/rubygems/timer.rb install -c -m 0644 rubygems/command_manager.rb /usr/lib/ruby/site_ruby/1.8/rubygems/command_manager.rb install -c -m 0644 rubygems/uninstaller.rb /usr/lib/ruby/site_ruby/1.8/rubygems/uninstaller.rb install -c -m 0644 rubygems/dependency_installer.rb /usr/lib/ruby/site_ruby/1.8/rubygems/dependency_installer.rb install -c -m 0644 rubygems/version_option.rb /usr/lib/ruby/site_ruby/1.8/rubygems/version_option.rb install -c -m 0644 rubygems/gem_path_searcher.rb /usr/lib/ruby/site_ruby/1.8/rubygems/gem_path_searcher.rb install -c -m 0644 rubygems/exceptions.rb /usr/lib/ruby/site_ruby/1.8/rubygems/exceptions.rb install -c -m 0644 rubygems/source_info_cache.rb /usr/lib/ruby/site_ruby/1.8/rubygems/source_info_cache.rb install -c -m 0644 rubygems/user_interaction.rb /usr/lib/ruby/site_ruby/1.8/rubygems/user_interaction.rb install -c -m 0644 rubygems/source_info_cache_entry.rb /usr/lib/ruby/site_ruby/1.8/rubygems/source_info_cache_entry.rb install -c -m 0644 rubygems/builder.rb /usr/lib/ruby/site_ruby/1.8/rubygems/builder.rb cp gem /tmp/gem install -c -m 0755 /tmp/gem /usr/bin/gem rm /tmp/gem cp update_rubygems /tmp/update_rubygems install -c -m 0755 /tmp/update_rubygems /usr/bin/update_rubygems rm /tmp/update_rubygems rm /usr/lib/ruby/gems/1.8/source_cache Removing old RubyGems RDoc and ri... rm -rf /usr/lib/ruby/gems/1.8/doc/rubygems-0.9.4 Installing rubygems-0.9.5 ri into /usr/lib/ruby/gems/1.8/doc/rubygems-0.9.5/ri... Installing rubygems-0.9.5 rdoc into /usr/lib/ruby/gems/1.8/doc/rubygems-0.9.5/rdoc... As of RubyGems 0.8.0, library stubs are no longer needed. Searching $LOAD_PATH for stubs to optionally delete (may take a while)... ...done. No library stubs found. [root at localhost rubygems-0.9.5]# gem install activerecord Bulk updating Gem source index for: http://gems.rubyforge.org Successfully installed activesupport-1.4.4 Successfully installed activerecord-1.15.6 2 gems installed Installing ri documentation for activesupport-1.4.4... Installing ri documentation for activerecord-1.15.6... Installing RDoc documentation for activesupport-1.4.4... Installing RDoc documentation for activerecord-1.15.6... [root at localhost rubygems-0.9.5]# UPDATE POSTGRESQL [root at localhost rubygems-0.9.5]# gem install postgres Building native extensions. This could take a while... ERROR: Error installing postgres: ERROR: Failed to build gem native extension. /usr/bin/ruby extconf.rb install postgres can't find header files for ruby. Gem files will remain installed in /usr/lib/ruby/gems/1.8/gems/postgres-0.7.1 for inspection. Results logged to /usr/lib/ruby/gems/1.8/gems/postgres-0.7.1/gem_make.out [root at localhost rubygems-0.9.5]# yum install pqsql Loading "installonlyn" plugin Setting up Install Process Parsing package install arguments Nothing to do [root at localhost rubygems-0.9.5]# which pgsql /usr/bin/which: no pgsql in (/usr/lib/qt-3.3/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/lib/ccache:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/root/bin) [root at localhost rubygems-0.9.5]# yum install postgres Loading "installonlyn" plugin Setting up Install Process Parsing package install arguments Nothing to do [root at localhost rubygems-0.9.5]# yum install postgresql Loading "installonlyn" plugin Setting up Install Process Parsing package install arguments Resolving Dependencies --> Running transaction check ---> Package postgresql.i386 0:8.2.5-1.fc7 set to be updated --> Processing Dependency: postgresql = 8.2.3-2.fc7 for package: postgresql-server --> Restarting Dependency Resolution with new changes. --> Running transaction check ---> Package postgresql-server.i386 0:8.2.5-1.fc7 set to be updated Dependencies Resolved ============================================================================= Package Arch Version Repository Size ============================================================================= Updating: postgresql i386 8.2.5-1.fc7 updates 3.0 M Updating for dependencies: postgresql-server i386 8.2.5-1.fc7 updates 4.0 M Transaction Summary ============================================================================= Install 0 Package(s) Update 2 Package(s) Remove 0 Package(s) Total download size: 7.0 M Is this ok [y/N]: y Downloading Packages: (1/2): postgresql-server- 100% |=========================| 4.0 MB 00:33 (2/2): postgresql-8.2.5-1 100% |=========================| 3.0 MB 00:24 Running Transaction Test Finished Transaction Test Transaction Test Succeeded Running Transaction Updating : postgresql ######################### [1/4] Updating : postgresql-server ######################### [2/4] Cleanup : postgresql ######################### [3/4] Cleanup : postgresql-server ######################### [4/4] Updated: postgresql.i386 0:8.2.5-1.fc7 Dependency Updated: postgresql-server.i386 0:8.2.5-1.fc7 Complete! [root at localhost rubygems-0.9.5]# gem install postgres Updating metadata for 5 gems from http://gems.rubyforge.org .... complete Building native extensions. This could take a while... ERROR: Error installing postgres: ERROR: Failed to build gem native extension. /usr/bin/ruby extconf.rb install postgres can't find header files for ruby. Gem files will remain installed in /usr/lib/ruby/gems/1.8/gems/postgres-0.7.1 for inspection. Results logged to /usr/lib/ruby/gems/1.8/gems/postgres-0.7.1/gem_make.out [root at localhost rubygems-0.9.5]# INSTALL RUBY-DEVEL [root at localhost rubygems-0.9.5]# gem install postgres --install-dir /usr/lib/ruby/1.8 Building native extensions. This could take a while... ERROR: Error installing postgres: ERROR: Failed to build gem native extension. /usr/bin/ruby extconf.rb install postgres --install-dir /usr/lib/ruby/1.8 can't find header files for ruby. Gem files will remain installed in /usr/lib/ruby/1.8/gems/postgres-0.7.1 for inspection. Results logged to /usr/lib/ruby/1.8/gems/postgres-0.7.1/gem_make.out [root at localhost rubygems-0.9.5]# gem install postgres --with-ruby-lib-dir=/usr/lib/ruby/1.8 ERROR: While executing gem ... (OptionParser::InvalidOption) invalid option: --with-ruby-lib-dir=/usr/lib/ruby/1.8 [root at localhost rubygems-0.9.5]# gem install postgres --with-pgsql-lib-dir=/usr/lib/pgsql ERROR: While executing gem ... (OptionParser::InvalidOption) invalid option: --with-pgsql-lib-dir=/usr/lib/pgsql [root at localhost rubygems-0.9.5]# yum install ruby-devel Loading "installonlyn" plugin Setting up Install Process Parsing package install arguments fedora 100% |=========================| 2.1 kB 00:00 updates 100% |=========================| 2.3 kB 00:00 Resolving Dependencies --> Running transaction check ---> Package ruby-devel.i386 0:1.8.6.111-1.fc7 set to be updated Dependencies Resolved ============================================================================= Package Arch Version Repository Size ============================================================================= Installing: ruby-devel i386 1.8.6.111-1.fc7 updates 563 k Transaction Summary ============================================================================= Install 1 Package(s) Update 0 Package(s) Remove 0 Package(s) Total download size: 563 k Is this ok [y/N]: y Downloading Packages: (1/1): ruby-devel-1.8.6.1 100% |=========================| 563 kB 00:04 Running Transaction Test Finished Transaction Test Transaction Test Succeeded Running Transaction Installing: ruby-devel ######################### [1/1] Installed: ruby-devel.i386 0:1.8.6.111-1.fc7 Complete! [root at localhost rubygems-0.9.5]# gem install postgres Building native extensions. This could take a while... ERROR: Error installing postgres: ERROR: Failed to build gem native extension. /usr/bin/ruby extconf.rb install postgres checking for cygwin32_socket() in -lwsock32... no checking for socket() in -lsocket... no checking for gethostbyname() in -linet... no checking for gethostbyname() in -lnsl... yes checking for sys/un.h... yes checking for socket()... yes checking for hsterror()... no checking for gethostname()... yes checking for PQsetdbLogin() in -lpq... no *** extconf.rb failed *** Could not create Makefile due to some reason, probably lack of necessary libraries and/or headers. Check the mkmf.log file for more details. You may need configuration options. Provided configuration options: --with-opt-dir --without-opt-dir --with-opt-include --without-opt-include=${opt-dir}/include --with-opt-lib --without-opt-lib=${opt-dir}/lib --with-make-prog --without-make-prog --srcdir=. --curdir --ruby=/usr/bin/ruby --with-pgsql-dir --without-pgsql-dir --with-pgsql-include --without-pgsql-include=${pgsql-dir}/include --with-pgsql-lib --without-pgsql-lib=${pgsql-dir}/lib --with-wsock32lib --without-wsock32lib --with-socketlib --without-socketlib --with-inetlib --without-inetlib --with-nsllib --without-nsllib --with-pgsql-include-dir --without-pgsql-include-dir --with-pgsql-lib-dir --without-pgsql-lib-dir --with-pqlib --without-pqlib Could not find PostgreSQL libraries: Makefile not created Gem files will remain installed in /usr/lib/ruby/gems/1.8/gems/postgres-0.7.1 for inspection. Results logged to /usr/lib/ruby/gems/1.8/gems/postgres-0.7.1/gem_make.out [root at localhost rubygems-0.9.5]# POSTGRESQL INSTALL (FROM SOURCE) (header files would be needed for installing ruby postgres plugin, but there's no) -downloaded from Posgres website -executed the following commands: ./configure gmake su gmake install adduser postgres mkdir /usr/local/pgsql/data chown postgres /usr/local/pgsql/data su - postgres /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data >logfile 2>&1 & /usr/local/pgsql/bin/createdb t RUBY PLUGIN FOR POSTGRES INSTALL [root at localhost rubygems-0.9.5]# gem install postgres -- --with-pgsql-include-dir=/usr/local/pgsql/include --with-pgsql-lib-dir=/usr/local/pgsql/lib Updating metadata for 8 gems from http://gems.rubyforge.org ........ complete Building native extensions. This could take a while... Successfully installed postgres-0.7.1 1 gem installed [root at localhost rubygems-0.9.5]# ADD ROOT USER TO POSTGRES -bash-3.2$ createuser root Shall the new role be a superuser? (y/n) y CREATE ROLE START METASPLOITDB DATABASE [root at localhost ~]# su - postgres -bash-3.2$ pg_ctl -D metasploitdb start server starting MAKE SURE THAT NMAP IS INSTALLED !!!!!!!!!!!! (otherwise db_create will run, but db_nmap will produce no output and will not run SETUP POSTGRES DATABASE REMOTE ACCESS(ON PORT 5432) /var/lib/pgsql/metasploitdb - here are the configuration files pg_hba.conf - you can set the which addresses postgres will accept connections from postgresql.conf - you have to uncomment two lines : 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) and restart the server : pg_ctl -D metasploitdb stop pg_ctl -D metasploitdb start INSTALL RUBY-TCLTK (without screwing up dependencies and metasploit) yum install ruby-tcltk you musn't compile tcltk from source, because then you have to recompile ruby and that screws up ruby postgres plugin which will make Metasploit not to work. !!!!
Current thread:
- postgresql database problems Simen Bjelke (May 07)
- postgresql database problems H D Moore (May 07)
- postgresql database problems Akos Toth (May 07)