700385 – Monitoring fails to connect to postgresql db

Bug 700385 - Monitoring fails to connect to postgresql db

Summary: Monitoring fails to connect to postgresql db

Keywords:
Status:	CLOSED CURRENTRELEASE
Alias:	None
Product:	Spacewalk
Classification:	Community
Component:	Server
Sub Component:
Version:	1.5
Hardware:	Unspecified
OS:	Unspecified
Priority:	medium
Severity:	medium
Target Milestone:	---
Assignee:	Michael Mráka
QA Contact:	Red Hat Satellite QA List
Docs Contact:
URL:
Whiteboard:
Depends On:
Blocks:	space16
TreeView+	depends on / blocked

Reported:	2011-04-28 09:34 UTC by Jiri Kastner
Modified:	2011-12-22 16:49 UTC (History)
CC List:	1 user (show)
Fixed In Version:	spacewalk-schema-1.6.13-1 NPalert-1.126.25-1
Doc Type:	Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed:	2011-12-22 16:49:26 UTC
Embargoed:

Attachments	(Terms of Use)

Description Jiri Kastner 2011-04-28 09:34:37 UTC

Description of problem:
when starting monitoring on spacewalk@postgresql, throws exception, see bellow

Version-Release number of selected component (if applicable):


How reproducible:


Steps to Reproduce:
1. enable monitoring on spacewalk
2. spacewalk-service restart
3. check output
  
Actual results:
Starting Monitoring ...  
2011-04-28 09:12:30 InstallSoftwareConfig: 	!! RHN::Exception: RHN::DB connect('dbname=spaceschema;host=localhost;port=5432','spaceuser',...) failed: could not connect to server: Permission denied
	Is the server running on host "localhost" and accepting
	TCP/IP connections on port 5432?

  RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 228 RHN::Exception::DB::throw
  DBI /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/DBI.pm 636 RHN::DB::handle_error
  DBI /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/DBI.pm 689 DBI::__ANON__
  RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 215 DBI::connect
  RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 180 RHN::DB::direct_connect
  NOCpulse::NOCpulseini /usr/lib/perl5/vendor_perl/5.8.8/NOCpulse/NOCpulseini.pm 45 RHN::DB::connect
  InstallSoftwareConfig /etc/rc.d/np.d/InstallSoftwareConfig.pm 22 NOCpulse::NOCpulseini::connect
  InstallSoftwareConfig /etc/rc.d/np.d/InstallSoftwareConfig.pm 21 (eval)
  SysVStep /etc/rc.d/np.d/SysVStep.pm 287 InstallSoftwareConfig::startActions
  SysVStep /etc/rc.d/np.d/SysVStep.pm 118 SysVStep::startStep
  MacroSysVStep /etc/rc.d/np.d/MacroSysVStep.pm 86 SysVStep::run
  MacroSysVStep /etc/rc.d/np.d/MacroSysVStep.pm 86 (eval)
  Monitoring /etc/rc.d/np.d/Monitoring.pm 51 MacroSysVStep::startModule
  SysVStep /etc/rc.d/np.d/SysVStep.pm 287 Monitoring::startActions
  SysVStep /etc/rc.d/np.d/SysVStep.pm 118 SysVStep::startStep
  MacroSysVStep /etc/rc.d/np.d/MacroSysVStep.pm 30 SysVStep::run
  main /usr/sbin/Monitoring 28 MacroSysVStep::run
  main /usr/sbin/Monitoring 28 (eval)

	Starting InstallSoftwareConfig ...  [ FAIL ]
2011-04-28 09:12:30 InstallSoftwareConfig: WARNING: STARTED BUT *NOT* RUNNING
2011-04-28 09:12:30 InstallSoftwareConfig: ERRORS ENCOUNTERED DURING LAST ACTION:
2011-04-28 09:12:30 InstallSoftwareConfig: 	!! RHN::Exception: RHN::DB connect('dbname=spaceschema;host=localhost;port=5432','spaceuser',...) failed: could not connect to server: Permission denied
	Is the server running on host "localhost" and accepting
	TCP/IP connections on port 5432?

  RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 228 RHN::Exception::DB::throw
  DBI /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/DBI.pm 636 RHN::DB::handle_error
  DBI /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/DBI.pm 689 DBI::__ANON__
  RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 215 DBI::connect
  RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 180 RHN::DB::direct_connect
  NOCpulse::NOCpulseini /usr/lib/perl5/vendor_perl/5.8.8/NOCpulse/NOCpulseini.pm 45 RHN::DB::connect
  InstallSoftwareConfig /etc/rc.d/np.d/InstallSoftwareConfig.pm 22 NOCpulse::NOCpulseini::connect
  InstallSoftwareConfig /etc/rc.d/np.d/InstallSoftwareConfig.pm 21 (eval)
  SysVStep /etc/rc.d/np.d/SysVStep.pm 287 InstallSoftwareConfig::startActions
  SysVStep /etc/rc.d/np.d/SysVStep.pm 118 SysVStep::startStep
  MacroSysVStep /etc/rc.d/np.d/MacroSysVStep.pm 86 SysVStep::run
  MacroSysVStep /etc/rc.d/np.d/MacroSysVStep.pm 86 (eval)
  Monitoring /etc/rc.d/np.d/Monitoring.pm 51 MacroSysVStep::startModule
  SysVStep /etc/rc.d/np.d/SysVStep.pm 287 Monitoring::startActions
  SysVStep /etc/rc.d/np.d/SysVStep.pm 118 SysVStep::startStep
  MacroSysVStep /etc/rc.d/np.d/MacroSysVStep.pm 30 SysVStep::run
  main /usr/sbin/Monitoring 28 MacroSysVStep::run
  main /usr/sbin/Monitoring 28 (eval)

2011-04-28 09:12:30 Monitoring: 	!! Monitoring configuration load failed
2011-04-28 09:12:30 Monitoring: 	!! Monitoring configuration not loaded - not starting MOC functions!
[ FAIL ]
2011-04-28 09:12:30 Monitoring: WARNING: STARTED BUT *NOT* RUNNING
2011-04-28 09:12:30 Monitoring: ERRORS ENCOUNTERED DURING LAST ACTION:
2011-04-28 09:12:30 Monitoring: 	!! Monitoring configuration load failed
2011-04-28 09:12:30 Monitoring: 	!! Monitoring configuration not loaded - not starting MOC functions!
Starting MonitoringScout ...  
2011-04-28 09:12:30 InstallSoftwareConfig: WARNING: STARTED BUT *NOT* RUNNING
2011-04-28 09:12:30 InstallSoftwareConfig: ERRORS ENCOUNTERED DURING LAST ACTION:
2011-04-28 09:12:30 InstallSoftwareConfig: 	!! RHN::Exception: RHN::DB connect('dbname=spaceschema;host=localhost;port=5432','spaceuser',...) failed: could not connect to server: Permission denied
	Is the server running on host "localhost" and accepting
	TCP/IP connections on port 5432?

  RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 228 RHN::Exception::DB::throw
  DBI /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/DBI.pm 636 RHN::DB::handle_error
  DBI /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/DBI.pm 689 DBI::__ANON__
  RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 215 DBI::connect
  RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 180 RHN::DB::direct_connect
  NOCpulse::NOCpulseini /usr/lib/perl5/vendor_perl/5.8.8/NOCpulse/NOCpulseini.pm 45 RHN::DB::connect
  InstallSoftwareConfig /etc/rc.d/np.d/InstallSoftwareConfig.pm 22 NOCpulse::NOCpulseini::connect
  InstallSoftwareConfig /etc/rc.d/np.d/InstallSoftwareConfig.pm 21 (eval)
  SysVStep /etc/rc.d/np.d/SysVStep.pm 287 InstallSoftwareConfig::startActions
  SysVStep /etc/rc.d/np.d/SysVStep.pm 118 SysVStep::startStep
  MacroSysVStep /etc/rc.d/np.d/MacroSysVStep.pm 86 SysVStep::run
  MacroSysVStep /etc/rc.d/np.d/MacroSysVStep.pm 86 (eval)
  Monitoring /etc/rc.d/np.d/Monitoring.pm 51 MacroSysVStep::startModule
  SysVStep /etc/rc.d/np.d/SysVStep.pm 287 Monitoring::startActions
  SysVStep /etc/rc.d/np.d/SysVStep.pm 118 SysVStep::startStep
  MacroSysVStep /etc/rc.d/np.d/MacroSysVStep.pm 30 SysVStep::run
  main /usr/sbin/Monitoring 28 MacroSysVStep::run
  main /usr/sbin/Monitoring 28 (eval)

2011-04-28 09:12:30 MonitoringScout: NOTE: Attempting to start scout without configuration refresh
	Starting NPBootstrap ...  2011-04-28 09:12:30 NPBootstrap: 	!! ERROR FROM SHELL COMMAND: 
2011-04-28 09:12:30 NPBootstrap: 	!! STDOUT: 
2011-04-28 09:12:30 NPBootstrap: 	!! STDERR: Can't call method "get" on an undefined value at /usr/bin/npBootstrap.pl line 15.

2011-04-28 09:12:30 NPBootstrap: 	!! EXIT: 512
[ FAIL ]
2011-04-28 09:12:30 NPBootstrap: WARNING: STARTED BUT *NOT* RUNNING
2011-04-28 09:12:30 NPBootstrap: ERRORS ENCOUNTERED DURING LAST ACTION:
2011-04-28 09:12:30 NPBootstrap: 	!! ERROR FROM SHELL COMMAND: 
2011-04-28 09:12:30 NPBootstrap: 	!! STDOUT: 
2011-04-28 09:12:30 NPBootstrap: 	!! STDERR: Can't call method "get" on an undefined value at /usr/bin/npBootstrap.pl line 15.

2011-04-28 09:12:30 NPBootstrap: 	!! EXIT: 512
	Starting SputLite ...  2011-04-28 09:12:31 SputLite: 	!! ERROR FROM SHELL COMMAND: 
2011-04-28 09:12:31 SputLite: 	!! STDOUT: 
2011-04-28 09:12:31 SputLite: 	!! STDERR: 
2011-04-28 09:12:31 SputLite: 	!! EXIT: 512
[ FAIL ]
2011-04-28 09:12:31 SputLite: WARNING: STARTED BUT *NOT* RUNNING
2011-04-28 09:12:31 SputLite: ERRORS ENCOUNTERED DURING LAST ACTION:
2011-04-28 09:12:31 SputLite: 	!! ERROR FROM SHELL COMMAND: 
2011-04-28 09:12:31 SputLite: 	!! STDOUT: 
2011-04-28 09:12:31 SputLite: 	!! STDERR: 
2011-04-28 09:12:31 SputLite: 	!! EXIT: 512
	Starting Dequeuer ...  2011-04-28 09:12:31 Dequeuer: 	!! ERROR FROM SHELL COMMAND: 
2011-04-28 09:12:31 Dequeuer: 	!! STDOUT: 
2011-04-28 09:12:31 Dequeuer: 	!! STDERR: 
2011-04-28 09:12:31 Dequeuer: 	!! EXIT: 512
[ FAIL ]
2011-04-28 09:12:31 Dequeuer: WARNING: STARTED BUT *NOT* RUNNING
2011-04-28 09:12:31 Dequeuer: ERRORS ENCOUNTERED DURING LAST ACTION:
2011-04-28 09:12:31 Dequeuer: 	!! ERROR FROM SHELL COMMAND: 
2011-04-28 09:12:31 Dequeuer: 	!! STDOUT: 
2011-04-28 09:12:31 Dequeuer: 	!! STDERR: 
2011-04-28 09:12:31 Dequeuer: 	!! EXIT: 512
	Starting Dispatcher ...  2011-04-28 09:12:31 Dispatcher: 	!! ERROR FROM SHELL COMMAND: 
2011-04-28 09:12:31 Dispatcher: 	!! STDOUT: 
2011-04-28 09:12:31 Dispatcher: 	!! STDERR: 
2011-04-28 09:12:31 Dispatcher: 	!! EXIT: 512
[ FAIL ]
2011-04-28 09:12:31 Dispatcher: WARNING: STARTED BUT *NOT* RUNNING
2011-04-28 09:12:31 Dispatcher: ERRORS ENCOUNTERED DURING LAST ACTION:
2011-04-28 09:12:31 Dispatcher: 	!! ERROR FROM SHELL COMMAND: 
2011-04-28 09:12:31 Dispatcher: 	!! STDOUT: 
2011-04-28 09:12:31 Dispatcher: 	!! STDERR: 
2011-04-28 09:12:31 Dispatcher: 	!! EXIT: 512
2011-04-28 09:12:31 MonitoringScout: 	!! Monitoring configuration load failed
[ FAIL ]
2011-04-28 09:12:31 MonitoringScout: WARNING: STARTED BUT *NOT* RUNNING
2011-04-28 09:12:31 MonitoringScout: ERRORS ENCOUNTERED DURING LAST ACTION:
2011-04-28 09:12:31 MonitoringScout: 	!! Monitoring configuration load failed


Expected results:
monitoring will start

Additional info:

Comment 2 Jan Pazdziora 2011-07-20 11:51:51 UTC

Aligning under space16.

Comment 3 Michael Mráka 2011-08-15 09:32:28 UTC

commit 4336cc8cd0f24f8fc9de5cbba905167ca436dfe1
    700385 - use standard ANSI join
commit 6ca0702c701d9f6d91c3960b3226419c460fcffa
    700385 - use current_timestamps instead of sysdate
commit abc1c6506cd5f190bb867d766a1cc795c375382b
    700385 - replaced synonym with original table_name
commit fa84daceb0f70daf6a6d3e524a83384995ef4d59
    700385 - use standard ANSI join
commit 72ee4a4e62558512a56a909efec2a0443cca1633
    700385 - created compatibility views for monitoring
commit e267a9260894a64018c6497015cac827ab60fa69
    700385 - added all_tab_columns compatibility view
commit ade3f2add9ced579ad70d2c9d121632a1a4f508c
    700385 - reuse RHN::DB for db connection in NotificationDB.pm


This series of commits made 'service Monitoring start' work again. This doesn't  mean monitoring works again but it's a good start point ;).

spacewalk-schema-1.6.6-1
NPalert-1.126.25-1

Comment 4 Michael Mráka 2011-09-09 09:47:59 UTC

# service MonitoringScout restart
Stopping MonitoringScout ...  
[ OK ]
Starting MonitoringScout ...  
[ OK ]
# rpm -q spacewalk-schema NPalert
spacewalk-schema-1.6.13-1.el6.noarch
NPalert-1.126.25-1.el6.noarch


Monitoring is know to not work with selinux. Please make sure selinux is in permissive mode before you start poking monitoring.

Comment 5 Milan Zázrivec 2011-12-22 16:49:26 UTC

Spacewalk 1.6 has been released.

Note You need to log in before you can comment on or make changes to this bug.