Is there a special way to add it?

I am getting:

Traceback (most recent call last):
  File "/opt/zenoss/zenoss/Products/ZenStatus/zenagios.py", line 25, in ?
    from Products.ZenEvents import Event
  File "/opt/zenoss/zenoss/Products/ZenEvents/__init__.py", line 17, in ?
    from MySqlEventManager import MySqlEventManager, addMySqlEventManager, \
  File "/opt/zenoss/zenoss/Products/ZenEvents/MySqlEventManager.py", line 10, 
in ?
    from MySqlSendEvent import MySqlSendEventMixin
  File "/opt/zenoss/zenoss/Products/ZenEvents/MySqlSendEvent.py", line 300
    return _mysql.escape_string(value.encode('iso-8859-1')) 

-----Ursprüngliche Nachricht-----
Von: Eric Newton [mailto:[EMAIL PROTECTED] 
Gesendet: Dienstag, 8. August 2006 14:55
An: General discussion of using zenoss system
Betreff: Re: [zenoss-users] Zensyslog, Unicode error

It looks like internationalization will be my timezone for this month.

I should have a patch in a couple of hours. If you want it fixed prior to that:
Edit Products/ZenEvents/MySqlSendEvent.py

Change:
return _mysql.escape_string(value.encode('iso-8859-1'))

To:
if type(value) == type(u''):
return _mysql.escape_string(value.encode('iso-8859-1'))
return _mysql.escape_string(value)


-Eric

Schuran, Sven wrote:
> Hi,
>
> have a look. 
> Do you need more?
>
> Sven
> ###########################
>
>
>
> UnicodeDecodeError: 'ascii' codec can't decode byte 0xfc in position 20:
> ordinal not in range(128)
> 2006-08-08 10:54:50 ERROR zen.Syslog: event processing failure: 
> Traceback (most recent call last):
>   File
> "/opt/zenoss/zenoss/Products/ZenEvents/SyslogProcessingThread.py", 
> line 93, in run
>     self.zem.sendEvent(evt)
>   File "/opt/zenoss/zenoss/Products/ZenEvents/MySqlSendEvent.py", line 
> 87, in sendEvent
>     self.doSendEvent(event, db)
>   File "/opt/zenoss/zenoss/Products/ZenEvents/MySqlSendEvent.py", line 
> 108, in doSendEvent
>     stmt = self.buildStatusInsert(statusdata, event._action, evid)
>   File "/opt/zenoss/zenoss/Products/ZenEvents/MySqlSendEvent.py", line 
> 214, in buildStatusInsert
>     insert = self.buildInsert(statusdata, table)
>   File "/opt/zenoss/zenoss/Products/ZenEvents/MySqlSendEvent.py", line 
> 254, in buildInsert
>     fields.append("%s='%s'" % (name, self.escape(value)))
>   File "/opt/zenoss/zenoss/Products/ZenEvents/MySqlSendEvent.py", line 
> 299, in escape
>     return _mysql.escape_string(value.encode('iso-8859-1'))
> UnicodeDecodeError: 'ascii' codec can't decode byte 0xa9 in position 31:
> ordinal not in range(128)
> 2006-08-08 10:54:56 ERROR zen.Syslog: event processing failure: 
> Traceback (most recent call last):
>   File
> "/opt/zenoss/zenoss/Products/ZenEvents/SyslogProcessingThread.py", 
> line 93, in run
>     self.zem.sendEvent(evt)
>   File "/opt/zenoss/zenoss/Products/ZenEvents/MySqlSendEvent.py", line 
> 87, in sendEvent
>     self.doSendEvent(event, db)
>   File "/opt/zenoss/zenoss/Products/ZenEvents/MySqlSendEvent.py", line 
> 108, in doSendEvent
>     stmt = self.buildStatusInsert(statusdata, event._action, evid)
>   File "/opt/zenoss/zenoss/Products/ZenEvents/MySqlSendEvent.py", line 
> 214, in buildStatusInsert
>     insert = self.buildInsert(statusdata, table)
>   File "/opt/zenoss/zenoss/Products/ZenEvents/MySqlSendEvent.py", line 
> 254, in buildInsert
>     fields.append("%s='%s'" % (name, self.escape(value)))
>   File "/opt/zenoss/zenoss/Products/ZenEvents/MySqlSendEvent.py", line 
> 299, in escape
>     return _mysql.escape_string(value.encode('iso-8859-1'))
> UnicodeDecodeError: 'ascii' codec can't decode byte 0xdf in position
> 107: ordinal not in range(128)
> 2006-08-08 10:54:56 ERROR zen.Syslog: event processing failure: 
> Traceback (most recent call last):
>   File
> "/opt/zenoss/zenoss/Products/ZenEvents/SyslogProcessingThread.py", 
> line 93, in run
>     self.zem.sendEvent(evt)
>   File "/opt/zenoss/zenoss/Products/ZenEvents/MySqlSendEvent.py", line 
> 87, in sendEvent
>     self.doSendEvent(event, db)
>   File "/opt/zenoss/zenoss/Products/ZenEvents/MySqlSendEvent.py", line 
> 108, in doSendEvent
>     stmt = self.buildStatusInsert(statusdata, event._action, evid)
>   File "/opt/zenoss/zenoss/Products/ZenEvents/MySqlSendEvent.py", line 
> 214, in buildStatusInsert
>     insert = self.buildInsert(statusdata, table)
>   File "/opt/zenoss/zenoss/Products/ZenEvents/MySqlSendEvent.py", line 
> 254, in buildInsert
>     fields.append("%s='%s'" % (name, self.escape(value)))
>   File "/opt/zenoss/zenoss/Products/ZenEvents/MySqlSendEvent.py", line 
> 299, in escape
>     return _mysql.escape_string(value.encode('iso-8859-1'))
> UnicodeDecodeError: 'ascii' codec can't decode byte 0xfc in position 76:
> ordinal not in range(128)
> _______________________________________________
> zenoss-users mailing list
> [email protected]
> http://lists.zenoss.org/mailman/listinfo/zenoss-users
>
>   

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


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

Reply via email to