-
Type:
Incident report
-
Resolution: Won't fix
-
Priority:
Major
-
None
-
Affects Version/s: None
-
Component/s: Frontend (F)
-
None
-
Environment:9.1-RELEASE FreeBSD 9.1-RELEASE
HI Guys, I've tryed to install Zabbix2-server
Zabbix2-frontend
Installation I made by this instruction:
http://wiki.iuliann.ro/?FreeBSD%2FZabbix2%2FSetup.md
And I have seperete errors in seperate pages:
Configuration-host — Undefined index: useip [hosts.php:900]
Configuration-host-create host / when I try to add host ---Error in query [INSERT INTO hosts (hostid, proxy_hostid, host, port, status, useip, dns, ip, disable_until, available,useipmi,ipmi_port,ipmi_authtype,ipmi_privilege,ipmi_username,ipmi_password,ipmi_ip) VALUES (10085,0,'NAS-1',10050,0,1,'NAS-1','192.168.0.250',0,0,0,623,-1,2,'','','')] [Unknown column 'port' in 'field list']
DBerror //Attached screen
Configuration-actions — Error in query [SELECT op.* FROM opmediatypes op WHERE (op.operationid IN (3)) ] [Table 'zabbix.opmediatypes' doesn't exist]
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:613]
mysql_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:615]
Undefined index: object [include/actions.inc.php:281]
Undefined index: objectid [include/actions.inc.php:283]
Inventory-Hosts —
Error in query [SELECT hp.* FROM hosts_profiles hp WHERE (hp.hostid IN (10084)) ] [Table 'zabbix.hosts_profiles' doesn't exist]
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:613]
mysql_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:615]
Error in query [SELECT hpe.* FROM hosts_profiles_ext hpe WHERE (hpe.hostid IN (10084)) ] [Table 'zabbix.hosts_profiles_ext' doesn't exist]
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:613]
mysql_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:615]
At First, I've tryed to search in google and did not find anything.
And I've tryed to DROP DATABASE and CREATE it one more time
imported all from /usr/local/share/zabbix2/server/database/mysql/
mysql> show tables;
-----------------------
| Tables_in_zabbix |
-----------------------
| acknowledges |
| actions |
| alerts |
| applications |
| auditlog |
| auditlog_details |
| autoreg_host |
| conditions |
| config |
| dchecks |
| dhosts |
| drules |
| dservices |
| escalations |
| events |
| expressions |
| functions |
| globalmacro |
| globalvars |
| graph_discovery |
| graph_theme |
| graphs |
| graphs_items |
| groups |
| help_items |
| history |
| history_log |
| history_str |
| history_str_sync |
| history_sync |
| history_text |
| history_uint |
| history_uint_sync |
| host_inventory |
| hostmacro |
| hosts |
| hosts_groups |
| hosts_templates |
| housekeeper |
| httpstep |
| httpstepitem |
| httptest |
| httptestitem |
| icon_map |
| icon_mapping |
| ids |
| images |
| interface |
| item_discovery |
| items |
| items_applications |
| maintenances |
| maintenances_groups |
| maintenances_hosts |
| maintenances_windows |
| mappings |
| media |
| media_type |
| node_cksum |
| nodes |
| opcommand |
| opcommand_grp |
| opcommand_hst |
| opconditions |
| operations |
| opgroup |
| opmessage |
| opmessage_grp |
| opmessage_usr |
| optemplate |
| profiles |
| proxy_autoreg_host |
| proxy_dhistory |
| proxy_history |
| regexps |
| rights |
| screens |
| screens_items |
| scripts |
| service_alarms |
| services |
| services_links |
| services_times |
| sessions |
| slides |
| slideshows |
| sysmap_element_url |
| sysmap_url |
| sysmaps |
| sysmaps_elements |
| sysmaps_link_triggers |
| sysmaps_links |
| timeperiods |
| trends |
| trends_uint |
| trigger_depends |
| trigger_discovery |
| triggers |
| user_history |
| users |
| users_groups |
| usrgrp |
| valuemaps |
-----------------------
103 rows in set (0.01 sec)
PKG_INFO
zabbix-frontend-1.8.13,2
zabbix2-agent-2.0.6_1
zabbix2-server-2.0.5
php5-5.4.17
php5-mysql-5.4.14
php5-mssql-5.4.17
mysql-client-5.5.31
mysql-server-5.5.31
Please help me with my issue, thanks in advase!
