Re: Virtual Router doesn't start

2014-03-24 Thread Alena Prokharchyk
Kambiz, can you please try one more thing. 1) Locate all the firewall rules for your guest network (205, right?) Select id, ip_address_id from firewall_rules where network_id=205; 2) Now get all static nat enabled ip addresses for those rules: Select vm_id, network_id from user_ip_address

Re: Virtual Router doesn't start

2014-03-24 Thread Kambiz Darabi
Hi, I hope I have understood what you wrote and created the following query correctly: select uip.vm_id, uip.network_id, uip.public_ip_address, n.state as nic_state, n.removed as nic_removed, vm.state as vm_state, vm.removed as vm_removed from user_ip_address uip join nics n

Re: Virtual Router doesn't start

2014-03-24 Thread Alena Prokharchyk
Yes, Kambiz, you followed up right, and vm id=15 is the culprit. If vm id=15 is expunged, we have to clear out the reference to it from user_ip_address table. Here is the flow: 1) Save the db dump. 2) Run the query to cleanup the reference: Update user_ip_address set one_to_one_nat=0,

Re: Virtual Router doesn't start

2014-03-22 Thread Kambiz Darabi
Hi Alena, thank you for your help. The query returns no rows, i.e. nics.removed was not null, but I removed the row though to see what happens: a new virtual router was created which also couldn't be started due to the same NPE. I reverted the change by restoring from the dump. I have to

Virtual Router doesn't start

2014-03-21 Thread Kambiz Darabi
Hello, as this is my first post to the list, I would like to thank all contributors for Cloudstack which I use since last fall without any problems. I run 4.1.1 with KVM and advanced networking. After a restart of the management server (stopping and starting the java process), the virtual domain