サーバー構築 : TS-WXにDebian組込み

phpMyAdmin は MySQLの操作をWebブラウザ上から行なえるようにするツールです。
ローカルのネット上からアクセスができますので、セキュリティ上からは好ましいものではありませんが、ちょっとデータを確認したい場合などは便利です。

root@meckk:~# aptitude -y install phpmyadmin The following NEW packages will be installed: dbconfig-common{a} fontconfig-config{a} javascript-common{a} libfontconfig1{a} libfreetype6{a} libgd2-xpm{a} libjpeg62{a} libjs-mootools{a} libltdl7{a} libmcrypt4{a} libpng12-0{a} libt1-5{a} libx11-6{a} libx11-data{a} libxau6{a} libxcb1{a} libxdmcp6{a} libxpm4{a} php5-gd{a} php5-mcrypt{a} php5-mysql{a} phpmyadmin ttf-dejavu-core{a} wwwconfig-common{a} 0 packages upgraded, 24 newly installed, 0 to remove and 0 not upgraded. Need to get 9643 kB of archives. After unpacking 31.7 MB will be used. Get:1 http://ftp.riken.jp/Linux/debian/debian/ squeeze/main dbconfig-common all 1.8.46+squeeze.0 [477 kB] Get:2 http://security.debian.org/ squeeze/updates/main php5-gd armel 5.3.3-7+squeeze13 [38.6 kB] Get:3 http://security.debian.org/ squeeze/updates/main php5-mcrypt armel 5.3.3-7+squeeze13 [14.9 kB] Get:4 http://security.debian.org/ squeeze/updates/main php5-mysql armel 5.3.3-7+squeeze13 [64.8 kB] Get:5 http://ftp.riken.jp/Linux/debian/debian/ squeeze/main ttf-dejavu-core all 2.31-1 [1451 kB] Get:6 http://ftp.riken.jp/Linux/debian/debian/ squeeze/main fontconfig-config all 2.8.0-2.1 [217 kB] Get:7 http://ftp.riken.jp/Linux/debian/debian/ squeeze/main wwwconfig-common all 0.2.1 [22.7 kB] Get:8 http://ftp.riken.jp/Linux/debian/debian/ squeeze/main javascript-common all 7 [3810 B] Get:9 http://ftp.riken.jp/Linux/debian/debian/ squeeze/main libfreetype6 armel 2.4.2-2.1+squeeze4 [343 kB] Get:10 http://ftp.riken.jp/Linux/debian/debian/ squeeze/main libfontconfig1 armel 2.8.0-2.1 [273 kB] Get:11 http://ftp.riken.jp/Linux/debian/debian/ squeeze/main libjpeg62 armel 6b1-1 [90.1 kB] Get:12 http://ftp.riken.jp/Linux/debian/debian/ squeeze/main libpng12-0 armel 1.2.44-1+squeeze4 [174 kB] Get:13 http://ftp.riken.jp/Linux/debian/debian/ squeeze/main libxau6 armel 1:1.0.6-1 [15.9 kB] Get:14 http://ftp.riken.jp/Linux/debian/debian/ squeeze/main libxdmcp6 armel 1:1.0.3-2 [17.9 kB] Get:15 http://ftp.riken.jp/Linux/debian/debian/ squeeze/main libxcb1 armel 1.6-1 [40.1 kB] Get:16 http://ftp.riken.jp/Linux/debian/debian/ squeeze/main libx11-data all 2:1.3.3-4 [190 kB] Get:17 http://ftp.riken.jp/Linux/debian/debian/ squeeze/main libx11-6 armel 2:1.3.3-4 [796 kB] Get:18 http://ftp.riken.jp/Linux/debian/debian/ squeeze/main libxpm4 armel 1:3.5.8-1 [40.2 kB] Get:19 http://ftp.riken.jp/Linux/debian/debian/ squeeze/main libgd2-xpm armel 2.0.36~rc1~dfsg-5 [227 kB] Get:20 http://ftp.riken.jp/Linux/debian/debian/ squeeze/main libjs-mootools all 1.2.4.0~debian1-1 [249 kB] Get:21 http://ftp.riken.jp/Linux/debian/debian/ squeeze/main libltdl7 armel 2.2.6b-2 [293 kB] Get:22 http://ftp.riken.jp/Linux/debian/debian/ squeeze/main libmcrypt4 armel 2.5.8-3.1 [81.0 kB] Get:23 http://ftp.riken.jp/Linux/debian/debian/ squeeze/main libt1-5 armel 5.1.2-3+squeeze1 [170 kB] Get:24 http://ftp.riken.jp/Linux/debian/debian/ squeeze/main phpmyadmin all 4:3.3.7-7 [4351 kB] Fetched 9643 kB in 1min 44s (92.5 kB/s) Preconfiguring packages ... Package configuration lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu Configuring phpmyadmin tqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqk x Please choose the web server that should be automatically configured to run phpMyAdmin. x x x x Web server to reconfigure automatically: x x x x [*] apache2 x x [ ] lighttpd x x x x x x <Ok> x x x mqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj Selecting previously deselected package dbconfig-common. (Reading database ... 15561 files and directories currently installed.) Unpacking dbconfig-common (from .../dbconfig-common_1.8.46+squeeze.0_all.deb) ... Selecting previously deselected package ttf-dejavu-core. Unpacking ttf-dejavu-core (from .../ttf-dejavu-core_2.31-1_all.deb) ... Selecting previously deselected package fontconfig-config. Unpacking fontconfig-config (from .../fontconfig-config_2.8.0-2.1_all.deb) ... Selecting previously deselected package wwwconfig-common. Unpacking wwwconfig-common (from .../wwwconfig-common_0.2.1_all.deb) ... Selecting previously deselected package javascript-common. Unpacking javascript-common (from .../javascript-common_7_all.deb) ... Selecting previously deselected package libfreetype6. Unpacking libfreetype6 (from .../libfreetype6_2.4.2-2.1+squeeze4_armel.deb) ... Selecting previously deselected package libfontconfig1. Unpacking libfontconfig1 (from .../libfontconfig1_2.8.0-2.1_armel.deb) ... Selecting previously deselected package libjpeg62. Unpacking libjpeg62 (from .../libjpeg62_6b1-1_armel.deb) ... Selecting previously deselected package libpng12-0. Unpacking libpng12-0 (from .../libpng12-0_1.2.44-1+squeeze4_armel.deb) ... Selecting previously deselected package libxau6. Unpacking libxau6 (from .../libxau6_1%3a1.0.6-1_armel.deb) ... Selecting previously deselected package libxdmcp6. Unpacking libxdmcp6 (from .../libxdmcp6_1%3a1.0.3-2_armel.deb) ... Selecting previously deselected package libxcb1. Unpacking libxcb1 (from .../libxcb1_1.6-1_armel.deb) ... Selecting previously deselected package libx11-data. Unpacking libx11-data (from .../libx11-data_2%3a1.3.3-4_all.deb) ... Selecting previously deselected package libx11-6. Unpacking libx11-6 (from .../libx11-6_2%3a1.3.3-4_armel.deb) ... Selecting previously deselected package libxpm4. Unpacking libxpm4 (from .../libxpm4_1%3a3.5.8-1_armel.deb) ... Selecting previously deselected package libgd2-xpm. Unpacking libgd2-xpm (from .../libgd2-xpm_2.0.36~rc1~dfsg-5_armel.deb) ... Selecting previously deselected package libjs-mootools. Unpacking libjs-mootools (from .../libjs-mootools_1.2.4.0~debian1-1_all.deb) ... Selecting previously deselected package libltdl7. Unpacking libltdl7 (from .../libltdl7_2.2.6b-2_armel.deb) ... Selecting previously deselected package libmcrypt4. Unpacking libmcrypt4 (from .../libmcrypt4_2.5.8-3.1_armel.deb) ... Selecting previously deselected package libt1-5. Unpacking libt1-5 (from .../libt1-5_5.1.2-3+squeeze1_armel.deb) ... Selecting previously deselected package php5-gd. Unpacking php5-gd (from .../php5-gd_5.3.3-7+squeeze13_armel.deb) ... Selecting previously deselected package php5-mcrypt. Unpacking php5-mcrypt (from .../php5-mcrypt_5.3.3-7+squeeze13_armel.deb) ... Selecting previously deselected package php5-mysql. Unpacking php5-mysql (from .../php5-mysql_5.3.3-7+squeeze13_armel.deb) ... Selecting previously deselected package phpmyadmin. Unpacking phpmyadmin (from .../phpmyadmin_4%3a3.3.7-7_all.deb) ... Processing triggers for man-db ... Processing triggers for libapache2-mod-php5 ... Reloading web server config: apache2. Setting up dbconfig-common (1.8.46+squeeze.0) ... Creating config file /etc/dbconfig-common/config with new version Setting up ttf-dejavu-core (2.31-1) ... Setting up fontconfig-config (2.8.0-2.1) ... Setting up wwwconfig-common (0.2.1) ... Setting up javascript-common (7) ... Setting up libfreetype6 (2.4.2-2.1+squeeze4) ... Setting up libfontconfig1 (2.8.0-2.1) ... Setting up libjpeg62 (6b1-1) ... Setting up libpng12-0 (1.2.44-1+squeeze4) ... Setting up libxau6 (1:1.0.6-1) ... Setting up libxdmcp6 (1:1.0.3-2) ... Setting up libxcb1 (1.6-1) ... Setting up libx11-data (2:1.3.3-4) ... Setting up libx11-6 (2:1.3.3-4) ... Setting up libxpm4 (1:3.5.8-1) ... Setting up libgd2-xpm (2.0.36~rc1~dfsg-5) ... Setting up libjs-mootools (1.2.4.0~debian1-1) ... Setting up libltdl7 (2.2.6b-2) ... Setting up libmcrypt4 (2.5.8-3.1) ... Setting up libt1-5 (5.1.2-3+squeeze1) ... Setting up php5-gd (5.3.3-7+squeeze13) ... Setting up php5-mcrypt (5.3.3-7+squeeze13) ... Setting up php5-mysql (5.3.3-7+squeeze13) ... Setting up phpmyadmin (4:3.3.7-7) ... Package configuration lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu Configuring phpmyadmin tqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqk x x x The phpmyadmin package must have a database installed and configured before it can be used. This can be optionally x x handled with dbconfig-common. x x x x If you are an advanced database administrator and know that you want to perform this configuration manually, or if x x your database has already been installed and configured, you should refuse this option. Details on what needs to be x x done should most likely be provided in /usr/share/doc/phpmyadmin. x x x x Otherwise, you should probably choose this option. x x x x Configure database for phpmyadmin with dbconfig-common? x x x x <Yes> <No> ←No選択 x x x mqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj dbconfig-common: writing config to /etc/dbconfig-common/phpmyadmin.conf Creating config file /etc/dbconfig-common/phpmyadmin.conf with new version Creating config file /etc/phpmyadmin/config-db.php with new version root@meckk:~# root@meckk:~# vi /etc/apache2/conf.d/phpmyadmin.conf # phpMyAdmin default Apache configuration Alias /phpmyadmin /usr/share/phpmyadmin Options FollowSymLinks DirectoryIndex index.php Order Deny,Allow Deny from all Allow from 127.0.0.1 192.168.1.0/24 AddType application/x-httpd-php .php php_flag magic_quotes_gpc Off php_flag track_vars On php_flag register_globals Off php_value include_path . # Authorize for setup AuthType Basic AuthName "phpMyAdmin Setup" AuthUserFile /etc/phpmyadmin/htpasswd.setup Require valid-user # Disallow web access to directories that don't need it Order Deny,Allow Deny from All Order Deny,Allow Deny from All root@meckk:~# /etc/init.d/apache2 restart Restarting web server: apache2 ... waiting . root@meckk:~#

[戻る] [TOP] [次へ]

（２４）phpMyAdmin