Apache authentication in Ubuntu

I. verification of username and password created based on htpasswd 1. create the user name and password file touch-f/tmp/shou /. passwdhtpasswd-B/tmp/shou /. passwdshoutest1234 ※htpasswd command usage reference: http://www.linuxidc.com/linux/2012-11/73915.htm2.

1. Authentication of username and password created based on htpasswd
1. Create a user name and password file

Touch-f/tmp/shou/. passwd
Htpasswd-B/tmp/shou/. passwd shou test1234

※Htpasswd command usage reference: http://www.linuxidc.com/Linux/2012-11/73915.htm
2. Configure the/etc/apache2/sites-available/default file

1. Alias/test "/tmp/shou/test"
3. Options Indexes FollowSymLinks MultiViews
4. AllowOverride None
5. Order allow, deny
6. Allow from all
8. AuthName "Authorization TEST (01 )"
9. AuthType Basic
10. AuthUserFile/tmp/shou/. passwd
12. Require valid-user

Ii. Verification Based on MySQL database table information

1. Install the mod_auth_mysql module for MySQL verification.

Sudo apt-get install libapache2-mod-auth-mysql

2. Activate the mode_auth_mysql module.

Cd/etc/apache2/mod-enabled

Ln-s ../mod-available/auth_mysql.load

3. Create a database table and add data

1. Create table tbl_user (
2. Id integer not null primary key AUTO_INCREMENT,
3. Username VARCHAR (128) not null,
4. Password VARCHAR (128) not null,
5. E-mail VARCHAR (128) NOT NULL
6. );
7. Insert into tbl_user (username, password, email) VALUES ('test1', 'pass1', 'test1 @ example.com ');
8. Insert into tbl_user (username, password, email) VALUES ('test2', 'passs2 ', 'test2 @ example.com ');

4. Configure the/etc/apache2/sites-available/default file

1. Alias/test1 "/tmp/shou/test1"
3. Options Indexes FollowSymLinks MultiViews
4. AllowOverride None
5. Order allow, deny
6. Allow from all
7. AuthName "Authorization TEST (02 )"
8. AuthType Basic
9. Auth_MySQL On
10. Auth_MySQL_Authoritative On
11. Auth_MySQL_Host localhost
12. Auth_MySQL_Username root
13. Auth_MySQL_Password rootadmin
14. Auth_MySQL_DB test
15. Auth_MySQL_Password_Table tbl_user
16. Auth_MySQL_Username_Field username
17. Auth_MySQL_Password_Field password
18. Auth_MySQL_Encryption_Types Plaintext
19. Auth_MySQL_Empty_Passwords Off
20. AuthBasicAuthoritative Off
21. AuthUserFile/dev/null
23. Require valid-user