Wrong type and other settings with rt-setup-databases

We are in the process of moving to a new server and we will upgrade RT and
other things. The new system will be RT 4.4.0 (Ubuntu 16.04 with MySQL
5.7). The old system runs RT 4.0.4 (Ubuntu 12.04 with MySQL 5.5). I am
stuck and haven’t been able to find a solution elsewhere. Thanks in
advance for any help and hopefully I didn’t just miss something in the the
documentation.

When I try to do

rt-setup-databases --action upgrade

the process appears to show settings for the wrong database type and some
other things. For example it will show Pg or sqllite even though we use
mysql and my SiteConfig has it set up that way. I am not sure what I am
missing or how else to verify it but the settings seem to be right, just
not used.

Always the type is wrong but often the database name or user is wrong too.

I see the same type of issue if I try to use the action to drop the
database.

Thanks again for any help. Please let me know if you need other
information to answer this.

Scott B

I wasn’t able to figure out the problem. We were trying to install the
Request Tracker that was current in the Ubuntu repository. After trying a
clean reinstall a few times I decided to get it direct from Best
Practical’s site. The version in the repository may have been RT 4.2 so
another motivation to go direct.

The install worked. I tested the site, which worked. Then I moved in the
old database and I was able to do the upgrade. We are now on the new
server, running RT 4.4, and have our old tickets, etc.

I wanted to post an update in case any others find this useful.

Scott BOn Fri, Aug 12, 2016 at 11:42 AM, Scott Boland smb@twsupport.com wrote:

We are in the process of moving to a new server and we will upgrade RT and
other things. The new system will be RT 4.4.0 (Ubuntu 16.04 with MySQL
5.7). The old system runs RT 4.0.4 (Ubuntu 12.04 with MySQL 5.5). I am
stuck and haven’t been able to find a solution elsewhere. Thanks in
advance for any help and hopefully I didn’t just miss something in the the
documentation.

When I try to do

rt-setup-databases --action upgrade

the process appears to show settings for the wrong database type and some
other things. For example it will show Pg or sqllite even though we use
mysql and my SiteConfig has it set up that way. I am not sure what I am
missing or how else to verify it but the settings seem to be right, just
not used.

Always the type is wrong but often the database name or user is wrong too.

I see the same type of issue if I try to use the action to drop the
database.

Thanks again for any help. Please let me know if you need other
information to answer this.

Scott B