{"action":"created","issue":{"url":"https://api.github.com/repos/sciserver/SkyServer/issues/123","repository_url":"https://api.github.com/repos/sciserver/SkyServer","labels_url":"https://api.github.com/repos/sciserver/SkyServer/issues/123/labels{/name}","comments_url":"https://api.github.com/repos/sciserver/SkyServer/issues/123/comments","events_url":"https://api.github.com/repos/sciserver/SkyServer/issues/123/events","html_url":"https://github.com/sciserver/SkyServer/issues/123","id":107074131,"number":123,"title":"ClientIP column size is not big enough to store IPv6 addresses","user":{"login":"mtaghiza","id":12413605,"avatar_url":"https://avatars.githubusercontent.com/u/12413605?v=3","gravatar_id":"","url":"https://api.github.com/users/mtaghiza","html_url":"https://github.com/mtaghiza","followers_url":"https://api.github.com/users/mtaghiza/followers","following_url":"https://api.github.com/users/mtaghiza/following{/other_user}","gists_url":"https://api.github.com/users/mtaghiza/gists{/gist_id}","starred_url":"https://api.github.com/users/mtaghiza/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mtaghiza/subscriptions","organizations_url":"https://api.github.com/users/mtaghiza/orgs","repos_url":"https://api.github.com/users/mtaghiza/repos","events_url":"https://api.github.com/users/mtaghiza/events{/privacy}","received_events_url":"https://api.github.com/users/mtaghiza/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-09-17T21:05:22Z","updated_at":"2016-02-23T18:09:18Z","closed_at":null,"body":"Right now the column is defined as varchar(16). The new IPv6 will have about   \r\n8 groups of 4 digits with 7 ':' between them (39 characters) or even \r\n45 characters in the case of [0000:0000:0000:0000:0000:0000:192.168.0.1] , which can be rounded to 48. \r\n\r\nWe will have to change accordingly the sqExecuteSQL stores procedure, weblog tables and harvester.\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/sciserver/SkyServer/issues/comments/187822012","html_url":"https://github.com/sciserver/SkyServer/issues/123#issuecomment-187822012","issue_url":"https://api.github.com/repos/sciserver/SkyServer/issues/123","id":187822012,"user":{"login":"mtaghiza","id":12413605,"avatar_url":"https://avatars.githubusercontent.com/u/12413605?v=3","gravatar_id":"","url":"https://api.github.com/users/mtaghiza","html_url":"https://github.com/mtaghiza","followers_url":"https://api.github.com/users/mtaghiza/followers","following_url":"https://api.github.com/users/mtaghiza/following{/other_user}","gists_url":"https://api.github.com/users/mtaghiza/gists{/gist_id}","starred_url":"https://api.github.com/users/mtaghiza/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mtaghiza/subscriptions","organizations_url":"https://api.github.com/users/mtaghiza/orgs","repos_url":"https://api.github.com/users/mtaghiza/repos","events_url":"https://api.github.com/users/mtaghiza/events{/privacy}","received_events_url":"https://api.github.com/users/mtaghiza/received_events","type":"User","site_admin":false},"created_at":"2016-02-23T18:09:18Z","updated_at":"2016-02-23T18:09:18Z","body":"Fixed. The messages table in sciserverlog database now allows an IP of 50 characters."}}