Connecting to the MySQL CLI

RT Users
1

Hi

I have some problems, I intend to write a perl script to access my
companys RT’s mysql server,

query it and pump out stats to which are mailed to every individual
using RT on a friday afternoon.

The problem I am having is, that the password access to the mysql
database is unknown.

I didn’t install the rt system. I downloaded a version of RT to look at
the default passwords in the

Makefile, I have tried these but to no use, using the format from the
FAQ and the Makefile:

mysql -u root -p -h localhost rt
password: My!word%z0t

but couldn’t access it.

Looked at the /etc/config.pm to glean anything but no use there.

Is there anyway to access the database, also is there any way to find
out the name of the Mysql database that RT is using.

Machine Details:

Linux 2.2.14-5.0
MySql Server version 3.22.32
perl, version 5.005_03
Apache Web Server
No patches installed

Thanks

will

2

your local RT admin should be able to tell you the password. It’s
kept in rt/etc/config.pm.

    -jOn Fri, Jun 15, 2001 at 05:36:26PM +0100, William Ritchie wrote:

Hi

I have some problems, I intend to write a perl script to access my
companys RT’s mysql server,

query it and pump out stats to which are mailed to every individual
using RT on a friday afternoon.

The problem I am having is, that the password access to the mysql
database is unknown.

I didn’t install the rt system. I downloaded a version of RT to look at
the default passwords in the

Makefile, I have tried these but to no use, using the format from the
FAQ and the Makefile:

mysql -u root -p -h localhost rt
password: My!word%z0t

but couldn’t access it.

Looked at the /etc/config.pm to glean anything but no use there.

Is there anyway to access the database, also is there any way to find
out the name of the Mysql database that RT is using.

Machine Details:

Linux 2.2.14-5.0
MySql Server version 3.22.32
perl, version 5.005_03
Apache Web Server
No patches installed

Thanks

will

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

jesse reed vincent – root@eruditorum.org – jesse@fsck.com
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

And I’m told we do share some common rituals. Our “flame war” is apparently
held in person in their land and called “project meeting”.
-Alan Cox [on “Suits”]

3

Cancel last request,

the owner ‘remembered’ the access info and got me access, at which stage,
I am now doing the

perl script to mail RT IS request statistics to RT users.

Thanks

will

William Ritchie wrote:

Hi

I have some problems, I intend to write a perl script to access my
companys RT’s mysql server,

query it and pump out stats to which are mailed to every individual
using RT on a friday afternoon.

The problem I am having is, that the password access to the mysql
database is unknown.

I didn’t install the rt system. I downloaded a version of RT to look at
the default passwords in the

Makefile, I have tried these but to no use, using the format from the
FAQ and the Makefile:

mysql -u root -p -h localhost rt
password: My!word%z0t

but couldn’t access it.

Looked at the /etc/config.pm to glean anything but no use there.

Is there anyway to access the database, also is there any way to find
out the name of the Mysql database that RT is using.

Machine Details:

Linux 2.2.14-5.0
MySql Server version 3.22.32
perl, version 5.005_03
Apache Web Server
No patches installed

Thanks

will

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

C