cnf.test

User=root
LogFile=/tmp/db2dhcp.log
DBType=MySQL
DBServerAddress=localhost
DBServerPort=3306
DBUserName=zapadlo
DBUserPassword=zapadlo
DBName=db2
DBClientsCount=10
DHCPCacheTTL=0
Var = CLI-GIADDR        h:24:4
Var = CLI-ETHER-ADDR    h:28:6  # Ethernet address
Var = OPT82-PORT        o:82:(7=0x00)9:1|7:1
Var = OPT82-REMOTE-ID    o:82:12
#QueryDiscover=SELECT code, type, value FROM dhcp_subnets where (subnet = '$DEV-NETWORK-INT$' and CONV('$CLI-GIADDR$', 16, 10) = 0) or subnet = CONV('$CLI-GIADDR$', 16, 10) UNION SELECT code, type, value FROM dhcp_clients_by_relay WHERE relay_id = '$OPT82-REMOTE-ID$' AND relay_port = '$OPT82-PORT$' ORDER BY CODE
QueryDiscover=SELECT code, type, value FROM dhcp_subnets where segment_id in (SELECT segment_id FROM dhcp_clients_by_relay WHERE relay_id = '$OPT82-REMOTE-ID$' AND relay_port = '$OPT82-PORT$') UNION SELECT code, type, value FROM dhcp_clients_by_relay WHERE relay_id = '$OPT82-REMOTE-ID$' AND relay_port = '$OPT82-PORT$' ORDER BY CODE
#QueryRelease=Insert into history (remote_id,port) values ('$OPT82-REMOTE-ID$','$OPT82-PORT$')
#QueryDiscover=Insert into history (remote_id,port) values ('$OPT82-REMOTE-ID$','$OPT82-PORT$')
QueryHistory=CALL insert2history('$OPT82-REMOTE-ID$','$OPT82-PORT$','$CLI-ETHER-ADDR$');