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

1.4.2 fails to install with Postgresql

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.4.2
    • Fix Version/s: 1.4.3
    • Component/s: Server (S)
    • Labels:
      None

      Description

      There is problem in table names used in data.sql , some data fails to import into PostgreSQL database. They should be "hosts" instead of `hosts`.

      Following installation procedure with PGSQL fails:

      sanatana# cat data.sql | psql -U zabbix zabbix
      INSERT 404144 1
      INSERT 404145 1
      INSERT 404146 1
      INSERT 404147 1
      INSERT 404148 1
      INSERT 404149 1
      INSERT 404150 1
      INSERT 404151 1
      INSERT 404152 1
      INSERT 404153 1
      INSERT 404154 1
      INSERT 404155 1
      INSERT 404156 1
      INSERT 404157 1
      INSERT 404158 1
      INSERT 404159 1
      ERROR: syntax error at or near "`"
      LINE 1: INSERT INTO `hosts` VALUES (10001,'Template_Linux','',0,'',1...
      ^
      ERROR: syntax error at or near "`"
      LINE 1: INSERT INTO `hosts` VALUES (10002,'Template_Windows','',0,''...
      ^
      ERROR: syntax error at or near "`"
      LINE 1: INSERT INTO `hosts` VALUES (10003,'Template_App_MySQL','',0,...
      ^
      ERROR: syntax error at or near "`"
      LINE 1: INSERT INTO `hosts` VALUES (10004,'Template_Standalone','',0...
      ^
      ERROR: syntax error at or near "`"
      LINE 1: INSERT INTO `hosts` VALUES (10007,'Template_SNMPv2_Device','...
      ^
      ERROR: syntax error at or near "`"
      LINE 1: INSERT INTO `hosts` VALUES (10008,'Template_FreeBSD','Templa...

      Can someone post fix?
      Edit/Delete Message

      http://www.zabbix.com/forum/showthread.php?t=7511

        Attachments

          Activity

            People

            Assignee:
            sasha Alexander Vladishev
            Reporter:
            alexei Alexei Vladishev
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: