ryan
10/08/2021, 2:28 PM"err":["failed to save host software: insert software: Error 1054: Unknown column 'bundle_identifier' in 'field list'"]
and verified that prepare db ran successfully.Tomas Touceda
10/08/2021, 3:08 PMryan
10/08/2021, 3:13 PMTomas Touceda
10/08/2021, 3:16 PMselect * from migration_status_tables
?ryan
10/08/2021, 3:16 PMalter table software add column bundle_identifier varchar(255) NOT NULL;
and the error goes away but then I get a bunch of other errors and my policies stop running| 100 | 20210819143446 | 1 | 2021-09-14 07:30:59 |
| 101 | 20210903132338 | 1 | 2021-09-14 07:30:59 |
| 102 | 20210915144307 | 1 | 2021-09-27 14:49:25 |
| 103 | 20210920155130 | 1 | 2021-09-27 14:49:25 |
| 104 | 20210927143115 | 1 | 2021-10-05 00:16:55
Tomas Touceda
10/08/2021, 3:18 PMALTER TABLE software ADD COLUMN bundle_identifier VARCHAR(255) DEFAULT ''
it shouldn't be not nullryan
10/08/2021, 3:32 PM"filename":"distributed.cpp","line":"131","message":"Error executing distributed query: fleet_policy_query_6: no such table: sharing_preferences"
Tomas Touceda
10/08/2021, 3:34 PMryan
10/08/2021, 3:51 PM{"hostIdentifier":"redacted","calendarTime":"Fri Oct 8 15:04:21 2021 UTC","unixTime":"1633705461","severity":"0","filename":"distributed.cpp","line":"121","message":"Executing distributed query: fleet_policy_query_6: select 1 from sharing_preferences where remote_login = 0;","version":"5.0.1","decorations":{"host_uuid":"redacted","hostname":"redacted"}}
{"hostIdentifier":"redacted","calendarTime":"Fri Oct 8 15:04:21 2021 UTC","unixTime":"1633705461","severity":"2","filename":"distributed.cpp","line":"131","message":"Error executing distributed query: fleet_policy_query_6: no such table: sharing_preferences","version":"5.0.1","decorations":{"host_uuid":"redacted","hostname":"redacted"}}
{"hostIdentifier":"redacted","calendarTime":"Fri Oct 8 15:04:21 2021 UTC","unixTime":"1633705461","severity":"0","filename":"distributed.cpp","line":"121","message":"Executing distributed query: fleet_policy_query_1: SELECT * FROM apps where bundle_identifier='io.redacted.redacted'","version":"5.0.1","decorations":{"host_uuid":"redacted","hostname":"redacted"}}
{"hostIdentifier":"redacted","calendarTime":"Fri Oct 8 15:04:21 2021 UTC","unixTime":"1633705461","severity":"2","filename":"distributed.cpp","line":"131","message":"Error executing distributed query: fleet_policy_query_1: no such table: apps","version":"5.0.1","decorations":{"host_uuid":"redacted","hostname":"redacted"}}
Tomas Touceda
10/08/2021, 3:53 PMryan
10/08/2021, 3:55 PMTomas Touceda
10/08/2021, 3:56 PMryan
10/08/2021, 4:01 PMTomas Touceda
10/08/2021, 4:02 PMryan
10/08/2021, 4:13 PMosquery:
status_log_plugin: filesystem
result_log_plugin: filesystem
filesystem:
status_log_file: /var/log/osquery/status.log
result_log_file: /var/log/osquery/result.log
enable_log_rotation: true
enable_log_compression: true
logging:
json: true