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
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 Huh. So you did: mysql -h localhost -u rt_user -p and you're sure there's no ~/.my.cnf (note leading dot, its a hidden file). That is strange. I'm not sure how the schema upgrade script makes its connection to mysql, if its using the mysql client program then it should work exactly the same. -- -- 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
[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
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
[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
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
-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
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
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] 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] 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
