domr 7

mysql> select * from nics where instance_id='7'\G
*************************** 1. row ***************************
            id: 13
   instance_id: 7
   mac_address: 06:17:a8:00:00:45
   ip4_address: 207.178.148.38
       netmask: 255.255.255.0
       gateway: 207.178.148.1
       ip_type: Ip4
 broadcast_uri: vlan://500
    network_id: 200
          mode: Static
         state: Reserved
      strategy: Managed
 reserver_name: PublicNetworkGuru
reservation_id: NULL
     device_id: 2
   update_time: 2011-09-28 10:55:36
 isolation_uri: vlan://500
   ip6_address: NULL
   default_nic: 1
       vm_type: DomainRouter
       created: 2011-08-14 15:20:09
       removed: NULL
*************************** 2. row ***************************
            id: 14
   instance_id: 7
   mac_address: 02:00:15:dc:00:02
   ip4_address: 172.22.83.1
       netmask: 255.255.255.0
       gateway: NULL
       ip_type: Ip4
 broadcast_uri: vlan://927
    network_id: 205
          mode: Dhcp
         state: Reserved
      strategy: Start
 reserver_name: GuestNetworkGuru
reservation_id: 18f5cb7d-c5d8-4007-a52c-c3feb5a2aebf
     device_id: 0
   update_time: 2011-09-22 11:04:54
 isolation_uri: vlan://927
   ip6_address: NULL
   default_nic: 0
       vm_type: DomainRouter
       created: 2011-08-14 15:20:09
       removed: NULL
*************************** 3. row ***************************
            id: 15
   instance_id: 7
   mac_address: 0e:00:a9:fe:01:d4
   ip4_address: 169.254.1.212
       netmask: 255.255.0.0
       gateway: 169.254.0.1
       ip_type: Ip4
 broadcast_uri: NULL
    network_id: 202
          mode: Static
         state: Reserved
      strategy: Start
 reserver_name: ControlNetworkGuru
reservation_id: 18f5cb7d-c5d8-4007-a52c-c3feb5a2aebf
     device_id: 1
   update_time: 2011-09-22 11:04:54
 isolation_uri: NULL
   ip6_address: NULL
   default_nic: 0
       vm_type: DomainRouter
       created: 2011-08-14 15:20:09
       removed: NULL
3 rows in set (0.00 sec)

mysql> select * from networks where id='205'\G
*************************** 1. row ***************************
                       id: 205
                     name: Virtual Network
             display_text: A dedicated virtualized network for your account.  The broadcast domain is contained within a VLAN and all public network access is routed out by a virtual router.
             traffic_type: Guest
    broadcast_domain_type: Vlan
            broadcast_uri: vlan://927
                  gateway: 172.22.83.1
                     cidr: 172.22.83.0/24
                     mode: Dhcp
      network_offering_id: 6
           data_center_id: 1
                guru_name: GuestNetworkGuru
                    state: Implemented
                  related: 205
                domain_id: 2
               account_id: 3
                     dns1: 207.178.128.20
                     dns2: 207.178.128.21
                guru_data: NULL
               set_fields: 0
               guest_type: Virtual
                   shared: 0
       is_domain_specific: 0
           network_domain: cs3cloud.internal
           reservation_id: NULL
               is_default: 1
                  created: 2011-08-14 15:20:04
                  removed: NULL
is_security_group_enabled: 0
1 row in set (0.00 sec)