Re: [rt-users] RT Upgrade failing from 3.6.6 to3.8.6 UPDATE:mason_data directory
I wasn't able to get this working after trying a good portion of the evening. I finally ended up setting up a new virtual server and just migrating the database over to it. -Josh -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Barron, Josh Sent: Tuesday, November 17, 2009 6:14 PM Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] RT Upgrade failing from 3.6.6 to3.8.6 UPDATE:mason_data directory Looks like it is on: [r...@help01 jbarron]# /usr/sbin/getenforce Enforcing [r...@help01 jbarron]# /sbin/ausearch -m avc -ts today no matches -Original Message- From: Stuart Browne [mailto:stuart.bro...@ausregistry.com.au] Sent: Tuesday, November 17, 2009 6:04 PM To: Barron, Josh; Tom Lahti Cc: rt-users@lists.bestpractical.com Subject: RE: [rt-users] RT Upgrade failing from 3.6.6 to 3.8.6 UPDATE:mason_data directory -Original Message- From: Barron, Josh That file does not exist in the new RT directory, nor is any file by that name in use anywhere from what I can see. I'm really baffled by this. SELinux isn't turned on by any chance is it? getenforce ausearch -m avc -ts today Stuart ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT Upgrade failing from 3.6.6 to3.8.6 UPDATE:mason_data directory
I did try and it was giving me other issues after doing that. Since the server was old and running on limited resources, we made the final decision to migrate clean anyways instead of throwing more time resources at the old server. Thanks for your help though! -Josh -Original Message- From: Tom Lahti [mailto:t...@bitstatement.net] Sent: Wednesday, November 18, 2009 1:18 PM To: Barron, Josh Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] RT Upgrade failing from 3.6.6 to3.8.6 UPDATE:mason_data directory Barron, Josh wrote: I wasn't able to get this working after trying a good portion of the evening. I finally ended up setting up a new virtual server and just migrating the database over to it. Did you ever try turning SELinux off? Just curious, I've never used it so I'm not sure what the impact would be. [r...@help01 jbarron]# /usr/sbin/getenforce Enforcing -- -- Tom Lahti, SCMDBA, LPIC-1 BIT LLC (425)251-0833 x 117 http://www.bitstatement.net/ -- ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT Upgrade failing from 3.6.6 to 3.8.6
Hi Tom, There is only one my.cnf and it doesn't contain those sections with that line. From what I can determine mysql is set to listen to any address. When I forced a localhost connection, I was able to connect as both root and rt_user. -Josh -Original Message- From: Tom Lahti [mailto:t...@bitstatement.net] Sent: Monday, November 16, 2009 5:38 PM To: Barron, Josh Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] RT Upgrade failing from 3.6.6 to 3.8.6 Try Yes I tried connecting to mysql directly from localhost and that worked: [jbar...@help01 ~]$ mysql -u rt_u...@localhost -p Enter password: ERROR 1045 (28000): Access denied for user 'rt_u...@localhos'@'localhost' (using password: YES) [jbar...@help01 ~]$ mysql -u rt_user -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 138 Server version: 5.0.77 Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql exit; Bye [jbar...@help01 ~]$ On *nix, mysql programs read startup options from the following in order: /etc/my.cnf SYSCONFDIR/my.cnf $MYSQL_HOME/my.cnf The file specified with --defaults-extra-file, if any ~/.my.cnf If any of these exist, and there is a [mysql] or [client] section that contains a host=... line, then mysql -u rt_user -p will connect to that host, not localhost. To force a localhost connection, do: mysql -h localhost -u rt_user -p What I'm getting at is: are you sure your MySQL instance for RT is on localhost? -- -- Tom Lahti, SCMDBA, LPIC-1 BIT LLC (425)251-0833 x 117 http://www.bitstatement.net/ -- ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT Upgrade failing from 3.6.6 to 3.8.6 UPDATE: mason_data directory
Thanks Tom, Looks like the permissions are set correctly: [r...@help01 rt3]# ls -l /opt/rt3/var/mason_data/ total 24 drwxrwxrwx 2 apache apache 4096 Oct 30 15:51 cache drwxrwxrwx 2 apache apache 4096 Oct 30 15:51 etc drwxrwxrwx 2 apache apache 4096 Nov 17 13:33 obj [r...@help01 rt3]# getfacl /opt/rt3/var/mason_data/obj getfacl: Removing leading '/' from absolute path names # file: opt/rt3/var/mason_data/obj # owner: apache # group: apache user::rwx group::rwx other::rwx -Original Message- From: Tom Lahti [mailto:t...@bitstatement.net] Sent: Tuesday, November 17, 2009 2:47 PM To: Barron, Josh Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] RT Upgrade failing from 3.6.6 to 3.8.6 UPDATE: mason_data directory [Tue Nov 17 16:24:02 2009] [error] [client 216.222.31.30] Could not create '/opt/rt3/var/mason_data/obj/.__obj_create_marker': Permission denied\nStack:\n You need to look specifically at the permissions on /opt/rt3/var/mason_data/obj and verify that the user the web server runs as can write to that directory. The higher level directories are irrelevant. Also, if you are using POSIX ACLs you might need to getfacl /opt/rt3/var/mason_data/obj -- -- Tom Lahti, SCMDBA, LPIC-1 BIT LLC (425)251-0833 x 117 http://www.bitstatement.net/ -- ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT Upgrade failing from 3.6.6 to 3.8.6 UPDATE: mason_data directory
That file does not exist in the new RT directory, nor is any file by that name in use anywhere from what I can see. I'm really baffled by this. -Josh -Original Message- From: Tom Lahti [mailto:t...@bitstatement.net] Sent: Tuesday, November 17, 2009 3:52 PM To: Barron, Josh Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] RT Upgrade failing from 3.6.6 to 3.8.6 UPDATE: mason_data directory [Tue Nov 17 16:24:02 2009] [error] [client 216.222.31.30] Could not create '/opt/rt3/var/mason_data/obj/.__obj_create_marker': Permission Does the *file* .__obj_create_marker already exist in that location, with some un-overwritable permissions perhaps? Or perhaps its in use? lsof | grep marker -- -- Tom Lahti, SCMDBA, LPIC-1 BIT LLC (425)251-0833 x 117 http://www.bitstatement.net/ -- ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT Upgrade failing from 3.6.6 to 3.8.6 UPDATE:mason_data directory
Looks like it is on: [r...@help01 jbarron]# /usr/sbin/getenforce Enforcing [r...@help01 jbarron]# /sbin/ausearch -m avc -ts today no matches -Original Message- From: Stuart Browne [mailto:stuart.bro...@ausregistry.com.au] Sent: Tuesday, November 17, 2009 6:04 PM To: Barron, Josh; Tom Lahti Cc: rt-users@lists.bestpractical.com Subject: RE: [rt-users] RT Upgrade failing from 3.6.6 to 3.8.6 UPDATE:mason_data directory -Original Message- From: Barron, Josh That file does not exist in the new RT directory, nor is any file by that name in use anywhere from what I can see. I'm really baffled by this. SELinux isn't turned on by any chance is it? getenforce ausearch -m avc -ts today Stuart ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] RT Upgrade failing from 3.6.6 to 3.8.6
Ok I've been fighting this forever and its really starting to get to me. I'm trying to upgrade RT and I'm at the step where I'm supposed to upgrade the database to a certain point before applying a schema. The command to run is: /opt/rt3/sbin/rt-setup-database --prompt-for-dba-password --action upgrade It then attempts to connect as rt_user. I give it the password, proceed through the prompts and then get: DBI connect('dbname=rt3;host=localhost','rt_user',...) failed: Access denied for user 'rt_user'@'localhost' (using password: YES) at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 106 Connect Failed Access denied for user 'rt_user'@'localhost' (using password: YES) at /opt/rt3/sbin/../lib/RT.pm line 204 So basically, it appears that my password is incorrect, HOWEVER, I can connect to mysql using the exact user and password. Its almost like the perl script is NOT taking the prompts. Hope someone can help. -Josh ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT Upgrade failing from 3.6.6 to 3.8.6
Hi Tom, Yes I tried connecting to mysql directly from localhost and that worked: [jbar...@help01 ~]$ mysql -u rt_u...@localhost -p Enter password: ERROR 1045 (28000): Access denied for user 'rt_u...@localhos'@'localhost' (using password: YES) [jbar...@help01 ~]$ mysql -u rt_user -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 138 Server version: 5.0.77 Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql exit; Bye [jbar...@help01 ~]$ The first connection failed when I specified localhost but connecting directly and specifying no host worked fine. Just to verify it was connecting to localhost I deliberately typed the password wrong and it showed me using rt_u...@localhost -Josh -Original Message- From: Tom Lahti [mailto:t...@bitstatement.net] Sent: Monday, November 16, 2009 5:25 PM To: Barron, Josh Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] RT Upgrade failing from 3.6.6 to 3.8.6 Connect Failed Access denied for user 'rt_user'@'localhost' (using password: YES) So basically, it appears that my password is incorrect, HOWEVER, I can connect to mysql using the exact user and password. Its almost like the perl script is NOT taking the prompts. Connecting at localhost? In MySQL, the user 'rt_user'@'something-else' is not the same user as 'rt_user'@'localhost'. -- -- Tom Lahti, SCMDBA, LPIC-1 BIT LLC (425)251-0833 x 117 http://www.bitstatement.net/ -- ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Unable to Upgrade RT 3.6.6 to 3.8.x usingMySQL 5.0.77 and provided database upgrade scripts
Hi Emmanuel, Yes I did. Its very strange, even when I enter the command with --dba root it still comes up using rt_user I've tried the password for rt-user and the password for root with no success. -Josh -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Emmanuel Lacour Sent: Monday, November 02, 2009 6:02 AM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Unable to Upgrade RT 3.6.6 to 3.8.x usingMySQL 5.0.77 and provided database upgrade scripts On Fri, Oct 30, 2009 at 06:36:38PM -0400, Barron, Josh wrote: [r...@help01 rt-3.8.6]# ./sbin/rt-setup-database --dba root --prompt-for-dba-password --action upgrade In order to create or update your RT database, this script needs to connect to your mysql instance on localhost as root Please specify that user's database password below. If the user has no database password, just press return. did you entered your MySQL root password here ? ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Unable to Upgrade RT 3.6.6 to 3.8.x using MySQL 5.0.77 and provided database upgrade scripts
Hello all, I'm having quite the time upgrading RT from 3.6.6 to the last version. I am following the readme and upgrading.mysql docs. ./configure runs fine Make testdeps and fixdeps were also successful Make upgrade ran with no errors Coming up on the section about upgrading the database to 3.7.87 prior to executing the SQL schema as detailed in the upgrading.mysql doc: [r...@help01 rt-3.8.6]# ./sbin/rt-setup-database --dba root --prompt-for-dba-password --action upgrade In order to create or update your RT database, this script needs to connect to your mysql instance on localhost 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: localhost Name: rt3 User: rt_user DBA:root Enter RT version you're upgrading from: 3.6.6 Going to apply following upgrades: * 3.7.1 * 3.7.3 * 3.7.10 * 3.7.15 * 3.7.19 * 3.7.81 * 3.7.82 * 3.7.85 * 3.7.86 * 3.7.87 * 3.8.0 * 3.8.1 * 3.8.2 * 3.8.3 * 3.8.4 * 3.8.6 Enter RT version if you want to stop upgrade at some point, or leave it blank if you want apply above upgrades: 3.7.87 Going to apply following upgrades: * 3.7.1 * 3.7.3 * 3.7.10 * 3.7.15 * 3.7.19 * 3.7.81 * 3.7.82 * 3.7.85 * 3.7.86 * 3.7.87 IT'S VERY IMPORTANT TO BACK UP BEFORE THIS STEP Proceed [y/N]:y Processing 3.7.1 DBI connect('dbname=rt3;host=localhost','rt_user',...) failed: Access denied for user 'rt_user'@'localhost' (using password: YES) at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 106 Connect Failed Access denied for user 'rt_user'@'localhost' (using password: YES) at /home/jbarron/rt-3.8.6/sbin/../lib/RT.pm line 204 Using the user/pass specified in the script to connect directly to mysql works fine so I'm not sure why its still failing on me. I've added all the permissions for the rt_user and root user just to test, tried running the script with no arguments except -action upgrade, and I'm still stuck. Thanks kindly, Josh Barron ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com