Longview can't auto-create MariaDB creds on Debian 9

[displague]

longview/debian/linode-longview.config

Line 174 in 536c819

mysql_password=$(egrep '^\s*password\s*=\s*' /etc/mysql/debian.cnf | head -n1 | sed 's/^\s*password\s*=\s*//')

should be adjusted to fetch the username associated with the "Upgrades" account. In Debian9 with MariaDB (which is a silent replacement for mysql-server) this account is now "root" rather than "debian-sys-maint".

---

Seen during Longview Client install:

Unable to automatically configure MySQL plugin:

Longview has detected MySQL running on this server but was unable to automatically configure the connection. To allow Longview to access your MySQL instance please run the following queries:

---

root@debian:~# cat /etc/mysql/debian.cnf
# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host     = localhost
user     = root
password =
socket   = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host     = localhost
user     = root
password =
socket   = /var/run/mysqld/mysqld.sock
basedir  = /usr

[displague]

The socket file should also be parsed from the config rather than assuming the default, as reported in #17