[rt-users] remote sql server w/ ssl RT make upgrade-database problem

[Pollard, James R]

Got it.  Hopefully this will be much more useful:

/usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib sbin/rt-setup-database
--action upgrade --prompt-for-dba-password
In order to create or update your RT database, this script needs to connect
to your  mysql instance on mysqldb02.company.site (port '') as root
Please specify that user's database password below. If the user has no
database
password, just press return.

Password: 
Working with:
Type:   mysql
Host:   mysqldb02.company.site
Port:
Name:   database_rt4
User:   username
DBA:    root
Enter RT version you're upgrading from: 
Going to apply following upgrades:
* 4.2.2
* 4.2.4

Enter RT version if you want to stop upgrade at some point,
  or leave it blank if you want apply above upgrades: 
IT'S VERY IMPORTANT TO BACK UP BEFORE THIS STEP

Proceed [y/N]:
[32426] [Mon Jun  2 18:26:23 2014] [warning]: DBI
connect('dbname=database_rt4;host=mysqldb02.company.site','username',...)
failed: Access denied for user 'username'@'RT.webhost.companysite' (using
password: YES) at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm li
ne 105. (/usr/local/share/perl5/Carp.pm:168)
[32426] [Mon Jun  2 18:26:23 2014] [critical]: Connect Failed Access denied
for user 'username'@'RT.webhost.companysite' (using password: YES)
 at /home/admin/rt-4.2.4/sbin/../lib/RT.pm line 212.
(/home/admin/rt-4.2.4/sbin/../lib/RT.pm:393)
Connect Failed Access denied for user 'username'@'RT.webhost.companysite'
(using password: YES)
 at /home/admin/rt-4.2.4/sbin/../lib/RT.pm line 212.
make: *** [upgrade-database] Error 255

-----Original Message-----
From: rt-users [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf
Of Kevin Falcone
Sent: Friday, May 30, 2014 3:24 PM
To: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] remote sql server w/ ssl RT make upgrade-database
problem

On Thu, May 29, 2014 at 03:29:23PM +0000, Pollard, James R wrote:
>    Trying to upgrade from RT 4.2.1 to 4.2.4 with a remote SSL required
Mysql server.  I've had
>    the current version working fine for months by modifying
/opt/rt/lib/RT/Handle.pm as such,
>    where ++ denotes added lines.

This seems like the sort of thing that could be contributed to core,
assuming it worked on upgrades...

>    I have already run make upgrade, copied my changes to Handle.pm and
verified that the
>    connection works using the web interface.  Make upgrade-database fails
however saying "access
>    denied for <user at RTwebhostname> (using password: YES)"

Unfortunately, you cut the important parts, seeing the connection details
printed by make upgrade-database and which step bailed out, since there are
schema changes *and* content changes.

>    2.       Do a manual database upgrade using a manual connection via
mysql -D .... Etc. etc.

Not possible, since there are changes that require RT to execute perl code
in those (and future) upgrade steps.

I assume you're tripping over RT trying to get a privileged handle for
schema changes and failing somewhere.

-kevin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 6204 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140602/e0053c8f/attachment.bin>