SQlite account (user authentication)

[Petr Novak]

Hello all,

I have database SQLite "name.db" (Use to access using the username and password) Account save tables "sqlite_user"

When a Database is opened via phpLiteAdmin I do not see any tables...

Can not open database that uses accounts?

[phpLiteAdmin]

I guess you are talking about user authentication as discussed here:

http://www.sqlite.org/src/doc/trunk/ext/userauth/user-auth.txt

I will have a look at this. Thanks for reporting this. In case you can provide a sample database file that requires user authentication for testing, this would be helpful.

[phpLiteAdmin]

I cannot find an interface for this in PHP's Sqlite3 extension so far. The SQLite changelog states this extension was introduced in SQLite 3.8.7. The PHP changelog states that SQLite 3.8.7.2 was included in PHP 5.5.21,but I know newer PHP versions with older SQLite extensions exists in some linux distributions....

[phpLiteAdmin]

I think PHP does not yet support user authentication for SQLite yet. I cannot find sqlite3_user_authenticate() in PDOs sqlite_driver.c even in PHP7. Same for the SQlite3's sqlite3.c. Without PHP supporting user authentication, phpLiteAdmin won't be able to do so... So I guess you need to go over to PHP's bug tracker.

[phpLiteAdmin]

Still I cannot find a a way to use sqlite user authentication in PHP, even in PHP 8.0.9. So there is still no way to use this in phpLiteAdmin.