Ad Widget

Collapse

Blog style for logfiles

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Heva
    Junior Member
    • Dec 2006
    • 15

    #1

    Blog style for logfiles

    I've upgraded from 1.4.2 to 1.6 and previously had some blogstyle listings of monitored logfiles. On one screen the logfiles for 6 system were displayed, the URL of which was created via Monitoring > Latest data > <some host log file> >history > add more logfiles for other host

    This worked fine, but after upgrade to 1.6 it's not working anymore.
    The old URL's seem to be invalid, so I set up to re-create them by hand.

    Now, the extra logfiles are added to the one displayed, but with MySQL errors at the bottom of the site:

    Code:
    * Error in query [SELECT MIN(t.clock) as clock FROM trends t WHERE t.itemid=Array] [Unknown column 'Array' in 'where clause']
        * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/var/www/include/db.inc.php:517]
        * Error in query [SELECT MIN(t.clock) as clock FROM trends_uint t WHERE t.itemid=Array] [Unknown column 'Array' in 'where clause']
        * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/var/www/include/db.inc.php:517]
    Also, after adding a hosts logfile, the URL changes from (like)
    Code:
    http://zabbix/history.php?action=showvalues&period=3600&itemid=22833
    to
    Code:
    http://zabbix/history.php
    which after some time frefreshes and displays to be invalid.

    Seems to me like some variable for Array is not correctly parsed to MySQL.
    The error is also displayed when ran on the mysql prompt, puttin Array in quotas returns NULL (and no error).

    Hopefully there's someone how does understand this?
    Last edited by Heva; 26-09-2008, 10:29.
  • Alexei
    Founder, CEO
    Zabbix Certified Trainer
    Zabbix Certified SpecialistZabbix Certified Professional
    • Sep 2004
    • 5654

    #2
    I believe this has been fixed in 1.6.1.
    Alexei Vladishev
    Creator of Zabbix, Product manager
    New York | Tokyo | Riga
    My Twitter

    Comment

    Working...