)]}'
{"devstack/README.md":[{"author":{"_account_id":21922,"name":"Dobroslaw Zybort","email":"dobroslaw.zybort@ts.fujitsu.com","username":"dobrolaw.zybort"},"change_message_id":"dff5ef55660fe8026e7b5cfc2b48671bc83d2dc0","unresolved":false,"context_lines":[{"line_number":99,"context_line":""},{"line_number":100,"context_line":"```"},{"line_number":101,"context_line":""},{"line_number":102,"context_line":"## Using PostgreSQL or Mysql"},{"line_number":103,"context_line":""},{"line_number":104,"context_line":"Monasca supports using both PostreSQL and MySQL and so does this devstack plugin."},{"line_number":105,"context_line":"Enable either ```postgresql``` or ```mysql``` to use either of them."}],"source_content_type":"text/x-gfm","patch_set":79,"id":"3a461143_eb0d313f","line":102,"range":{"start_line":102,"start_character":23,"end_line":102,"end_character":28},"updated":"2017-01-27 10:20:16.000000000","message":"MySQL","commit_id":"66d48e6f14f8f86e38d4ac55846f9e02e674d6b8"},{"author":{"_account_id":16168,"name":"Tomasz Trębski","email":"kornicameister@gmail.com","username":"trebskit"},"change_message_id":"fa549255441a450206dfa09717dc2d81ac2d8664","unresolved":false,"context_lines":[{"line_number":99,"context_line":""},{"line_number":100,"context_line":"```"},{"line_number":101,"context_line":""},{"line_number":102,"context_line":"## Using PostgreSQL or Mysql"},{"line_number":103,"context_line":""},{"line_number":104,"context_line":"Monasca supports using both PostreSQL and MySQL and so does this devstack plugin."},{"line_number":105,"context_line":"Enable either ```postgresql``` or ```mysql``` to use either of them."}],"source_content_type":"text/x-gfm","patch_set":79,"id":"3a461143_4ec7fa63","line":102,"range":{"start_line":102,"start_character":23,"end_line":102,"end_character":28},"in_reply_to":"3a461143_eb0d313f","updated":"2017-01-30 05:16:50.000000000","message":"Done","commit_id":"66d48e6f14f8f86e38d4ac55846f9e02e674d6b8"},{"author":{"_account_id":21922,"name":"Dobroslaw Zybort","email":"dobroslaw.zybort@ts.fujitsu.com","username":"dobrolaw.zybort"},"change_message_id":"dff5ef55660fe8026e7b5cfc2b48671bc83d2dc0","unresolved":false,"context_lines":[{"line_number":101,"context_line":""},{"line_number":102,"context_line":"## Using PostgreSQL or Mysql"},{"line_number":103,"context_line":""},{"line_number":104,"context_line":"Monasca supports using both PostreSQL and MySQL and so does this devstack plugin."},{"line_number":105,"context_line":"Enable either ```postgresql``` or ```mysql``` to use either of them."},{"line_number":106,"context_line":""},{"line_number":107,"context_line":"To setup environment with MySQL use:"}],"source_content_type":"text/x-gfm","patch_set":79,"id":"3a461143_6b194188","line":104,"range":{"start_line":104,"start_character":28,"end_line":104,"end_character":37},"updated":"2017-01-27 10:20:16.000000000","message":"PostgreSQL","commit_id":"66d48e6f14f8f86e38d4ac55846f9e02e674d6b8"},{"author":{"_account_id":16168,"name":"Tomasz Trębski","email":"kornicameister@gmail.com","username":"trebskit"},"change_message_id":"fa549255441a450206dfa09717dc2d81ac2d8664","unresolved":false,"context_lines":[{"line_number":101,"context_line":""},{"line_number":102,"context_line":"## Using PostgreSQL or Mysql"},{"line_number":103,"context_line":""},{"line_number":104,"context_line":"Monasca supports using both PostreSQL and MySQL and so does this devstack plugin."},{"line_number":105,"context_line":"Enable either ```postgresql``` or ```mysql``` to use either of them."},{"line_number":106,"context_line":""},{"line_number":107,"context_line":"To setup environment with MySQL use:"}],"source_content_type":"text/x-gfm","patch_set":79,"id":"3a461143_6ec4b65e","line":104,"range":{"start_line":104,"start_character":28,"end_line":104,"end_character":37},"in_reply_to":"3a461143_6b194188","updated":"2017-01-30 05:16:50.000000000","message":"Done","commit_id":"66d48e6f14f8f86e38d4ac55846f9e02e674d6b8"}],"devstack/Vagrantfile":[{"author":{"_account_id":18286,"name":"Shinya Kawabata","email":"s-kawabata@wx.jp.nec.com","username":"kawabata"},"change_message_id":"490f05ec5c7aa535f913552ce5bfa569c9c83f18","unresolved":false,"context_lines":[{"line_number":90,"context_line":"LOGDIR\u003d$DEST/logs"},{"line_number":91,"context_line":"LOG_COLOR\u003dFalse"},{"line_number":92,"context_line":""},{"line_number":93,"context_line":"# Check database backend for devstack"},{"line_number":94,"context_line":"MONASCA_DATABASE_BACKEND\u003d${MONASCA_DATABASE_BACKEND:-mysql}"},{"line_number":95,"context_line":"MONASCA_DATABASE_USE_ORM\u003d${MONASCA_DATABASE_USE_ORM:-false}"},{"line_number":96,"context_line":""}],"source_content_type":"application/octet-stream","patch_set":7,"id":"1ac06dbe_21d379d6","line":93,"range":{"start_line":93,"start_character":0,"end_line":93,"end_character":37},"updated":"2016-08-24 06:49:07.000000000","message":"Why don\u0027t you show options we can select as comment?","commit_id":"93034dca25a5d1d007b2fc06fe9e1a37d96d868b"},{"author":{"_account_id":20033,"name":"Artur Basiak","email":"artur.basiak@ts.fujitsu.com","username":"abasiak"},"change_message_id":"1c793d3ce2f1766d27312272294523789193d771","unresolved":false,"context_lines":[{"line_number":90,"context_line":"LOGDIR\u003d$DEST/logs"},{"line_number":91,"context_line":"LOG_COLOR\u003dFalse"},{"line_number":92,"context_line":""},{"line_number":93,"context_line":"# Check database backend for devstack"},{"line_number":94,"context_line":"MONASCA_DATABASE_BACKEND\u003d${MONASCA_DATABASE_BACKEND:-mysql}"},{"line_number":95,"context_line":"MONASCA_DATABASE_USE_ORM\u003d${MONASCA_DATABASE_USE_ORM:-false}"},{"line_number":96,"context_line":""}],"source_content_type":"application/octet-stream","patch_set":7,"id":"1ac06dbe_5243e16b","line":93,"range":{"start_line":93,"start_character":0,"end_line":93,"end_character":37},"in_reply_to":"1ac06dbe_21d379d6","updated":"2016-08-24 07:02:33.000000000","message":"Ok, but the problem is we need to know which database is used and which should be configured.\nIn devstack documentation it is written that if we want to use postgresql, mysql shouldn\u0027t be installed.","commit_id":"93034dca25a5d1d007b2fc06fe9e1a37d96d868b"},{"author":{"_account_id":16168,"name":"Tomasz Trębski","email":"kornicameister@gmail.com","username":"trebskit"},"change_message_id":"9374f9d210fe894215c09320e03b81b985bd7d1c","unresolved":false,"context_lines":[{"line_number":91,"context_line":"LOG_COLOR\u003dFalse"},{"line_number":92,"context_line":""},{"line_number":93,"context_line":"# Check database backend for devstack"},{"line_number":94,"context_line":"MONASCA_DATABASE_BACKEND\u003d${MONASCA_DATABASE_BACKEND:-mysql}"},{"line_number":95,"context_line":"MONASCA_DATABASE_USE_ORM\u003d${MONASCA_DATABASE_USE_ORM:-false}"},{"line_number":96,"context_line":""},{"line_number":97,"context_line":"disable_all_services"}],"source_content_type":"application/octet-stream","patch_set":12,"id":"fa7ab95a_ac6faf29","line":94,"updated":"2016-08-29 11:58:48.000000000","message":"MONASCA_DATABASE_BACKEND needs to be removed actually.","commit_id":"4d63f17ccb7978f919e83779a668cd1474dedbcd"},{"author":{"_account_id":16168,"name":"Tomasz Trębski","email":"kornicameister@gmail.com","username":"trebskit"},"change_message_id":"9374f9d210fe894215c09320e03b81b985bd7d1c","unresolved":false,"context_lines":[{"line_number":95,"context_line":"MONASCA_DATABASE_USE_ORM\u003d${MONASCA_DATABASE_USE_ORM:-false}"},{"line_number":96,"context_line":""},{"line_number":97,"context_line":"disable_all_services"},{"line_number":98,"context_line":"enable_service rabbit postgresql key tempest horizon"},{"line_number":99,"context_line":""},{"line_number":100,"context_line":"# The following two variables allow switching between Java and Python for the implementations"},{"line_number":101,"context_line":"# of the Monasca API and the Monasca Persister. If these variables are not set, then the"}],"source_content_type":"application/octet-stream","patch_set":12,"id":"fa7ab95a_4c9c630f","line":98,"updated":"2016-08-29 11:58:48.000000000","message":"This one I will revert in the next patch set.","commit_id":"4d63f17ccb7978f919e83779a668cd1474dedbcd"},{"author":{"_account_id":11809,"name":"Craig Bryant","email":"craig.bryant@hpe.com","username":"craig-bryant"},"change_message_id":"9fd01bd818635b03b00167367d2fed0ec730c2e8","unresolved":false,"context_lines":[{"line_number":93,"context_line":""},{"line_number":94,"context_line":"DEST\u003d/opt/stack"},{"line_number":95,"context_line":""},{"line_number":96,"context_line":"# HINT: If postgresql service is enabled, ORM is enforced"},{"line_number":97,"context_line":"MONASCA_DATABASE_USE_ORM\u003d${MONASCA_DATABASE_USE_ORM:-false}"},{"line_number":98,"context_line":""},{"line_number":99,"context_line":"disable_all_services"}],"source_content_type":"application/octet-stream","patch_set":75,"id":"5a3905b3_3196b6f0","line":96,"range":{"start_line":96,"start_character":0,"end_line":96,"end_character":57},"updated":"2017-01-20 20:58:38.000000000","message":"I would like to see something to uncomment that would bring it up with postgres. It is not obvious how to do that","commit_id":"45b0c952c9031df351abb7ead9b3059850b9c243"},{"author":{"_account_id":16168,"name":"Tomasz Trębski","email":"kornicameister@gmail.com","username":"trebskit"},"change_message_id":"f5ab9f398836fb04bd5e1050cf591d99add17642","unresolved":false,"context_lines":[{"line_number":93,"context_line":""},{"line_number":94,"context_line":"DEST\u003d/opt/stack"},{"line_number":95,"context_line":""},{"line_number":96,"context_line":"# HINT: If postgresql service is enabled, ORM is enforced"},{"line_number":97,"context_line":"MONASCA_DATABASE_USE_ORM\u003d${MONASCA_DATABASE_USE_ORM:-false}"},{"line_number":98,"context_line":""},{"line_number":99,"context_line":"disable_all_services"}],"source_content_type":"application/octet-stream","patch_set":75,"id":"5a3905b3_e1f4325c","line":96,"range":{"start_line":96,"start_character":0,"end_line":96,"end_character":57},"in_reply_to":"5a3905b3_3196b6f0","updated":"2017-01-23 06:32:24.000000000","message":"Done.\n\nAdded variable MONASCA_RDB_BACKEND which is either mysql or postgresql and it is passed to enable_service call.\nYou will be able to uncomment either line to have postgres or mysql.","commit_id":"45b0c952c9031df351abb7ead9b3059850b9c243"},{"author":{"_account_id":22157,"name":"Andrea Adams","email":"aadams@hpe.com","username":"andrea.adams"},"change_message_id":"42369c0f343d7583c204e90e6fc8db366c3352db","unresolved":false,"context_lines":[{"line_number":95,"context_line":""},{"line_number":96,"context_line":"# Uncomment of of the following lines to use either MySQL or PostgreSQL"},{"line_number":97,"context_line":"# as RDB (relational database) backend for monasca."},{"line_number":98,"context_line":"MONASCA_RDB_BACKEND\u003d${MONASCA_DB_BACKEND:-mysql}"},{"line_number":99,"context_line":"#MONASCA_RDB_BACKEND\u003d${MONASCA_DB_BACKEND:-postgresql}"},{"line_number":100,"context_line":""},{"line_number":101,"context_line":"# HINT: If postgresql service is enabled, ORM is enforced"}],"source_content_type":"application/octet-stream","patch_set":77,"id":"3a461143_340fdbe2","line":98,"range":{"start_line":98,"start_character":0,"end_line":98,"end_character":48},"updated":"2017-01-25 23:30:16.000000000","message":"Do we need to add any documentation incase the user want to use stack.sh or will it work ok without these variables in local.conf?","commit_id":"6ae503b8a3a986bd51a6bf2ae965c3cf3e26d9d8"},{"author":{"_account_id":16168,"name":"Tomasz Trębski","email":"kornicameister@gmail.com","username":"trebskit"},"change_message_id":"b6aa21c0a414937bb76b61606139fa33ac73d56c","unresolved":false,"context_lines":[{"line_number":95,"context_line":""},{"line_number":96,"context_line":"# Uncomment of of the following lines to use either MySQL or PostgreSQL"},{"line_number":97,"context_line":"# as RDB (relational database) backend for monasca."},{"line_number":98,"context_line":"MONASCA_RDB_BACKEND\u003d${MONASCA_DB_BACKEND:-mysql}"},{"line_number":99,"context_line":"#MONASCA_RDB_BACKEND\u003d${MONASCA_DB_BACKEND:-postgresql}"},{"line_number":100,"context_line":""},{"line_number":101,"context_line":"# HINT: If postgresql service is enabled, ORM is enforced"}],"source_content_type":"application/octet-stream","patch_set":77,"id":"3a461143_0527fa12","line":98,"range":{"start_line":98,"start_character":0,"end_line":98,"end_character":48},"in_reply_to":"3a461143_340fdbe2","updated":"2017-01-26 10:49:13.000000000","message":"You know what, I think I will just add another enable_service line below first one with the same comment that will be better and will not introduce any doubts around new variable.","commit_id":"6ae503b8a3a986bd51a6bf2ae965c3cf3e26d9d8"},{"author":{"_account_id":21922,"name":"Dobroslaw Zybort","email":"dobroslaw.zybort@ts.fujitsu.com","username":"dobrolaw.zybort"},"change_message_id":"dff5ef55660fe8026e7b5cfc2b48671bc83d2dc0","unresolved":false,"context_lines":[{"line_number":96,"context_line":"disable_all_services"},{"line_number":97,"context_line":"enable_service zookeeper rabbit key tempest horizon"},{"line_number":98,"context_line":""},{"line_number":99,"context_line":"# Uncomment of of the following lines to use either MySQL or PostgreSQL"},{"line_number":100,"context_line":"# as RDB (relational database) backend for monasca."},{"line_number":101,"context_line":"enable_service mysql"},{"line_number":102,"context_line":"#enable_service postgresql"}],"source_content_type":"application/octet-stream","patch_set":79,"id":"3a461143_0e10cb4d","line":99,"range":{"start_line":99,"start_character":12,"end_line":99,"end_character":14},"updated":"2017-01-27 10:20:16.000000000","message":"one","commit_id":"66d48e6f14f8f86e38d4ac55846f9e02e674d6b8"},{"author":{"_account_id":16168,"name":"Tomasz Trębski","email":"kornicameister@gmail.com","username":"trebskit"},"change_message_id":"fa549255441a450206dfa09717dc2d81ac2d8664","unresolved":false,"context_lines":[{"line_number":96,"context_line":"disable_all_services"},{"line_number":97,"context_line":"enable_service zookeeper rabbit key tempest horizon"},{"line_number":98,"context_line":""},{"line_number":99,"context_line":"# Uncomment of of the following lines to use either MySQL or PostgreSQL"},{"line_number":100,"context_line":"# as RDB (relational database) backend for monasca."},{"line_number":101,"context_line":"enable_service mysql"},{"line_number":102,"context_line":"#enable_service postgresql"}],"source_content_type":"application/octet-stream","patch_set":79,"id":"3a461143_eeaee696","line":99,"range":{"start_line":99,"start_character":12,"end_line":99,"end_character":14},"in_reply_to":"3a461143_0e10cb4d","updated":"2017-01-30 05:16:50.000000000","message":"Done","commit_id":"66d48e6f14f8f86e38d4ac55846f9e02e674d6b8"}],"devstack/files/monasca-api/api-config.yml":[{"author":{"_account_id":11809,"name":"Craig Bryant","email":"craig.bryant@hpe.com","username":"craig-bryant"},"change_message_id":"e2ed7a60e00e733100d2361b7f7ab568978ecd45","unresolved":false,"context_lines":[{"line_number":52,"context_line":"  checkConnectionOnBorrow: true"},{"line_number":53,"context_line":""},{"line_number":54,"context_line":"# Available data sources are:"},{"line_number":55,"context_line":"# - com.mysql.jdbc.jdbc2.optional.MysqlDataSource"},{"line_number":56,"context_line":"# - org.postgresql.ds.PGPoolingDataSource"},{"line_number":57,"context_line":"# HINT: dataSourceUrl is relevant only for mysql"},{"line_number":58,"context_line":"hibernate:"}],"source_content_type":"text/x-yaml","patch_set":75,"id":"5a3905b3_386ea995","line":55,"range":{"start_line":55,"start_character":4,"end_line":55,"end_character":49},"updated":"2017-01-20 15:17:37.000000000","message":"Its not clear where these could go. The comment above says \"data sources\" but that doesn\u0027t match any of the names below","commit_id":"45b0c952c9031df351abb7ead9b3059850b9c243"},{"author":{"_account_id":16168,"name":"Tomasz Trębski","email":"kornicameister@gmail.com","username":"trebskit"},"change_message_id":"f5ab9f398836fb04bd5e1050cf591d99add17642","unresolved":false,"context_lines":[{"line_number":52,"context_line":"  checkConnectionOnBorrow: true"},{"line_number":53,"context_line":""},{"line_number":54,"context_line":"# Available data sources are:"},{"line_number":55,"context_line":"# - com.mysql.jdbc.jdbc2.optional.MysqlDataSource"},{"line_number":56,"context_line":"# - org.postgresql.ds.PGPoolingDataSource"},{"line_number":57,"context_line":"# HINT: dataSourceUrl is relevant only for mysql"},{"line_number":58,"context_line":"hibernate:"}],"source_content_type":"text/x-yaml","patch_set":75,"id":"5a3905b3_e1c272e8","line":55,"range":{"start_line":55,"start_character":4,"end_line":55,"end_character":49},"in_reply_to":"5a3905b3_386ea995","updated":"2017-01-23 06:32:24.000000000","message":"Done, rewritten to explicitly point at dataSourceClassName property.","commit_id":"45b0c952c9031df351abb7ead9b3059850b9c243"}],"devstack/files/monasca-api/python/api-config.conf":[{"author":{"_account_id":11809,"name":"Craig Bryant","email":"craig.bryant@hpe.com","username":"craig-bryant"},"change_message_id":"e2ed7a60e00e733100d2361b7f7ab568978ecd45","unresolved":false,"context_lines":[{"line_number":44,"context_line":"# Available options:"},{"line_number":45,"context_line":"# - Influx \u003d\u003e monasca_api.common.repositories.influxdb.metrics_repository:MetricsRepository"},{"line_number":46,"context_line":"# - Cassandra \u003d\u003e monasca_api.common.repositories.cassandra.metrics_repository:MetricsRepository"},{"line_number":47,"context_line":"# metrics_driver \u003d monasca_api.common.repositories.influxdb.metrics_repository:MetricsRepository"},{"line_number":48,"context_line":"metrics_driver \u003d %MONASCA_METRIC_DATABASE_DRIVER%"},{"line_number":49,"context_line":""},{"line_number":50,"context_line":"# The driver to use for the alarm definitions repository"}],"source_content_type":"text/plain","patch_set":75,"id":"5a3905b3_18a00d90","line":47,"range":{"start_line":47,"start_character":0,"end_line":47,"end_character":96},"updated":"2017-01-20 15:17:37.000000000","message":"Shouldn\u0027t you just delete the above line?","commit_id":"45b0c952c9031df351abb7ead9b3059850b9c243"},{"author":{"_account_id":16168,"name":"Tomasz Trębski","email":"kornicameister@gmail.com","username":"trebskit"},"change_message_id":"f5ab9f398836fb04bd5e1050cf591d99add17642","unresolved":false,"context_lines":[{"line_number":44,"context_line":"# Available options:"},{"line_number":45,"context_line":"# - Influx \u003d\u003e monasca_api.common.repositories.influxdb.metrics_repository:MetricsRepository"},{"line_number":46,"context_line":"# - Cassandra \u003d\u003e monasca_api.common.repositories.cassandra.metrics_repository:MetricsRepository"},{"line_number":47,"context_line":"# metrics_driver \u003d monasca_api.common.repositories.influxdb.metrics_repository:MetricsRepository"},{"line_number":48,"context_line":"metrics_driver \u003d %MONASCA_METRIC_DATABASE_DRIVER%"},{"line_number":49,"context_line":""},{"line_number":50,"context_line":"# The driver to use for the alarm definitions repository"}],"source_content_type":"text/plain","patch_set":75,"id":"5a3905b3_a1a5ca47","line":47,"range":{"start_line":47,"start_character":0,"end_line":47,"end_character":96},"in_reply_to":"5a3905b3_18a00d90","updated":"2017-01-23 06:32:24.000000000","message":"Done","commit_id":"45b0c952c9031df351abb7ead9b3059850b9c243"},{"author":{"_account_id":21922,"name":"Dobroslaw Zybort","email":"dobroslaw.zybort@ts.fujitsu.com","username":"dobrolaw.zybort"},"change_message_id":"dff5ef55660fe8026e7b5cfc2b48671bc83d2dc0","unresolved":false,"context_lines":[{"line_number":42,"context_line":"[repositories]"},{"line_number":43,"context_line":"# The driver to use for the metrics repository"},{"line_number":44,"context_line":"# Available options:"},{"line_number":45,"context_line":"# - Influx \u003d\u003e monasca_api.common.repositories.influxdb.metrics_repository:MetricsRepository"},{"line_number":46,"context_line":"# - Cassandra \u003d\u003e monasca_api.common.repositories.cassandra.metrics_repository:MetricsRepository"},{"line_number":47,"context_line":"metrics_driver \u003d %MONASCA_METRIC_DATABASE_DRIVER%"},{"line_number":48,"context_line":""}],"source_content_type":"text/plain","patch_set":79,"id":"3a461143_aeffb765","line":45,"range":{"start_line":45,"start_character":4,"end_line":45,"end_character":10},"updated":"2017-01-27 10:20:16.000000000","message":"InfluxDB","commit_id":"66d48e6f14f8f86e38d4ac55846f9e02e674d6b8"},{"author":{"_account_id":16168,"name":"Tomasz Trębski","email":"kornicameister@gmail.com","username":"trebskit"},"change_message_id":"fa549255441a450206dfa09717dc2d81ac2d8664","unresolved":false,"context_lines":[{"line_number":42,"context_line":"[repositories]"},{"line_number":43,"context_line":"# The driver to use for the metrics repository"},{"line_number":44,"context_line":"# Available options:"},{"line_number":45,"context_line":"# - Influx \u003d\u003e monasca_api.common.repositories.influxdb.metrics_repository:MetricsRepository"},{"line_number":46,"context_line":"# - Cassandra \u003d\u003e monasca_api.common.repositories.cassandra.metrics_repository:MetricsRepository"},{"line_number":47,"context_line":"metrics_driver \u003d %MONASCA_METRIC_DATABASE_DRIVER%"},{"line_number":48,"context_line":""}],"source_content_type":"text/plain","patch_set":79,"id":"3a461143_0e989277","line":45,"range":{"start_line":45,"start_character":4,"end_line":45,"end_character":10},"in_reply_to":"3a461143_aeffb765","updated":"2017-01-30 05:16:50.000000000","message":"Done","commit_id":"66d48e6f14f8f86e38d4ac55846f9e02e674d6b8"}],"devstack/files/monasca-notification/notification.yaml":[{"author":{"_account_id":21922,"name":"Dobroslaw Zybort","email":"dobroslaw.zybort@ts.fujitsu.com","username":"dobrolaw.zybort"},"change_message_id":"dff5ef55660fe8026e7b5cfc2b48671bc83d2dc0","unresolved":false,"context_lines":[{"line_number":42,"context_line":"postgresql:"},{"line_number":43,"context_line":"  host: %DATABASE_HOST%"},{"line_number":44,"context_line":"  port: %DATABASE_PORT%"},{"line_number":45,"context_line":"  user: notification"},{"line_number":46,"context_line":"  password: %DATABASE_PASSWORD%"},{"line_number":47,"context_line":"  database: mon"},{"line_number":48,"context_line":""}],"source_content_type":"text/x-yaml","patch_set":79,"id":"3a461143_6e2cef02","line":45,"range":{"start_line":45,"start_character":8,"end_line":45,"end_character":20},"updated":"2017-01-27 10:20:16.000000000","message":"Should be %MONASCA_NOTIFICATION_DATABASE_USER% ?","commit_id":"66d48e6f14f8f86e38d4ac55846f9e02e674d6b8"},{"author":{"_account_id":16168,"name":"Tomasz Trębski","email":"kornicameister@gmail.com","username":"trebskit"},"change_message_id":"fa549255441a450206dfa09717dc2d81ac2d8664","unresolved":false,"context_lines":[{"line_number":42,"context_line":"postgresql:"},{"line_number":43,"context_line":"  host: %DATABASE_HOST%"},{"line_number":44,"context_line":"  port: %DATABASE_PORT%"},{"line_number":45,"context_line":"  user: notification"},{"line_number":46,"context_line":"  password: %DATABASE_PASSWORD%"},{"line_number":47,"context_line":"  database: mon"},{"line_number":48,"context_line":""}],"source_content_type":"text/x-yaml","patch_set":79,"id":"3a461143_6e9bd672","line":45,"range":{"start_line":45,"start_character":8,"end_line":45,"end_character":20},"in_reply_to":"3a461143_6e2cef02","updated":"2017-01-30 05:16:50.000000000","message":"Done","commit_id":"66d48e6f14f8f86e38d4ac55846f9e02e674d6b8"}],"devstack/files/monasca-thresh/thresh-config.yml":[{"author":{"_account_id":21922,"name":"Dobroslaw Zybort","email":"dobroslaw.zybort@ts.fujitsu.com","username":"dobrolaw.zybort"},"change_message_id":"dff5ef55660fe8026e7b5cfc2b48671bc83d2dc0","unresolved":false,"context_lines":[{"line_number":131,"context_line":"  # hibernate provider class"},{"line_number":132,"context_line":"  providerClass: com.zaxxer.hikari.hibernate.HikariConnectionProvider"},{"line_number":133,"context_line":""},{"line_number":134,"context_line":"  #Database name"},{"line_number":135,"context_line":"  databaseName: mon"},{"line_number":136,"context_line":""},{"line_number":137,"context_line":"  #Server name/address"}],"source_content_type":"text/x-yaml","patch_set":79,"id":"3a461143_0e3c4b2e","line":134,"updated":"2017-01-27 10:20:16.000000000","message":"Add space, stick to the same comment convention.","commit_id":"66d48e6f14f8f86e38d4ac55846f9e02e674d6b8"},{"author":{"_account_id":16168,"name":"Tomasz Trębski","email":"kornicameister@gmail.com","username":"trebskit"},"change_message_id":"fa549255441a450206dfa09717dc2d81ac2d8664","unresolved":false,"context_lines":[{"line_number":131,"context_line":"  # hibernate provider class"},{"line_number":132,"context_line":"  providerClass: com.zaxxer.hikari.hibernate.HikariConnectionProvider"},{"line_number":133,"context_line":""},{"line_number":134,"context_line":"  #Database name"},{"line_number":135,"context_line":"  databaseName: mon"},{"line_number":136,"context_line":""},{"line_number":137,"context_line":"  #Server name/address"}],"source_content_type":"text/x-yaml","patch_set":79,"id":"3a461143_ce804afa","line":134,"in_reply_to":"3a461143_0e3c4b2e","updated":"2017-01-30 05:16:50.000000000","message":"Done","commit_id":"66d48e6f14f8f86e38d4ac55846f9e02e674d6b8"},{"author":{"_account_id":21922,"name":"Dobroslaw Zybort","email":"dobroslaw.zybort@ts.fujitsu.com","username":"dobrolaw.zybort"},"change_message_id":"dff5ef55660fe8026e7b5cfc2b48671bc83d2dc0","unresolved":false,"context_lines":[{"line_number":134,"context_line":"  #Database name"},{"line_number":135,"context_line":"  databaseName: mon"},{"line_number":136,"context_line":""},{"line_number":137,"context_line":"  #Server name/address"},{"line_number":138,"context_line":"  serverName: %DATABASE_HOST%"},{"line_number":139,"context_line":""},{"line_number":140,"context_line":"  #Server port number"}],"source_content_type":"text/x-yaml","patch_set":79,"id":"3a461143_6e130fb9","line":137,"updated":"2017-01-27 10:20:16.000000000","message":"Add space","commit_id":"66d48e6f14f8f86e38d4ac55846f9e02e674d6b8"},{"author":{"_account_id":16168,"name":"Tomasz Trębski","email":"kornicameister@gmail.com","username":"trebskit"},"change_message_id":"fa549255441a450206dfa09717dc2d81ac2d8664","unresolved":false,"context_lines":[{"line_number":134,"context_line":"  #Database name"},{"line_number":135,"context_line":"  databaseName: mon"},{"line_number":136,"context_line":""},{"line_number":137,"context_line":"  #Server name/address"},{"line_number":138,"context_line":"  serverName: %DATABASE_HOST%"},{"line_number":139,"context_line":""},{"line_number":140,"context_line":"  #Server port number"}],"source_content_type":"text/x-yaml","patch_set":79,"id":"3a461143_ee850607","line":137,"in_reply_to":"3a461143_6e130fb9","updated":"2017-01-30 05:16:50.000000000","message":"Done","commit_id":"66d48e6f14f8f86e38d4ac55846f9e02e674d6b8"},{"author":{"_account_id":21922,"name":"Dobroslaw Zybort","email":"dobroslaw.zybort@ts.fujitsu.com","username":"dobrolaw.zybort"},"change_message_id":"dff5ef55660fe8026e7b5cfc2b48671bc83d2dc0","unresolved":false,"context_lines":[{"line_number":137,"context_line":"  #Server name/address"},{"line_number":138,"context_line":"  serverName: %DATABASE_HOST%"},{"line_number":139,"context_line":""},{"line_number":140,"context_line":"  #Server port number"},{"line_number":141,"context_line":"  portNumber: %DATABASE_PORT%"},{"line_number":142,"context_line":""},{"line_number":143,"context_line":"  #Hibernate auto configuretion parameter"}],"source_content_type":"text/x-yaml","patch_set":79,"id":"3a461143_8e167ba5","line":140,"updated":"2017-01-27 10:20:16.000000000","message":"Add space","commit_id":"66d48e6f14f8f86e38d4ac55846f9e02e674d6b8"},{"author":{"_account_id":16168,"name":"Tomasz Trębski","email":"kornicameister@gmail.com","username":"trebskit"},"change_message_id":"fa549255441a450206dfa09717dc2d81ac2d8664","unresolved":false,"context_lines":[{"line_number":137,"context_line":"  #Server name/address"},{"line_number":138,"context_line":"  serverName: %DATABASE_HOST%"},{"line_number":139,"context_line":""},{"line_number":140,"context_line":"  #Server port number"},{"line_number":141,"context_line":"  portNumber: %DATABASE_PORT%"},{"line_number":142,"context_line":""},{"line_number":143,"context_line":"  #Hibernate auto configuretion parameter"}],"source_content_type":"text/x-yaml","patch_set":79,"id":"3a461143_0e7fb215","line":140,"in_reply_to":"3a461143_8e167ba5","updated":"2017-01-30 05:16:50.000000000","message":"Done","commit_id":"66d48e6f14f8f86e38d4ac55846f9e02e674d6b8"},{"author":{"_account_id":21922,"name":"Dobroslaw Zybort","email":"dobroslaw.zybort@ts.fujitsu.com","username":"dobrolaw.zybort"},"change_message_id":"dff5ef55660fe8026e7b5cfc2b48671bc83d2dc0","unresolved":false,"context_lines":[{"line_number":140,"context_line":"  #Server port number"},{"line_number":141,"context_line":"  portNumber: %DATABASE_PORT%"},{"line_number":142,"context_line":""},{"line_number":143,"context_line":"  #Hibernate auto configuretion parameter"},{"line_number":144,"context_line":"  autoConfig: validate"}],"source_content_type":"text/x-yaml","patch_set":79,"id":"3a461143_ae0df791","line":143,"updated":"2017-01-27 10:20:16.000000000","message":"Add space","commit_id":"66d48e6f14f8f86e38d4ac55846f9e02e674d6b8"},{"author":{"_account_id":16168,"name":"Tomasz Trębski","email":"kornicameister@gmail.com","username":"trebskit"},"change_message_id":"fa549255441a450206dfa09717dc2d81ac2d8664","unresolved":false,"context_lines":[{"line_number":140,"context_line":"  #Server port number"},{"line_number":141,"context_line":"  portNumber: %DATABASE_PORT%"},{"line_number":142,"context_line":""},{"line_number":143,"context_line":"  #Hibernate auto configuretion parameter"},{"line_number":144,"context_line":"  autoConfig: validate"}],"source_content_type":"text/x-yaml","patch_set":79,"id":"3a461143_2e7c6e1e","line":143,"in_reply_to":"3a461143_ae0df791","updated":"2017-01-30 05:16:50.000000000","message":"Done","commit_id":"66d48e6f14f8f86e38d4ac55846f9e02e674d6b8"}],"devstack/files/schema/mon_postgresql.sql":[{"author":{"_account_id":21922,"name":"Dobroslaw Zybort","email":"dobroslaw.zybort@ts.fujitsu.com","username":"dobrolaw.zybort"},"change_message_id":"dff5ef55660fe8026e7b5cfc2b48671bc83d2dc0","unresolved":false,"context_lines":[{"line_number":105,"context_line":"    expression text NOT NULL,"},{"line_number":106,"context_line":"    alarm_id character varying(36) NOT NULL,"},{"line_number":107,"context_line":"    sub_expression_id character varying(36),"},{"line_number":108,"context_line":"    state character varying(20) NOT NULL DEFAULT \u0027OK\u0027"},{"line_number":109,"context_line":");"},{"line_number":110,"context_line":""},{"line_number":111,"context_line":"CREATE TABLE sub_alarm_definition ("}],"source_content_type":"text/x-sql","patch_set":79,"id":"3a461143_4ea7334f","line":108,"range":{"start_line":108,"start_character":50,"end_line":108,"end_character":52},"updated":"2017-01-27 10:20:16.000000000","message":"I think default should be `UNDETERMINED`. Change to `OK` only when you are sure it\u0027s OK, not by default.","commit_id":"66d48e6f14f8f86e38d4ac55846f9e02e674d6b8"},{"author":{"_account_id":16168,"name":"Tomasz Trębski","email":"kornicameister@gmail.com","username":"trebskit"},"change_message_id":"fa549255441a450206dfa09717dc2d81ac2d8664","unresolved":false,"context_lines":[{"line_number":105,"context_line":"    expression text NOT NULL,"},{"line_number":106,"context_line":"    alarm_id character varying(36) NOT NULL,"},{"line_number":107,"context_line":"    sub_expression_id character varying(36),"},{"line_number":108,"context_line":"    state character varying(20) NOT NULL DEFAULT \u0027OK\u0027"},{"line_number":109,"context_line":");"},{"line_number":110,"context_line":""},{"line_number":111,"context_line":"CREATE TABLE sub_alarm_definition ("}],"source_content_type":"text/x-sql","patch_set":79,"id":"3a461143_6e72f64a","line":108,"range":{"start_line":108,"start_character":50,"end_line":108,"end_character":52},"in_reply_to":"3a461143_4ea7334f","updated":"2017-01-30 05:16:50.000000000","message":"Nope, that\u0027s the same value as it is in mysql schema.","commit_id":"66d48e6f14f8f86e38d4ac55846f9e02e674d6b8"}],"devstack/plugin.sh":[{"author":{"_account_id":18286,"name":"Shinya Kawabata","email":"s-kawabata@wx.jp.nec.com","username":"kawabata"},"change_message_id":"490f05ec5c7aa535f913552ce5bfa569c9c83f18","unresolved":false,"context_lines":[{"line_number":750,"context_line":"        sudo mysql -h \"127.0.0.1\" -uroot -psecretmysql \u003c /opt/monasca/sqls/mon.sql || echo \"Did the schema change? This process will fail on schema changes.\""},{"line_number":751,"context_line":"    elif [[ \"${MONASCA_DATABASE_BACKEND,,}\" \u003d\u003d \u0027postgresql\u0027 ]]; then"},{"line_number":752,"context_line":"        sudo -u postgres psql -c \"DROP DATABASE IF EXISTS mon;\""},{"line_number":753,"context_line":"        sudo -u postgres psql -c \"CREATE DATABASE mon ENCODING \u0027UTF8\u0027 LC_COLLATE \u0027en_us.UTF-8\u0027;\""},{"line_number":754,"context_line":"        sudo -u postgres psql -d mon -f /opt/monasca/sqls/mon.sql || echo \"Did the schema change? This process will fail on schema changes.\""},{"line_number":755,"context_line":"    fi"},{"line_number":756,"context_line":""}],"source_content_type":"text/x-sh","patch_set":7,"id":"1ac06dbe_77236fbd","line":753,"range":{"start_line":753,"start_character":85,"end_line":753,"end_character":87},"updated":"2016-08-24 06:49:07.000000000","message":"Upper case \u0027US\u0027 works in my environment.","commit_id":"93034dca25a5d1d007b2fc06fe9e1a37d96d868b"},{"author":{"_account_id":20033,"name":"Artur Basiak","email":"artur.basiak@ts.fujitsu.com","username":"abasiak"},"change_message_id":"f439f977f25f082d9e882d0b4e879f5c43b50412","unresolved":false,"context_lines":[{"line_number":750,"context_line":"        sudo mysql -h \"127.0.0.1\" -uroot -psecretmysql \u003c /opt/monasca/sqls/mon.sql || echo \"Did the schema change? This process will fail on schema changes.\""},{"line_number":751,"context_line":"    elif [[ \"${MONASCA_DATABASE_BACKEND,,}\" \u003d\u003d \u0027postgresql\u0027 ]]; then"},{"line_number":752,"context_line":"        sudo -u postgres psql -c \"DROP DATABASE IF EXISTS mon;\""},{"line_number":753,"context_line":"        sudo -u postgres psql -c \"CREATE DATABASE mon ENCODING \u0027UTF8\u0027 LC_COLLATE \u0027en_us.UTF-8\u0027;\""},{"line_number":754,"context_line":"        sudo -u postgres psql -d mon -f /opt/monasca/sqls/mon.sql || echo \"Did the schema change? This process will fail on schema changes.\""},{"line_number":755,"context_line":"    fi"},{"line_number":756,"context_line":""}],"source_content_type":"text/x-sh","patch_set":7,"id":"1ac06dbe_11596635","line":753,"range":{"start_line":753,"start_character":85,"end_line":753,"end_character":87},"in_reply_to":"1ac06dbe_77236fbd","updated":"2016-08-24 07:29:35.000000000","message":"Done","commit_id":"93034dca25a5d1d007b2fc06fe9e1a37d96d868b"},{"author":{"_account_id":14123,"name":"Stefano Canepa","email":"sc@linux.it","username":"sc"},"change_message_id":"82aa29a47e1c997cef40593b6013629ed476ce62","unresolved":false,"context_lines":[{"line_number":761,"context_line":"    sudo chown root:root /opt/monasca/sqls/winchester.sql"},{"line_number":762,"context_line":""},{"line_number":763,"context_line":"    # must login as root@localhost"},{"line_number":764,"context_line":"    sudo mysql -h \"127.0.0.1\" -uroot -psecretmysql \u003c /opt/monasca/sqls/winchester.sql || echo \"Did the schema change? This process will fail on schema changes.\""},{"line_number":765,"context_line":""},{"line_number":766,"context_line":"    sudo mkdir -p /opt/kafka/logs || true"},{"line_number":767,"context_line":""}],"source_content_type":"text/x-sh","patch_set":8,"id":"1ac06dbe_ba05c714","line":764,"range":{"start_line":764,"start_character":15,"end_line":764,"end_character":16},"updated":"2016-08-24 09:03:45.000000000","message":"If I understood correctly we don\u0027t have mysql installed so we cannot use mysql. Winchester looks like to use SQLAlchemy so should work with any SQL","commit_id":"a9e6f33fb0cd2bbf61a08d417605a549f30fee54"},{"author":{"_account_id":16168,"name":"Tomasz Trębski","email":"kornicameister@gmail.com","username":"trebskit"},"change_message_id":"c973f24112feb00b1bafc350ef5114ce425a50a1","unresolved":false,"context_lines":[{"line_number":761,"context_line":"    sudo chown root:root /opt/monasca/sqls/winchester.sql"},{"line_number":762,"context_line":""},{"line_number":763,"context_line":"    # must login as root@localhost"},{"line_number":764,"context_line":"    sudo mysql -h \"127.0.0.1\" -uroot -psecretmysql \u003c /opt/monasca/sqls/winchester.sql || echo \"Did the schema change? This process will fail on schema changes.\""},{"line_number":765,"context_line":""},{"line_number":766,"context_line":"    sudo mkdir -p /opt/kafka/logs || true"},{"line_number":767,"context_line":""}],"source_content_type":"text/x-sh","patch_set":8,"id":"1ac06dbe_15ec928e","line":764,"range":{"start_line":764,"start_character":15,"end_line":764,"end_character":16},"in_reply_to":"1ac06dbe_2b0b4b7e","updated":"2016-08-24 15:32:57.000000000","message":"As discussed during weekly meeting, winchester schema is not used anymore and can be safely removed as technical debt.","commit_id":"a9e6f33fb0cd2bbf61a08d417605a549f30fee54"},{"author":{"_account_id":16168,"name":"Tomasz Trębski","email":"kornicameister@gmail.com","username":"trebskit"},"change_message_id":"cd56146dd407571bbfad9b67abeb644dff316b39","unresolved":false,"context_lines":[{"line_number":761,"context_line":"    sudo chown root:root /opt/monasca/sqls/winchester.sql"},{"line_number":762,"context_line":""},{"line_number":763,"context_line":"    # must login as root@localhost"},{"line_number":764,"context_line":"    sudo mysql -h \"127.0.0.1\" -uroot -psecretmysql \u003c /opt/monasca/sqls/winchester.sql || echo \"Did the schema change? This process will fail on schema changes.\""},{"line_number":765,"context_line":""},{"line_number":766,"context_line":"    sudo mkdir -p /opt/kafka/logs || true"},{"line_number":767,"context_line":""}],"source_content_type":"text/x-sh","patch_set":8,"id":"1ac06dbe_2b0b4b7e","line":764,"range":{"start_line":764,"start_character":15,"end_line":764,"end_character":16},"in_reply_to":"1ac06dbe_ba05c714","updated":"2016-08-24 09:15:30.000000000","message":"That\u0027s actually a good question, but I am not even sure if that winchester (whatever that is) is used, I mean if the tables that are defined there are used anywhere.\n\nMaybe that\u0027s actually a point to put in agenda of the weekly meeting and see if that\u0027s available to be removed.","commit_id":"a9e6f33fb0cd2bbf61a08d417605a549f30fee54"},{"author":{"_account_id":14123,"name":"Stefano Canepa","email":"sc@linux.it","username":"sc"},"change_message_id":"82aa29a47e1c997cef40593b6013629ed476ce62","unresolved":false,"context_lines":[{"line_number":782,"context_line":""},{"line_number":783,"context_line":"    echo_summary \"Clean Monasca Schema\""},{"line_number":784,"context_line":""},{"line_number":785,"context_line":"    sudo echo \"drop database winchester;\" | mysql -uroot -ppassword"},{"line_number":786,"context_line":"    if [[ \"${MONASCA_DATABASE_BACKEND}\" \u003d\u003d \u0027mysql\u0027 ]]; then"},{"line_number":787,"context_line":"      sudo echo \"drop database mon;\" | mysql -uroot -ppassword"},{"line_number":788,"context_line":"    elif [[ \"${MONASCA_DATABASE_BACKEND}\" ]]; then"}],"source_content_type":"text/x-sh","patch_set":8,"id":"1ac06dbe_c5042816","line":785,"range":{"start_line":785,"start_character":4,"end_line":785,"end_character":8},"updated":"2016-08-24 09:03:45.000000000","message":"Same as before","commit_id":"a9e6f33fb0cd2bbf61a08d417605a549f30fee54"},{"author":{"_account_id":16168,"name":"Tomasz Trębski","email":"kornicameister@gmail.com","username":"trebskit"},"change_message_id":"9a0dd6d1f3f7e82de15212147ff1da9a40ba9f00","unresolved":false,"context_lines":[{"line_number":746,"context_line":"    sudo chown root:root /opt/monasca/sqls/mon.sql"},{"line_number":747,"context_line":""},{"line_number":748,"context_line":"    # must login as root@localhost"},{"line_number":749,"context_line":"    if [[ \"${MONASCA_DATABASE_BACKEND,,}\" \u003d\u003d \u0027mysql\u0027 ]]; then"},{"line_number":750,"context_line":"        sudo mysql -h \"127.0.0.1\" -uroot -psecretmysql \u003c /opt/monasca/sqls/mon.sql || echo \"Did the schema change? This process will fail on schema changes.\""},{"line_number":751,"context_line":"    elif [[ \"${MONASCA_DATABASE_BACKEND,,}\" \u003d\u003d \u0027postgresql\u0027 ]]; then"},{"line_number":752,"context_line":"        sudo -u postgres psql -c \"DROP DATABASE IF EXISTS mon;\""}],"source_content_type":"text/x-sh","patch_set":9,"id":"1ac06dbe_50860114","line":749,"updated":"2016-08-24 21:44:43.000000000","message":"That should actually use recreate_database function.","commit_id":"3049f726490b2b52a36082ca99513693b7a271e5"},{"author":{"_account_id":16168,"name":"Tomasz Trębski","email":"kornicameister@gmail.com","username":"trebskit"},"change_message_id":"3d2aa5f41a793df88839ae49f845aee21b66515e","unresolved":false,"context_lines":[{"line_number":1899,"context_line":"    cd grafana"},{"line_number":1900,"context_line":"    cp \"${MONASCA_BASE}\"/monasca-ui/grafana-dashboards/* ./public/dashboards/"},{"line_number":1901,"context_line":""},{"line_number":1902,"context_line":"    go run build.go setup"},{"line_number":1903,"context_line":"    $GOPATH/bin/godep go run build.go build"},{"line_number":1904,"context_line":""},{"line_number":1905,"context_line":"    set -i"},{"line_number":1906,"context_line":""}],"source_content_type":"text/x-sh","patch_set":36,"id":"fa6399be_149dd709","line":1903,"range":{"start_line":1902,"start_character":25,"end_line":1903,"end_character":43},"updated":"2016-10-14 10:50:34.000000000","message":"This line \u003d bad merge","commit_id":"7847058fa880be62a28034041a2406b49ca9583f"},{"author":{"_account_id":16168,"name":"Tomasz Trębski","email":"kornicameister@gmail.com","username":"trebskit"},"change_message_id":"07db9f7a68329bb4861cdab0a4d191ab0d643829","unresolved":false,"context_lines":[{"line_number":1899,"context_line":"    cd grafana"},{"line_number":1900,"context_line":"    cp \"${MONASCA_BASE}\"/monasca-ui/grafana-dashboards/* ./public/dashboards/"},{"line_number":1901,"context_line":""},{"line_number":1902,"context_line":"    go run build.go setup"},{"line_number":1903,"context_line":""},{"line_number":1904,"context_line":"    set -i"},{"line_number":1905,"context_line":""}],"source_content_type":"text/x-sh","patch_set":37,"id":"fa6399be_e01899d5","line":1902,"updated":"2016-10-14 12:25:48.000000000","message":"build","commit_id":"3e32f2e0556309fcc79108bb5a5eec9c0b289a65"},{"author":{"_account_id":20033,"name":"Artur Basiak","email":"artur.basiak@ts.fujitsu.com","username":"abasiak"},"change_message_id":"297567c5849c3ad9a10139cc1f6bc257a208ef4d","unresolved":false,"context_lines":[{"line_number":1796,"context_line":"    createuser $echoFlag -h $DATABASE_HOST -U$DATABASE_USER -c $MAX_DB_CONNECTIONS -E $user"},{"line_number":1797,"context_line":"    sudo -u root sudo -u postgres -i psql -c \"ALTER USER $user WITH PASSWORD \u0027$DATABASE_PASSWORD\u0027;\""},{"line_number":1798,"context_line":"    sudo -u root sudo -u postgres -i psql -c \"GRANT ALL PRIVILEGES ON DATABASE $db TO $user;\""},{"line_number":1799,"context_line":"    sudo -u root sudo -u postgres -i psql -c \"GRANT $dbPermissions ON ALL TABLES IN SCHEMA public TO $user;\""},{"line_number":1800,"context_line":"  done"},{"line_number":1801,"context_line":"}"},{"line_number":1802,"context_line":"# Allows this script to be called directly outside of"}],"source_content_type":"text/x-sh","patch_set":60,"id":"9a629dbe_45258908","line":1799,"range":{"start_line":1799,"start_character":0,"end_line":1799,"end_character":108},"updated":"2016-11-14 08:35:05.000000000","message":"You should use -d parameter (use database). Without it user monapi cannot use schema in database mon. It will throw an error.\n\nudo -u root sudo -u postgres -i psql -d $db -c \"GRANT $dbPermissions ON ALL TABLES IN SCHEMA public TO $user;\"","commit_id":"8b10530d01bce1fa216c48f7396cfcbd89eb7188"},{"author":{"_account_id":16168,"name":"Tomasz Trębski","email":"kornicameister@gmail.com","username":"trebskit"},"change_message_id":"004c7909daa1e48ec1e4c696eb8adca94ea84b9a","unresolved":false,"context_lines":[{"line_number":1796,"context_line":"    createuser $echoFlag -h $DATABASE_HOST -U$DATABASE_USER -c $MAX_DB_CONNECTIONS -E $user"},{"line_number":1797,"context_line":"    sudo -u root sudo -u postgres -i psql -c \"ALTER USER $user WITH PASSWORD \u0027$DATABASE_PASSWORD\u0027;\""},{"line_number":1798,"context_line":"    sudo -u root sudo -u postgres -i psql -c \"GRANT ALL PRIVILEGES ON DATABASE $db TO $user;\""},{"line_number":1799,"context_line":"    sudo -u root sudo -u postgres -i psql -c \"GRANT $dbPermissions ON ALL TABLES IN SCHEMA public TO $user;\""},{"line_number":1800,"context_line":"  done"},{"line_number":1801,"context_line":"}"},{"line_number":1802,"context_line":"# Allows this script to be called directly outside of"}],"source_content_type":"text/x-sh","patch_set":60,"id":"9a629dbe_ace48dac","line":1799,"range":{"start_line":1799,"start_character":0,"end_line":1799,"end_character":108},"in_reply_to":"9a629dbe_45258908","updated":"2016-11-14 09:28:02.000000000","message":"Done","commit_id":"8b10530d01bce1fa216c48f7396cfcbd89eb7188"},{"author":{"_account_id":21922,"name":"Dobroslaw Zybort","email":"dobroslaw.zybort@ts.fujitsu.com","username":"dobrolaw.zybort"},"change_message_id":"dff5ef55660fe8026e7b5cfc2b48671bc83d2dc0","unresolved":false,"context_lines":[{"line_number":51,"context_line":"# Set default persistent layer settings"},{"line_number":52,"context_line":"export MONASCA_METRICS_DB\u003d${MONASCA_METRICS_DB:-influxdb}"},{"line_number":53,"context_line":"# Make sure we use ORM mapping as default if postgresql is enabled"},{"line_number":54,"context_line":"if is_service_enabled mysql; then"},{"line_number":55,"context_line":"  MONASCA_DATABASE_USE_ORM\u003d${MONASCA_DATABASE_USE_ORM:-false}"},{"line_number":56,"context_line":"elif is_service_enabled postgresql; then"},{"line_number":57,"context_line":"  MONASCA_DATABASE_USE_ORM\u003dtrue"},{"line_number":58,"context_line":"fi"},{"line_number":59,"context_line":"MONASCA_DATABASE_USE_ORM\u003d$(trueorfalse False MONASCA_DATABASE_USE_ORM)"},{"line_number":60,"context_line":""},{"line_number":61,"context_line":"# Set INFLUXDB_VERSION"}],"source_content_type":"text/x-sh","patch_set":79,"id":"3a461143_0e228bb9","line":58,"range":{"start_line":54,"start_character":0,"end_line":58,"end_character":2},"updated":"2017-01-27 10:20:16.000000000","message":"Exit with fail if anything else found.","commit_id":"66d48e6f14f8f86e38d4ac55846f9e02e674d6b8"},{"author":{"_account_id":21922,"name":"Dobroslaw Zybort","email":"dobroslaw.zybort@ts.fujitsu.com","username":"dobrolaw.zybort"},"change_message_id":"dff5ef55660fe8026e7b5cfc2b48671bc83d2dc0","unresolved":false,"context_lines":[{"line_number":675,"context_line":"  sudo chown root:root $MONASCA_SCHEMA_DIR/mon.sql"},{"line_number":676,"context_line":""},{"line_number":677,"context_line":"  recreate_database $databaseName"},{"line_number":678,"context_line":"  if is_service_enabled mysql; then"},{"line_number":679,"context_line":"      sudo mysql -u$DATABASE_USER -p$DATABASE_PASSWORD -h$MYSQL_HOST \u003c $MONASCA_SCHEMA_DIR/mon.sql"},{"line_number":680,"context_line":"  elif is_service_enabled postgresql; then"},{"line_number":681,"context_line":"      sudo -u root sudo -u postgres -i psql -d $databaseName -f $MONASCA_SCHEMA_DIR/mon.sql"},{"line_number":682,"context_line":"  fi"},{"line_number":683,"context_line":""},{"line_number":684,"context_line":"  # for postgres, creating users must be after schema has been deployed"},{"line_number":685,"context_line":"  recreate_users $databaseName MON_DB_USERS MON_DB_HOSTS"}],"source_content_type":"text/x-sh","patch_set":79,"id":"3a461143_71d12e57","line":682,"range":{"start_line":678,"start_character":0,"end_line":682,"end_character":4},"updated":"2017-01-27 10:20:16.000000000","message":"Exit with fail if anything else found.","commit_id":"66d48e6f14f8f86e38d4ac55846f9e02e674d6b8"},{"author":{"_account_id":21922,"name":"Dobroslaw Zybort","email":"dobroslaw.zybort@ts.fujitsu.com","username":"dobrolaw.zybort"},"change_message_id":"dff5ef55660fe8026e7b5cfc2b48671bc83d2dc0","unresolved":false,"context_lines":[{"line_number":1012,"context_line":""},{"line_number":1013,"context_line":"    sudo userdel mon-api"},{"line_number":1014,"context_line":""},{"line_number":1015,"context_line":"    if is_service_enabled postgresql; then"},{"line_number":1016,"context_line":"      apt_get -y purge libpq-dev"},{"line_number":1017,"context_line":"    elif is_service_enabled mysql; then"},{"line_number":1018,"context_line":"      apt_get -y purge libpq-dev"},{"line_number":1019,"context_line":"      apt_get -y purge libmysqlclient-dev"},{"line_number":1020,"context_line":"    fi"},{"line_number":1021,"context_line":""},{"line_number":1022,"context_line":"}"},{"line_number":1023,"context_line":""}],"source_content_type":"text/x-sh","patch_set":79,"id":"3a461143_17c7fa45","line":1020,"range":{"start_line":1015,"start_character":0,"end_line":1020,"end_character":6},"updated":"2017-01-27 10:20:16.000000000","message":"Fail on anything else.","commit_id":"66d48e6f14f8f86e38d4ac55846f9e02e674d6b8"},{"author":{"_account_id":21922,"name":"Dobroslaw Zybort","email":"dobroslaw.zybort@ts.fujitsu.com","username":"dobrolaw.zybort"},"change_message_id":"dff5ef55660fe8026e7b5cfc2b48671bc83d2dc0","unresolved":false,"context_lines":[{"line_number":1254,"context_line":""},{"line_number":1255,"context_line":"    PIP_VIRTUAL_ENV\u003d/opt/monasca"},{"line_number":1256,"context_line":""},{"line_number":1257,"context_line":"    if is_service_enabled postgresql; then"},{"line_number":1258,"context_line":"      apt_get -y install libpq-dev"},{"line_number":1259,"context_line":"      pip_install psycopg2\u003d\u003d2.6.2"},{"line_number":1260,"context_line":"    elif is_service_enabled mysql; then"},{"line_number":1261,"context_line":"      apt_get -y install python-mysqldb"},{"line_number":1262,"context_line":"      apt_get -y install libmysqlclient-dev"},{"line_number":1263,"context_line":"      pip_install PyMySQL"},{"line_number":1264,"context_line":"      pip_install mysql-python"},{"line_number":1265,"context_line":"    fi"},{"line_number":1266,"context_line":"    if [[ ${MONASCA_DATABASE_USE_ORM} \u003d\u003d \"True\" ]]; then"},{"line_number":1267,"context_line":"      pip_install sqlalchemy"},{"line_number":1268,"context_line":"    fi"}],"source_content_type":"text/x-sh","patch_set":79,"id":"3a461143_77de7e12","line":1265,"range":{"start_line":1257,"start_character":0,"end_line":1265,"end_character":6},"updated":"2017-01-27 10:20:16.000000000","message":"Fail on anything else.","commit_id":"66d48e6f14f8f86e38d4ac55846f9e02e674d6b8"},{"author":{"_account_id":20033,"name":"Artur Basiak","email":"artur.basiak@ts.fujitsu.com","username":"abasiak"},"change_message_id":"f5d64b8f561e2712e6182a4b053da2c595754922","unresolved":false,"context_lines":[{"line_number":831,"context_line":"    sudo chown mon-api:root /etc/monasca/api-config.yml"},{"line_number":832,"context_line":"    sudo chmod 0640 /etc/monasca/api-config.yml"},{"line_number":833,"context_line":""},{"line_number":834,"context_line":"    sudo sed -e \""},{"line_number":835,"context_line":"      s|%KAFKA_HOST%|$SERVICE_HOST|g;"},{"line_number":836,"context_line":"      s|%MONASCA_DATABASE_USE_ORM%|$MONASCA_DATABASE_USE_ORM|g;"},{"line_number":837,"context_line":"      s|%MONASCA_API_DATABASE_ENGINE%|$dbEngine|g;"},{"line_number":838,"context_line":"      s|%MONASCA_API_DATABASE_USER%|$MONASCA_API_DATABASE_USER|g;"},{"line_number":839,"context_line":"      s|%DATABASE_HOST%|$DATABASE_HOST|g;"},{"line_number":840,"context_line":"      s|%DATABASE_PORT%|$dbPort|g;"},{"line_number":841,"context_line":"      s|%DATABASE_PASSWORD%|$DATABASE_PASSWORD|g;"},{"line_number":842,"context_line":"      s|%MONASCA_METRICS_DB%|$MONASCA_METRICS_DB|g;"},{"line_number":843,"context_line":"      s|%INFLUXDB_HOST%|$SERVICE_HOST|g;"},{"line_number":844,"context_line":"      s|%INFLUXDB_PORT%|8086|g;"},{"line_number":845,"context_line":"      s|%VERTICA_HOST%|$SERVICE_HOST|g;"},{"line_number":846,"context_line":"      s|%SERVICE_HOST%|$SERVICE_HOST|g;"},{"line_number":847,"context_line":"      s|%ADMIN_PASSWORD%|$ADMIN_PASSWORD|g;"},{"line_number":848,"context_line":"      s|%KEYSTONE_SERVICE_PORT%|$KEYSTONE_SERVICE_PORT|g;"},{"line_number":849,"context_line":"      s|%KEYSTONE_SERVICE_HOST%|$KEYSTONE_SERVICE_HOST|g;"},{"line_number":850,"context_line":"    \" -i /etc/monasca/api-config.yml"},{"line_number":851,"context_line":""},{"line_number":852,"context_line":"}"},{"line_number":853,"context_line":""}],"source_content_type":"text/x-sh","patch_set":82,"id":"1a430d35_194ef3c0","line":850,"range":{"start_line":834,"start_character":4,"end_line":850,"end_character":36},"updated":"2017-02-08 11:51:56.000000000","message":"sed also variables: MYSQL_HOST and MYSQL_PORT, after installing monasca-api java version config file looks like:\nhibernate:\n  supportEnabled: True\n  providerClass: com.zaxxer.hikari.hibernate.HikariConnectionProvider\n  dataSourceClassName: org.postgresql.ds.PGPoolingDataSource\n  dataSourceUrl: jdbc:mysql://%MYSQL_HOST%:%MYSQL_PORT%/mon","commit_id":"0bd46fd8b4d6c49cbac05b5006418fa9669d10e8"}],"devstack/settings":[{"author":{"_account_id":16168,"name":"Tomasz Trębski","email":"kornicameister@gmail.com","username":"trebskit"},"change_message_id":"bbc8f30420b48fde5ac272a0b773c82f9db9b5fd","unresolved":false,"context_lines":[{"line_number":1,"context_line":"#"},{"line_number":2,"context_line":"# (C) Copyright 2015 Hewlett Packard Enterprise Development Company LP"},{"line_number":3,"context_line":"# Copyright 2016 FUJITSU LIMITED"},{"line_number":4,"context_line":"#"},{"line_number":5,"context_line":"# Licensed under the Apache License, Version 2.0 (the \"License\");"}],"source_content_type":"application/octet-stream","patch_set":79,"id":"3a461143_2e310706","line":2,"updated":"2017-01-27 08:54:03.000000000","message":"Guess this company ought to be removed","commit_id":"66d48e6f14f8f86e38d4ac55846f9e02e674d6b8"},{"author":{"_account_id":16168,"name":"Tomasz Trębski","email":"kornicameister@gmail.com","username":"trebskit"},"change_message_id":"fa549255441a450206dfa09717dc2d81ac2d8664","unresolved":false,"context_lines":[{"line_number":1,"context_line":"#"},{"line_number":2,"context_line":"# (C) Copyright 2015 Hewlett Packard Enterprise Development Company LP"},{"line_number":3,"context_line":"# Copyright 2016 FUJITSU LIMITED"},{"line_number":4,"context_line":"#"},{"line_number":5,"context_line":"# Licensed under the Apache License, Version 2.0 (the \"License\");"}],"source_content_type":"application/octet-stream","patch_set":79,"id":"3a461143_aebdbeb8","line":2,"in_reply_to":"3a461143_2e310706","updated":"2017-01-30 05:16:50.000000000","message":"Done","commit_id":"66d48e6f14f8f86e38d4ac55846f9e02e674d6b8"},{"author":{"_account_id":16168,"name":"Tomasz Trębski","email":"kornicameister@gmail.com","username":"trebskit"},"change_message_id":"bbc8f30420b48fde5ac272a0b773c82f9db9b5fd","unresolved":false,"context_lines":[{"line_number":1,"context_line":"#"},{"line_number":2,"context_line":"# (C) Copyright 2015 Hewlett Packard Enterprise Development Company LP"},{"line_number":3,"context_line":"# Copyright 2016 FUJITSU LIMITED"},{"line_number":4,"context_line":"#"},{"line_number":5,"context_line":"# Licensed under the Apache License, Version 2.0 (the \"License\");"},{"line_number":6,"context_line":"# you may not use this file except in compliance with the License."}],"source_content_type":"application/octet-stream","patch_set":79,"id":"3a461143_6e194f88","line":3,"updated":"2017-01-27 08:54:03.000000000","message":"Bad year....although this change has been added last year ;-)","commit_id":"66d48e6f14f8f86e38d4ac55846f9e02e674d6b8"},{"author":{"_account_id":16168,"name":"Tomasz Trębski","email":"kornicameister@gmail.com","username":"trebskit"},"change_message_id":"fa549255441a450206dfa09717dc2d81ac2d8664","unresolved":false,"context_lines":[{"line_number":1,"context_line":"#"},{"line_number":2,"context_line":"# (C) Copyright 2015 Hewlett Packard Enterprise Development Company LP"},{"line_number":3,"context_line":"# Copyright 2016 FUJITSU LIMITED"},{"line_number":4,"context_line":"#"},{"line_number":5,"context_line":"# Licensed under the Apache License, Version 2.0 (the \"License\");"},{"line_number":6,"context_line":"# you may not use this file except in compliance with the License."}],"source_content_type":"application/octet-stream","patch_set":79,"id":"3a461143_ceae8a80","line":3,"in_reply_to":"3a461143_6e194f88","updated":"2017-01-30 05:16:50.000000000","message":"Done","commit_id":"66d48e6f14f8f86e38d4ac55846f9e02e674d6b8"}]}