Feb 26
Robert Givens Lasso 8.6.3 connectivity issue with MySQL
Feb 26, 2018; 12:25
Robert Givens
Lasso 8.6.3 connectivity issue with MySQL
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>
Mar 01
Bil Corry Re: Lasso 8.6.3 connectivity issue with MySQL
Mar 01, 2018; 20:21
Bil Corry
Re: Lasso 8.6.3 connectivity issue with MySQL
Mar 05
Robert Givens Re: Lasso 8.6.3 connectivity issue with MySQL
Mar 05, 2018; 16:27
Robert Givens
Re: Lasso 8.6.3 connectivity issue with MySQL
Mar 05
Mason Miller Re: Lasso 8.6.3 connectivity issue with MySQL
Mar 05, 2018; 16:38
Mason Miller
Re: Lasso 8.6.3 connectivity issue with MySQL
Mar 05
Ke Carlton Re: Lasso 8.6.3 connectivity issue with MySQL
Mar 05, 2018; 21:39
Ke Carlton
Re: Lasso 8.6.3 connectivity issue with MySQL
Mar 05
Steffan Cline Re: Lasso 8.6.3 connectivity issue with MySQL
Mar 05, 2018; 14:41
Steffan Cline
Re: Lasso 8.6.3 connectivity issue with MySQL
Mar 05
Robert Givens Re: Lasso 8.6.3 connectivity issue with MySQL
Mar 05, 2018; 15:52
Robert Givens
Re: Lasso 8.6.3 connectivity issue with MySQL
Mar 07
Bil Corry Re: Lasso 8.6.3 connectivity issue with MySQL
Mar 07, 2018; 09:04
Bil Corry
Re: Lasso 8.6.3 connectivity issue with MySQL
Mar 07
Jon Harris RE: Lasso 8.6.3 connectivity issue with MySQL
Mar 07, 2018; 17:02
Jon Harris
RE: Lasso 8.6.3 connectivity issue with MySQL