Hi,
I’m in need of help with an Lasso 8.6.3 connectivity issue with MySQL.

Lasso can no longer access MySQL records until server is restarted, where it was able to access a MySQL database and multiple tables within without issue.

Running Lasso 8.6.3 on CentOS 6.9, MySQL 5.7.20, AWS t2.small instance

Found this in the Lasso Error logs: Error: MySQLDS: error from mysql: 1146 Table 'pdi.templates' doesn't exist. The same error message appears for all tables lasso attempts to query.

What I’ve tried.
* Verified that the tables lasso is reporting as missing do exist with records in MySQL.
* Verified that PHP can access the same table and records with identical query not working for Lasso
* Restarting MySQL - Doesn’t fix the issues
* Restarting Lasso - Doesn’t fix the issues
* Restarting the server - Fixes the issue but only temporally.


What might have triggered this issue. These are the only two actions that I’m fairly certain caused the problem, but it has occurred a half dozen times since setting up this server in November 2017.
* Restarting Apache service after updating http.conf with a new secure certificate. Prior to the restart the server ran for two weeks without issue.
* Adding a field to a MySQL table via Lasso Database browser.

What might be the root cause of this issue?

Thank you,

Robert W. Givens
IMAGERS | Senior Web Developer
1575 Northside Drive #490 | Atlanta GA 30318
Direct: 404.605.8339 | robert@imagers.com <mailto:ben@imagers.com>

#############################################################

This message is sent to you because you are subscribed to
the mailing list Lasso Lasso@lists.lassosoft.com
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>