[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