Created
January 13, 2019 20:58
-
-
Save greenaussie/d10f3b34350133dfebf76df2e5141c42 to your computer and use it in GitHub Desktop.
nginx configuration snippet for ombidb-server behind reverse proxy with path prefix.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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