rt-setup-database(8) Request Tracker Reference rt-setup-database(8)NAME
rt-setup-database - Set-up the database for Request Tracker
SYNOPSIS
rt-setup-database --action ...
OPTIONS
action
Several actions can be combined using comma separated list.
init
Initialize the database. This is combination of multiple actions listed below. Create DB, schema, setup acl, insert core data and
initial data.
upgrade
Apply all needed schema/acl/content updates (will ask for version to upgrade from)
create
Create the database.
drop
Drop the database. This will ERASE ALL YOUR DATA.
schema
Initialize only the database schema
To use a local or supplementary datafile, specify it using the '--datadir' option below.
acl Initialize only the database ACLs
To use a local or supplementary datafile, specify it using the '--datadir' option below.
coredata
Insert data into RT's database. This data is required for normal functioning of any RT instance.
insert
Insert data into RT's database. By default, will use RT's installation data. To use a local or supplementary datafile, specify it
using the '--datafile' option below.
datafile
file path of the data you want to action on
e.g. "--datafile /path/to/datafile"
datadir
Used to specify a path to find the local database schema and acls to be installed.
e.g. "--datadir /path/to/"
dba dba's username
dba-password
dba's password
prompt-for-dba-password
Ask for the database administrator's password interactively
skip-create
for 'init': skip creating the database and the user account, so we don't need administrator privileges
root-password-file
for 'init' and 'insert': rather than using the default administrative password for RT's "root" user, use the password in this file.
perl v5.14.2 2013-05-22 rt-setup-database(8)
Check Out this Related Man Page
mysql_import_combined_log.pl(1) General Commands Manual mysql_import_combined_log.pl(1)NAME
mysql_import_combined_log.pl - Imports an Apache combined log into a MySQL database.
SYNOPSIS
mysql_import_combined_log.pl -d <database name> -t <table name> [-h <host name>] [-u <user name>] [-p <password>] [-f <filename>]
OPTIONS
--host|-h <host name>
The host to connect to. Default is localhost.
--database|-d <database name>
The database to use. Required.
--username|-u <username>
The user to connect as.
--password|-p <password>
The user's password.
--table|-t <table name>
The name of the table in which to insert data.
--logfile|-f <file name>
The file to read from. If not given, data is read from stdin.
--help|-?
Print out this help message.
--version
Print out the version of this software.
AUTHOR
Aaron Jenson
Updated to work under Perl 5.6.1 by Edward Rudd
MAN PAGE CREATED BY
Michael A. Toth <lirul.lists@gmail.com> - based on content of script
COMMENTS
This man page was written using xml2man (1) by the same author.
Manuals User mysql_import_combined_log.pl(1)
check this out
ls -l nmo*
-rwsr-s--- 1 root dba 19312 Mar 31 14:44 nmo
-rw-r----- 1 oracle dba 0 May 19 2004 nmo0
-rwxr-x--- 1 oracle dba 16512 Mar 31 14:44 nmocat
# rm nmo0
nmo0: No such file or directory
# id
uid=0(root) gid=1(other)
what... (8 Replies)
Hi,
I have a datafile which has the following data and it can have much more records. The data set is as follows:
ISA~00~ ~00~ ~ZZ~F159B ~ZZ~U1CAD ~051215~184
3~U~00200~000011432~0~P~<
GS~FA~TC11A~U1CAD~051215~1843~000011432~X~002002
ST~997~0001... (6 Replies)
I am using this command to replace a text string in a data file:
sed -e 's/ab/test2/g' -e 's/abcxyz/test1/g' datafile
datafile contains:
ab
abcxyz
My results:
test2
test2cxyz
I want my results to be:
test2
test1 (7 Replies)
Hi,
Is there any way we can find out which process is creating a partucular datafile.I know the user and group but i am just curios to know is there any way to find the process.
Thanks (7 Replies)
HI,
Can anybody tell me..about recovering windows administrator password in case of Forget it.
Now in Unix OS and any database,there is a fascility of recovering root/admin password....
Can window provide any such kind of fascility?....Also tell me any other normal users password recovery... (5 Replies)
Hi Guys
I need to have a shell script which reads a log file and insert a part of each line into the database. Some sample lines in the file are as below.
20091112091359 MED_RQACK : user_data=60173054304,100232120,20091112091359,;ask_status=0;ask_reason=OK;msg_id=20091112091319... (5 Replies)
Hi
We have 50 million records in mainframes DB2. We have a requirement to Record the Change Data Capture(CDC) records.
i.e New Records or Updated Records that were added into the DB2.
Unfortunately we dont have any column indicators to give the details of the changes made to the records.
... (8 Replies)
Hi,
on AIX 6.1 I have :
-rwx------ 1 oracle dba 1263 Dec 8 02:43 initMYDB.ora
-rwx------ 1 oracle dba 1263 Dec 16 10:44 initOURDB.ora
RINT------ 1 oracle dba 1263 Dec 16 10:42 initMYDB.ora
I havr never seen
RINT------
Do you know... (14 Replies)
I have a CSV file like this:
abc ,def ghi ,jkl
mno ,pqr stu ,vwx
Desired Output:
Field 1:
abc
mno
Field 2:
def ghi
pqr stu
Field 3:
jkl
vwx
This does not work:
for i in `cat file.txt`
do
Field1=`echo $i | awk -F ',' '{print $1}'| sed 's/^ *// ; s/ *$//'`... (8 Replies)
I have a datafile containing data in the following format
name1,employee_number1,cell1,home1,fax1
name2,employee_number2,cell2,home2,fax2
name3,employee_number3,cell3,home3,fax3
name4,employee_number4,cell4,home4,fax4
name5,employee_number5,cell5,home5,fax5
...
...
....
I would like... (6 Replies)
Hello Everyone,
I want to convert
Relative Path - /home/stevin/data/APP_SERVICE/../datafile.txt
to
Absolute Path - /home/stevin/data/datafile.txt
Is there a built-in tool in Unix to do this or any good ideas as to how can I implement this.
-Steve (5 Replies)
Hi,
I have a single value in insertval file. I want to load that value to database with the current date. I tried the below code but it is inserting <NULL> to database and echo $c is also null.
cat insertval | awk -F ' ' '{print $1}' > c
echo c=$c
data=`sqlplus -s user/pwd@hostname <<EOF ... (5 Replies)
Hi,
Strange problem I'm having here and not sure what to do.
I have here a xml that is supposed to execute the next value in the schema but it isn't do the job it's supposed to do. I'm not a dba or a developer so I'm sorry in advance if there are some things i don't understand.
when we run... (5 Replies)
Hi Gents,
What is the best way to create a web interface for mysql database? That I can manage my data for root user and for normal user as well according to their privileges? Assuming that I use Linux as a server and Apache as a web server and my database is mysql.
Thanks in advance (5 Replies)
Hello All,
I hope I'm posting this in the right section.
I have zero sql query writing skill, in fact, I've never done it before, but for some reason, a request came across my desk to get information from one of our databases. I have about 200 ticket numbers that have no information attached,... (8 Replies)