RT mysql database initializing error
 

Hi I am trying to get Mysql databse initialized using make initialize-database and getting following error

/usr/local/bin/perl -I/usr/local/rt-3.8.8/local/lib -I/usr/local/rt-3.8.8/lib sbin/rt-setup-database --action init --dba root --prompt-for-dba-password
In order to create or update your RT database, this script needs to connect to your mysql instance on localhost as root
Please specify that user's database password below. If the user has no database
password, just press return.

Password:
Working with:
Type: mysql
Host: localhost
Name: rt3
User: root
DBA: root
Now creating a mysql database rt3 for RT.
Done.
Now populating database schema.
DBD::mysql::st execute failed: 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 'TYPE=InnoDB CHARACTER SET utf8' at line 15 at /home/RT_installs/rt-3.8.8/sbin/../lib/RT/Handle.pm line 506.
make: *** [initialize-database] Error 255


My systems details as below
OS - RedHat 5.4 (64 bit)
Mysql - MySQL-server-5.5.8-1.rhel5
Perl - 5, version 12, subversion 2 (v5.12.2) built for x86_64-linux
Apache - Apache/2.2.17
Mode_perl - 2.0.4

Appreciate any help that you can give em

Thanks & best Regards

Hi tha management wanted to use Oracle and works fine, sad could not find what was going on this this