I did a fresh install of NAV on a new server running FreeBSD 6.0 (I'm testing a new NAV-port) with postgres version 8.1.2 It's working OK, but I have one issue with editdb. When I add some (not all) devices I got this message:
Mod_python error: "PythonHandler editdb"
Traceback (most recent call last):
File "/usr/local/lib/python2.4/site-packages/mod_python/apache.py", line 299, in HandlerDispatch result = object(req)
File "/usr/local/nav/apache/webroot/editdb/editdb.py", line 156, in handler output = editPage(req,pageList[table](),request,unicodeError)
File "/usr/local/nav/apache/webroot/editdb/editdb.py", line 463, in editPage outputForm,action)
File "/usr/local/nav/apache/webroot/editdb/editdb.py", line 2323, in add box.getDeviceId()
File "/usr/local/nav/apache/webroot/editdb/initBox.py", line 172, in getDeviceId handle.execute(sql)
ProgrammingError: ERROR: invalid UTF-8 byte sequence detected near byte 0xa6
select deviceid,productid from device where serial='TSC072200EF' or serial='TSC072200EF' or serial='SAL0723EGL7' or serial='SAL0724ES3J' or serial='SAL081231FM' or serial='SAD074205GH' or serial='SAD054901Y2' or serial='SAD070602XN' or serial='TSC072200EF' or serial='TSC072200EF' or serial='ART07080201' or serial='ART0708021F' or serial='SMT0718B638' or serial='SMT0717E960' or serial='SMT0718B178' or serial='SMT0719A419' or serial='SMT0719A658' or serial='SAL0723EGL7' or serial='SAD072500EC' or serial='53P20860004N5 ' or serial='0304041111522442' or serial='0402072351382736' or serial='0301180923529392' or serial='0402072350198996' or serial='0402072342552745' or serial=' ??!,' or serial='0110090723375165' or serial='0110102236193275' or serial='0109251314313648' or serial='0408190153253929' or serial='0408142032151214' or serial='0502031302311622' or serial='0109252054240475' or serial='0404102131298442' or serial='SAL0724ES3J' or serial='SAD072400X2' or serial='23L3337006PP5 ' or serial='0402072351156706' or serial='0402072342477730' or serial='0402072348095458' or serial='0404101237444069' or serial='53P20860004RL ' or serial='"?]?' or serial='0404101234484655' or serial='0402072349401982' or serial='0402072342279079' or serial='0110221752152448' or serial='0402072342405113' or serial='SAL081231FM' or serial='0109251545455076' or serial='0402072349174124' or serial='0402072348587844' or serial='0402072351457995' or serial='0402072351520962' or serial='0404030400310757' or serial='0404030349531186' or serial='0404101236580442' or serial='0404101224508999' or serial='0404101209525423' or serial='0404030401209314' or serial='0404030357555556' or serial='0404030400194397' or serial='0404030359569002' or serial='0406010029209883' or serial='0408162112586079' or serial='SAD074205GH' or serial='SAD074200KC' or serial='SAD074105GC' or serial='SAD054901Y2' or serial='SAD070602XN'
(the device is a c6509)
It's a fresh database and it looks like editdb tries to put non-UTF-8 characters into the database? A bug?
I know that the encoding-consistency for Unicode has been tightened down in postgres 8.1: http://archives.postgresql.org/pgsql-hackers/2005-10/msg00972.php
regards,
-- Borge Brunes, Computer Center, University of Tromso, Norway http://www.cc.uit.no/~borge/ | http://www.freebsd.org