Unable to login to Kibana, etc. MySQL error.

[PB]

Hi,

I have done a clean install of SO using the latest ISO, 16.04.4.3, and updated before running the setup.

When attempting to login to Kibana it fails without an error and returns to the original login page, or with Squil, it is unable to connect.

Running 'so-user-add' does not allow a new user access either.

When running 'so-user-list', the following error is generated:

mysql: [ERROR] Could not open required defaults file: /etc/mysql/debian.cnf
mysql: [ERROR] Fatal error in defaults handling. Program aborted!

There is no 'debian.cnf' file.

I guess this may be related to the July 31 blog post?

Thanks.

[PB]

FYI, checked with ISO 16.04.01 and everything works as expected.

Thanks,

[Doug Burks]

Hi PB,

Yes, this is most likely related to the July 31 blog post:

https://blog.securityonion.net/2018/07/mysql-upgrade-errors.html

That blog post links to a workaround:

https://securityonion.net/wiki/MySQL-Upgrade-Errors

Have you tried the workaround?

Alternatively, we just released a new ISO image which avoids the MySQL issue altogether:

https://blog.securityonion.net/2018/08/security-onion-160451-now-available.html

--
Follow Security Onion on Twitter!
https://twitter.com/securityonion
---
You received this message because you are subscribed to the Google Groups "security-onion" group.
To unsubscribe from this group and stop receiving emails from it, send an email to security-onion+unsubscribe@googlegroups.com.
To post to this group, send email to security-onion@googlegroups.com.
Visit this group at https://groups.google.com/group/security-onion.
For more options, visit https://groups.google.com/d/optout.

--

Doug Burks
CEO
Security Onion Solutions, LLC

[PB]

Hi Doug,

I did try the workaround, but no success. I did not try too hard though as my priority was testing new hardware, so reverted to older SO ISO.

Tested the new ISO, 16.04.5.1, on two different types of hardware and everything worked as expected.

Thanks for the help.