Page 1 of 1

Missing DHCP lease comment in API response in 3.27 (bug?)

Posted: Wed Jul 22, 2009 11:45 pm
by astounding
I have a script for synchronizing static DHCP configurations on Mikrotik APs with an internal database that uses the API /ip/dhcp-server/lease/getall to check the AP's current DHCP state.

When running version 3.23, the comment field (in which I store a human-readable account ID so I know to whom the lease belongs when I'm logged into the AP via telnet/ssh/winbox) the API returns things just fine:
1	"!re"	=	null
2	".id"	=	"*1"
3	"comment"	=	"Joe User Account 4567"
4	"address"	=	"10.0.0.55"
5	"mac-address"	=	"DE:AD:BE:EF:00:11"
6	"status"	=	"bound"
7	"expires-after"	=	"00:41:30"
8	"active-address"	=	"10.0.0.55"
9	"active-mac-address"	=	"DE:AD:BE:EF:00:11"
10	"active-client-id"	=	"1:DE:AD:BE:EF:00:11"
11	"active-server"	=	"dhcp-server"
12	"host-name"	=	"MyMikroTikAP"
13	"disabled"	=	"false"
14	"radius"	=	"false"
15	"dynamic"	=	"false"
16	"blocked"	=	"false"

1	"!done"	=	null
However when I perform the same query on an AP running version 3.27, "getall" does NOT return the comment field, even when properly set:
1	"!re"	=	null
2	".id"	=	"*1"
3	"address"	=	"10.1.0.33"
4	"mac-address"	=	"FE:ED:BE:AD:51:73"
5	"disabled"	=	"false"
6	"radius"	=	"false"
7	"dynamic"	=	"false"
8	"blocked"	=	"false"

1	"!done"	=	null
Is this a bug in 3.27? It doesn't matter whether or not the lease is bound/active or not, the result is the same, in 3.27 the comment field is missing.

Wondering,
Aaron out

Re: Missing DHCP lease comment in API response in 3.27 (bug?)

Posted: Thu Jul 23, 2009 12:20 am
by astounding
Also note that including "comment" in .proplist and doing the getall query still fails to include the comment field in the output.

Re: Missing DHCP lease comment in API response in 3.27 (bug?)

Posted: Thu Jul 23, 2009 12:24 am
by astounding
Fortunately filtering DOES appear to work based on the comment. For example:
/ip/dhcp-server/getall
?comment="Jane Doe account 12345"
The above API query would in fact return the correct record, but again, the comment field would be missing.

Re: Missing DHCP lease comment in API response in 3.27 (bug?)

Posted: Thu Jul 23, 2009 2:09 pm
by janisk
comments will appear in next release

Re: Missing DHCP lease comment in API response in 3.27 (bug?)

Posted: Mon Aug 17, 2009 8:14 pm
by astounding
Thank you very much! 3.28 fixes the problem for /ip/dhcp-server/lease/getall (and print) and also for /interface/wireless/access-list/getall (and print).