[rt-users] Connecting to the MySQL CLI
jesse at fsck.com
Thu Jun 21 12:55:33 EDT 2001
your local RT admin should be able to tell you the password. It's
kept in rt/etc/config.pm.
On Fri, Jun 15, 2001 at 05:36:26PM +0100, William Ritchie wrote:
> 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
> rt-users mailing list
> rt-users at lists.fsck.com
jesse reed vincent -- root at eruditorum.org -- jesse at 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"]
More information about the rt-users