Getting Lasso to see MYSQL Databases

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

Getting Lasso to see MYSQL Databases

Duane Hannan
I have a new Mac OS 10.10.4/Lasso 8.6 setup.  I installed MySQL and can interact with it with the command line and with Sequel Pro.  I’ve turned on Apache and can hit an index page.  I installed lasso and succeeded in running it up with the the new lasso connector.  I can’t, however, see the databases/tables/records I created with the command line/Sequel Pro within the databasebrowser.lassoapp nor can I create a new database from that lassoapp.   I can see the lasso internal databases.

I’ve created an account using Sequel Pro to match up with the lasso site administrator account, but I don’t think that’s the right direction.  I’ve check the permission on the mysql folder in local: system:read/write, wheel:read, everyone:read; and the data folder in the mysql folder: lasso(which I created):read/write, _mysql:read/write, everyone:read; and the folder of the database I created in Sequel—TestDatabase:lasso:read/write, _mysql:read/write, everyone:read/write.

Clearly, lasso isn’t seeing into the folder that contains the mysql or it doesn’t have permission to.  When I try to add a database with databasebrowser.lassoapp, I get the message “In order to create a new database, one database on the host must be enabled (-1).

I’d appreciate greatly any advice.

Duane Hannan
WWG Schools



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

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: Getting Lasso to see MYSQL Databases

French, Shelane
In your site admin, have you gone to Setup > Data Sources?

Check that Lasso Connector for MySQL is enabled and that you've added your
host information.

On 7/31/15, 10:11 AM, "[hidden email] on behalf of
Duane Hannan" <[hidden email] on behalf of
[hidden email]> wrote:

>I have a new Mac OS 10.10.4/Lasso 8.6 setup.  I installed MySQL and can
>interact with it with the command line and with Sequel Pro.  I¹ve turned
>on Apache and can hit an index page.  I installed lasso and succeeded in
>running it up with the the new lasso connector.  I can¹t, however, see
>the databases/tables/records I created with the command line/Sequel Pro
>within the databasebrowser.lassoapp nor can I create a new database from
>that lassoapp.   I can see the lasso internal databases.
>
>I¹ve created an account using Sequel Pro to match up with the lasso site
>administrator account, but I don¹t think that¹s the right direction.
>I¹ve check the permission on the mysql folder in local:
>system:read/write, wheel:read, everyone:read; and the data folder in the
>mysql folder: lasso(which I created):read/write, _mysql:read/write,
>everyone:read; and the folder of the database I created in
>Sequel‹TestDatabase:lasso:read/write, _mysql:read/write,
>everyone:read/write.
>
>Clearly, lasso isn¹t seeing into the folder that contains the mysql or it
>doesn¹t have permission to.  When I try to add a database with
>databasebrowser.lassoapp, I get the message ³In order to create a new
>database, one database on the host must be enabled (-1).
>
>I¹d appreciate greatly any advice.
>
>Duane Hannan
>WWG Schools
>
>
>
>#############################################################
>
>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: Getting Lasso to see MYSQL Databases

Duane Hannan
Thanks, Shelane.  I had the connector enabled, but for no good reason, I changed the “IP Address/Host Name” from 127.0.0.1 to localhost.  The databases are now visible and I can create and so on.  I thought 127.0.0.1 equals localhost.  Shows how much I know.  Thanks for your help.

Duane Hannan
WWG Schools

On Jul 31, 2015, at 1:08 PM, French, Shelane <[hidden email]> wrote:

> In your site admin, have you gone to Setup > Data Sources?
>
> Check that Lasso Connector for MySQL is enabled and that you've added your
> host information.
>
> On 7/31/15, 10:11 AM, "[hidden email] on behalf of
> Duane Hannan" <[hidden email] on behalf of
> [hidden email]> wrote:
>
>> I have a new Mac OS 10.10.4/Lasso 8.6 setup.  I installed MySQL and can
>> interact with it with the command line and with Sequel Pro.  I¹ve turned
>> on Apache and can hit an index page.  I installed lasso and succeeded in
>> running it up with the the new lasso connector.  I can¹t, however, see
>> the databases/tables/records I created with the command line/Sequel Pro
>> within the databasebrowser.lassoapp nor can I create a new database from
>> that lassoapp.   I can see the lasso internal databases.
>>
>> I¹ve created an account using Sequel Pro to match up with the lasso site
>> administrator account, but I don¹t think that¹s the right direction.
>> I¹ve check the permission on the mysql folder in local:
>> system:read/write, wheel:read, everyone:read; and the data folder in the
>> mysql folder: lasso(which I created):read/write, _mysql:read/write,
>> everyone:read; and the folder of the database I created in
>> Sequel‹TestDatabase:lasso:read/write, _mysql:read/write,
>> everyone:read/write.
>>
>> Clearly, lasso isn¹t seeing into the folder that contains the mysql or it
>> doesn¹t have permission to.  When I try to add a database with
>> databasebrowser.lassoapp, I get the message ³In order to create a new
>> database, one database on the host must be enabled (-1).
>>
>> I¹d appreciate greatly any advice.
>>
>> Duane Hannan
>> WWG Schools
>>
>>
>>
>> #############################################################
>>
>> 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]>
Reply | Threaded
Open this post in threaded view
|

Re: Getting Lasso to see MYSQL Databases

French, Shelane
As far as servers are concerned, usually 127.0.0.1 is equal to localhost.
However, in MySQL, they can't be defined as different users. So if you
didn't have the one you were trying to connect with defined, it would not
have access.

On 7/31/15, 12:15 PM, "[hidden email] on behalf of
Duane Hannan" <[hidden email] on behalf of
[hidden email]> wrote:

>Thanks, Shelane.  I had the connector enabled, but for no good reason, I
>changed the “IP Address/Host Name” from 127.0.0.1 to localhost.  The
>databases are now visible and I can create and so on.  I thought
>127.0.0.1 equals localhost.  Shows how much I know.  Thanks for your help.
>
>Duane Hannan
>WWG Schools
>
>On Jul 31, 2015, at 1:08 PM, French, Shelane <[hidden email]> wrote:
>
>> In your site admin, have you gone to Setup > Data Sources?
>>
>> Check that Lasso Connector for MySQL is enabled and that you've added
>>your
>> host information.
>>
>> On 7/31/15, 10:11 AM, "[hidden email] on behalf of
>> Duane Hannan" <[hidden email] on behalf of
>> [hidden email]> wrote:
>>
>>> I have a new Mac OS 10.10.4/Lasso 8.6 setup.  I installed MySQL and can
>>> interact with it with the command line and with Sequel Pro.  I¹ve
>>>turned
>>> on Apache and can hit an index page.  I installed lasso and succeeded
>>>in
>>> running it up with the the new lasso connector.  I can¹t, however, see
>>> the databases/tables/records I created with the command line/Sequel Pro
>>> within the databasebrowser.lassoapp nor can I create a new database
>>>from
>>> that lassoapp.   I can see the lasso internal databases.
>>>
>>> I¹ve created an account using Sequel Pro to match up with the lasso
>>>site
>>> administrator account, but I don¹t think that¹s the right direction.
>>> I¹ve check the permission on the mysql folder in local:
>>> system:read/write, wheel:read, everyone:read; and the data folder in
>>>the
>>> mysql folder: lasso(which I created):read/write, _mysql:read/write,
>>> everyone:read; and the folder of the database I created in
>>> Sequel‹TestDatabase:lasso:read/write, _mysql:read/write,
>>> everyone:read/write.
>>>
>>> Clearly, lasso isn¹t seeing into the folder that contains the mysql or
>>>it
>>> doesn¹t have permission to.  When I try to add a database with
>>> databasebrowser.lassoapp, I get the message ³In order to create a new
>>> database, one database on the host must be enabled (-1).
>>>
>>> I¹d appreciate greatly any advice.
>>>
>>> Duane Hannan
>>> WWG Schools
>>>
>>>
>>>
>>> #############################################################
>>>
>>> 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]>


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

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]>