{"action":"created","issue":{"url":"https://api.github.com/repos/cloudfoundry/cloud_controller_ng/issues/445","labels_url":"https://api.github.com/repos/cloudfoundry/cloud_controller_ng/issues/445/labels{/name}","comments_url":"https://api.github.com/repos/cloudfoundry/cloud_controller_ng/issues/445/comments","events_url":"https://api.github.com/repos/cloudfoundry/cloud_controller_ng/issues/445/events","html_url":"https://github.com/cloudfoundry/cloud_controller_ng/issues/445","id":110111560,"number":445,"title":"security_groups.rules column too small","user":{"login":"youngm","id":438661,"avatar_url":"https://avatars.githubusercontent.com/u/438661?v=3","gravatar_id":"","url":"https://api.github.com/users/youngm","html_url":"https://github.com/youngm","followers_url":"https://api.github.com/users/youngm/followers","following_url":"https://api.github.com/users/youngm/following{/other_user}","gists_url":"https://api.github.com/users/youngm/gists{/gist_id}","starred_url":"https://api.github.com/users/youngm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/youngm/subscriptions","organizations_url":"https://api.github.com/users/youngm/orgs","repos_url":"https://api.github.com/users/youngm/repos","events_url":"https://api.github.com/users/youngm/events{/privacy}","received_events_url":"https://api.github.com/users/youngm/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2015-10-06T22:06:09Z","updated_at":"2015-10-07T17:20:35Z","closed_at":null,"body":"We are trying to create a security group to cover all AWS subnets.  This creates a rule too large for a single security_group.  Thoughts in changing security_groups.rules from VARCHAR(2048) to mediumtext?  Would this change create a problem?\r\n\r\nWe can work around the issue by creating multiple security_groups but that is messy."},"comment":{"url":"https://api.github.com/repos/cloudfoundry/cloud_controller_ng/issues/comments/146267947","html_url":"https://github.com/cloudfoundry/cloud_controller_ng/issues/445#issuecomment-146267947","issue_url":"https://api.github.com/repos/cloudfoundry/cloud_controller_ng/issues/445","id":146267947,"user":{"login":"dieucao","id":1187097,"avatar_url":"https://avatars.githubusercontent.com/u/1187097?v=3","gravatar_id":"","url":"https://api.github.com/users/dieucao","html_url":"https://github.com/dieucao","followers_url":"https://api.github.com/users/dieucao/followers","following_url":"https://api.github.com/users/dieucao/following{/other_user}","gists_url":"https://api.github.com/users/dieucao/gists{/gist_id}","starred_url":"https://api.github.com/users/dieucao/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dieucao/subscriptions","organizations_url":"https://api.github.com/users/dieucao/orgs","repos_url":"https://api.github.com/users/dieucao/repos","events_url":"https://api.github.com/users/dieucao/events{/privacy}","received_events_url":"https://api.github.com/users/dieucao/received_events","type":"User","site_admin":false},"created_at":"2015-10-07T17:20:35Z","updated_at":"2015-10-07T17:20:35Z","body":"@youngm Thanks for the links.\r\nI think its okay to up the size of the column to mediumtext on mysql and the equivalent size on postgres.\r\nAs a side note, there's a separate configuration that controls the max body size that cloud controller will accept\r\n`cc.client_max_body_size` that currently defaults to 15M but could be adjusted if that's actually required.\r\n\r\nhttps://github.com/cloudfoundry/cf-release/blob/master/jobs/cloud_controller_ng/spec#L407-L408\r\n\r\nI'll update the other story and link to this issue."}}