- ContactDB: Deleting organisations: The comparison of the organisation data stored in the database and the organisation data provided by the frontend now ignores empty 'expires' entries in all annotation types.
- For the Audit log
intelmq-certbund-contact
version 0.9.5 is required for theaudit_log
database table.
- Fixed compatibility of contactdb_api with PostsgreSQL >= 10.0.
- Added authorization and session handling.
- Added script to add users to the database.
- Tickets and Events:
- Send the timezone of the database via the /subqueries endpoint to allow the front end to display how values are interpreted in queries.
- Check that
SHOW timezone;
in the database gives a full timezone name, otherwise set it explicitly (find more details insetup()
of `events_apt/events_api/serve.py).
- Tickets and Events:
- Indicate a client problem, if stats? endpoints are called with their main range selection parameters given more than once.
- Small text improvement delete
Tag
fromRecipient Group Tag
subqueries.
- config/apache-example: Add LogFormat to log time taken to serve the request to the LogFormat.
- Tickets and Events:
- Improve frontend usability by automatically searching for substrings
in case of
_icontains
subqueries and by searching case-insensitive for strings in general. - Remove
_encl
subqueries as they are not needed. - Make subqueries similar (and equal in case of
intelmq-cb-mailgen
setups) between Tickets and Events.
- Improve frontend usability by automatically searching for substrings
in case of
- Events: Add default subqueries for recipient email addresses.
- Events: Fix endpoints that use queries with mailgen tables to also include events that have not been sent yet.
- Events: Fix
./stats?
to count events only once in case ofintelmq-cb-mailgen
setups. Note that several entries can be returned with the corresponding./search?
call. See usage hint for the reason.
-
Tickets:
- Change default parameters for
./stats?
to include the full last day (based on what is the timezone of the database.) - Cleanup code: Remove unused and broken
?id=
ability, change/?ticketnumber=
ability to return mailgen tables likeevents/search
.
- Change default parameters for
-
Events:
- Change
./search?
to return the columns frommailgen_directives
andmailgen_sent
tables as JSON values for easier handling in clients. - Remove
./export?
, as too similar to./search?
and assumed unused. - Fix subquery for "EventID" (broken since 0.6.4).
- Fix support for hug v==2.2.0 in three endpoints.
- Change
-
Events:
- Enhance endpoints
./search?
,./export?
to allow searching by columns from joineddirectives
andsent
tables for symmetry with the tickets backend. Add example for searching forrecipient_group
inaggregate_identifier
.
- Enhance endpoints
-
Contactdb:
- Enhance endpoint
./annotation/search?tag=
to additionally search for email tags and return organisations with those email addresses.
- Enhance endpoint
- Optional: Add an index for "
recipient_group
to directives (2019-10)", see https://github.com/Intevation/intelmq-mailgen/blob/master/sql/updates.txt
- Contactdb:
- Fix handling of email tags, by returning the correct default tags.
- Contactdb:
- Disallows creating CIDRs or FQDNs with the same value in a single contact; only the first will be inserted. If this happens it shows in loglevel INFO.
- Events:
- Additional configuration parameter
database table
to set the table name of the events table. Default isevents
.
- Additional configuration parameter
- Contacts: Add handling of email tags.
- Requirements: intelmq-certbund-contact>=0.9.4 on the db server.
- Contactdb:
- Adds GET and PUT endpoints for ./email/ and an additional endpoint GET /searchdisabledcontact to support the separate email_status table.
- Requirements: Check that we have postgresql v>=9.5.
- Checkticket:
- Adds optional
limit
parameter to endpoint./getEventsForTicket
. - Changes
getEventIDsForTicket
to returned a sorted list, to make the query result consistent for the same parameter.
- Adds optional
- Contactdb:
- Fixes search by email address so it filters out duplicates.
- Adds
tools/import_manual_contacts.py
to import manual contacts from a .csv file via TLS. - Adds sorting to some attribute lists when serving an org. Attributes sorted are contacts, asns, networks, fqdns, national_certs and tags.
- Events: Changes /search endpoint to return complete events (similar to checkticket's /getEvents)
- Events: Enhances subqueries:
- New subqueries can be added in the config file, see example configuration.
- The given parameter can be used multiple times in an SQL query,
for example:
("source.ip" = '%s' OR "destination.ip" = '%s')
- Configuration: (optional) Add the example subquery
all_ips
to the eventsdb config file to get one more useful query.
- Contactdb: Fixes annotation/search for organisation_annotations.
- Contactdb: Adds search for annotations by tag-name.
- Contactdb: Allows to configure the list of common "tags".
- Contactdb: Changes email search to be case-insensitive.
- Configuration: (optional) Add "common_tags" to the contactdb config file, otherwise the default ones may be exposed to users by the frontend.
- Contactdb: Allows tracking of db changes by user.
- Contactdb: Adds example script for importing a manual whitelist.
- Technical: Module called "intelmq-fody-backend" now
- Technical: Compatible with psycopg2 coming with Ubuntu 16.04LTS now.
- To enable tracking of db changes by user follow instructions in README.md.
- Technical: Must make sure that calling code uses the new module name.