DB Auth Storage

All Plugins / Auth / Sql

Identity Card

StatusCore
Plugin LabelDB Auth Storage
Short DescriptionStores the Authentication data in an SQL database.
Plugin Identifierauth.sql
AuthorCharles du Jeu
Urldocs/references/plugins/auth/sql
Dependencies

Documentation

Stores the users data inside a database. It is database generic, the connexion to the database must be described in an array, see http://dibiphp.com/cs/ for more info on databases supported and configurations. A create.sql file is included to generated the necessary table for storing users data.

This is the default user's store for Pydio.

The driver options are defined at install, internally it is an array like this.

    "SQL_DRIVER"	=> array(
        "driver"        => "mysql",
        "host"          => "localhost",
        "database"      => "ajxp",
        "user"          => "user",
        "password"      => "pass",
    );
    

Plugin parameters

LabelDescriptionTypeDefault
Core Connexion *
core_driver
Driver type (do not touch)Hiddencore
Driver *
mysql_driver
Driver type (do not touch)Hiddenmysql
Host *
mysql_host
Database serverStringlocalhost
Database *
mysql_database
Database nameStringpydio
User *
mysql_username
User nameString
Password *
mysql_password
User passwordPassword
Use MySQLi *
mysql_use_mysqli
Use PHP MySQLi extensionBooleantrue
Driver *
sqlite3_driver
Driver type (do not touch)Hiddensqlite3
formatDate *
sqlite3_formatDate
formatDate (do not touch)Hidden'Y-m-d'
formatDateTime *
sqlite3_formatDateTime
formatDateTime (do not touch)Hidden'Y-m-d H:i:s'
File *
sqlite3_database
Database fileStringAJXP_DATA_PATH/plugins/conf.sql/pydio.db
Driver *
postgre_driver
Driver type (do not touch)Hiddenpostgre
Host *
postgre_host
Database serverStringlocalhost
Database *
postgre_database
Database nameStringpydio
User *
postgre_username
User nameString
Password *
postgre_password
User passwordPassword

Instance parameters

LabelDescriptionTypeDefault
Connection *
SQL_DRIVER
The Database ConnectionGroup_switch:dibicore
SQL Tables
INSTALL_SQL
Install SQL TablesButton
Auth Driver Commons
Auto Create User
AUTOCREATE_AJXPUSER
When set to true, the user object is created automatically if the authentication succeed. Used by remote authentication systems.Booleanfalse
Login Redirect
LOGIN_REDIRECT
If set to a given URL, the login action will not trigger the display of login screen but redirect to this URL.String
Administrator Login
AJXP_ADMIN_LOGIN
For exotic auth drivers, an user ID that must be considered as admin by default.String
Auto apply role
AUTO_APPLY_ROLE
For multiple authentication, apply this role to users authenticated via this driverString