Commit Graph

247 Commits (2.4)

Author SHA1 Message Date
iglocska 296db741a2
fix: [permissions] Fixed the default sync/user/publisher permissions to include perm_tagger and perm_tag_editor(sync only) 2019-06-11 09:24:16 +02:00
Richard van den Berg 1a855f2ddf Be consistent in quoting table names 2019-04-04 11:27:16 +02:00
Nikos Filippakis 9d59b10368 Publish events to Kafka
Signed-off-by: Nikos Filippakis <nikolaos.filippakis@cern.ch>
2019-03-18 15:53:22 +01:00
iglocska 1bad3580ea fix: [data model] added the fix to the org_id field in the tag table to the mysql.sql file 2019-01-01 16:39:32 +01:00
iglocska d4992f5b7d fix: [setup] Brought MYSQL.sql up to date, fixes #3357, fixes #3358 2018-06-20 06:30:01 +02:00
iglocska cc9b182a87 chg: Changed the org admin role to not have sync privileges by default 2018-04-23 12:46:00 +02:00
Matt Carothers f5c5afa5ac Updated model column length to 80 characters 2018-02-14 15:33:19 -05:00
iglocska 8b78df3cf9 fix: Added missing db field to users
- fixes a nasty issue with saving users failing when ZMQ is enabled on instances installed after 2.4.69
- fixes a typo that caused invalid user changes being pushed to the ZMQ channel
2018-02-02 19:44:41 +01:00
iglocska 5e04ac97f9 fix: user_id in tag table was not included in MYSQL.sql
- added it to the initial db bootstrap along with an upgrade script for existing MISPs missing the field
2018-02-01 04:32:49 +01:00
iglocska f955f7ef6d fix: aadmin settings version updated 2018-01-17 09:19:57 +01:00
iglocska d0a6d0ff0b fix: Fixed typo in field name for the object templates
- disable_correlation(s) - s was a mistake and it caused the feature in the templates not to work
2017-12-07 15:00:20 +01:00
iglocska 5abdc39a56 fix: Added new field to MYSQL.sql 2017-11-28 12:02:26 +01:00
iglocska 68d9a14ab6 fix: Added missing IP field to logs 2017-10-20 14:34:18 +02:00
iglocska d0e99c061e new: Further progress on the graphing
- also, added new icon field to galaxies
2017-10-08 15:32:26 +02:00
iglocska e9ac667afe fix: Fixed no specification of the tinyint length for the objects in MYSQL.sql 2017-09-19 09:50:05 +02:00
iglocska bb99706cf3 new: Various object template improvements
- allow multiple versions of a template to be stored at the same time
- select which version is the primary version of a template
- disable/enable templates
- edit objects with one of the older versions of a template if the object's version requires that

- various UI / bug fixes
2017-09-18 00:38:30 +02:00
iglocska 03881e40c1 chg: Rename two fields in the object references
- source_uuid => object_uuid
- destination_uuid => referenced_uuid
2017-09-07 14:00:18 +02:00
iglocska c09741ebfc new: Further work on the objects
- uuids of both sides saved in references
- attachment adding fixed
2017-09-01 17:42:54 +02:00
iglocska 5552d7c030 new: Several new features
- added multiple flag among other things
2017-08-29 18:28:18 +02:00
iglocska 961bc76393 Merge branch '2.4' into objects_wip 2017-08-21 10:17:16 +02:00
iglocska 859d6e1c46 new: Added object relations 2017-08-21 10:13:19 +02:00
iglocska be38a769c2 fix: Fixed mistyped field 2017-08-16 22:25:56 +02:00
iglocska 8be3f61be6 fix: Fixes to the galaxy import tool 2017-08-16 22:18:32 +02:00
iglocska e9caf3c180 fix: Fixed an outdated index pointing to a now non-existant field 2017-08-10 09:12:21 +02:00
iglocska 0e7dd2eddc new: Added first iteration of object references and other changes
- various fixes
- rework of the pagination library
2017-08-09 17:53:25 +02:00
iglocska 8f6b53ee24 new: Progress on the Objects
- Fixed UI elements in the event view
- Added object-aware filtering to the event view
- Objects can now be deleted and viewed once deleted
  - object sanitisation if the setting is set is implemented
- Edit objects directly from the interface (if the template exists)
- Various other fixes
2017-08-06 18:23:24 +02:00
iglocska 48423fa181 fix: Added description field to object template elements 2017-08-03 14:44:33 +02:00
iglocska 1bf51908ea fix: Fixed previous commit 2017-08-03 14:26:11 +02:00
iglocska 04ffe988a5 fix: Missing field in object template elements added to match upgrade script 2017-08-03 14:23:35 +02:00
iglocska 3b004d5686 Merge branch '2.4' into objects_wip 2017-08-03 11:20:34 +02:00
iglocska f89a9ce061 fix: Added user password length change to the MYSQL.sql file 2017-07-12 15:59:20 +02:00
iglocska a5d582750e fix: Updated fields 2017-07-06 15:02:19 +02:00
iglocska 38d02692df fix: Removed obsolete table 2017-07-05 10:55:07 +02:00
iglocska 38620a4c0e fix: Fixed object references table 2017-07-05 10:36:45 +02:00
iglocska d10c7cd4b0 Merge branch '2.4' into objects_wip 2017-07-02 00:08:14 +02:00
iglocska ee1c1c5de9 new: Further progress on the objects 2017-07-02 00:05:15 +02:00
iglocska f53d954c51 fix: Removed unused fulltext index in favour of 255 length index 2017-06-29 07:44:14 +02:00
iglocska 93a99208c6 Merge branch '2.4' into feature/objects 2017-06-13 12:08:26 +02:00
iglocska 2b6ddaff95 chg: Added new fields to mysql 2017-06-13 12:00:32 +02:00
iglocska c80621d2ef fix: Removed two duplicate fields from MYSQL.sql 2017-05-10 14:33:05 +02:00
iglocska 4ba1fb8fd8 fix: Added missing fields causing pulled events to not contain attributes, fixes #2171 2017-05-10 14:24:34 +02:00
Andras Iklody 699be1ed30 Merge pull request #1947 from SekoiaLab/fix/install_sql
Fix/install sql
2017-04-30 18:42:45 +02:00
devnull- 9835b8932f Merge branch '2.4' into issues_1643 2017-04-27 10:04:32 +02:00
juju4 47cfcd1047 Remove default value for column comment
ERROR 1101 (42000) at line 20: BLOB, TEXT, GEOMETRY or JSON column 'comment' can't have a default value
https://travis-ci.org/juju4/ansible-MISP/jobs/222624828#L7561
(ubuntu xenial, mysql 5.7)
https://dev.mysql.com/doc/refman/5.7/en/blob.html

Strangely, this does not affect centos7 and mariadb 5.5 even if corresponding documentation states the same.
https://travis-ci.org/juju4/ansible-MISP/jobs/222624827#L4862
2017-04-16 18:05:47 -04:00
iglocska 8acd4a783d chg: DB changes pre-loaded for 2.4.71 2017-04-10 17:25:10 +02:00
Richard van den Berg bc37031530 Add perm_sighting to initial database and roles 2017-03-17 14:43:41 +01:00
iglocska 048cfab5a9 fix: Fixed sql fail 2017-03-08 17:55:20 +01:00
iglocska e1baec2896 fix: Fixed some default value issues with taxonomy colours 2017-03-08 15:04:38 +01:00
iglocska 46695b8ca2 fix: Several blacklist related fixes
- turned the functionality to a default on feature
- added indexes
- fixed some default values
2017-03-07 17:39:44 +01:00
devnull- 89e76bc859 Merge branch '2.4' into issues_1643 2017-02-28 15:47:28 +01:00
iglocska 470f90b5b5 fix: More invalid MySQL fields fixed 2017-02-24 11:17:10 +01:00
iglocska 72d6b275ba fix: Fixed a mysql issue 2017-02-24 11:12:30 +01:00
devnull- f35d247930 Merge branch '2.4' into issues_1643 2017-02-20 09:23:07 +01:00
iglocska 1251eb8189 fix: Added missing column in MYSQL.sql and some indexing 2017-02-17 09:46:07 +01:00
iglocska 2f80d46dcf fix: typo 2017-02-17 09:39:24 +01:00
iglocska 88c08af7df fix: MYSQL.sql brought up to date 2017-02-17 09:34:56 +01:00
devnull- f24682f86a Merge branch '2.4' into issues_1643 2017-02-16 21:49:45 +01:00
Adrien RAFFIN 9dd55f5380 fix: Add event_blacklists and org_blacklists in MYSQL install scripts 2017-02-16 13:04:30 +01:00
iglocska 4ad022b03c Merge branch '2.4' into feature/attribute-tagging 2017-01-16 16:15:06 +01:00
iglocska 44fcf5dfdb chg: Added event ID to the attribute level tags 2017-01-14 00:16:05 +01:00
devnull- d500f8682d Update the database schema unpublish_event (servers) & PublishWithoutEmail (servers) 2017-01-05 16:40:40 +01:00
iglocska 7146652059 Merge branch '2.4' into feature/attribute-tagging 2016-12-26 23:30:21 +01:00
iglocska 5a58d0d8d5 chg: Added colour fields to sql files 2016-12-25 18:13:51 +01:00
Richard van den Berg 50f684d1c5 Add missing indexes 2016-12-15 18:38:51 +01:00
Richard van den Berg 9d89516e58 Add fulltext indexes from AppModel.php to MYSQL.sql 2016-12-13 10:34:29 +01:00
Richard van den Berg e8ce32f0a2 Set proposal_to_delete default to 0 2016-12-09 09:54:08 +01:00
Iglocska 0280fad3e6 fix: index length fixed for several text fields 2016-12-06 00:38:11 +01:00
Iglocska 2ac3d543f3 fix: Escape field names again
- TODO, have a backtick replacement script for postgres
2016-12-06 00:21:19 +01:00
Iglocska b8c28c20b1 fix: Attempt at a fix for SQL woes 2016-12-06 00:02:32 +01:00
Iglocska 8302048dd9 fix: Fixed an issue where a normal index was attempted to be created for a text field causing the installation to fail 2016-12-05 23:31:23 +01:00
Iglocska fe49d598f6 new: Added galaxy tables 2016-12-03 23:43:48 +01:00
Iglocska 2875789804 fix: Some additional changes to accomodate for the automatically enabled sightings 2016-11-21 17:57:55 +01:00
Andreas Ziegler 7960c87000 new: add sql for attribute_tags (MySQL) 2016-09-29 16:52:06 +02:00
Iglocska aa03830643 chg: Default roles all have API access
- changed the default role set to have api access enabled
- existing installations not affected
- if a community wants to restrict API access for certain users they're free to do it
2016-09-20 14:38:54 +02:00
iglocska ba986bea38 fix: Add key length to text field index 2016-08-31 11:14:04 +02:00
iglocska 517f7e0003 fix: Removed incorrect index in the previous commit 2016-08-31 11:07:38 +02:00
iglocska 51848fd4c7 chg: Changed the default event table engine to InnoDB 2016-08-31 11:01:44 +02:00
iglocska 29f5b936b1 Merge branch '2.4' of https://github.com/MISP/MISP into 2.4 2016-08-31 10:11:21 +02:00
iglocska dd68eb0aae chg: Set "User" as the default role for new installations 2016-08-31 10:11:06 +02:00
Andreas Ziegler 812e8a6dd5 fix: update version number to 2.4.51 in MYSQL.sql 2016-08-31 04:30:45 +02:00
iglocska 9656913bd1 fix: Added 2.4.51's database changes to MYSQL.sql 2016-08-30 15:52:58 +02:00
iglocska 444171bd2d Merge branch '2.4' into sslclientsync 2016-08-18 09:58:52 +02:00
Andreas Ziegler 88b2ea1eaf chg: add index for cake_sessions expires to MYSQL.sql 2016-08-16 04:10:34 +02:00
Andreas Ziegler 44d5fe0344 chg: small cleanup of MYSQL.sql
- integers instead of strings
- spaces after commas, not before
- add&remove spaces
2016-08-01 18:21:14 +02:00
Richard van den Berg 81a5838131 Add support for sync server SSL client certificates 2016-08-01 16:30:22 +02:00
Iglocska e65bc0db53 Merge branch '2.4' into 2.4.49
Conflicts:
	app/Controller/AppController.php
2016-07-22 13:29:27 +02:00
Iglocska b4806939fc fix: MySQL error on users.certif_public, fixes #1378 2016-07-22 10:48:19 +02:00
Iglocska 53289b5416 new: Added a tag restriction to restrict the usage of a tag to a single organisation 2016-07-20 00:08:46 +02:00
Iglocska 069bc3e77f fix: Added roaming to sharing groups in the mysql.sql 2016-07-19 08:44:11 +02:00
Iglocska da0ce1e861 fix: No need for default tasks in the MYSQL.sql file any longer
- handled by the tasks automatically on view
2016-07-18 13:21:59 +02:00
Iglocska af35a4eea2 fix: Added perm_delegate to the default roles in the MYSQL.sql file 2016-07-18 12:24:08 +02:00
Iglocska 6d78946be7 fix: Fixed strings for tinyint(1) type fields in the MYSQL.sql file 2016-07-18 12:22:05 +02:00
Iglocska 5ec15ed05f fix: reverted version number in MYSQL.sql 2016-07-18 00:47:21 +02:00
Iglocska bd46fab70d Merge branch 'email' into 2.4
Conflicts:
	INSTALL/MYSQL.sql
2016-07-18 00:43:47 +02:00
Iglocska 0a33220f03 fix: changed field name from job_id -> process_id for tasks 2016-07-18 00:42:32 +02:00
Iglocska 0ef167f78d Merge branch 'jobid' into 2.4 2016-07-18 00:40:20 +02:00
Steve Fossen 27ce8c9cec mysql for bug #1180 2016-07-15 08:55:01 -07:00
Steve Fossen 75c633f788 update initial install mysql too 2016-07-15 08:42:52 -07:00
Andreas Ziegler 8f31a9f5c9 fix: allow null values for taxonomies expanded column, fixes #1354 2016-07-11 19:33:21 +02:00
Andreas Ziegler 31f21e83ad chg: another cleanup of MYSQL.sql 2016-07-11 19:12:44 +02:00