MySQL error during install

[cstackpole]

I am not sure if this is a bug or something I did so I wanted to see what others thought.
I pulled the code from the SVN yesterday and am attempting to build the 1.4.2 code.
I am using the PDF for a guide (release 009) on Debian Lenny and MySQL reports its version as: 5.0.45-Debian_1

A copy and paste from the PDF (page 38 on my copy) says:
For MySQL:
shell> mysql -u<username> -p<password>
mysql> create database zabbix;
mysql> quit;
shell> cd create/schema
shell> cat mysql.sql | mysql -u<username> -p<password> zabbix
...

All goes well until that last bit. First there is no mysql.sql in that directory but a quick search on the forum (looking through other how-tos and posts) makes me think that the PDF has not been updated yet as others appear to have-used/use schema.sql which is in the directory. So I run the command and I get this error:
DevTest:~/zabbix/tags/1.4.2/create/schema# cat schema.sql | mysql -uroot -p zabbix
Enter password:
ERROR 1064 (42000) at line 24: 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 'TABLE|slideshows|slideshowid|ZBX_SYNC
FIELD |slideshowid |t_id |'0' |NOT NULL ' at line 1


I have looked around the forum but did not see this error message from anyone else. This makes me believe that I have either done something silly and goofed it up or there might be a bug. Considering that I am stepping into new territory (for me anyway) I would not put it past me to have made a mistake somewhere so I thought I would ask first.

Let me know if there is something else I can do.
Thanks,
cstackpole

[swaterhouse]

There is someting you need to do to prep the release from the svn code. I forget what it is.

Anyway there is a nightly build posted to the developers page very day so you might want to try that instead.

http://www.zabbix.com/developers.php

[cstackpole]

Heh. Its amazing how well things work when you do it right
I am just now trying to get my hands dirty and learn all the mysteries of the Zabbix code so I appreciate the help.

Also, I noticed in the PDF on page 39 of Release 009 that the line:
./configure --enable-server --with-mysql --with-net-snmp –with-jabber –
with-libcurl

Should actually be:
./configure --enable-server --with-mysql --with-net-snmp --with-jabber --
with-libcurl

The second - is needed for jabber and libcurl.


Thanks for the help!
cstackpole