pam_mysql 安装配置总结 (结合vsftpd).docxVIP

pam_mysql 安装配置总结 (结合vsftpd) 2009-10-29 13:27:09标签：pam_mysqlvsftpd前一段时间，论坛里总有朋友问到pam-mysql的安装问题。比较典型的有：vsftp1.2+mysql4.1+pam_mysql0.5在RedHat AS4(32bit)下好像是有bug还是mysql虚拟用户和vsftpd的登陆问题?为了解答类似的问题，我动手试验了一下vsftpd+pam-mysql的配置过程，总结如下:系统环境：* RedHat AS 4* MySQL 4.1.15* pam_mysql-0.7pre3说明一下，MySQL我是使用其官方网站的rpm包安装的，包括下面这4个：1. MySQL-server-standard-4.1.15-0.rhel4.i386.rpm2. MySQL-client-standard-4.1.15-0.rhel4.i386.rpm3. MySQL-devel-standard-4.1.15-0.rhel4.i386.rpm4. MySQL-shared-standard-4.1.15-0.rhel4.i386.rpmvsftpd是RedHat自带的。建立用于存放vsftpd虚拟用户的Schema的过程：[Copy to clipboard][ - ]CODE:mysql create database vsftpd;mysql use vsftpd;mysql create table users (- id int AUTO_INCREMENT NOT NULL,- name char(16) binary NOT NULL,- passwd char(48) binary NOT NULL,- primary key(id)- );mysql describe users;+--------+----------+------+-----+---------+----------------+| Field | Type | Null | Key | Default | Extra |+--------+----------+------+-----+---------+----------------+| id | int(11) | | PRI | NULL | auto_increment || name | char(16) | | | | || passwd | char(48) | | | | |+--------+----------+------+-----+---------+----------------+mysql create table logs (msg varchar(255),- user char(16),- pid int,- host char(32),- rhost char(32),- logtime timestamp- );mysql describe logs;+---------+--------------+------+-----+-------------------+-------+| Field | Type | Null | Key | Default | Extra |+---------+--------------+------+-----+-------------------+-------+| msg | varchar(255) | YES | | NULL | || user | varchar(16) | YES | | NULL | || pid | int(11) | YES | | NULL | || host | varchar(32) | YES | | NULL | || rhost | varchar(32) | YES | | NULL | || logtime | timestamp | YES | | CURRENT_TIMESTAMP | |+---------+--------------+------+-----+-------------------+-------+这里，用户密码这个字段的长度是48。这是根据MySQL加密函数的返回值的长度确定的。关于PASSWORD函数返回值的长度，可以参考这个：/doc/refman/4.1/en/password-hashing.html[Copy to clipboard][ - ]CODE:mysql select encrypt(foo);+----------------+| encrypt(foo) |+----------------+| 4Wwn2AXFYb.So |+------