17.case腳本
~]#vim /etc/boot/foo/sh
#!/bin/bash
case $1 in
echo "RedHat"
;;
redhat)
echo "fedora"
;;
*)
echo "/root/foo.sh redhat|fedora"
esac
~]# chmod +x /root/foo.sh
18.添加使用者腳本????
~]#vim/root/batchusers.sh
#!/bin/bash
if [$# -eq 0 ];then
echo "Usage:/root/batchusers"
exit 1
fi
if [! -f $1];then
echo "input file not found"
exit 1
fi
for i in $(cat $1);do
useradd -s /bin/false $i;
done
~]# chmod +x /root/batchusers.sh
19.ISCSI服務
~]# fdisk -l /dev/vda
~]#yum install -y targetcli
~]#targetcli
/> ls
/> cd backstores/
/> cd block
/> create disk1 /dev/vda1
/> cd ..
/> cd ..
/> cd iscsi
/> create iqn.2014-11.com.example:server0
/> cd iqn.2014-11.com.wxample:server0/tpg1/
/> ls
/> luns/ create /backstores/block/disk1
/> acls/ create iqn.2014-11.com.example:desktop0
/> portals/ create 172.25.0.11
/> exit
~]#fire-cmd --add-port=3260/tcp --permanent
~]#fire-cmd --reload
~]#systemctl enaable target
~]#systemctl start targe
20.配置ISCSI服務用戶端
~]# yum install iscsi* -y
~]#vim /ettc/iscsi/initiatorname.iscsi
InitiatorName=iqn.2014-11.com.example:desktop0
~]#iscsiadm -t st -m discovery -p 172.25.0.11
~]#iscsiadm -m node -T iqn.2014-11.com.example:server0 -p 172.25.0.11 -l
~]#fdisk -l
~]#fdisk /dev/sdc分區
~]#mkfs.ext4 /dev/sd...
~]#mkdir /mnt/data
~]#vim /etc/fstab
UUID= /mnt/data ext4 defaults,_netdev 0 0
~]#mount -a
21.配置資料庫
~]# yum groupinstall"mariadb*"-y
~]# systemctl start mariadb
~]# systemctlenablemariadb
~]# mysql_secure_installation
~]# mysql -u root -p
MariaDB >CREATE DATABASEContacts;
MariaDB >quit
~]# mysql -u root -p Contacts< /root/users.mdb
22.查詢資料庫
~]# mysql -u root -p
MariaDB >use Contacts;
MariaDB >show tables;
MariaDB >create user [email protected] identified by 'redhat';
MariaDB >grant select on Contacts.* to [email protected];
MariaDB >flush privileges;
MariaDB >select * from pass inner join name where name.aid=pass.bid;
MariaDB >select * from pass inner join name on name.aid=pass.bid wherepassword='tangerine';
MariaDB >select * from name inner join loc on name.aid=loc.cid wherefirstname='John' and loction='guangzhou';
