Monthly Report Generation
Base on daily records to generate monthly report:
Example:
select to_char(price_date,'yyyy-mm') Price_date,
avg(price) price
from dm_data_1
group by to_char(price_date,'yyyy-mm')Linux RHCE Preparation
RHCE 1. Start classroom-rh254 2. Set environment: yum install ./examrhce-0.0.1-l.el7.x86_64.rpm -y 3. Start server-rh254 4. Set lab environment: lab examrhce setup 5. Start desktop-rh254 6. Set lab environment: lab examrhce setup 7. Check result: lab examrhcsa grade 1. Set Selinux A. Change config file: vim /etc/sysconfig/selinux B. Temporary set selinux: setenforce 1 C. Check selinux: getenforce If it used to be disabled, you need to restart to change to enforcing. 2. SSH Access Setting A. Disable the firewall for RHEL 6 i. systemctl mask iptables; ii. systemctl mask ip6tables; iii systemctl mask ebtable.service B. Start the firewall for RHEL 7 i. systemctl enable firewalld ii. systemctl start firewalld C. Set firewall rule i. Allow ssh: firewall-cmd --permanent --add-service=ssh ii. Block subnet for ssh: firewall-cmd --permanent --add-rich-rul='rule family=ipv4 source address=172.17.10.0/24 service=ssh reject' D. Reloa...
Comments
Post a Comment