##2.基础服务(SQl,RabbitMQ)--openstack

##2.基础服务(MysqlSQL,RabbitMQ)

#SQL root密码
DBPass=open2017

# #------------------
#SQL数据库
yuminstall mariadb mariadb-server python2-PyMySQL -y
cp /etc/my.cnf.d/openstack.cnf{,.bak}
echo"#[mysqld]
bind-address = 0.0.0.0
default-storage-engine = innodb
innodb_file_per_table
max_connections = 4096
collation-server = utf8_general_ci
character-set-server = utf8
#">/etc/my.cnf.d/openstack.cnf#启动数据库服务
systemctl enable mariadb.service
systemctl start mariadb.service
netstat -antp|grep mysqld
#mysql_secure_installation #初始化设置密码,自动交互
[[ -f /usr/bin/expect ]] || { yuminstall expect -y; } #若没expect则安装
/usr/bin/expect << EOF
set timeout 30
spawn mysql_secure_installation
expect {
    "enter for none" { send "\r"; exp_continue}
    "Y/n" { send "Y\r" ; exp_continue}
    "password:" { send "$DBPass\r"; exp_continue}
    "new password:" { send "$DBPass\r"; exp_continue}
    "Y/n" { send "Y\r" ; exp_continue}
    eof { exit }
}
EOF
#测试
mysql -u root -p$DBPass -e "show databases;"
[ $? = 0 ] || { echo"mariadb初始化失败";exit; }

#数据库配置，创建数据库、用户授权
#mysql -u root -p 
mysql -u root -p$DBPass -e "
create database keystone;
grant all privileges on keystone.* to ‘keystone‘@‘localhost‘ identified by ‘keystone‘;
grant all privileges on keystone.* to ‘keystone‘@‘%‘ identified by ‘keystone‘;
create database glance;
grant all privileges on glance.* to ‘glance‘@‘localhost‘ identified by ‘glance‘;
grant all privileges on glance.* to ‘glance‘@‘%‘ identified by ‘glance‘;

create database nova;
grant all privileges on nova.* to ‘nova‘@‘localhost‘ identified by ‘nova‘;
grant all privileges on nova.* to ‘nova‘@‘%‘ identified by ‘nova‘;
create database nova_api;
grant all privileges on nova_api.* to ‘nova‘@‘localhost‘ identified by ‘nova‘;
grant all privileges on nova_api.* to ‘nova‘@‘%‘ identified by ‘nova‘;
create database nova_cell0;
grant all privileges on nova_cell0.* to ‘nova‘@‘localhost‘ identified by ‘nova‘;
grant all privileges on nova_cell0.* to ‘nova‘@‘%‘ identified by ‘nova‘;

create database neutron;
grant all privileges on neutron.* to ‘neutron‘@‘localhost‘ identified by ‘neutron‘;
grant all privileges on neutron.* to ‘neutron‘@‘%‘ identified by ‘neutron‘;

flush privileges;
select user,host from mysql.user;
show databases;
"
#

# create database cinder;
# grant all privileges on cinder.* to ‘cinder‘@‘localhost‘ identified by ‘cinder‘;
# grant all privileges on cinder.* to ‘cinder‘@‘%‘ identified by ‘cinder‘;

# #------------------
sleep1

# #------------------
#RabbitMQ #消息队列
yum -y install erlang socat
yuminstall -y rabbitmq-server
#启动 rabbitmq ,端口5672
systemctl enable rabbitmq-server.service
systemctl start rabbitmq-server.service
rabbitmq-plugins enable rabbitmq_management  #启动web插件端口15672
#添加用户及密码
rabbitmqctl  add_user admin admin
rabbitmqctl  set_user_tags admin administrator
rabbitmqctl add_user openstack openstack 
rabbitmqctl set_permissions openstack ".*"".*"".*" 
rabbitmqctl  set_user_tags openstack administrator
systemctl restart rabbitmq-server.service
netstat -antp|grep‘5672‘

# rabbitmq-plugins list  #查看支持的插件
# lsof -i:15672
#访问RabbitMQ,访问地址是http://ip:15672
#默认用户名密码都是guest，浏览器添加openstack用户到组并登陆测试