search

Packet-Clearing-House / DNSAuth

Go-lang app to aggregate DNS queries to 1 minute buckets and write them to influxdb
MIT License
2 stars 2 forks source link

mysql: unknown auth plugin #7

Open mrjones-plip opened 6 years ago

mrjones-plip commented 6 years ago

If I use the default customer-db value in dnsauth.toml:

customer-db = "root:pass@(127.0.0.1)/customers"

Everything works fine. But if I use a custom one like this:

customer-db = "user:password@(192.168.68.42)/dns_query"

I get an error:

2018/06/14 19:50:37 [CustomerDB] Refreshing list from mysql...
[mysql] 2018/06/14 19:50:37 auth.go:293: unknown auth plugin:
[mysql] 2018/06/14 19:50:37 driver.go:120: could not use requested auth plugin '': this authentication plugin is not supported

The .42 IP is my mysql server with the zones table in the dns_query DB. The table is very large (80k+ rows).

I tested with different user name and passwords and database names and got the correct errors (bad auth & table not found), so it is connecting OK. Maybe it's still working? I'll test ingestion next, but we should resolve the error all the same.

mrjones-plip commented 6 years ago

oh! it might be helpful to know that even with an authentication error, the unknown auth plugin error hits regardless:

2018/06/14 21:10:10 [CustomerDB] Refreshing list from mysql...
[mysql] 2018/06/14 21:10:10 auth.go:293: unknown auth plugin:
[mysql] 2018/06/14 21:10:10 driver.go:120: could not use requested auth plugin '': this authentication plugin is not supported
2018/06/14 21:10:10 [CustomerDB] ERROR: Could not refresh customer list ( Error 1045: Access denied for user 'useeeer'@'192.168.68.110' (using password: YES) )!
mrjones-plip commented 6 years ago

It looks like this doesn't prevent ingestion, but I'm not sure if this affects #9 or not.