On 10/27/2017 1:23 PM, Matt Riedemann wrote:
Nova has had this long-standing known performance issue if you're
filtering a large number of instances by IP. The instance IPs are stored
in a JSON blob in the database so we don't do filtering in SQL. We pull
the instances out of the database, dese
FYI, Nova did use regex
https://github.com/openstack/nova/blob/master/nova/db/sqlalchemy/api.py#L2408
2017-10-27 11:35 GMT+08:00 Matt Riedemann :
> On 10/26/2017 9:54 PM, Tony Breeds wrote:
>
>> Can you use RLIKE/REGEX? or is that too MySQL specific ?
>>
>
> I thought about that, and my gut respo
Matt Riedemann wrote:
On 10/26/2017 10:56 PM, Joshua Harlow wrote:
Just the paranoid person in me, but is it safe to say that the filter
that you are showing here does not come from user text?
Ie these two lines don't come from a user input directly (without
going through some filter) do they?
On 10/26/2017 10:56 PM, Joshua Harlow wrote:
Just the paranoid person in me, but is it safe to say that the filter
that you are showing here does not come from user text?
Ie these two lines don't come from a user input directly (without going
through some filter) do they?
https://github.com/
On 2017-10-27 14:26:06 -0400 (-0400), Mohammed Naser wrote:
[...]
> in our experience, malicious VMs are not short lived but they are
> long lived. We'll generally find them running before we received
> the report which means that the abuse report came for that user
> indeed.
[...]
I guess the In
On Fri, Oct 27, 2017 at 12:48 PM, Jeremy Stanley wrote:
> On 2017-10-26 22:26:59 -0400 (-0400), Mohammed Naser wrote:
> [...]
> > The use-case for us is that it helps us easily identify or find VMs which
> > we get any abuse reports for (or anything we see malicious traffic going
> > to/from). W
On 2017-10-26 22:26:59 -0400 (-0400), Mohammed Naser wrote:
[...]
> The use-case for us is that it helps us easily identify or find VMs which
> we get any abuse reports for (or anything we see malicious traffic going
> to/from). We usually search for an *exact* match of the IP address as we
> are
Just the paranoid person in me, but is it safe to say that the filter
that you are showing here does not come from user text?
Ie these two lines don't come from a user input directly (without going
through some filter) do they?
https://github.com/openstack/nova/blob/16.0.0/nova/compute/api.py
On Thu, Oct 26, 2017 at 10:35:47PM -0500, Matt Riedemann wrote:
> On 10/26/2017 9:54 PM, Tony Breeds wrote:
> > Can you use RLIKE/REGEX? or is that too MySQL specific ?
>
> I thought about that, and my gut response is 'no' because even if it does
> work for mysql, I'm assuming regex pattern matchi
On 10/26/2017 9:54 PM, Tony Breeds wrote:
Can you use RLIKE/REGEX? or is that too MySQL specific ?
I thought about that, and my gut response is 'no' because even if it
does work for mysql, I'm assuming regex pattern matching for postgresql
is different. And then you have different API behavio
On Thu, Oct 26, 2017 at 09:23:50PM -0500, Matt Riedemann wrote:
> Nova has had this long-standing known performance issue if you're filtering
> a large number of instances by IP. The instance IPs are stored in a JSON
> blob in the database so we don't do filtering in SQL. We pull the instances
> ou
On Thu, Oct 26, 2017 at 10:23 PM, Matt Riedemann
wrote:
> Nova has had this long-standing known performance issue if you're
> filtering a large number of instances by IP. The instance IPs are stored in
> a JSON blob in the database so we don't do filtering in SQL. We pull the
> instances out of t
Nova has had this long-standing known performance issue if you're
filtering a large number of instances by IP. The instance IPs are stored
in a JSON blob in the database so we don't do filtering in SQL. We pull
the instances out of the database, deserialize the JSON and then apply a
regex filte
13 matches
Mail list logo