Legacy Discussions

Expand all | Collapse all

Move o Delte all event in Zenoss 4.2.5

  • 1.  Move o Delte all event in Zenoss 4.2.5

    Posted 12-09-2016 07:06 AM

    Hi folks, I have instaled zenoss 4.2.5, I load all devices and I have a lot of events, so, I want to delete all events ( move events to history) and the User interface doesn't work, then, I use a simple script ( python script that use zenoss api) and it doesn't work either. I tray to truncata the table event_summury using myslq but I can't

    Cannot truncate a table referenced in a foreign key constraint (`zenoss_zep`.`event_trigger_signal_spool`, CONSTRAINT `fk_event_summary_uuid` FOREIGN KEY (`event_summary_uuid`) REFERENCES `zenoss_zep`.`event_summary` (`uuid`))

    Any idea what I can do

    Thanks you!



  • 2.  ..

    Posted 12-09-2016 07:26 AM

    .



  • 3.  Make sure you have a full

    Posted 12-13-2016 10:46 AM

    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">mailto:jane.curry@skills-1st.co.uk">jane.curry@skills-1st.co.uk   Web: http://www.skills-1st.co.uk

    ">http://www.skills-1st.co.uk">http://www.skills-1st.co.uk



  • 4.  Hi Jcurry! Thanks a lot for

    Posted 12-14-2016 02:36 PM

    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!



  • 5.  I can't see the mysql status

    Posted 12-14-2016 02:42 PM

    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 ]



  • 6.  Hi�Jcurry

    Posted 12-14-2016 03:08 PM

    HiJcurry

    I can run the command in this way:

    zeneventserver-create-db --dbtype=mysql --dbadminuser=<mysql admin user> --dbadminpass=<mysql admin pass> --force --dbuser=<zenoss db user> --dbpass=<zenoss db pass>

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