Error in connection with mariadb

General
1

Hello,

I am trying in a simple projet (like a beginner...) to connect node-red to a database with mariadb (under raspberry pi)
I have already create the base under Mariadb and i can access it sous mariadb (root + Password).
But i can't do it under node red (node-red-node-mysql is istalled ...)
I receive this message in debug : Error: Packets out of order. Got: 1 Expected: 0"

phot1
phot11360×768 124 KB

phot2
phot21360×768 124 KB

Annyone have an idea ?
Thank !

2

which version of the node-red-node-mysql are you using ?
that sort of error usually indicates the server either not being there or disconnecting rapidly for some reason. Can you connect to it from another client (not command line ?)

3

Thanks for your prompt response !
The version is : 0.0.20
I Have not tried any other client : what advise you to test ?

4

I tried reinstalling my raspberry
Starting with phpmyadmin (avec apache2 et php 7), then node-red and its libraries: everything works perfectly!
But if I install behind raspap (I need a wifi access point): the problem comes back ...
Is there a conflict with raspap?

5

I wouldn't think there is a conflict - but more likely the security on mysql is blocking access to remote clients - so you need to configure it correctly to allow remote access - there are plenty of mysql guides to help that.

6

Thank you for this track that I will explore
But I don't really believe in it: raspap is used for the connection with the MQTT server and the arduino card and not between node-red and the mysql server (which is exclusively local)
In addition, this problem appears only after installing raspap ...
But it is worth trying!

7

Possibly this, though I don't see the connection with raspap

8

You were right: it is a problem of access rights with mariadb users!
This problem is caused by the installation of raspap: the database is no longer considered in localhost; however I do not use the access point to connect to it ...
For the moment I therefore declare the base on the IP address of eth0 and I give rights accordingly. But I don't find it practical or flexible. There must be a simpler solution.
Thank you very much for your wise advice!

9

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.