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

SQL Debug data without Debug being on

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Major Major
    • 1.8.5
    • 1.8.1
    • Frontend (F)
    • None
    • Debian Squeeze, Kernel 2.6.18-20-ovz-686 #1 SMP Mon Nov 9 21:45:14 UTC 2009 i686 GNU/Linux, Fresh install of zabbix, db upgrade from 1.6.6 to 1.8.1, mysql-5.1

      Zabbix server outputs 'hidden' data that appears to be mysql debug data. Fresh install from a debian package on the squeeze repos. Did not turn debugging on/off [this has to be a default at the moment]

      Using a text browser, I see the following, I assume this should be off by default:

      Received cookie: zbx_sessionid=e1d8f50389e15d97cc22c1f565d42ece
      Received cookie: zbx_sessionid=deleted
      Help|Get support|Print|Login

      SEARCH: [ ]

      • Timezone for PHP is not set. Please set "date.timezone" option in php.ini.

      Login

      Login name [ ]
      Password [ ]
      [Enter]
      Zabbix 1.8.1 Copyright 2001-2009 by SIA Zabbix | Not connected

                                          • Stats for script *************************
                                            Total time: 0.421011
                                            Memory limit : 128M
                                            Memory usage : 1024K - 7.5M
                                            Memory leak : 6.5M
                                            SQL selects count: 5
                                            SQL executes count: 4
                                            SQL requests count: 9
                                            Time:0.000326 SQL: SET NAMES utf8
                                            Time:0.000142 SQL: SET CHARACTER SET utf8
                                            Time:0.001414 SQL: SELECT * FROM nodes WHERE nodetype=1 ORDER BY nodeid
                                            Time:0.001798 SQL: SELECT u.* FROM users u WHERE u.alias='guest' AND ((u.userid
                                            BETWEEN 000000000000000 AND 099999999999999))
                                            Time:0.007277 SQL: INSERT INTO sessions (sessionid,userid,lastaccess,status)
                                            VALUES ('e1d8f50389e15d97cc22c1f565d42ece',2,1266388377,0)
                                            Time:0.001212 SQL: SELECT MAX(g.gui_access) as gui_access FROM usrgrp g,
                                            users_groups ug WHERE ug.userid=2 AND g.usrgrpid=ug.usrgrpid
                                            Time:0.001003 SQL: SELECT g.usrgrpid FROM usrgrp g, users_groups ug WHERE
                                            ug.userid = 2 AND g.usrgrpid = ug.usrgrpid AND g.users_status = 1 LIMIT 1
                                            OFFSET 0
                                            Time:0.001421 SQL: UPDATE sessions SET status=1 WHERE sessionid=
                                            'e1d8f50389e15d97cc22c1f565d42ece'

            Unassigned Unassigned
            codeninja Chris Walker
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: