[omd-users] Need help with mysql in OMD

Chris Moody chris at node-nine.com
Sat Apr 7 02:33:03 CEST 2018


I recently started checking out the additional functionality built into
OMD and toggled on mysql in the 'omd config <site>' command.

Trouble is, when the site starts/stops, it complains about mysql access
not being allowed for 'root'@'localhost'.

root at omd1:~# omd start nsight
Creating temporary filesystem /omd/sites/nsight/tmp...OK
Starting mkeventd (builtin: syslog-udp,snmptrap)...OK
Starting gearmand...OK
Starting influxdb.........OK
Starting MySQL... .OK.
*ERROR 1698 (28000): Access denied for user 'root'@'localhost'*
Starting rrdcached...OK
Starting Grafana...OK
Starting gearman_worker...OK
Starting npcd...OK
Starting DataScryer...OK
Starting nagios...OK
Starting prometheus....OK
Starting dedicated Apache for site nsight...OK
Starting Nagflux...OK
Starting Nagios Service Check Acceptor...OK
Starting xinetd...OK
Initializing Crontab...OK

MySQL does start for the site instance, despite the error. 

root at omd1:~# ps aux | grep my
nsight    8500  0.0  0.1  18252  3092 pts/0    S    17:26   0:00
/bin/bash /usr/bin/mysqld_safe --defaults-file=.my.cnf
nsight    8643  0.0  1.5 260540 32404 pts/0    Sl   17:26   0:00
/usr/sbin/mysqld --defaults-file=.my.cnf --basedir=/usr
--datadir=/omd/sites/nsight/var/mysql --plugin-dir=/usr/lib/mysql/plugin
--socket=/omd/sites/nsight/tmp/run/mysqld/mysqld.sock --port=3306
root      9046  0.0  0.0  14224   976 pts/0    S+   17:26   0:00 grep
--color=auto my

And when I specify the socket to connect to via the CLI when I connect
to mysql, it allows 'root'@'localhost' in just fine currently without
any credentials.

root at omd1:~# mysql -p -u root
Enter password:  <ENTER>
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 9
Server version: 10.0.34-MariaDB-0ubuntu0.16.04.1 Ubuntu 16.04

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input

MariaDB [(none)]>

So two questions:

1.  What process/params is in need of correction/editing so that the
process that's complaining can in fact talk to mysql as needed.

2.  On that note, when I lock down MySQL to actually require valid
credentials, where would I need to specify this in 'omd land' so that
OMD plays nicely?

Thanks a ton in advance.  This is an incredible bundling of projects!!!


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mathias-kettner.de/pipermail/omd-users/attachments/20180406/4106c08c/attachment.html>

More information about the omd-users mailing list