[Openstack] MySQL server has gone away

2018-08-16 Thread Satish Patel
I have deployed openstack-ansible and somehow i am frequently seeing
following error, I have no packet loss in network and max_packet size
is also 16MB in mysql does any one know about this issue?

nova-placement-api.log

==> ostack-infra-03-nova-api-container-543a1e2a/nova-placement-api.log <==
Aug 17 00:18:48 ostack-infra-03-nova-api-container-543a1e2a
nova-placement-api: 2018-08-17 00:18:41.497 14880 ERROR
oslo_db.sqlalchemy.engines [req-bfc9f182-7b91-4de5-8b99-f353fda4487f
8ec61b0530b94a699c4dcf164115f365 328fc75d4f944a64ad1b8699c02350ca -
default default] Database connection was found disconnected;
reconnecting: DBConnectionError: (pymysql.err.OperationalError) (2006,
"MySQL server has gone away (error(104, 'Connection reset by peer'))")
[SQL: u'SELECT 1'] (Background on this error at:
http://sqlalche.me/e/e3q8)
Aug 17 00:18:48 ostack-infra-03-nova-api-container-543a1e2a
nova-placement-api: 2018-08-17 00:18:41.497 14880 ERROR
oslo_db.sqlalchemy.engines Traceback (most recent call last):
Aug 17 00:18:48 ostack-infra-03-nova-api-container-543a1e2a
nova-placement-api: 2018-08-17 00:18:41.497 14880 ERROR
oslo_db.sqlalchemy.engines   File
"/openstack/venvs/nova-17.0.8/lib/python2.7/site-packages/oslo_db/sqlalchemy/engines.py",
line 73, in _connect_ping_listener

___
Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
Post to : openstack@lists.openstack.org
Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack


Re: [Openstack] [OpenStack][Keystone][new_service]

2018-08-16 Thread Eric K
Hi Bruno!

What is the new service you're looking to develop?

I think the answer depends on your needs. Most openstack projects use
the oslo policy library as a PDP to protect API access [1]. On the
other hand, if you want dynamic rules and very fine-grained access
control, you may also consider Openstack Congress [2] which offers a
general and flexible rule framework.

Either way, here is how it typically works in an openstack service:
Policy rules are written and stored in the chosen policy framework.
For oslo policy, this is typically the json file containing policy
rules. In Congress, the policy store is managed by Congress service
and accessed via Congress API.
When an API is accessed, the service serving the API acts as the PEP.
It consults the PDP to see whether something is allowed, and enforces
that decision. For oslo policy, this is a library call [3]. For
Congress, this is an API call to Congress service to query the result
of rule evaluation [4][5].

For oslo policy, the main PAP is the json file containing the policy
rules. For congress, the policies and rules are managed through the
Congress API/GUI/client.

Hope that helps. Happy to talk further!

Eric
OpenStack Congress contributor

[1] 
https://docs.openstack.org/oslo.policy/latest/reference/api/oslo_policy.policy.html#
[2] https://docs.openstack.org/congress/latest/user/policy.html#
[3] 
https://docs.openstack.org/oslo.policy/latest/reference/api/oslo_policy.policy.html#generic-checks
[4] 
https://docs.openstack.org/congress/latest/user/api.html#policy-table-rows-v1-policies-policy-id-tables-table-id
[5] 
https://github.com/openstack/python-congressclient/blob/master/congressclient/v1/client.py#L113

On Wed, Aug 15, 2018 at 8:29 AM, B.M.Canning  wrote:
> Dear OpenStackers,
>
> Hello, I'm new to the list.
>
> I would like to know what support is available for creating a new
> OpenStack service that contains role-based access control components,
> such as a Policy Decision Point (PDP), inside the new service.
>
> I have come across oslo.policy in my research, is this what other OpenStack
> components use for their PEP, PDP, PAP and PIP? If so, what resources are
> available to help developers use this framework in their projects?
>
> Background:
> As part of my MSc degree in computer science, I am conducting a research
> project into the application of self-adaptation in authorisation
> infrastructures as a means of mitigation against insider threats towards
> cloud computing infrastructures. I'm using Keystone as a role-based
> access control system to protect access to a web-based game, and actions
> that a player can perform in the game, which represents computing
> resources, here snakes and ladders. Cheating in the game represents the
> malicious behaviour of an insider threat, to which the authorisation
> infrastructure responds by reducing/removing the user's privileges. The
> intention is to have the game represent an OpenStack service, like
> Swift. I am currently using the Queens release of Keystone and v3 of the
> API for both service-level and infrastructure-level policy decisions.
>
> Best wishes,
> Bruno Canning
>
> School of Computing, University of Kent
> ___
> Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
> Post to : openstack@lists.openstack.org
> Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack

___
Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
Post to : openstack@lists.openstack.org
Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack