{"id":60,"date":"2014-10-13T03:19:00","date_gmt":"2014-10-12T18:19:00","guid":{"rendered":"https:\/\/www.picolix.jp\/blog\/2014\/10\/centos7.html\/"},"modified":"2019-04-02T10:27:26","modified_gmt":"2019-04-02T01:27:26","slug":"centos7","status":"publish","type":"post","link":"https:\/\/www.picolix.jp\/blog\/2014\/10\/centos7.html","title":{"rendered":"\u3055\u304f\u3089\uff36\uff30\uff33\u3067\u501f\u308a\u3066\u3044\u308b\u30b5\u30fc\u30d0\u3092CentOS7\u306b\u79fb\u884c\u3057\u307e\u3057\u305f\u3002"},"content":{"rendered":"

\u3055\u304f\u3089\uff36\uff30\uff33\u3000CentOS6.5\u306e\u30b5\u30fc\u30d0\u3092\u65b0\u305f\u306bCentOS 7\u3092\u30af\u30ea\u30fc\u30f3\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u79fb\u884c\u3057\u307e\u3057\u305f\u3002
\n\uff086.5\u304b\u30897\u3078UPGRADE\u3082\u3067\u304d\u307e\u3059\u304c\u3001\u4eca\u5f8c\u306e\u3053\u3068\u3082\u8003\u3048\u3066\u30af\u30ea\u30fc\u30f3\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002\uff09
\nLAMP\u95a2\u4fc2\u306f\u52d5\u3044\u3066\u5f53\u7136\u306a\u306e\u3067\u6c17\u306b\u3057\u3066\u306a\u3044\u306e\u3067\u3059\u304c\u3001
\n\u30fbOSGrid opensim\u30b5\u30fc\u30d0
\n\u30fb\u753b\u50cf\u751f\u6210\u30b5\u30fc\u30d0
\n\u306e\u70ba\u306b\u30011),2)\u304c\u52d5\u4f5c\u5fc5\u9808\u306e\u30a2\u30d7\u30ea\uff06\u30e2\u30b8\u30e5\u30fc\u30eb\u3067\u3059\u3002<\/p>\n

\n1) opensim\u95a2\u9023
\n  \u25cb mono<\/p>\n

wget http:\/\/download.mono-project.com\/repo\/xamarin.gpg
\nrpm –import xamarin.gpg
\nyum-config-manager –add-repo http:\/\/download.mono-project.com\/repo\/centos\/
\n\u3000\u3000\u3000yum install mono
\n      \u3067\u3055\u304f\u3063\u3068\u5165\u3063\u305f\u3002\uff08Mono JIT compiler version 3.10.0\uff09
\n      \u4ee5\u524d\u306f\u95a2\u9023\u30e2\u30b8\u30e5\u30fc\u30eb\u3092\u30b3\u30f3\u30d1\u30a4\u30eb\u3057\u3066\u5165\u308c\u3066\u3044\u307e\u3057\u305f\u3002<\/p>\n

\u3000\u25cb opensim.exe
\n\u3000\u3000\u3000CentOS 7 \u304b\u3089\u306f\u3001\uff24\uff22\u306f\u3001MySQL\u2192MariaDB \u3078\u5909\u66f4\u3002\u3068\u3044\u3063\u3066\u3082
\n\u3000\u3000\u3000\u65e7\u30c7\u30fc\u30bf\u3001\u8a2d\u5b9a\u306f\u305d\u306e\u307e\u307e\u4f7f\u3048\u3066\u3001\u554f\u984c\u306a\u304f\u52d5\u4f5c\u3002<\/p>\n

2) \u753b\u50cf\u95a2\u9023\uff1a
\n\u3000\u25cb\u3000ImageMagick-perl-6.7.8.9-10.el7.x86_64
\n\u3000\u25cb\u3000netpbm<\/p>\n

\u3000\u3000\u3000\u3053\u308c\u3082\u554f\u984c\u306a\u304f\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\uff06\u52d5\u4f5c\uff2f\uff2b<\/p>\n

3) VPN pptpd
\n  CentOS7,firewall-cmd\u3067\u8a2d\u5b9a\u3057\u305f\u60c5\u5831\u304c\u3042\u307e\u308a\u306a\u304b\u3063\u305f\u304c\u3001\u306a\u3093\u3068\u306a\u304f\u8a2d\u5b9a\u3057\u305f\u3089\u7c21\u5358\u306b
\n\u52d5\u3044\u305f\u3002\uff08CentOS6.5\u3088\u308a\u3082\u7c21\u5358\u8a2d\u5b9a\uff09
\n\u3000\u4ee5\u4e0b\u3001\u8a2d\u5b9a\u30e1\u30e2<\/p>\n

\u3000#yum install pptpd
\n  \/etc\/pptpd.conf
\n    localip 192.168.0.1
\n    remoteip 192.168.0.234-238,192.168.0.245<\/p>\n

  \/etc\/rsyslog.conf
\n     *.=debug;
\n          news.none;mail.none     -\/var\/log\/pptpd<\/p>\n

  systemctl restart rsyslog.service<\/p>\n

  \/etc\/ppp\/options.pptpd
\n  #ms-dns 8.8.8.8
\n  ms-dns 210.224.163.4
\n  ms-dns 210.224.163.3<\/p>\n

 \/etc\/ppp\/chap-secrets
\n # Secrets for authentication using CHAP
\n # client        server  secret                  IP addresses
\n username * password *<\/p>\n

 \u30d5\u30a1\u30a4\u30a2\u30a6\u30a9\u30fc\u30eb\u8a2d\u5b9a
\n firewall-cmd –add-port=1723\/tcp –permanent
\n firewall-cmd –add-port=514\/udp –permanent
\n firewall-cmd –permanent –direct –add-rule ipv4 filter INPUT 0 -p 47 -j ACCEPT
\n firewall-cmd –zone=public –add-masquerade –permanent
\n firewall-cmd –reload<\/p>\n

 firewall-cmd\u3067–add-masquerade\u3092\u5b9f\u884c\u3059\u308b\u3068ip_forward\u306e\u8a2d\u5b9a\u306f\u4e0d\u8981\u3002<\/p>\n

 #systemctl start  pptpd.service
\n #systemctl enable pptpd.service<\/p>\n

4) mondorescue (ISO\u30a4\u30e1\u30fc\u30b8\u307e\u308b\u3054\u3068\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\uff09<\/p>\n

\u3000\u3053\u308c\u306f\u52d5\u4f5c\u3057\u307e\u305b\u3093\u3002\u307e\u3060CentOS7\u7528\u306f\u51fa\u3066\u304a\u308a\u307e\u305b\u3093\u3002
\n\u3000\u7121\u7406\u3084\u308a\u3001CentOS6\u7528\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u4f7f\u3066\u898b\u307e\u3057\u305f\u304c\u3060\u3081\u3067\u3057\u305f\u3002
\n\u3000CentOS 6\u7528\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u4f7f\u3046\u3068\u3001grub\u304c\u7121\u3044\u3063\u3066\u6012\u3089\u308c\u307e\u3059\u3002
\n\u3000CentOS 7\u304b\u3089grub\u306fgrub2\u306b\u306a\u3063\u3066\u308b\u3002
\n\u3000<\/p>\n

\n\uff1d\uff1d\u4ee5\u4e0b\u81ea\u5206\u7528\u306e\u30b3\u30de\u30f3\u30c9\u30e1\u30e2\u3067\u3059\u3002CentOS7 Sakura == \u30e1\u30e2
\n\u30fbRUN\u3000LEVEL 3\u306b\u5909\u66f4
\nln -sf \/lib\/systemd\/system\/runlevel3.target \/etc\/systemd\/system\/default.target<\/p>\n

\u30fb\u3044\u3089\u306a\u3044\u30b5\u30fc\u30d3\u30b9\u306f\u3084\u3081\u308b\u3002
\nsystemctl disable abrt-ccpp.service
\nsystemctl disable abrt-oops.service
\nsystemctl disable abrt-vmcore.service
\nsystemctl disable abrt-xorg.service
\nsystemctl disable abrtd.service
\nsystemctl disable atd.service
\nsystemctl disable dbus-org.freedesktop.nm-dispatcher.service
\nsystemctl disable auditd.service
\nsystemctl disable avahi-daemon.service
\nsystemctl disable bluetooth.service
\nsystemctl disable accounts-daemon.service
\nsystemctl disable avahi-daemon.service
\nsystemctl disable dbus-org.freedesktop.ModemManager1.service
\nsystemctl disable dmraid-activation.service
\nsystemctl disable display-manager.service
\nsystemctl disable firstboot-graphical.service
\nsystemctl disable fprintd.service
\nsystemctl disable gdm.service
\nsystemctl disable hypervkvpd.service
\nsystemctl disable hypervvssd.service
\nsystemctl disable irqbalance.service
\nsystemctl disable iscsi.service
\nsystemctl disable ksm.service
\nsystemctl disable ksmtuned.service
\nsystemctl disable libstoragemgmt.service
\nsystemctl disable libvirtd.service
\nsystemctl disable lvm2-monitor.service
\nsystemctl disable mdmonitor.service
\nsystemctl disable microcode.service
\nsystemctl disable ModemManager.service
\nsystemctl disable multipathd.service
\nsystemctl disable nfs-lock.service
\nsystemctl disable packagekit-offline-update.service
\nsystemctl disable rngd.service
\nsystemctl disable rpcbind.service
\nsystemctl disable rtkit-daemon.service
\nsystemctl disable smartd.service
\nsystemctl disable spice-vdagentd.service
\nsystemctl disable sysstat.service
\nsystemctl disable systemd-readahead-collect.service
\nsystemctl disable systemd-readahead-drop.service
\nsystemctl disable systemd-readahead-replay.service
\nsystemctl disable tuned.service
\nsystemctl disable vmtoolsd.service
\nsystemctl disable chronyd
\n chronyd ==> ntpd\u306e\u4ee3\u308f\u308a\u3089\u3057\u3044<\/p>\n

systemctl list-unit-files | grep enable
\ncups.path                                   enabled
\ncrond.service                               enabled
\ncups.service                                enabled
\ndbus-org.fedoraproject.FirewallD1.service   enabled
\ndbus-org.freedesktop.NetworkManager.service enabled
\ndbus-org.freedesktop.nm-dispatcher.service  enabled
\nfirewalld.service                           enabled
\ngetty@.service                              enabled
\nnetcf-transaction.service                   enabled
\nNetworkManager-dispatcher.service           enabled
\nNetworkManager.service                      enabled
\npostfix.service                             enabled
\nrsyslog.service                             enabled
\nserial-getty@.service                       enabled
\nsshd.service                                enabled
\ncups.socket                                 enabled
\ndm-event.socket                             enabled
\niscsid.socket                               enabled
\niscsiuio.socket                             enabled
\nlvm2-lvmetad.socket                         enabled
\ndefault.target                              enabled
\nmulti-user.target                           enabled
\nnfs.target                                  enabled
\nremote-fs.target                            enabled
\nreboot<\/p>\n

[[\u30ea\u30dd\u30b8\u30c8\u30ea\u30fc]]
\nyum install -y epel-release
\nrpm -ivh http:\/\/rpms.famillecollet.com\/enterprise\/remi-release-7.rpm
\nwget http:\/\/download.mono-project.com\/repo\/xamarin.gpg
\nrpm –import xamarin.gpg
\nyum-config-manager –add-repo http:\/\/download.mono-project.com\/repo\/centos\/<\/p>\n

vi \/etc\/yum.repos.d\/CentOS-Base.repo
\n [centosplus]
\n name=CentOS-$releasever – Plus
\n mirrorlist=http:\/\/mirrorlist.centos.org\/?release=$releasever&arch=$basearch&repo=centosplus&infra=$infra
\n #baseurl=http:\/\/mirror.centos.org\/centos\/$releasever\/centosplus\/$basearch\/
\n gpgcheck=1
\n enabled=1<\/p>\n

wget http:\/\/pkgs.repoforge.org\/rpmforge-release\/rpmforge-release-0.5.3-1.el7.rf.x86_64.rpm
\nrpm -iUvh rpmforge-release-0.5.3-1.el7.rf.x86_64.rpm<\/p>\n

\n[[yum or make]]
\nyum install postgre*
\nyum install mariadb*
\nyum install php php-cli php-pdo php-mysql php-common php php-cgi php-devel php-gd php-mbstring php-pear php-xmlrpc php-xml php-gd php-pgsql php-json
\nyum install screen
\nyum install mono
\nyum install perl-DBD*
\nyum install vsftpd
\nyum install clamd
\nyum localinstall http:\/\/mirror.centos.org\/centos\/6\/os\/x86_64\/Packages\/nkf-2.0.8b-6.2.el6.x86_64.rpm
\nyum install ImageMagick-*
\nwget ftp:\/\/ftp.pangeia.com.br\/pub\/seg\/pac\/chkrootkit.tar.gz
\n  http:\/\/www.mk-mode.com\/octopress\/2014\/08\/07\/centos-7-0-installation-of-chrootkit\/
\n  earching for Suckit rootkit… Warning: \/sbin\/init INFECTED => \u3053\u308c\u306f\u8aa4\u52d5\u4f5c\u3089\u3057\u3044\u306e\u3067OK
\nyum install pptpd
\nyum install ftp
\nyum remove cronie-anacron\u3000\uff1d\uff1eanacron\u306f\u5acc\u3044\u3002
\nyum install cronie-noanacron\u3000\uff1d\uff1e\u3044\u3064\u3082\u306ecron\u306b\u3059\u308b\u3002
\nyum install libjpeg*
\nyum install hdparm<\/p>\n

\/etc\/yum.conf
\nexclude=kernel* centos* mono*<\/p>\n

yum\u3067\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9
\nyumdownloader bash
\nyum install –downloadonly –downloaddir=\/tmp bash\u3067\u3082\u53ef\u80fd<\/p>\n

[[perl\u30e2\u30b8\u30e5\u30fc\u30eb]]
\ncpan[1]> install Jcode
\ncpan[2]> install Expect
\ncpan[1]> install Time::HiRes
\ncpan[2]> install YAML
\ninstall Spreadsheet::ParseExcel
\ninstall Spreadsheet::XLSX
\ninstall Module::Install
\ninstall Module::Install::AuthorTests
\ninstall Module::Install::Repository
\ninstall Net::Twitter::Lite
\ninstall XML::RSS
\ninstall JSON::Any
\ninstall XML::Simple
\ninstall DateTime::Format::HTTP
\ninstall LWP::Protocol::https
\ninstall Config::Auto
\ninstall Net::OAuth<\/p>\n

WWquitW-Shorten-3.06
\n perl Build.PL
\n perl Build
\n perl Build install
\nWWW-Shorten-Bitly-1.17
\nWWW-Shorten-Google-0.01<\/p>\n

[[\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30fc]]
\n\/etc\/ssh\/sshd_config
\nPermitRootLogin no
\nsystemctl reload sshd.service<\/p>\n

\/etc\/hosts.allow
\npptpd : ALL<\/p>\n

ALL : 127.0.0.1
\nsendmail : ALL<\/p>\n

vsftpd : xxx.xxx.xxx.xxx
\n.
\n.
\nsshd : xxx.xxx.xxx.xxx
\n.
\n.
\nsyslogd :  xxx.xxx.xxx.xxx<\/p>\n

\/etc\/hosts.deny
\nALL:ALL<\/p>\n

\/etc\/sysconfig\/selinux
\nSELINUX=disabled<\/p>\n

[[\u30d5\u30a1\u30a4\u30a2\u30fc\u30a6\u30a9\u30fc\u30eb]]
\n[root@www ~]# firewall-cmd –state
\nrunning
\nfirewall-cmd –add-service=http –permanent
\nfirewall-cmd –add-port=9000\/udp –permanent
\nfirewall-cmd –add-port=9001\/udp –permanent
\nfirewall-cmd –add-port=9002\/udp –permanent
\nfirewall-cmd –add-port=9003\/udp –permanent
\nfirewall-cmd –add-port=9000\/tcp –permanent
\nfirewall-cmd –add-port=9001\/tcp –permanent
\nfirewall-cmd –add-port=1723\/tcp –permanent
\nfirewall-cmd –add-port=514\/udp –permanent
\nfirewall-cmd –permanent –direct –add-rule ipv4 filter INPUT 0 -p 47 -j ACCEPT
\nfirewall-cmd –zone=public –add-masquerade –permanent
\nfirewall-cmd –permanent –direct –add-rule ipv4 filter INPUT 1 -s xxx.xxx.xxx.xxx\/32 -j ACCEPT<\/p>\n

\nfirewall-cmd –reload
\nfirewall-cmd –list-services
\n[root@www ~]# firewall-cmd –list-all
\npublic (default, active)
\n  interfaces: eth0
\n  sources:
\n  services: dhcpv6-client http ssh
\n  ports: 9001\/udp 1723\/tcp 9003\/udp 9002\/udp 9000\/udp 9001\/tcp 9000\/tcp 514\/udp
\n  masquerade: yes
\n  forward-ports:
\n  icmp-blocks:
\n  rich rules:<\/p>\n

\nGUI
\n# firewall-config<\/p>\n

\n[[pptpd]]
\n\/etc\/pptpd.conf
\nlocalip 192.168.0.1
\nremoteip 192.168.0.234-238,192.168.0.245<\/p>\n

\/etc\/rsyslog.conf<\/p>\n

$ModLoad imudp
\n$UDPServerRun 514<\/p>\n

 *.=debug;
\n      news.none;mail.none     -\/var\/log\/pptpd
\nlocal1.*                                                \/var\/log\/routerlog<\/p>\n

\/etc\/sysconfig\/rsyslog
\nSYSLOGD_OPTIONS=”-x -c 5″
\n#-x\u306f\uff24\uff2e\uff33\u53c2\u7167\u3057\u306a\u3044<\/p>\n

\/etc\/ppp\/options.pptpd
\n#ms-dns 8.8.8.8
\nms-dns 210.224.163.4
\nms-dns 210.224.163.3<\/p>\n

\/etc\/ppp\/chap-secrets
\n# Secrets for authentication using CHAP
\n# client        server  secret                  IP addresses
\nusername * ?????? *<\/p>\n

systemctl start  pptpd.service
\nsystemctl enable pptpd.service<\/p>\n

systemctl stop rsyslog.service
\nsystemctl start rsyslog.service<\/p>\n

[root@www log]# netstat -an | grep -i udp | grep 514
\nudp        0      0 0.0.0.0:514             0.0.0.0:*
\nudp6       0      0 :::514                  :::*<\/p>\n

\n[[FTP]]
\n\/etc\/vsftpd\/vsftpd.conf
\nanonymous_enable=NO
\n#listen_ipv6=YES
\nlisten=YES<\/p>\n

systemctl start vsftpd.service
\nsystemctl enable vsftpd.service<\/p>\n

[[http]]<\/p>\n

systemctl start httpd.service
\nsystemctl enable httpd.service<\/p>\n

apachectl -V
\nEVENT\u30e2\u30fc\u30c9\u306b\u306a\u3063\u3066\u306a\u3044\u3053\u3068\u3002prefork\u30e2\u30fc\u30c9\u3067\u5341\u5206\u3067\u3059\u3002<\/p>\n

\n::1 internal dummy connection\u3000\u30ed\u30b0\u6291\u5236
\n==
\nSetEnvIf User-Agent “internal dummy connection” nolog<\/p>\n

<VirtualHost *:80><\/p>\n

  ServerName    www.picolix.jp<\/p>\n

\n  ErrorLog      \/virtual\/lisa\/log\/error.log
\n  TransferLog   \/virtual\/lisa\/log\/transfer.log
\n  CustomLog     \/virtual\/lisa\/log\/www_access.log combined env=!nolog
\n==<\/p>\n

\n[[mysql]]<\/p>\n

\u65e7\u30b5\u30fc\u30d0\uff1a
\nmysqldump -ulisa -p?????????????? crenazumina > crenazuminadb-????????.txt
\nmysqldump -ulisa -p?????????????? lisa > lisadb-????????.txt
\nmysqldump -ulisa -p?????????????? mwiki > mwikidb-????????.txt
\nmysqldump -ulisa -p?????????????? opensim > opensimdb-????????.txt
\nmysqldump -ulisa -p?????????????? opensim073 > opensimdb073-????????.txt
\nmysqldump -ulisa -p?????????????? wordpress > wordpressdb-????????.txt<\/p>\n

\n\/etc\/my.cnf.d\/server.cnf
\n[mysqld]
\ncharacter-set-server = utf8<\/p>\n

\nsystemctl start mariadb.service
\nsystemctl enable mariadb.service<\/p>\n

mysql -u root -p<\/p>\n

set password for root@localhost=password(‘????????’);
\nCREATE DATABASE opensim DEFAULT CHARACTER SET utf8;
\nCREATE DATABASE crenazumina DEFAULT CHARACTER SET utf8;
\nCREATE DATABASE lisa DEFAULT CHARACTER SET ujis;
\nCREATE DATABASE opensim073 DEFAULT CHARACTER SET utf8;
\nCREATE DATABASE wordpress DEFAULT CHARACTER SET utf8;
\nCREATE DATABASE mwiki DEFAULT CHARACTER SET utf8;<\/p>\n

\nCREATE USER ‘opensim’@’localhost’ identified by ‘????????’;
\nCREATE USER ‘lisa’@’localhost’ identified by ‘??????????????’;<\/p>\n

SET PASSWORD FOR ‘opensim’@’www.picolix.jp’ = PASSWORD(‘????????’);
\nGRANT ALL ON *.* TO ‘lisa’@’localhost’;<\/p>\n

mysql -u lisa -p?????????????? crenazumina < crenazuminadb-????????.txt
\nmysql -u lisa -p?????????????? lisa < lisadb-????????.txt
\nmysql -u lisa -p?????????????? opensim < opensimdb-????????.txt
\nmysql -u lisa -p?????????????? opensim073 < opensimdb073-????????.txt
\nmysql -u lisa -p?????????????? wordpress < wordpressdb-????????.txt
\nmysql -u lisa -p?????????????? mwiki <  mwikidb-????????.txt &<\/p>\n

[[postgrtesql]]<\/p>\n

\u65e7\u30b5\u30fc\u30d0\uff1a
\npg_dump lisa -f pgdump????????.tgz -F c -Z 0 -v -U lisa
\npg_dump lisa2 -f pgdump????????-lisa2.tgz -F c -Z 0 -v -U lisa<\/p>\n

yum install postgresql postgresql-server postgresql-libs postgresql-devel postgresql-contribsu – postgres
\ninitdb –encoding=EUC_JP –no-locale
\nc
\nsystemctl enable postgresql.service<\/p>\n

-bash-4.2$ createuser -s -d -r -P lisa
\nEnter password for new role:
\nEnter it again:??????????????<\/p>\n

-bash-4.2$createdb lisa
\n-bash-4.2$createdb lisa2<\/p>\n

\n-bash-4.2$ psql
\npsql (9.2.7)
\nType “help” for help.<\/p>\n

postgres=# du
\n                             List of roles
\n Role name |                   Attributes                   | Member of
\n———–+————————————————+———–
\n lisa      | Superuser, Create role, Create DB              | {}
\n postgres  | Superuser, Create role, Create DB, Replication | {}<\/p>\n

postgres=# l
\n                             List of databases
\n   Name    |  Owner   | Encoding | Collate | Ctype |   Access privileges
\n———–+———-+———-+———+——-+———————–
\n lisa      | postgres | EUC_JP   | C       | C     |
\n postgres  | postgres | EUC_JP   | C       | C     |
\n lisa2     | postgres | EUC_JP   | C       | C     |
\n template0 | postgres | EUC_JP   | C       | C     | =c\/postgres          +
\n           |          |          |         |       | postgres=CTc\/postgres
\n template1 | postgres | EUC_JP   | C       | C     | =c\/postgres          +
\n           |          |          |         |       | postgres=CTc\/postgres<\/p>\n

postgres=# ALTER USER postgres encrypted password ‘??????????????’;
\nALTER ROLE
\npostgres=# ALTER USER lisa encrypted password ‘??????????????’;
\nALTER ROLE<\/p>\n

\/var\/lib\/pgsql\/data\/pg_hba.conf
\nlocal   all         lisa      md5<\/p>\n

systemctl restart postgresql.service<\/p>\n

[root@www data]# psql -d lisa -U lisa
\nPassword for user lisa:
\npsql (9.2.7)<\/p>\n

[root@www db]# pg_restore -d lisa -U lisa pgdump????????.tgz
\nPassword:
\npg_restore: [archiver (db)] Error while PROCESSING TOC:
\npg_restore: [archiver (db)] Error from TOC entry 508; 2612 16388 PROCEDURAL LANGUAGE plpgsql lisa
\npg_restore: [archiver (db)] could not execute query: ERROR:  language “plpgsql” already exists
\n    Command was: CREATE PROCEDURAL LANGUAGE plpgsql;<\/p>\n

[root@www db]# pg_restore -d lisa2 -U lisa pgdump????????-lisa2.tgz
\nPassword:<\/p>\n

-bash-4.2$ psql -U lisa
\nPassword for user lisa:
\npsql (9.2.7)
\nType “help” for help.<\/p>\n

lisa=# l
\n                             List of databases
\n   Name    |  Owner   | Encoding | Collate | Ctype |   Access privileges
\n———–+———-+———-+———+——-+———————–
\n lisa      | postgres | EUC_JP   | C       | C     |
\n postgres  | postgres | EUC_JP   | C       | C     |
\n lisa2     | postgres | EUC_JP   | C       | C     |
\n template0 | postgres | EUC_JP   | C       | C     | =c\/postgres          +
\n           |          |          |         |       | postgres=CTc\/postgres
\n template1 | postgres | EUC_JP   | C       | C     | =c\/postgres          +
\n           |          |          |         |       | postgres=CTc\/postgres
\n(5 rows)<\/p>\n

lisa=# d
\n                         List of relations
\n Schema |                  Name                  |   Type   | Owner
\n——–+—————————————-+———-+——-
\n public | blog_url_conv_data                     | table    | lisa
\n public | blog_url_conv_data_seq_seq             | sequence | lisa
\n public | blog_url_conv_data_url-crenazumina_seq | sequence | lisa
\n public | comsearch_release_seq                  | sequence | lisa
\n public | dmoz_link_cnt                          | table    | lisa
\n public | dmoz_link_robot                        | table    | lisa
\n public | eki_data                               | table    | lisa
\n public | nouki_mst                              | table    | lisa
\n public | pazdora                                | table    | lisa
\n public | pazdora_kskill_m                       | table    | lisa
\n public | pazdora_skill_m                        | table    | lisa
\n public | pazdora_type_m                         | table    | lisa
\n public | secondlife_history                     | table    | lisa
\n public | share_d                                | table    | lisa
\n public | sozai_dmoz_art_m                       | table    | lisa
\n public | syouhin_data                           | table    | lisa
\n public | testnouse                              | table    | lisa
\n(17 rows)<\/p>\n

-bash-4.2$ psql -U lisa
\nPassword for user lisa:
\npsql (9.2.7)
\nType “help” for help.<\/p>\n

lisa=# c lisa2
\nYou are now connected to database “lisa2” as user “lisa”.
\nlisa2=# l
\n                             List of databases
\n   Name    |  Owner   | Encoding | Collate | Ctype |   Access privileges
\n———–+———-+———-+———+——-+———————–
\n lisa      | postgres | EUC_JP   | C       | C     |
\n postgres  | postgres | EUC_JP   | C       | C     |
\n lisa2     | postgres | EUC_JP   | C       | C     |
\n template0 | postgres | EUC_JP   | C       | C     | =c\/postgres          +
\n           |          |          |         |       | postgres=CTc\/postgres
\n template1 | postgres | EUC_JP   | C       | C     | =c\/postgres          +
\n           |          |          |         |       | postgres=CTc\/postgres
\n(5 rows)<\/p>\n

lisa2=# d
\n        List of relations
\n Schema |  Name   | Type  | Owner
\n——–+———+——-+——-
\n public | share_d | table | lisa
\n public | user_m  | table | lisa
\n(2 rows)<\/p>\n

\n[[CRON]]
\n\/etc\/crontab
\nPERL5LIB=\/root\/perl5\/lib\/perl5:\/home\/shoichi\/perl5\/lib\/perl5:
\n\u2191\u3053\u308c\u304c\u306a\u3044\u3068\u3001perl\u30b9\u30af\u30ea\u30d7\u30c8\u304c\u30a8\u30e9\u30fc\u3067\u3059\u3002<\/p>\n

\/etc\/cron.d\/0hourly
\n\u5168\u3066#
\n\/etc\/cron.d\/dailyjobs
\n\u5168\u3066#<\/p>\n

systemctl stop crond.service
\nsystemctl start crond.service
\n# run-parts
\n45 * * * * root run-parts \/etc\/cron.hourly
\n46 3 * * * root run-parts \/etc\/cron.daily
\n22 4 * * 0 root run-parts \/etc\/cron.weekly
\n42 4 1 * * root run-parts \/etc\/cron.monthly
\n59 23 * * * root \/virtual\/lisa\/cron\/analog_rotate.sh > \/dev\/null 2>&1
\n2,12,22,32,42,52 * * * * root \/virtual\/lisa\/cron\/cron1.sh > \/dev\/null 2>&1<\/p>\n

[[postfix]]
\n\/etc\/postfix\/main.cf
\nmynetworks = 127.0.0.0\/8 , xxx.xxx.xxx.xxx\/32<\/p>\n

systemctl stop postfix.service
\nsystemctl start postfix.service<\/p>\n

\n[root@www cron.daily]# pwd
\n\/etc\/cron.daily
\n[root@www cron.daily]# ln -s \/virtual\/lisa\/cron\/syschk.sh syschk.sh
\n[root@www cron.daily]# ln -s \/virtual\/lisa\/cron\/viurscheck-clama.sh viurscheck-clama.sh
\ndns-x86.tar.gz
\ncp dnstran \/usr\/bin\/
\ncp analogurldecode\/usr\/bin\/analogurldecode
\nanalog-6.0.tar.gz \u7f6e\u304d\u63db\u3048\u308b
\ncp analog \/usr\/bin\/analog<\/p>\n

\n[[\u30b7\u30f3\u30dc\u30ea\u30c3\u30af\u30ea\u30f3\u30af]]
\nln -s \/bin\/mono \/usr\/local\/bin\/mono
\nln -s \/bin\/perl \/usr\/local\/bin\/perl
\nln -s \/usr\/bin\/convert \/usr\/local\/bin\/convert<\/p>\n

\n[[\u30e1\u30e2]]
\nGNOME \u65e5\u672c\u8a9e\u30d5\u30a9\u30eb\u30c0\u30fc\u3092\u82f1\u6587\u5b57\u306b
\nhttp:\/\/www.atmarkit.co.jp\/flinux\/rensai\/linuxtips\/a077changelang.html
\nteraterm
\n \u8a2d\u5b9a\u2010\u305d\u306e\u4ed6\u306e\u8a2d\u5b9a\u2010\uff21\uff2e\uff33\uff29\u30ab\u30e9\u30fc\u4ee5\u5916\u5168\u90e8\u5916\u3059
\n\/usr\/lib\/systemd\/system
\n\/lib\/systemd\/system<\/p>\n

[root@www cron.daily]# hdparm -t \/dev\/vda2
\n\/dev\/vda2:
\n Timing buffered disk reads: 486 MB in  3.03 seconds = 160.40 MB\/sec
\n[root@www23254ue backup]# hdparm -t \/dev\/vda2
\n\/dev\/vda2:
\n Timing buffered disk reads:  10 MB in  3.58 seconds =   2.79 MB\/sec
\n Timing buffered disk reads: 124 MB in  3.01 seconds =  41.13 MB\/sec<\/p>\n

\n[[\u30b5\u30fc\u30d3\u30b9]]
\n———————————-
\n[root@www ~]# cd \/usr\/lib\/systemd\/system
\n[root@www system]# cat opensim.service
\n[Unit]
\nDescription=opensim Server
\nAfter=mariadb.target<\/p>\n

[Service]
\nType=notify
\nEnvironmentFile=\/etc\/opensim.env
\nExecStart=\/usr\/bin\/screen -S $PROGNAME -d -m $MONO $OSGRID\/OpenSim.exe
\nExecStop=\/usr\/bin\/screen -S $PROGNAME -p 0 -X stuff $’quitn’ 1> \/dev\/null 2>&1<\/p>\n

KillSignal=SIGCONT
\nPrivateTmp=true<\/p>\n

[Install]
\nWantedBy=multi-user.target<\/p>\n

—-
\n\/etc\/opensim.env
\n—-
\nPROGNAME=OpenSim
\nOSGRID=\/projects\/opensim
\nMONO=\/usr\/local\/bin\/mono
\nexport MONO_THREADS_PER_CPU=125
\nexport LANG=C
\nulimit -s 262144<\/p>\n

[[\u30cd\u30c3\u30c8\u30ef\u30fc\u30af]]<\/p>\n

nmtui
\nnmcli c d “System eth0” ; sudo nmcli c u “System eth0”
\nnmcli c d “ens33” ; sudo nmcli c u “ens33”<\/p>\n","protected":false},"excerpt":{"rendered":"

\u3055\u304f\u3089\uff36\uff30\uff33\u3000CentOS6.5\u306e\u30b5\u30fc\u30d0\u3092\u65b0\u305f\u306bCentOS 7\u3092\u30af\u30ea\u30fc\u30f3\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u79fb\u884c\u3057\u307e\u3057\u305f\u3002 \uff086.5\u304b\u30897\u3078UPGRADE\u3082\u3067\u304d\u307e\u3059\u304c\u3001\u4eca\u5f8c\u306e\u3053\u3068\u3082\u8003\u3048\u3066\u30af\u30ea\u30fc\u30f3\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002\uff09 LAMP\u95a2\u4fc2\u306f\u52d5\u3044\u3066 … <\/p>\n

“\u3055\u304f\u3089\uff36\uff30\uff33\u3067\u501f\u308a\u3066\u3044\u308b\u30b5\u30fc\u30d0\u3092CentOS7\u306b\u79fb\u884c\u3057\u307e\u3057\u305f\u3002” \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[6],"_links":{"self":[{"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/posts\/60"}],"collection":[{"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/comments?post=60"}],"version-history":[{"count":1,"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/posts\/60\/revisions"}],"predecessor-version":[{"id":1384,"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/posts\/60\/revisions\/1384"}],"wp:attachment":[{"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/media?parent=60"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/categories?post=60"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/tags?post=60"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}