From bf3af8f8a444365f3040da2928837986409fa016 Mon Sep 17 00:00:00 2001 From: Stefan Wintermeyer Date: Tue, 29 Jan 2013 18:43:06 +0100 Subject: Single Sign On via a ENV['USER_NAME'] mechanism. --- db/migrate/20130129154700_add_sso_key.rb | 9 +++++++++ db/schema.rb | 2 +- 2 files changed, 10 insertions(+), 1 deletion(-) create mode 100644 db/migrate/20130129154700_add_sso_key.rb (limited to 'db') diff --git a/db/migrate/20130129154700_add_sso_key.rb b/db/migrate/20130129154700_add_sso_key.rb new file mode 100644 index 0000000..2e47f39 --- /dev/null +++ b/db/migrate/20130129154700_add_sso_key.rb @@ -0,0 +1,9 @@ +class AddSsoKey < ActiveRecord::Migration + def up + GsParameter.create(:name => 'SingleSignOnEnvUserNameKey', :section => 'Generic', :value => '', :class_type => 'Nil', :description => 'When set to a string this env variable will be used to authenticate the user. e.g. REMOTE_USER') + end + + def down + GsParameter.create(:name => 'SingleSignOnEnvUserNameKey').destroy_all + end +end diff --git a/db/schema.rb b/db/schema.rb index 7bae5fd..e1bed77 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -11,7 +11,7 @@ # # It's strongly recommended to check this file into your version control system. -ActiveRecord::Schema.define(:version => 20130128121800) do +ActiveRecord::Schema.define(:version => 20130129154700) do create_table "access_authorizations", :force => true do |t| t.string "access_authorizationable_type" -- cgit v1.2.3 From 0dc0b4d44907b51f859e125a00c8b5dbc39c1a6f Mon Sep 17 00:00:00 2001 From: spag Date: Wed, 30 Jan 2013 10:01:35 +0100 Subject: disable passing of custom headers to gateway --- db/migrate/20130130185300_add_no_copy_headers.rb | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 db/migrate/20130130185300_add_no_copy_headers.rb (limited to 'db') diff --git a/db/migrate/20130130185300_add_no_copy_headers.rb b/db/migrate/20130130185300_add_no_copy_headers.rb new file mode 100644 index 0000000..c2c5c90 --- /dev/null +++ b/db/migrate/20130130185300_add_no_copy_headers.rb @@ -0,0 +1,9 @@ +class AddNoCopyHeaders < ActiveRecord::Migration + def up + GsParameter.create(:entity => 'dialplan', :section => 'variables', :name => 'sip_copy_custom_headers', :value => 'false', :class_type => 'Boolean', :description => 'Controls passing SIP headers from one call leg to another.') + end + + def down + GsParameter.create(:entity => 'dialplan', :section => 'variables', :name => 'sip_copy_custom_headers').destroy_all + end +end -- cgit v1.2.3 From 8da882cf3ec53f9057b17bd8dd39c2eadb2a88c2 Mon Sep 17 00:00:00 2001 From: Stefan Wintermeyer Date: Thu, 31 Jan 2013 11:39:25 +0100 Subject: Fixed single sign on. #145 --- db/schema.rb | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'db') diff --git a/db/schema.rb b/db/schema.rb index e1bed77..31d4063 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -11,7 +11,7 @@ # # It's strongly recommended to check this file into your version control system. -ActiveRecord::Schema.define(:version => 20130129154700) do +ActiveRecord::Schema.define(:version => 20130130185300) do create_table "access_authorizations", :force => true do |t| t.string "access_authorizationable_type" -- cgit v1.2.3 From 2e5789bcaf38a7c2b8b6ffabe9140b4517dcffc8 Mon Sep 17 00:00:00 2001 From: Stefan Wintermeyer Date: Sat, 2 Feb 2013 15:36:41 +0100 Subject: Set a trunk_access_code during setup. #126 --- .../20130202140927_add_trunk_access_code_to_gemeinschaft_setup.rb | 5 +++++ db/schema.rb | 3 ++- 2 files changed, 7 insertions(+), 1 deletion(-) create mode 100644 db/migrate/20130202140927_add_trunk_access_code_to_gemeinschaft_setup.rb (limited to 'db') diff --git a/db/migrate/20130202140927_add_trunk_access_code_to_gemeinschaft_setup.rb b/db/migrate/20130202140927_add_trunk_access_code_to_gemeinschaft_setup.rb new file mode 100644 index 0000000..82fa3ad --- /dev/null +++ b/db/migrate/20130202140927_add_trunk_access_code_to_gemeinschaft_setup.rb @@ -0,0 +1,5 @@ +class AddTrunkAccessCodeToGemeinschaftSetup < ActiveRecord::Migration + def change + add_column :gemeinschaft_setups, :trunk_access_code, :string + end +end diff --git a/db/schema.rb b/db/schema.rb index 31d4063..5d4b5e3 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -11,7 +11,7 @@ # # It's strongly recommended to check this file into your version control system. -ActiveRecord::Schema.define(:version => 20130130185300) do +ActiveRecord::Schema.define(:version => 20130202140927) do create_table "access_authorizations", :force => true do |t| t.string "access_authorizationable_type" @@ -540,6 +540,7 @@ ActiveRecord::Schema.define(:version => 20130130185300) do t.string "default_area_code" t.string "default_company_name" t.string "default_system_email" + t.string "trunk_access_code" end create_table "gs_cluster_sync_log_entries", :force => true do |t| -- cgit v1.2.3 From 775dc19b31c8d9304c571187464f936f4f337064 Mon Sep 17 00:00:00 2001 From: spag Date: Sun, 3 Feb 2013 18:30:15 +0100 Subject: perimeter parameters added --- .../20130203165800_add_perimeter_parameters.rb | 23 ++++++++++++++++++++++ 1 file changed, 23 insertions(+) create mode 100644 db/migrate/20130203165800_add_perimeter_parameters.rb (limited to 'db') diff --git a/db/migrate/20130203165800_add_perimeter_parameters.rb b/db/migrate/20130203165800_add_perimeter_parameters.rb new file mode 100644 index 0000000..9ef41d0 --- /dev/null +++ b/db/migrate/20130203165800_add_perimeter_parameters.rb @@ -0,0 +1,23 @@ +class AddPerimeterParameters < ActiveRecord::Migration + def up + GsParameter.create(:entity => 'perimeter', :section => 'general', :name => 'contact_count_threshold', :value => '10', :class_type => 'Integer', :description => '') + GsParameter.create(:entity => 'perimeter', :section => 'general', :name => 'contact_span_threshold', :value => '2', :class_type => 'Integer', :description => '') + GsParameter.create(:entity => 'perimeter', :section => 'general', :name => 'name_changes_threshold', :value => '2', :class_type => 'Integer', :description => '') + GsParameter.create(:entity => 'perimeter', :section => 'general', :name => 'ban_threshold', :value => '20', :class_type => 'Integer', :description => '') + GsParameter.create(:entity => 'perimeter', :section => 'general', :name => 'ban_tries', :value => '2', :class_type => 'Integer', :description => '') + GsParameter.create(:entity => 'perimeter', :section => 'general', :name => 'blacklist_file', :value => '/var/opt/gemeinschaft/firewall/blacklist', :class_type => 'String', :description => '') + GsParameter.create(:entity => 'perimeter', :section => 'general', :name => 'blacklist_file_comment', :value => '# PERIMETER_BAN - points: {points}, generated: {date}', :class_type => 'String', :description => '') + GsParameter.create(:entity => 'perimeter', :section => 'general', :name => 'blacklist_file_entry', :value => '{received_ip} udp 5060', :class_type => 'String', :description => '') + GsParameter.create(:entity => 'perimeter', :section => 'general', :name => 'ban_command', :value => 'sudo /sbin/service shorewall refresh', :class_type => 'String', :description => '') + GsParameter.create(:entity => 'perimeter', :section => 'checks', :name => 'check_frequency', :value => '1', :class_type => 'Integer', :description => '') + GsParameter.create(:entity => 'perimeter', :section => 'checks', :name => 'check_username_scan', :value => '1', :class_type => 'Integer', :description => '') + GsParameter.create(:entity => 'perimeter', :section => 'checks', :name => 'check_bad_headers', :value => '1', :class_type => 'Integer', :description => '') + GsParameter.create(:entity => 'perimeter', :section => 'bad_headers', :name => 'user_agent', :value => '^friendly.scanner$', :class_type => 'String', :description => '') + GsParameter.create(:entity => 'perimeter', :section => 'bad_headers', :name => 'to_user', :value => '^%d+', :class_type => 'String', :description => '') + GsParameter.create(:entity => 'perimeter', :section => 'bad_headers', :name => 'auth_result', :value => '^FORBIDDEN$', :class_type => 'String', :description => '') + end + + def down + GsParameter.where(:entity => 'perimeter').destroy_all + end +end -- cgit v1.2.3 From f0716d611fd0cdf332ab5a11189034876a69b2df Mon Sep 17 00:00:00 2001 From: spag Date: Sun, 3 Feb 2013 18:30:51 +0100 Subject: migration fixed --- db/migrate/20130130185300_add_no_copy_headers.rb | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'db') diff --git a/db/migrate/20130130185300_add_no_copy_headers.rb b/db/migrate/20130130185300_add_no_copy_headers.rb index c2c5c90..aa96653 100644 --- a/db/migrate/20130130185300_add_no_copy_headers.rb +++ b/db/migrate/20130130185300_add_no_copy_headers.rb @@ -4,6 +4,6 @@ class AddNoCopyHeaders < ActiveRecord::Migration end def down - GsParameter.create(:entity => 'dialplan', :section => 'variables', :name => 'sip_copy_custom_headers').destroy_all + GsParameter.where(:entity => 'dialplan', :section => 'variables', :name => 'sip_copy_custom_headers').destroy_all end end -- cgit v1.2.3 From 8ba73e0d84c74e22ee91dcdd7c855514d0dd0e99 Mon Sep 17 00:00:00 2001 From: spag Date: Sun, 3 Feb 2013 18:45:59 +0100 Subject: remove_perimeter_parameters migration added --- db/migrate/20130203164500_remove_perimeter_parameters.rb | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 db/migrate/20130203164500_remove_perimeter_parameters.rb (limited to 'db') diff --git a/db/migrate/20130203164500_remove_perimeter_parameters.rb b/db/migrate/20130203164500_remove_perimeter_parameters.rb new file mode 100644 index 0000000..15838bb --- /dev/null +++ b/db/migrate/20130203164500_remove_perimeter_parameters.rb @@ -0,0 +1,10 @@ +class StartPerimeterDefense < ActiveRecord::Migration + def up + module_index = GsParameter.where(:entity => 'events', :section => 'modules').all.count + 1; + GsParameter.create(:entity => 'events', :section => 'modules', :name => 'perimeter_defense', :value => module_index, :class_type => 'Integer') + end + + def down + GsParameter.where(:entity => 'events', :section => 'modules', :name => 'perimeter_defense').destroy_all + end +end -- cgit v1.2.3 From b8576b59e912905f3e30e0d69ca2d4df013bc313 Mon Sep 17 00:00:00 2001 From: spag Date: Sun, 3 Feb 2013 18:46:22 +0100 Subject: start perimeter migration added --- db/migrate/20130203174300_start_perimeter_defense.rb | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 db/migrate/20130203174300_start_perimeter_defense.rb (limited to 'db') diff --git a/db/migrate/20130203174300_start_perimeter_defense.rb b/db/migrate/20130203174300_start_perimeter_defense.rb new file mode 100644 index 0000000..15838bb --- /dev/null +++ b/db/migrate/20130203174300_start_perimeter_defense.rb @@ -0,0 +1,10 @@ +class StartPerimeterDefense < ActiveRecord::Migration + def up + module_index = GsParameter.where(:entity => 'events', :section => 'modules').all.count + 1; + GsParameter.create(:entity => 'events', :section => 'modules', :name => 'perimeter_defense', :value => module_index, :class_type => 'Integer') + end + + def down + GsParameter.where(:entity => 'events', :section => 'modules', :name => 'perimeter_defense').destroy_all + end +end -- cgit v1.2.3 From 53fcddfc40f84d8fd12872e751233cb034e2832f Mon Sep 17 00:00:00 2001 From: spag Date: Sun, 3 Feb 2013 18:50:10 +0100 Subject: remove_perimeter_parameters migration fixed --- db/migrate/20130203164500_remove_perimeter_parameters.rb | 14 ++++++++++---- 1 file changed, 10 insertions(+), 4 deletions(-) (limited to 'db') diff --git a/db/migrate/20130203164500_remove_perimeter_parameters.rb b/db/migrate/20130203164500_remove_perimeter_parameters.rb index 15838bb..8c37174 100644 --- a/db/migrate/20130203164500_remove_perimeter_parameters.rb +++ b/db/migrate/20130203164500_remove_perimeter_parameters.rb @@ -1,10 +1,16 @@ -class StartPerimeterDefense < ActiveRecord::Migration +class RemovePerimeterParameters < ActiveRecord::Migration def up - module_index = GsParameter.where(:entity => 'events', :section => 'modules').all.count + 1; - GsParameter.create(:entity => 'events', :section => 'modules', :name => 'perimeter_defense', :value => module_index, :class_type => 'Integer') + GsParameter.where(:entity => 'perimeter', :section => 'general', :name => 'malicious_contact_count').destroy_all + GsParameter.where(:entity => 'perimeter', :section => 'general', :name => 'malicious_contact_time_span').destroy_all + GsParameter.where(:entity => 'perimeter', :section => 'general', :name => 'ban_futile').destroy_all + GsParameter.where(:entity => 'perimeter', :section => 'general', :name => 'execute').destroy_all + end def down - GsParameter.where(:entity => 'events', :section => 'modules', :name => 'perimeter_defense').destroy_all + GsParameter.create(:entity => 'perimeter', :section => 'general', :name => 'malicious_contact_count', :value => 20, :class_type => 'Integer') + GsParameter.create(:entity => 'perimeter', :section => 'general', :name => 'malicious_contact_time_span', :value => 2, :class_type => 'Integer') + GsParameter.create(:entity => 'perimeter', :section => 'general', :name => 'ban_futile', :value => 5, :class_type => 'Integer') + GsParameter.create(:entity => 'perimeter', :section => 'general', :name => 'execute', :value => 'sudo /usr/local/bin/ban_ip.sh {ip_address}', :class_type => 'String') end end -- cgit v1.2.3 From ecdbd88b2059ccfcf79e000d07efb9ffddde9aed Mon Sep 17 00:00:00 2001 From: spag Date: Sun, 3 Feb 2013 20:03:28 +0100 Subject: try to ban only once --- db/migrate/20130203165800_add_perimeter_parameters.rb | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'db') diff --git a/db/migrate/20130203165800_add_perimeter_parameters.rb b/db/migrate/20130203165800_add_perimeter_parameters.rb index 9ef41d0..d229b29 100644 --- a/db/migrate/20130203165800_add_perimeter_parameters.rb +++ b/db/migrate/20130203165800_add_perimeter_parameters.rb @@ -4,7 +4,7 @@ class AddPerimeterParameters < ActiveRecord::Migration GsParameter.create(:entity => 'perimeter', :section => 'general', :name => 'contact_span_threshold', :value => '2', :class_type => 'Integer', :description => '') GsParameter.create(:entity => 'perimeter', :section => 'general', :name => 'name_changes_threshold', :value => '2', :class_type => 'Integer', :description => '') GsParameter.create(:entity => 'perimeter', :section => 'general', :name => 'ban_threshold', :value => '20', :class_type => 'Integer', :description => '') - GsParameter.create(:entity => 'perimeter', :section => 'general', :name => 'ban_tries', :value => '2', :class_type => 'Integer', :description => '') + GsParameter.create(:entity => 'perimeter', :section => 'general', :name => 'ban_tries', :value => '1', :class_type => 'Integer', :description => '') GsParameter.create(:entity => 'perimeter', :section => 'general', :name => 'blacklist_file', :value => '/var/opt/gemeinschaft/firewall/blacklist', :class_type => 'String', :description => '') GsParameter.create(:entity => 'perimeter', :section => 'general', :name => 'blacklist_file_comment', :value => '# PERIMETER_BAN - points: {points}, generated: {date}', :class_type => 'String', :description => '') GsParameter.create(:entity => 'perimeter', :section => 'general', :name => 'blacklist_file_entry', :value => '{received_ip} udp 5060', :class_type => 'String', :description => '') -- cgit v1.2.3 From 947d4a71a17518b734c32a148617bef15a42fed1 Mon Sep 17 00:00:00 2001 From: spag Date: Sun, 3 Feb 2013 22:03:45 +0100 Subject: threshold changed --- db/migrate/20130203165800_add_perimeter_parameters.rb | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'db') diff --git a/db/migrate/20130203165800_add_perimeter_parameters.rb b/db/migrate/20130203165800_add_perimeter_parameters.rb index d229b29..23e0157 100644 --- a/db/migrate/20130203165800_add_perimeter_parameters.rb +++ b/db/migrate/20130203165800_add_perimeter_parameters.rb @@ -2,7 +2,7 @@ class AddPerimeterParameters < ActiveRecord::Migration def up GsParameter.create(:entity => 'perimeter', :section => 'general', :name => 'contact_count_threshold', :value => '10', :class_type => 'Integer', :description => '') GsParameter.create(:entity => 'perimeter', :section => 'general', :name => 'contact_span_threshold', :value => '2', :class_type => 'Integer', :description => '') - GsParameter.create(:entity => 'perimeter', :section => 'general', :name => 'name_changes_threshold', :value => '2', :class_type => 'Integer', :description => '') + GsParameter.create(:entity => 'perimeter', :section => 'general', :name => 'name_changes_threshold', :value => '5', :class_type => 'Integer', :description => '') GsParameter.create(:entity => 'perimeter', :section => 'general', :name => 'ban_threshold', :value => '20', :class_type => 'Integer', :description => '') GsParameter.create(:entity => 'perimeter', :section => 'general', :name => 'ban_tries', :value => '1', :class_type => 'Integer', :description => '') GsParameter.create(:entity => 'perimeter', :section => 'general', :name => 'blacklist_file', :value => '/var/opt/gemeinschaft/firewall/blacklist', :class_type => 'String', :description => '') -- cgit v1.2.3 From 0db4c7250feab288018d42cbd5c7d12657d60e3a Mon Sep 17 00:00:00 2001 From: spag Date: Mon, 4 Feb 2013 09:39:42 +0100 Subject: check calls --- .../20130204065900_split_perimeter_parameters.rb | 30 ++++++++++++++++++++++ 1 file changed, 30 insertions(+) create mode 100644 db/migrate/20130204065900_split_perimeter_parameters.rb (limited to 'db') diff --git a/db/migrate/20130204065900_split_perimeter_parameters.rb b/db/migrate/20130204065900_split_perimeter_parameters.rb new file mode 100644 index 0000000..b29bb29 --- /dev/null +++ b/db/migrate/20130204065900_split_perimeter_parameters.rb @@ -0,0 +1,30 @@ +class SplitPerimeterParameters < ActiveRecord::Migration + def up + GsParameter.where(:entity => 'perimeter', :section => 'checks').destroy_all + GsParameter.where(:entity => 'perimeter', :section => 'bad_headers').destroy_all + GsParameter.create(:entity => 'perimeter', :section => 'general', :name => 'ban_command', :value => 'sudo /sbin/service shorewall refresh', :class_type => 'String', :description => '') + GsParameter.create(:entity => 'perimeter', :section => 'checks_register', :name => 'check_frequency', :value => '1', :class_type => 'Integer', :description => '') + GsParameter.create(:entity => 'perimeter', :section => 'checks_register', :name => 'check_username_scan', :value => '1', :class_type => 'Integer', :description => '') + GsParameter.create(:entity => 'perimeter', :section => 'checks_register', :name => 'check_bad_headers', :value => '1', :class_type => 'Integer', :description => '') + GsParameter.create(:entity => 'perimeter', :section => 'checks_call', :name => 'check_frequency', :value => '1', :class_type => 'Integer', :description => '') + GsParameter.create(:entity => 'perimeter', :section => 'checks_call', :name => 'check_bad_headers', :value => '1', :class_type => 'Integer', :description => '') + GsParameter.create(:entity => 'perimeter', :section => 'bad_headers_register', :name => 'user_agent', :value => '^friendly.scanner$', :class_type => 'String', :description => '') + GsParameter.create(:entity => 'perimeter', :section => 'bad_headers_register', :name => 'to_user', :value => '^%d+', :class_type => 'String', :description => '') + GsParameter.create(:entity => 'perimeter', :section => 'bad_headers_register', :name => 'auth_result', :value => '^FORBIDDEN$', :class_type => 'String', :description => '') + GsParameter.create(:entity => 'perimeter', :section => 'bad_headers_call', :name => 'user_agent', :value => '^friendly.scanner$', :class_type => 'String', :description => '') + GsParameter.create(:entity => 'perimeter', :section => 'bad_headers_call', :name => 'hangup_cause', :value => '^MANDATORY_IE_MISSING', :class_type => 'String', :description => '') + end + + def down + GsParameter.where(:entity => 'perimeter', :section => 'checks_register').destroy_all + GsParameter.where(:entity => 'perimeter', :section => 'checks_call').destroy_all + GsParameter.where(:entity => 'perimeter', :section => 'bad_headers_register').destroy_all + GsParameter.where(:entity => 'perimeter', :section => 'bad_headers_call').destroy_all + GsParameter.create(:entity => 'perimeter', :section => 'checks', :name => 'check_frequency', :value => '1', :class_type => 'Integer', :description => '') + GsParameter.create(:entity => 'perimeter', :section => 'checks', :name => 'check_username_scan', :value => '1', :class_type => 'Integer', :description => '') + GsParameter.create(:entity => 'perimeter', :section => 'checks', :name => 'check_bad_headers', :value => '1', :class_type => 'Integer', :description => '') + GsParameter.create(:entity => 'perimeter', :section => 'bad_headers', :name => 'user_agent', :value => '^friendly.scanner$', :class_type => 'String', :description => '') + GsParameter.create(:entity => 'perimeter', :section => 'bad_headers', :name => 'to_user', :value => '^%d+', :class_type => 'String', :description => '') + GsParameter.create(:entity => 'perimeter', :section => 'bad_headers', :name => 'auth_result', :value => '^FORBIDDEN$', :class_type => 'String', :description => '') + end +end -- cgit v1.2.3 From bb8168c33f9501fe877345a7bbc7b7f7b64cdfc7 Mon Sep 17 00:00:00 2001 From: Stefan Wintermeyer Date: Tue, 5 Feb 2013 12:40:42 +0100 Subject: Added a BackupJob scaffold. --- db/migrate/20130205102838_create_backup_jobs.rb | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 db/migrate/20130205102838_create_backup_jobs.rb (limited to 'db') diff --git a/db/migrate/20130205102838_create_backup_jobs.rb b/db/migrate/20130205102838_create_backup_jobs.rb new file mode 100644 index 0000000..0d71421 --- /dev/null +++ b/db/migrate/20130205102838_create_backup_jobs.rb @@ -0,0 +1,16 @@ +class CreateBackupJobs < ActiveRecord::Migration + def self.up + create_table :backup_jobs do |t| + t.datetime :started_at + t.datetime :finished_at + t.string :state + t.string :directory + t.string :size_of_the_backup + t.timestamps + end + end + + def self.down + drop_table :backup_jobs + end +end -- cgit v1.2.3 From b1f9f3b2c39d31d0621da36420318406f33a1f92 Mon Sep 17 00:00:00 2001 From: Stefan Wintermeyer Date: Tue, 5 Feb 2013 16:21:02 +0100 Subject: DelayedJob table upgrade. --- db/migrate/20130205151844_add_queue_to_delayed_jobs.rb | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 db/migrate/20130205151844_add_queue_to_delayed_jobs.rb (limited to 'db') diff --git a/db/migrate/20130205151844_add_queue_to_delayed_jobs.rb b/db/migrate/20130205151844_add_queue_to_delayed_jobs.rb new file mode 100644 index 0000000..072c8d4 --- /dev/null +++ b/db/migrate/20130205151844_add_queue_to_delayed_jobs.rb @@ -0,0 +1,9 @@ +class AddQueueToDelayedJobs < ActiveRecord::Migration + def self.up + add_column :delayed_jobs, :queue, :string + end + + def self.down + remove_column :delayed_jobs, :queue + end +end -- cgit v1.2.3 From 3edd6e58ea3f5d25068ea9d47f639ae89e5f2c0c Mon Sep 17 00:00:00 2001 From: Stefan Wintermeyer Date: Wed, 6 Feb 2013 11:07:04 +0100 Subject: Improved the backup. --- db/migrate/20130205102838_create_backup_jobs.rb | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'db') diff --git a/db/migrate/20130205102838_create_backup_jobs.rb b/db/migrate/20130205102838_create_backup_jobs.rb index 0d71421..0994939 100644 --- a/db/migrate/20130205102838_create_backup_jobs.rb +++ b/db/migrate/20130205102838_create_backup_jobs.rb @@ -5,7 +5,7 @@ class CreateBackupJobs < ActiveRecord::Migration t.datetime :finished_at t.string :state t.string :directory - t.string :size_of_the_backup + t.integer :size_of_the_backup t.timestamps end end -- cgit v1.2.3 From 07d49f54067cfb8666f650323c7ffefe1e860b24 Mon Sep 17 00:00:00 2001 From: Stefan Wintermeyer Date: Wed, 6 Feb 2013 16:03:43 +0100 Subject: Use CarrierWave to store the backup file. --- ...20130206144829_add_backup_file_to_backup_job.rb | 5 +++++ db/schema.rb | 23 +++++++++++++++++++++- 2 files changed, 27 insertions(+), 1 deletion(-) create mode 100644 db/migrate/20130206144829_add_backup_file_to_backup_job.rb (limited to 'db') diff --git a/db/migrate/20130206144829_add_backup_file_to_backup_job.rb b/db/migrate/20130206144829_add_backup_file_to_backup_job.rb new file mode 100644 index 0000000..e02f2b3 --- /dev/null +++ b/db/migrate/20130206144829_add_backup_file_to_backup_job.rb @@ -0,0 +1,5 @@ +class AddBackupFileToBackupJob < ActiveRecord::Migration + def change + add_column :backup_jobs, :backup_file, :string + end +end diff --git a/db/schema.rb b/db/schema.rb index 5d4b5e3..5e51305 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -11,7 +11,7 @@ # # It's strongly recommended to check this file into your version control system. -ActiveRecord::Schema.define(:version => 20130202140927) do +ActiveRecord::Schema.define(:version => 20130206144829) do create_table "access_authorizations", :force => true do |t| t.string "access_authorizationable_type" @@ -124,6 +124,26 @@ ActiveRecord::Schema.define(:version => 20130202140927) do t.string "music" end + create_table "backup_jobs", :force => true do |t| + t.datetime "started_at" + t.datetime "finished_at" + t.string "state" + t.string "directory" + t.integer "size_of_the_backup" + t.datetime "created_at", :null => false + t.datetime "updated_at", :null => false + t.string "backup_file" + end + + create_table "backups", :force => true do |t| + t.datetime "start_at" + t.datetime "end_at" + t.string "directory" + t.string "size" + t.datetime "created_at", :null => false + t.datetime "updated_at", :null => false + end + create_table "call_forward_cases", :force => true do |t| t.string "value" t.datetime "created_at", :null => false @@ -358,6 +378,7 @@ ActiveRecord::Schema.define(:version => 20130202140927) do t.string "locked_by" t.datetime "created_at", :null => false t.datetime "updated_at", :null => false + t.string "queue" end add_index "delayed_jobs", ["priority", "run_at"], :name => "delayed_jobs_priority" -- cgit v1.2.3 From 72f100c680ddcf9c36448ae3ee367eab19052adc Mon Sep 17 00:00:00 2001 From: Stefan Wintermeyer Date: Thu, 7 Feb 2013 09:27:43 +0100 Subject: Use CarrierWave to store the tar.gz. Removed size_of_the_backup attribute. --- .../20130207082728_remove_size_of_the_backup_from_backup_job.rb | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 db/migrate/20130207082728_remove_size_of_the_backup_from_backup_job.rb (limited to 'db') diff --git a/db/migrate/20130207082728_remove_size_of_the_backup_from_backup_job.rb b/db/migrate/20130207082728_remove_size_of_the_backup_from_backup_job.rb new file mode 100644 index 0000000..a902fd2 --- /dev/null +++ b/db/migrate/20130207082728_remove_size_of_the_backup_from_backup_job.rb @@ -0,0 +1,9 @@ +class RemoveSizeOfTheBackupFromBackupJob < ActiveRecord::Migration + def up + remove_column :backup_jobs, :size_of_the_backup + end + + def down + add_column :backup_jobs, :size_of_the_backup, :string + end +end -- cgit v1.2.3 From 9e723519982c3b442aa90f3728bfddd4025d4a69 Mon Sep 17 00:00:00 2001 From: spag Date: Fri, 8 Feb 2013 10:41:18 +0100 Subject: softkey-call_forward relation polymorphic --- db/migrate/20130208065700_add_softkeyable_to_softkey.rb | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 db/migrate/20130208065700_add_softkeyable_to_softkey.rb (limited to 'db') diff --git a/db/migrate/20130208065700_add_softkeyable_to_softkey.rb b/db/migrate/20130208065700_add_softkeyable_to_softkey.rb new file mode 100644 index 0000000..deae9a0 --- /dev/null +++ b/db/migrate/20130208065700_add_softkeyable_to_softkey.rb @@ -0,0 +1,16 @@ +class AddSoftkeyableToSoftkey < ActiveRecord::Migration + def up + add_column :softkeys, :softkeyable_type, :string + add_column :softkeys, :softkeyable_id, :integer + Softkey.where('call_forward_id > 0').each do |softkey| + softkey.update_attributes( :softkeyable_type => 'CallForward', :softkeyable_id => softkey.call_forward_id ) + end + remove_column :softkeys, :call_forward_id + end + + def down + remove_column :softkeys, :softkeyable_type + remove_column :softkeys, :softkeyable_id + add_column :softkeys, :call_forward_id, :integer + end +end -- cgit v1.2.3 From 4c9cc92c0a49ec34c8bf00e31d1710450fb533fa Mon Sep 17 00:00:00 2001 From: Peter Kozak Date: Sun, 10 Feb 2013 08:09:05 +0000 Subject: firewall blacklist model added --- db/migrate/20130210075617_create_intruders.rb | 26 ++++++++++++++++++++++++++ 1 file changed, 26 insertions(+) create mode 100644 db/migrate/20130210075617_create_intruders.rb (limited to 'db') diff --git a/db/migrate/20130210075617_create_intruders.rb b/db/migrate/20130210075617_create_intruders.rb new file mode 100644 index 0000000..bd4db0b --- /dev/null +++ b/db/migrate/20130210075617_create_intruders.rb @@ -0,0 +1,26 @@ +class CreateIntruders < ActiveRecord::Migration + def self.up + create_table :intruders do |t| + t.string :list_type + t.string :key + t.integer :points + t.integer :bans + t.datetime :ban_last + t.datetime :ban_end + t.string :contact_ip + t.integer :contact_port + t.integer :contact_count + t.datetime :contact_last + t.float :contacts_per_second + t.float :contacts_per_second_max + t.string :user_agent + t.string :to_user + t.string :comment + t.timestamps + end + end + + def self.down + drop_table :intruders + end +end -- cgit v1.2.3 From 33e88d16edc4d9f8047ef1a2087134c54f169c21 Mon Sep 17 00:00:00 2001 From: spag Date: Sun, 10 Feb 2013 09:52:31 +0100 Subject: key index added --- db/migrate/20130210075617_create_intruders.rb | 2 ++ 1 file changed, 2 insertions(+) (limited to 'db') diff --git a/db/migrate/20130210075617_create_intruders.rb b/db/migrate/20130210075617_create_intruders.rb index bd4db0b..fc944cc 100644 --- a/db/migrate/20130210075617_create_intruders.rb +++ b/db/migrate/20130210075617_create_intruders.rb @@ -18,6 +18,8 @@ class CreateIntruders < ActiveRecord::Migration t.string :comment t.timestamps end + + add_index :intruders, :key, :unique => true end def self.down -- cgit v1.2.3 From ca8121930d7e75b9f6bac08591c6ffea3ca1fea1 Mon Sep 17 00:00:00 2001 From: Stefan Wintermeyer Date: Mon, 11 Feb 2013 14:42:22 +0100 Subject: Removed PrivatePub stuff. --- db/migrate/20120127101726_create_system_messages.rb | 13 ------------- 1 file changed, 13 deletions(-) delete mode 100644 db/migrate/20120127101726_create_system_messages.rb (limited to 'db') diff --git a/db/migrate/20120127101726_create_system_messages.rb b/db/migrate/20120127101726_create_system_messages.rb deleted file mode 100644 index 830f54a..0000000 --- a/db/migrate/20120127101726_create_system_messages.rb +++ /dev/null @@ -1,13 +0,0 @@ -class CreateSystemMessages < ActiveRecord::Migration - def self.up - create_table :system_messages do |t| - t.integer :user_id - t.string :content - t.timestamps - end - end - - def self.down - drop_table :system_messages - end -end -- cgit v1.2.3 From d1145ad9d4f495d7416ed97e0dd3c17365990323 Mon Sep 17 00:00:00 2001 From: spag Date: Tue, 12 Feb 2013 08:19:00 +0100 Subject: create profile template --- db/migrate/20130212071000_default_profile_to_template.rb | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 db/migrate/20130212071000_default_profile_to_template.rb (limited to 'db') diff --git a/db/migrate/20130212071000_default_profile_to_template.rb b/db/migrate/20130212071000_default_profile_to_template.rb new file mode 100644 index 0000000..d3fd89c --- /dev/null +++ b/db/migrate/20130212071000_default_profile_to_template.rb @@ -0,0 +1,13 @@ +class DefaultProfileToTemplate < ActiveRecord::Migration + def up + GsParameter.where(:entity => 'sofia', :section => 'profile:gemeinschaft').each do |profile| + profile.update_attributes(:section => 'profile') + end + end + + def down + GsParameter.where(:entity => 'sofia', :section => 'profile').each do |profile| + profile.update_attributes(:section => 'profile:gemeinschaft') + end + end +end -- cgit v1.2.3 From fb66a5e5a4c5d5f9eac4a5e8de6a286482cb55d5 Mon Sep 17 00:00:00 2001 From: Stefan Wintermeyer Date: Tue, 12 Feb 2013 13:41:13 +0100 Subject: Some span.hidden-phone stuff to improve the UI on a phone. --- db/schema.rb | 48 +++++++++++++++++++++++++++--------------------- 1 file changed, 27 insertions(+), 21 deletions(-) (limited to 'db') diff --git a/db/schema.rb b/db/schema.rb index 5e51305..fc2b635 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -11,7 +11,7 @@ # # It's strongly recommended to check this file into your version control system. -ActiveRecord::Schema.define(:version => 20130206144829) do +ActiveRecord::Schema.define(:version => 20130212071000) do create_table "access_authorizations", :force => true do |t| t.string "access_authorizationable_type" @@ -129,21 +129,11 @@ ActiveRecord::Schema.define(:version => 20130206144829) do t.datetime "finished_at" t.string "state" t.string "directory" - t.integer "size_of_the_backup" - t.datetime "created_at", :null => false - t.datetime "updated_at", :null => false + t.datetime "created_at", :null => false + t.datetime "updated_at", :null => false t.string "backup_file" end - create_table "backups", :force => true do |t| - t.datetime "start_at" - t.datetime "end_at" - t.string "directory" - t.string "size" - t.datetime "created_at", :null => false - t.datetime "updated_at", :null => false - end - create_table "call_forward_cases", :force => true do |t| t.string "value" t.datetime "created_at", :null => false @@ -656,6 +646,28 @@ ActiveRecord::Schema.define(:version => 20130206144829) do t.string "hostname", :limit => 256 end + create_table "intruders", :force => true do |t| + t.string "list_type" + t.string "key" + t.integer "points" + t.integer "bans" + t.datetime "ban_last" + t.datetime "ban_end" + t.string "contact_ip" + t.integer "contact_port" + t.integer "contact_count" + t.datetime "contact_last" + t.float "contacts_per_second" + t.float "contacts_per_second_max" + t.string "user_agent" + t.string "to_user" + t.string "comment" + t.datetime "created_at", :null => false + t.datetime "updated_at", :null => false + end + + add_index "intruders", ["key"], :name => "index_intruders_on_key", :unique => true + create_table "languages", :force => true do |t| t.string "name" t.string "code" @@ -961,15 +973,9 @@ ActiveRecord::Schema.define(:version => 20130206144829) do t.datetime "updated_at", :null => false t.integer "sip_account_id" t.integer "softkey_function_id" - t.integer "call_forward_id" t.string "uuid" - end - - create_table "system_messages", :force => true do |t| - t.integer "user_id" - t.string "content" - t.datetime "created_at", :null => false - t.datetime "updated_at", :null => false + t.string "softkeyable_type" + t.integer "softkeyable_id" end create_table "tasks", :id => false, :force => true do |t| -- cgit v1.2.3