Bug 700385
| Summary: | Monitoring fails to connect to postgresql db | ||
|---|---|---|---|
| Product: | [Community] Spacewalk | Reporter: | Jiri Kastner <jkastner> |
| Component: | Server | Assignee: | Michael Mráka <mmraka> |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Red Hat Satellite QA List <satqe-list> |
| Severity: | medium | Docs Contact: | |
| Priority: | medium | ||
| Version: | 1.5 | CC: | cperry |
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | spacewalk-schema-1.6.13-1 NPalert-1.126.25-1 | Doc Type: | Bug Fix |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2011-12-22 16:49:26 UTC | Type: | --- |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
| Bug Depends On: | |||
| Bug Blocks: | 723481 | ||
Aligning under space16. 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
# 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. Spacewalk 1.6 has been released. |
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: