I'm self-hosting on Mac OS X and run into problems during setup. Help!

~ 0 min
2020-07-04 04:53

When self-hosting on Mac OS X you'll need to keep in mind that there is a default setting in the my.cnf configuration file for MySQL, which is not present in most (all?) of the shared hosting environments for which Armadillo was designed.

This default setting in the my.cnf config file is as follows:

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

The effect of the second setting (STRICT_TRANS_TABLES) is such that, in case the type of a submitted value is not strictly what it is "supposed" to be, the transaction will be aborted.

That particular setting affects Armadillo, preventing the creation of options in the database during the initial online setup.

In short, you'll need to remove that setting so that the sql_mode is as follows:

sql_mode=NO_ENGINE_SUBSTITUTION

Once you've done that, Armadillo should function correctly and successfully complete online setup.

Tags: Troubleshooting
Average rating 0 (0 Votes)

You cannot comment on this entry