1
File-based Authentication
2
=========================
4
.. warning:: :program:`auth_file` is a security risk! Do not use this plugin with production servers!
6
:program:`auth_file` is an authentication plugin that authenticates connections
7
using a list of ``username:password`` entries in a plain text file.
9
.. note:: Unload the :doc:`/plugins/auth_all/index` plugin before using this plugin.
10
.. seealso:: :doc:`/administration/authentication`
12
.. _auth_file_loading:
17
To load this plugin, start :program:`drizzled` with::
19
--plugin-add=auth_file
21
Loading the plugin may not enable or configure it. See the plugin's
22
:ref:`auth_file_configuration` and :ref:`auth_file_variables`.
24
.. seealso:: :doc:`/options` for more information about adding and removing plugins.
26
.. _auth_file_configuration:
31
These command line options configure the plugin when :program:`drizzled`
32
is started. See :doc:`/configuration` for more information about specifying
37
.. option:: --auth-file.users ARG
39
:Default: :file:`BASEDIR/etc/drizzle.users`
40
:Variable: :ref:`auth_file_users <auth_file_users>`
42
File to load for usernames and passwords.
44
.. _auth_file_variables:
49
These variables show the running configuration of the plugin.
50
See `variables` for more information about querying and setting variables.
58
:Option: :option:`--auth-file.users`
60
File to load for usernames and passwords.
62
.. _auth_file_examples:
67
First, create a :file:`users` file with one ``user:pass`` entry per line, like::
72
Then start :program:`drizzled` like::
74
sbin/drizzled --plugin-remove=auth_all \
75
--plugin-add=auth_file \
76
--auth-file.users=/path/to/my/users
81
ERROR 1045 (28000): Access denied for user 'daniel' (using password: NO)
83
$ drizzle --user=user1
84
ERROR 1045 (28000): Access denied for user 'user1' (using password: NO)
86
$ drizzle --user=user1 --password=password1
87
Welcome to the Drizzle client.. Commands end with ; or \g.
90
.. _auth_file_authors:
97
.. _auth_file_version:
102
This documentation applies to **auth_file 0.1**.
104
To see which version of the plugin a Drizzle server is running, execute:
106
.. code-block:: mysql
108
SELECT MODULE_VERSION FROM DATA_DICTIONARY.MODULES WHERE MODULE_NAME='auth_file'