[rt-users] Upgrade issue 3.0.10 to 3.6.6

[Winn Johnston]

check the permissions on the user rt at localhost

Try

mysql -urt -hlocalhost -pPASSWORD

once logged in try and create a db, and a table, then
insert some data into it. Your account may only have
read access.


-winn


--- Matt Grosland <grosland at mtsu.edu> wrote:

> Hi all,
> 
> When upgrading from 3.0.10 to 3.6.6, I followed the
> upgrade file and  
> did the following:
> 
>          @echo "   
> $(RT_SBIN_PATH)/rt-setup-database --dba $(DB_DBA)  
> --prompt-for-dba-passwor
> d --action schema --datadir etc/upgrade/<version>"
>          @echo "   
> $(RT_SBIN_PATH)/rt-setup-database --dba $(DB_DBA)  
> --prompt-for-dba-passwor
> d --action acl --datadir etc/upgrade/<version>"
>          @echo "   
> $(RT_SBIN_PATH)/rt-setup-database --dba $(DB_DBA)  
> --prompt-for-dba-passwor
> d --action insert --datadir etc/upgrade/<version>"
> 
> The first two worked fine on the first directory
> (3.1.0).  When I did  
> the 'insert' command for the 3.1.0 upgrade
> directory, however, I got  
> this:
> 
> 
> DBI connect('dbname=rt3;host=localhost','rt',...)
> failed: Access  
> denied for user 'rt'@'localhost' (using password:
> YES) at /Library/ 
> Perl/5.8.6/DBIx/SearchBuilder/Handle.pm line 106
> Connect Failed Access denied for user
> 'rt'@'localhost' (using  
> password: YES)
>   at /opt/rt3/lib/RT.pm line 220
> 
> I didn't change anything between the other commands,
> so I'm a bit  
> perplexed.  Ideas?
> 
> -Matt
> Matt Grosland
> Manager of IT
> Dept of Recording Industry
> Middle Tennessee State University
> (615) 494-8997
> grosland at mtsu.edu
> 
> > _______________________________________________
>
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from
> O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com



      ____________________________________________________________________________________
Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ