{"action":"created","issue":{"url":"https://api.github.com/repos/JamborJan/paperwork/issues/13","labels_url":"https://api.github.com/repos/JamborJan/paperwork/issues/13/labels{/name}","comments_url":"https://api.github.com/repos/JamborJan/paperwork/issues/13/comments","events_url":"https://api.github.com/repos/JamborJan/paperwork/issues/13/events","html_url":"https://github.com/JamborJan/paperwork/issues/13","id":87692044,"number":13,"title":"Upgrading old grains to new app version","user":{"login":"JamborJan","id":7508960,"avatar_url":"https://avatars.githubusercontent.com/u/7508960?v=3","gravatar_id":"","url":"https://api.github.com/users/JamborJan","html_url":"https://github.com/JamborJan","followers_url":"https://api.github.com/users/JamborJan/followers","following_url":"https://api.github.com/users/JamborJan/following{/other_user}","gists_url":"https://api.github.com/users/JamborJan/gists{/gist_id}","starred_url":"https://api.github.com/users/JamborJan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JamborJan/subscriptions","organizations_url":"https://api.github.com/users/JamborJan/orgs","repos_url":"https://api.github.com/users/JamborJan/repos","events_url":"https://api.github.com/users/JamborJan/events{/privacy}","received_events_url":"https://api.github.com/users/JamborJan/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/JamborJan/paperwork/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":{"login":"JamborJan","id":7508960,"avatar_url":"https://avatars.githubusercontent.com/u/7508960?v=3","gravatar_id":"","url":"https://api.github.com/users/JamborJan","html_url":"https://github.com/JamborJan","followers_url":"https://api.github.com/users/JamborJan/followers","following_url":"https://api.github.com/users/JamborJan/following{/other_user}","gists_url":"https://api.github.com/users/JamborJan/gists{/gist_id}","starred_url":"https://api.github.com/users/JamborJan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JamborJan/subscriptions","organizations_url":"https://api.github.com/users/JamborJan/orgs","repos_url":"https://api.github.com/users/JamborJan/repos","events_url":"https://api.github.com/users/JamborJan/events{/privacy}","received_events_url":"https://api.github.com/users/JamborJan/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/JamborJan/paperwork/milestones/2","html_url":"https://github.com/JamborJan/paperwork/milestones/v5","labels_url":"https://api.github.com/repos/JamborJan/paperwork/milestones/2/labels","id":1061764,"number":2,"title":"v5","description":null,"creator":{"login":"JamborJan","id":7508960,"avatar_url":"https://avatars.githubusercontent.com/u/7508960?v=3","gravatar_id":"","url":"https://api.github.com/users/JamborJan","html_url":"https://github.com/JamborJan","followers_url":"https://api.github.com/users/JamborJan/followers","following_url":"https://api.github.com/users/JamborJan/following{/other_user}","gists_url":"https://api.github.com/users/JamborJan/gists{/gist_id}","starred_url":"https://api.github.com/users/JamborJan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JamborJan/subscriptions","organizations_url":"https://api.github.com/users/JamborJan/orgs","repos_url":"https://api.github.com/users/JamborJan/repos","events_url":"https://api.github.com/users/JamborJan/events{/privacy}","received_events_url":"https://api.github.com/users/JamborJan/received_events","type":"User","site_admin":false},"open_issues":2,"closed_issues":5,"state":"open","created_at":"2015-04-10T11:06:25Z","updated_at":"2015-07-20T16:41:53Z","due_on":null,"closed_at":null},"comments":2,"created_at":"2015-06-12T10:58:42Z","updated_at":"2015-07-20T16:56:33Z","closed_at":null,"body":"After having moved from the docker build process to ```vagrant-spk``` I can perfectly create new grains but cannot open existing ones which have been created with the older version of the app. \r\n\r\nIt's pretty obvious that the reason is the mysql setup. \r\n\r\nI have used the recommended setup back then like it was used here: https://github.com/jparyani/Lychee/blob/sandstorm/Dockerfile#L30-L33\r\n\r\nJust in case you see the reason of the issue @zarvox you might point me to it (I must really bother you these days .... :-) ). I will also continue to work on that but after having some other stuff accomplished first for the paperwork package.\r\n\r\nThis is the sandstorm log.\r\n\r\n```\r\n\r\n** SANDSTORM SUPERVISOR: Starting up grain.\r\nInstalling MySQL system tables...\r\n150612 10:53:03 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.\r\n150612 10:53:03 [Note] /usr/sbin/mysqld (mysqld 5.5.43-0ubuntu0.14.04.1) starting as process 37 ...\r\nOK\r\nFilling help tables...\r\n150612 10:53:03 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.\r\n150612 10:53:03 [Note] /usr/sbin/mysqld (mysqld 5.5.43-0ubuntu0.14.04.1) starting as process 43 ...\r\nOK\r\n\r\nTo start mysqld at boot time you have to copy\r\nsupport-files/mysql.server to the right place for your system\r\n\r\nPLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !\r\nTo do so, start the server, then issue the following commands:\r\n\r\n/usr/bin/mysqladmin -u root password 'new-password'\r\n/usr/bin/mysqladmin -u root -h sandbox password 'new-password'\r\n\r\nAlternatively you can run:\r\n/usr/bin/mysql_secure_installation\r\n\r\nwhich will also give you the option of removing the test\r\ndatabases and anonymous user created by default.  This is\r\nstrongly recommended for production servers.\r\n\r\nSee the manual for more instructions.\r\n\r\nYou can start the MySQL daemon with:\r\ncd /usr ; /usr/bin/mysqld_safe &\r\n\r\nYou can test the MySQL daemon with mysql-test-run.pl\r\ncd /usr/mysql-test ; perl mysql-test-run.pl\r\n\r\nPlease report any problems at http://bugs.mysql.com/\r\n\r\n/opt/app/.sandstorm/launcher.sh: line 31: /etc/mysql/conf.d/small.cnf: Read-only file system\r\nsed: can't read /etc/mysql/debian.cnf: Input/output error\r\nsed: couldn't open temporary file /etc/mysql/sedt6PN2I: Read-only file system\r\nNeither host 'sandbox' nor 'localhost' could be looked up with\r\n/usr/bin/resolveip\r\nPlease configure the 'hostname' command to return a correct\r\nhostname.\r\nIf you want to solve this at a later stage, restart this script\r\nwith the --force option\r\nchown: invalid spec: 'mysql:'\r\nwaiting for mysql to be available at /var/run/mysqld/mysqld.sock\r\n150612 10:53:04 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.\r\n150612 10:53:04 [Note] /usr/sbin/mysqld (mysqld 5.5.43-0ubuntu0.14.04.1) starting as process 68 ...\r\nwaiting for mysql to be available at /var/run/mysqld/mysqld.sock\r\nwaiting for mysql to be available at /var/run/mysqld/mysqld.sock\r\nwaiting for mysql to be available at /var/run/mysqld/mysqld.sock\r\nwaiting for mysql to be available at /var/run/mysqld/mysqld.sock\r\n[...] \r\n\r\n```"},"comment":{"url":"https://api.github.com/repos/JamborJan/paperwork/issues/comments/122949735","html_url":"https://github.com/JamborJan/paperwork/issues/13#issuecomment-122949735","issue_url":"https://api.github.com/repos/JamborJan/paperwork/issues/13","id":122949735,"user":{"login":"JamborJan","id":7508960,"avatar_url":"https://avatars.githubusercontent.com/u/7508960?v=3","gravatar_id":"","url":"https://api.github.com/users/JamborJan","html_url":"https://github.com/JamborJan","followers_url":"https://api.github.com/users/JamborJan/followers","following_url":"https://api.github.com/users/JamborJan/following{/other_user}","gists_url":"https://api.github.com/users/JamborJan/gists{/gist_id}","starred_url":"https://api.github.com/users/JamborJan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JamborJan/subscriptions","organizations_url":"https://api.github.com/users/JamborJan/orgs","repos_url":"https://api.github.com/users/JamborJan/repos","events_url":"https://api.github.com/users/JamborJan/events{/privacy}","received_events_url":"https://api.github.com/users/JamborJan/received_events","type":"User","site_admin":false},"created_at":"2015-07-20T16:56:33Z","updated_at":"2015-07-20T16:56:33Z","body":"Hi @zarvox,\r\n\r\nNow that I have finalized the new version of the paperwork app I come back to this issue.\r\n\r\nUnfortunately I cannot upgrade my old app which has been created from a Docker container with the new version which has been created with vagrant.spk.\r\n\r\nI used this Dockerfile to setup the system: https://github.com/JamborJan/paperwork/blob/4e0666e3705cc69cccf41e4c0b1fb70014b44c0d/Dockerfile\r\n\r\nNow I use ```vagrant-spk```. I guess it has something to do with the way how mysql was set up in the Docker-container but didn't find out so far what. If you have any idea or see where a cause might be from your experience, I would appreciate a hint where to look further to get the old grains updated.\r\n\r\nThanks!\r\nJJ"}}