[rt-users] Connecting to the MySQL CLI

[William Ritchie]

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 at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users

C