Ad Widget

Collapse

Zabbix database creation

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • alanjay
    Junior Member
    • Jan 2006
    • 5

    #1

    Zabbix database creation

    Hi,

    After trying the 1.1beta and it not compiling I wnet back and tried 1.0 on compilation and installation went fine up to the point where I wanted to create the database following your instructions (which are fine except the "|" looks like a "\" ) all went well until copying the data.

    Creating the schema went fine but addign the data resulted in:

    ERROR 1136 at line 24: Column count doesn't match value count at row 1

    I am using mySQL 4.1.16; FreeBSD 4.9; PHP 4.4.2

    PS Thanks for the very fast response on the problems with the beta.
  • alanjay
    Junior Member
    • Jan 2006
    • 5

    #2
    This seemed to be implying that the data is already in place but this is with a brand new database created from scratch. Not sure what I have done wrong on this.

    Also once loaded and running in the Houskeeping Confguration trying to update the database gives:

    SQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'alert_history=350,refresh_unsupported=' at line 1
    Query: update config set alarm_history=,alert_history=350,refresh_unsupport ed=

    Comment

    Working...