Public bug reported:
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.
** Affects: mosquitto (Ubuntu)
Importance: Undecided
Status: New
** Description changed:
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.
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1752985
Title:
auth plugin socket error
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mosquitto/+bug/1752985/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
