[rt-users] SQL fix

[Matt Disney]

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! ;-)

Matt

"Alexander, John" writes:
>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 at 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
>
>
>
>_______________________________________________
>rt-users mailing list
>rt-users at lists.fsck.com
>http://lists.fsck.com/mailman/listinfo/rt-users
>