Error Installing AT - Make initdb

[Ralph]

Hello,

I'm trying to install AT, but it's failing at the make initdb command:

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' at line 12 at /opt/rt4/sbin/../
lib/RT/Handle.pm line 517.
...returned with error: 65280
make: *** [initdb] Error 2

My system: SUSE Linux 11 SP1 64 bit. I have RT 4.0.2 installed. MySQL
5.5.16, Apache 2.2.21.

Any suggestions?

Thanks!
Ralph

[Darin Perusich]

You can always call "rt-setup-database" to initialize the AT database. This is what I ran when I setup AT on my system...you'll need to set the --datadir to the wherever AT's been installed.

rt-setup-database --action schema --dba rt_user --prompt-for-dba-password --datadir /usr/share/request-tracker/local/plugins/RTx-AssetTracker/etc/
rt-setup-database --action acl --dba rt_user --prompt-for-dba-password --datadir /usr/share/request-tracker/local/plugins/RTx-AssetTracker/etc/

--
Later,
Darin

Ralph

--
You received this message because you are subscribed to the Google Groups "at-users" group.
To post to this group, send email to at-u...@googlegroups.com.
To unsubscribe from this group, send email to at-users+u...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/at-users?hl=en.

[Ralph Arbelo]

It still fails:

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' at line 12 at /opt/rt4/sbin/../lib/RT/Handle.pm line 517.

--
"Be polite to all, but intimate with few."
-Thomas Jefferson

[Ralph Arbelo]

Sorry, my previous message got chopped off. Here's the error:

Working with:

Type: mysql

Host: localhost

Name: rt4

User: rt_user

DBA: rt_user

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' at line 12 at /opt/rt4/sbin/../lib/RT/Handle.pm line 517.

[Aaron Zuercher]

Hi,
I'm not an expert  but sounds like some mysql requirement is missing?  possibly innodb support? googling Request Tracker and innodb brings up some threads.  check to see if you have all the required pieces installed.

Aaron

[Ralph Arbelo]

Ok, I figured out the problem. I had to edit plugins/RTx-AssetTracker/etc/schema.mysql and do a global search and replace. Any instance of TYPE  was changed to ENGINE (so instead of TYPE=InnoDB it's ENGINE=InnoDB). I then ran the two commands you gave me and they ran successfully. 

I guess this is an issue with certain versions of MySQL:

http://comments.gmane.org/gmane.comp.bug-tracking.request-tracker.user/60593

I'm running 5.5.16-1

Thanks for your help with this.

Ralph

[Fredrik Normann]

Hey,

Thanks for this helpfull tip!

-f-