this is my first time actually using FreeBSD so there's a chance I might have missed something big, but it's unlikely.
So I want to set up mysql on my pfSense server so I can enable historical logging on ntopng. I am aware of the dangers of doing this and I am taking the necessary precautions to keep my system secure.
I installed it by copying URLs from http://pkg.freebsd.org/FreeBSD:11:amd64/latest/All/ and pasting them into
pkg add, which worked. I got mysql56-server and all it's dependencies installed.
Because I'm on pfSense, I have to start it with
service mysql-server onestart because there's no rc.conf, but when I do it I get this:
Starting mysql. Bad -c option /usr/local/etc/rc.d/mysql-server: WARNING: failed to start mysql
I googled for what
bad -c option means for mysql and found zero answers. Not a single page describes a similar issue.
I tried deleting
/var/db/mysql/* but it made no difference.
I'm stumped. Thanks in advance.
Edit: yes, there is a
mysql user. The pkg automatically made it.