ovsqlite bits and pieces

Bo Lindbergh <[email protected]> Sun, 24 May 2026 16:26:00 +0200
Newsgroups gmane.network.inn
Message-ID <[email protected]>
--Apple-Mail=_2E15ED3B-575D-4806-83C1-8557B6D8F3A6
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
	charset=us-ascii

This gets embarrassing.

Back in 2020, I somehow missed that SQLite's PRNG has a direct C interface.
Using this is much simpler than preparing and running some SQL.

The PRNG is only used in one place: generating a random
authentication cookie when Unix-domain sockets aren't available.
So to test the new shorter code I built INN with Unix sockets
forced off, and then I discovered that I had failed to test this case
in the INN::ovsqlite_client Perl module.

New and improved code attached, actually tested this time.

/Bo Lindbergh

--Apple-Mail=_2E15ED3B-575D-4806-83C1-8557B6D8F3A6
Content-Disposition: attachment;
	filename=0001-Using-sqlite3_randomness-simplifies-things.patch.gz
Content-Type: application/x-gzip;
	x-unix-mode=0644;
	name="0001-Using-sqlite3_randomness-simplifies-things.patch.gz"
Content-Transfer-Encoding: base64

H4sICOIBE2oCAzAwMDEtVXNpbmctc3FsaXRlM19yYW5kb21uZXNzLXNpbXBsaWZpZXMtdGhpbmdz
LnBhdGNoAK1WbXPaRhD+rl+x8UxmRECyXjHgurHr4sZjbJJA2g+djuYkrcQFvVDdyQlt+t+7esEG
h8R8yA0zJ93uPvfcc7srroo8BdM0XQtPgsHADX1m9x3LGAxOkLlO4Du27VqOEUV+n8FtnsEMV2Ce
gGGM6h9YhmEqVwQzgl9ymPAs9LGIF/CTn8TJuZAsWGKmL+VCF/iz8iuTOIJZmfXAcuCWrSne6oPp
jix3ZBvQNQhPmZX+RwzkCP58ezG/fAPmsfUXfBA8i0H8nXCJtlewLMzTDIUAwdNVwiOOAuSCfISu
KJqmKSBkXrAYj/P7JurhQRNY3GOhB/AFLBu62t6xB4AmLWU80+kB6vEFwIba2YKIJ8QhWLAsxrAH
JvCMNpI8z9Ruhw7sQogJVu9C1TqKEvIootiYS2DHB5D1D3BS6ALwM9g+DtGJ2Imuu0HkDm3DccA0
jL7jVNoctJ/S7XYP2/P8HDRrMOzZFnSr2TSBllK2RI9nKL2EC4kZFup9zsOOAv8qtXakVAGvVkwu
TpsFIYsykCDyYMnCsKBgEOxU0Sobz8ggmSxFu1BhQUBaSngV5PmSY4tSeRYoN5gElmDmUTSjecsn
CumlwdpklU/q0a5SpQWvvugmz+gyezD9ffZucj0fe5fT6c312JuM736bv+m0dBpucPaARUdePcXZ
OPMI1DbgxRm0sO+nf3RIGg3aEXJUj8hGaIBFkRfwaUEZBnElJZNVNTSo0Bx/BC/FUe8xfvtgFJ+K
WCW5MiosysDOhsp/zdRAbNEP8qRMM89Pcv9rNYztg7xoYne4f6UGEQjyELcZnD6679VjerMD+aMk
OUyWWhrAROBeDmWGn1cUgiHcfZhMKN9Emchn2BztgO/IXwvwRPm1RLFP+kqib+Tik+TZYtkSFPwf
PJRlimmwWqurvJB6Y+rBZv5+LdBmKIMEWbGnALrbF/DYxtWKWh7BznZbL52qWOujNd2kqusqv2hC
qV5cedd343kPZtPLG282fz++uG3S9CG/tsPOQDM7z/TfnV7vf9/edl3HdgMbmWHqemRaQ2PAgv4z
XXcH5RsNd8en7rW9ITXaXr/qsivyTRlEeYE8zrwlrquyM2u1WptfirUneYp5Kck23Iy6/RGt9m4U
augJZUubDnXlvzarO1Wg8opRplwE9Fls3O5ZUiJE1T+IZr0anxZYIBCLs9fEgcIUS7eGuqEo/wM0
LlCYawgAAA==
--Apple-Mail=_2E15ED3B-575D-4806-83C1-8557B6D8F3A6
Content-Disposition: attachment;
	filename=0002-Fix-the-no-unix-sockets-path-of-ovsqlite_client.pm.patch.gz
Content-Type: application/x-gzip;
	x-unix-mode=0644;
	name="0002-Fix-the-no-unix-sockets-path-of-ovsqlite_client.pm.patch.gz"
Content-Transfer-Encoding: base64

H4sICOIBE2oCAzAwMDItRml4LXRoZS1uby11bml4LXNvY2tldHMtcGF0aC1vZi1vdnNxbGl0ZV9j
bGllbnQucG0ucGF0Y2gAjVLvT9swEP3uv+ItqlCrkDRx24QGmPjZrRoUNNgnhCondtqswc4Sdyra
9r/PScVEiwZEkU++e3fv7vlGpXpAOOwNQ8+jKe/3BwkbeElKU1/0+B7njMec9YOezxnFpZK4EQX8
EJ4XNT+o5/lkZMpEOFG4yCSPRTmb4yDOZ/lRpVmyENJd6LlbiY/kjGkR4WYpd0H7uGSPJp8G8AcR
DaLBELZn6pGbZfxdJDrC3fXx7eln0C69xyhbQc8FpHKWMls5lTKVdYWC6TlUCvWz+pFnWkyTPBNS
u8UDIY7jEBSizLvjyaT7EoHf6MO2a5SPNMsFkjmTM8FNe8hkJUqdKVm17U7t4CIX67vTIYRnaQrH
mWUarPsaR/xalBjBxAo+MzImAQ1dN/Yp9/bEgMP3vKDfr4d4nYHYtv0Gy9ERnF5Ad0PYa2McJ+ef
xhP8Inj+tRjnJQ6NqsliWktc36dL2W7VOnf2t9CJUotMGLxlPQv9gcirLEXbSTHFzg5aZg/0XXiP
w0P4ex1D6jwv8/CIdiud78Ic8TI1dqa0OQtV6sa5pjHs9nvT6k43e1WFkGu4dWDVqHqeTYgBlUhK
xRawmnjUZEVofTDjNRqGvUbDxvxXQ9PGetI3y3+TYlWYVRcc51cja0veJFeVqHs202wI1n4hjXmC
pawfrW1JMD+wnlTZFu1f6jsSN6cqUoO9Hk3Hk/Pb/fdsTSafyMaT47Ozr9OLq6vrk+PTL53tXRH1
Rjgg1KVD1yPkLxsDoliXBAAA
--Apple-Mail=_2E15ED3B-575D-4806-83C1-8557B6D8F3A6
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

-- 
inn-workers mailing list
[email protected]
https://lists.isc.org/mailman/listinfo/inn-workers

--Apple-Mail=_2E15ED3B-575D-4806-83C1-8557B6D8F3A6--