pam-mysql 安装_pam_mysql安装

yum install -y gcc gcc-c++ gcc4-c++ autoconf gd gd-devel libxml2 libxml2-devel zlib-devel glibc glibc-devel glib2 glib2-devel bzip2 bzip2-devel ncurses ncurses-devel curl curl-devel e2fsprogs e2fsprogs-devel krb5 krb5-devel libidn libidn-devel openssl openssl-devel expat expat-devel sqlite sqlite-devel png-devel jpeg-devel libtool libjpeg* libpng* freetype-devel pam-devel

wget http://autosetup1.googlecode.com/files/myget-0.1.2.tar.gz

tar -zxvf myget-0.1.2.tar.gz

cd myget-0.1.2

./configure

make;make install

cd ..

/usr/local/bin/mytget -n 10 -f mysql-5.1.31.tar.gz http://autosetup1.googlecode.com/files/mysql-5.1.31.tar.gz

tar -zxvf mysql-5.1.31.tar.gz

cd mysql-5.1.31

./configure --prefix=/usr/local/mysql/ --enable-assembler --with-extra-charsets=complex --enable-thread-safe-client --with-big-tables --with-readline --with-ssl --with-embedded-server --enable-local-infile --with-plugins=innobase

make;make install

cd ..

groupadd mysql

useradd -g mysql mysql

cp /usr/local/mysql/share/mysql/my-medium.cnf /etc/my.cnf

sed -i 's/skip-federated/#skip-federated/g' /etc/my.cnf

/usr/local/mysql/bin/mysql_install_db --user=mysql

chmod +w /usr/local/mysql

chown -R mysql /usr/local/mysql/var

chgrp -R mysql /usr/local/mysql/.

cp /usr/local/mysql/share/mysql/mysql.server /etc/init.d/mysql

chmod 755 /etc/init.d/mysql

chkconfig --level 345 mysql on

service mysql start

/usr/local/mysql/bin/mysqladmin -u root password root

echo "/usr/local/mysql/lib/mysql" >> /etc/ld.so.conf

ldconfig

ln -s /usr/local/mysql/lib/mysql /usr/lib/mysql

ln -s /usr/local/mysql/include/mysql /usr/include/mysql

service mysql stop

service mysql start

wget http://autosetup2.googlecode.com/files/pam_mysql-0.7RC1.tar.gz

tar -zxvf pam_mysql-0.7RC1.tar.gz

cd pam_mysql-0.7RC1

./configure --with-openssl --with-mysql=/usr/local/mysql

make;make install

echo "/lib/security" >> /etc/ld.so.conf

ldconfig

/usr/local/mysql/bin/mysql -u root -proot

create database if not exists `pam`;

USE `pam`;

SET FOREIGN_KEY_CHECKS=0;

/*数据表 `admin` 的表结构*/

DROP TABLE IF EXISTS `admin`;

CREATE TABLE `admin` (

`id` int(10) NOT NULL AUTO_INCREMENT,

`name` varchar(50) NOT NULL,

`password` varchar(50) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

/*数据表 `admin` 的数据*/

LOCK TABLES `admin` WRITE;

insert into `admin` values

(1,'admin','admin');

UNLOCK TABLES;

/*数据表 `user` 的表结构*/

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (

`id` int(20) NOT NULL AUTO_INCREMENT,

`name` varchar(50) NOT NULL,

`password` varchar(50) NOT NULL,

`active` int(10) DEFAULT '1',

PRIMARY KEY (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

/*数据表 `user` 的数据*/

LOCK TABLES `user` WRITE;

insert into `user` values

(1,'test','test',1);

vi /etc/pam.d/pam

auth required /lib/security/pam_mysql.so user=root passwd=root host=localhost db=pam table=user usercolumn=name passwdcolumn=password where=active=1 sqllog=0 crypt=0

account required /lib/security/pam_mysql.so user=root passwd=root host=localhost db=pam table=user usercolumn=name passwdcolumn=password where=active=1 sqllog=0 crypt=0

testsaslauthd -u test -p test -s pam