C#•5mo ago

✅ trying to figure out SQLite database encryption

Trying to add a password to my SQLite database

SQLiteConnection connection = new SQLiteConnection(AuthDBConnection);
connection.Open();
connection.ChangePassword("password");

SQLiteConnection connection = new SQLiteConnection(AuthDBConnection);
connection.Open();
connection.ChangePassword("password");

i get an error on the change password line

'System.Data.SQLite.SEE.License, Version=1.0.118.0, Culture=neutral, PublicKeyToken=0a9a2a02614f8a52, processorArchitecture=MSIL'. The system cannot find the file specified.
File name: 'System.Data.SQLite.SEE.License, Version=1.0.118.0, Culture=neutral, PublicKeyToken=0a9a2a02614f8a52, processorArchitecture=MSIL'
   at System.Reflection.RuntimeAssembly.InternalLoad(AssemblyName assemblyName, StackCrawlMark& stackMark, AssemblyLoadContext assemblyLoadContext, RuntimeAssembly requestingAssembly, Boolean throwOnFileNotFound)
   at System.Reflection.Assembly.Load(String assemblyString)
   at System.Data.SQLite.SQLiteExtra.InnerVerify(String argument)
   at System.Data.SQLite.SQLiteExtra.Verify(String argument)
   at System.Data.SQLite.SQLite3.ChangePassword(Byte[] newPasswordBytes, Boolean asText)
   at System.Data.SQLite.SQLiteConnection.ChangePassword(Byte[] newPassword)
   at System.Data.SQLite.SQLiteConnection.ChangePassword(String newPassword)
   at Program.ConnectToAuth() in C:\Users\evanriker\Desktop\Ward Management\MyWardDataLayer\MyWardDataLayer\Program.cs:line 70
   at Program.InitializeDatabase() in C:\Users\evanriker\Desktop\Ward Management\MyWardDataLayer\MyWardDataLayer\Program.cs:line 89
   at Program.Main(String[] args) in C:\Users\evanriker\Desktop\Ward Management\MyWardDataLayer\MyWardDataLayer\Program.cs:line 606

'System.Data.SQLite.SEE.License, Version=1.0.118.0, Culture=neutral, PublicKeyToken=0a9a2a02614f8a52, processorArchitecture=MSIL'. The system cannot find the file specified.
File name: 'System.Data.SQLite.SEE.License, Version=1.0.118.0, Culture=neutral, PublicKeyToken=0a9a2a02614f8a52, processorArchitecture=MSIL'
   at System.Reflection.RuntimeAssembly.InternalLoad(AssemblyName assemblyName, StackCrawlMark& stackMark, AssemblyLoadContext assemblyLoadContext, RuntimeAssembly requestingAssembly, Boolean throwOnFileNotFound)
   at System.Reflection.Assembly.Load(String assemblyString)
   at System.Data.SQLite.SQLiteExtra.InnerVerify(String argument)
   at System.Data.SQLite.SQLiteExtra.Verify(String argument)
   at System.Data.SQLite.SQLite3.ChangePassword(Byte[] newPasswordBytes, Boolean asText)
   at System.Data.SQLite.SQLiteConnection.ChangePassword(Byte[] newPassword)
   at System.Data.SQLite.SQLiteConnection.ChangePassword(String newPassword)
   at Program.ConnectToAuth() in C:\Users\evanriker\Desktop\Ward Management\MyWardDataLayer\MyWardDataLayer\Program.cs:line 70
   at Program.InitializeDatabase() in C:\Users\evanriker\Desktop\Ward Management\MyWardDataLayer\MyWardDataLayer\Program.cs:line 89
   at Program.Main(String[] args) in C:\Users\evanriker\Desktop\Ward Management\MyWardDataLayer\MyWardDataLayer\Program.cs:line 606

36 Replies

hutoanhillOP•5mo ago

is there something wrong with my SQLite install?

Angius•5mo ago

The system cannot find the file specified. Seems like the SQLite file you pointed at does not exist

Jimmacle•5mo ago

that looks like it's failing to load a DLL, not a database file

hutoanhillOP•5mo ago

DLL file... thats somthing to do with the NuGet module right?

Jimmacle•5mo ago

potentially

Unknown User•5mo ago

Message Not Public

Jimmacle•5mo ago

https://stackoverflow.com/questions/76184374/could-not-load-file-or-assembly-system-data-sqlite-see-license-version-1-0-11

Stack Overflow

Could not load file or assembly 'System.Data.SQLite.SEE.License, Ve...

I am facing error with window form application with .net framework. I have successfully built a SQLite database through application but when I am going to update the database it give me below error.

Jimmacle•5mo ago

tl;dr downgrade your sqlite package version, the library that supports password protection is no longer supported

Unknown User•5mo ago

Message Not Public

hutoanhillOP•5mo ago

step 4 mentions a SDS-SEE.exml file. what is this and where can i find it

Unknown User•5mo ago

Message Not Public

Jimmacle•5mo ago

google it and if you do you'll see that it costs $2500 a year https://sqlite.org/purchase/sds

Unknown User•5mo ago

Message Not Public

hutoanhillOP•5mo ago

am not

Unknown User•5mo ago

Message Not Public

Jimmacle•5mo ago

sqlite encryption does not appear to be free, no

hutoanhillOP•5mo ago

no idea. ive just been googling how to secure a sqlite database. darn

Jimmacle•5mo ago

secure it from who

Unknown User•5mo ago

Message Not Public

hutoanhillOP•5mo ago

i am building a authentication api for a seprate database. i am using SQLite to store login credentials and i would like it to be extremely annoying for anything other than my application to get at that data

Unknown User•5mo ago

Message Not Public

Jimmacle•5mo ago

hutoanhillOP•5mo ago

eventually it will be a web app that calls my API.

Unknown User•5mo ago

Message Not Public

hutoanhillOP•5mo ago

doing that

Unknown User•5mo ago

Message Not Public

Jimmacle•5mo ago

then what's the point in encrypting on top of it

Unknown User•5mo ago

Message Not Public

Jimmacle•5mo ago

also what tebe is saying, use a proper db

Unknown User•5mo ago

Message Not Public

Jimmacle•5mo ago

if i wasn't currently using AD for auth i'd just be storing hashes in the main application database no need to overcomplicate it

Unknown User•5mo ago

Message Not Public

hutoanhillOP•5mo ago

ok. This is my first time doing something like this and i've been leaning on the side of paranoia

Unknown User•5mo ago

Message Not Public

hutoanhillOP•5mo ago

will look into this. thanks

Unknown User•5mo ago

Message Not Public

Gaming

Programming

✅ trying to figure out SQLite database encryption