xpra icon
Bug tracker and wiki

Opened 3 weeks ago

Last modified 5 days ago

#1488 assigned enhancement

Authorisation. New module - sql

Reported by: Denis01 Owned by: Antoine Martin
Priority: major Milestone: 2.2
Component: server Version: trunk
Keywords: Cc:

Description

Create possibility to keep the users records (like multifile records structure) in mySQL table

Attachments (1)

sql-auth-stub.patch (2.8 KB) - added by Antoine Martin 5 days ago.
stub for sql auth

Download all attachments as: .zip

Change History (3)

comment:1 Changed 3 weeks ago by Antoine Martin

Component: androidserver
Milestone: 2.2
Status: newassigned

Will be useful for things like #1486 and may allow us to move away from multifile.
With a sqlite backend, we could easily provide a simple GUI too.

Changed 5 days ago by Antoine Martin

Attachment: sql-auth-stub.patch added

stub for sql auth

comment:2 Changed 5 days ago by Antoine Martin

It would make sense to eventually move the common SQL code to a utility superclass, so this auth module should be called "sqliteauth".

Then we can also have a "mysqlauth" and "postgresqlauth", etc..
All the connectors should follow the PEP 249 : Python Database API Specification v2.0

The "sqliteauth" module can take a single specific parameter: the path to the database file, whereas the other SQL auth modules will require extra parameters: host, port, username, password, database name, etc
All the SQL auth modules should use the "password_query" and "sessions_query" (this one can be made optional) as per the stub patch, moved to the superclass.

Note: See TracTickets for help on using tickets.