[Kea-users] 1.3.0 beta not working with mysql
Bill Pye
bill.pye at phoenix-systems.co.uk
Tue Oct 10 10:32:17 UTC 2017
Hi Rasmus & Thomas
I think we can put this problem down to user error although I really don't know what's caused it. I have a centos7 dedicated to just building software, I used that to build kea and although it built with apparently no errors and I couldn't see anything in the log file it would never run against a clean install of percona or mariadb no matter which version I used.
Eventually I came to the conclusion that there was a problem with my build environment so I installed mock and built kea again in that environment- it built fine and after install it worked against all the versions of percona & mariadb that I had installed.
I've done a few limited tests against Mariadb 10.2.29, 5.5.56 and my Percona Cluster - all without problems and creating correct records in the lease table.
I also use Proxysql for HA against my percona cluster and the only problem with kea is trying to use the proxsql instance but that's only a minor inconvenience for now.
I'd like to thank everyone that's helped me with spec files, srpms and your advice and details of kea config and installs. :)
Regards
Bill
----- Original Message -----
> From: "Rasmus Edgar" <regj at arch-ed.dk>
> To: "bill pye" <bill.pye at phoenix-systems.co.uk>
> Cc: "kea-users" <kea-users at lists.isc.org>
> Sent: Monday, 9 October, 2017 20:54:47
> Subject: Re: [Kea-users] 1.3.0 beta not working with mysql
> Hi,
>
> I just tested kea-1.3.0-beta kea-dhcp4 with my supplied srpm on CentOS
> 7.4 running mariadb 5.5.56 on the same host and using it as lease
> storage for dhcp4.
>
> It works.
>
> [root at rpmbuild-1 ~]# tail /var/log/kea-dhcp4.log
> 2017-10-09 20:19:00.802 INFO [kea-dhcp4.dhcp4/3870] DHCP4_STARTED Kea
> DHCPv4 server version 1.3.0-beta started
> 2017-10-09 20:19:27.429 INFO [kea-dhcp4.dhcp4/3870] DHCP4_SHUTDOWN
> server shutdown
> 2017-10-09 20:33:20.052 INFO [kea-dhcp4.dhcp4/1834] DHCP4_STARTED Kea
> DHCPv4 server version 1.3.0-beta started
> 2017-10-09 20:33:21.483 INFO [kea-dhcp4.leases/1834] DHCP4_LEASE_ADVERT
> [hwtype=1 08:00:27:f6:62:cb],
> cid=[ff:27:f6:62:cb:00:01:00:01:21:6e:7a:ad:08:00:27:f6:62:cb],
> tid=0xb90df951: lease 192.0.2.3 will be advertised
> 2017-10-09 20:33:21.490 INFO [kea-dhcp4.leases/1834] DHCP4_LEASE_ALLOC
> [hwtype=1 08:00:27:f6:62:cb],
> cid=[ff:27:f6:62:cb:00:01:00:01:21:6e:7a:ad:08:00:27:f6:62:cb],
> tid=0xb90df951: lease 192.0.2.3 has been allocated
> 2017-10-09 20:33:59.078 INFO [kea-dhcp4.leases/1834] DHCP4_LEASE_ADVERT
> [hwtype=1 08:00:27:f6:62:cb],
> cid=[ff:27:f6:62:cb:00:01:00:01:1e:59:e5:3c:08:00:27:f6:62:cb],
> tid=0xc09f4c43: lease 192.0.2.4 will be advertised
> 2017-10-09 20:33:59.080 INFO [kea-dhcp4.leases/1834] DHCP4_LEASE_ALLOC
> [hwtype=1 08:00:27:f6:62:cb],
> cid=[ff:27:f6:62:cb:00:01:00:01:1e:59:e5:3c:08:00:27:f6:62:cb],
> tid=0xc09f4c43: lease 192.0.2.4 has been allocated
> 2017-10-09 20:43:20.372 INFO [kea-dhcp4.dhcp4/1834] DHCP4_SHUTDOWN
> server shutdown
>
> MariaDB [kea_leases]> select * from lease4;
> +------------+--------+---------------------+----------------+---------------------+-----------+----------+----------+----------+-------+
>| address | hwaddr | client_id | valid_lifetime | expire
> | subnet_id | fqdn_fwd | fqdn_rev | hostname | state |
> +------------+--------+---------------------+----------------+---------------------+-----------+----------+----------+----------+-------+
>| 3221225987 | 'öbË | ÿ'öbË !n 'öbË | 3600 |
> 2017-10-09 21:33:21 | 1 | 0 | 0 | | 0
>|
>| 3221225988 | 'öbË | ÿ'öbË Yå 'öbË | 3600 |
> 2017-10-09 21:33:59 | 1 | 0 | 0 | | 0
>|
> +------------+--------+---------------------+----------------+---------------------+-----------+----------+----------+----------+-------+
> 2 rows in set (0.00 sec)
>
> When creating the database tables I followed the guide here:
> http://kea.isc.org/docs/kea-guide.html#idp52513808
>
> The kea.conf (which is the standard one adjusted and no comments) is
> pasted below:
> {
>
> "Dhcp4": {
> "interfaces-config": {
> "interfaces": [ "enp0s8" ]
>
> },
>
> "control-socket": {
> "socket-type": "unix",
> "socket-name": "/tmp/kea-dhcp4-ctrl.sock"
> },
>
> "lease-database": {
> "type": "mysql",
> "user": "kea_user",
> "password": "gaffel",
> "name": "kea_leases"
> },
>
>
> "expired-leases-processing": {
> "reclaim-timer-wait-time": 10,
> "flush-reclaimed-timer-wait-time": 25,
> "hold-reclaimed-time": 3600,
> "max-reclaim-leases": 100,
> "max-reclaim-time": 250,
> "unwarned-reclaim-cycles": 5
> },
>
> "renew-timer": 900,
> "rebind-timer": 1800,
> "valid-lifetime": 3600,
>
>
> "option-data": [
> {
> "name": "domain-name-servers",
> "data": "192.0.2.1, 192.0.2.2"
> },
>
> {
> "code": 15,
> "data": "example.org"
> },
>
> {
> "name": "domain-search",
> "data": "mydomain.example.com, example.com"
> },
>
>
> {
> "name": "boot-file-name",
> "data": "EST5EDT4\\,M3.2.0/02:00\\,M11.1.0/02:00"
> },
>
> {
> "name": "default-ip-ttl",
> "data": "0xf0"
> }
>
> ],
>
>
> "client-classes": [
> {
> "name": "voip",
>
> "test": "substring(option[60].hex,0,6) == 'Aastra'",
>
> "next-server": "192.0.2.254",
> "server-hostname": "hal9000",
> "boot-file-name": "/dev/null"
>
> }
> ],
>
>
> "subnet4": [
> {
> "subnet": "192.0.2.0/24",
>
> "pools": [ { "pool": "192.0.2.3 - 192.0.2.200" } ],
>
> "option-data": [
> {
> "name": "routers",
> "data": "192.0.2.1"
> }
> ],
>
> "reservations": [
>
> {
> "hw-address": "1a:1b:1c:1d:1e:1f",
> "ip-address": "192.0.2.201"
> },
>
> {
> "client-id": "01:11:22:33:44:55:66",
> "ip-address": "192.0.2.202",
> "hostname": "special-snowflake"
> },
>
> {
> "duid": "01:02:03:04:05",
> "ip-address": "192.0.2.203",
> "option-data": [ {
> "name": "domain-name-servers",
> "data": "10.1.1.202, 10.1.1.203"
> } ]
> },
>
> {
> "client-id": "01:12:23:34:45:56:67",
> "ip-address": "192.0.2.204",
> "option-data": [
> {
> "name": "vivso-suboptions",
> "data": "4491"
> },
> {
> "name": "tftp-servers",
> "space": "vendor-4491",
> "data": "10.1.1.202, 10.1.1.203"
> }
> ]
> },
> {
> "client-id": "01:0a:0b:0c:0d:0e:0f",
> "ip-address": "192.0.2.205",
> "next-server": "192.0.2.1",
> "server-hostname": "hal9000",
> "boot-file-name": "/dev/null"
> },
> {
> "flex-id": "'s0mEVaLue'",
> "ip-address": "192.0.2.206"
> }
> ]
> }
> ]
>
> },
>
> "Dhcp6": {
> "interfaces-config": {
> "interfaces": [ ]
> },
>
> "control-socket": {
> "socket-type": "unix",
> "socket-name": "/tmp/kea-dhcp6-ctrl.sock"
> },
>
> "lease-database": {
> "type": "memfile"
> },
>
>
> "expired-leases-processing": {
> "reclaim-timer-wait-time": 10,
> "flush-reclaimed-timer-wait-time": 25,
> "hold-reclaimed-time": 3600,
> "max-reclaim-leases": 100,
> "max-reclaim-time": 250,
> "unwarned-reclaim-cycles": 5
> },
>
> "renew-timer": 1000,
> "rebind-timer": 2000,
> "preferred-lifetime": 3000,
> "valid-lifetime": 4000,
>
> "option-data": [
> {
> "name": "dns-servers",
> "data": "2001:db8:2::45, 2001:db8:2::100"
> },
>
> {
> "code": 12,
> "data": "2001:db8::1"
> },
>
>
> {
> "name": "new-posix-timezone",
> "data": "EST5EDT4\\,M3.2.0/02:00\\,M11.1.0/02:00"
> },
>
> {
> "name": "preference",
> "data": "0xf0"
> },
>
> {
> "name": "bootfile-param",
> "data": "root=/dev/sda2, quiet, splash"
> }
> ],
>
> "subnet6": [
> {
> "subnet": "2001:db8:1::/64",
>
> "pools": [ { "pool": "2001:db8:1::/80" } ],
>
> "pd-pools": [
> {
> "prefix": "2001:db8:8::",
> "prefix-len": 56,
> "delegated-len": 64
>
> }
> ],
> "option-data": [
> {
> "name": "dns-servers",
> "data": "2001:db8:2::dead:beef,
> 2001:db8:2::cafe:babe"
> }
> ],
>
> "reservations": [
> {
> "duid": "01:02:03:04:05:0A:0B:0C:0D:0E",
> "ip-addresses": [ "2001:db8:1::100" ]
> },
>
> {
> "hw-address": "00:01:02:03:04:05",
> "ip-addresses": [ "2001:db8:1::101" ],
> "option-data": [
> {
> "name": "dns-servers",
> "data": "3000:1::234"
> },
> {
> "name": "nis-servers",
> "data": "3000:1::234"
> }],
>
> "client-classes": [ "special_snowflake", "office" ]
> },
>
> {
> "duid": "01:02:03:04:05:06:07:08:09:0A",
> "ip-addresses": [ "2001:db8:1:cafe::1" ],
> "prefixes": [ "2001:db8:2:abcd::/64" ],
> "hostname": "foo.example.com",
> "option-data": [
> {
> "name": "vendor-opts",
> "data": "4491"
> },
> {
> "name": "tftp-servers",
> "space": "vendor-4491",
> "data": "3000:1::234"
> }
> ]
> },
>
>
> {
> "flex-id": "'somevalue'",
> "ip-addresses": [ "2001:db8:1:cafe::2" ]
> }
> ]
> }
> ]
>
>
>
>
> },
>
> "DhcpDdns":
> {
> "ip-address": "127.0.0.1",
> "port": 53001,
> "tsig-keys": [],
> "forward-ddns" : {},
> "reverse-ddns" : {}
> },
>
> "Control-agent": {
> "http-host": "127.0.0.1",
> "http-port": 8080,
>
> "control-sockets": {
> "dhcp4": {
> "socket-type": "unix",
> "socket-name": "/tmp/kea-dhcp4-ctrl.sock"
> },
> "dhcp6": {
> "socket-type": "unix",
> "socket-name": "/tmp/kea-dhcp6-ctrl.sock"
> }
> },
>
> "hooks-libraries": [
> ]
> },
>
> "Logging":
> {
> "loggers": [
> {
> "name": "kea-dhcp4",
> "output_options": [
> {
> "output": "/var/log/kea-dhcp4.log"
>
>
>
> }
> ],
> "severity": "INFO",
>
> "debuglevel": 0
> },
> {
> "name": "kea-dhcp6",
> "output_options": [
> {
> "output": "/var/log/kea-dhcp6.log"
> }
> ],
> "severity": "INFO",
> "debuglevel": 0
> },
> {
> "name": "kea-dhcp-ddns",
> "output_options": [
> {
> "output": "/var/log/kea-ddns.log"
> }
> ],
> "severity": "INFO",
> "debuglevel": 0
> },
> {
> "name": "kea-ctrl-agent",
> "output_options": [
> {
> "output": "/var/log/kea-ctrl-agent.log"
> }
> ],
> "severity": "INFO",
> "debuglevel": 0
> }
> ]
> }
> }
>
> Br,
> Rasmus
>
> Bill Pye skrev den 2017-10-09 18:19:
>> Hi Thomas
>>
>> I initially built them myself from a Spec file that Rasmus provided
>> and the downloaded source code, he later provided an srpm so I rebuilt
>> it with that. The original list message (and links) is this:
>>
>> Hi Bill,
>>
>> You're welcome. Glad to help.
>>
>> Here's the srpms for 1.2.0 and 1.3.0-beta for those who are interested:
>>
>> 1.2.0:
>> https://arch-ed.dk/srpms/kea-1.2.0/kea-1.2.0-1.el7.centos.src.rpm
>>
>> 1.3.0-beta:
>> https://arch-ed.dk/srpms/kea-1.3.0-beta/kea-1.3.0-0.1.beta.el7.centos.src.rpm
>>
>> Br,
>>
>> Rasmus
>>
>> Where would you like me to send my rpm files, to the list?
>>
>>
>> Regards
>>
>>
>>
>> Bill
>> ----- Original Message -----
>>> From: "Thomas Markwalder" <tmark at isc.org>
>>> To: "bill pye" <bill.pye at phoenix-systems.co.uk>
>>> Cc: "kea-users" <kea-users at lists.isc.org>
>>> Sent: Monday, 9 October, 2017 17:40:38
>>> Subject: Re: [Kea-users] 1.3.0 beta not working with mysql
>>
>>> Hi Bill:
>>>
>>> I did not use RPMs, I installed from source. Please send us your
>>> RPMs.
>>> Where did you get these RPMs?
>>>
>>> Thanks,
>>>
>>> Thomas
>>>
>>>
>>> On 10/9/17 11:18 AM, Bill Pye wrote:
>>>> Hi Thomas
>>>>
>>>> I've built a VM Centos& server, fully updated and just the MariaDB &
>>>> epel
>>>> repositories and fully updated. Unfortunately no luck, the same
>>>> problem occurs.
>>>> Is this, by any chance, a possible problem with my build of kea?
>>>> Would you like
>>>> me to send you my RPMs or perhaps you could send me yours?
>>>>
>>>>
>>>> Regards
>>>>
>>>>
>>>> Bill
>>>>
>>>> ----- Original Message -----
>>>>> From: "Thomas Markwalder" <tmark at isc.org>
>>>>> To: "kea-users" <kea-users at lists.isc.org>
>>>>> Sent: Monday, 9 October, 2017 14:29:37
>>>>> Subject: Re: [Kea-users] 1.3.0 beta not working with mysql
>>>>> Hi Bill:
>>>>>
>>>>> Just following up with you. I was able to build out a Centos 7 VM
>>>>> with
>>>>> MariaDB. Kea builds fine, the unit tests all pass (which include
>>>>> pretty
>>>>> exhaustive testing of our supported backends). kea-dhcp4 comes and
>>>>> happily hands out leases with lifetimes of 604800 with no apparent
>>>>> issues. This was using the 1.3-beta code as is. I even verified
>>>>> that
>>>>> setting the wait_timeout to 30 * 86400 seems to work fine using the
>>>>> mysql command line client.
>>>>>
>>>>> I can't say why you saw what you did before. Doesn't make much
>>>>> sense.
>>>>> If you see it again let us know and we'll dig further.
>>>>>
>>>>> Regards,
>>>>>
>>>>> Thomas Markwalder
>>>>> ISC Software Engineering
>> _______________________________________________
>> Kea-users mailing list
>> Kea-users at lists.isc.org
> > https://lists.isc.org/mailman/listinfo/kea-users
More information about the Kea-users
mailing list