NYCPHP Meetup

[David Roth]

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 <scott at 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<scott at 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