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

Errors when execute data.sql in Oracle

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Blocker Blocker
    • 2.0.1rc1, 2.1.0
    • 2.0.0
    • Installation (I)
    • Oracle 11gR1

      I can not import initial data via data.sql in Oracle, there are some errors like:

      SP2-0734: unknown command beginning "{$SNMP_COM..." - rest of line ignored.
      ERROR:
      ORA-01756: quoted string not properly terminated

      • MySQL server is up','0','30')
        *
        ERROR at line 1:
        ORA-00900: invalid SQL statement

      It seems part of data.sql is in windows format, my workaround is converting it to unix with "dos2unix data.sql" and then removing all blank lines with "sed -i '/^$/d' data.sql".

            Unassigned Unassigned
            mycigar Guoyu Li
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: