Thank you for the pointer Sven. I executed that in the /omd/sites/<site> directory and su'd to the <site> user in question since I noticed the proceeding '.' before the path. Here's the results.
root@omd1:/omd/sites/nsight# su - nsight OMD[nsight]:~$ OMD[nsight]:~$ OMD[nsight]:~$ OMD[nsight]:~$ bash -x ./etc/init.d/mysql start + cd /omd/sites/nsight + . lib/omd/init_profile + . etc/omd/site.conf ++ CONFIG_ADMIN_MAIL=hostmas...@node-nine.com ++ CONFIG_ALERTMANAGER=off ++ CONFIG_ALERTMANAGER_TCP_ADDR=127.0.0.1 ++ CONFIG_ALERTMANAGER_TCP_PORT=9094 ++ CONFIG_APACHE_MODE=own ++ CONFIG_APACHE_TCP_ADDR=127.0.0.1 ++ CONFIG_APACHE_TCP_PORT=5001 ++ CONFIG_AUTOSTART=on ++ CONFIG_BLACKBOX_EXPORTER=off ++ CONFIG_BLACKBOX_EXPORTER_TCP_ADDR=127.0.0.1 ++ CONFIG_BLACKBOX_EXPORTER_TCP_PORT=9116 ++ CONFIG_CORE=nagios ++ CONFIG_CRONTAB=on ++ CONFIG_DATASCRYER=on ++ CONFIG_DEFAULT_GUI=thruk ++ CONFIG_DOKUWIKI_AUTH=off ++ CONFIG_DOWNTIMEAPI=on ++ CONFIG_GEARMAND=on ++ CONFIG_GEARMAND_PORT=localhost:4730 ++ CONFIG_GEARMAN_NEB=on ++ CONFIG_GEARMAN_WORKER=on ++ CONFIG_GRAFANA=on ++ CONFIG_GRAFANA_TCP_PORT=8004 ++ CONFIG_INFLUXDB=on ++ CONFIG_INFLUXDB_HTTP_TCP_PORT=127.0.0.1:8086 ++ CONFIG_INFLUXDB_META_TCP_PORT=8089 ++ CONFIG_INFLUXDB_RETENTION=104 ++ CONFIG_LIVESTATUS_TCP=on ++ CONFIG_LIVESTATUS_TCP_PORT=6557 ++ CONFIG_MKEVENTD=on ++ CONFIG_MKEVENTD_SNMPTRAP=on ++ CONFIG_MKEVENTD_SYSLOG=on ++ CONFIG_MKEVENTD_SYSLOG_TCP=off ++ CONFIG_MOD_GEARMAN=on ++ CONFIG_MULTISITE_AUTHORISATION=off ++ CONFIG_MULTISITE_COOKIE_AUTH=off ++ CONFIG_MYSQL=on ++ CONFIG_NAGFLUX=on ++ CONFIG_NAGIOS_THEME=classicui ++ CONFIG_NAGVIS_URLS=thruk ++ CONFIG_NSCA=on ++ CONFIG_NSCA_TCP_PORT=5667 ++ CONFIG_PNP4NAGIOS=on ++ CONFIG_PROMETHEUS=on ++ CONFIG_PROMETHEUS_SNMP_ADDR=127.0.0.1 ++ CONFIG_PROMETHEUS_SNMP_EXPORTER=off ++ CONFIG_PROMETHEUS_SNMP_PORT=9217 ++ CONFIG_PROMETHEUS_TCP_ADDR=127.0.0.1 ++ CONFIG_PROMETHEUS_TCP_PORT=9091 ++ CONFIG_SNMPTRAPD=off ++ CONFIG_SNMPTRAPD_UDP_PORT=9163 ++ CONFIG_THRUK_COOKIE_AUTH=on ++ CONFIG_THRUK_LOGCACHE=on ++ CONFIG_TMPFS=on + '[' on '!=' on ']' + MYSQLD_PID=tmp/run/mysqld/mysqld.pid + MYSQL_CNF=.my.cnf + __init_hook ./etc/init.d/mysql start pre + '[' -h ./etc/init.d/mysql ']' + file=./etc/init.d/mysql ++ printf /omd/sites/nsight/etc/init-hooks.d/%s-%s-%s mysql start pre + hook=/omd/sites/nsight/etc/init-hooks.d/mysql-start-pre + '[' -x /omd/sites/nsight/etc/init-hooks.d/mysql-start-pre ']' + '[' -e /omd/sites/nsight/etc/init-hooks.d/mysql-start-pre ']' + case $1 in + echo -n 'Starting MySQL... ' Starting MySQL... + check_install_db + '[' '!' -e /omd/sites/nsight/var/mysql/mysql ']' + mysql_wait_start + mysqld_status check_alive nowarn ++ mysqladmin --defaults-file=.my.cnf ping *+ ping_output='mysqladmin: connect to server at '\''localhost'\'' failed* *error: '\''Access denied for user '\''root'\''@'\''localhost'\'''\'''* + ping_alive=1 + ps_alive=0 + '[' -f tmp/run/mysqld/mysqld.pid ']' ++ cat tmp/run/mysqld/mysqld.pid + ps 8643 + ps_alive=1 + '[' check_alive = check_alive -a 1 = 1 ']' + return 0 + echo -n 'already running. ' already running. + return 1 + echo ERROR. ERROR. + __init_hook ./etc/init.d/mysql start post 1 + '[' -h ./etc/init.d/mysql ']' + file=./etc/init.d/mysql ++ printf /omd/sites/nsight/etc/init-hooks.d/%s-%s-%s mysql start post + hook=/omd/sites/nsight/etc/init-hooks.d/mysql-start-post + '[' -x /omd/sites/nsight/etc/init-hooks.d/mysql-start-post ']' + '[' -e /omd/sites/nsight/etc/init-hooks.d/mysql-start-post ']' + exit 1 OMD[nsight]:~$ Reading the init script (which again, thank you for the pointer - I didn't even think that there would be localized ./etc/init.d/ scripts per site/user. I need to explore the filesystem layout a bit more) it's the mysqladmin 'ping' that's complaining in the init script. Testing a bit more, when su'd as the site-user, mysqladmin throws the error upon trying to login/connect however when just logged in as root, a user can get in just fine. Now I at least know where to keep digging and adjusting to help get the permissions functioning. I'll post my results once I have it functioning. Cheers, -Chris On 4/8/18 11:40 PM, Sven Nierlein wrote: > bash -x ./etc/init.d/mysql start
_______________________________________________ omd-users mailing list omd-users@lists.mathias-kettner.de http://lists.mathias-kettner.de/mailman/listinfo/omd-users
