Kevin Falcone <falcone <at> bestpractical.com> writes: > > On Thu, Feb 14, 2013 at 08:30:46AM +0000, Martin wrote: > > 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 > > 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 as below FastCgiServer /opt/rt4/sbin/rt-server.fcgi -processes 5 -idle-timeout 300 <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. -- RT training in Amsterdam, March 20-21: http://bestpractical.com/services/training.html Help improve RT by taking our user survey: https://www.surveymonkey.com/s/N23JW9T