Upgrade issue 3.0.10 to 3.6.6

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/"
@echo " $(RT_SBIN_PATH)/rt-setup-database --dba $(DB_DBA)
–prompt-for-dba-passwor
d --action acl --datadir etc/upgrade/"
@echo " $(RT_SBIN_PATH)/rt-setup-database --dba $(DB_DBA)
–prompt-for-dba-passwor
d --action insert --datadir etc/upgrade/"

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@mtsu.edu

check the permissions on the user rt@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

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/"
@echo
$(RT_SBIN_PATH)/rt-setup-database --dba $(DB_DBA)
–prompt-for-dba-passwor
d --action acl --datadir etc/upgrade/”
@echo
$(RT_SBIN_PATH)/rt-setup-database --dba $(DB_DBA)
–prompt-for-dba-passwor
d --action insert --datadir etc/upgrade/”

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@mtsu.edu


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@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