We are trying to set up a ticket request application on a Solaris 9 (SPARC) server.
http://wiki.bestpractical.com/index.cgi?SolarisInstallGuide
Apache has been configured and MySQL 4.1.12 was installed.
Now the issue is with Initial RT configuration. When we try to initialize the RT's database it is returning the following error.
# make initialize-database
/usr/local/bin/perl //usr/local/rt3/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:
Now creating a database for RT.
Creating mysql database rt3.
Now populating database schema.
Creating database schema.
Problem with statement:
CREATE TABLE Attachments (
id INTEGER NOT NULL AUTO_INCREMENT,
TransactionId integer NOT NULL ,
Parent integer NOT NULL DEFAULT 0 ,
MessageId varchar(160) NULL ,
Subject varchar(255) NULL ,
Filename varchar(255) NULL ,
ContentType varchar(80) NULL ,
ContentEncoding varchar(80) NULL ,
Content LONGTEXT NULL ,
Headers LONGTEXT NULL ,
Creator integer NOT NULL DEFAULT 0 ,
Created DATETIME NULL ,
PRIMARY KEY (id)
) TYPE=InnoDB
Table 'Attachments' already exists at //usr/local/rt3/sbin/rt-setup-database line 205.
make: *** [initialize-database] Error 255
#
MySQL password is not yet set and will be set after this step.
What is this "Error 255". Few postings are there on the net and we could not find the right solution. Your help is apprecaited.
Thanks in advance