Re: [sqlite] Mailing list shutting down...

On Wed, 13 Jun 2018 07:22:20 -0400 Richard Hipp wrote: > Unfortunately, I'm going to need to shut down this mailing list due to > robot harassment. I am working to come up with a fix or an > alternative now. Your suggestions are welcomed. > > This mailing list has operated for many years using

Re: [sqlite] Mailing list shutting down...

On 6/13/18 6:52 PM, Bob Friesenhahn wrote: > On Wed, 13 Jun 2018, Jeffrey Schiller wrote: > >> Would limiting subscription requests to one per day help. I'm >> familiar with >> the Mailman code, having modified it for use at MIT, and can code the >> necessary changes. I suspect only one file would

Re: [sqlite] Mailing list shutting down...

On Wed, Jun 13, 2018 at 5:17 PM Simon Slavin wrote: > 13 Jun 2018, at 11:52pm, Bob Friesenhahn > wrote: > > > The problem is knowing what "one" means. The subscription request is > likely submitted via http/https into the web form and using a bogus email > subscription address (of the "victim")

Re: [sqlite] sqlite-users Digest, Vol 126, Issue 13

On Wed, Jun 13, 2018 at 09:01:22PM +0200, Simone Mosciatti wrote: > Hi folks, > > I already posted this message but I believe there was some error or > issue with nabble and I am not sure it was received, if you already > got it, please sorry a lot for the noise. I'm finding some mailing list pos

Re: [sqlite] Mailing list shutting down...

13 Jun 2018, at 11:52pm, Bob Friesenhahn wrote: > The problem is knowing what "one" means. The subscription request is likely > submitted via http/https into the web form and using a bogus email > subscription address (of the "victim"). A botnet is able to submit these > requests from hundre

Re: [sqlite] Mailing list shutting down...

On Wed, 13 Jun 2018, Jeffrey Schiller wrote: Would limiting subscription requests to one per day help. I'm familiar with the Mailman code, having modified it for use at MIT, and can code the necessary changes. I suspect only one file would need to be changed. The problem is knowing what "one"

Re: [sqlite] Mailing list shutting down...

Would limiting subscription requests to one per day help. I'm familiar with the Mailman code, having modified it for use at MIT, and can code the necessary changes. I suspect only one file would need to be changed. -Jeff On Wed, Jun 13, 2018 at 6:16 PM Gary R. Schmidt wrote: > On 13/06/2018 21:

Re: [sqlite] Mailing list shutting down...

On 13/06/2018 21:42, Gary R. Schmidt wrote: On 13/06/2018 21:22, Richard Hipp wrote: Unfortunately, I'm going to need to shut down this mailing list due to robot harassment.  I am working to come up with a fix or an alternative now.  Your suggestions are welcomed. This mailing list has operated

Re: [sqlite] Mailing list shutting down...

On 14/06/2018 03:37, John Long wrote: On Wed, 2018-06-13 at 21:42 +1000, Gary R. Schmidt wrote: This is an increasing problem, and has been discussed on the Mailman mailing list recently, you should join them and see what mitigation strategies are available. Well I'm sure he would like to, b

Re: [sqlite] Mailing list shutting down...

On 6/13/18, Florian Weimer wrote: > if the bots are > actually targeting innocent users, for most recipients, they can just > use multiple aliases of the form , > , and so on. I have a accumulated a good assortment of robot counter-measures over the years, a few of which are outlined here: https:

Re: [sqlite] How to convert SQL file into database when a column value is Inf?

On 13 Jun 2018, at 9:44pm, skywind mailing lists wrote: > The operation system is iOS (therefore, it is difficult to remove the battery > and do several tests after each other) (First paragraph is background for others reading this message.) An iOS application which is running is supposed to

Re: [sqlite] Mailing list shutting down...

* Richard Hipp: > On 6/13/18, Brian Curley wrote: >> Doesn't the Fossil site already have a Capcha interface built into it that >> could be adopted to enforce additional authentication around subscriptions? > > There are no captchas built into GNU MailMan. You enter your email > address to subsc

Re: [sqlite] [fossil-users] Mailing list shutting down...

could use Gitter ( https://gitter.in ) is nice; emails on directed messges; retains discussion histories; integrates with various other platforms... git in particular such a referecning issues and pull requests with just # supports markdown formatting; which makes talking about `code fragments` nic

Re: [sqlite] How to convert SQL file into database when a column value is Inf?

Hi Ryan, I just became aware that I might give synchronisation level 3 a chance (currently the level is 1, default setting). I was not aware of this setting since a couple of minutes ago. Otherwise, the database is in serialised threading mode, though only one thread is accessing it. The opera

Re: [sqlite] [fossil-users] Mailing list shutting down...

On 6/13/18, Svyatoslav Mishyn wrote: > > Another alternative would be nimforum: > https://github.com/nim-lang/nimforum > It does not appear to have email notification. Unless I overlooked something. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users

Re: [sqlite] sqlite-users Digest, Vol 126, Issue 13

On 13 Jun 2018, at 8:01pm, Simone Mosciatti wrote: > I try to use the module that I just created I only get an error: "no such > module: $NAME_MODULE" Are you storing the name of the module in a variable ? You seem to be somehow passing to the parameter a module name containing the dollar sig

Re: [sqlite] Mailing list shutting down...

Using policyd one should be able to limit the rate at which one account (subscribe confirmation) is able to send messages to a particular address, or the overall number of mails sent to an address. https://wiki.policyd.org/quotas On Wed, Jun 13, 2018, 9:36 PM Richard Hipp wrote: > On 6/13/18, A

Re: [sqlite] Mailing list shutting down...

Richard, We use Discourse (as a user) to get support for the Mail in a Box system. MIAB use Discourse for their support systems. I also think Discourse is used for the Ionic support pages as well as they have very similar looking interfaces. Until now I paid little attention to them. I was g

Re: [sqlite] [fossil-users] Mailing list shutting down...

(Wed, 13 Jun 14:59) Richard Hipp: > Cross-posted to the fossil-users mailing list since www.fossil-scm.org > and www.sqlite.org are the same machine and both mailing lists are > impacted by the current problem. > > On 6/13/18, Luiz Américo wrote: > > How about using https://www.discourse.org/ ? >

Re: [sqlite] Mailing list shutting down...

On 6/13/18, Simon Slavin wrote: > > > On 13 Jun 2018, at 3:02pm, Simon Slavin wrote: > >> you might try the solution described in the lower part of >> >> >> >> and also the measure recommended here: >> >>

Re: [sqlite] Mailing list shutting down...

On 6/13/18, Alessandro Marzocchi wrote: > Do you have control over postfix server? If so maybe adding a policy to the > account used for subscription confirmation may work. I dont have a PC > available at the moment but in the case i may check. I don't see how that could possibly help. Please en

Re: [sqlite] Mailing list shutting down...

Do you have control over postfix server? If so maybe adding a policy to the account used for subscription confirmation may work. I dont have a PC available at the moment but in the case i may check. On Wed, Jun 13, 2018, 9:16 PM Chris Brody wrote: > On Wed, Jun 13, 2018 at 3:00 PM Richard Hipp

Re: [sqlite] How to convert SQL file into database when a column value is Inf?

On 2018/06/13 6:35 PM, skywind mailing lists wrote: Hi Ryan, my problem is that I use the "most safest" mode that exists for SQLite and it still fails… Therefore, I need to know why it fails. Alright, but this implies a very serious flaw in SQLite, so mind if we double-check some things? -

Re: [sqlite] Mailing list shutting down...

On Wed, Jun 13, 2018 at 3:00 PM Richard Hipp wrote: > > Cross-posted to the fossil-users mailing list since www.fossil-scm.org +1 > Even so, Discourse does seem like considering. Does anybody else have > any experience with Discourse, good or bad? SQLCipher switched over to Discourse for the d

Re: [sqlite] sqlite-users Digest, Vol 126, Issue 13

Hi folks, I already posted this message but I believe there was some error or issue with nabble and I am not sure it was received, if you already got it, please sorry a lot for the noise. == Hi All, I am facing a quite interesting problem. I am trying to implement a new virtual

Re: [sqlite] Mailing list shutting down...

On 13 Jun 2018, at 3:02pm, Simon Slavin wrote: > you might try the solution described in the lower part of > > > > and also the measure recommended here: > >

Re: [sqlite] Mailing list shutting down...

Cross-posted to the fossil-users mailing list since www.fossil-scm.org and www.sqlite.org are the same machine and both mailing lists are impacted by the current problem. On 6/13/18, Luiz Américo wrote: > How about using https://www.discourse.org/ ? > > Open source projects can use for free Than

Re: [sqlite] Mailing list shutting down...

How about using https://www.discourse.org/ ? Open source projects can use for free Luiz Em qua, 13 de jun de 2018 14:37, John Long escreveu: > On Wed, 2018-06-13 at 21:42 +1000, Gary R. Schmidt wrote: > > > > > > This is an increasing problem, and has been discussed on the Mailman > > mailing

Re: [sqlite] Mailing list shutting down...

On Wed, 2018-06-13 at 21:42 +1000, Gary R. Schmidt wrote: > > > This is an increasing problem, and has been discussed on the Mailman > mailing list recently, you should join them and see what mitigation > strategies are available. Well I'm sure he would like to, but subscriptions have probably

Re: [sqlite] How to convert SQL file into database when a column value is Inf?

On 06/13/2018 12:35 PM, skywind mailing lists wrote: Hi Ryan, my problem is that I use the "most safest" mode that exists for SQLite and it still fails… Therefore, I need to know why it fails. I have been watching this from a distance and all I can think is : 1) what do you mean by

Re: [sqlite] Mailing list shutting down...

On 6/13/18, Michael Tiernan wrote: > May I respectfully suggest to everyone that offering solutions, while > valuable and helpful, may not be as valuable as the offer of assistance > to our listmaster. +1 :-) -- D. Richard Hipp d...@sqlite.org ___ sq

Re: [sqlite] How to convert SQL file into database when a column value is Inf?

Hi Ryan, my problem is that I use the "most safest" mode that exists for SQLite and it still fails… Therefore, I need to know why it fails. Regards, Hartwig > Am 2018-06-13 um 01:23 schrieb R Smith : > > > On 2018/06/13 12:21 AM, skywind mailing lists wrote: >> Hi, >> >> the original databas

Re: [sqlite] Mailing list shutting down...

May I respectfully suggest to everyone that offering solutions, while valuable and helpful, may not be as valuable as the offer of assistance to our listmaster. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqli

Re: [sqlite] Mailing list shutting down...

On Wed, Jun 13, 2018 at 12:14:46PM -0400, Richard Hipp wrote: > (1) Nobody seems to want to own the GNU MailMan software. It is not > well maintained as far as I can see. I'm not an expert, but how does Sympa handle this? I remember a few years ago a lot of people were moving their Mailman syste

Re: [sqlite] Mailing list shutting down...

On 6/13/18, Brian Curley wrote: > Doesn't the Fossil site already have a Capcha interface built into it that > could be adopted to enforce additional authentication around subscriptions? There are no captchas built into GNU MailMan. You enter your email address to subscribe and you get a confirm

Re: [sqlite] Mailing list shutting down...

Doesn't the Fossil site already have a Capcha interface built into it that could be adopted to enforce additional authentication around subscriptions? Or a 2-step, email confirmation-type option, maybe? If they're robots causing the problem, then they wouldn't be able to mive beyond the initial att

Re: [sqlite] Mailing list shutting down...

On 6/13/18, Chris Brody wrote: > On Wed, Jun 13, 2018 at 10:44 AM jungle Boogie > wrote: >> [...] >> http://spamassassin.apache.org/ > > Maybe just add SpamAssassin to the existing GNU MailMan setup? > > http://www.jamesh.id.au/articles/mailman-spamassassin/ That solves a different problem from

Re: [sqlite] Mailing list shutting down...

On Wed, Jun 13, 2018 at 10:44 AM jungle Boogie wrote: > [...] > http://spamassassin.apache.org/ Maybe just add SpamAssassin to the existing GNU MailMan setup? http://www.jamesh.id.au/articles/mailman-spamassassin/ ___ sqlite-users mailing list sqlite-u

Re: [sqlite] Mailing list shutting down...

On 13 June 2018 at 04:22, Richard Hipp wrote: > Unfortunately, I'm going to need to shut down this mailing list due to > robot harassment. I am working to come up with a fix or an > alternative now. Your suggestions are welcomed. > OpenBSD uses Majordomo for their mailing lists: https://en.wik

Re: [sqlite] Issue with node-sqlite3

Hi Omer, Unfortunately what you are trying to do it not possible. You are trying to run the npm package `node-sqlite3` in an Angular project. Angular is a front-end, browser-based framework. The npm package manager contains javascript modules which can sometimes be used either in the browser or

Re: [sqlite] Mailing list shutting down...

On 13 Jun 2018, at 12:22pm, Richard Hipp wrote: > The most recent problem is that robots are visiting the subscription > page and entering innocent user's email addresses and names. I'm surprised the server lasted this long. That problem has been around since 2010. I don't know what you've al

Re: [sqlite] Mailing list shutting down...

> Le 13 juin 2018 à 13:22, Richard Hipp a écrit : > > Unfortunately, I'm going to need to shut down this mailing list due to > robot harassment. > ... > I have already suspended new subscriptions. Existing subscribers will > be able to continue using this list until I come up with a replacement

Re: [sqlite] Issue with node-sqlite3

On 13 Jun 2018, at 11:50am, Space Pixel wrote: > Also, some of the packages sqlite3 requires are > very ancient and deprecated: crypto, aws-sdk, http, https, and some more. sqlite3 does not require any of those packages. SQLite has no dependencies at all. You can compile sqlte3 support entire

Re: [sqlite] Issue with node-sqlite3

> On 13 Jun 2018, at 11:50am, Space Pixel wrote: > > Also, some of the packages sqlite3 requires are > very ancient and deprecated: crypto, aws-sdk, http, https, and some more. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http:/

Re: [sqlite] Issue with node-sqlite3

On 13 Jun 2018, at 9:26am, Space Pixel wrote: > I am having serious trouble with the Node.js module "sqlite3". This package Hello Omer. Then retry your command using just node, with no .cs involved const db = new sqlite3.Database("file name here"); In other words, make a test.js file

Re: [sqlite] Mailing list shutting down...

On 6/13/18, Tim Streater wrote: > Personally I'd be loath to see this list moved to a web page, for > instance. We invite you to submit working code that implements your desired solution. :-) -- D. Richard Hipp d...@sqlite.org ___ sqlite-users maili

Re: [sqlite] Mailing list shutting down...

On 13 Jun 2018, at 12:22, Richard Hipp wrote: > Unfortunately, I'm going to need to shut down this mailing list due to > robot harassment. I am working to come up with a fix or an > alternative now. Your suggestions are welcomed. Perhaps another subscription mechanism is needed, if that is the

Re: [sqlite] Issue with node-sqlite3

>I can see you didn't quite understand me. The project I am attempting >to >install sqlite3 on is an Angular 6 project. Now, in the package sqlite3 >there is a CS file that spits out a warning Ryan's advice, though, is still correct: this is not a NodeJS or Angular mailing list. You'd probably h

Re: [sqlite] Mailing list shutting down...

On 13/06/2018 21:22, Richard Hipp wrote: Unfortunately, I'm going to need to shut down this mailing list due to robot harassment. I am working to come up with a fix or an alternative now. Your suggestions are welcomed. This mailing list has operated for many years using GNU MailMan. Unfortunat

[sqlite] Mailing list shutting down...

Unfortunately, I'm going to need to shut down this mailing list due to robot harassment. I am working to come up with a fix or an alternative now. Your suggestions are welcomed. This mailing list has operated for many years using GNU MailMan. Unfortunately, that software is not able to cope with

Re: [sqlite] Issue with node-sqlite3

Hi Ryan, I can see you didn't quite understand me. The project I am attempting to install sqlite3 on is an Angular 6 project. Now, in the package sqlite3 there is a CS file that spits out a warning "you need an appropriate loader to handle this file type". Also, some of the packages sqlite3 requir

Re: [sqlite] Issue with node-sqlite3

On 2018/06/13 10:26 AM, Space Pixel wrote: Hello sqlite community, I am having serious trouble with the Node.js module "sqlite3". This package is supposed to connect JavaScript or TypeScript code with a sqlite3 database (file or online database). When I try to use the sqlite file (the command I

[sqlite] Issue with node-sqlite3

Hello sqlite community, I am having serious trouble with the Node.js module "sqlite3". This package is supposed to connect JavaScript or TypeScript code with a sqlite3 database (file or online database). When I try to use the sqlite file (the command I am using is "const db = new sqlite3.Database(