The cause of the OperationalError: (1449, "There is no 'zenoss'@'localhost' registered") and ERROR 1227 (42000): Access denied; you need the SUPER privilege for this operation error messages is how the mysql trigger status_delete is created.
It is created with [EMAIL PROTECTED], which is why I'm guessing the user 'zenoss' is granted SUPER privileges. To create a trigger in mysql(prior to 5.1.16) the user needs SUPER privileges. Personally I think granting 'zenoss' global SUPER privileges is a security flaw/risk and should be removed. The solution is to delete the trigger and re-create it with [EMAIL PROTECTED] or with some other user that has the SUPER privilege. How to delete the trigger Code: drop trigger status_delete; How to re-create the trigger Code: CREATE [EMAIL PROTECTED] TRIGGER `status_delete` BEFORE DELETE ON `status` FOR EACH ROW INSERT INTO history SET dedupid=OLD.dedupid, evid=OLD.evid, device=OLD.device, component=OLD.component, eventClass=OLD.eventClass, eventKey=OLD.eventKey, summary=OLD.summary, message=OLD.message, severity=OLD.severity, eventState=OLD.eventState, eventClassKey=OLD.eventClassKey, eventGroup=OLD.eventGroup, stateChange=OLD.stateChange, firstTime=OLD.firstTime, lastTime=OLD.lastTime, count=OLD.count, prodState=OLD.prodState, suppid=OLD.suppid, manager=OLD.manager, agent=OLD.agent, DeviceCLass=OLD.DeviceClass, Location=OLD.Location, Systems=OLD.Systems, DeviceGroups=OLD.DeviceGroups, ipAddress=OLD.ipAddress, facility=OLD.facility, priority=OLD.priority, ntevid=OLD.ntevid, ownerid=OLD.ownerid, deletedTime=NULL, clearid=OLD.clearid, DevicePriority=OLD.DevicePriority, eventClassMapping=OLD.eventClassMapping ; The trigger was found by dumping the mysql database without the data. Code: mysqldump -u root -p --opt zenoss --no-data --result-file=empty.zenoss Hopefully this helps anyone else looking to using Zenoss with a separate MySQL server. Reference links: http://dev.mysql.com/doc/refman/5.0/en/faqs-triggers.html#qandaitem-28-5-6 http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html http://dev.mysql.com/doc/refman/5.0/en/drop-trigger.html -------------------- m2f -------------------- Read this topic online here: http://community.zenoss.com/forums/viewtopic.php?p=18070#18070 -------------------- m2f -------------------- _______________________________________________ zenoss-users mailing list [email protected] http://lists.zenoss.org/mailman/listinfo/zenoss-users
