[rt-users] RT Upgrade failing from 3.6.6 to 3.8.6 UPDATE: mason_data directory

[Barron, Josh]

I was able to finally get the script to take.  Now it seems I have a
permissions issue that I can't get around:

[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
[/usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Interp.pm:222]\n
[/usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Interp.pm:169]\n
[/usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Interp.pm:155]\n
[/usr/lib/perl5/vendor_perl/5.8.8/Class/Container.pm:329]\n
[/usr/lib/perl5/vendor_perl/5.8.8/Class/Container.pm:53]\n
[/usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/ApacheHandler.pm:633]\n
[/opt/rt3/bin/../lib/RT/Interface/Web/Handler.pm:161]\n
[/opt/rt3/bin/../lib/RT/Interface/Web/Handler.pm:141]\n
[/opt/rt3/bin/webmux.pl:160]\n
[/usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/ApacheHandler.pm:0]\n

The directory in question has the following permissions on it:
[root at help01 rt3]# ls -l /opt/rt3/var/
total 24
drwxrwxrwx 2 apache apache 4096 Oct 30 15:51 log
drwxrwxrwx 5 apache apache 4096 Nov 17 13:33 mason_data
drwxrwxrwx 2 apache apache 4096 Oct 30 15:51 session_data


It doesn't look like a permissions issue but I can't figure out why it
is being denied.  There is no .htaccess in there.

-Josh
-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Barron,
Josh
Sent: Tuesday, November 17, 2009 9:13 AM
To: Tom Lahti
Cc: rt-users at lists.bestpractical.com
Subject: 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:toml at bitstatement.net] 
Sent: Monday, November 16, 2009 5:38 PM
To: Barron, Josh
Cc: rt-users at 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:
> 
> [jbarron at help01 ~]$ mysql -u rt_user at localhost -p
> Enter password: 
> ERROR 1045 (28000): Access denied for user
> 'rt_user at localhos'@'localhost' (using password: YES)
> [jbarron at 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
> [jbarron at 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: sales at bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com