Installing Kegbot Server on Mac: storage_engine error


#1

I’m using the Install Guide at https://kegbot.org/docs/server/install/ and have been able to brew install the dependencies, set up and activate my virtual environment, create the mysql database, and verify that redis is running.

When I try to run setup-kegbot.py, I get this error:
django.db.utils.OperationalError: (1193, "Unknown system variable 'storage_engine'")
ERROR: Command returned non-zero exit status (1)

Any ideas for how I can get past this? I am able to see a ~/.kegbot/local_settings.py file that is generated by setup-kegbot.py but I can’t tell what wasn’t completed due to the error above.


#2

I figured out my own issue. Apparently, storage_engine has been replaced with default_storage_engine in MySQL, deprecated as of v5.7.5. I had to edit my /data/kb/bin/setup-kegbot.py file to replace storage_engine with default_storage_engine at line 369.

Documentation about mysql storage_engine variable: http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_storage_engine

The recommended Homebrew method installed mysql v5.7.14 (in September 2016), so I suspect this will be a common problem for anyone trying kegbot setup from now on.


#3

Thankyou for this, helped me out on a new build to replace the RPi.


#4

@wangela
I joined just to say thank you. This was driving me nuts (and I do a little linux work normally).

For anyone else on Linux (not sure where on Mac), the setup-kegbot.py is located at /usr/local/bin directory. Simply “sudo nano -c setup-kegbot.py” (or vim, etc.) and modify as wangela has it.