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

question marks ??? instead of cyrillic text in frontend with Oracle db backend, better documentation

XMLWordPrintable

      We have zabbix-server 2.0.6, compiled from source, httpd 2.2.22 compiled from source & Oracle DB 11.2.0.3 with UTF8 codepage. We use native frontend with Russian translation, history and messages in triggers is displayed as '?????????'.

      select client_charset from v$session_connect_info where OSUSER='apache'; 
      US7ASCII
      

      Please help.

      DB NLS Params

      NLS_LANGUAGE	AMERICAN
      NLS_TERRITORY	AMERICA
      NLS_CURRENCY	$
      NLS_ISO_CURRENCY	AMERICA
      NLS_NUMERIC_CHARACTERS	.,
      NLS_CHARACTERSET	AL32UTF8
      NLS_CALENDAR	GREGORIAN
      NLS_DATE_FORMAT	DD-MON-RR
      NLS_DATE_LANGUAGE	AMERICAN
      NLS_SORT	BINARY
      NLS_TIME_FORMAT	HH.MI.SSXFF AM
      NLS_TIMESTAMP_FORMAT	DD-MON-RR HH.MI.SSXFF AM
      NLS_TIME_TZ_FORMAT	HH.MI.SSXFF AM TZR
      NLS_TIMESTAMP_TZ_FORMAT	DD-MON-RR HH.MI.SSXFF AM TZR
      NLS_NCHAR_CHARACTERSET	UTF8
      NLS_DUAL_CURRENCY	$
      NLS_COMP	BINARY
      NLS_LENGTH_SEMANTICS	BYTE
      NLS_NCHAR_CONV_EXCP	FALSE
      NLS_RDBMS_VERSION	11.2.0.3.0
      

      apache OS env:

      LESSKEY=/etc/lesskey.bin
      NNTPSERVER=news
      INFODIR=/usr/local/info:/usr/share/info:/usr/info
      MANPATH=/usr/local/man:/usr/share/man
      HOSTNAME=as04cityp
      XKEYSYMDB=/usr/share/X11/XKeysymDB
      HOST=as04cityp
      SHELL=/bin/bash
      TERM=xterm
      PROFILEREAD=true
      HISTSIZE=1000
      NLS_LANG=AMERICAN_AMERICA.AL32UTF8
      MORE=-sl
      USER=apache
      LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib
      LS_COLORS=no=00:fi=00:di=01;34:ln=00;36:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=41;33;01:ex=00;32:*.cmd=00;32:*.exe=01;32:*.com=01;32:*.bat=01;32:*.btm=01;32:*.dll=01;32:*.tar=00;31:*.tbz=00;31:*.tgz=00;31:*.rpm=00;31:*.deb=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.lzma=00;31:*.zip=00;31:*.zoo=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.tb2=00;31:*.tz2=00;31:*.tbz2=00;31:*.avi=01;35:*.bmp=01;35:*.fli=01;35:*.gif=01;35:*.jpg=01;35:*.jpeg=01;35:*.mng=01;35:*.mov=01;35:*.mpg=01;35:*.pcx=01;35:*.pbm=01;35:*.pgm=01;35:*.png=01;35:*.ppm=01;35:*.tga=01;35:*.tif=01;35:*.xbm=01;35:*.xpm=01;35:*.dl=01;35:*.gl=01;35:*.wmv=01;35:*.aiff=00;32:*.au=00;32:*.mid=00;32:*.mp3=00;32:*.ogg=00;32:*.voc=00;32:*.wav=00;32:
      XNLSPATH=/usr/share/X11/nls
      ENV=/etc/bash.bashrc
      HOSTTYPE=x86_64
      FROM_HEADER=
      PAGER=less
      CSHEDIT=emacs
      XDG_CONFIG_DIRS=/etc/xdg
      MINICOM=-c on
      MAIL=/var/spool/mail/apache
      PATH=/opt/apache/bin:/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/X11R6/bin:/usr/games:/opt/kde3/bin:/usr/lib/mit/bin:/usr/lib/mit/sbin:/usr/java/jdk1.7.0_04/bin:/usr/lib/oracle/11.2/client64/lib
      CPU=x86_64
      INPUTRC=/opt/apache/.inputrc
      PWD=/opt/apache
      JAVA_HOME=/usr/java/jdk1.7.0_04
      LANG=en_US.UTF-8
      PYTHONSTARTUP=/etc/pythonstart
      QT_SYSTEM_DIR=/usr/share/desktop-data
      SHLVL=1
      HOME=/opt/apache
      LESS_ADVANCED_PREPROCESSOR=no
      OSTYPE=linux
      LS_OPTIONS=-N --color=tty -T 0
      XCURSOR_THEME=DMZ
      WINDOWMANAGER=/usr/bin/startkde
      G_FILENAME_ENCODING=@locale,UTF-8,ISO-8859-15,CP1252
      LESS=-M -I
      MACHTYPE=x86_64-suse-linux
      LOGNAME=apache
      XDG_DATA_DIRS=/usr/share:/etc/opt/kde3/share:/opt/kde3/share
      LESSOPEN=lessopen.sh %s
      INFOPATH=/usr/local/info:/usr/share/info:/usr/info
      ORACLE_HOME=/usr/lib/oracle/11.2/client64
      

            Unassigned Unassigned
            ozz_born Alexander
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: