'전체 글'에 해당되는 글 812건

#!/bin/sh

M_DB_HOST="example.com"

M_DB_USER="root"

M_DB_PASS="비밀번호"

S_DB_HOST="localhost"

S_DB_USER="root"

S_DB_PASS="비밀번호"

M_DATABASES=(`mysql -h$M_DB_HOST -u$M_DB_USER -p$M_DB_PASS -e "show databases" | grep -v "Database\|information_schema\|mysql\|performance_schema"`)

DB_CNT=${#M_DATABASES[*]}

for ((i=0; i<$DB_CNT; i++)) ; do

DATABASE=${M_DATABASES[$i]}

TABLES=(`mysql -h$M_DB_HOST -u$M_DB_USER -p$M_DB_PASS -D$DATABASE -e "show tables" | grep -v "Tables_in_"`)

TB_CNT=${#TABLES[*]}

for ((j=0; j<$TB_CNT; j++)) ; do

TABLE=${TABLES[$j]}

M_CHECKSUMS=(`mysql -h$M_DB_HOST -u$M_DB_USER -p$M_DB_PASS -D$DATABASE -e "checksum tables $TABLE" | grep "$DATABASE." | awk -F " " '{print $1"-"$2}'`)

S_CHECKSUMS=(`mysql -h$S_DB_HOST -u$S_DB_USER -p$S_DB_PASS -D$DATABASE -e "checksum tables $TABLE" | grep "$DATABASE." | awk -F " " '{print $1"-"$2}'`)

CS_CNT=${#M_CHECKSUMS[*]}

for ((k=0; k<$CS_CNT; k++)) ; do

if [ "${M_CHECKSUMS[$k]}" != "${S_CHECKSUMS[$k]}" ] ; then

echo "${M_CHECKSUMS[$k]} != ${S_CHECKSUMS[$k]}"

#mysqldump -h$M_DB_HOST -u$M_DB_USER -p$M_DB_PASS $DATABASE $TABLE --opt | gzip > $DATABASE.$TABLE.$TODAY.sql.gz

#gunzip < $DATABASE.$TABLE.$TODAY.sql.gz | mysql -h$S_DB_HOST -u$S_DB_USER -p$S_DB_PASS $DATABASE 

fi

done

done

done

Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.2743.116 Whale/0.7.27.4 Safari/537.36

# yum update

There was a problem importing one of the Python modules

required to run yum. The error leading to this problem was:

   No module named yum

Please install a package which provides this module, or

verify that the module is installed correctly.

It's possible that the above module doesn't match the

current version of Python, which is:

2.7.11 (default, May 13 2016, 18:00:58)

[GCC 4.4.7 20120313 (Red Hat 4.4.7-11)]

If you cannot solve this problem yourself, please go to

the yum faq at:

  http://yum.baseurl.org/wiki/Faq

wget http://mirror.centos.org/centos-6/6/os/x86_64/Packages/yum-3.2.29-73.el6.centos.noarch.rpm

wget http://mirror.centos.org/centos-6/6/os/x86_64/Packages/yum-metadata-parser-1.1.2-16.el6.x86_64.rpm

wget http://mirror.centos.org/centos-6/6/os/x86_64/Packages/yum-plugin-fastestmirror-1.1.30-37.el6.noarch.rpm

wget http://mirror.centos.org/centos-6/6/os/x86_64/Packages/yum-plugin-security-1.1.30-37.el6.noarch.rpm

wget http://mirror.centos.org/centos-6/6/os/x86_64/Packages/yum-utils-1.1.30-37.el6.noarch.rpm

wget http://mirror.centos.org/centos-6/6/os/x86_64/Packages/python-2.6.6-64.el6.x86_64.rpm

wget http://mirror.centos.org/centos-6/6/os/x86_64/Packages/python-devel-2.6.6-64.el6.x86_64.rpm

wget http://mirror.centos.org/centos-6/6/os/x86_64/Packages/python-libs-2.6.6-64.el6.x86_64.rpm

# rpm -e --nodeps yum

# rpm -e --nodeps python

# rpm -Uvh --nodeps *.rpm

# yum

bash: /usr/bin/yum: No such file or directory

# rpm -Uvh --nodeps yum-3.2.29-73.el6.centos.noarch.rpm

# rpm -Uvh --nodeps python-2.6.6-64.el6.x86_64.rpm

#!/bin/sh

for i in {1..100}

do

        echo $i

        sleep 3

done

# ./bgtest.sh > bgtest.txt &

# ssh root@localhost "sh /root/bgtest.sh > bgtest.txt &"

#!/bin/sh

for i in 1 2 3 4 5

do

        echo $i

done

#!/bin/sh

for i in {1..5}

do

        echo $i

done

#!/bin/sh

alphabet="a b c d e"

for c in $alphabet

do

        echo $c

done

#Alias /phpMyAdmin /usr/share/phpMyAdmin

#Alias /phpmyadmin /usr/share/phpMyAdmin

Listen 8081

NameVirtualHost *:8081

<VirtualHost *:8081>

    ServerName www.example.com

    DocumentRoot /var/www/html

    ErrorLog logs/www.example.com.8081-error_log

    LogFormat "%V %h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\"" vcommon

    CustomLog logs/www.example.com.8081-access_log vcommon

    Alias /phpMyAdmin /usr/share/phpMyAdmin

    Alias /phpmyadmin /usr/share/phpMyAdmin

</VirtualHost>

# firewall-cmd --permanent --zone=public --add-rich-rule='rule family="ipv4" source address="허용아이피/24" port protocol="tcp" port="8081" accept'

# firewall-cmd --reload

# iptables -I INPUT -p tcp --dport 8081 -j DROP

# iptables -I INPUT -p tcp -s 허용아이피 --dport 8081 -j ACCEPT

#!/bin/sh

M_HOST="example.com"

M_USER="root"

M_PASS="password"

S_HOST="localhost"

S_USER="root"

S_PASS="password"

DBNAMES="

database1

database2

database3

"

for DBNAME in $DBNAMES

do

echo "mysqldump -h$M_HOST -u$M_USER -p$M_PASS act --opt | gzip > $DBNAME.sql.gz"

echo "gunzip < $DBNAME.sql.gz | mysql -h$S_HOST -u$S_USER -p$S_PASS $DBNAME"

done

30 03 * * * root /root/bin/dbdump.sh

GRANT ALL PRIVILEGES ON *.* TO 'root'@'접속허용아이피' identified by '비밀번호';

[mysqld]

log-bin=mysql-bin

server-id=1

binlog_do_db=database1

binlog_do_db=database2

GRANT REPLICATION SLAVE ON *.* TO '유저아이디'@'%' IDENTIFIED BY '비밀번호';

FLUSH TABLES WITH READ LOCK;

# mysqldump -h마스터IP -uroot -p비밀번호 데이터베이스명 > backup.sql

# mysql -h슬래이브IP -uroot -p비밀번호 데이터베이스명 < backup.sql

UNLOCK TABLES;

SHOW MASTER STATUS;

[mysqld]

log-bin=mysql-bin

log-slave-updates=1

server-id=2

replicate_do_db=database1

slave-skip-errors=1062

CHANGE MASTER TO

MASTER_HOST='마스터IP',

MASTER_USER='유저아이디',

MASTER_PASSWORD='비밀번호',

MASTER_PORT=3306,

MASTER_LOG_FILE='File값',

MASTER_LOG_POS=Position값,

MASTER_CONNECT_RETRY=30;

START SLAVE;

SHOW SLAVE STATUS;

# badblocks -wsv /dev/sdb

Checking for bad blocks in read-write mode

From block 0 to 976762583

Testing with pattern 0xaa:   0.10% done, 2:38 elapsed

# smartctl -a /dev/sdb

smartctl 5.43 2012-06-30 r3573 [x86_64-linux-2.6.32-431.17.1.el6.x86_64] (local build)

Copyright (C) 2002-12 by Bruce Allen, http://smartmontools.sourceforge.net

=== START OF INFORMATION SECTION ===

Model Family:     Hitachi Deskstar 7K1000.D

Device Model:     Hitachi HDS721010DLE630

Serial Number:    MSK523Y202D35C

LU WWN Device Id: 5 000cca 37fc03e15

Firmware Version: MS2OA610

User Capacity:    1,000,204,886,016 bytes [1.00 TB]

Sector Sizes:     512 bytes logical, 4096 bytes physical

Device is:        In smartctl database [for details use: -P show]

ATA Version is:   8

ATA Standard is:  ATA-8-ACS revision 4

Local Time is:    Fri Mar 10 11:29:59 2017 KST

SMART support is: Available - device has SMART capability.

SMART support is: Enabled

=== START OF READ SMART DATA SECTION ===

SMART overall-health self-assessment test result: FAILED!

Drive failure expected in less than 24 hours. SAVE ALL DATA.

See vendor-specific Attribute list for failed Attributes.

General SMART Values:

Offline data collection status:  (0x84) Offline data collection activity

                                        was suspended by an interrupting command from host.

                                        Auto Offline Data Collection: Enabled.

Self-test execution status:      (   0) The previous self-test routine completed

                                        without error or no self-test has ever

                                        been run.

Total time to complete Offline

data collection:                ( 7361) seconds.

Offline data collection

capabilities:                    (0x5b) SMART execute Offline immediate.

                                        Auto Offline data collection on/off support.

                                        Suspend Offline collection upon new

                                        command.

                                        Offline surface scan supported.

                                        Self-test supported.

                                        No Conveyance Self-test supported.

                                        Selective Self-test supported.

SMART capabilities:            (0x0003) Saves SMART data before entering

                                        power-saving mode.

                                        Supports SMART auto save timer.

Error logging capability:        (0x01) Error logging supported.

                                        General Purpose Logging supported.

Short self-test routine

recommended polling time:        (   1) minutes.

Extended self-test routine

recommended polling time:        ( 123) minutes.

SCT capabilities:              (0x003d) SCT Status supported.

                                        SCT Error Recovery Control supported.

                                        SCT Feature Control supported.

                                        SCT Data Table supported.

SMART Attributes Data Structure revision number: 16

Vendor Specific SMART Attributes with Thresholds:

ID# ATTRIBUTE_NAME          FLAG     VALUE WORST THRESH TYPE      UPDATED  WHEN_FAILED RAW_VALUE

  1 Raw_Read_Error_Rate     0x000b   002   002   016    Pre-fail  Always   FAILING_NOW 3948150783

  2 Throughput_Performance  0x0005   068   068   054    Pre-fail  Offline      -       2076

  3 Spin_Up_Time            0x0007   100   100   024    Pre-fail  Always       -       205

  4 Start_Stop_Count        0x0012   100   100   000    Old_age   Always       -       7

  5 Reallocated_Sector_Ct   0x0033   001   001   005    Pre-fail  Always   FAILING_NOW 1976

  7 Seek_Error_Rate         0x000b   100   100   067    Pre-fail  Always       -       0

  8 Seek_Time_Performance   0x0005   115   115   020    Pre-fail  Offline      -       34

  9 Power_On_Hours          0x0012   095   095   000    Old_age   Always       -       38464

 10 Spin_Retry_Count        0x0013   100   100   060    Pre-fail  Always       -       0

 12 Power_Cycle_Count       0x0032   100   100   000    Old_age   Always       -       7

192 Power-Off_Retract_Count 0x0032   100   100   000    Old_age   Always       -       381

193 Load_Cycle_Count        0x0012   100   100   000    Old_age   Always       -       381

194 Temperature_Celsius     0x0002   150   150   000    Old_age   Always       -       40 (Min/Max 20/45)

196 Reallocated_Event_Count 0x0032   001   001   000    Old_age   Always       -       2102

197 Current_Pending_Sector  0x0022   100   100   000    Old_age   Always       -       0

198 Offline_Uncorrectable   0x0008   100   100   000    Old_age   Offline      -       0

199 UDMA_CRC_Error_Count    0x000a   200   200   000    Old_age   Always       -       0

SMART Error Log Version: 1

ATA Error Count: 311 (device log contains only the most recent five errors)

        CR = Command Register [HEX]

        FR = Features Register [HEX]

        SC = Sector Count Register [HEX]

        SN = Sector Number Register [HEX]

        CL = Cylinder Low Register [HEX]

        CH = Cylinder High Register [HEX]

        DH = Device/Head Register [HEX]

        DC = Device Command Register [HEX]

        ER = Error register [HEX]

        ST = Status register [HEX]

Powered_Up_Time is measured from power on, and printed as

DDd+hh:mm:SS.sss where DD=days, hh=hours, mm=minutes,

SS=sec, and sss=millisec. It "wraps" after 49.710 days.

Error 311 occurred at disk power-on lifetime: 37261 hours (1552 days + 13 hours)

  When the command that caused the error occurred, the device was active or idle.

  After command completion occurred, registers were:

  ER ST SC SN CL CH DH

  -- -- -- -- -- -- --

  10 51 08 3f 00 00 00  Error: IDNF at LBA = 0x0000003f = 63

  Commands leading to the command that caused the error were:

  CR FR SC SN CL CH DH DC   Powered_Up_Time  Command/Feature_Name

  -- -- -- -- -- -- -- --  ----------------  --------------------

  ca 00 08 3f 00 00 e0 08   5d+04:35:46.742  WRITE DMA

  35 00 08 3f 00 44 e0 08   5d+04:35:40.691  WRITE DMA EXT

  35 00 08 3f 00 44 e0 08   5d+04:35:34.756  WRITE DMA EXT

  35 00 08 3f 00 44 e0 08   5d+04:35:34.458  WRITE DMA EXT

  35 00 08 f8 48 80 e0 08   5d+04:35:30.949  WRITE DMA EXT

Error 310 occurred at disk power-on lifetime: 37260 hours (1552 days + 12 hours)

  When the command that caused the error occurred, the device was active or idle.

  After command completion occurred, registers were:

  ER ST SC SN CL CH DH

  -- -- -- -- -- -- --

  10 51 08 47 21 00 00  Error: IDNF at LBA = 0x00002147 = 8519

  Commands leading to the command that caused the error were:

  CR FR SC SN CL CH DH DC   Powered_Up_Time  Command/Feature_Name

  -- -- -- -- -- -- -- --  ----------------  --------------------

  ca 00 08 47 21 00 e0 08   5d+02:50:47.175  WRITE DMA

  27 00 00 00 00 00 e0 08   5d+02:50:47.175  READ NATIVE MAX ADDRESS EXT

  ec 00 00 00 00 00 a0 08   5d+02:50:47.172  IDENTIFY DEVICE

  ef 03 42 00 00 00 a0 08   5d+02:50:47.169  SET FEATURES [Set transfer mode]

  27 00 00 00 00 00 e0 08   5d+02:50:47.169  READ NATIVE MAX ADDRESS EXT

Error 309 occurred at disk power-on lifetime: 37260 hours (1552 days + 12 hours)

  When the command that caused the error occurred, the device was active or idle.

  After command completion occurred, registers were:

  ER ST SC SN CL CH DH

  -- -- -- -- -- -- --

  10 51 08 47 21 00 00  Error: IDNF at LBA = 0x00002147 = 8519

  Commands leading to the command that caused the error were:

  CR FR SC SN CL CH DH DC   Powered_Up_Time  Command/Feature_Name

  -- -- -- -- -- -- -- --  ----------------  --------------------

  ca 00 08 47 21 00 e0 08   5d+02:50:43.296  WRITE DMA

  35 00 08 a8 6b 45 e0 08   5d+02:50:24.581  WRITE DMA EXT

  35 00 10 98 6b 45 e0 08   5d+02:50:24.557  WRITE DMA EXT

  35 00 08 a7 3b 44 e0 08   5d+02:50:06.715  WRITE DMA EXT

  35 00 10 97 3b 44 e0 08   5d+02:50:03.638  WRITE DMA EXT

Error 308 occurred at disk power-on lifetime: 37236 hours (1551 days + 12 hours)

  When the command that caused the error occurred, the device was active or idle.

  After command completion occurred, registers were:

  ER ST SC SN CL CH DH

  -- -- -- -- -- -- --

  10 51 08 47 21 00 00  Error: IDNF at LBA = 0x00002147 = 8519

  Commands leading to the command that caused the error were:

  CR FR SC SN CL CH DH DC   Powered_Up_Time  Command/Feature_Name

  -- -- -- -- -- -- -- --  ----------------  --------------------

  ca 00 08 47 21 00 e0 08   4d+02:56:47.399  WRITE DMA

  27 00 00 00 00 00 e0 08   4d+02:56:47.399  READ NATIVE MAX ADDRESS EXT

  ec 00 00 00 00 00 a0 08   4d+02:56:47.396  IDENTIFY DEVICE

  ef 03 42 00 00 00 a0 08   4d+02:56:47.393  SET FEATURES [Set transfer mode]

  27 00 00 00 00 00 e0 08   4d+02:56:47.393  READ NATIVE MAX ADDRESS EXT

Error 307 occurred at disk power-on lifetime: 37236 hours (1551 days + 12 hours)

  When the command that caused the error occurred, the device was active or idle.

  After command completion occurred, registers were:

  ER ST SC SN CL CH DH

  -- -- -- -- -- -- --

  10 51 08 47 21 00 00  Error: IDNF at LBA = 0x00002147 = 8519

  Commands leading to the command that caused the error were:

  CR FR SC SN CL CH DH DC   Powered_Up_Time  Command/Feature_Name

  -- -- -- -- -- -- -- --  ----------------  --------------------

  ca 00 08 47 21 00 e0 08   4d+02:56:43.515  WRITE DMA

  27 00 00 00 00 00 e0 08   4d+02:56:43.515  READ NATIVE MAX ADDRESS EXT

  ec 00 00 00 00 00 a0 08   4d+02:56:43.512  IDENTIFY DEVICE

  ef 03 42 00 00 00 a0 08   4d+02:56:43.509  SET FEATURES [Set transfer mode]

  27 00 00 00 00 00 e0 08   4d+02:56:43.509  READ NATIVE MAX ADDRESS EXT

SMART Self-test log structure revision number 1

No self-tests have been logged.  [To run self-tests, use: smartctl -t]

SMART Selective self-test log data structure revision number 1

 SPAN  MIN_LBA  MAX_LBA  CURRENT_TEST_STATUS

    1        0        0  Not_testing

    2        0        0  Not_testing

    3        0        0  Not_testing

    4        0        0  Not_testing

    5        0        0  Not_testing

Selective self-test flags (0x0):

  After scanning selected spans, do NOT read-scan remainder of disk.

If Selective self-test is pending on power-up, resume after 0 minute delay.

iptables -I INPUT -p tcp --dport 21 -j DROP

iptables -I INPUT -s 127.0.0.1 -p tcp --dport 21 -j ACCEPT

iptables -I INPUT -s 192.168.1.1 -p tcp --dport 21 -j ACCEPT

iptables -I INPUT -p tcp --dport 25 -j DROP

iptables -I INPUT -s 127.0.0.1 -p tcp --dport 25 -j ACCEPT

iptables -I INPUT -s 192.168.1.1 -p tcp --dport 25 -j ACCEPT

iptables -I INPUT -p tcp --dport 3306 -j DROP

iptables -I INPUT -s 127.0.0.1 -p tcp --dport 3306 -j ACCEPT

iptables -I INPUT -s 192.168.1.1 -p tcp --dport 3306 -j ACCEPT

service iptables save

# iptables -L

Chain INPUT (policy ACCEPT)

target     prot opt source               destination

ACCEPT     all  --  anywhere             anywhere            state RELATED,ESTABLISHED

ACCEPT     all  --  anywhere             anywhere

DROP       icmp --  anywhere             anywhere

ACCEPT     tcp  --  192.168.1.1          anywhere            tcp dpt:ftp

ACCEPT     tcp  --  localhost.localdomain  anywhere            tcp dpt:ftp

DROP       tcp  --  anywhere             anywhere            tcp dpt:ftp

ACCEPT     tcp  --  192.168.1.1          anywhere            tcp dpt:smtp

ACCEPT     tcp  --  localhost.localdomain  anywhere            tcp dpt:smtp

DROP       tcp  --  anywhere             anywhere            tcp dpt:smtp

ACCEPT     tcp  --  192.168.1.1          anywhere            tcp dpt:mysql

ACCEPT     tcp  --  localhost.localdomain  anywhere            tcp dpt:mysql

DROP       tcp  --  anywhere             anywhere            tcp dpt:mysql

ACCEPT     tcp  --  anywhere             anywhere            state NEW tcp dpt:ftp

ACCEPT     tcp  --  anywhere             anywhere            state NEW tcp dpt:domain

ACCEPT     udp  --  anywhere             anywhere            state NEW udp dpt:domain

ACCEPT     tcp  --  anywhere             anywhere            state NEW tcp dpt:http

ACCEPT     tcp  --  anywhere             anywhere            state NEW tcp dpts:irdmi:webcache

ACCEPT     tcp  --  anywhere             anywhere            state NEW tcp dpt:warehouse