너는 개발자냐?

rename table ofExtComponentConf to ofextcomponentconf;

rename table ofGroup to ofgroup;

rename table ofGroupProp to ofgroupprop;

rename table ofGroupUser to ofgroupuser;

rename table ofID to ofid;

rename table ofMucAffiliation to ofmucaffiliation;

rename table ofMucConversationLog to ofmucconversationlog;

rename table ofMucMember to ofmucmember;

rename table ofMucRoom to ofmucroom;

rename table ofMucRoomProp to ofmucroomprop;

rename table ofMucService to ofmucservice;

rename table ofMucServiceProp to ofmucserviceprop;

rename table ofOffline to ofoffline;

rename table ofPresence to ofpresence;

rename table ofPrivacyList to ofprivacylist;

rename table ofPrivate to ofprivate;

rename table ofProperty to ofproperty;

rename table ofPubsubAffiliation to ofpubsubaffiliation;

rename table ofPubsubDefaultConf to ofpubsubdefaultconf;

rename table ofPubsubItem to ofpubsubitem;

rename table ofPubsubNode to ofpubsubnode;

rename table ofPubsubNodeGroups to ofpubsubnodegroups;

rename table ofPubsubNodeJIDs to ofpubsubnodejids;

rename table ofPubsubSubscription to ofpubsubsubscription;

rename table ofRemoteServerConf to ofremoteserverconf;

rename table ofRoster to ofroster;

rename table ofRosterGroups to ofrostergroups;

rename table ofSASLAuthorized to ofsaslauthorized;

rename table ofSecurityAuditLog to ofsecurityauditlog;

rename table ofUser to ofuser;

rename table ofUserFlag to ofuserflag;

rename table ofUserProp to ofuserprop;

rename table ofVCard to ofvcard;

rename table ofVersion to ofversion;

이 처럼 만들어 준다.

centos 에 ngxtop 설치

소스 설치 방법

ngxtop 설치

pip install ngxtop

pip 없으면 yum install python-pip 로 설치

python-php 없으면

rpm -ivh http://dl.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm

실행

# ngxtop -c /usr/local/nginx-1.5.2/conf/nginx.conf

# ngxtop -c /usr/local/nginx-1.5.2/conf/nginx.conf top remote_addr

mysql> SELECT @@max_allowed_packet;

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

| @@max_allowed_packet |

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

|              1048576 |

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

1 row in set

http://krazydad.com/mazes/

tomcat8 에서 사용가능한 probe 파일

probe.z01

probe.zip

https://github.com/psi-probe/psi-probe

http://www.kurobuti.com/blog/?p=7370

OSS에서 채팅 도구를 찾고 있었는데, SPIKA을 발견했습니다. 
그래서 CentOS6에 OSS 메신저 SPIKA를 설치하고 보았습니다. 
※ 여기에서는 우선 동작 단계 만 쓰고 있습니다. 보안거나 무시하고 있습니다 

■ SPIKA 공식 
http://spikaapp.com/ja/

1. EPEL 저장소 등록

  [root @ localhost ~] # rpm -ivh http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm
 http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm 가져 오는 중 경고 : /var/tmp/rpm-tmp.iRW5Nq : 헤더 V3 RSA / SHA256 Signature, key ID 0608b895 : NOKEY
 준비 중 ... ########################################### [100 %]
    1 : epel-release ########################################### [100 %] 

SPIKA 설치에 필요한 xdebug와 phpunit를 설치하기 위해 EPEL을 사용합니다. 
　

2. 필요한 패키지 설치

  [root @ localhost ~] # yum -y install httpd mod_ssl curl git php php-curl php-mysql php-gd php-phpunit-PHPUnit php-pecl-xdebug mysql-server 

※ mod_ssl을 설치하는 것은 https를 대응 할 수 있도록하기 위해서입니다. 필수는 아닙니다. 단, https에서 SPIKA을 이용하면 채팅 발언의 실시간 반영이 잘되지 않았습니다. 

3. SPIKA 설치

  [root @ localhost ~] # cd / var / www / html /
 [root @ localhost html] # git clone https://github.com/cloverstudio/Spika-Server.git
 [root @ localhost html] # cd Spika-Server /
 [root @ localhost Spika-Server] # mkdir logs
 [root @ localhost Spika-Server] # mkdir uploads
 [root @ localhost Spika-Server] # chmod 777 logs /
 [root @ localhost Spika-Server] # chmod 777 uploads /
 [root @ localhost Spika-Server] # php composer.phar install -d.
 (snip)
 silex / silex suggests installing symfony / form (> = 2.3 <2.5-dev)
 phpunit / phpunit suggests installing phpunit / php-invoker (> = 1.1.0 <1.2.0)
 symfony / dom-crawler suggests installing symfony / css-selector ()
 symfony / browser-kit suggests installing symfony / process ()
 Generating autoload files 

4. Apache 설정

  [root @ localhost ~] # vi /etc/httpd/conf/httpd.conf
 (snip)
 <Directory "/ var / www / html">
 (snip)
 # for more information.
 #
     Options Indexes FollowSymLinks

 #
 # AllowOverride controls what directives may be placed in .htaccess files.
 # It can be "All", "None", or any combination of the keywords :
 # Options FileInfo AuthConfig Limit
 #
     AllowOverride None
     ↓ # 변경 AllowOverride All 

AllowOverride All  로 변경

5. MySQL 설정

  [root @ localhost ~] # vi /etc/my.cnf
 (snip)
 # Disabling symbolic-links is recommended to prevent assorted security risks
 symbolic-links = 0

 character-set-server = utf8 # 추가 

skip-character-set-client-handshake # 추가 

6. Apache와 MySQL의 시작

  [root @ localhost ~] # service httpd start
 [root @ localhost ~] # chkconfig httpd on
 [root @ localhost ~] # service mysqld start
 [root @ localhost ~] # chkconfig mysqld on 

7. SPIKA에서 사용하는 DB와 MySQL 사용자를 생성

  [root @ localhost ~] # mysql -u root
 mysql> create database spikadb;
 Query OK, 1 row affected (0.00 sec)

 mysql> grant all privileges on spikadb. * to spikauser @ localhost identified by 'password';
 Query OK, 0 rows affected (0.00 sec)

 mysql> quit
 Bye 

8. SPIKA 설치

브라우저에서 다음 주소로 이동합니다. 

주소 : http : // IP or FQDN / Spika-Server / wwwroot / installer 
　

8-1. DB 정보를 입력

DB 정보를 입력하고 "Connect to Database"를 클릭합니다. 

8-2 스키마 작성

"Create Database Schema"을 클릭합니다. 
 
　

8-3. 초기 데이터 작성

"Create Initial Data"를 클릭합니다. 
 
　

8-4. 초기 설정

赤枠 부분을 복사합니다. 
 

다음 파일 (init.php)을 수정합니다.

  [root @ localhost ~] # vi /var/www/html/Spika-Server/config/init.php
 (snip)
 / * change here * /
 / * define ( 'ROOT_URL', 'http : // localhost : 8080 / wwwroot'); 주석 define ( 'LOCAL_ROOT_URL', 'http : // localhost / wwwroot'); 주석 * /

 define ( 'ROOT_URL', 'http : //192.168.0.195/Spika-Server/wwwroot'); / * 추가​​ * /
 define ( 'LOCAL_ROOT_URL', 'http : // localhost / Spika-Server / wwwroot'); / * 추가​​ * /

 / * define ( "MySQL_HOST" 'localhost'); 주석 define ( 'MySQL_DBNAME', 'spikadb'); 주석 define ( 'MySQL_USERNAME', 'root'); 주석 define ( 'MySQL_PASSWORD', 'yourpassword'); 주석 * /

 define ( "MySQL_HOST" 'localhost'); / * 추가​​ * /
 define ( 'MySQL_DBNAME', 'spikadb'); / * 추가​​ * /
 define ( 'MySQL_USERNAME', 'spikauser'); / * 추가​​ * /
 define ( 'MySQL_PASSWORD', 'password'); / * 추가​​ * / 

8-5. SPIKA 시작

"Open Spika Admin"을 클릭합니다. 
 
　

9. 로그인

SPIKA에 로그인합니다. 
초기 정보는 다음과 같습니다. 

ID : admin@spikaapp.com 
PW : password 

"Sing In '을 클릭하여 로그인합니다. 
 

다음은 초기 로그인 화면입니다. 

http://www.delmaster.net/129

이거 보고 따라함. 

int 필드 값을 sum 했을 때 발생.

expression을(를) 데이터 형식 int(으)로 변환하는 중 산술 오버플로 오류가 발생했습니다.

-- SUM 하고자 하는 값을 먼저 변환 한다.
SELECT SUM(CONVERT(BIGINT, field)) AS alias FROM tablename

sum 할때 bigint로 convert 해줌. 끝

http://www.cyberciti.biz/tips/domain-check-script.html

리눅스에서 도메인 남은 기간 확인 하고 메일 발송 해주는 스크립트

I've already written about a shell script to check / monitor domain renew /expiration date here. Now I’ve modified matt’s domain-check script to support additional C/TLDs .in, .biz, .org and .info domains. I've also added 5 seconds delay to avoid whois server rejecting query. This script checks to see if a domain has expired. It can be run in interactive and batch mode, and provides facilities to alarm if a domain is about to expire in advance.

Sample usage

Display expiration date and registrar for theos.in domain:
domain-check-2 -d {domain-name}

$ domain-check-2 -d theos.in
Output:

Domain                              Registrar         Status   Expires     Days Left
----------------------------------- ----------------- -------- ----------- ---------
theos.in                            et4India (R7-AFIN Valid    28-Oct-2009   799  

You can also get an email if theos.in going to expire in 30 days
$ domain-check-2 -a -d theos.in -q -x 30 -e vivek@nixcraft.com

However most killer feature is you can read list of domain names from a file such as mydomains.txt (list each domain on a new line):
$ domain-check-2 -a -f mydomains.txt -q -x 30 -e vivek@nixcraft.com
OR
$ domain-check-2 -f mydomains.txt

Output:

Domain                              Registrar         Status   Expires     Days Left
----------------------------------- ----------------- -------- ----------- ---------
theos.in                            et4India (R7-AFIN Valid    28-Oct-2009   799
nixcraft.org                        oDaddy.com, Inc.  Valid    13-Aug-2009   723
vivekgite.com                       MONIKER ONLINE SE Valid    18-aug-2010   1093
cyberciti.biz                                         Valid    30-Jun-2009   679
nixcraft.info                       oDaddy.com Inc. ( Valid    26-Jun-2009   675
nixcraft.net                        GODADDY.COM, INC. Valid    11-dec-2009   843  

Download

=> Download modified domain-check-2 script here.

domain-check-2.txt

Quick installation

Use wget command to download and install domain-check script:
$ wget http://www.cyberciti.biz/files/scripts/domain-check-2.txt
$ mv domain-check-2.txt domain-check
$ chmod +x domain-check
$ ./domain-check -d vivekgite.com

Make sure your run domain-check script using a cron job.