Hi, I've been working with the TKMW and loving it. It's truely easy to get going and setup. In minutes your making pages, adding users and so on. However, for my specific needs, I need to be able to create and manage multiple wikis. Luckily, this used to complex but is now covered by the extension Farmer.
This requires some adaptations to MySQL and that's where the VM breaks. It wouldn't allow me to do stuff through phpmyadmin as root user. :( I am root, why not? I couldn't create a new db, for instance. Turns out a 'chown mysql /var/lib/mysql' solved that. Otherwise, the web process has no rights to access mysql.
Now I'd like to rename tables using phpmyadmin to have a prefix (as req by the Farmer extension), however that option is not available. After investigation, it turned out that the pmadb - used for enhanced operations and commands - is missing. But just creating it also doesn't help.
Is there a way you can provide some assistence for re-enabling extended features for MySQL by letting me create a proper PMA database? There should be scripts in /var/lib/phpmyadmin but they are not there.
the pmadb issue has been solved. Debian has the scripts in a different location, as listed in the docs on pmadb. Using the create_tables script works fine from phpmymadmin, once I changed the access rights on /var/lib/mysql. So that does indeed seem like a bug. However, the PMA enhanced features still don't allow me to easily rename all tables of a database from phpmyadmin. Instead, I used a PHP script.
Also, the rename script that renamed all wiki_db tables to have a prefix "mw_" failed because access rights on /var/lib/mysql/wiki_db were also root:root instead of root:mysql with group write rights. Another bug?