---

Subject:	Make sure you have a full
Author:	Jane Curry
Posted:	2016-12-13 11:46

Make sure you have a full backup first and then, as the zenoss user, try:

zenoss stop

zeneventserver-create-db --dbtype=mysql --force

rm -rf $ZENHOME/var/zeneventserver/* (removes the zep indexes)

zenoss start

This should completely rebuild your zep events database and its indexes. It does NOT move events to history - it really does a rebuild, Caveat emptor!

Cheers,

Jane

Email: jane.curry@skills-1st.co.uk    Web: https://www.skills-1st.co.uk

---

Subject:	Hi Jcurry! Thanks a lot for
Author:	[Not Specified]
Posted:	2016-12-14 15:36

Hi Jcurry! Thanks a lot for you reply, I tryed and I got this:

[zenoss@zenoss4prd ~]$ zeneventserver-create-db --dbtype=mysql --force
Dropping database: zenoss_zep
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

It's Okey if the databases rebuild, I don't care, I just want clean my zenoss event.

You have any suggestion

Thanks you!

---

Subject:	I can't see the mysql status
Author:	[Not Specified]
Posted:	2016-12-14 15:42

I can't see the mysql status service with zenoss user:

[zenoss@zenoss4prd ~]$ service mysql status
/etc/init.d/mysql: line 352: /var/lib/mysql/zenoss4prd.pid: Permission denied
MySQL is not running, but PID file exists [FAILED]

If I loging as root I don't have any problem:

[root@zenoss4prd /]# service mysql status
MySQL running (1943) [ OK ]

---

Subject:	Hi Jcurry
Author:	[Not Specified]
Posted:	2016-12-14 16:08

HiJcurry

I can run the command in this way:

zeneventserver-create-db --dbtype=mysql --dbadminuser= --dbadminpass= --force --dbuser= --dbpass=

Thanks a lot! My databases and zenoss user interfaces work great now! Thanks a lot , I love you!!