Comment 2 for bug 901242

Hi

Heres the stuff that you wanted (And some more:))

[root]# bin/mysql_config --plugindir
/db/test/server/lib/mysql/plugin

[root plugin]# ls -al
-rwxr-xr-x 1 root root 15546 Nov 19 09:47 auth_pam.so

TEST XtraDB (none)> INSTALL PLUGIN auth_pam_server SONAME 'auth_pam.so';
Query OK, 0 rows affected (0.03 sec)

TEST XtraDB (none)> show variables like 'plugin%';
+---------------+----------------------------------+
| Variable_name | Value |
+---------------+----------------------------------+
| plugin_dir | /db/test/server/lib/mysql/plugin |
+---------------+----------------------------------+

[root server]# ls -al /etc/pam.d/mysqld
-rw-r--r-- 1 root root 192 Dec 12 11:22 /etc/pam.d/mysqld

TEST XtraDB (none)> create user 'patlin'@'localhost' identified with auth_pam_server;
Query OK, 0 rows affected (0.01 sec)

[root server]# bin/mysql -upatlin -p
Enter password:
ERROR 2059 (HY000): Authentication plugin 'auth_pam' cannot be loaded: /usr/local/Percona-Server-5.5.13-rel20.4-138.Linux.x86_64/lib/plugin/auth_pam.so: cannot open shared object file: No such file or directory

TEST XtraDB (none)> SHOW PLUGINS;
+--------------------------------+----------+--------------------+-------------+---------+
| Name | Status | Type | Library | License |
+--------------------------------+----------+--------------------+-------------+---------+
| auth_pam_server | ACTIVE | AUTHENTICATION | auth_pam.so | GPL |
+--------------------------------+----------+--------------------+-------------+---------+

TEST XtraDB (none)> SELECT user,host,plugin,authentication_string FROM mysql.user WHERE user LIKE "patlin";
+--------+-----------+-----------------+-----------------------+
| user | host | plugin | authentication_string |
+--------+-----------+-----------------+-----------------------+
| patlin | localhost | auth_pam_server | |
+--------+-----------+-----------------+-----------------------+