SQL fix

RT Users
1

For those of us who aren’t that conversant in issuing SQL statements to
MySQL, could someone lay out the steps to apply the SQL fix that Jesse has
published. I’m running RT 2.0.11 and cannot upgrade for some time.

John Alexander john.alexander@fortrex.com
Network Security Operations phone: 301-977-6966
Fortrex Technologies, Inc fax: 301-947-3539
Gaithersburg, MD
http://www.fortrex.com

Because Your Information is Your Business

2

I would recommend becoming familiar with mysql usage and routine
maintenance (indexes, dumps, etc…) if you are running RT. But
that doesn’t help you much right now, so below I’ll try and list
out the steps you can take to run the update.

Let’s say you have mysql installed in the prefix /usr/local/mysql.

You would run:
/usr/local/mysql/bin/mysql -u rt_db_user -p rt_db_name

… where “rt_db_user” is your RT database username and “rt_db_name”
is the database name for RT (I believe the default on that is rt2).
After you run this command, you’ll be prompted for a password. You
want to enter the RT database password. You can look in your RT’s
config.pm for these options. You may also need to pass the “-h”
flag along with the hostname of your mysql server. I guess I should
just say that depending on your setup, you may need additional
command line parameters to get into mysql.

After you get logged into mysql, you’ll be dropped into an
interactive mysql shell. That’s where you type the update statement
Jesse sent out:

update Users set Password = ‘LOCK’ where Password is null;

Type exit to quit mysql and that should do it.

Hope that helps and that I haven’t mislead you at all! (I feel pretty
confident about the info above, but follow at your own risk! :wink:

Matt

“Alexander, John” writes:

3

-----Original Message-----
From: Matt Disney [mailto:matthew.disney@fedex.com]
Sent: Thursday, March 28, 2002 7:56 AM
To: rt-users@lists.fsck.com
Subject: Re: [rt-users] SQL fix

After you get logged into mysql, you’ll be dropped into an
interactive mysql shell. That’s where you type the update statement
Jesse sent out:

update Users set Password = ‘LOCK’ where Password is null;

Type exit to quit mysql and that should do it.

If your mysql setup is like mine, you’ll have to do “use rt2;” first before
you can do that update statement. Otherwise it won’t know which database
you’re talking about.
Kendric Beachey

4

Beachey, Kendric wrote:

From: Matt Disney [mailto:matthew.disney@fedex.com]

After you get logged into mysql, you’ll be dropped into an
interactive mysql shell. That’s where you type the update statement
Jesse sent out:

update Users set Password = ‘LOCK’ where Password is null;

If your mysql setup is like mine, you’ll have to do “use rt2;” first
before you can do that update statement. Otherwise it won’t know
which database you’re talking about.

Ah, but part of Matt’s instructions that you snipped include:

/usr/local/mysql/bin/mysql -u rt_db_user -p rt_db_name

… where “rt_db_user” is your RT database username and “rt_db_name”
is the database name for RT (I believe the default on that is rt2).

Because “rt2” was specified at the end of the command line, ‘MySQL’ will
use that database.

Smylers
GBdirect