Re: [Chicken-hackers] pastiche db drop

2014-02-03 Thread Christian Kellermann
* Christian Kellermann ck...@pestilenz.org [140203 10:55]: I had a copy of the db which has been taken around december 9th 2013 and copied that over to the server. Thanks to Mario we now have a backup dated Feb 1st back in action. Thanks so much! -- In the world, there is nothing more

Re: [Chicken-hackers] pastiche db drop

2014-02-03 Thread Alaric Snell-Pym
On 03/02/14 09:53, Christian Kellermann wrote: Hi there, I have just dropped pastiche's database accidentally by omitting an equal sign during spam deletion. That is: delete from pastes where hash 6e4bc38a652603314074d80094b39197fee50ac2; Bah! Why did the sql engine (sqlite?) not

Re: [Chicken-hackers] pastiche db drop

2014-02-03 Thread John Cowan
Alaric Snell-Pym scripsit: Bah! Why did the sql engine (sqlite?) not reject that as a syntax error? Sqlite does reject it: [cowan@vrici ~]$ sqlite3 SQLite version 3.8.0.2 2013-09-03 17:11:13 Enter .help for instructions Enter SQL statements terminated with a ; sqlite delete from pastes where

Re: [Chicken-hackers] pastiche db drop

2014-02-03 Thread Christian Kellermann
* John Cowan co...@mercury.ccil.org [140203 15:14]: Alaric Snell-Pym scripsit: Bah! Why did the sql engine (sqlite?) not reject that as a syntax error? Sqlite does reject it: [cowan@vrici ~]$ sqlite3 SQLite version 3.8.0.2 2013-09-03 17:11:13 Enter .help for instructions Enter SQL

Re: [Chicken-hackers] pastiche db drop

2014-02-03 Thread Alaric Snell-Pym
On 03/02/14 14:13, John Cowan wrote: On the other hand, that was the *only* time the system went down in a serious way. It was a Mickey-Mouse-watch design: if you drop it, it stops; but if you pick it up and shake it, it works again. In particular, if the web and FTP sites were messed up,

Re: [Chicken-hackers] [PATCH] Enable -deploy on NetBSD [was: Re: [PATCH] Enable -deploy on OpenBSD]

2014-02-03 Thread Christian Kellermann
* Thomas Chust ch...@web.de [140201 20:48]: the longer that disjunction of conditions gets, the more I feel that something like (if (and deployed (memq (software-version) '(freebsd openbsd netbsd))) ...) would look nicer ;-) I have pushed Peter's patch with this small correction.

Re: [Chicken-hackers] [PATCH] Replace unsafe string functions with their safer counterparts

2014-02-03 Thread Peter Bex
On Thu, Jan 23, 2014 at 12:28:01PM +0100, Christian Kellermann wrote: Hi all, I propose the following patch. It has been tested on OpenBSD and Linux. Should work without troubles on all other OSes as well. Please give it a try. Hi Christian, After some reconsideration, I think this is