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