As root I can 'su mysql'. I've never actually done that before, have not had a reason until now. I did try to create a test file in /tmp and it gave a message of "Permission denied". I'd think that alone is odd, shouldn't mysql as a user be able to write to /tmp? This may be related to the problem? Thanks!
David Roth On Mon, Feb 27, 2012 at 8:30 PM, Scott Wolpow <sc...@wolpow.com> wrote: > Can you login into mysql as root? > SW > > On 2/27/2012 8:12 PM, David Roth wrote: >> >> Hi Scott. >> >> Thanks for the reply. >> >> I'm able at the command line do a mysql -p and login with the usual >> password. Are you referring to resetting some other >> password/permissions for the mysqld? >> >> Never had a serious MySQL problem like this before. Time for the long >> pants. :-) >> >> David Roth >> >> On Mon, Feb 27, 2012 at 7:13 PM, Scott Wolpow<sc...@wolpow.com> wrote: >>> >>> Hmm, >>> Sounds like you MySql root user got corrupted. >>> >>> I suggest you search on lost MySql root password and follow those >>> directions. >>> SW >>> >>> >>> On 2/27/2012 2:37 PM, David Roth wrote: >>>> >>>> I'm using Joomla 2.5.1 on my CentOS 6.2 server running MySQL Server >>>> version: 5.1.61. All the sudden I get error messages when logged in >>>> as Admin when trying to access the Menu Manager items such as Home. >>>> Things were working fine the night before so I look in the PHP error >>>> log: >>>> >>>> [27-Feb-2012 01:23:47] PHP Notice: Trying to get property of >>>> non-object in >>>> /home/www/html/staging/administrator/includes/application.php >>>> on line 275 >>>> [27-Feb-2012 01:23:47] PHP Notice: Undefined property: >>>> stdClass::$params in >>>> /home/www/html/staging/administrator/includes/application.php on line >>>> 276 >>>> [27-Feb-2012 01:23:47] PHP Warning: Invalid argument supplied for >>>> foreach() in >>>> /home/www/html/staging/libraries/joomla/database/database/mysql.php >>>> on line 377 >>>> [27-Feb-2012 01:23:47] PHP Notice: Trying to get property of >>>> non-object in >>>> /home/www/html/staging/administrator/includes/application.php >>>> on line 275 >>>> [27-Feb-2012 01:23:47] PHP Notice: Undefined property: >>>> stdClass::$params in >>>> /home/www/html/staging/administrator/includes/application.php on line >>>> 276 >>>> [27-Feb-2012 01:23:47] PHP Warning: Invalid argument supplied for >>>> foreach() in >>>> /home/www/html/staging/libraries/joomla/database/database/mysql.php >>>> on line 377 >>>> [27-Feb-2012 01:23:47] PHP Warning: Invalid argument supplied for >>>> foreach() in >>>> /home/www/html/staging/libraries/joomla/database/database/mysql.php >>>> on line 377 >>>> [27-Feb-2012 01:23:47] PHP Warning: Invalid argument supplied for >>>> foreach() in /home/www/html/staging/libraries/joomla/database/table.php >>>> on line 406 >>>> [27-Feb-2012 01:23:47] PHP Notice: Trying to get property of >>>> non-object in >>>> >>>> /home/www/html/staging/administrator/components/com_menus/models/item.php >>>> on line 544 >>>> [27-Feb-2012 01:23:47] PHP Warning: Invalid argument supplied for >>>> foreach() in >>>> /home/www/html/staging/libraries/joomla/database/database/mysql.php >>>> on line 377 >>>> [27-Feb-2012 01:23:47] PHP Warning: Invalid argument supplied for >>>> foreach() in >>>> /home/www/html/staging/libraries/joomla/database/database/mysql.php >>>> on line 377 >>>> [27-Feb-2012 01:23:47] PHP Warning: Invalid argument supplied for >>>> foreach() in /home/www/html/staging/libraries/joomla/database/table.php >>>> on line 406 >>>> [27-Feb-2012 01:23:47] PHP Warning: Invalid argument supplied for >>>> foreach() in >>>> /home/www/html/staging/libraries/joomla/database/database/mysql.php >>>> on line 377 >>>> [27-Feb-2012 01:23:47] PHP Warning: Invalid argument supplied for >>>> foreach() in >>>> /home/www/html/staging/libraries/joomla/database/database/mysql.php >>>> on line 377 >>>> [27-Feb-2012 01:23:47] PHP Warning: Invalid argument supplied for >>>> foreach() in /home/www/html/staging/libraries/joomla/database/table.php >>>> on line 406 >>>> >>>> So it appears to be MySQL related. So I decided to do a mysqldump of >>>> the database Joomla 2.5.1 is using to rebuild the database and come up >>>> with this error message: >>>> >>>> mysqldump: Couldn't execute 'show fields from `cmyzk_assets`': Can't >>>> create/write to file '/tmp/#sql_6da_0.MYI' (Errcode: 13) (1) >>>> >>>> I do a ' perror 13' command to see what Errcode 13 means and get this: >>>> OS error code 13: Permission denied >>>> >>>> This doesn't make sense to me because I'm logged in as root doing all >>>> this. Furthermore, I didn't change anything (that I know of). I >>>> looked to see how MySql is running: >>>> >>>> root 1665 0.0 0.0 108256 1432 ? S 12:15 0:00 >>>> /bin/sh /usr/bin/mysqld_safe --datadir=/home/mysql >>>> --socket=/var/lib/mysql/mysql.sock >>>> --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql >>>> mysql 1754 0.0 0.5 217712 19536 ? Sl 12:15 0:01 >>>> /usr/libexec/mysqld --basedir=/usr --datadir=/home/mysql --user=mysql >>>> --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid >>>> --socket=/var/lib/mysql/mysql.sock >>>> >>>> I don't know what the next step should be. I'd appreciate suggestions. >>>> Thanks! >>>> >>>> David Roth >>>> _______________________________________________ >>>> New York PHP SIG: Joomla! Mailing List >>>> http://lists.nyphp.org/mailman/listinfo/joomla >>>> >>>> NYPHPCon 2006 Presentations Online >>>> http://www.nyphpcon.com >>>> >>>> Show Your Participation in New York PHP >>>> http://www.nyphp.org/show_participation.php >>>> >>> _______________________________________________ >>> New York PHP SIG: Joomla! Mailing List >>> http://lists.nyphp.org/mailman/listinfo/joomla >>> >>> NYPHPCon 2006 Presentations Online >>> http://www.nyphpcon.com >>> >>> Show Your Participation in New York PHP >>> http://www.nyphp.org/show_participation.php >> >> _______________________________________________ >> New York PHP SIG: Joomla! Mailing List >> http://lists.nyphp.org/mailman/listinfo/joomla >> >> NYPHPCon 2006 Presentations Online >> http://www.nyphpcon.com >> >> Show Your Participation in New York PHP >> http://www.nyphp.org/show_participation.php >> > _______________________________________________ > New York PHP SIG: Joomla! Mailing List > http://lists.nyphp.org/mailman/listinfo/joomla > > NYPHPCon 2006 Presentations Online > http://www.nyphpcon.com > > Show Your Participation in New York PHP > http://www.nyphp.org/show_participation.php _______________________________________________ New York PHP SIG: Joomla! Mailing List http://lists.nyphp.org/mailman/listinfo/joomla NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
