LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 01-24-2011, 05:41 AM   #1
procfs
Member
 
Registered: Jan 2006
Location: Sri Lanka
Posts: 636

Rep: Reputation: 34
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
 
Old 07-08-2012, 01:12 PM   #2
procfs
Member
 
Registered: Jan 2006
Location: Sri Lanka
Posts: 636

Original Poster
Rep: Reputation: 34
Hi tha management wanted to use Oracle and works fine, sad could not find what was going on this this
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
mysql database error satish Linux - Server 3 05-11-2010 02:37 AM
Error install MySql initial database r3cursive Slackware 11 03-31-2009 03:59 PM
mysql database error Peter Shepard Ubuntu 1 06-06-2007 12:56 PM
Azureus database not initializing arterius Debian 2 01-22-2006 06:06 AM
mysql database error Tredo Linux - Security 7 11-26-2004 03:12 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 02:13 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration