On Mon, Oct 11, 2010 at 07:59:41PM +0200, Sigurd Mytting wrote:
I'm also getting a lot of errors in ipdevpoll.log, just one examle:
[snip]
"/var/lib/python-support/python2.5/django/db/models/sql/query.py", line 1734, in execute_sql cursor.execute(sql, params) DataError: invalid byte sequence for encoding "UTF8": 0xe56b65 HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".
Is there any way I can avoid putting non latin-1 characters into the database as a workaround?
Well, this error has avoided it for you ;-)
Apparently, you've set the description of Gi1/0/17 on 12a-sw-vts to "Temperatur Overvåker", using a latin-1 encoding.
Mostly, ipdevpoll assumes everything it collects is either ASCII or decodeable as UTF-8. For hardwired text strings, ASCII will almost always be correct, but for user-configured values it should probably try multiple encodings before giving up. This error message says the string could not be saved to the database, since it's not UTF-8, and that ensures that none of 12a-sw-vts' data will be saved at all.
Please report this to the bugtracker, and we'll try to fix it in 3.6.1 (scheduled next week, but possibly delayed over the weekend due to some saved-up vacation time).