|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Initial RT Configuration
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. http://www.sun.com/bigadmin/features/articles/req_track_1.html Now the issue is with Initial RT configuration. When we try to initialize the RT's database it is returning the following error. http://www.sun.com/bigadmin/features/articles/req_track_2.html # 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 |
|
#2
|
|||
|
|||
|
For whatever reason there is already a table named 'Attachments'. If this is the second or third time you've tried this install and it doesn't rollback changes on error, it is possible that some tables already exist.
|
|
#3
|
|||
|
|||
|
RT Configuration
Hi Jim
Thanks for the good idea. |
![]() |
| Viewing: Dev Shed Forums > Operating Systems > UNIX Help > Initial RT Configuration |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|