---

Subject:	RE: Zenoss 4.2.5 Database issue
Author:	Pheripheral Pheripheral
Posted:	2021-01-22 09:51

​Hi,

I'm pretty sure i've seen this error in amougst the various errors i've seen with corrupted event databases.

I've got a pair of scripts that totally removes then rebuilds the event database if you want to give them a try...

Main script, save this with whatever name you fancy in a top level dir called /fixme/ (or edit script to work in whatever location you want)

#!/bin/sh
set -x #echo on

# STOP ZENOSS
sudo -i -u zenoss zenoss stop

# TRY AND REMOVE ZENOSS_ZEP
# MAY WELL FAIL AS THIS SCRIPT IS TO BE USED WHEN ZENOSS_ZEP CORRUPTED
mysql -u root << DROPZEPSQL
show databases;
drop database zenoss_zep;
\! echo "zenoss_zep drop run"
show databases;
DROPZEPSQL

# STOP MYSQL
service mysql stop

# EMPTY AND REMOVE ZENOSS_ZEP DIRECTORY ENTIRELY
rm /var/lib/mysql/zenoss_zep/*.*
rmdir /var/lib/mysql/zenoss_zep/

# START MYSQL
service mysql start

# DROP ZENOSS_ZEP IF IT STILL EXISTS
mysql -u root << DROPZEPSQL
show databases;
drop database zenoss_zep;
\! echo "zenoss_zep drop run"
show databases;
DROPZEPSQL

# FORCE CREATE ZENOSS_ZEP - Often fails after full remove
sudo -i -u zenoss /fixme/create_zepdb.sh

# STOP MYSQL
service mysql stop

# EMPTY POSSIBLE PARTIALLY CREATED ZENOSS_ZEP DIRECTORY
rm /var/lib/mysql/zenoss_zep/*.*

# START MYSQL
service mysql start

# FORCE CREATE ZENOSS_ZEP
sudo -i -u zenoss /fixme/create_zepdb.sh

# START ZENOSS
sudo -i -u zenoss zenoss start​

Secondary script (called via sudo as zenoss user from main script) - save this as create_zepdb.sh in the same /fixme/ directory

#/bin/sh
set -x #echo on

zengc=/opt/zenoss/bin/zenglobalconf

# read configuration from global.conf
dbtype=$(${zengc} -p zodb-db-type)
host=$(${zengc} -p zodb-host)
port=$(${zengc} -p zodb-port)
user=$(${zengc} -p zodb-user)
userpass=$(${zengc} -p zodb-password)
admin=$(${zengc} -p zodb-admin-user)
adminpass=$(${zengc} -p zodb-admin-password)
dbname=$(${zengc} -p zodb-db)

# Drop and recreate the ZEP event database
zeneventserver-create-db --dbtype $dbtype --dbhost $host --dbport $port --dbadminuser $admin --dbadminpass "${adminpass}" --dbuser $user --dbpass "${userpass}" --force
​

Run the main script as root and it should drop the event database, remove the directories and recreate.
It does the recreate twice as during tests I saw it fail under some circumstances on the first go. This one seems to work everytime.

Hope this helps.

Cheers

------------------------------
Pheripheral Pheripheral
------------------------------