Lasso 8.6.3 connectivity issue with MySQL

classic Classic list List threaded Threaded
9 messages Options
Reply | Threaded
Open this post in threaded view
|

Lasso 8.6.3 connectivity issue with MySQL

Robert Givens
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 | [hidden email] <mailto:[hidden email]>

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

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Lasso 8.6.3 connectivity issue with MySQL

Bil Corry-3
Perhaps there's something here that can help?

https://stackoverflow.com/questions/7759170/mysql-table-doesnt-exist-but-it-does-or-it-should

What do the MySQL logs show?


- Bil


On Mon, Feb 26, 2018 at 10:25 AM, Robert Givens <[hidden email]> wrote:

> 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 | [hidden email] <mailto:[hidden email]>
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>   the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>

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

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Lasso 8.6.3 connectivity issue with MySQL

Robert Givens
In reply to this post by Robert Givens
> On Mar 1, 2018, at 10:22 PM, [hidden email] wrote:
>
> Perhaps there's something here that can help?
>
> https://stackoverflow.com/questions/7759170/mysql-table-doesnt-exist-but-it-does-or-it-should <https://stackoverflow.com/questions/7759170/mysql-table-doesnt-exist-but-it-does-or-it-should>
>
> What do the MySQL logs show?
>
>
> - Bil

Bil, thanks for the link. The symptom seemed the seem although their issues were caused by copying a database which was not the case here.

No errors are logged in the error log.
I set a general log in my.cnf.
In comparing the PHP vs the Lasso call. They are very similar:

PHP
2018-03-05T20:53:19.106598Z   25 Connect root@localhost on PDI using Socket
2018-03-05T20:53:19.106806Z   25 Query SELECT * FROM templates
2018-03-05T20:53:19.199382Z   25 Quit

Lasso
2018-03-05T20:53:22.518152Z   26 Connect root@localhost on  using Socket
2018-03-05T20:53:22.518224Z   26 Init DB pdi
2018-03-05T20:53:22.518299Z   26 Query SELECT * FROM templates
2018-03-05T20:53:22.518458Z   26 Quit

The only thing that looks suspicious is the difference in case for the database PDI, which is supposed to be uppercase. I suspect that if I restarted the server to fix the issue then the log entries for the same PHP and lasso tests would be identical. But for now I’m not restarting the server so that I might find the root cause to this.

Any ideas on what I should look at next?

~ Robert


>
>
> On Mon, Feb 26, 2018 at 10:25 AM, Robert Givens <[hidden email] <mailto:[hidden email]>> wrote:
>
>> 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 | [hidden email] <mailto:[hidden email]> <mailto:[hidden email] <mailto:[hidden email]>>


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

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Lasso 8.6.3 connectivity issue with MySQL

Mason Miller
There is an age old problem with Lasso’s ability to do DNS lookups dying until a restart. Have you tried 127.0.0.1 instead of localhost?

Mason

> On Mar 5, 2018, at 4:27 PM, Robert Givens <[hidden email]> wrote:
>
>> On Mar 1, 2018, at 10:22 PM, [hidden email] wrote:
>>
>> Perhaps there's something here that can help?
>>
>> https://stackoverflow.com/questions/7759170/mysql-table-doesnt-exist-but-it-does-or-it-should <https://stackoverflow.com/questions/7759170/mysql-table-doesnt-exist-but-it-does-or-it-should>
>>
>> What do the MySQL logs show?
>>
>>
>> - Bil
>
> Bil, thanks for the link. The symptom seemed the seem although their issues were caused by copying a database which was not the case here.
>
> No errors are logged in the error log.
> I set a general log in my.cnf.
> In comparing the PHP vs the Lasso call. They are very similar:
>
> PHP
> 2018-03-05T20:53:19.106598Z   25 Connect root@localhost on PDI using Socket
> 2018-03-05T20:53:19.106806Z   25 Query SELECT * FROM templates
> 2018-03-05T20:53:19.199382Z   25 Quit
>
> Lasso
> 2018-03-05T20:53:22.518152Z   26 Connect root@localhost on  using Socket
> 2018-03-05T20:53:22.518224Z   26 Init DB pdi
> 2018-03-05T20:53:22.518299Z   26 Query SELECT * FROM templates
> 2018-03-05T20:53:22.518458Z   26 Quit
>
> The only thing that looks suspicious is the difference in case for the database PDI, which is supposed to be uppercase. I suspect that if I restarted the server to fix the issue then the log entries for the same PHP and lasso tests would be identical. But for now I’m not restarting the server so that I might find the root cause to this.
>
> Any ideas on what I should look at next?
>
> ~ Robert
>
>
>>
>>
>> On Mon, Feb 26, 2018 at 10:25 AM, Robert Givens <[hidden email] <mailto:[hidden email]>> wrote:
>>
>>> 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 | [hidden email] <mailto:[hidden email]> <mailto:[hidden email] <mailto:[hidden email]>>
>
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>  the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>

Mason Miller

[hidden email]
https://www.listingstogo.com/

[hidden email]
https://www.sitewelder.com/

703-626-5532 cell



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

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Lasso 8.6.3 connectivity issue with MySQL

Ke Carlton-3
In reply to this post by Robert Givens
On some linux / MySQL configurations databases and table names can be case
sensitive.

You should try specifying the database in the correct case.

On Tue, Mar 6, 2018 at 10:27 AM Robert Givens <[hidden email]> wrote:

>
> The only thing that looks suspicious is the difference in case for the
> database PDI, which is supposed to be uppercase.

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

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Lasso 8.6.3 connectivity issue with MySQL

Steffan A. Cline
Typically Oracle will uppercase all table and column names but will take any combo in a query. I haven’t run across that issue on a connect string though. I’d recommend trying to uppercase as a test.

Thanks,
Steffan Cline
[hidden email]
602-793-0014

> On Mar 5, 2018, at 2:39 PM, Ke Carlton <[hidden email]> wrote:
>
> On some linux / MySQL configurations databases and table names can be case
> sensitive.
>
> You should try specifying the database in the correct case.
>
>> On Tue, Mar 6, 2018 at 10:27 AM Robert Givens <[hidden email]> wrote:
>>
>>
>> The only thing that looks suspicious is the difference in case for the
>> database PDI, which is supposed to be uppercase.
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>  the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>
>


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

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Lasso 8.6.3 connectivity issue with MySQL

Robert Givens
In reply to this post by Robert Givens
>
> There is an age old problem with Lasso?s ability to do DNS lookups dying until a restart. Have you tried 127.0.0.1 instead of localhost?
>
> Mason

Originally the host was set to 127.0.0.1. I changed it to localhost which is how PHP is accessing the database. The issue occurs when host is configured for either 127.0.0.1 or localhost.

~ Robert

>
>> On Mar 5, 2018, at 4:27 PM, Robert Givens <[hidden email] <mailto:[hidden email]>> wrote:
>>
>>> On Mar 1, 2018, at 10:22 PM, [hidden email] <mailto:[hidden email]> wrote:
>>>
>>> Perhaps there's something here that can help?
>>>
>>> https://stackoverflow.com/questions/7759170/mysql-table-doesnt-exist-but-it-does-or-it-should <https://stackoverflow.com/questions/7759170/mysql-table-doesnt-exist-but-it-does-or-it-should> <https://stackoverflow.com/questions/7759170/mysql-table-doesnt-exist-but-it-does-or-it-should <https://stackoverflow.com/questions/7759170/mysql-table-doesnt-exist-but-it-does-or-it-should>>
>>>
>>> What do the MySQL logs show?
>>>
>>>
>>> - Bil
>>
>> Bil, thanks for the link. The symptom seemed the seem although their issues were caused by copying a database which was not the case here.
>>
>> No errors are logged in the error log.
>> I set a general log in my.cnf.
>> In comparing the PHP vs the Lasso call. They are very similar:
>>
>> PHP
>> 2018-03-05T20:53:19.106598Z   25 Connect root@localhost on PDI using Socket
>> 2018-03-05T20:53:19.106806Z   25 Query SELECT * FROM templates
>> 2018-03-05T20:53:19.199382Z   25 Quit
>>
>> Lasso
>> 2018-03-05T20:53:22.518152Z   26 Connect root@localhost on  using Socket
>> 2018-03-05T20:53:22.518224Z   26 Init DB pdi
>> 2018-03-05T20:53:22.518299Z   26 Query SELECT * FROM templates
>> 2018-03-05T20:53:22.518458Z   26 Quit
>>
>> The only thing that looks suspicious is the difference in case for the database PDI, which is supposed to be uppercase. I suspect that if I restarted the server to fix the issue then the log entries for the same PHP and lasso tests would be identical. But for now I?m not restarting the server so that I might find the root cause to this.
>>
>> Any ideas on what I should look at next?
>>
>> ~ Robert


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

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Lasso 8.6.3 connectivity issue with MySQL

Bil Corry-3
In reply to this post by Ke Carlton-3
I concur - I would try using an uppercase PDI and see if that fixes it.

- Bil

On Mon, Mar 5, 2018 at 2:39 PM, Ke Carlton <[hidden email]> wrote:

> On some linux / MySQL configurations databases and table names can be case
> sensitive.
>
> You should try specifying the database in the correct case.
>
> On Tue, Mar 6, 2018 at 10:27 AM Robert Givens <[hidden email]> wrote:
>
> >
> > The only thing that looks suspicious is the difference in case for the
> > database PDI, which is supposed to be uppercase.
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>   the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>
>

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

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

RE: Lasso 8.6.3 connectivity issue with MySQL

Jon Harris-2
We put:

lower_case_table_names = 1

in our /etc/my.cnf, to sort out case issues from a mysql server moved from Windows to Centos.

HTH
Jon


-----Original Message-----
From: [hidden email] [mailto:[hidden email]] On Behalf Of Bil Corry
Sent: 07 March 2018 04:05 PM
To: [hidden email]
Subject: Re: Lasso 8.6.3 connectivity issue with MySQL

I concur - I would try using an uppercase PDI and see if that fixes it.

- Bil

On Mon, Mar 5, 2018 at 2:39 PM, Ke Carlton <[hidden email]> wrote:

> On some linux / MySQL configurations databases and table names can be
> case sensitive.
>
> You should try specifying the database in the correct case.
>
> On Tue, Mar 6, 2018 at 10:27 AM Robert Givens <[hidden email]> wrote:
>
> >
> > The only thing that looks suspicious is the difference in case for
> > the database PDI, which is supposed to be uppercase.
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>   the mailing list Lasso [hidden email] Official list
> archives available at http://www.lassotalk.com To unsubscribe, E-mail
> to: <[hidden email]>
> Send administrative queries to  <[hidden email]>
>

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

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

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

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