Mysql connection

I was just wondering what rt is using to connect to a Mysql database as my
rt1.0.7 is running perfectly but I cannot get a connection to mysql with any
of my other perl scripts. :frowning:

Matthew Frick wrote:

I was just wondering what rt is using to connect to a Mysql database as my
rt1.0.7 is running perfectly but I cannot get a connection to mysql with any
of my other perl scripts. :frowning:

DBI.

You can see my stats script as an example at

http://peabody.itd.uts.edu.au/rt2stats/

and the source at:

http://peabody.itd.uts.edu.au/rt2stats/dist/

Hope that helps.

T�o de Hesselle, | Kites rise highest against
Unix Systems Administrator | the wind – not with it.
|
University of Technology, Sydney | – Winston Churchill

Hello, just make sure you have these 4 variables well configured in your
other scripts… these variables are included in your
/path/to/rt/etc/config.pm.

host is the domain name of your database server

if it’s on localhost, leave it blank for enhanced performance

$DatabaseHost=“localhost”;

#The name of the database user (inside the database)
$DatabaseUser=“rt”;

Password the DatabaseUser should use to access the database

$DatabasePassword=“rtpassword”;

The name of the RT’s database on your database server

$DatabaseName=“rt2”;
Steve Poirier
Directeur d�veloppement / Project Manager
Inet-Technologies inc.From: “Matthew Frick” mfrick@learnedsolutions.com
To: “rt-users” rt-users@lists.fsck.com
Sent: Tuesday, August 21, 2001 10:11 PM
Subject: [rt-users] Mysql connection

I was just wondering what rt is using to connect to a Mysql database as my
rt1.0.7 is running perfectly but I cannot get a connection to mysql with
any
of my other perl scripts. :frowning:


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