FW: [rt-users] Help with mysql tables rt2 -> rt3

Stefan Leblanc sleblanc at radicalhorizon.com
Thu Apr 22 13:47:24 EDT 2004



-----Original Message-----
From: Stefan Leblanc 
Sent: Thursday, April 22, 2004 1:46 PM
To: 'Dave Dennis'
Cc: 'rt-users-bounces at lists.bestpractical.com'
Subject: RE: [rt-users] Help with mysql tables rt2 -> rt3


You could try this one..

MySql.org is my preferate site for this kind of things..

SL

-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com]On Behalf Of Dave
Dennis
Sent: Thursday, April 22, 2004 1:04 PM
To: pdh at bestpractical.com
Cc: RT Users
Subject: Re: [rt-users] Help with mysql tables rt2 -> rt3


Dear PDH,

Great, that narrows the focus significantly, thanks.

If anyone has link to where at mysql.com describes this
it would be greatly appreciated.  Or what terms to search
under with their engine.. Still searching...

Kind regards,

+-------------------------
+ Dave Dennis
+ Seattle, WA
+ dmd at speakeasy.org
+ http://www.dmdennis.com
+-------------------------

On Thu, 22 Apr 2004 pdh at bestpractical.com wrote:

> Dave Dennis wrote:
> > however in the RT3 server (3.0.9, mysql 4.0.17)
> > I somehow managed to put up a working RT3 install
> > that has no mysql tables.  Not sure how, but here is what happens:
>
> RT3 uses the "rt3" database. The "mysql" database is none of
> its concern (aside from providing the required rt_user account
> for RT to access the rt3 database, that is...)
>
> > mysql > use mysql;
> > ERROR 1044: Access denied for user: 'root at localhost' to database 'mysql'
>
> Someone has deleted root at localhost's access to the database.
> That's not an RT problem, however www.mysql.com does tell
> you how to recover from problems like that.
>
> > We are thinking of standing up a different mysql 4.0.17 server,
> > tarring cvf /var/lib/mysql/mysql.tar /var/lib/mysql/mysql
> > then tar xvf that same tarfile back on top of the existing
> > mysql install with the fully configured rt3 .
>
> That would be bad. It might work, it might not, and it would
> certainly cause your RT3 instance to become unusable.
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> RT Developer and Administrator training is coming to LA, DC and Frankfurt this spring and summer.
> http://bestpractical.com/services/training.html
>
> Sign up early, as class space is limited.
>
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

RT Developer and Administrator training is coming to LA, DC and Frankfurt this spring and summer.
http://bestpractical.com/services/training.html

Sign up early, as class space is limited. 



More information about the rt-users mailing list