¥Ï¡¼¥É¥Ç¥£¥¹¥¯¥á¥ó¥Æ¥Ê¥ó¥¹

¥Ï¡¼¥É¥Ç¥£¥¹¥¯¤Î¿ÇÃÇ¡¢ÊªÍý¥Õ¥©¡¼¥Þ¥Ã¥È¡¢ÀŲ»²½¡¢Linux¡¢¥µ¡¼¥Ð¡¼¡¢MySQL¤Ê¤É¤¬¥á¥¤¥ó¤À¤Ã¤¿¤Î¤Ç¤¹¤¬¡¢¤½¤Î¸å¹­¤¬¤ê¡¢¥«¥á¥é¤ä¥Ï¡¼¥É¥¦¥§¥¢¤ÎÅê¹Æ¤âÁý¤¨¤Æ¤­¤Þ¤·¤¿¡£ ¥â¥Ð¥¤¥ë¥Ç¥Ð¥¤¥¹¤Ï¡¢MacBookAir(13·¿)¡¢iPad Air2¡¢¥Ý¥á¥é DM100(¥­¥ó¥°¥¸¥à)¡¢OLYMPUS STYLUS XZ-2¤Ê¤É¡£ ¤³¤ì¤é¤ò»È¤¤¤Ê¤¬¤é¡¢¥Ö¥í¥°¤ò¹¹¿·¤·¤Æ¤¤¤Þ¤¹¡£

¥¿¥°¡§phpMyAdmin



ÅöÊý¤¬»È¤Ã¤Æ¤¤¤ëNAS(¥Õ¥¡¥¤¥ë¥µ¡¼¥Ð¡¼)¤ÏNETGEAR¤ÎReadyNAS104(RN10400-100AJS)¤Ç¤¢¤ê¡¢¥Ö¥é¥¦¥¶·Ðͳ¤ÇÁàºî¤¹¤ë¡£

RN10400-100AJS

¤¬¡¢SSH¤Ç¥·¥§¥ë¥í¥°¥¤¥ó¤¹¤ë¤³¤È¤â¤Ç¤­¤ë¡£

# ¥·¥§¥ë¥í¥°¥¤¥ó¡§¥µ¡¼¥Ð¤Ë¥í¥°¥¤¥ó¤·¡¢UNIX¥³¥Þ¥ó¥É¤Ç±ó³ÖÁàºî¤¹¤ëµ¡Ç½

¾ï»þµ¯Æ°¤·¤Æ¤¤¤ë¥Õ¥¡¥¤¥ë¥µ¡¼¥Ð¡¼¤Ë¡¢Apache,PHP,MySQL,phpMyAdmin,WordPress¤Ê¤É¤âÆþ¤ì¤é¤ì¤ë¤Î¤Ç¡¢ÊÌÅÓ»ª¤òÍÑ°Õ¤·¤Ê¤¯¤Æ¤âºÑ¤à¤È¤¤¤¦ÍøÅÀ¤¬¤¢¤ë¡£

¤·¤«¤·¡¢¤³¤ì¤Ï¡¢°Ê²¼¤ÎÍýͳ¤«¤é¥ª¥¹¥¹¥á¤·¤Ê¤¤¡£

¡¦CPU¤¬¥·¥ó¥°¥ë¥³¥¢¤ÇÃÙ¿ù¡§Marvell Armada 370 1.2GHz(1¥³¥¢1¥¹¥ì¥Ã¥É£÷£÷£÷£÷£÷)
¡¦¥á¥â¥ê¡¼¤¬512MB¤·¤«¤Ê¤¤¡£

´ØÏ¢¡§ReadyNAS214¤ÈReadyNAS104¤Î¿·µìÀ­Ç½Èæ³Ó(NETGEAR)

WordPress¤òReadyNAS104¤ËÃÖ¤¯¤È¡¢LANÆâ¤Ê¤Î¤ËŸ³«(ɽ¼¨)¤¬ÃÙ¤¤»ÏËö¤Ç¤¢¤ë(¾Ð)

¤Þ¤¿¡¢¥·¥§¥ë¥í¥°¥¤¥ó¤ÏÆ°ºîÊݾڳ°¤Ç¤¢¤ê¡¢Áàºî¤ò¥·¥¯¥Â¥ë¤ÈNAS¤Î¥Ç¡¼¥¿¤ò¼º¤¦¡£

SSH_NETGEAR

¥³¥Þ¥ó¥ÉÁàºî¤ÇÆâÉô¤Ï²¿¤Ç¤âÊѤ¨¤é¤ì¤ë¤è¤¦¤Ë¸«¤¨¤ë¤¬¡¢¤½¤¦¤¹¤ë¤È¥Ö¥é¥¦¥¶·Ðͳ¤ÇÁàºî¤¹¤ë(ËÜÍè¤Î)¥·¥¹¥Æ¥à¤È¤Î´Ö¤ËÉÔÀ°¹ç¤¬È¯À¸¡¢ÌÌÅݤʥ³¥È¤Ë¤Ê¤ê¤«¤Í¤Ê¤¤¡£

¤Æ¥³¥È¤Ç¡¢¥Õ¥¡¥¤¥ë¥µ¡¼¥Ð¡¼µ¡Ç½¤Ë¥È¥É¥á¥Æ¤ª¤¤¤¿Êý¤¬ÌµÆñ¡£

¤Þ¤¿¡¢²¿¥«¥·¥é¤ÎÀ©¸Â¤¬¤«¤«¤Ã¤Æ¤¤¤ë¤è¤¦¤Ç¡¢PHP¤Î¥¢¥Ã¥×¥Ç¡¼¥È¤¬¤Ç¤­¤Ê¤«¤Ã¤¿¤ê¤â¤¹¤ë¡£

¤Ï¥Â¤á¤Ë¡¢¥Ï¡¼¥É¥¦¥§¥¢¤Î³Îǧ¡£

OS¤Î¥Ð¡¼¥¸¥ç¥ó



cat /etc/issue

ReadyNASOS 6.10.3 \n \l

cat /etc/debian_version

8.11

CPU



cat /proc/cpuinfo

processor : 0 ¢«¡Ö0¡×¤À¤±¤Ê¤Î¤Ç¥·¥ó¥°¥ë¥³¥¢¡ª
model name : ARMv7 Processor rev 1 (v7l)
BogoMIPS : 34.37
Features : half thumb fastmult vfp edsp vfpv3 vfpv3d16 tls idivt
CPU implementer : 0x56
CPU architecture: 7
CPU variant : 0x1
CPU part : 0x581
CPU revision : 1

Hardware : Marvell Armada 370/XP (Device Tree)
Revision : 0000
Serial : 0000000000000000

¥á¥â¥ê



cat /proc/meminfo

MemTotal: 508656 kB ¢«¥á¥â¥ê¡¼¤¬512MB¤·¤«¥Ê¤ð¡ª
MemFree: 44660 kB
MemAvailable: 164540 kB
Buffers: 8428 kB
Cached: 218924 kB
SwapCached: 312 kB
Active: 183892 kB
Inactive: 126892 kB
Active(anon): 36676 kB
Inactive(anon): 73784 kB
Active(file): 147216 kB
Inactive(file): 53108 kB
Unevictable: 0 kB
Mlocked: 0 kB
HighTotal: 0 kB
HighFree: 0 kB
LowTotal: 508656 kB
LowFree: 44660 kB
SwapTotal: 1046524 kB
SwapFree: 1044532 kB
Dirty: 76 kB
Writeback: 0 kB
AnonPages: 83156 kB
Mapped: 54212 kB
Shmem: 27028 kB
Slab: 37560 kB
SReclaimable: 12228 kB
SUnreclaim: 25332 kB
KernelStack: 1512 kB
PageTables: 2820 kB
NFS_Unstable: 0 kB
Bounce: 0 kB
WritebackTmp: 0 kB
CommitLimit: 1300852 kB
Committed_AS: 797372 kB
VmallocTotal: 507904 kB
VmallocUsed: 0 kB
VmallocChunk: 0 kB

¥Ç¥£¥¹¥¯



df -h

Filesystem Size Used Avail Use% Mounted on
udev 10M 4.0K 10M 1% /dev
/dev/md0 4.0G 977M 2.8G 26% /
tmpfs 249M 0 249M 0% /dev/shm
tmpfs 249M 424K 248M 1% /run
tmpfs 125M 21M 104M 17% /run/lock
tmpfs 249M 0 249M 0% /sys/fs/cgroup
/dev/md127 8.2T 6.1T 2.1T 75% /(¥Ü¥ê¥å¡¼¥à̾)
/dev/md127 8.2T 6.1T 2.1T 75% /apps
/dev/md127 8.2T 6.1T 2.1T 75% /home
/dev/sde1 15G 524M 14G 4% /media/(USB¥á¥â¥ê¡¼Åù)

CPU»ÈÍÑΨ¤ÎÍúÎò



vmstat 2(2ÉÃËè¤Î¾ì¹ç)

¡¦us¡§¥æ¡¼¥¶¡¼CPU»þ´Ö(¥«¡¼¥Í¥ë°Ê³°¤¬»ÈÍÑ)
¡¦sy¡§¥·¥¹¥Æ¥àCPU»þ´Ö(¥«¡¼¥Í¥ë¤¬»ÈÍÑ)
¡¦id¡§¥¢¥¤¥É¥ë»þ´Ö
¡¦wa¡§IOÂÔ¤Á»þ´Ö
¡¦st¡§²¾ÁÛ¥Þ¥·¥ó¤Ë¼è¤é¤ì¤¿»þ´Ö



Î㤨¤Ð¡¢sy¤Ï¡¢´ÉÍý²èÌ̤Ƕ¦Í­¤Î¡Ö»ÈÍÑÎÌ·×»»¡×¤ò¹Ô¤¦¤È¡¢¤½¤ì¤À¤±¤Ç50%ÄøÅ٤˾徺¤¹¤ë¡£
¥¤¥«¤Ë¤³¤ÎCPU(SoC)¤¬ÈóÎϤ«Ê¬¤«¤ë¤À¤í¤¦¡£

¡ÖCtrl+C¡×¤Ç½ªÎ»

¸½ºß¤ÎÃͤΤß

top

¡ÖCtrl+C¡×¤Ç½ªÎ»

¥·¥¹¥Æ¥à¤Î²ÔƯ»þ´Ö



uptime

¥í¥°¥¤¥óÍúÎò



lastlog(¥æ¡¼¥¶¡¼Ëè¤ÎºÇ¸å¤Î¥í¥°¥¤¥ó)

last(ºÇ¶á¥í¥°¥¤¥ó¤·¤¿¥æ¡¼¥¶¤ÎÆü»þ) ¾å¤¬¿·

ɬÍץ֥ĤΥ¤¥ó¥¹¥È¡¼¥ëÅù



apt-get update

¥¤¥ó¥¹¥È¡¼¥ë²Äǽ¤Ê¥Ñ¥Ã¥±¡¼¥¸¤Î°ìÍ÷¤ò¹¹¿·¤¹¤ë¡£
¥Ñ¥Ã¥±¡¼¥¸¤Î¥¤¥ó¥¹¥È¡¼¥ë¡¢¥¢¥Ã¥×¥°¥ì¡¼¥É¤Ê¤É¤Ï¹Ô¤ï¤Ê¤¤¡£

[PR] au PAY / au WALLET ¥«¡¼¥É ¾ðÊó

¤³¤Î¥¨¥ó¥È¥ê¡¼¤ò¤Ï¤Æ¤Ê¥Ö¥Ã¥¯¥Þ¡¼¥¯¤ËÄɲà mixi¥Á¥§¥Ã¥¯



phpMyAdmin 3.4.11.1deb2

phpMyAdmin¤Îɸ½à¤Î¥Ç¥¶¥¤¥ó(¥Æ¡¼¥Þ/¥¹¥¿¥¤¥ë)¤Ï¡¢¤¤¤Ä¤·¤«pmahomme¤È¤¤¤¦¤â¤Î¤ËÊѹ¹¤Ë¤Ê¤Ã¤Æ¤¤¤ë¡£

pmahomme
pmahomme

¤·¤«¤·¡¢Á°¤Î¥Æ¡¼¥Þ(Original)¤Ë´·¤ì¤Æ¤¤¤ë¾ì¹ç¡¢Original¤ÎÊý¤¬¤¤¤¤¤³¤È¤â¤¢¤í¤¦¡£

Original
Original

¥Æ¡¼¥Þ¤Ï¡¢¥Û¡¼¥à¤Ë¤¢¤ë ³°´Ñ¤ÎÀßÄê¡ä¥Æ¡¼¥Þ/¥¹¥¿¥¤¥ë ¤«¤éÊѹ¹¤Ç¤­¤ë¡£

phpMyAdmin

­¡¤Ç¥Û¡¼¥à¤ËÈô¤Ó¡¢­¢¤Ç¥Ç¥¶¥¤¥ó¤òÁªÂò¤¹¤ë¡£

³°´Ñ¤ÎÀßÄê¡ä¥Æ¡¼¥Þ/¥¹¥¿¥¤¥ë

¤³¤ì¤ò¡¢É¸½à¤ÇOriginal¤Ë¤¹¤ë¤Ë¤Ï¡¢

/var/www/phpmyadmin/libraries

¤Ë¤¢¤ë

config.default.php

¤Î¥Õ¥¡¥¤¥ëÃæ¤Î°Ê²¼¤òOriginal¤Ë½ñ¤­´¹¤¨¤ë¡£

/**
* set up default theme, if ThemePath not empty you can set up here an valid
* path to themes or 'original' for the original pma-theme
*
* @global string $cfg['ThemeDefault']
*/
$cfg['ThemeDefault'] = 'pmahomme';

¢­

$cfg['ThemeDefault'] = 'Original';

¤Ê¤ª¡¢¥Æ¡¼¥Þ¤Î¥Õ¥¡¥¤¥ë·²¤Ï

/var/www/phpmyadmin/themes

¤Ë³ÊǼ¤µ¤ì¤Æ¤ª¤ê¡¢Â¾¤Î¥Æ¡¼¥Þ¤âÇÛÉÛ¤µ¤ì¤Æ¤¤¤ë¡£

Ê£¿ô¤Î¥µ¡¼¥Ð¡¼¤ò»ý¤Ã¤ÆÊ£¿ô¤ÎphpMyAdmin¤ò°·¤¦¾ì¹ç¡¢»î¸³¥µ¡¼¥Ð¡¼¤ÎDB¤È»×¤Ã¤ÆDROP¤·¤¿¤é¡¢¼Â¤Ï¼Â±¿ÍÑ¥µ¡¼¥Ð¡¼¤ÎDB¤Ç¤¢¤Ã¤¿¡¢¤È¤Ê¤ë¤Èº¤¤ë¡£

¤É¤Á¤é¤ÎDB¤Ç¤¢¤ë¤«Ê¬¤«¤ê¤ä¤¹¤¯¤¹¤ë¤¿¤á¡¢»î¸³¥µ¡¼¥Ð¡¼¤È¼Â±¿ÍÑ¥µ¡¼¥Ð¡¼¤ÎphpMyAdmin¤Î¥Æ¡¼¥Þ¤òÂ礭¤¯ÊѤ¨¤Æ¤ª¤¯¤È¤è¤¤¤À¤í¤¦¡£

phpMyAdmin¤Îº¸¾å¤Ë¤Ï¥¯¥ê¥Ã¥¯¤¹¤ë¤È¥Û¡¼¥à¤ËÈô¤Ö¥í¥´¤¬¤¢¤ë¤¬¡¢¤³¤ì¤ò¡Ö»î¸³¥µ¡¼¥Ð¡¼¡×¤È¤«¡Ö¼Â¥µ¡¼¥Ð¡¼¡×¤È¤«¤ËÊѤ¨¤Æ¤ª¤¯¤Èʬ¤«¤ê¤ä¤¹¤¤¤À¤í¤¦¡£

Original¤Î¾ì¹ç¤Ï

http://192.168.0.10/phpmyadmin/themes/original/img/logo_left.png

¤¬º¸¾å¤Î¥í¥´¤Ç¤¢¤ê¡¢pmahomme¤Ç¤Ï

http://192.168.0.10/phpmyadmin/themes/pmahomme/img/logo_left.png

¤Ç¤¢¤ë¡£

¤Ê¤ª¡¢phpMyAdmin¤Ç¥Æ¡¼¥Ö¥ëÁªÂò¸å¤Ë¡ÖSQL¡×¤ò¥¯¥ê¥Ã¥¯¤¹¤ë¤È¡Ö¥Ç¡¼¥¿¥Ù¡¼¥¹ xxx ¾å¤Ç¥¯¥¨¥ê¤ò¼Â¹Ô¤¹¤ë¡×¤³¤È¤¬¤Ç¤­¤ë¤¬¡¢¤³¤Îɸ½à¤ÎSQLʸ(SELECT * FROM @TABLE@ WHERE 1)¤âÊѹ¹²Äǽ¤À¡£

¾åµ­¤Îconfig.default.php¤Î³ºÅö²Õ½ê¤ò½ñ¤­´¹¤¨¤ë¡£

/**
* Default query for table
*
* @global string $cfg['DefaultQueryTable']
*/
$cfg['DefaultQueryTable'] = 'SELECT * FROM @TABLE@ WHERE 1';

¥¤¥ó¥Ý¡¼¥È¤ÎºÇĹ¥µ¥¤¥º¤Ï¤ÎÊѹ¹¤Ï¤³¤ì¤é¤ÎÀßÄê¤Ç¤Ï¤Ç¤­¤Ê¤¤¤Î¤Ç¡¢

phpMyAdmin¤Ç¤Î¥¤¥ó¥Ý¡¼¥È¥Õ¥¡¥¤¥ë¤ÎºÇŤòÊѹ¹(Debian)¤ò»²¾È¤Î¤³¤È¡£
[PR] au PAY / au WALLET ¥«¡¼¥É ¾ðÊó

¤³¤Î¥¨¥ó¥È¥ê¡¼¤ò¤Ï¤Æ¤Ê¥Ö¥Ã¥¯¥Þ¡¼¥¯¤ËÄɲà mixi¥Á¥§¥Ã¥¯



phpMyAdmin¡ä¥¤¥ó¥Ý¡¼¥È¡ä¥¤¥ó¥Ý¡¼¥È¤¹¤ë¥Õ¥¡¥¤¥ë¡ä»²¾È ¤Çsql¥Õ¥¡¥¤¥ë¤ò¾å¤²¤è¤¦¤È¤¹¤ë¤È¡¢
ÍÆÎ̤¬Â礭¤¹¤®¤Æ¼õ¤±ÉÕ¤±¤é¤ì¤Ê¤¤¤³¤È¤¬¤¢¤ë¡£

ºÇĹ:2,048KiB
(ºÇĹ:2,048KiB)

¤³¤ì¤Ï¡¢ÍÆÎ̤ξå¸Â¤¬2MB¤ËÀßÄꤵ¤ì¤Æ¤¤¤ë¤¿¤á¡£

¤¿¤Ã¤¿2MB¤È¤Ï¥Ê¥Ë¥´¥È¤«¡ª

¤³¤ÎÀßÄê¤òÊѤ¨¤ì¤Ð2MB¤ò±Û¤¨¤ë¤â¤Î¤â¥¤¥ó¥Ý¡¼¥È¤Ç¤­¤ë¤Î¤À¤¬¡¢
phpMyAdmin¤Î²èÌ̾夫¤é¤ÏÊѹ¹¤Ç¤­¤º¡¢php.ini¤Î½ñ´¹¤¨¤¬É¬Íס£

php.ini¤Î¾ì½ê

/etc/php5/apache2/php.ini

; Maximum allowed size for uploaded files.
; http://php.net/upload-max-filesize
upload_max_filesize = 2M

¢­

upload_max_filesize = 100M

¤³¤ì¤À¤±¤Ç¤ÏÍ­¸ú¤Ë¤Ê¤é¤Ê¤¤¤Î¤Ç¡¢Apache¤òºÆµ¯Æ°¤¹¤ë¡£

/etc/init.d/apache2 restart

¤¹¤ë¤È¡¢

ºÇĹ:8,192KiB
(ºÇĹ:8,192KiB)

¤È¤Ê¤ê¡¢Áý²Ã¤Ï¤·¤Æ¤¤¤ë¤¬¡¢10MB¤Ç¤Ï¤Ê¤¤¡£

8MB°Ê¾å¤Ë¤¹¤ë¾ì¹ç¤Ï¡¢¤â¤¦1²Õ½êÊѹ¹¤¹¤ëɬÍפ¬¤¢¤ë¡£

; Maximum size of POST data that PHP will accept.
; http://php.net/post-max-size
post_max_size = 8M

¢­

post_max_size = 100M

¤³¤ì¤ÇApache¤òºÆµ¯Æ°¤·¡¢³Îǧ¤¹¤ë¤È...

ºÇĹ:100MiB
(ºÇĹ:100MiB)

¤È¤Ê¤ê¡¢Â礭¤¤¥Õ¥¡¥¤¥ë¤â¥¤¥ó¥Ý¡¼¥È¤Ç¤­¤ë¤è¤¦¤Ë¤Ê¤ë¡£

¸¢¸Â¤ÎÍýͳ¤Ç¡¢phpMyAdmin¤«¤é¤ÏÊѹ¹¤Ç¤­¤Ê¤¤¤è¤¦¤Ë¤Ê¤Ã¤Æ¤¤¤ë¡£

´ØÏ¢¡§php.ini¤ÎÊÔ½¸¤äÊݸ¤¬¤Ç¤­¤Ê¤¤¾ì¹ç

¤Ç¤­¤ëPRO Apache Web¥µ¡¼¥Ð¡¼ ²þÄûÈÇ Version 2.4/2.2/2.0Âбþ (¤Ç¤­¤ëPRO¥·¥ê¡¼¥º)
ÄÔ ½¨Åµ ÅÏÊÕ ¹â»Ö ÎëÌÚ ¹¬ÉÒ ¤Ç¤­¤ë¥·¥ê¡¼¥ºÊÔ½¸Éô
¥¤¥ó¥×¥ì¥¹
Çä¤ê¾å¤²¥é¥ó¥­¥ó¥°: 192,337

½é¤á¤Æ¤ÎWeb¥µ¡¼¥Ð¡ÖApache¡×CentOS 7ÊÔ (NextPublishing)
¥¤¥ó¥×¥ì¥¹R&D (2017-05-26)
Çä¤ê¾å¤²¥é¥ó¥­¥ó¥°: 35,780

¥µ¡¼¥Ð¹½Ãۤμºݤ¬¤ï¤«¤ë Apache[¼ÂÁ©]±¿ÍÑ/´ÉÍý (Software Design plus)
ÄáĹ Äðì
µ»½ÑɾÏÀ¼Ò
Çä¤ê¾å¤²¥é¥ó¥­¥ó¥°: 116,112


[PR] au PAY / au WALLET ¥«¡¼¥É ¾ðÊó

¤³¤Î¥¨¥ó¥È¥ê¡¼¤ò¤Ï¤Æ¤Ê¥Ö¥Ã¥¯¥Þ¡¼¥¯¤ËÄɲà mixi¥Á¥§¥Ã¥¯

¤³¤Î¥Ú¡¼¥¸¤Î¥È¥Ã¥×¥Ø