Article Index
Zone security MySQL with Apache
Installing the module
Configuration and Usage
Configuration Options
Configuration ..

AuthMySQLEnable On | Off

  This enables or disables mod_auth_mysql authentication, without you having to remove or unload the  module from Apache directly.

AuthMySQLHost localhost | hostname | ipaddress

  This is the hostname or IP address of the MySQL database server. If your environment runs Apache and  MySQL on different machines, you'll need to use this. The default value is localhost, so machines running both Apache and MySQL can usually ignore this setting.

AuthMySQLPort port_number

  This is the TCP/IP port on which MySQL is listening. The default value for MySQL is port 3306, but can  be changed. The default value for this option is also 3306, so the option needs to be specified only if  MySQL is listening on a nonstandard port.

AuthMySQLSocket socket_file_path

  This is the UNIX socket file used to access MySQL on a UNIX machine. The default value is  /tmp/mysql.sock, and like AuthMySQLPort, it needs to be used only in nonstandard installations.

AuthMySQLUser userid

  This is the user ID used to access the MySQL database holding the authentication information. Most  database systems will not allow users or the Apache process to access the database without a proper  userid/password combination, so set this along with AuthMySQLPassword to a non-root user account  that has access to the authentication tables. At a minimum, the user will need SELECT access to the  authentication tables.

AuthMySQLPassword password

  Used in conjunction with AuthMySQLUser, this option specifies the password for the user account  accessing the MySQL authentication tables.

AuthMySQLDB dbname

  This is the name of the database in MySQL that holds the authentication tables. If no name is specified,  the default value of test will be used.
 

AuthMySQLUserTable table_name

This is the name of table in the database that holds the usernames and passwords. If no table is specified, the default value of user_info is used.

AuthMySQLNameField column_name

This is the name of the column in the user table (AuthMySQLUserTable) that holds the usernames. When creating the tables in MySQL, ensure that this column has an index or key, ensuring each value is unique. The =length of the column is whatever you decide it should be in MySQL. The default value  is user_name.

AuthMySQLUserCondition

When mod_auth_mysql performs a user lookup, it performs a simple SQL SELECT statement, with any criteria needed to perform a match. The AuthMySQLUserCondition field allows you to specify extra parameters to be used in the WHERE clause of the SQL statement.

AuthMySQLPasswordField column_name

This is the name of the column in the user table that holds the users' passwords. The length of the column in MySQL should be at least as long as the encrypted password hash. The default value for AuthMySQLPasswordField is user_password.