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--