It's better when it's simple

User Tools

Site Tools


authsqlite Plugin

Compatible with DokuWiki

  • 2017-02-19 "Frusterick Manners" unknown
  • 2016-06-26 "Elenor Of Tsort" unknown
  • 2015-08-10 "Detritus" unknown
  • 2014-09-29 "Hrun" yes

plugin Authentication against an SQLite database, with per animal group management in farms.

Last updated on

Similar to authmysql, authpgsql

Tagged with authentication, sqlite


:!: External requirements: This plugin requires the following additional components that must be installed separately:

  • PHP greater than 5.2.0 for proper SQLite3 support.

Install the plugin using the Plugin Manager and the download URL above, which points to latest version of the plugin. Refer to Plugins on how to install plugins manually.


Create an authentication database in a folder which is readable and writeable by your web server, but outside of DOCUMENT_ROOT.

sqlite3 /var/wikiauth/auth.db < auth.sql

The auth.sql file is provided with the plugin. As written it will support a single user database for all animals in your farm, but per-animal group management.

Configuration and Settings

Configuration of the SQLite queries is detailed in the file distributed with the plugin, or available at

The SQLite Database File configuration option should be a full path, and outside of your web server's DOCUMENT_ROOT folder. Otherwise it is trivial for somebody to download the file and gather all your user information.

Your First User

Getting your first user into the database is done like other database authentication mechanisms.

  • Create the database as described above.
  • Copy the username and password hash into the database from the user entry in DOKU_CONF/local.auth.php
  • Create user and admin groups.
  • Link the user to the new groups via the usergroups table.

The SQL to do that might look like this:

INSERT INTO user (login, pass) VALUES ('admin', '$1$abc123');


INSERT INTO groups (name) VALUES ('user');
INSERT INTO groups (name) VALUES ('admin');

SELECT * FROM groups;
INSERT INTO usergroup (uid, gid) VALUES (1, 1);
INSERT INTO usergroup (uid, gid) VALUES (1, 2);

Change Log

  • 2015-06-25
    • Initial release

Known Bugs and Issues

Please see the bug tracker above for current issues.


plugin/authsqlite.txt · Last modified: 2016-04-28 18:19 by