Ad Widget

Collapse

[1.5 R5512] GUI: Template import/linking

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • NOB
    Senior Member
    Zabbix Certified Specialist
    • Mar 2007
    • 469

    #1

    [1.5 R5512] GUI: Template import/linking

    Hi

    after upgrading from Beta to R5512 (incl. DB-Schema), I still get this error
    message during import or template linking:

    # Undefined index: proxyid[/usr/local/apache2/htdocs/zabbix-1.5/hosts.php:200]
    # pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: syntax error at or near "," at character 26[/usr/local/apache2/htdocs/zabbix-1.5/include/db.inc.php:374]
    # Error in query [update hosts set proxyid=,host='T_ZABBIX-Server',port=10050,useip=0,dns='',ip='0.0.0.0' where hostid=10044] [ERROR: syntax error at or near "," at character 26]
    Regards

    Norbert.
  • Aly
    ZABBIX developer
    • May 2007
    • 1126

    #2
    Mmmm I'm confused, because thous changes were made in rev. 5470. There is no such code in rev. 5512. Check your frontend installation.
    Zabbix | ex GUI developer

    Comment

    • NOB
      Senior Member
      Zabbix Certified Specialist
      • Mar 2007
      • 469

      #3
      Originally posted by Aly
      Mmmm I'm confused, because thous changes were made in rev. 5470. There is no such code in rev. 5512. Check your frontend installation.
      OK, the message is different than last time: proxyid vs. proxy_hostid
      but the result is the same.
      It is never checked whether proxyid ist set or not.
      And in my case, it's obviously not.
      I updated the schema, of course.

      Excerpt from R5512 hosts.php:

      Code:
      		$templates = get_request('templates', array());
      
      		if(isset($_REQUEST["hostid"]))
      		{
      			if(isset($_REQUEST['clear_templates'])) 
      			{
      				foreach($_REQUEST['clear_templates'] as $id)
      				{
      					unlink_template($_REQUEST["hostid"], $id, false);
      				}
      			}
      
      			$result = update_host($_REQUEST["hostid"],
      				$_REQUEST["host"],$_REQUEST["port"],$_REQUEST["status"],$useip,$_REQUEST["dns"],
      				$_REQUEST["ip"],$_REQUEST["proxyid"],$templates,$_REQUEST["newgroup"],$groups);
      Regards

      Norbert.

      Comment

      • Aly
        ZABBIX developer
        • May 2007
        • 1126

        #4
        May be I misunderstood you, but this code is from frontend R.5508, and it's still unchanged..

        Code:
        		$templates = get_request('templates', array());
        		
        		[B]$_REQUEST['proxy_hostid'] = get_request('proxy_hostid',0);[/B]
        
        		if(isset($_REQUEST['hostid'])){
        			if(isset($_REQUEST['clear_templates'])) {
        				foreach($_REQUEST['clear_templates'] as $id){
        					unlink_template($_REQUEST["hostid"], $id, false);
        				}
        			}
        
        			$result = update_host($_REQUEST["hostid"],
        				$_REQUEST["host"],$_REQUEST["port"],$_REQUEST["status"],$useip,$_REQUEST["dns"],
        				$_REQUEST["ip"],$_REQUEST["proxy_hostid"],$templates,$_REQUEST["newgroup"],$groups);
        Zabbix | ex GUI developer

        Comment

        • NOB
          Senior Member
          Zabbix Certified Specialist
          • Mar 2007
          • 469

          #5
          Hi,

          I just downloaded pre-zabbix-1.5.tar.gz from your web site (developers.php).
          On the page it says it's release R5555.

          Please download it yourself and have a look at frontends/php/hosts.php
          line 186 !
          The statement you marked in your last response is still missing !?
          Of course, I can add it.
          But how can I be sure that this is the only difference to the "real" version ?

          I looked at it, again, and there ARE other differences, e.g. proxyid vs. proxy_hostid

          I can't use SVN from here (Firewall blocks access).

          Regards

          Norbert.
          Last edited by NOB; 28-03-2008, 08:45. Reason: Found more differences

          Comment

          • Aly
            ZABBIX developer
            • May 2007
            • 1126

            #6
            Problem with nightly builds.. There're old sources. We will fix this as soon as posible .
            Zabbix | ex GUI developer

            Comment

            • NOB
              Senior Member
              Zabbix Certified Specialist
              • Mar 2007
              • 469

              #7
              Hi Aly

              Originally posted by Aly
              Problem with nightly builds.. There're old sources. We will fix this as soon as posible .
              thanks a lot for your help.

              Can't wait to do more testing:
              I have to demonstrate it to our users next tuesday !

              Regards

              Norbert.

              Comment

              • Aly
                ZABBIX developer
                • May 2007
                • 1126

                #8
                Just don't forget that this is a beta
                Zabbix | ex GUI developer

                Comment

                • Aly
                  ZABBIX developer
                  • May 2007
                  • 1126

                  #9
                  Nightly builds updated
                  Zabbix | ex GUI developer

                  Comment

                  • NOB
                    Senior Member
                    Zabbix Certified Specialist
                    • Mar 2007
                    • 469

                    #10
                    Hi Aly


                    Originally posted by Aly
                    Just don't forget that this is a beta
                    Sure
                    I'll tell them that there is a lot of work going on in Riga right now
                    to fix the remaining problems.

                    But the new dashboard is too good to be true for some of our VIPs
                    voting pro or contra ZABBIX
                    So I'll have to show it to them.

                    I found another (the real) problem in Firefox: Everytime I "download" it
                    the (old) version in the cache is used and no real download happens !
                    I guess it's because of the same name.
                    All the code in the latest download via Firefox is from 6th of March 2008 !
                    Perhaps corresponding to my previous (first) download.
                    If I use wget to download it, everything is fine.

                    Regards

                    Norbert.

                    Comment

                    • Alexei
                      Founder, CEO
                      Zabbix Certified Trainer
                      Zabbix Certified SpecialistZabbix Certified Professional
                      • Sep 2004
                      • 5654

                      #11
                      Originally posted by NOB
                      All the code in the latest download via Firefox is from 6th of March 2008 !
                      Perhaps corresponding to my previous (first) download.
                      If I use wget to download it, everything is fine.
                      Actually the nightly build download was broken for several weeks. It contained old 1.5 archive, however the revision number was up-to date. I fixed it today.
                      Alexei Vladishev
                      Creator of Zabbix, Product manager
                      New York | Tokyo | Riga
                      My Twitter

                      Comment

                      Working...