Enabling New Databases Automagically

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

Enabling New Databases Automagically

Stephen Christiansen
All...

I am working in a MySQL environment where databases that need to interact with Lasso are dynamically created by another process. I have no problem querying the new databases after they have been enabled in Lasso Security with "Enable All New," but the problem is that I don't know when they have been created.

Is it possible to run a page with a timed process (Event) that can Enable All New databases found on a server. If this is possible, insight on what the script would look like would be greatly appreciated.

Thanks,
Steve
**************************************
Steve Christiansen
Technical Support
K12 Services, Inc.
11 N. Washington Street Suite 510
Rockville, MD 20850

“Our Goal is to Remove Non-Value Added Costs from K12 Procurement”
**************************************



#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Enabling New Databases Automagically

Marc Vos
I think this problem only occurs when you use Lasso-syntax in inlines. If you can convert them to -SQL queries, and enable SQL in SiteAdmin, I think you avoid the problem you're having.

- -
Marc

Sent from my iPhone

On 19 jul. 2012, at 22:31, Stephen Christiansen <[hidden email]> wrote:

> All...
>
> I am working in a MySQL environment where databases that need to interact with Lasso are dynamically created by another process. I have no problem querying the new databases after they have been enabled in Lasso Security with "Enable All New," but the problem is that I don't know when they have been created.
>
> Is it possible to run a page with a timed process (Event) that can Enable All New databases found on a server. If this is possible, insight on what the script would look like would be greatly appreciated.
>
> Thanks,
> Steve
> **************************************
> Steve Christiansen
> Technical Support
> K12 Services, Inc.
> 11 N. Washington Street Suite 510
> Rockville, MD 20850
>
> “Our Goal is to Remove Non-Value Added Costs from K12 Procurement”
> **************************************
>
>
>
> #############################################################
> This message is sent to you because you are subscribed to
>  the mailing list Lasso
> [hidden email]
> 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]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Enabling New Databases Automagically

Ke Carlton-3
You can also go down the -host route and bypass Lasso security altogether.

Ke

On 19 July 2012 21:40, Marc Vos <[hidden email]> wrote:

> I think this problem only occurs when you use Lasso-syntax in inlines. If
> you can convert them to -SQL queries, and enable SQL in SiteAdmin, I think
> you avoid the problem you're having.
#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Enabling New Databases Automagically

Stephen Christiansen
In reply to this post by Marc Vos
Ke,

Thanks, but I am using -SQL syntax and the host and databases (all) are set to allow SQL. That doesn't appear to be the solution.

Steve
**************************************
Steve Christiansen
Technical Support
K12 Services, Inc.
11 N. Washington Street Suite 510
Rockville, MD 20850

“Our Goal is to Remove Non-Value Added Costs from K12 Procurement”
**************************************



On Jul 19, 2012, at 4:40 PM, Marc Vos wrote:

> I think this problem only occurs when you use Lasso-syntax in inlines. If you can convert them to -SQL queries, and enable SQL in SiteAdmin, I think you avoid the problem you're having.
>
> - -
> Marc
>
> Sent from my iPhone
>
> On 19 jul. 2012, at 22:31, Stephen Christiansen <[hidden email]> wrote:
>
>> All...
>>
>> I am working in a MySQL environment where databases that need to interact with Lasso are dynamically created by another process. I have no problem querying the new databases after they have been enabled in Lasso Security with "Enable All New," but the problem is that I don't know when they have been created.
>>
>> Is it possible to run a page with a timed process (Event) that can Enable All New databases found on a server. If this is possible, insight on what the script would look like would be greatly appreciated.
>>
>> Thanks,
>> Steve
>> **************************************
>> Steve Christiansen
>> Technical Support
>> K12 Services, Inc.
>> 11 N. Washington Street Suite 510
>> Rockville, MD 20850
>>
>> “Our Goal is to Remove Non-Value Added Costs from K12 Procurement”
>> **************************************
>>
>>
>>
>> #############################################################
>> This message is sent to you because you are subscribed to
>> the mailing list Lasso
>> [hidden email]
>> 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]
> 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]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Enabling New Databases Automagically

Ke Carlton-3
Hey — I suggested using -host and bypass security:

inline(
-host=array(
-datasource='mysqlds',
-name='192.168.0.1',
-username='user',
 -password='****'
),
-database = 'xxx',
-sql = 'show tables'
);

/inline;

Ke


On 19 July 2012 22:07, Stephen Christiansen <
[hidden email]> wrote:

> Ke,
>
> Thanks, but I am using -SQL syntax and the host and databases (all) are
> set to allow SQL. That doesn't appear to be the solution.
>
> Steve
> **************************************
> Steve Christiansen
> Technical Support
> K12 Services, Inc.
> 11 N. Washington Street Suite 510
> Rockville, MD 20850
>
> “Our Goal is to Remove Non-Value Added Costs from K12 Procurement”
> **************************************
>
>
>
> On Jul 19, 2012, at 4:40 PM, Marc Vos wrote:
>
> > I think this problem only occurs when you use Lasso-syntax in inlines.
> If you can convert them to -SQL queries, and enable SQL in SiteAdmin, I
> think you avoid the problem you're having.
> >
> > - -
> > Marc
> >
> > Sent from my iPhone
> >
> > On 19 jul. 2012, at 22:31, Stephen Christiansen <
> [hidden email]> wrote:
> >
> >> All...
> >>
> >> I am working in a MySQL environment where databases that need to
> interact with Lasso are dynamically created by another process. I have no
> problem querying the new databases after they have been enabled in Lasso
> Security with "Enable All New," but the problem is that I don't know when
> they have been created.
> >>
> >> Is it possible to run a page with a timed process (Event) that can
> Enable All New databases found on a server. If this is possible, insight on
> what the script would look like would be greatly appreciated.
> >>
> >> Thanks,
> >> Steve
> >> **************************************
> >> Steve Christiansen
> >> Technical Support
> >> K12 Services, Inc.
> >> 11 N. Washington Street Suite 510
> >> Rockville, MD 20850
> >>
> >> “Our Goal is to Remove Non-Value Added Costs from K12 Procurement”
> >> **************************************
> >>
> >>
> >>
> >> #############################################################
> >> This message is sent to you because you are subscribed to
> >> the mailing list Lasso
> >> [hidden email]
> >> 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]
> > 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]
> 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]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Enabling New Databases Automagically

Wade Maxfield
In reply to this post by Stephen Christiansen
On 20/07/2012, at 9:07 AM, Stephen Christiansen wrote:

> Ke,
>
> Thanks, but I am using -SQL syntax and the host and databases (all) are set to allow SQL. That doesn't appear to be the solution.

Set up a default table that uses the same encoding as your dynamic tables, enable that in your Lasso Security setup. Use this default table as the -table parameter for all your inlines, but use the real table name you want in the actual SQL statement.

 - Wade


#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Enabling New Databases Automagically

Stephen Christiansen
Ke and Wade,

Thanks very much for your suggestions. I am experimenting.

Steve
**************************************
Steve Christiansen
Technical Support
K12 Services, Inc.
11 N. Washington Street Suite 510
Rockville, MD 20850

“Our Goal is to Remove Non-Value Added Costs from K12 Procurement”
**************************************



On Jul 19, 2012, at 6:06 PM, Wade Maxfield wrote:

> On 20/07/2012, at 9:07 AM, Stephen Christiansen wrote:
>
>> Ke,
>>
>> Thanks, but I am using -SQL syntax and the host and databases (all) are set to allow SQL. That doesn't appear to be the solution.
>
> Set up a default table that uses the same encoding as your dynamic tables, enable that in your Lasso Security setup. Use this default table as the -table parameter for all your inlines, but use the real table name you want in the actual SQL statement.
>
> - Wade
>
>
> #############################################################
> This message is sent to you because you are subscribed to
>  the mailing list Lasso
> [hidden email]
> 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]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>