'시스템, 서버/Tip & Tech'에 해당되는 글 17건

# for directories:

find ./ -type d -print0 | xargs -0 chmod 0755

# for files:

find ./ -type f -print0 | xargs -0 chmod 0644 

locale-gen ko_KR.UTF-8

vi /etc/default/locale

LANG=ko_KR.UTF-8

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

cat /etc/timezone

dpkg-reconfigure tzdata

modal 을 show -> hide 반복시 backdrop 이 안없어지는 문제

$('#myModal').modal('show');

$('.modal-backdrop').hide(); // for black background

//$('body').removeClass('modal-open'); // For scroll run // 오픈시 효과 class?

$('#myModal').modal('hide');

사실 cron 데몬이 있습니다만...

하지만 cron 데몬에 등록하기 애매할 때가 있죠

예를 들어 퇴근을 해야 합니다.

한시간 후에 sync 명령 하나만 치면 됩니다.

cron 등록은 부담스럽죠?

이럴때 사용하는 명령어가 at 입니다.

at + 실행 시간을 하면 그 시간후에 실행이 됩니다.

예를 들어 아래와 같이 실행합니다.

boggle70@boggle70-15ND530-PX7SK:temp$ at now + 60min

warning: commands will be executed using /bin/sh

at> sync

at> <EOT>    --->>> Ctrl-d 

job 6 at Mon Dec  7 01:35:00 2015

1시간 후에 sync 라는 명령이 실행됩니다.

아 어떻게 확인 하냐구요?  atq 를 실행하면 보여줍니다.

boggle70@boggle70-15ND530-PX7SK:temp$ atq

6 Mon Dec  7 01:35:00 2015 a boggle70

잘못 등록했으면 atrm 으로 지우면 됩니다.

boggle70@boggle70-15ND530-PX7SK:temp$ atrm 6

boggle70@boggle70-15ND530-PX7SK:temp$ atq

http://bizadmin.tistory.com/entry/mysql-%EC%9D%B4%EB%B2%A4%ED%8A%B8-%EC%8A%A4%EC%BC%80%EC%A5%B4%EB%9F%AC-%EC%82%AC%EC%9A%A9%ED%95%98%EA%B8%B0

http://genesis8.tistory.com/298

http://ellehu.com/mysql/4225

example :: every day at 13:00

CREATE EVENT IF NOT EXISTS `session_cleaner_event`
ON SCHEDULE
  EVERY 13 DAY_HOUR
  COMMENT 'Clean up sessions at 13:00 daily!'
  DO
    DELETE FROM site_activity.sessions;

CREATE EVENT event1
ON SCHEDULE EVERY '1' DAY
STARTS '2016-12-15 13:00:00' -- should be in the future
DO
-- your statements
END

참고 : https://blog.outsider.ne.kr/1178

설치

cd /usr/local/

git clone https://github.com/letsencrypt/letsencrypt

확인

cd /usr/local/letsencrypt

./letsencrypt-auto --help

인증서 발급

./letsencrypt-auto certonly --manual

발급확인

cd /etc/letsencrypt/live

ls

nginx 설정

listen 443 ssl;

ssl_certificate /etc/letsencrypt/live/도메인/fullchain.pem;

ssl_certificate_key /etc/letsencrypt/live/도메인/privkey.pem;

apache 설정

SSLEngine on

SSLCertificateFile    /etc/letsencrypt/live/도메인/cert.pem

SSLCertificateKeyFile /etc/letsencrypt/live/도메인/privkey.pem

SSLCertificateChainFile /etc/letsencrypt/live/도메인/chain.pem

갱신 - 3달전

cd /usr/local/letsencrypt

./letsencrypt-auto renew

Mroonga

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

Your MariaDB connection id is 608

Server version: 10.1.19-MariaDB-1~xenial mariadb.org binary distribution

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)]> show engines;

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

| Engine             | Support | Comment                                                                                          | Transactions | XA   | Savepoints |

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

| CSV                | YES     | CSV storage engine                                                                               | NO           | NO   | NO         |

| MRG_MyISAM         | YES     | Collection of identical MyISAM tables                                                            | NO           | NO   | NO         |

| SEQUENCE           | YES     | Generated tables filled with sequential values                                                   | YES          | NO   | YES        |

| MyISAM             | YES     | MyISAM storage engine                                                                            | NO           | NO   | NO         |

| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables                                        | NO           | NO   | NO         |

| Aria               | YES     | Crash-safe tables with MyISAM heritage                                                           | NO           | NO   | NO         |

| PERFORMANCE_SCHEMA | YES     | Performance Schema                                                                               | NO           | NO   | NO         |

| InnoDB             | DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, foreign keys and encryption for tables | YES          | YES  | YES        |

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

8 rows in set (0.02 sec)

MariaDB [(none)]> INSTALL SONAME 'ha_mroonga';

Query OK, 0 rows affected (0.10 sec)

MariaDB [(none)]> show engines;

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

| Engine             | Support | Comment                                                                                          | Transactions | XA   | Savepoints |

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

| CSV                | YES     | CSV storage engine                                                                               | NO           | NO   | NO         |

| MRG_MyISAM         | YES     | Collection of identical MyISAM tables                                                            | NO           | NO   | NO         |

| SEQUENCE           | YES     | Generated tables filled with sequential values                                                   | YES          | NO   | YES        |

| MyISAM             | YES     | MyISAM storage engine                                                                            | NO           | NO   | NO         |

| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables                                        | NO           | NO   | NO         |

| Mroonga            | YES     | CJK-ready fulltext search, column store                                                          | NO           | NO   | NO         |

| PERFORMANCE_SCHEMA | YES     | Performance Schema                                                                               | NO           | NO   | NO         |

| InnoDB             | DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, foreign keys and encryption for tables | YES          | YES  | YES        |

| Aria               | YES     | Crash-safe tables with MyISAM heritage                                                           | NO           | NO   | NO         |

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

9 rows in set (0.01 sec)

MariaDB [(none)]>