Some troubble with mysql while installing zabbix

[hiacine]

Hi,

I just installed zabbix on CentOs 5.3

I folow this method :

http://robinbowes.com/article.php/20080730161131557

In the setup web interface, when I click on the finish button I have this error :

# mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/etc/zabbix/db.inc.php:411]
# Error in query [select n.nodeid,min(r.permission) as permission, g.userid from nodes n left join rights r on r.id=n.nodeid and r.type=0 left join users_groups g on r.groupid=g.usrgrpid and g.userid=0 where n.nodeid in (0) group by n.nodeid, g.userid order by nodeid desc, userid desc, permission desc] [Table 'zabbix.nodes' doesn't exist]
# mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/etc/zabbix/db.inc.php:411]
# mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/etc/zabbix/db.inc.php:411]
# Error in query [select n.nodeid,min(r.permission) as permission, g.userid from nodes n left join rights r on r.id=n.nodeid and r.type=0 left join users_groups g on r.groupid=g.usrgrpid and g.userid=0 where n.nodeid in (0) group by n.nodeid, g.userid order by nodeid desc, userid desc, permission desc] [Table 'zabbix.nodes' doesn't exist]
# mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/etc/zabbix/db.inc.php:411]
# mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/etc/zabbix/db.inc.php:411]
# Error in query [select n.nodeid,min(r.permission) as permission, g.userid from nodes n left join rights r on r.id=n.nodeid and r.type=0 left join users_groups g on r.groupid=g.usrgrpid and g.userid=0 where n.nodeid in (0) group by n.nodeid, g.userid order by nodeid desc, userid desc, permission desc] [Table 'zabbix.nodes' doesn't exist]
# mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/etc/zabbix/db.inc.php:411]
# mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/etc/zabbix/db.inc.php:411]

My Mysql user is root

Loggin is impossible.
And I'm unable to replay the zabbix web setup

[pesadilla]

[Table 'zabbix.nodes' doesn't exist]

mysql -uroot -p zabbix

type "show tables;"

[hiacine]

Yes,
Table is empty.

I've got mysql version : 5.0.45

But when i try to create the tables manualy from zabbix's source,
it tell me that there is an error in syntax.

[hiacine]

for example :

with this request whish is in mysql.sql

CREATE TABLE slideshows (
-> slideshowidbigint unsignedDEFAULT '0'NOT NULL,
-> namevarchar(255)DEFAULT ''NOT NULL,
-> delayintegerDEFAULT '0'NOT NULL,
-> PRIMARY KEY (slideshowid)
-> ) type=InnoDB;

i've got this error

ERROR 1064 (42000): 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 'unsignedDEFAULT '0'NOT NULL,
namevarchar(255)DEFAULT ''NOT NULL,
delayintegerDEF' at line 2

[hiacine]

The méthod was not good for creating tables.

here is the good method :

mysql -u root -p zabbix < /home/zabbix/zabbix-1.4/create/schema/mysql.sql

mysql -u root -p zabbix < /home/zabbix/zabbix-1.4/create/data/data.sql

mysql -u root -p zabbix < /home/zabbix/zabbix-1.4/create/data/images_mysql.sql

Now it works
thanks