Activity log for bug #1752985

Date Who What changed Old value New value Message
2018-03-02 21:02:11 Domingo Oropeza bug added bug
2018-03-02 21:03:05 Domingo Oropeza description Hello, I'm compiling the auth-plugin from the source and after a successful make I copied the so to /usr/lib/mosquitto-auth-plugin/auth-plugin.so and added the following lines to /etc/mosquitto/conf.d/auth-plug.conf auth_plugin /usr/lib/mosquitto-auth-plugin/auth-plugin.so auth_opt_backends mysql auth_opt_host 127.0.0.1 auth_opt_port 3306 auth_opt_user mosquitto auth_opt_dbname glpilocal auth_opt_pass 12345 auth_opt_cacheseconds 300 after restart the service I can't use it. the following errors are showed on the log 1520023868: mosquitto version 1.4.15 (build date Fri, 02 Mar 2018 13:11:49 +0000) starting 1520023868: Config loaded from /etc/mosquitto/mosquitto.conf. 1520023868: Opening ipv4 listen socket on port 1883. 1520023868: Opening ipv6 listen socket on port 1883. 1520023872: New connection from 127.0.0.1 on port 1883. 1520023872: New client connected from 127.0.0.1 as mqttac69a6ddbf38c7bf (c1, k50, u'flyvemdm-backend'). 1520023872: Socket error on client mqttac69a6ddbf38c7bf, disconnecting. 1520023877: New connection from 127.0.0.1 on port 1883. 1520023877: New client connected from 127.0.0.1 as mqtta0b8c7ef9c5cef65 (c1, k50, u'flyvemdm-backend'). 1520023877: Socket error on client mqtta0b8c7ef9c5cef65, disconnecting. 1520023882: New connection from 127.0.0.1 on port 1883. Hello, I'm compiling the auth-plugin from the source and after a successful make I copied the so to /usr/lib/mosquitto-auth-plugin/auth-plugin.so and added the following lines to /etc/mosquitto/conf.d/auth-plug.conf auth_plugin /usr/lib/mosquitto-auth-plugin/auth-plugin.so auth_opt_backends mysql auth_opt_host 127.0.0.1 auth_opt_port 3306 auth_opt_user mosquitto auth_opt_dbname glpilocal auth_opt_pass 12345 auth_opt_userquery SELECT password FROM glpi_plugin_flyvemdm_mqttusers WHERE user='%s' AND enabled='1' auth_opt_aclquery SELECT topic FROM glpi_plugin_flyvemdm_mqttacls a LEFT JOIN glpi_plugin_flyvemdm_mqttusers u ON (a.plugin_flyvemdm_mqttusers_id = u.id) WHERE u.user='%s' AND u.enabled='1' AND (a.access_level & %d) auth_opt_cacheseconds 300 after restart the service I can't use it. the following errors are showed on the log 1520023868: mosquitto version 1.4.15 (build date Fri, 02 Mar 2018 13:11:49 +0000) starting 1520023868: Config loaded from /etc/mosquitto/mosquitto.conf. 1520023868: Opening ipv4 listen socket on port 1883. 1520023868: Opening ipv6 listen socket on port 1883. 1520023872: New connection from 127.0.0.1 on port 1883. 1520023872: New client connected from 127.0.0.1 as mqttac69a6ddbf38c7bf (c1, k50, u'flyvemdm-backend'). 1520023872: Socket error on client mqttac69a6ddbf38c7bf, disconnecting. 1520023877: New connection from 127.0.0.1 on port 1883. 1520023877: New client connected from 127.0.0.1 as mqtta0b8c7ef9c5cef65 (c1, k50, u'flyvemdm-backend'). 1520023877: Socket error on client mqtta0b8c7ef9c5cef65, disconnecting. 1520023882: New connection from 127.0.0.1 on port 1883.