[OS]CentOS « AuctionPro

VI 기본 명령어

1. 파일 열기 닫기 파일열기 : vi info.php파일 저장하고 닫기 (esc 버튼) : qw!저장없이 닫기 (esc 버튼) : q! 2. 파일 편집 (esc 버튼) 입력/수정 모드 진입 : i 또는 a단어 삭제 : dw실행 취소 : u한줄 삭제 : dd복사 : yy붙여넣기 : p 3. 위치이동 (esc 버튼) 파일 맨 아래 끝으로 이동 : G줄 앞으로 […]

crontab을 이용한 디비백업

실행 파일을 만든다.

파일명:sql.sh


#!/bin/bash
d=$(/bin/date +”%Y%m%d”)
/usr/local/mysql/bin/mysqldump -uroot -p’패스워드’ 디비명 >/backup-sql/디비백업파일명.sql
cp -Ruf /usr/local/mysql/data/db_young /backup-sql/
tar cvfpz /backup-sql/$d.young_sql.tar.gz /backup-sql/*
mv /backup-sql/$d.young_sql.tar.gz /backup-full/

#!/bin/bash

d=$(/bin/date +”%Y%m%d”)

/usr/local/mysql/bin/mysqldump -uroot -p’패스워드’ 디비명 >/backup-sql/디비백업파일명.sql

cp -Ruf /usr/local/mysql/data/db_young /backup-sql/

tar cvfpz /backup-sql/$d.young_sql.tar.gz /backup-sql/*

mv /backup-sql/$d.young_sql.tar.gz /backup-full/

그리고


crontab -e

3 2 * * * /sql.sh

crontab -e

3 2 * * * /sql.sh

cento pstree 안될때


 yum install psmisc

yum install psmisc


[root@localhost CoreTest]# yum install psmisc
Loaded plugins: fastestmirror
Determining fastest mirrors
epel/x86_64/metalink                                     | 5.6 kB
 * base: data.aonenetworks.kr
 * epel: mirrors.yun-idc.com
 * extras: data.aonenetworks.kr
 * updates: ftp-srv2.kddilabs.jp
 * webtatic: us-east.repo.webtatic.com
base                                                     | 3.6 kB
epel                                                     | 5.3 kB
extras                                                   | 2.9 kB
mariadb                                                  | 2.9 kB
packages-microsoft-com-prod                              | 2.9 kB
updates                                                  | 2.9 kB
webtatic                                                 | 3.6 kB
(1/7): extras/7/x86_64/primary_db                          | 159 kB
(2/7): epel/x86_64/updateinfo                              | 1.0 MB
epel/x86_64/primary_db         FAILED
https://mirrors.thzhost.com/epel/7/x86_64/repodata/1037dd5827f24f5fd5e12fb11504be3d944cf70be264e6f882c2c-primary.sqlite.bz2: [Errno 14] HT04 - Not Found
Trying other mirror.
To address this issue please refer to the below wiki article

https://wiki.centos.org/yum-errors

If above article doesn't help to resolve this issue please use https:os.org/.

(3/7): mariadb/primary_db                                  |  49 kB
(4/7): epel/x86_64/primary_db                              | 6.9 MB
(5/7): packages-microsoft-com-prod/primary_db              |  10 MB
(6/7): webtatic/x86_64/primary_db                          | 248 kB
(7/7): updates/7/x86_64/primary_db                         | 6.7 MB
Resolving Dependencies
--> Running transaction check
---> Package psmisc.x86_64 0:22.20-16.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

=====================================================================
 Package          Arch             Version                 Repository
=====================================================================
Installing:
 psmisc           x86_64           22.20-16.el7            base

Transaction Summary
=====================================================================
Install  1 Package

Total download size: 141 k
Installed size: 475 k
Is this ok [y/d/N]: y
Downloading packages:
psmisc-22.20-16.el7.x86_64.rpm                             | 141 kB
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : psmisc-22.20-16.el7.x86_64
  Verifying  : psmisc-22.20-16.el7.x86_64

Installed:
  psmisc.x86_64 0:22.20-16.el7

Complete!

[root@localhost CoreTest]# yum install psmisc

Loaded plugins: fastestmirror

Determining fastest mirrors

epel/x86_64/metalink | 5.6 kB

* base: data.aonenetworks.kr

* epel: mirrors.yun-idc.com

* extras: data.aonenetworks.kr

* updates: ftp-srv2.kddilabs.jp

* webtatic: us-east.repo.webtatic.com

base | 3.6 kB

epel | 5.3 kB

extras | 2.9 kB

mariadb | 2.9 kB

packages-microsoft-com-prod | 2.9 kB

updates | 2.9 kB

webtatic | 3.6 kB

(1/7): extras/7/x86_64/primary_db | 159 kB

(2/7): epel/x86_64/updateinfo | 1.0 MB

epel/x86_64/primary_db FAILED

https://mirrors.thzhost.com/epel/7/x86_64/repodata/1037dd5827f24f5fd5e12fb11504be3d944cf70be264e6f882c2c-primary.sqlite.bz2: [Errno 14] HT04 - Not Found

Trying other mirror.

To address this issue please refer to the below wiki article

https://wiki.centos.org/yum-errors

If above article doesn't help to resolve this issue please use https:os.org/.

(3/7): mariadb/primary_db | 49 kB

(4/7): epel/x86_64/primary_db | 6.9 MB

(5/7): packages-microsoft-com-prod/primary_db | 10 MB

(6/7): webtatic/x86_64/primary_db | 248 kB

(7/7): updates/7/x86_64/primary_db | 6.7 MB

Resolving Dependencies

--> Running transaction check

---> Package psmisc.x86_64 0:22.20-16.el7 will be installed

--> Finished Dependency Resolution

Dependencies Resolved

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

Package Arch Version Repository

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

Installing:

psmisc x86_64 22.20-16.el7 base

Transaction Summary

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

Install 1 Package

Total download size: 141 k

Installed size: 475 k

Is this ok [y/d/N]: y

Downloading packages:

psmisc-22.20-16.el7.x86_64.rpm | 141 kB

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

Installing : psmisc-22.20-16.el7.x86_64

Verifying : psmisc-22.20-16.el7.x86_64

Installed:

psmisc.x86_64 0:22.20-16.el7

Complete!

VI 기본 명령어

1. 파일 열기 닫기

1) 파일 열기 vi info.php 2) 파일 저장하고 닫기 (esc 버튼) qw! 3) 저장없이 닫기 (esc 버튼) q!

2. 파일 편집 (esc 버튼)

1) 입력/수정 모드 진입 i 또는 a 2) 단어 삭제 dw 3) 실행 취소 u 4) 한줄 삭제 dd 5) 복사 yy 6) 붙여넣기 p

3. […]

Ripmime simscan 설치 /spamassassin 구동시 필요 filtering


* Ripmime 설치

-- 수동 설치 --
[root@localhost]#cd /usr/local/src
[root@localhost]# wget https://dl.fedoraproject.org/pub/epel/6/x86_64/Packages/r/ripmime-1.4.0.9-2.el6.x86_64.rpm 
[root@localhost]# rpm -ivh ripmime-1.4.0.9-2.el6.x86_64.rpm
[root@localhost]# cd /usr/src/redhat/SPECS
[root@localhost]# rpmbuild -ba ripmime.spec
[root@localhost]# cd /usr/src/redhat/RPMS/i386
[root@localhost]# rpm -Uvh ripmime*


[간단 설치 비고]
Download the latest epel-release rpm from
https://dl.fedoraproject.org/pub/epel/6/x86_64/Packages/r/ripmime-1.4.0.9-2.el6.x86_64.rpm 
 
Install epel-release rpm:
# rpm -Uvh epel-release*rpm

Install ripmime rpm package:
-- 자동 설치 * 추천 --
[root@ns1 src]# yum install ripmime
Loaded plugins: fastestmirror, security
Setting up Install Process
Determining fastest mirrors
epel/metalink                                            | 6.2 kB     00:00
Could not retrieve mirrorlist http://rpms.remirepo.net/enterprise/6/remi/mirror error was
14: PYCURL ERROR 7 - "Failed to connect to 2001:bc8:33a1:100::1: Network is unreachable"
 * base: data.aonenetworks.kr
 * epel: mirror.premi.st
 * extras: data.aonenetworks.kr
 * remi: mirrors.thzhost.com
 * remi-safe: ftp.riken.jp
 * rpmforge: ftp.riken.jp
 * updates: data.aonenetworks.kr
base                                                     | 3.7 kB     00:00
epel                                                     | 3.2 kB     00:00
epel/primary                                             | 3.2 MB     00:00
epel                                                                12522/12522
epel-httpd24                                             | 2.9 kB     00:00
extras                                                   | 3.4 kB     00:00
remi                                                     | 2.9 kB     00:00
remi/primary_db                                          | 2.2 MB     00:05
remi-safe                                                | 2.9 kB     00:00
remi-safe/primary_db                                     | 1.0 MB     00:00
rpmforge                                                 | 1.9 kB     00:00
updates                                                  | 3.4 kB     00:00
updates/primary_db                                       | 1.2 MB     00:09
Resolving Dependencies
--> Running transaction check
---> Package ripmime.x86_64 0:1.4.0.9-2.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package          Arch            Version                   Repository     Size
================================================================================
Installing:
 ripmime          x86_64          1.4.0.9-2.el6             epel           83 k

Transaction Summary
================================================================================
Install       1 Package(s)

Total download size: 83 k
Installed size: 201 k
Is this ok [y/N]: y
Downloading Packages:
ripmime-1.4.0.9-2.el6.x86_64.rpm                         |  83 kB     00:00
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : ripmime-1.4.0.9-2.el6.x86_64                                 1/1
  Verifying  : ripmime-1.4.0.9-2.el6.x86_64                                 1/1

Installed:
  ripmime.x86_64 0:1.4.0.9-2.el6

Complete!
------------------------------------------------------------------------------------------------------

* simscan 설치 

[root@localhost]#cd /usr/local/src
[root@localhost]#wget http://downloads.sourceforge.net/project/simscan/simscan/simscan-1.4.0/simscan-1.4.0.tar.gz
[root@localhost]#wget https://notes.sagredo.eu/files/qmail/patches/simscan-1.4.0.patch
[root@localhost]tar xvfz simscan-1.4.0.tar.gz
[root@localhost]cd simscan-1.4.0
[root@localhost]patch -p1 < ../simscan-1.4.0.patch
[root@localhost]useradd -r -g clamav -s /bin/false -c "Simscan - a qmail-queue substitute" simscan
./configure --prefix=/usr --sysconfdir=/etc --mandir=/usr/share/man --enable-user=simscan --enable-clamav=y --enable-attach=y --enable-dropmsg=y --enable-per-domain=y --enable-spam=y --enable-spamc-user=y --enable-spamc=/usr/bin/spamc --enable-spam-hits=30.0 --enable-qmaildir=/var/qmail --enable-workdir=/var/qmail/simscan --enable-controldir=/var/qmail/control --enable-quarantinedir=/var/qmail/quarantine --enable-qmail-queue=/var/qmail/bin/qmail-queue --enable-ripmime=/usr/bin/ripmime --enable-received=y --enable-spamassassin-path=/usr/bin/spamassassin --enable-clamavdb-path=/var/clamav --enable-clamdscan=/usr/bin/clamdscan --enable-sigtool-path=/usr/bin/sigtool --enable-spam-passthru=y
[root@localhost]# make
[root@localhost]# make install-strip
[root@localhost]# mkdir /var/qmail/quarantine
[root@localhost]# chown simscan:clamav /var/qmail/quarantine/
[root@localhost]# chmod 770 /var/qmail/quarantine/
[root@localhost]# cat /var/qmail/control/simcontrol
:clam=yes,spam=yes,attach=.scr:.bat:.com:.pif:.exe:.mp3:.avi:.mpeg:.wmv
[root@localhost]# /var/qmail/bin/simscanmk -g
simscan versions cdb file built. /var/qmail/control/simversions.cdb
[root@localhost]# /var/qmail/bin/simscanmk
simscan cdb file built. /var/qmail/control/simcon

100

101

102

103

104

105

106

* Ripmime 설치

-- 수동 설치 --

[root@localhost]#cd /usr/local/src

[root@localhost]# wget https://dl.fedoraproject.org/pub/epel/6/x86_64/Packages/r/ripmime-1.4.0.9-2.el6.x86_64.rpm

[root@localhost]# rpm -ivh ripmime-1.4.0.9-2.el6.x86_64.rpm

[root@localhost]# cd /usr/src/redhat/SPECS

[root@localhost]# rpmbuild -ba ripmime.spec

[root@localhost]# cd /usr/src/redhat/RPMS/i386

[root@localhost]# rpm -Uvh ripmime*

[간단 설치 비고]

Download the latest epel-release rpm from

https://dl.fedoraproject.org/pub/epel/6/x86_64/Packages/r/ripmime-1.4.0.9-2.el6.x86_64.rpm

Install epel-release rpm:

# rpm -Uvh epel-release*rpm

Install ripmime rpm package:

-- 자동 설치 * 추천 --

[root@ns1 src]# yum install ripmime

Loaded plugins: fastestmirror, security

Setting up Install Process

Determining fastest mirrors

epel/metalink | 6.2 kB 00:00

Could not retrieve mirrorlist http://rpms.remirepo.net/enterprise/6/remi/mirror error was

14: PYCURL ERROR 7 - "Failed to connect to 2001:bc8:33a1:100::1: Network is unreachable"

* base: data.aonenetworks.kr

* epel: mirror.premi.st

* extras: data.aonenetworks.kr

* remi: mirrors.thzhost.com

* remi-safe: ftp.riken.jp

* rpmforge: ftp.riken.jp

* updates: data.aonenetworks.kr

base | 3.7 kB 00:00

epel | 3.2 kB 00:00

epel/primary | 3.2 MB 00:00

epel 12522/12522

epel-httpd24 | 2.9 kB 00:00

extras | 3.4 kB 00:00

remi | 2.9 kB 00:00

remi/primary_db | 2.2 MB 00:05

remi-safe | 2.9 kB 00:00

remi-safe/primary_db | 1.0 MB 00:00

rpmforge | 1.9 kB 00:00

updates | 3.4 kB 00:00

updates/primary_db | 1.2 MB 00:09

Resolving Dependencies

--> Running transaction check

---> Package ripmime.x86_64 0:1.4.0.9-2.el6 will be installed

--> Finished Dependency Resolution

Dependencies Resolved

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

Package Arch Version Repository Size

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

Installing:

ripmime x86_64 1.4.0.9-2.el6 epel 83 k

Transaction Summary

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

Install 1 Package(s)

Total download size: 83 k

Installed size: 201 k

Is this ok [y/N]: y

Downloading Packages:

ripmime-1.4.0.9-2.el6.x86_64.rpm | 83 kB 00:00

Running rpm_check_debug

Running Transaction Test

Transaction Test Succeeded

Running Transaction

Installing : ripmime-1.4.0.9-2.el6.x86_64 1/1

Verifying : ripmime-1.4.0.9-2.el6.x86_64 1/1

Installed:

ripmime.x86_64 0:1.4.0.9-2.el6

Complete!

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

* simscan 설치

[root@localhost]#cd /usr/local/src

[root@localhost]#wget http://downloads.sourceforge.net/project/simscan/simscan/simscan-1.4.0/simscan-1.4.0.tar.gz

[root@localhost]#wget https://notes.sagredo.eu/files/qmail/patches/simscan-1.4.0.patch

[root@localhost]tar xvfz simscan-1.4.0.tar.gz

[root@localhost]cd simscan-1.4.0

[root@localhost]patch -p1 < ../simscan-1.4.0.patch

[root@localhost]useradd -r -g clamav -s /bin/false -c "Simscan - a qmail-queue substitute" simscan

./configure --prefix=/usr --sysconfdir=/etc --mandir=/usr/share/man --enable-user=simscan --enable-clamav=y --enable-attach=y --enable-dropmsg=y --enable-per-domain=y --enable-spam=y --enable-spamc-user=y --enable-spamc=/usr/bin/spamc --enable-spam-hits=30.0 --enable-qmaildir=/var/qmail --enable-workdir=/var/qmail/simscan --enable-controldir=/var/qmail/control --enable-quarantinedir=/var/qmail/quarantine --enable-qmail-queue=/var/qmail/bin/qmail-queue --enable-ripmime=/usr/bin/ripmime --enable-received=y --enable-spamassassin-path=/usr/bin/spamassassin --enable-clamavdb-path=/var/clamav --enable-clamdscan=/usr/bin/clamdscan --enable-sigtool-path=/usr/bin/sigtool --enable-spam-passthru=y

[root@localhost]# make

[root@localhost]# make install-strip

[root@localhost]# mkdir /var/qmail/quarantine

[root@localhost]# chown simscan:clamav /var/qmail/quarantine/

[root@localhost]# chmod 770 /var/qmail/quarantine/

[root@localhost]# cat /var/qmail/control/simcontrol

:clam=yes,spam=yes,attach=.scr:.bat:.com:.pif:.exe:.mp3:.avi:.mpeg:.wmv

[root@localhost]# /var/qmail/bin/simscanmk -g

simscan versions cdb file built. /var/qmail/control/simversions.cdb

[root@localhost]# /var/qmail/bin/simscanmk

simscan cdb file built. /var/qmail/control/simcon

AuctionPro

카테고리

블로그롤

VI 기본 명령어

crontab을 이용한 디비백업

cento pstree 안될때

VI 기본 명령어

Ripmime simscan 설치 /spamassassin 구동시 필요 filtering

최신 글

글목록