Ad Widget

**Alexei** · 15-03-2007, 18:25

Use 1.3.3 database schema.

**davidpe** · 15-03-2007, 19:40

Where is this 1.3.3 database schema? I see a patch.sql script in the source download in \upgrades\dbpatches\1.3\mysql. I looked at the script and it drops the tables and renames them to %tablename%_tmp. I'd rather not have to re-create my hosts and configurations.

**Alexei** · 15-03-2007, 19:51

The patch is for upgrade from 1.1.x. ZABBIX 1.3.3 schemas can be found in usual location in create/<db engine>/. Read documentation (PDF) for more details.

**davidpe** · 15-03-2007, 19:57

Ok, I'm using a fresh install of 1.3.3 so I am using the correct schema. Can I manually alter the correct table for this column 'configid' that is missing?

**davidpe** · 17-03-2007, 04:48

Anyone have any ideas about the missing 'configid' field?

**ghislain** · 18-03-2007, 11:02

i have the very same error after a fresh install of 1.3.3.

The upgrade script failed to upgrade 1.1.6 so i dropped the base and recreated using schemal.sql, data.sql and image.sql but zabbix dies with:

10519:20070318:021503 Query::select i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h .useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.ho stid,h.status,i.value_type,h.errors_from,i.snmp_po
rt,i.delta,i.prevorgvalue,i.lastclock,i.units,i.mu ltiplier,i.snmpv3_securityname,i.snmpv3_securityle vel,i.snmpv3_authpassphrase,i.snmpv3_privpassphras e,i.formula,h.available,i.status,i.trapper_hosts,i .logtimefmt,i.valuemapid,i.delay_flex
,h.dns from hosts h, items i where h.status=0 and h.hostid=i.hostid and h.host='aqueos.com' and i.key_='icmpping' and i.status=0 and i.type=3 and configid>=100000000000000*0 and configid<=(100000000000000*0+99999999999999)
10519:20070318:021503 Query failed:Unknown column 'configid' in 'where clause' [1054]
10493:20070318:021503 One child process died. Exiting ...

it must be missing something.

regards,
Ghislain.

**ghislain** · 18-03-2007, 11:09

i searched in the sql files and configid appears only in the config table, not in the host or item:

CREATE TABLE config (
configid bigint unsigned DEFAULT '0' NOT NULL,
alert_history integer DEFAULT '0' NOT NULL,
event_history integer DEFAULT '0' NOT NULL,
refresh_unsupported integer DEFAULT '0' NOT NULL,
work_period varchar(100) DEFAULT '1-5,00:00-24:00' NOT NULL,
alert_usrgrpid bigint unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (configid)
);

any idea ?

regards,
Ghislain.

**ghislain** · 20-03-2007, 15:47

patch to ./src/zabbix_server/pinger/pinger.c

i found the issue in the file:

./src/zabbix_server/pinger/pinger.c

i changed :

505: result = DBselect("select refresh_unsupported from config where " ZBX_COND_NODEID, LOCAL_NODE("configid"));

into
505: result = DBselect("select refresh_unsupported from config where " ZBX_COND_NODEID, LOCAL_NODE("h.hostid"));

and it works fine now , seems to be a typo in the code.

regards,
Ghislain.

**monsieurcanard** · 23-03-2007, 05:12

Just to confirm, I too used the 1.3.3 schema and have the very same problem. Will try correcting the code as above and recompiling :-)

Alexei, can you confirm that this fix has been committed?

Many thanks,
Matt

**Alexei** · 23-03-2007, 09:58

The problem has been fixed in pre-1.3.4. Replace 'configid' by 'h.hostid' as suggested to make it work.

**monsieurcanard** · 23-03-2007, 20:06

Thanks Alexei :-)

Ad Widget

icmpping simple check fails

icmpping simple check fails

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment