ERROR: Database corrupted, missed default user 'guest' (in 1.4.2)

[sebelk]

First,

After installation in Mandriva 2008 I can't login because it appears message of the subject.

I don't know why. I've created user zabbix, run cat mysql.sql | mysql -uzabbix -p zabbix and follow the wizard, but zabbix won't work.


I am using mysql 5.0.45-7. Also I've downloaded tarball package and compared Mandriva RPM db.inc.php with tarball 1.4.2. db.inc.php and there are no differences :'-(

I don't knot what to do. Please could you help me to solve it?

Thanks in advance!!

[sebelk]

Sorry I forget to use:
cat create/data.sql | mysql -uzabbix -ppassword zabbix


But, oddly, zabbix still doesn't work

I can't login, logs looks as follows:

21659:20071207:000712 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 i.nextcheck<=1196996832 and i.status in (0,3) and i.type not in (2,7,9) and h.status=0 and h.disable_until<=1196996832 and h.errors_from=0 and h.hostid=i.hostid and mod(i.itemid,5)=1 and i.key_ not in ('status','icmpping','icmppingsec','zabbix[log]') and h.hostid>=100000000000000*0 and h.hostid<=(100000000000000*0+99999999999999) order by i.nextcheck
21659:20071207:000712 Query failed:Unknown column 'h.dns' in 'field list' [1054]

[Niels]

Looks like you still haven't initialized the database properly. I'd start over: Clean the database and import the three (not two) sql files.