{"action":"created","issue":{"url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/issues/502","labels_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/issues/502/labels{/name}","comments_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/issues/502/comments","events_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/issues/502/events","html_url":"https://github.com/aerogear/aerogear-unifiedpush-server/pull/502","id":58291728,"number":502,"title":"[RFC] UPS database migrator","user":{"login":"qmx","id":66734,"avatar_url":"https://avatars.githubusercontent.com/u/66734?v=3","gravatar_id":"","url":"https://api.github.com/users/qmx","html_url":"https://github.com/qmx","followers_url":"https://api.github.com/users/qmx/followers","following_url":"https://api.github.com/users/qmx/following{/other_user}","gists_url":"https://api.github.com/users/qmx/gists{/gist_id}","starred_url":"https://api.github.com/users/qmx/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/qmx/subscriptions","organizations_url":"https://api.github.com/users/qmx/orgs","repos_url":"https://api.github.com/users/qmx/repos","events_url":"https://api.github.com/users/qmx/events{/privacy}","received_events_url":"https://api.github.com/users/qmx/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":58,"created_at":"2015-02-20T00:11:01Z","updated_at":"2015-03-03T15:54:25Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/pulls/502","html_url":"https://github.com/aerogear/aerogear-unifiedpush-server/pull/502","diff_url":"https://github.com/aerogear/aerogear-unifiedpush-server/pull/502.diff","patch_url":"https://github.com/aerogear/aerogear-unifiedpush-server/pull/502.patch"},"body":"This needs documentation fixes which should follow tomorrow, but I'd love to\r\nhave as earlier feedback as possible\r\n\r\nsteps to run:\r\n\r\n```\r\ncd $UPS_ROOT/migrator\r\nmvn clean package\r\n```\r\n\r\nYou should see a file named `unifiedpush-migrator-1.0.3-SNAPSHOT.zip` inside the target\r\nfolder.\r\n\r\nunzip it, it should give this structure:\r\n\r\n```\r\nunifiedpush-migrator-1.0.3-SNAPSHOT/\r\nunifiedpush-migrator-1.0.3-SNAPSHOT/ups-migrator.jar\r\nunifiedpush-migrator-1.0.3-SNAPSHOT/bin/\r\nunifiedpush-migrator-1.0.3-SNAPSHOT/bin/ups-migrator\r\nunifiedpush-migrator-1.0.3-SNAPSHOT/lib/\r\nunifiedpush-migrator-1.0.3-SNAPSHOT/lib/liquibase-core-3.3.2.jar\r\nunifiedpush-migrator-1.0.3-SNAPSHOT/lib/mysql-connector-java-5.1.18.jar\r\nunifiedpush-migrator-1.0.3-SNAPSHOT/lib/postgresql-9.2-1004-jdbc41.jar\r\nunifiedpush-migrator-1.0.3-SNAPSHOT/lib/base64-2.3.8.jar\r\nunifiedpush-migrator-1.0.3-SNAPSHOT/liquibase-mysql-example.properties\r\nunifiedpush-migrator-1.0.3-SNAPSHOT/liquibase-postgresql-example.properties\r\n```\r\n\r\ncd into the folder, copy the example file for your preferred database flavor:\r\n\r\n`cp liquibase-postgresql-example.properties liquibase.properties`\r\n\r\nedit this file with your database credentials then run:\r\n\r\n`bin/ups-migrator update`\r\n\r\nit should bring your database to the current schema + populate the\r\n`ups_db_changelog` table with the current db migration changelog.\r\n\r\nFrom @danielpassos - Step by step for testing https://gist.github.com/danielpassos/231a372eaefbd6156792"},"comment":{"url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/issues/comments/76972115","html_url":"https://github.com/aerogear/aerogear-unifiedpush-server/pull/502#issuecomment-76972115","issue_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/issues/502","id":76972115,"user":{"login":"matzew","id":157646,"avatar_url":"https://avatars.githubusercontent.com/u/157646?v=3","gravatar_id":"","url":"https://api.github.com/users/matzew","html_url":"https://github.com/matzew","followers_url":"https://api.github.com/users/matzew/followers","following_url":"https://api.github.com/users/matzew/following{/other_user}","gists_url":"https://api.github.com/users/matzew/gists{/gist_id}","starred_url":"https://api.github.com/users/matzew/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/matzew/subscriptions","organizations_url":"https://api.github.com/users/matzew/orgs","repos_url":"https://api.github.com/users/matzew/repos","events_url":"https://api.github.com/users/matzew/events{/privacy}","received_events_url":"https://api.github.com/users/matzew/received_events","type":"User","site_admin":false},"created_at":"2015-03-03T15:54:24Z","updated_at":"2015-03-03T15:54:24Z","body":"@qmx I am getting:\r\n```\r\nUnexpected error running Liquibase: org.postgresql.util.PSQLException: ERROR: relation \"public.Installation\" does not exist \r\n```"}}