- 追加された行はこの色です。
- 削除された行はこの色です。
CONTENTS
#contents
----
Lastmodified &lastmod;
----
[[MySQL-GUI]]
#contents
----
*Blackcube2 portinstall [#tde78805]
**************************************************************************** [#n86da55a]
===> Installing for phpMyAdmin-4.1.7
===> Registering installation for phpMyAdmin-4.1.7
===> Creating users and/or groups.
Using existing group 'www'.
Installing phpMyAdmin-4.1.7... done
phpMyAdmin-4.1.7 has been installed into:
/usr/local/www/phpMyAdmin
Please edit config.inc.php to suit your needs.
To make phpMyAdmin available through your web site, I suggest
that you add something like the following to httpd.conf:
For Apache versions earlier than 2.4:
Alias /phpmyadmin/ "/usr/local/www/phpMyAdmin/"
<Directory "/usr/local/www/phpMyAdmin/">
Options none
AllowOverride Limit
Order Deny,Allow
Deny from all
Allow from 127.0.0.1 .example.com
</Directory>
For Apache version 2.4.x or above:
Alias /phpmyadmin/ "/usr/local/www/phpMyAdmin/"
<Directory "/usr/local/www/phpMyAdmin/">
Options None
AllowOverride Limit
Require local
Require host .example.com
</Directory>
SECURITY NOTE: phpMyAdmin is an administrative tool that has had several
remote vulnerabilities discovered in the past, some allowing remote
attackers to execute arbitrary code with the web server's user credential.
All known problems have been fixed, but the FreeBSD Security Team strongly
advises that any instance be protected with an additional protection layer,
e.g. a different access control mechanism implemented by the web server
as shown in the example. Do consider enabling phpMyAdmin only when it
is in use.
===> Cleaning for phpMyAdmin-4.1.7
The following line has been added to your /usr/local/etc/php/extensions.ini
configuration file to automatically load the installed extension:
extension=mcrypt.so
**************************************************************************** [#a7f590e3]
*portinstall databases/phpmyadmin [#s1e5986e]
===> Returning to build of phpMyAdmin-suphp-3.2.5
===> phpMyAdmin-suphp-3.2.5 depends on shared library: mysqlclient.16 - found
===> Generating temporary packing list
===> Checking if databases/phpmyadmin already installed
===> Creating users and/or groups.
Using existing group `www'.
Creating user `_pma' with uid `336'.
===> Adjusting file ownership in /usr/local/www/phpMyAdmin
phpMyAdmin-suphp-3.2.5 has been installed into:
/usr/local/www/phpMyAdmin
Please edit config.inc.php to suit your needs.
To make phpMyAdmin available through your web site, I suggest
that you add something like the following to httpd.conf:
Alias /phpmyadmin/ "/usr/local/www/phpMyAdmin/"
<Directory "/usr/local/www/phpMyAdmin/">
Options none
AllowOverride Limit
Order Deny,Allow
Deny from all
Allow from 127.0.0.1 .example.com
</Directory>
===> Registering installation for phpMyAdmin-suphp-3.2.5
===> Cleaning for suphp-0.7.1
===> Cleaning for php5-mysqli-5.2.12
===> Cleaning for phpMyAdmin-suphp-3.2.5
*erorr [#r83ac7df]
#ref(phpmyadmin_error.png)
**リンクテーブルを処理するための追加機能が無効になっています [#p15d8e7b]
http://ja.528p.com/linux/centos/SJ004-phpMyAdmin.html
*(例1)または(例2)の設定をします
警告を無視します (例1)
*config.inc.phpを修正します
$cfg['PmaNoRelation_DisableWarning'] = true;
phpmyadminという名前のデータベースを作ってリレーション機能を有効にします (例2)
*config.inc.phpを修正します (デフォルト値をそのまま使います)
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][$i]['relation'] = 'pma_relation';
$cfg['Servers'][$i]['table_info'] = 'pma_table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma_column_info';
$cfg['Servers'][$i]['history'] = 'pma_history';
$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
*SQLクエリを発行してデータベースを作成します
*phpmyadminで用意されているsqlファイルを読み込みます
# mysql -u root -p < /home/www/myhome/phpmyadmin/scripts/create_tables.sql
Enter password:← パスワード(mysql管理者)の入力
k222# cd /usr/local/www/phpMyAdmin/scripts
k222# mysql -u root -p < create_tables.sql
Enter password:
*mcrypt拡張をロードできません [#o4766c07]
portupgrade -a したあとからのような気がするが、
#ref(mcrypt.png)
の様な警告が出るようになった。phpのextensionのようなのだが、php の make config をみても、mcrypt の設定はなく、
k222# locate php5-mcrypt
/usr/Backups/Guard/usr/ports/security/php5-mcrypt
/usr/Backups/Guard/usr/ports/security/php5-mcrypt/Makefile
/usr/Backups/MailKN/usr/ports/security/php5-mcrypt
/usr/Backups/MailKN/usr/ports/security/php5-mcrypt/Makefile
/usr/ports/security/php5-mcrypt
/usr/ports/security/php5-mcrypt/Makefile
/usr/var/db/pkg/php5-mcrypt-5.2.9
/usr/var/db/pkg/php5-mcrypt-5.2.9/+COMMENT
/usr/var/db/pkg/php5-mcrypt-5.2.9/+CONTENTS
/usr/var/db/pkg/php5-mcrypt-5.2.9/+DESC
/usr/var/db/pkg/php5-mcrypt-5.2.9/+MTREE_DIRS
/usr/var/db/pkg/php5-mcrypt-5.2.9/+REQUIRED_BY
/var/db-stop/pkg/php5-mcrypt-5.2.9
/var/db-stop/pkg/php5-mcrypt-5.2.9/+COMMENT
/var/db-stop/pkg/php5-mcrypt-5.2.9/+CONTENTS
/var/db-stop/pkg/php5-mcrypt-5.2.9/+DESC
/var/db-stop/pkg/php5-mcrypt-5.2.9/+MTREE_DIRS
との仰せなので、
portupgrade php5-mcrypt-5.2.9
してみたら、
****************************************************************************
The following line has been added to your /usr/local/etc/php/extensions.ini
configuration file to automatically load the installed extension:
extension=mcrypt.so
****************************************************************************
とのこと。で、解決。
----
----
Total access &counter(total);:本日 &counter(today);:昨日 &counter(yesterday);
#counter([total|today|yesterday]);