can't create ZABBIX database with Sqlite3 on 1.3.4beta

[Jun.Liu]

hi, expert
I had untar the zabbix-1.3.4 on RHEL4.1 and installed the Sqlite3 (3.3.15). then I following the document to create the database for zabbix as below:

[root@localhost opt]# cd zabbix-1.3.4/
[root@localhost zabbix-1.3.4]#
[root@localhost zabbix-1.3.4]# pwd
/opt/zabbix-1.3.4
[root@localhost zabbix-1.3.4]# cd create
[root@localhost create]# ls
data Makefile.am Makefile.in schema
[root@localhost create]# cd schema
[root@localhost schema]# ls
Makefile.am Makefile.in mysql.sql oracle.sql postgresql.sql sqlite3.sql
[root@localhost schema]# cat sqlite3.sql
Usage: ./gen.pl [c|mysql|oracle|php|postgresql|sqlite]
The script generates ZABBIX SQL schemas and C/PHP code for different database engines.
[root@localhost schema]#


it's obvious that the sqlite3.sql is not a sql script. and I can't find the gen.pl script under the zibbix-1.3.4. Is anything wrong with the sqlite.sql ? anyone can help? thanks beforehand!

[Alexei]

Thanks for reporting this. Fixed in pre 1.3.5. In order to generate Sqlite schema run:

./gen.pl sqlite >sqlite3.sql

[Jun.Liu]

hi, alexei
I can't find the gen.pl at $ZABBIX_HOME/create/scheme/ where is it located?

[Alexei]

I forgot to mention that the script is not part of standard ZABBIX distro. It can be found in our Subversion repository at svn://svn.zabbix.com/trunk