TKMW - improperly set access rights /var/lib/mysql

[cpeper]

Upon default installation of the TK MediaWiki appliance, some directory access rights seem to be incorrect (related to PMA features).

Symptoms:
when logging into phpmyadmin as root, create of new database fails with error #13
when rename an existing MySQL table, it fails with error #13

Problem:
/var/lib/mysql and /var/lib/mysql/<database name> are owned by root:root and mysql can't change anything.

Solution:
chgrp mysql /var/lib/mysql
chmod g+w /var/lib/mysql
chgrp mysql /var/lib/mysql/<database name>
chmod g+w /var/lib/mysql/<database name>

After this, database actions from phpmyadmin function as expected.

[Alon Swartz (alonswartz)]

Thank you for providing a detailed explanation, but unfortunately I cannot replicate this issue.

I have tried on the mediawiki_2009-04 version, both live and installed, but I am able to make whatever changes I desire to mysql (create new databases, manipulate existing tables, etc.)

It would be helpful if you could attempt to replicate this issue in a fresh instance of the appliance, and let us know.
For now, I have changed the status to invalid but will re-open the bug if you can provide more information.

[cpeper (dreamszz)]

Thanks Alon, you are right. I've reinstalled a VM with the 2009-04 ISO and it works. I can create dbs, tables and fields.

My fault. I had relocated /var and /usr into LVM partitions prior to configuring mysql/mediawiki and so on. During the copy of the existing fs into LVM, certain rights may have not been transfered 100% correctly. Sorry for the confusing.

However... There are still some phpmyadmin features missing using the default install.
My reason for filing this report was to indicate the renaming of existing tables wasn't possible, whereas the PMA features are not (fully) configured. I've attached some screenshots to show what I mean.

[cpeper (dreamszz)]

Hmmm can only attach 1 screenshot at a time.

[cpeper (dreamszz)]

screenshot

[cpeper (dreamszz)]

missing PMA features on Operations tab with wiki_db tables. There should be a Rename option here to rename all tables in one go by selecting all

[Alon Swartz (alonswartz)]

Due to pmadb being a completely different issue to that of this bug report, I have created a new bug report [1] and leaving this as invalid.

[1] https://bugs.launchpad.net/turnkeylinux/+bug/426303