[sqlite] sqlite3 file as database

2015-09-14 Thread Brian Willner
Microsoft security best practices is never to name anything .db  They
recommend obfuscating the function of the file and putting some strange or
random (.bob) file extension.  This is for when you have an active
intrusion, you are not handing them what to take on a silver platter.  You
could argue the same applies to SQLite file naming conventions as well.

> Why do people use .db3 for sqlite database files? In my experience 
> .db3 is the file extension for dBase III database files.


[sqlite] Rare database corruption - does this help?

2015-09-11 Thread Brian Willner
I assume nothing in the Server logs for security and applications at the
corresponding time?

-Original Message-
The environment is Windows Server 2012 R2, with the database on a local NTFS
drive.



[sqlite] Lawyers, encryption, and RC4

2015-08-12 Thread Brian Willner
"Several operating systems include arc4random, an API originating in OpenBSD
providing access to a random number generator originally based on RC4. In
OpenBSD 5.5, released in May 2014, arc4random was modified to use
ChaCha20.[11][12] As of January 2015, implementation of arc4random in
NetBSD[13][14] also uses ChaCha20, however, implementation of arc4random in
FreeBSD,[15] Linux's libbsd,[16] and Mac OS X[17] are still based on RC4." 
Sourced: https://en.wikipedia.org/wiki/RC4

If you point out to your lawyers that SQLite is not doing anything that
Apple's OS X is doing, you may get some traction as well.

-Original Message-
From: sqlite-users-boun...@mailinglists.sqlite.org
[mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Richard
Hipp
Sent: Tuesday, August 11, 2015 10:11 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Lawyers, encryption, and RC4

No.

The RC4 encryption algorithm consists of three subcomponents:

(1) Key management logic
(2) The pseudo-random number generator (PRNG)
(3) The encoder/decoder

SQLite only implements (2).  It omits (1) and (3).  And hence, the RC4
kernel inside of SQLite cannot be used for encryption.

--
D. Richard Hipp
drh at sqlite.org
___
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] Lawyers, encryption, and RC4

2015-08-11 Thread Brian Willner
Have you found yourself in an ITAR mess?
https://en.wikipedia.org/wiki/Export_of_cryptography_from_the_United_States

The length of the keys is usually the determining factor for EAR.  I'm not
an expert, but I'm guessing that is why they are concerned.

-Original Message-
From: sqlite-users-boun...@mailinglists.sqlite.org
[mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Eric Hill
Sent: Tuesday, August 11, 2015 8:31 AM
To: General Discussion of SQLite Database
Subject: [sqlite] Lawyers, encryption, and RC4

Sorry to bother folks with this.

We're getting some pushback from our lawyers suggesting that SQLite's use of
RC4 even just to generate random numbers is, in their minds, encryption for
export purposes.  Now, this makes absolutely no sense to me, I can assure
you, and I am not finding anything online that would suggest that is a valid
position, but I'm wondering if this has come up before and if you have any
good ammunition for dealing with such an argument.

Thanks,

Eric
___
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users