[Kea-users] Problem on query ISC KEA PgSQL by client_id
BALL SUN
paulrbk at gmail.com
Fri Jan 3 03:37:26 UTC 2020
Hi
I have an installation on using KEA 1.6 with PgSQL and I have issue on
retrieving record by client_id. anyone can help?
below is the entry that I had.
address | hwaddr | client_id
| valid_lifetime | expire | subnet_id |
fqdn_fwd | fqdn_rev | hostname | state | user_context
------------+----------------+------------------------------------------------+----------------+------------------------+-----------+----------+----------+----------+-------+--------------
3227711669 | \x115131110400 |
\x003836303031383735303030303030315f61706e31 | 864000 |
2020-01-12 07:51:02+00 | 1 | f | f | |
0 |
(1 row)
I tired to issue below select statement, but nothing can find.
dhcp=# select * from lease4 where client_id like
'%3836303031383735303030303030315f61706e31';
address | hwaddr | client_id | valid_lifetime | expire | subnet_id |
fqdn_fwd | fqdn_rev | hostname | state | user_context
---------+--------+-----------+----------------+--------+-----------+----------+----------+----------+-------+--------------
(0 rows)
More information about the Kea-users
mailing list