[Kea-users] MySQL DB does not work when "lease-database" is set
Kevin Olbrich
ko at sv01.de
Thu Jun 14 11:14:39 UTC 2018
https://www.debian.org/devel/wnpp/#howto-o
Kevin
2018-06-14 13:13 GMT+02:00 Kevin Olbrich <ko at sv01.de>:
> Debian lists wnpp at debian.org as a contact for "work needing packages".
>
> Kevin
>
>
> 2018-06-14 4:06 GMT+02:00 Jason Guy <jguy at cumulusnetworks.com>:
>
>> Hi Tomek,
>>
>> The debian maintainer (Adam) is not responsive. I packaged 1.3.0, and
>> nagged him for 6 months to update the repo. He finally did in January, but
>> he has not integrated any of my fixes for 1.3.0 since January. I have been
>> running my 1.3.0 package in production for 6 months, and asked him
>> repeatedly to give me the permissions to update the repo, and push the
>> packages to stable. I am not sure what I can do... he does not seem to be
>> taking this seriously. What is the next step?
>>
>> I will be starting the packaging of 1.4.0 next week.
>>
>> Cheers,
>> Jason
>>
>> On Wed, Jun 13, 2018 at 11:15 AM, Tomek Mrugalski <tomasz at isc.org> wrote:
>>
>>> When talking to the Debian maintainer, you may also mention that 1.4.0
>>> is around the corner. Unless we hit something very unexpected, it should
>>> be released this Friday.
>>>
>>> Tomek
>>>
>>> On 13/06/2018 16:32, Kevin Olbrich wrote:
>>> > Package version on debian is still 1.1.0 on all branches.
>>> > I sent an email to the maintainer as 1.3.0 is the recommended release
>>> > and 1.1.0 is some kind of "please do not use this anymore"-release.
>>> >
>>> > PS: I am on MariaDB 10.2 on both server and client. This might be the
>>> > problem. I did not fix the problem yet as all leases are static. I will
>>> > look into this the coming weeks.
>>> >
>>> > Kind regards
>>> > Kevin
>>> >
>>> >
>>> >
>>> > 2018-03-19 14:26 GMT+01:00 Jason Guy <jguy at cumulusnetworks.com
>>> > <mailto:jguy at cumulusnetworks.com>>:
>>> >
>>> > Hi Kevin,
>>> >
>>> > What version of mysql are you using? I have no problems with mysql
>>> > 5.7 (client and server). Also, have you initialized the database?
>>> >
>>> > Finally, I assume you are using version 1.1 because that it the
>>> only
>>> > version available on Debian Apt... I am still trying to have the
>>> > maintainer take more of my patches, and push the 1.3 packages to
>>> the
>>> > testing repo, but it is not going well. If anyone knows the
>>> > maintainer for this package, or has any advice about how to get
>>> more
>>> > traction with the debian maintainer, I would be grateful. I have
>>> > done a lot of work to patch the 1.1 package to become the 1.3
>>> > package, and I am using in my testing. But I would like to make
>>> this
>>> > available to all. :)
>>> >
>>> > Cheers,
>>> > Jason
>>> >
>>> >
>>> > On Mon, Mar 19, 2018 at 9:22 AM, Thomas Markwalder <tmark at isc.org
>>> > <mailto:tmark at isc.org>> wrote:
>>> >
>>> > Hello Kevin:
>>> >
>>> > Kea is now up to version 1.3.0 with many new features added
>>> > since 1.1.0 so you may wish to consider upgrading. However,
>>> Kea
>>> > 1.1.0 should function using MySQL for lease storage. Kea
>>> > servers can emit a great deal of logging detail, provided you
>>> > have it enabled. With sufficient logging enabled, you should
>>> > see some sort of response from Kea to client packets. Even if
>>> > Kea elects to drop a packet, you should still it's arrival
>>> > logged and an explanation for why it was dropped.
>>> >
>>> > I would suggest, as a starting point that you dial up the
>>> > logging detail. The following logger configuration will give
>>> > you maximum output to stdout (for more information on logging
>>> > please see the Logging chapter in the Kea Admin guide):
>>> >
>>> >
>>> > "Logging":
>>> > {
>>> > "loggers": [
>>> > {
>>> > "name": "kea-dhcp4",
>>> > "output_options": [
>>> > {
>>> > "output": "stdout"
>>> > }
>>> > ],
>>> > "severity": "INFO",
>>> > "debuglevel":99
>>> > }
>>> > ]
>>> > }
>>> >
>>> > I have attached a log excerpt from a Kea 1.1.0 server I
>>> > configured to use MySQL lease storage so you can see what to
>>> expect.
>>> >
>>> >
>>> >
>>> > Regards,
>>> >
>>> > Thomas Markwalder
>>> > ISC Software Engineering
>>> >
>>> >
>>> >
>>> > On 03/18/2018 06:02 PM, Kevin Olbrich wrote:
>>> >> Hi,
>>> >>
>>> >> I set the following as my lease-db:
>>> >>
>>> >> "lease-database": {
>>> >> "type": "mysql",
>>> >> "name": "dc_dhcp",
>>> >> "host": "192.168.30.2",
>>> >> "user": "dc_dhcp",
>>> >> "password": "xxxxxxxxxxxxxx"
>>> >> # "type": "memfile",
>>> >> # "persist": true,
>>> >> # "name": "/tmp/kea-leases4.csv",
>>> >> # "lfc-interval": 1800
>>> >> },
>>> >>
>>> >> If I use MySQL, no lease is ever created. The server also
>>> >> never answers any DHCP request.
>>> >>
>>> >> Changing from mysql to memfile (commented out code above),
>>> >> everything works fine.
>>> >> No error is logged, "it just dont work" with mysql.
>>> >>
>>> >> root at dhcp01:~# kea-dhcp4 -v
>>> >> 1.1.0
>>> >>
>>> >> Debian Stretch, main repo.
>>> >>
>>> >> Is this a known issue?
>>> >>
>>> >> Kind regards,
>>> >> Kevin
>>> >>
>>> >>
>>> >> _______________________________________________
>>> >> Kea-users mailing list
>>> >> Kea-users at lists.isc.org <mailto:Kea-users at lists.isc.org>
>>> >> https://lists.isc.org/mailman/listinfo/kea-users
>>> >> <https://lists.isc.org/mailman/listinfo/kea-users>
>>> >
>>> >
>>> > _______________________________________________
>>> > Kea-users mailing list
>>> > Kea-users at lists.isc.org <mailto:Kea-users at lists.isc.org>
>>> > https://lists.isc.org/mailman/listinfo/kea-users
>>> > <https://lists.isc.org/mailman/listinfo/kea-users>
>>> >
>>> >
>>> >
>>> > _______________________________________________
>>> > Kea-users mailing list
>>> > Kea-users at lists.isc.org <mailto:Kea-users at lists.isc.org>
>>> > https://lists.isc.org/mailman/listinfo/kea-users
>>> > <https://lists.isc.org/mailman/listinfo/kea-users>
>>> >
>>> >
>>> >
>>> >
>>> > _______________________________________________
>>> > Kea-users mailing list
>>> > Kea-users at lists.isc.org
>>> > https://lists.isc.org/mailman/listinfo/kea-users
>>> >
>>> _______________________________________________
>>> Kea-users mailing list
>>> Kea-users at lists.isc.org
>>> https://lists.isc.org/mailman/listinfo/kea-users
>>>
>>
>>
>> _______________________________________________
>> Kea-users mailing list
>> Kea-users at lists.isc.org
>> https://lists.isc.org/mailman/listinfo/kea-users
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20180614/8f5097aa/attachment.htm>
More information about the Kea-users
mailing list