[Kea-users] Vendor Specific Option in mysql table

[Andre Roberge]

Hi, 

 I'mtrying to get vendor specific options to work with MySQL tables. I can pushdhcp4 space option with the tables but I can't get the vendor-encapsulated-options-space to work. We need to push vendor specificoptions for the AMINO IPTV device through the tables. 

 My issueis that my option 43 is always empty has you can see on the tcpdump.

 Here ismy tcpdump of the bootreply.

  TIME: 08:31:12.228704

   IP: > (6a:6d:fc:31:bd:dc) >  (64:9e:f3:ba:26:54)

   OP: 2 (BOOTPREPLY)

HTYPE: 1(Ethernet)

 HLEN: 6

 HOPS: 1

  XID: 1102d51a

 SECS: 0

FLAGS: 0

CIADDR:0.0.0.0

YIADDR:10.243.253.254

SIADDR:10.243.253.1

GIADDR:10.243.253.1

CHADDR:00:02:02:39:ec:e3:00:00:00:00:00:00:00:00:00:00

SNAME:225.10.10.11.

FNAME:bootfile.efi.

OPTION:  1 (  4) Subnetmask                                                 255.255.255.0

OPTION:  2 (  4) Timeoffset                                                    -18000 ()

OPTION:  6 (  8) DNSserver                                                    192.0.2.1,192.0.2.2

OPTION: 12 ( 18) Hostname                                                  39ece3.sogetel.net

OPTION: 42 (  4) NTPservers                                                 69.51.194.2

OPTION: 43 (  0) Vendor specificinfo                      

OPTION: 51 (  4) IP address leasetime                                4000 (1h6m40s)

OPTION:  53 (  1) DHCP messagetype                                 5 (DHCPACK)

OPTION:  54 (  4) Serveridentifier                                         205.236.148.125

OPTION:  61 (  7)Client-identifier                                          01:00:02:02:39:ec:e3

OPTION: 82 ( 14) Relay AgentInformation                        Remote-ID    02:0a:00:00:0a:f3:fd:01:fd:fb:00:00

---------------------------------------------------------------------------

  Here ismy option-def :

 "option-def":[

               {

                              "name": "timezone",

                              "code": 16,

                              "type": "string",

                              "array": false,

                              "record-types": "",

                              "space": "vendor-encapsulated-options-space",

                              "encapsulate": ""

               },

               {

                              "name": "software_uri",

                              "code": 28,

                              "type": "string",

                              "array": false,

                              "record-types": "",

                              "space": "vendor-encapsulated-options-space",

                              "encapsulate": ""

               }

],

 And hereis the content of both tables (host and dhcp4_options) from a MySQL request

 SELECTh.host_id, h.dhcp_identifier, h.dhcp_identifier_type, 

    h.dhcp4_subnet_id,h.dhcp6_subnet_id, h.ipv4_address, h.hostname, 

    h.dhcp4_client_classes,h.dhcp6_client_classes, 

    h.dhcp4_next_server, h.dhcp4_server_hostname,h.dhcp4_boot_file_name,

   o.option_id, o.code, o.value, o.formatted_value, o.space, 

    o.persistent

FROMkea.hosts AS h

LEFTJOIN kea.dhcp4_options AS o 

    ONh.host_id = o.host_id

WHEREh.dhcp4_subnet_id = 183762176 AND h.ipv4_address = 183762430 ORDER BYh.host_id, o.option_id

 host_id               dhcp_identifier               dhcp_identifier_type    dhcp4_subnet_id          dhcp6_subnet_id          ipv4_address               hostname          dhcp4_client_classes    dhcp6_client_classes   dhcp4_next_server      dhcp4_server_hostname               dhcp4_boot_file_name              option_id           code      value    formatted_value           space    persistent

9            ...           0            183762176         NULL    183762430         39ece3.sogetel.net       NULL     NULL     183762177               225.10.10.11     bootfile.efi        39          43                          NULL     dhcp4   0

9            ...           0            183762176         NULL    183762430         39ece3.sogetel.net       NULL     NULL     183762177               225.10.10.11     bootfile.efi        40          42           ...           NULL     dhcp4   0

9            ...           0            183762176         NULL    183762430         39ece3.sogetel.net       NULL     NULL     183762177               225.10.10.11     bootfile.efi        41          2            ...           NULL     dhcp4   0

9            ...           0            183762176         NULL    183762430         39ece3.sogetel.net       NULL     NULL     183762177               225.10.10.11     bootfile.efi        42          28          ...           NULL    vendor-encapsulated-options-space    0

9            ...           0            183762176         NULL    183762430         39ece3.sogetel.net       NULL     NULL     183762177               225.10.10.11      bootfile.efi        43          16          ...           NULL    vendor-encapsulated-options-space    0

 Any hinton what I'm doing wrong would be greatly appreciated. 

 André Roberge

 
robergeandre at yahoo.com


 


 

 

 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20170120/faae96c3/attachment.htm>