Nick
Apr 13th, 2009
Apr 13th, 2009
Fix Ensim MySQL Permission Problems
DB function failed with error number 1
Can’t create/write to file ‘/var/lib/mysql/#sql_25dd_0.MYI’ (Errcode: 13) SQL=SELECT p.*, u.name AS editor, g.name AS groupname FROM jos_plugins AS
p LEFT JOIN jos_users AS u ON u.id = p.checked_out LEFT JOIN jos_groups AS g ON g.id = p.access WHERE p.client_id = 0 GROUP BY p.id ORDER BY
p.folder , p.ordering ASC LIMIT 0, 50
OR:
mysqldump: Couldn’t execute ’show fields from `admins`’: Can’t create/write to file ‘/var/lib/mysql/#sql_25dd_0.MYI’ (Errcode: 13) (1)
If you get any of the errors showed above while browsing your Ensim Panel is a straight symptom that your server is experiencing a MySQL permission issue, to correct this type the command below,
-
# chmod g+w /var/lib/mysql
