[Kea-users] MySQL DB does not work when "lease-database" is set

Kevin Olbrich ko at sv01.de
Thu Jun 14 11:13:54 UTC 2018


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/2ef2364f/attachment.htm>


More information about the Kea-users mailing list