Hi Eric,
 
It would appear that the mysql DB hasn't been updated. The error is about a missing field. See Below. The migration fails also. It maybe related, but I was leaving that until I solved the first part. I'm not seeing any errors in the build regarding mysql.
 
EBL-005:/usr/local/zenoss/bin # ./zenxevent run -v 10 --cycle
DEBUG:zen.Events:EventClassInst=Start
DEBUG:zen.Events:update status set clearid = '0a67b4bf344d1410dfffffff' where device='EBL-005.iacgs.qld.edu.au' and component='zenxevent' and eventKey='' and (eventClass='/App/Stop' or eventClass='/App/Start')
ERROR:zen.Events:(1054, "Unknown column 'clearid' in 'field list'")
Traceback (most recent call last):
  File "/usr/local/Zope-2.8.6-final/Products/ZenEvents/MySqlSendEvent.py", line 19, in execute
    result = cursor.execute(statement)
  File "/usr/local/zenoss/lib/python/MySQLdb/cursors.py", line 137, in execute
    self.errorhandler(self, exc, value)
  File "/usr/local/zenoss/lib/python/MySQLdb/connections.py", line 33, in defaulterrorhandler
    raise errorclass, errorvalue
OperationalError: (1054, "Unknown column 'clearid' in 'field list'")
ERROR:zen.Events:(1054, "Un known column 'clearid' in 'field list'")
Traceback (most recent call last):
  File "/usr/local/Zope-2.8.6-final/Products/ZenEvents/MySqlSendEvent.py", line 87, in sendEvent
    self.doSendEvent(event, db)
  File "/usr/local/Zope-2.8.6-final/Products/ZenEvents/MySqlSendEvent.py", line 107, in doSendEvent
    execute(curs, self.buildClearUpdate(event, clearcls))
  File "/usr/local/Zope-2.8.6-final/Products/ZenEvents/MySqlSendEvent.py", line 24, in execute
    raise ex
OperationalError: (1054, "Unknown column 'clearid' in 'field list'")
Traceback (most recent call last):
  File "/usr/local/zenoss/Products/ZenEvents/zenxevent.py", line 87, in ?
    z = ZenXEvent()
  File "/usr/local/zenoss/Products/ZenEvents/zenxevent.py", line 37, in __init__
    EventServer.__init__(self)
  File "/usr/local/Zope-2.8.6-final/Products/ZenEvents/EventS erver.py", line 69, in __init__
    component=self.name))
  File "/usr/local/Zope-2.8.6-final/Products/ZenEvents/EventServer.py", line 96, in sendEvent
    self.zem.sendEvent(evt)
  File "/usr/local/Zope-2.8.6-final/Products/ZenEvents/MySqlSendEvent.py", line 92, in sendEvent
    raise ZenBackendFailure(str(e))
Products.ZenEvents.Exceptions.ZenBackendFailure: (1054, "Unknown column 'clearid' in 'field list'")
 
Eric Belcher
Manager - Technology Services
Anglican Church Grammar School
Oaklands Parade, East Brisbane
[EMAIL PROTECTED]
Phone 617 3896 2186
Fax 617 3891 5976


>>> Eric Newton <[EMAIL PROTECTED]> 29/08/2006 10:44 pm >>>
Run zenxevent with debugging turned on:

    zenxevent run -v 10 --cycle

Ignore the warning about the config, or just make one:

    touch $ZENHOME/etc/zenxevent.conf

You should be able to connect to zenxevent on port 8081:

    http://localhost:8081

-Eric

Eric Belcher wrote:
> Hi,

> Just tried to upgrade to 0.22.1. My main problem seems to be that
> zenxevent doesn't start. Could I have a few things to check?

> For example the config file is empty (zenxevent.conf). Is this
> correct?

> Thanks
> Eric.



_______________________________________________
zenoss-users mailing list
[email protected]
http://lists.zenoss.org/mailman/listinfo/zenoss-users

Disclaimer

This email is intended for the use of the named individual or entity and may contain confidential and privileged information. Any dissemination distribution or copying by anyone other than the intended recipient of this email is strictly prohibited. If this email has been received in error, please send an email in response, or telephone us immediately on +61 7 38962200, and destroy the original message. Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of the Corporation of the Synod of the Diocese of Brisbane or Churchie.

_______________________________________________
zenoss-users mailing list
[email protected]
http://lists.zenoss.org/mailman/listinfo/zenoss-users

Reply via email to