SQLite Forum

Password-protected databases no longer work with 1.113, no rollback possible
Login

Password-protected databases no longer work with 1.113, no rollback possible

(1.1) By Peter Bickford (pbickford) on 2020-06-02 21:48:18 edited from 1.0 [link] [source]

Did a Nuget update to system.Data.Sqlite 1.0.113.1 today, and noticed that the ChangePassword method of ConnectionString is no longer supported (and that password-protected databases no longer open). Unfortunately, Nuget.org no longer offers a rollback to 1.0.112, so I had to do a source code rollback of my project to return to a functional build.

Is there a way to get ChangePassword support back? Why was it dropped?

Thanks,
-Pete

(2.1) By Ulrich Telle (utelle) on 2020-06-02 20:58:49 edited from 2.0 in reply to 1.0 [link] [source]

DRH and the SQLite developer team decided in February to remove the undocumented and officially unsupported SQLITE_HAS_CODEC feature (see DRH's response to a similar question a few days ago). SQLite version 3.32.x was the first released version affected by this change.

System.Data.SQLite 1.0.113.1 is based on SQLite version 3.32.1, and is therefore also affected.

Taking into account that the SQLITE_HAS_CODEC feature was around in the SQLite code base for about 15 years or so, it was a bit unfortunate that its removal was not even mentioned in the release notes. However, for undocumented features one has to live with such decisions, unfortunately.

(3) By Peter Bickford (pbickford) on 2020-06-02 21:46:43 in reply to 1.0 [link] [source]

Ugh. I'm currently shipping a consumer solution based on the Password facility that was built into SQLite until the February build. I'm not sure I entirely follow the implications here, but it does sound like implementing any sort of compatible scheme with existing customer databases is likely going to be quite the project if this feature is removed.

Any chance of restoring the Nuget System.Data.SQLite 1.0.112 package on nuget.org to make rolling back/installing compatible versions with the Password facility possible? (As is, there's a fair amount of surgery/tricky manual version component installs required to spin up a System.Data.Sqlite-based Visual Studio solution targeting databases which use the legacy Password encoding.). It would definitely be a big help if there were a way to checkpoint our projects back to the last supported version.

(4) By Gerhard (tagelus) on 2020-06-08 12:59:00 in reply to 3 [source]

Yes, same problem here. I'm in the middle of my beta test and didn't see this coming. Rolling out an unencrypted db for now is not a problem, but I'd love to have a solution to this

(5) By Stephan Beal (stephan) on 2020-06-08 13:18:16 in reply to 4 [link] [source]

Rolling out an unencrypted db for now is not a problem, but I'd love to have a solution to this.

Richard (the project lead), posted that it was never a documented or supported feature. The solution is to license SEE.

(6) By Gerhard (tagelus) on 2020-06-13 06:46:57 in reply to 5 [link] [source]

I got SQLiteCrypt to work. Perfect for my purpose and it doesn't cost like $2000. Also got rid of the Nuget package, cleans things up nicely

(9) By Nando (nandostyle) on 2020-07-23 02:08:20 in reply to 6 [link] [source]

But, it is not open source. Or is it? Trust no one!

(10) By diynesia on 2020-07-28 10:19:46 in reply to 4 [link] [source]

I tried to retrieve older version by modify the link from new one For example:

Modify this link

https://system.data.sqlite.org/blobs/1.0.113.0/sqlite-netFx40-setup-bundle-x64-2010-1.0.113.0.exe

to

https://system.data.sqlite.org/blobs/1.0.112.0/sqlite-netFx40-setup-bundle-x64-2010-1.0.112.0.exe

And VOILA !!!

Disclaimer : -Above method is work per 2020/07/20 -Not all version worked

(7) By anonymous on 2020-07-18 07:05:08 in reply to 1.1 [link] [source]

To install System.Data.SQLite.Core 1.0.112.2 from the Package Manager Console within Visual Studio, run the following command:

Install-Package System.Data.SQLite.Core -Version 1.0.112.2 -Source http://nuget.yuanbei.biz/nuget/Default

(8) By Nando (nandostyle) on 2020-07-23 02:05:22 in reply to 7 [link] [source]

You beat me to this comment. This will help many! It was hard to find how to install an earlier version.

(11) By anonymous on 2020-11-16 02:39:49 in reply to 7 [link] [source]

Thank you :)

(12) By anonymous on 2021-08-30 14:59:08 in reply to 7 [link] [source]

Thanks! This works for me, but I still need Stub.System.Data.SQLite.Core.NetFramework for my project. But doing the same kind of NuGet console command doesn't work for me when trying to get a version 1.0.112 or 1.0.112.2. Any ideas?