Ad Widget

Collapse

ODBC Problem within Zabbix-GUI

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • DiViNe
    Member
    • Feb 2015
    • 30

    #1

    ODBC Problem within Zabbix-GUI

    Too many live links/images found in your post content. Please edit your post or contact the administrator.

    cannot connect to ODBC DSN:[SQL_ERROR]:[IM002][0][unixODBC][Driver Manager]Data source name not found, and no default driver specified]]

    No links or images were in my posts, so I made a pdf with my post.
    Attached Files
  • DiViNe
    Member
    • Feb 2015
    • 30

    #2
    Any ideas?

    Comment

    • DiViNe
      Member
      • Feb 2015
      • 30

      #3
      Looks like my assumption was right, zabbix server doesen't get my enviorement variable even though I've put it in .bash_profile of the zabbix user (see attached pdf)
      strings -a /proc/<zabbix pid>/environ
      LANG=en_US.UTF-8
      PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
      CONFFILE=/etc/zabbix/zabbix_server.conf

      Comment

      • DiViNe
        Member
        • Feb 2015
        • 30

        #4
        Zabbix as root, still doesen't work

        I've also tried to edit /etc/zabbix/zabbix_server.conf

        Code:
        ### Option: AllowRoot
        #       Allow the server to run as 'root'. If disabled and the server is started by 'root', the server
        #       will try to switch to the user specified by the User configuration option instead.
        #       Has no effect if started under a regular user.
        #       0 - do not allow
        #       1 - allow
        #
        # Mandatory: no
        # Default:
        # AllowRoot=0
        AllowRoot=1

        Comment

        • DiViNe
          Member
          • Feb 2015
          • 30

          #5
          Solved: /usr/lib64

          I think I found it

          In:
          /etc/sysconfig/zabix-server and/or
          /home/zabbix/.bash_profile

          my line was:
          LD_LIBRARY_PATH=/usr/lib/oracle/12.2/client64/lib

          Instead of:
          LD_LIBRARY_PATH=/usr/lib/oracle/12.2/client64/lib:/usr/lib64

          Comment

          • wh1test
            Junior Member
            • Jun 2018
            • 1

            #6

            Originally posted by DiViNe
            Solved: /usr/lib64

            I think I found it

            In:
            /etc/sysconfig/zabix-server and/or
            /home/zabbix/.bash_profile

            my line was:
            LD_LIBRARY_PATH=/usr/lib/oracle/12.2/client64/lib

            Instead of:
            LD_LIBRARY_PATH=/usr/lib/oracle/12.2/client64/lib:/usr/lib64
            I don't understand why this information about configuring oracle odbc is not exist in official user guide =|

            Comment

            Working...