'LINUX'에 해당되는 글 258건

# date

Thu Mar 30 12:07:08 KST 2017

# ln -sf /usr/share/zoneinfo/Asia/Seoul /etc/localtime

00 06 * * * root /usr/bin/rdate -s time.bora.net && /sbin/clock -w

# yum -y install ntp

# systemctl start ntpd

# systemctl enable ntpd

# ntpq -pn

     remote           refid      st t when poll reach   delay   offset  jitter

==============================================================================

*211.233.40.78   204.123.2.5      2 u   76   64    2   37.130    0.738   0.000

 45.76.107.191   160.16.75.242    3 u   10   64    1    1.939    3.836   0.000

#server 0.centos.pool.ntp.org iburst

#server 1.centos.pool.ntp.org iburst

#server 2.centos.pool.ntp.org iburst

#server 3.centos.pool.ntp.org iburst

server kr.pool.ntp.org

server asia.pool.ntp.org

wheel:x:10:root,허용계정

auth            required        pam_wheel.so use_uid

unison -batch -times -ignore='Path test1' -ignore='Path test2' -ignore='Path test3' -logfile=/var/log/unison.log /var/www/html ssh://root@192.168.1.3//var/www/html

# Unison preferences file

root = /var/www/html

root = ssh://root@192.168.1.3//var/www/html

sshargs = -p 10022

ignore = Path test1

ignore = Path test2

ignore = Path test3

ignore = Name *.tmp

ignore = Name *.swp

batch = true

times = true

logfile = /var/log/unison.log

# yum install unison

Contacting server...

bash: unison: command not found

Fatal error: Lost connection with the server

settings {

        logfile="/var/log/lsyncd/lsyncd.log",

        statusFile="/var/log/lsyncd/lsyncd-status.log"

}

sync {

        default.rsyncssh,

        source="/var/www/html",

        host="192.168.1.3", -- 메인서버, 백업서버 다르게 설정

        targetdir="/var/www/html",

        delete = false,

        rsync = {

                archive = true,

                compress = false,

                verbose = false

        }

}

# Unison preferences file

root = /var/www/html

root = ssh://root@192.168.1.3//var/www/html

ignore = Path test1

ignore = Path test2

ignore = Path test3

batch = true

times = true

logfile = /var/log/unison.log

# echo "00 03 * * * root /usr/bin/unison" > /etc/cron.d/unison

# chmod 600 /etc/cron.d/unison

# yum install logwatch

# vi /usr/share/logwatch/default.conf/logwatch.conf

MailTo = root

# /usr/sbin/logwatch --output mail

################### Logwatch 7.4.0 (03/01/11) #################### 

        Processing Initiated: Fri Mar 24 16:27:20 2017

        Date Range Processed: yesterday

                              ( 2017-Mar-23 )

                              Period is day.

        Detail Level of Output: 0

        Type of Output/Format: mail / text

        Logfiles for Host: conoha.ivps.kr

 ################################################################## 

 --------------------- httpd Begin ------------------------ 

 Connection attempts using mod_proxy:

    1.162.172.194 -> mx-tw.mail.gm0.yahoodns.net:25: 231 Time(s)

    195.154.226.17 -> lqak.euw1.lol.riotgames.com:443: 3 Time(s)

 A total of 3 sites probed the server 

    183.129.160.229

    60.191.38.77

    60.191.38.78

 Requests with error response codes

    400 Bad Request

       lqak.euw1.lol.riotgames.com:443: 3 Time(s)

    404 Not Found

       /favicon.ico: 14 Time(s)

       /robots.txt: 8 Time(s)

       /current_config/passwd: 4 Time(s)

       /current_config/Account1: 3 Time(s)

       /admin/i18n/readme.txt: 2 Time(s)

       /auto/4_0235.html: 1 Time(s)

       /auto/8_6858.html: 1 Time(s)

       /cgi-bin/php?-d+allow_url_include%3Don+-d+ ... atus_env%3D0+-n: 1 Time(s)

       /hot/news/0_3783.html: 1 Time(s)

       /html/5_8085.html: 1 Time(s)

       /html/7_7733.html: 1 Time(s)

       /media/7_4339.html: 1 Time(s)

       /phpmyadmin: 1 Time(s)

       /pic/news/5_4026.html: 1 Time(s)

       /shehui/6_1375.html: 1 Time(s)

       /tech/4_7891.html: 1 Time(s)

       /yule/1_6028.html: 1 Time(s)

    405 Method Not Allowed

       /webdav/: 3 Time(s)

 ---------------------- httpd End ------------------------- 

 --------------------- pam_unix Begin ------------------------ 

 sshd:

    Authentication Failures:

 vsftpd:

    Authentication Failures:

       unknown (202.107.219.49): 1 Time(s)

       unknown (39.33.123.228): 1 Time(s)

    Invalid Users:

       Unknown Account: 2 Time(s)

 ---------------------- pam_unix End ------------------------- 

 --------------------- Connections (secure-log) Begin ------------------------ 

 **Unmatched Entries**

 ---------------------- Connections (secure-log) End ------------------------- 

 --------------------- SSHD Begin ------------------------ 

 SSHD Killed: 2 Time(s)

 SSHD Started: 4 Time(s)

 Failed logins from:

 Illegal users from:

    undef: 1 time

 Login attempted when not in AllowUsers list:

 Users logging in through sshd:

 Received disconnect:

    11: disconnected by user : 17 Time(s)

 **Unmatched Entries**

 error: key_from_blob: can't read key type : 2 time(s)

 error: buffer_get_string_ret: bad string length 67108871 : 2 time(s)

 ---------------------- SSHD End ------------------------- 

 --------------------- Disk Space Begin ------------------------ 

 Filesystem      Size  Used Avail Use% Mounted on

 /dev/vda2        20G   15G  4.4G  77% /

 devtmpfs        236M     0  236M   0% /dev

 ---------------------- Disk Space End ------------------------- 

 ###################### Logwatch End ######################### 

GRANT SELECT, SHOW DATABASES, LOCK TABLES ON *.* TO '유저아이디'@'localhost' IDENTIFIED BY '비밀번호'

# echo "AllowUsers 유저1 유저2 유저3" >> /etc/ssh/sshd_config

# systemctl restart sshd

# nslookup -debug conoha.ivps.kr

Server:         157.7.180.133

Address:        157.7.180.133#53

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

    QUESTIONS:

        conoha.ivps.kr, type = A, class = IN

    ANSWERS:

    ->  conoha.ivps.kr

        internet address = 133.130.124.240

        ttl = 92

    AUTHORITY RECORDS:

    ADDITIONAL RECORDS:

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

Non-authoritative answer:

Name:   conoha.ivps.kr

Address: 133.130.124.240

# nslookup

> conoha.ivps.kr

Server:         157.7.180.133

Address:        157.7.180.133#53

Non-authoritative answer:

Name:   conoha.ivps.kr

Address: 133.130.124.240

> set debug

> conoha.ivps.kr

Server:         157.7.180.133

Address:        157.7.180.133#53

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

    QUESTIONS:

        conoha.ivps.kr, type = A, class = IN

    ANSWERS:

    ->  conoha.ivps.kr

        internet address = 133.130.124.240

        ttl = 44

    AUTHORITY RECORDS:

    ADDITIONAL RECORDS:

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

Non-authoritative answer:

Name:   conoha.ivps.kr

Address: 133.130.124.240

> exit

GRANT SELECT ON *.* to 'readuser'@'%' IDENTIFIED BY 'readonly'

# mysql -ureaduser -preadonly

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 58

Server version: 5.5.52-MariaDB MariaDB Server

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> use testdb

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

MariaDB [testdb]> select * from test_table4;

+-----+-------+

| idx | title |

+-----+-------+

|   1 | 111   |

|   2 | 222   |

|   3 | 333   |

+-----+-------+

3 rows in set (0.00 sec)

MariaDB [testdb]> delete from test_table4 where idx = 3;

ERROR 1142 (42000): DELETE command denied to user 'readuser'@'localhost' for table 'test_table4'

MariaDB [testdb]> update test_table4 set title='444' where idx = 4;

ERROR 1142 (42000): UPDATE command denied to user 'readuser'@'localhost' for table 'test_table4'

MariaDB [testdb]> insert into test_table4 value (4,444);

ERROR 1142 (42000): INSERT command denied to user 'readuser'@'localhost' for table 'test_table4'

ARR_A=(1 2 3 4 5)

ARR_C=`echo ${ARR_A[@]} | sed -e "s/ /,/g"`

echo $ARR_C

ARR_B="1 2 3 4 5"

ARR_C=`echo $ARR_B | sed -e "s/ /,/g"`

echo $ARR_C