|
hi eric, how do i resolve this? [EMAIL PROTECTED] bin]# zeneventbuild zenoss z3n055 203.190.77.153 ERROR 1359 at line 79: Trigger already exists ERROR 1370 at line 2: alter routine command denied to user 'zenoss'@'202.52.163.42' for routine 'events.close_events' ---- i edited the zeneventbuild and it looks like this now: #!/bin/sh if [ "$ZENHOME" = "" ]; then echo ERROR: ZENHOME envrionment variable not set. exit 1 fi EVTDB=$ZENHOME/Products/ZenEvents/db if [ -d $EVTDB ]; then cd $EVTDB else echo ERROR: $EVTDB not installed. exit 1 fi mysql -u $1 --password=$2 -h $3 < zenevents.sql mysql -u $1 --password=$2 -h $3< zenprocs.sql ---- is this ok? i followed ur instructions in installing zenoss to a vm instance. and copied it to my desired machine. it looks fine. also updated the zeneventmanager properties. also followed the steps on mysql grants. but i still see this in the dashboard: --> Lost Connection to Zenoss event.log: ------- File "/usr/local/zenoss/Products/ZenEvents/EventManagerBase.py", line 294, in getEventSummaryME return self.getEventSummary(where, severity, state, prodState) File "/usr/local/zenoss/Products/ZenEvents/MySqlEventManager.py", line 65, in getEventSummary db = self.connect() File "/usr/local/zenoss/Products/ZenEvents/DbAccessBase.py", line 25, in connect db="events",conv=mysqlconv) File "usr/local/zenoss/lib/python/MySQLdb/__init__.py", line 66, in Connect # log messages. When the "real" loggers are set up, we flush File "usr/local/zenoss/lib/python/MySQLdb/connections.py", line 134, in __init__ OperationalError: (2013, 'Lost connection to MySQL server during query') bin]# tail ../log/zenxevent.log retval = method(*data) File "/usr/local/zenoss/Products/ZenEvents/EventManagerBase.py", line 767, in sendEvents db = self.connect() File "/usr/local/zenoss/Products/ZenEvents/DbAccessBase.py", line 25, in connect db="events",conv=mysqlconv) File "usr/local/zenoss/lib/python/MySQLdb/__init__.py", line 66, in Connect return Connection(*args, **kwargs) File "usr/local/zenoss/lib/python/MySQLdb/connections.py", line 134, in __init__ super(Connection, self).__init__(*args, **kwargs2) OperationalError: (2013, 'Lost connection to MySQL server during query') --- do u think its also a network problem? thanks Eric Newton wrote: Hey Joel, -- Joel M. Mandapat Chikka Asia, Inc. 3104-B, East Tektite Towers, Philippine Stock Exchange Center Exchange Road, Ortigas Pasig City, Philippines Mobile: +639285028664 Tel: +6326316166 local 145 Fax: +6326317217 AN ISO 9001:2000; ISO 15000:2002; ISO 17799:2002 CERTIFIED COMPANY; A CMMI Maturity level 5 Organization. [EMAIL PROTECTED] http://www.chikka.com This message and any attachment are confidential and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, you must not copy this message or attachment or disclose the contents to any other person. If you have received this transmission in error, please notify the sender immediately and delete the message and any attachment from your system. Chikka does not accept liability for any omissions or errors in this message which may arise as a result of E-Mail-transmission or for damages resulting from any unauthorized changes of the content of this message and any attachment thereto. Chikka does not guarantee that this message is free of viruses and does not accept liability for any damages caused by any virus transmitted therewith. |
_______________________________________________ zenoss-users mailing list [email protected] http://lists.zenoss.org/mailman/listinfo/zenoss-users
