We have been testing out RT 3.8.8 for the last couple of months on a test
machine and find that it is going to help us. Now that we are ready to put
RT in production we are installing 3.8.9 on the production machine as we
want to have the latest bug fixes and improvements. I am running into a
problem while initializing the database:
Working with:
Type: mysql
Host: localhost
Name: rt3
User: rt_user
DBA: sqladmin
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
/usr/local/src/rt-3.8.9/sbin/…/lib/RT/Handle.pm line 515.
I knew from my 3.8.8 install that I needed to change the schema from
“TYPE=InnoDB” to “ENGINE=InnoDB” and I did that both in
./etc/schema.mysql-4.0 and ./etc/schema.mysql-4.1. I am using mysql version
5.5.10 (I used 5.5.8 on my test machine). Any insight would be appreciated
Regards,
Paul
Paul Fincher
Senior Engineering Support Engineer
Green Hills Software - blocked::http://www.ghs.com/http://www.ghs.com
34125 US Hwy 19 North Suite 100
Palm Harbor, FL 34684
(727) 781-4909
I knew from my 3.8.8 install that I needed to change the schema from "TYPE=InnoDB" to
“ENGINE=InnoDB” and I did that both in ./etc/schema.mysql-4.0 and ./etc/schema.mysql-4.1. I
am using mysql version 5.5.10 (I used 5.5.8 on my test machine). Any insight would be
appreciated
I suspect you changed them after typing make install and that you
actually need to fix /opt/rt3/etc/schema.mysql-4.1
I knew from my 3.8.8 install that I needed to change the schema from
“TYPE=InnoDB” to
“ENGINE=InnoDB” and I did that both in ./etc/schema.mysql-4.0 and
./etc/schema.mysql-4.1. I
am using mysql version 5.5.10 (I used 5.5.8 on my test machine). Any
insight would be
appreciated
I suspect you changed them after typing make install and that you actually
need to fix /opt/rt3/etc/schema.mysql-4.1
Thanks you are right. I had written down that I changed the schema
(from when installing 3.8.8 when I went digging through the list and found
the solution) but didn’t make note of when or where I changed them.
Thanks again!
Paul
-----Original Message-----
From: rt-users-bounces lists.bestpractical.com
[mailto:rt-users-bounces lists.bestpractical.com] On Behalf Of Kevin
Falcone
Sent: Thursday, March 24, 2011 6:06 PM
To: rt-users lists.bestpractical.com
Subject: Re: [rt-users] RT 3.8.9 Installation
I knew from my 3.8.8 install that I needed to change the schema from
“TYPE=InnoDB” to
“ENGINE=InnoDB” and I did that both in ./etc/schema.mysql-4.0 and
./etc/schema.mysql-4.1. I
am using mysql version 5.5.10 (I used 5.5.8 on my test machine). Any
insight would be
appreciated
I suspect you changed them after typing make install and that you actually
need to fix /opt/rt3/etc/schema.mysql-4.1
-kevin
Hey Guys
I have searched all over for the fix for
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 /tmp/rt-
3.8.10/sbin/…/lib/RT/Handle.pm line 516.
make: *** [initialize-database] Error 255
i have already changed all instances of TYPE=InnoDB to ENGINE=InnoDB in my
/opt/rt3/etc/schema.mysql-4.1
but the error persists.
i am trying to install rt 3.8.10 on ubuntu 12.04
mysql version is 5.5.29
Perhaps if someone has an idea how i can fix this i would really appreciate the
help
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 /tmp/rt-
3.8.10/sbin/…/lib/RT/Handle.pm line 516.
make: *** [initialize-database] Error 255
i have already changed all instances of TYPE=InnoDB to ENGINE=InnoDB in my
/opt/rt3/etc/schema.mysql-4.1
but the error persists.
i am trying to install rt 3.8.10 on ubuntu 12.04
mysql version is 5.5.29
Perhaps if someone has an idea how i can fix this i would really appreciate the
Why are you installing 3.8.10?
The current release of RT is 4.0.10, the current release of the 3.8
series is 3.8.16 (and both include fixes for this).
Your problem is likely because you are editing the file in
/opt/rt3/etc/schema.mysql-4.1 rather than
/tmp/rt-3.8.10/etc/schema.mysql-4.1 but that doesn’t explain
installing a version of RT which has multiple known security flaws.
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 /tmp/rt-
3.8.10/sbin/…/lib/RT/Handle.pm line 516.
make: *** [initialize-database] Error 255
i have already changed all instances of TYPE=InnoDB to ENGINE=InnoDB in my
/opt/rt3/etc/schema.mysql-4.1
but the error persists.
i am trying to install rt 3.8.10 on ubuntu 12.04
mysql version is 5.5.29
Perhaps if someone has an idea how i can fix this i would really appreciate
the
Why are you installing 3.8.10?
The current release of RT is 4.0.10, the current release of the 3.8
series is 3.8.16 (and both include fixes for this).
Your problem is likely because you are editing the file in
/opt/rt3/etc/schema.mysql-4.1 rather than
/tmp/rt-3.8.10/etc/schema.mysql-4.1 but that doesn’t explain
installing a version of RT which has multiple known security flaws.
-kevin
Hi Kevin
Thanks i really appreciate the help. just to let you know i did a dist upgrade
then installed rt 4.0 and managed to get past this error.
But later when editing my /etc/apache2/sites-available/rt4
<VirtualHost rt4.example.com>
### Optional apache logs for RT
# Ensure that your log rotation scripts know about these files
# ErrorLog /opt/rt4/var/log/apache2.error
# TransferLog /opt/rt4/var/log/apache2.access
# LogLevel debug
AddDefaultCharset UTF-8
Alias /NoAuth/images/ /opt/rt4/share/html/NoAuth/images/
ScriptAlias / /opt/rt4/sbin/rt-server.fcgi/
DocumentRoot "/opt/rt4/share/html"
<Location />
Order allow,deny
Allow from all
Options +ExecCGI
AddHandler fastcgi-script fcgi
</Location>
</VirtualHost>
i cannot get my browser to open the rt default page.
You’ve not provided any apache error logs or errors from your browser.
Without that, we can’t possibly guess the problem.
You’ve also left rt4.example.com as the virtualhost name, is that
correct for your environment?
<VirtualHost rt4.example.com>
### Optional apache logs for RT
# Ensure that your log rotation scripts know about these files
# ErrorLog /opt/rt4/var/log/apache2.error
# TransferLog /opt/rt4/var/log/apache2.access
# LogLevel debug
AddDefaultCharset UTF-8
Alias /NoAuth/images/ /opt/rt4/share/html/NoAuth/images/
ScriptAlias / /opt/rt4/sbin/rt-server.fcgi/
DocumentRoot "/opt/rt4/share/html"
<Location />
Order allow,deny
Allow from all
Options +ExecCGI
AddHandler fastcgi-script fcgi
</Location>
</VirtualHost>
i cannot get my browser to open the rt default page.
You’ve not provided any apache error logs or errors from your browser.
Without that, we can’t possibly guess the problem.
You’ve also left rt4.example.com as the virtualhost name, is that
correct for your environment?
-kevin
Hi Kevin
No rt4.example.com is not what i used i actually created /etc/apache2/sites-
available/rt4 with that code with the <VirtualHost *:80>
i enabled it and disabled default.
While trying to solve the problem i ran into you on another on of your threads