Re: [openstack-dev] [Neutron] need help in translating sql query to sqlalchemy query

2015-12-02 Thread Sean M. Collins
Was perusing the documentation again this morning and there is another thing I found - you can call join() with the aliased=True flag to get similar results. Check out the "Constructing Aliases Anonymously" section. http://docs.sqlalchemy.org/en/latest/orm/query.html -- Sean M. Collins

Re: [openstack-dev] [Neutron] need help in translating sql query to sqlalchemy query

2015-12-01 Thread Venkata Anil
Thanks Sean. I will check that. Meanwhile I tried this and it is working port1 = orm.aliased(models_v2.Port, name="port1") port2 = orm.aliased(models_v2.Port, name="port2") router_intf_qry = context.session.query(RouterPort.router_id).join((port1,

Re: [openstack-dev] [Neutron] need help in translating sql query to sqlalchemy query

2015-12-01 Thread Sean M. Collins
On Tue, Dec 01, 2015 at 10:22:41AM EST, Venkata Anil wrote: > Thanks Sean. I will check that. > > Meanwhile I tried this and it is working > > port1 = orm.aliased(models_v2.Port, name="port1") > port2 = orm.aliased(models_v2.Port, name="port2") > router_intf_qry = >

Re: [openstack-dev] [Neutron] need help in translating sql query to sqlalchemy query

2015-12-01 Thread Venkata Anil
On 12/01/2015 09:06 PM, Sean M. Collins wrote: On Tue, Dec 01, 2015 at 10:22:41AM EST, Venkata Anil wrote: Thanks Sean. I will check that. Meanwhile I tried this and it is working port1 = orm.aliased(models_v2.Port, name="port1") port2 = orm.aliased(models_v2.Port,

[openstack-dev] [Neutron] need help in translating sql query to sqlalchemy query

2015-12-01 Thread Venkata Anil
Hi All I have the below sql query which - "lists routers connected to given internal and external networks" select DISTINCT routerports.router_id from routerports inner join ports as ports1 on (ports1.id=routerports.port_id and ports1.network_id=internal_network_id) inner join ports as

Re: [openstack-dev] [Neutron] need help in translating sql query to sqlalchemy query

2015-12-01 Thread Sean M. Collins
Consult the API: http://docs.sqlalchemy.org/en/latest/orm/query.html#sqlalchemy.orm.query.Query.join In fact, there is already one join happening a couple lines above your change: https://github.com/openstack/neutron/blob/stable/liberty/neutron/db/l3_db.py#L800 Most likely, you will also need

[openstack-dev] [neutron] Please help review this RFE

2015-09-17 Thread Li Ma
Hi Neutron folks, I'd like to introduce a pure python-driven network configuration library to Neutron. A discussion just started in the RFE ticket [1]. I'd like to get feedback on this proposal. [1]: https://bugs.launchpad.net/neutron/+bug/1492714 Take a look and let me know your thoughts. --

Re: [openstack-dev] [neutron][lbaas] Help on single create call

2015-07-30 Thread Brandon Logan
One of the features we were hoping to get into Liberty for neutron-lbaas v2 was a single create call. This call would be one that would accept an entire configuration tree of loadbalancer, listeners, pools, members, and health montiors in the API and create all of it (and also rolling back

[openstack-dev] [Neutron] AGAIN HELP CONFIRM OR DISCUSS:create a port when network contain ipv4 subnets and ipv6 subnets, allocate ipv6 address to the port.

2015-07-22 Thread zhaobo
Hi , Could anyone please check the bug below? I had received message from some kind people, but I didn't get the answer which i want. The key point is why the created port with specify ipv4 subnet as fixed-ip get an ipv6 addr when there are some ipv6 slaac/dhcpstateful subnets. And I know the

Re: [openstack-dev] [Neutron] AGAIN HELP CONFIRM OR DISCUSS:create a port when network contain ipv4 subnets and ipv6 subnets, allocate ipv6 address to the port.

2015-07-22 Thread Sridhar Gaddam
Hello ZhaoBo, The short summary of the BP [1] is that when a network contains an IPv6 SLAAC/dhcpv6-stateless subnet, we use RADVD daemon to advertise the prefix. RADVD deamon periodically advertises the prefix info which is a multicast message received by all the hosts/VMs on the network.

Re: [openstack-dev] [neutron] Need help getting DevStack setup working for VPN testing

2015-01-05 Thread Anita Kuno
On 01/02/2015 08:43 AM, Paul Michali (pcm) wrote: To summarize what I’m trying to do with option (A)… I want to test VPN in DevStack by setting up two private networks, two routers, and a shared public network. The VMs created in the private networks should be able to access the public

Re: [openstack-dev] [neutron] Need help getting DevStack setup working for VPN testing

2015-01-02 Thread Paul Michali (pcm)
To summarize what I’m trying to do with option (A)… I want to test VPN in DevStack by setting up two private networks, two routers, and a shared public network. The VMs created in the private networks should be able to access the public network, but not the other private network (e.g. VM on

[openstack-dev] [neutron] Need help getting DevStack setup working for VPN testing

2014-12-31 Thread Paul Michali (pcm)
I’ve been playing a bit with trying to get VPNaaS working post-repo split, and haven’t been successful. I’m trying it a few ways with DevStack, and I’m not sure whether I have a config error, setup issue, or there is something due to the split. In the past (and it’s been a few months since I

Re: [openstack-dev] [neutron] Need help getting DevStack setup working for VPN testing

2014-12-31 Thread Paul Michali (pcm)
Just more data… I keep consistently seeing that on private subnet, the VM can only access router (as expected), but on privateB subnet, the VM can access the private I/F of router1 on private subnet. From the router’s namespace, I cannot ping the local VM (why not?). Oddly, I can ping

Re: [openstack-dev] [Neutron] for help!

2014-09-30 Thread Fawad Khaliq
Hi Chengyong, I remember there is a blueprint[1] by Edgar Magana which talks about similar use cases but that still marked for discussion whether this belongs to Neutron or Heat. [1] https://blueprints.launchpad.net/neutron/+spec/network-topologies-api Fawad Khaliq On Tue, Sep 30, 2014 at 2:26

Re: [openstack-dev] [Neutron] for help!

2014-09-30 Thread Salvatore Orlando
On 30 September 2014 10:26, Linchengyong linchengy...@huawei.com wrote: Dear all, Could anyone help me? I have some questions to trouble . 1. Can the neutron create complex virtual network topology? Such as, any two routers' interconnection between each other. Only if you bridge

Re: [openstack-dev] [Neutron] Need help to start contribute to Neutron

2014-05-23 Thread Edgar Magana Perdomo (eperdomo)
: [openstack-dev] [Neutron] Need help to start contribute to Neutron Hello chen, You are already doing great, using irc and the mailing list is a good start. Let me give you some links that can help you ramping up: Neutron development: https://wiki.openstack.org/wiki/NeutronDevelopment If you wanna

[openstack-dev] [Neutron] Need help to start contribute to Neutron

2014-05-22 Thread Li, Chen
Hi list, I have using Openstack/Neutron for a while. And now I hope I can do some contributions too. But neutron is too complicated, I don't know where to start. In IRC, iwamoto suggested me to work with developer doc team. That sounds like a good idea. But I still doesn't know what/where I

Re: [openstack-dev] [Neutron] Need help to start contribute to Neutron

2014-05-22 Thread Rossella Sblendido
Hello chen, You are already doing great, using irc and the mailing list is a good start. Let me give you some links that can help you ramping up: Neutron development: https://wiki.openstack.org/wiki/NeutronDevelopment If you wanna contribute fixing some bug I suggest you have a look at the low

Re: [openstack-dev] [Neutron] Need help to start contribute to Neutron

2014-05-22 Thread Gary Kotton
(not for usage questions) openstack-dev@lists.openstack.orgmailto:openstack-dev@lists.openstack.org Date: Thursday, May 22, 2014 11:56 AM To: OpenStack Development Mailing List (not for usage questions) openstack-dev@lists.openstack.orgmailto:openstack-dev@lists.openstack.org Subject: [openstack-dev

Re: [openstack-dev] Neutron: Need help with tox failure in VPN code

2014-03-04 Thread Paul Michali
) From: Paul Michali p...@cisco.com To: OpenStack Development Mailing List (not for usage questions) openstack-dev@lists.openstack.org Sent: Tuesday, March 4, 2014 1:28:48 PM Subject: [openstack-dev] Neutron: Need help with tox failure in VPN code Hi, I'm stuck and can use some guidance here

Re: [openstack-dev] Neutron: Need help with tox failure in VPN code

2014-03-04 Thread Paul Michali
).setUp( vpnaas_plugin=VPN_DRIVER_CLASS) From: Paul Michali p...@cisco.com To: OpenStack Development Mailing List (not for usage questions) openstack-dev@lists.openstack.org Sent: Tuesday, March 4, 2014 1:28:48 PM Subject: [openstack-dev] Neutron: Need help with tox failure in VPN code

[openstack-dev] Neutron: Need help with tox failure in VPN code

2014-03-03 Thread Paul Michali
Hi, I'm stuck and can use some guidance here…please! I have a change set out for review that used the VPN Service Type Framework ( https://review.openstack.org/74144). Everything worked fine, passed Jenkins, etc. Found out that the STF won't make it to I-3, so I removed the dependency from

Re: [openstack-dev] Neutron: Need help with tox failure in VPN code

2014-03-03 Thread Nachi Ueno
./run_test.sh or ./run_test.sh -d package_name is working? 2014-03-03 21:28 GMT-08:00 Paul Michali p...@cisco.com: Hi, I'm stuck and can use some guidance here...please! I have a change set out for review that used the VPN Service Type Framework ( https://review.openstack.org/74144).

Re: [openstack-dev] Neutron: Need help with tox failure in VPN code

2014-03-03 Thread Irena Berezovsky
(not for usage questions) Subject: [openstack-dev] Neutron: Need help with tox failure in VPN code Hi, I'm stuck and can use some guidance here...please! I have a change set out for review that used the VPN Service Type Framework ( https://review.openstack.org/74144). Everything worked fine, passed

Re: [openstack-dev] Neutron: Need help with tox failure in VPN code

2014-03-03 Thread Bo Lin
( vpnaas_plugin=VPN_DRIVER_CLASS) - Original Message - From: Paul Michali p...@cisco.com To: OpenStack Development Mailing List (not for usage questions) openstack-dev@lists.openstack.org Sent: Tuesday, March 4, 2014 1:28:48 PM Subject: [openstack-dev] Neutron: Need help with tox