DEV Community: Jakub

Docker and Snort 3

Jakub — Tue, 08 Jun 2021 19:53:43 +0000

Hello,
My inquiry is about a project I'm building in Docker with Snort3 and what should be the correct way to have it set it up to get in the console the alerts logs.

The project is here: GitHub

I tried many researchers but was unable to make the correct setup for the HOME_NET and to see the alerts when I try to ping any of the IP addresses I set up in the snort.lua

Would be possible to get help to set it up correctly in my project?

I would like to make it work and correctly.

Please help me to improve my knowledge on this matter and the way I should make the set up with Docker to run Snort3 as should be.

Thank you for yours help :)

KnexJS: how to convert a SQL join with aliases and ordered by values from another table

Jakub — Thu, 08 Apr 2021 08:32:18 +0000

Hello DEV community,

I'm writing here as I'm a new in KnexJS query builder and need help to how to make a specific SQL script in KnexJS.

The script

SELECT
    c.id,
    c.topic,
    c.origin_type,
    c.origin_id,
    c.created_at,
    MAX(m.updated_at) updated_at
FROM
    conversation AS c
    JOIN message m ON m.conversation_id = c.id
GROUP BY
    c.id,
    c.topic,
    c.origin_type,
    c.origin_id,
    c.created_at
ORDER BY
    updated_at DESC

The script joins 2 tables message and conversation.
The result is all conversations ordered by the last created_at message in message table

example of an output result:

id	topic	origin_type	origin_id	created_at	updated_at
2	xx	aaa	bbb	2021-04-07 14:47:55.55+00	2021-04-07 18:47:43.558+00
1	xx	aaa	bbb	2021-04-07 14:37:45.446+00	2021-04-07 18:12:01.91+00
3	xx	aaa	bbb	2021-04-07 14:48:04.055+00	2021-04-07 14:56:52.709884+00

The updated_at is deducted from the message table where the last created message as created_at gives which is the newest updated_at conversation.

All what I need is to convert to KnexJs but I have no idea how to make it.

I hope what I explained is understandable and hope to get some help with that so I may learn the ideal way of doing it.

Thank you for yor time spent reading my help request :)

How to manage in React the statuses response from a Google API

Jakub — Tue, 05 Jan 2021 09:27:29 +0000

Hello,

I'm writing this post as I would like to learn and understand the best way to manage Google API status responses.

Link to statuses:
https://developers.google.com/places/web-service/autocomplete#place_autocomplete_status_codes

I would like to understand what should I do to cover the statuses in the right way and how to inform a client about it.

For example:
Probably with a status ZERO_RESULTS I can show a message to the client about the result was not a success.

But what about those statuses which are more for the dev team or management to know like this:
OVER_QUERY_LIMIT

Would be good to throw an error? and to client show, a message like The service is temporarily not available?

I would like to see some example of a good way of managing those statuses in React so I can learn a good practice :)

Thank you for your help :)