Skip to content

Instantly share code, notes, and snippets.

@greenaussie
Created January 13, 2019 20:58
Show Gist options
  • Save greenaussie/d10f3b34350133dfebf76df2e5141c42 to your computer and use it in GitHub Desktop.
Save greenaussie/d10f3b34350133dfebf76df2e5141c42 to your computer and use it in GitHub Desktop.
nginx configuration snippet for ombidb-server behind reverse proxy with path prefix.
location /omnidb/ {
proxy_pass http://localhost:8000/ ;
# add_header Content-Base /omnidb/ ;
proxy_http_version 1.1;
proxy_set_header Upgrade $http_upgrade;
proxy_set_header Connection 'upgrade';
proxy_set_header Host $host;
proxy_cache_bypass $http_upgrade;
sub_filter '/wss' '/omnidb/wss';
# From https://github.com/OmniDB/OmniDB/OmniDB_app/urls.py
#LOGIN
sub_filter '/static' '/omnidb/static';
sub_filter '/sign_in' '/omnidb/sign_in';
# sub_filter '/login' '/omnidb/login';
# sub_filter '/login.css' '/omnidb/login.css';
sub_filter '/check_session_message' '/omnidb/check_session_message';
sub_filter '/logout' '/omnidb/logout';
#CONNECTION
sub_filter '/connections' '/omnidb/connections';
sub_filter '/get_connections' '/omnidb/get_connections';
sub_filter '/save_connections' '/omnidb/save_connections';
sub_filter '/test_connection' '/omnidb/test_connection';
sub_filter '/select_connection' '/omnidb/select_connection';
sub_filter '/get_groups' '/omnidb/get_groups';
sub_filter '/new_group' '/omnidb/new_group';
sub_filter '/edit_group' '/omnidb/edit_group';
sub_filter '/delete_group' '/omnidb/delete_group';
#USERS
sub_filter '/get_users' '/omnidb/get_users';
sub_filter '/new_user' '/omnidb/new_user';
sub_filter '/remove_user' '/omnidb/remove_user';
sub_filter '/save_users' '/omnidb/save_users';
#MONITORING
sub_filter '/monitoring' '/omnidb/monitoring';
sub_filter '/welcome' '/omnidb/welcome';
sub_filter '/shortcuts' '/omnidb/shortcuts';
sub_filter '/save_config_user' '/omnidb/save_config_user';
sub_filter '/save_shortcuts' '/omnidb/save_shortcuts';
sub_filter '/get_database_list' '/omnidb/get_database_list';
sub_filter '/renew_password' '/omnidb/renew_password';
sub_filter '/draw_graph' '/omnidb/draw_graph';
sub_filter '/alter_table_data' '/omnidb/alter_table_data';
sub_filter '/save_alter_table' '/omnidb/save_alter_table';
sub_filter '/start_edit_data' '/omnidb/start_edit_data';
sub_filter '/get_completions' '/omnidb/get_completions';
sub_filter '/get_completions_table' '/omnidb/get_completions_table';
sub_filter '/get_command_list' '/omnidb/get_command_list';
sub_filter '/clear_command_list' '/omnidb/clear_command_list';
sub_filter '/indent_sql' '/omnidb/indent_sql';
sub_filter '/refresh_monitoring' '/omnidb/refresh_monitoring';
sub_filter '/get_console_history' '/omnidb/get_console_history';
sub_filter '/get_console_history_clean' '/omnidb/get_console_history_clean';
sub_filter '/get_autocomplete_results' '/omnidb/get_autocomplete_results';
#HOOKS
sub_filter '/get_plugins' '/omnidb/get_plugins';
sub_filter '/list_plugins' '/omnidb/list_plugins';
sub_filter '/reload_plugins' '/omnidb/reload_plugins';
sub_filter '/exec_plugin_function' '/omnidb/exec_plugin_function';
#TREE_SNIPPETS
sub_filter '/get_tree_info_postgresql' '/omnidb/get_tree_info_postgresql';
sub_filter '/get_tables_postgresql' '/omnidb/get_tables_postgresql';
sub_filter '/get_schemas_postgresql' '/omnidb/get_schemas_postgresql';
sub_filter '/get_columns_postgresql' '/omnidb/get_columns_postgresql';
sub_filter '/get_pk_postgresql' '/omnidb/get_pk_postgresql';
sub_filter '/get_pk_columns_postgresql' '/omnidb/get_pk_columns_postgresql';
sub_filter '/get_fks_postgresql' '/omnidb/get_fks_postgresql';
sub_filter '/get_fks_columns_postgresql' '/omnidb/get_fks_columns_postgresql';
sub_filter '/get_uniques_postgresql' '/omnidb/get_uniques_postgresql';
sub_filter '/get_uniques_columns_postgresql' '/omnidb/get_uniques_columns_postgresql';
sub_filter '/get_indexes_postgresql' '/omnidb/get_indexes_postgresql';
sub_filter '/get_indexes_columns_postgresql' '/omnidb/get_indexes_columns_postgresql';
sub_filter '/get_checks_postgresql' '/omnidb/get_checks_postgresql';
sub_filter '/get_excludes_postgresql' '/omnidb/get_excludes_postgresql';
sub_filter '/get_rules_postgresql' '/omnidb/get_rules_postgresql';
sub_filter '/get_rule_definition_postgresql' '/omnidb/get_rule_definition_postgresql';
sub_filter '/get_triggers_postgresql' '/omnidb/get_triggers_postgresql';
sub_filter '/get_inheriteds_postgresql' '/omnidb/get_inheriteds_postgresql';
sub_filter '/get_partitions_postgresql' '/omnidb/get_partitions_postgresql';
sub_filter '/get_functions_postgresql' '/omnidb/get_functions_postgresql';
sub_filter '/get_function_fields_postgresql' '/omnidb/get_function_fields_postgresql';
sub_filter '/get_function_definition_postgresql' '/omnidb/get_function_definition_postgresql';
sub_filter '/get_function_debug_postgresql' '/omnidb/get_function_debug_postgresql';
sub_filter '/get_procedures_postgresql' '/omnidb/get_procedures_postgresql';
sub_filter '/get_procedure_fields_postgresql' '/omnidb/get_procedure_fields_postgresql';
sub_filter '/get_procedure_definition_postgresql' '/omnidb/get_procedure_definition_postgresql';
sub_filter '/get_procedure_debug_postgresql' '/omnidb/get_procedure_debug_postgresql';
sub_filter '/get_triggerfunctions_postgresql' '/omnidb/get_triggerfunctions_postgresql';
sub_filter '/get_triggerfunction_definition_postgresql' '/omnidb/get_triggerfunction_definition_postgresql';
sub_filter '/get_sequences_postgresql' '/omnidb/get_sequences_postgresql';
sub_filter '/get_views_postgresql' '/omnidb/get_views_postgresql';
sub_filter '/get_views_columns_postgresql' '/omnidb/get_views_columns_postgresql';
sub_filter '/get_view_definition_postgresql' '/omnidb/get_view_definition_postgresql';
sub_filter '/get_mviews_postgresql' '/omnidb/get_mviews_postgresql';
sub_filter '/get_mviews_columns_postgresql' '/omnidb/get_mviews_columns_postgresql';
sub_filter '/get_mview_definition_postgresql' '/omnidb/get_mview_definition_postgresql';
sub_filter '/get_databases_postgresql' '/omnidb/get_databases_postgresql';
sub_filter '/get_tablespaces_postgresql' '/omnidb/get_tablespaces_postgresql';
sub_filter '/get_roles_postgresql' '/omnidb/get_roles_postgresql';
sub_filter '/get_extensions_postgresql' '/omnidb/get_extensions_postgresql';
sub_filter '/get_physicalreplicationslots_postgresql' '/omnidb/get_physicalreplicationslots_postgresql';
sub_filter '/get_logicalreplicationslots_postgresql' '/omnidb/get_logicalreplicationslots_postgresql';
sub_filter '/get_publications_postgresql' '/omnidb/get_publications_postgresql';
sub_filter '/get_subscriptions_postgresql' '/omnidb/get_subscriptions_postgresql';
sub_filter '/get_publication_tables_postgresql' '/omnidb/get_publication_tables_postgresql';
sub_filter '/get_subscription_tables_postgresql' '/omnidb/get_subscription_tables_postgresql';
sub_filter '/get_foreign_data_wrappers_postgresql' '/omnidb/get_foreign_data_wrappers_postgresql';
sub_filter '/get_foreign_servers_postgresql' '/omnidb/get_foreign_servers_postgresql';
sub_filter '/get_user_mappings_postgresql' '/omnidb/get_user_mappings_postgresql';
sub_filter '/get_foreign_tables_postgresql' '/omnidb/get_foreign_tables_postgresql';
sub_filter '/get_foreign_columns_postgresql' '/omnidb/get_foreign_columns_postgresql';
sub_filter '/kill_backend_postgresql' '/omnidb/kill_backend_postgresql';
sub_filter '/get_properties_postgresql' '/omnidb/get_properties_postgresql';
sub_filter '/get_database_objects_postgresql' '/omnidb/get_database_objects_postgresql';
sub_filter '/template_select_postgresql' '/omnidb/template_select_postgresql';
sub_filter '/template_insert_postgresql' '/omnidb/template_insert_postgresql';
sub_filter '/template_update_postgresql' '/omnidb/template_update_postgresql';
sub_filter '/template_select_function_postgresql' '/omnidb/template_select_function_postgresql';
sub_filter '/template_call_procedure_postgresql' '/omnidb/template_call_procedure_postgresql';
sub_filter '/change_active_database' '/omnidb/change_active_database';
#TREE_ORACLE
sub_filter '/get_tree_info_oracle' '/omnidb/get_tree_info_oracle';
sub_filter '/get_tables_oracle' '/omnidb/get_tables_oracle';
sub_filter '/get_columns_oracle' '/omnidb/get_columns_oracle';
sub_filter '/get_pk_oracle' '/omnidb/get_pk_oracle';
sub_filter '/get_pk_columns_oracle' '/omnidb/get_pk_columns_oracle';
sub_filter '/get_fks_oracle' '/omnidb/get_fks_oracle';
sub_filter '/get_fks_columns_oracle' '/omnidb/get_fks_columns_oracle';
sub_filter '/get_uniques_oracle' '/omnidb/get_uniques_oracle';
sub_filter '/get_uniques_columns_oracle' '/omnidb/get_uniques_columns_oracle';
sub_filter '/get_indexes_oracle' '/omnidb/get_indexes_oracle';
sub_filter '/get_indexes_columns_oracle' '/omnidb/get_indexes_columns_oracle';
sub_filter '/get_triggers_oracle' '/omnidb/get_triggers_oracle';
sub_filter '/get_partitions_oracle' '/omnidb/get_partitions_oracle';
sub_filter '/get_functions_oracle' '/omnidb/get_functions_oracle';
sub_filter '/get_function_fields_oracle' '/omnidb/get_function_fields_oracle';
sub_filter '/get_function_definition_oracle' '/omnidb/get_function_definition_oracle';
sub_filter '/get_procedures_oracle' '/omnidb/get_procedures_oracle';
sub_filter '/get_procedure_fields_oracle' '/omnidb/get_procedure_fields_oracle';
sub_filter '/get_procedure_definition_oracle' '/omnidb/get_procedure_definition_oracle';
sub_filter '/get_function_debug_oracle' '/omnidb/get_function_debug_oracle';
sub_filter '/get_triggerfunctions_oracle' '/omnidb/get_triggerfunctions_oracle';
sub_filter '/get_triggerfunction_definition_oracle' '/omnidb/get_triggerfunction_definition_oracle';
sub_filter '/get_sequences_oracle' '/omnidb/get_sequences_oracle';
sub_filter '/get_views_oracle' '/omnidb/get_views_oracle';
sub_filter '/get_views_columns_oracle' '/omnidb/get_views_columns_oracle';
sub_filter '/get_view_definition_oracle' '/omnidb/get_view_definition_oracle';
sub_filter '/get_mviews_oracle' '/omnidb/get_mviews_oracle';
sub_filter '/get_mviews_columns_oracle' '/omnidb/get_mviews_columns_oracle';
sub_filter '/get_mview_definition_oracle' '/omnidb/get_mview_definition_oracle';
sub_filter '/get_tablespaces_oracle' '/omnidb/get_tablespaces_oracle';
sub_filter '/get_roles_oracle' '/omnidb/get_roles_oracle';
sub_filter '/kill_backend_oracle' '/omnidb/kill_backend_oracle';
sub_filter '/get_properties_oracle' '/omnidb/get_properties_oracle';
sub_filter '/template_select_oracle' '/omnidb/template_select_oracle';
sub_filter '/template_insert_oracle' '/omnidb/template_insert_oracle';
sub_filter '/template_update_oracle' '/omnidb/template_update_oracle';
#TREE_MYSQL
sub_filter '/get_tree_info_mysql' '/omnidb/get_tree_info_mysql';
sub_filter '/get_tables_mysql' '/omnidb/get_tables_mysql';
sub_filter '/get_columns_mysql' '/omnidb/get_columns_mysql';
sub_filter '/get_pk_mysql' '/omnidb/get_pk_mysql';
sub_filter '/get_pk_columns_mysql' '/omnidb/get_pk_columns_mysql';
sub_filter '/get_fks_mysql' '/omnidb/get_fks_mysql';
sub_filter '/get_fks_columns_mysql' '/omnidb/get_fks_columns_mysql';
sub_filter '/get_uniques_mysql' '/omnidb/get_uniques_mysql';
sub_filter '/get_uniques_columns_mysql' '/omnidb/get_uniques_columns_mysql';
sub_filter '/get_indexes_mysql' '/omnidb/get_indexes_mysql';
sub_filter '/get_indexes_columns_mysql' '/omnidb/get_indexes_columns_mysql';
sub_filter '/get_triggers_mysql' '/omnidb/get_triggers_mysql';
sub_filter '/get_partitions_mysql' '/omnidb/get_partitions_mysql';
sub_filter '/get_functions_mysql' '/omnidb/get_functions_mysql';
sub_filter '/get_function_fields_mysql' '/omnidb/get_function_fields_mysql';
sub_filter '/get_function_definition_mysql' '/omnidb/get_function_definition_mysql';
sub_filter '/get_procedures_mysql' '/omnidb/get_procedures_mysql';
sub_filter '/get_procedure_fields_mysql' '/omnidb/get_procedure_fields_mysql';
sub_filter '/get_procedure_definition_mysql' '/omnidb/get_procedure_definition_mysql';
sub_filter '/get_function_debug_mysql' '/omnidb/get_function_debug_mysql';
sub_filter '/get_triggerfunctions_mysql' '/omnidb/get_triggerfunctions_mysql';
sub_filter '/get_triggerfunction_definition_mysql' '/omnidb/gget_triggerfunction_definition_mysql';
sub_filter '/get_sequences_mysql' '/omnidb/get_sequences_mysql';
sub_filter '/get_views_mysql' '/omnidb/get_views_mysql';
sub_filter '/get_views_columns_mysql' '/omnidb/get_views_columns_mysql';
sub_filter '/get_view_definition_mysql' '/omnidb/get_view_definition_mysql';
sub_filter '/get_databases_mysql' '/omnidb/get_databases_mysql';
sub_filter '/get_roles_mysql' '/omnidb/get_roles_mysql';
sub_filter '/kill_backend_mysql' '/omnidb/kill_backend_mysql';
sub_filter '/get_properties_mysql' '/omnidb/get_properties_mysql';
sub_filter '/template_select_mysql' '/omnidb/template_select_mysql';
sub_filter '/template_insert_mysql' '/omnidb/template_insert_mysql';
sub_filter '/template_update_mysql' '/omnidb/template_update_mysql';
#TREE_MARIADB
sub_filter '/get_tree_info_mariadb' '/omnidb/get_tree_info_mariadb';
sub_filter '/get_tables_mariadb' '/omnidb/get_tables_mariadb';
sub_filter '/get_columns_mariadb' '/omnidb/get_columns_mariadb';
sub_filter '/get_pk_mariadb' '/omnidb/get_pk_mariadb';
sub_filter '/get_pk_columns_mariadb' '/omnidb/get_pk_columns_mariadb';
sub_filter '/get_fks_mariadb' '/omnidb/get_fks_mariadb';
sub_filter '/get_fks_columns_mariadb' '/omnidb/get_fks_columns_mariadb';
sub_filter '/get_uniques_mariadb' '/omnidb/get_uniques_mariadb';
sub_filter '/get_uniques_columns_mariadb' '/omnidb/get_uniques_columns_mariadb';
sub_filter '/get_indexes_mariadb' '/omnidb/get_indexes_mariadb';
sub_filter '/get_indexes_columns_mariadb' '/omnidb/get_indexes_columns_mariadb';
sub_filter '/get_triggers_mariadb' '/omnidb/get_triggers_mariadb';
sub_filter '/get_partitions_mariadb' '/omnidb/get_partitions_mariadb';
sub_filter '/get_functions_mariadb' '/omnidb/get_functions_mariadb';
sub_filter '/get_function_fields_mariadb' '/omnidb/get_function_fields_mariadb';
sub_filter '/get_function_definition_mariadb' '/omnidb/get_function_definition_mariadb';
sub_filter '/get_procedures_mariadb' '/omnidb/get_procedures_mariadb';
sub_filter '/get_procedure_fields_mariadb' '/omnidb/get_procedure_fields_mariadb';
sub_filter '/get_procedure_definition_mariadb' '/omnidb/get_procedure_definition_mariadb';
sub_filter '/get_function_debug_mariadb' '/omnidb/get_function_debug_mariadb';
sub_filter '/get_triggerfunctions_mariadb' '/omnidb/get_triggerfunctions_mariadb';
sub_filter '/get_triggerfunction_definition_mariadb' '/omnidb/get_triggerfunction_definition_mariadb';
sub_filter '/get_sequences_mariadb' '/omnidb/get_sequences_mariadb';
sub_filter '/get_views_mariadb' '/omnidb/get_views_mariadb';
sub_filter '/get_views_columns_mariadb' '/omnidb/get_views_columns_mariadb';
sub_filter '/get_view_definition_mariadb' '/omnidb/get_view_definition_mariadb';
sub_filter '/get_databases_mariadb' '/omnidb/get_databases_mariadb';
sub_filter '/get_roles_mariadb' '/omnidb/get_roles_mariadb';
sub_filter '/kill_backend_mariadb' '/omnidb/kill_backend_mariadb';
sub_filter '/get_properties_mariadb' '/omnidb/get_properties_mariadb';
sub_filter '/template_select_mariadb' '/omnidb/template_select_mariadb';
sub_filter '/template_insert_mariadb' '/omnidb/template_insert_mariadb';
sub_filter '/template_update_mariadb' '/omnidb/template_update_mariadb';
#MONITORING SYSTEM
sub_filter '/get_monitor_nodes' '/omnidb/get_monitor_nodes';
sub_filter '/test_monitor_script' '/omnidb/test_monitor_script';
sub_filter '/get_monitor_unit_list' '/omnidb/get_monitor_unit_list';
sub_filter '/get_monitor_unit_details' '/omnidb/get_monitor_unit_details';
sub_filter '/get_monitor_units' '/omnidb/get_monitor_units';
sub_filter '/refresh_monitor_units' '/omnidb/refresh_monitor_units';
sub_filter '/get_monitor_unit_template' '/omnidb/get_monitor_unit_template';
sub_filter '/save_monitor_unit' '/omnidb/save_monitor_unit';
sub_filter '/delete_monitor_unit' '/omnidb/delete_monitor_unit';
sub_filter '/remove_saved_monitor_unit' '/omnidb/remove_saved_monitor_unit';
sub_filter '/update_saved_monitor_unit_interval' '/omnidb/update_saved_monitor_unit_interval';
sub_filter '/XXXX' '/omnidb/XXXX';
sub_filter '/workspace' '/omnidb/workspace';
sub_filter_once off;
sub_filter_types *;
}
location /omnidb/workspace/ {
proxy_pass http://localhost:8000/workspace/ ;
# add_header Content-Base /omnidb/ ;
proxy_http_version 1.1;
proxy_set_header Upgrade $http_upgrade;
proxy_set_header Connection 'upgrade';
proxy_set_header Host $host;
proxy_cache_bypass $http_upgrade;
sub_filter '/static' '/omnidb/static';
sub_filter '/logout' '/omnidb/logout';
sub_filter '/wss' '/omnidb/wss';
sub_filter_once off;
sub_filter_types *;
}
location /omnidb/wss {
proxy_pass http://127.0.0.1:25482;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
proxy_set_header X-Forwarded-Ssl https;
proxy_set_header X-Forwarded-Proto https;
proxy_set_header X-Forwarded-Port 443;
proxy_set_header Host $host;
proxy_http_version 1.1;
proxy_set_header Upgrade $http_upgrade;
proxy_set_header Connection "upgrade";
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment