You are here

Issues moving Mysql database to a seperate host (OPSview v 3.20130304.0.11642 on Debian Squeeze 32bit)

2 posts / 0 new
Last post
shaun666
shaun666's picture
Issues moving Mysql database to a seperate host (OPSview v 3.20130304.0.11642 on Debian Squeeze 32bit)

Hi,

I've carefully followed the instructions given in http://docs.opsview.com/doku.php?id=opsview4.3:dbs-on-diff-server in an attempt to move our databases to a different host in order to reduce the load on our OPSview server.

There were no errors, but the newly configured OPSview server is not establishing any connections with our new database machine, instead it continues to use the original MySQL databases

opsview.conf look like this:

#
# This file overrides variables from opsview.defaults
# This file will not be overwritten on upgrades
#
$dbpasswd = "xxx";
$odw_dbpasswd = "xxx";
$runtime_dbpasswd = "xxx";

$nrd_shared_password = "xxxxx";

$dbhost = "nagiosdb.ohpen.local";
$odw_dbhost = "nagiosdb.ohpen.local";
$runtime_dbhost = "nagiosdb.ohpen.local";
$reports_dbhost = "nagiosdb.ohpen.local";
$dashboard_dbhost = "nagiosdb.ohpen.local";

The opsview server resolves this name correctly and can reach port 3306

/usr/local/nagios/bin/rc.opsview gen_config Produced: Tue Sep 24 17:15:14 2013 Starting Tue Sep 24 17:15:14 2013 --> Writing config files for Master Monitoring Server Tue Sep 24 17:15:14 2013 Created distributed information Tue Sep 24 17:15:14 2013 Created keyword lookup list for 14 keywords Tue Sep 24 17:15:14 2013 91 commands written to checkcommands.cfg Unlinked OID in IPATM-IPMC-MIB: marsMIB ::= { mib-2 57 } Undefined identifier: mib-2 near line 18 of /usr/share/mibs/ietf/IPATM-IPMC-MIB Undefined OBJECT-GROUP (diffServMIBMultiFieldClfrGroup): At line 2195 in /usr/share/mibs/ietf/IPSEC-SPD-MIB Undefined OBJECT-GROUP (diffServMultiFieldClfrNextFree): At line 2157 in /usr/share/mibs/ietf/IPSEC-SPD-MIB Undefined OBJECT-GROUP (diffServMIBMultiFieldClfrGroup): At line 2062 in /usr/share/mibs/ietf/IPSEC-SPD-MIB Bad operator (INTEGER): At line 73 in /usr/share/mibs/ietf/SNMPv2-PDU Expected "::=" (RFC5644): At line 493 in /usr/share/mibs/iana/IANA-IPPM-METRICS-REGISTRY-MIB Expected "{" (EOF): At line 651 in /usr/share/mibs/iana/IANA-IPPM-METRICS-REGISTRY-MIB Bad object identifier: At line 651 in /usr/share/mibs/iana/IANA-IPPM-METRICS-REGISTRY-MIB Bad parse of OBJECT-IDENTITY: At line 651 in /usr/share/mibs/iana/IANA-IPPM-METRICS-REGISTRY-MIB Tue Sep 24 17:15:19 2013 1192 service definitions written to services.cfg Tue Sep 24 17:15:19 2013 107 hosts written to hosts.cfg Tue Sep 24 17:15:19 2013 11 hostgroups written to hostgroups.cfg Tue Sep 24 17:15:20 2013 45 contacts (29 profiles) written to contacts.cfg Tue Sep 24 17:15:20 2013 45 contacts written to htpasswd.users Tue Sep 24 17:15:20 2013 90 groups written to contactgroups.cfg Tue Sep 24 17:15:20 2013 Written nagios.cfg Tue Sep 24 17:15:20 2013 Written cgi.cfg Tue Sep 24 17:15:20 2013 Written misccommands.cfg Tue Sep 24 17:15:20 2013 Written timeperiods.cfg Tue Sep 24 17:15:20 2013 Written notificationmethodvariables.cfg Tue Sep 24 17:15:20 2013 Written nsca.cfg Tue Sep 24 17:15:20 2013 Written nrd.conf Tue Sep 24 17:15:20 2013 Written send_nrd.cfg Tue Sep 24 17:15:20 2013 Written send_nsca.cfg Tue Sep 24 17:15:20 2013 Written ndo2db.cfg Tue Sep 24 17:15:20 2013 Written ndomod.cfg Tue Sep 24 17:15:20 2013 27 dependencies written to services.cfg /etc/init.d/opsview-web restart

Succeeded

Any advice would be greatly appreciated

Many thanks

Shaun

 

 

 

 

shaun666
shaun666's picture
Re: Issues moving Mysql database to a seperate host (OPSview ...

I've just discovered OPSview Core no longer supports a seperate database.

So I guess this thread is closed.