Switching MWA from sqlite to MySQL

[Andrew Valentine]

Hello!

I'm seeing occasional "Database is locked" errors when attempting to access MWA.

Going by this thread:

https://groups.google.com/forum/#!topic/munki-web-admin/55jtyt_vz5Q

this is likely due to our install using sqlite rather than MySQL.

I don't have much experience with SQL of any flavour. Can anyone offer any advice on switching over?

Cheers,

Andrew

[tackyy]

I had the same issues and switching to MySQL fixed it.

The big word of advice I’d have is make sure you create the database using UTF-8 as your charset. Otherwise you will get errors. This post was helpful to remind me of the syntax:

https://www.euperia.com/development/mysql-create-database-with-utf8-character-set-syntax/1064

The Ubuntu setup instructions (https://github.com/munki/munkiwebadmin/wiki/MunkiWebAdmin%20Ubuntu%20Setup) show how to set up a mysql database with a web GUI using phpmyadmin if you’re more comfortable going that route than CLI.

-tack

--
You received this message because you are subscribed to the Google Groups "MunkiWebAdmin" group.
To unsubscribe from this group and stop receiving emails from it, send an email to munki-web-adm...@googlegroups.com.
Visit this group at https://groups.google.com/group/munki-web-admin.
For more options, visit https://groups.google.com/d/optout.