I have been using the GDataBase for MySQL toolkit for some time now and have had great success with the product. Recently, my team and I encountered some instances of the Saphir functions erroring out during execution; these are without code changes to the application build, so I am assuming they are environmental (network) and not so much an issue with the application or any Saphir product.
These errors occur during execution of the Open Connection function. Sometimes, it’s one or the other. In one case, it started out with these:
[20/01/20 17:25:42.574] DB Thread: Error at 'Open DB Connection' at Use DB. Code: 59. Reason:
TCP Open Connection in MySQLVIEW.lvlib:MySQLNetworkStream.lvclass:Open.vi->MySQLVIEW.lvlib:MySQLConnector.lvclass:Open.vi->GDatabase_TestVI.vi->RT_Target.vi
… then only showed these for a while after:
[20/01/20 17:32:38.534] DB Thread: Error at 'Open DB Connection' at Use DB. Code: 8044. Reason:
<Error from MySQL server>Access denied for user 'aeiuser'@'%' to database 'aeidb'
in MySQLVIEW.lvlib:MySQLConnector.lvclass:Open.vi->GDatabase_TestVI.vi->RT_Target.vi->
I was wondering if anyone has ever stumbled across this particular set of errors. I am curious as to what the database API is not liking, because I have independently verified that the credentials do in fact work (logged into database via separate DB application). The error is also very generalized and doesn’t go into too much depth. I do realize that is an NI code and nothing Saphir has injected.
Just curious if anyone has any thoughts on this. The database host system is a Raspberry Pi 4B running Raspbian Buster and MariaDB 10.4.11, and the network connectivity on the Pi sees wlan0 and eth0 configured as a bridge. I know there is some weirdness with those types of configuration and using non 4-byte addressing, but we do have a production version that is working just fine.
Thanks
R
