| Ticket Hash: | 3eb097e917a7740f3499aae66e9a3cd021e9f81c | ||
| Title: | Could not determine incorrect password | ||
| Status: | Closed | Type: | Incident |
| Severity: | Important | Priority: | Medium |
| Subsystem: | Connection | Resolution: | Works_As_Designed |
| Last Modified: |
2014-02-04 02:53:32 11.21 years ago |
Created: |
2014-02-04 00:28:50 11.21 years ago |
| Version Found In: | 1.0.90.0 from NuGet | ||
| User Comments: | ||||
anonymous added on 2014-02-04 00:28:50:
Hello. Sorry for my bad English.
I use SQLite latest version and attemt to determine when password is wrong. I use this code:
var connectionString = new SQLiteConnectionStringBuilder
{
DataSource = dataSource, // (1) admin.db3, (2) admin.db3
Version = 3,
Password = password // (1) admin, (2) password
}.ToString();
SQLiteConnection connection = new SQLiteConnection(connectionString);
connection.Authorize += (sender, args) => Debug.WriteLine(args);
connection.Open();
connection.Close(); // (2) breakpoint
Test case:
(1) I create DB with DataSource = "admin.db3", Password = "admin"
(2) I connect to DB with DataSource = "admin.db3", Password = "password"
I expect throwing Exception or anything else, but nothing happens. At the breakpoint I see, that Status == Opened, ResultCode == Ok, ExtendedResultCode == Ok
Below this code begins NHibernate initialization, that logging "SQLite error (26): file is encrypted or is not a database" and not throwing Exception too.
As a result, I can find out about incorrect password only catching log from NHibernate.
I will be glad to help. Thank you for all that you do.
mistachkin added on 2014-02-04 02:53:23: This is by design. The error message only occurs when you try to read from -OR- write to the underlying database file. Opening the database does not typically perform either operation. It is recommended that you execute a SELECT statement on some well-known table (e.g. "sqlite_master") immediately after opening the database in order to determine if it is in a usable state. | ||||