Initial RT Configuration Post: 76088

Sponsored Content

Top Forums UNIX for Advanced & Expert Users Initial RT Configuration Post 76088 by chrs0302 on Friday 24th of June 2005 10:47:25 AM

06-24-2005

Registered User

Initial RT Configuration

We are trying to set up a ticket request application on a Solaris 9 (SPARC) server.
http://wiki.bestpractical.com/index....isInstallGuide

Apache has been configured and MySQL 4.1.12 was installed.
http://www.sun.com/bigadmin/features...q_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...q_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

chrs0302

View Public Profile for chrs0302

Find all posts by chrs0302

5 More Discussions You Might Find Interesting

1. Solaris

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...

2. AIX

Not getting the initial Firmware prompt

Hi All.. Well I have a prob. Last day I Installed AIX 5.3 on a P550, the installation went fine and I am able to login and perform my activities. But today I noticed one thing. Whenever I reboot the server, am not getting the initial firmware menu from where I could select the boot devices and...

3. Solaris

zfs initial install

Can anyone tell me why /export and /export/home are showing up after an install? I'm assuming it's reading from the old default filesystem layout during installs but I don't see anywhere to change that. Thanks in advance, df -hF zfs Filesystem size used avail capacity ...

4. Shell Programming and Scripting

initial setup for iconv

hi I am trying iconv on my linux machine for conversion of RUSSIAN to ENGLISH, but i am not able to get exact result. i want to know what initial setting in linux machine we need to do to get desired output I created sample russian file using google translate in CP866 endcoding and full...

5. Shell Programming and Scripting

Removing all characters up to initial '{'

Hi there, Im having a bit of difficulty with this one and I suspect its because of the character I want to match against maybe causing me a problem, but i wanted to remove everything up to (but not including) the first instance of '{' in a string so for example the string that I want to...

LEARN ABOUT SUSE

apache::session::lock::mysql

Session::Lock::MySQL(3) 				User Contributed Perl Documentation				   Session::Lock::MySQL(3)

NAME

       Apache::Session::Lock::MySQL - Provides mutual exclusion using MySQL

SYNOPSIS

	use Apache::Session::Lock::MySQL;

	my $locker = Apache::Session::Lock::MySQL->new();

	$locker->acquire_read_lock($ref);
	$locker->acquire_write_lock($ref);
	$locker->release_read_lock($ref);
	$locker->release_write_lock($ref);
	$locker->release_all_locks($ref);

DESCRIPTION

       Apache::Session::Lock::MySQL fulfills the locking interface of Apache::Session.	Mutual exclusion is achieved through the use of MySQL's
       GET_LOCK and RELEASE_LOCK functions.  MySQL does not support the notion of read and write locks, so this module only supports exclusive
       locks.  When you request a shared read lock, it is instead promoted to an exclusive write lock.

CONFIGURATION

       The module must know how to connect to your MySQL database to acquire locks.  You must provide a datasource name, a user name, and a
       password.  These options are passed in the usual Apache::Session style, and are very similar to the options for
       Apache::Session::Store::MySQL.  Example:

	tie %hash, 'Apache::Session::MySQL', $id, {
	    LockDataSource => 'dbi:mysql:database',
	    LockUserName   => 'database_user',
	    LockPassword   => 'K00l'
	};

       Instead, you may pass in an already opened DBI handle to your database.

	tie %hash, 'Apache::Session::MySQL', $id, {
	    LockHandle => $dbh
	};

AUTHOR

       This module was written by Jeffrey William Baker <jwbaker@acm.org>.

SEE ALSO

       Apache::Session

perl v5.12.1							    2008-01-08						   Session::Lock::MySQL(3)