chgrp: cannot access /var/lib/mysql/progressfundraising_phpbb': No such file or directory chmod: cannot access /var/lib/mysql/progressfundraising_phpbb’: No such file or directory
chgrp: cannot access /var/lib/mysql/progressfundraising_roundcube': No such file or directory chmod: cannot access /var/lib/mysql/progressfundraising_roundcube’: No such file or directory
chgrp: cannot access /var/lib/mysql/progressfundraising_mediawiki': No such file or directory chmod: cannot access /var/lib/mysql/progressfundraising_mediawiki’: No such file or directory
chgrp: cannot access /var/lib/mysql/progressfundraising_phpmyadmin': No such file or directory chmod: cannot access /var/lib/mysql/progressfundraising_phpmyadmin’: No such file or directory
chgrp: cannot access /var/lib/mysql/progressfundraising_wordpress': No such file or directory chmod: cannot access /var/lib/mysql/progressfundraising_wordpress’: No such file or directory
I moved the MySQL data directory to the home partition (/home/mysql/). I’m assuming that the MySQL data directory is hardcoded in the scripts?? Is there some place I can change it in the scripts?
I guess I can work around that my just creating a symbolic link from /var/lib/mysql to /home/mysql but I guess I would rather update in some configuration screen somewhere.
FYI: I using Virtualmin GPL upgraded to Pro on EC2 and need the databases off the instance partition. So, I attached an EBS volume at /home. Trying to take advantage of the reserved instance pricing in case your wondering why I didn’t go with the paid AMI for Virtualmin Pro.
What you’re seeing above is because Virtualmin tries to change the permissions on the databases after creating them, so that they’ll be included in the user quotas.
Virtualmin doesn’t attempt to directly access the data in them or anything. So long as MySQL knows where it’s databases are, you should be okay in that department.
Not that this solves your problem at all, it just seems like the above errors probably aren’t the issue
Now, to correct the above errors, if you take a look in Webmin -> Servers -> MySQL -> Module Config -> System Configuration, is the “Path to MySQL databases directory” setting correct?