Re: AW: [zenoss-users] Zensyslog, Unicode error

[Eric Newton]

Sven,

svn now has a patch in for the problems you are seeing.  Please pull it 
down and let me know if it helps.

-Eric

Schuran, Sven wrote:
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
zenoss-users@zenoss.org
http://lists.zenoss.org/mailman/listinfo/zenoss-users