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
