SQL syntax error when creating database

RT Users
1

I am getting the following error when attempting to create the database:

sudo /usr/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:
User: rtuser
DBA: root
Now creating a mysql database for RT.
Couldn’t finish ‘create’ step.

ERROR: 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 ‘’ at line 1

2

I am getting the following error when attempting to create the database:

It appears you’re using one of the packaged versions of RT?
You also didn’t include an RT version or a mysql version.

You may get more information out of RT by setting
Set($LogToScreen, ‘debug’) in your RT_SiteConfig.pm

-kevin

3

Yes, I am attempting to install packaged version 3.8 for Ubuntu on 11.04
64 bit
mysql Ver 14.14 Distrib 5.1.54, for debian-linux-gnu (x86_64) using
readline 6.2

LogToScreen did not provide anymore verbose error messages.

4

Yes, I am attempting to install packaged version 3.8 for Ubuntu on
11.04 64 bit
mysql Ver 14.14 Distrib 5.1.54, for debian-linux-gnu (x86_64) using
readline 6.2

LogToScreen did not provide anymore verbose error messages.

Don’t the ubuntu packages create the database for you?
BTW your command output implies that your DatabaseName is unset.
Presumably that’s because you stopped the package install partway
through and don’t have a full config?

-kevin

5

BTW your command output implies that your DatabaseName is unset.

I started over and have gotten past the database error. It seems it was
not picking up on the name because of a typo (just guessing).

Thank you