[Dnsmasq-discuss] MySQL backend for dnsmasq DHCP server

[Marko Fritzsche]

This is a cryptographically signed message in MIME format.

--------------ms070804020205090705050405
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

The mysql patch was updated.

Bugfix:
* reconnect for every DB update (Avoid lost mysql connections)

Enhancement:
* dynamic updates. If an entry was updated in the lease table, dnsmasq 
refreshes its cache automaticly. There's no need to restart or kill -HUP 
the dnsmasq.
* Small PHP Web-GUI to administrate computers and leases (you need 
Smarty http://smarty.php.net)

http://www.0xcc.de/dnsmasq-2.20-mysql.patch.tgz

Cheers,
Marko


Marko Fritzsche wrote:

> Hi,
>
> I extended dnsmasq with a MySQL backend to
> a) get reserved IPs from a DB table
> b) update lease time in a DB table
>
> It's a first try so use it with care. I tested it for 3 days with ca. 
> 50 clients (leasetime 2 hours) without any problems.
>
> Here's the link:
> http://www.0xcc.de/dnsmasq-2.20-mysql-patch.tgz
>
> Cheers,
> Marko
>
>
> _______________________________________________
> Dnsmasq-discuss mailing list
> Dnsmasq-discuss@lists.thekelleys.org.uk
> http://lists.thekelleys.org.uk/mailman/listinfo/dnsmasq-discuss
>

--------------ms070804020205090705050405
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIII9TCC
AtUwggI+oAMCAQICAw4kQzANBgkqhkiG9w0BAQQFADBiMQswCQYDVQQGEwJaQTElMCMGA1UE
ChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNv
bmFsIEZyZWVtYWlsIElzc3VpbmcgQ0EwHhcNMDUwMjI3MTIzNTMzWhcNMDYwMjI3MTIzNTMz
WjBGMR8wHQYDVQQDExZUaGF3dGUgRnJlZW1haWwgTWVtYmVyMSMwIQYJKoZIhvcNAQkBFhRm
cml0enNjaGVAZW1henlueC5kZTCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBANEt
slbF9xONkjZxL40nA5+Ozs3o7iM+6iFDebHgNeRh4b8FSgFFqRE114EZVgqx2KOvuxFzFwXh
wKI55tCn++vykFdipEd8FU1STT/slCSdMIG2YtyHL7+2im0EZKRiGNWNMspXHg1fr24V2n09
mjmEYc+n12DY9xDGHxJtohxR2Q34a6TVyBsh19CqWrqcmCiYmBkvcLUCHaNDRspC7tQVe435
3ev1ENmRkDVebjYw0cgW+e1fYEivVoB9pp/fzfB1sO7ArovjWZ/MQepofEP7eZi9KCOQZN9J
E1YKQNh2oZDRwk+81BI661miDoFg3DfAeleSMm+6f1M1oNax8WECAwEAAaMxMC8wHwYDVR0R
BBgwFoEUZnJpdHpzY2hlQGVtYXp5bnguZGUwDAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQQF
AAOBgQBjhOM4u+V25oOo8uUr981kx/rwQD/qZ+WeNSdeTuDKcRk/305CGf0XhwGDyqSvmbX8
Zv+dtDJAIjDjH0QJ3Wx8QCqYhfuBzr9Ca9e2DRJMq3T8XkeojpV6fJkkoenEIGKSs4c6SdQR
Iyw9s7d/+bYg8KgUgQZjf5A2KhA6htSsUDCCAtUwggI+oAMCAQICAw4kQzANBgkqhkiG9w0B
AQQFADBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkg
THRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0EwHhcN
MDUwMjI3MTIzNTMzWhcNMDYwMjI3MTIzNTMzWjBGMR8wHQYDVQQDExZUaGF3dGUgRnJlZW1h
aWwgTWVtYmVyMSMwIQYJKoZIhvcNAQkBFhRmcml0enNjaGVAZW1henlueC5kZTCCASIwDQYJ
KoZIhvcNAQEBBQADggEPADCCAQoCggEBANEtslbF9xONkjZxL40nA5+Ozs3o7iM+6iFDebHg
NeRh4b8FSgFFqRE114EZVgqx2KOvuxFzFwXhwKI55tCn++vykFdipEd8FU1STT/slCSdMIG2
YtyHL7+2im0EZKRiGNWNMspXHg1fr24V2n09mjmEYc+n12DY9xDGHxJtohxR2Q34a6TVyBsh
19CqWrqcmCiYmBkvcLUCHaNDRspC7tQVe4353ev1ENmRkDVebjYw0cgW+e1fYEivVoB9pp/f
zfB1sO7ArovjWZ/MQepofEP7eZi9KCOQZN9JE1YKQNh2oZDRwk+81BI661miDoFg3DfAeleS
Mm+6f1M1oNax8WECAwEAAaMxMC8wHwYDVR0RBBgwFoEUZnJpdHpzY2hlQGVtYXp5bnguZGUw
DAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQQFAAOBgQBjhOM4u+V25oOo8uUr981kx/rwQD/q
Z+WeNSdeTuDKcRk/305CGf0XhwGDyqSvmbX8Zv+dtDJAIjDjH0QJ3Wx8QCqYhfuBzr9Ca9e2
DRJMq3T8XkeojpV6fJkkoenEIGKSs4c6SdQRIyw9s7d/+bYg8KgUgQZjf5A2KhA6htSsUDCC
Az8wggKooAMCAQICAQ0wDQYJKoZIhvcNAQEFBQAwgdExCzAJBgNVBAYTAlpBMRUwEwYDVQQI
EwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEaMBgGA1UEChMRVGhhd3RlIENv
bnN1bHRpbmcxKDAmBgNVBAsTH0NlcnRpZmljYXRpb24gU2VydmljZXMgRGl2aXNpb24xJDAi
BgNVBAMTG1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBDQTErMCkGCSqGSIb3DQEJARYccGVy
c29uYWwtZnJlZW1haWxAdGhhd3RlLmNvbTAeFw0wMzA3MTcwMDAwMDBaFw0xMzA3MTYyMzU5
NTlaMGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBM
dGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQTCBnzAN
BgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAxKY8VXNV+065yplaHmjAdQRwnd/p/6Me7L3N9Vvy
Gna9fww6YfK/Uc4B1OVQCjDXAmNaLIkVcI7dyfArhVqqP3FWy688Cwfn8R+RNiQqE88r1fOC
dz0Dviv+uxg+B79AgAJk16emu59l0cUqVIUPSAR/p7bRPGEEQB5kGXJgt/sCAwEAAaOBlDCB
kTASBgNVHRMBAf8ECDAGAQH/AgEAMEMGA1UdHwQ8MDowOKA2oDSGMmh0dHA6Ly9jcmwudGhh
d3RlLmNvbS9UaGF3dGVQZXJzb25hbEZyZWVtYWlsQ0EuY3JsMAsGA1UdDwQEAwIBBjApBgNV
HREEIjAgpB4wHDEaMBgGA1UEAxMRUHJpdmF0ZUxhYmVsMi0xMzgwDQYJKoZIhvcNAQEFBQAD
gYEASIzRUIPqCy7MDaNmrGcPf6+svsIXoUOWlJ1/TCG4+DYfqi2fNi/A9BxQIJNwPP2t4WFi
w9k6GX6EsZkbAMUaC4J0niVQlGLH2ydxVyWN3amcOY6MIE9lX5Xa9/eH1sYITq726jTlEBpb
NU1341YheILcIRk13iSx0x1G/11fZU8xggM7MIIDNwIBATBpMGIxCzAJBgNVBAYTAlpBMSUw
IwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUg
UGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQQIDDiRDMAkGBSsOAwIaBQCgggGnMBgGCSqG
SIb3DQEJAzELBgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTA1MDIyNzE3NDMzNlowIwYJ
KoZIhvcNAQkEMRYEFKj4LErbAoUJ7tC6t2c0bFwujxVwMFIGCSqGSIb3DQEJDzFFMEMwCgYI
KoZIhvcNAwcwDgYIKoZIhvcNAwICAgCAMA0GCCqGSIb3DQMCAgFAMAcGBSsOAwIHMA0GCCqG
SIb3DQMCAgEoMHgGCSsGAQQBgjcQBDFrMGkwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRo
YXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBG
cmVlbWFpbCBJc3N1aW5nIENBAgMOJEMwegYLKoZIhvcNAQkQAgsxa6BpMGIxCzAJBgNVBAYT
AlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNU
aGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQQIDDiRDMA0GCSqGSIb3DQEBAQUA
BIIBAJlEv+OtiFXn04CVyaEPTH3LBhf1E+WE4XfdteLnFl3redg3nXwCOk7rgONAyLVniIkF
5BdNlAgYnRCDnLT6eVsRm2VbbQt8X+0yASkhfkdHjXFgnoisOaFyJo/54b8p76GlAjPHTahi
HncseD2dZRDcgOoK0W51w39ZYsaOOpJfZxaA79d8RvK0/nh1ucpV0BsdEr5f2U4DZG0fsA0O
FzWs9Xj6SfD2emIB4LQu3Q+IUGIg/xJ9jPWfJ/t/I4I+cJSwIWfcp8sSZjlfLiOLxcegi3jZ
DHO/9YXHwfhb8MALUfZXKTWKVMHAb/FgVeYzasM+efrVgEhWd12Gszf157gAAAAAAAA=
--------------ms070804020205090705050405--