[omd-users] Need help with mysql in OMD

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


Hello.

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'.

ex>
==================================
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
--log-error=/omd/sites/nsight/var/mysql/omd1.node-nine.com.err
--pid-file=/omd/sites/nsight/tmp/run/mysqld/mysqld.pid
--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
--socket=/omd/sites/nsight/tmp/run/mysqld/mysqld.sock
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
statement.

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!!!

-Chris

-------------- 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