- 追加された行はこの色です。
- 削除された行はこの色です。
[[MySQL-GUI]]
#contents
----
*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
****************************************************************************
とのこと。で、解決。
----