Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-3081

The problem with logrt and russian utf8

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Major Major
    • 1.8.10
    • 1.8.3
    • Server (S)
    • Fedora 10, PostgreSQL 8.3.4, Zabbix 1.8.3

      google translate result :
      -----------------------------------------------------------------------
      Monitoring logs used by logrt.

      In a controlled log found this line:

      Sep 29 14:05:53 zabbix-160 passwd: PAM unable to dlopen (/ lib64/security/pam_gnome_keyring.so): / lib64/security/pam_gnome_keyring.so: can not open shared object file: No such file or directory

      In the server log file Zabbix (zabbix_server.log) on ??this line we get:

      12754:20101005:151411.938 [Z3005] Query failed: [0] PGRES_FATAL_ERROR: ERROR: invalid byte sequence for encoding "UTF8": 0xd027
      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".
      [Update items set lastclock = 1286277245, prevvalue = lastvalue, lastvalue = 'Sep 29 14:05:53 zabbix-160 passwd: PAM unable to dlopen (/ lib64/security/pam_gnome_keyring.so): / lib64/security/pam_gnome_keyring.so : can not open shared object file: No such file. ', lastlogsize = 4524, mtime = 1285754770 where itemid = 24 998;
      ]
      12754:20101005:151411.939 [Z3005] Query failed: [0] PGRES_FATAL_ERROR: ERROR: current transaction is aborted, commands ignored until end of transaction block
      [Insert into history_log (id, itemid, clock, timestamp, source, severity, value, logeventid) values ??(74,24998,1286277245,0,'', 0, 'Sep 29 14:05:53 zabbix-160 passwd: PAM unable to dlopen (/ lib64/security/pam_gnome_keyring.so): / lib64/security/pam_gnome_keyring.so: can not open shared object file: No such file or directory ', 0);
      ]
      12754:20101005:151411.939 [Z3005] Query failed: [0] PGRES_FATAL_ERROR: ERROR: current transaction is aborted, commands ignored until end of transaction block
      [Select distinct t.triggerid, t.type, t.value, t.error, t.expression, f.itemid from triggers t, functions f, items i where i.status not in (3) and i.itemid = f . itemid and t.status = 0 and f.triggerid = t.triggerid and f.itemid in (24 998) order by t.triggerid]

      Judging from the log, the server Zabbix cut Russian letter 'l' (utf8 code 0xd0bb) in half, then attributed to the first 0xd0 single quotation mark (code 0x27) and got the code 0xd027, which is not a valid code utf8.

      As a result, the lines similar to those specified in the journal Zabbix does not fall.

      original :
      -----------------------------------------------------------------------
      ???????????? ?????????? ????? ? ??????? logrt.

      ? ?????????????? ???? ??????????? ????? ??????:

      Sep 29 14:05:53 zabbix-160 passwd: PAM unable to dlopen(/lib64/security/pam_gnome_keyring.so): /lib64/security/pam_gnome_keyring.so: ?????????? ??????? ??????????? ????????? ????: ??? ?????? ????? ??? ????????

      ? ???? ??????? Zabbix (zabbix_server.log) ?? ??? ?????? ????????:

      12754:20101005:151411.938 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: invalid byte sequence for encoding "UTF8": 0xd027
      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".
      [update items set lastclock=1286277245,prevvalue=lastvalue,lastvalue='Sep 29 14:05:53 zabbix-160 passwd: PAM unable to dlopen(/lib64/security/pam_gnome_keyring.so): /lib64/security/pam_gnome_keyring.so: ?????????? ??????? ??????????? ????????? ????: ??? ?????? ????? ?.',lastlogsize=4524,mtime=1285754770 where itemid=24998;
      ]
      12754:20101005:151411.939 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: current transaction is aborted, commands ignored until end of transaction block
      [insert into history_log (id,itemid,clock,timestamp,source,severity,value,logeventid) values (74,24998,1286277245,0,'',0,'Sep 29 14:05:53 zabbix-160 passwd: PAM unable to dlopen(/lib64/security/pam_gnome_keyring.so): /lib64/security/pam_gnome_keyring.so: ?????????? ??????? ??????????? ????????? ????: ??? ?????? ????? ??? ????????',0);
      ]
      12754:20101005:151411.939 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: current transaction is aborted, commands ignored until end of transaction block
      [select distinct t.triggerid,t.type,t.value,t.error,t.expression,f.itemid from triggers t,functions f,items i where i.status not in (3) and i.itemid=f.itemid and t.status=0 and f.triggerid=t.triggerid and f.itemid in (24998) order by t.triggerid]

      ???? ?? ??, ?????? Zabbix ??????? ??????? ?????? '?' (utf8 ??? 0xd0bb) ??????, ????? ? ??????? 0xd0 ???????? ?????? ????????? ??????? (? 0x27) ? ??????? ??? 0xd027, ??????? ?? ???????? ?????????? ????? utf8.

      ? ?????, ??????, ??????????? ?????????, ? ?????? Zabbix ?? ????????.

            Unassigned Unassigned
            dmsam Dmitry Samoylov
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: