FreeBSD phpMyadmin

CONTENTS

Blackcube2 portinstall
portinstall databases/phpmyadmin
erorr
- リンクテーブルを処理するための追加機能が無効になっています
mcrypt拡張をロードできません

Lastmodified　2014-02-18 (火) 09:17:52

Blackcube2 portinstall
portinstall databases/phpmyadmin
erorr
- リンクテーブルを処理するための追加機能が無効になっています
mcrypt拡張をロードできません

Blackcube2 portinstall†

===>  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

↑

portinstall databases/phpmyadmin†

===>   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†

↑

リンクテーブルを処理するための追加機能が無効になっています†

http://ja.528p.com/linux/centos/SJ004-phpMyAdmin.html

＊(例１)または(例２)の設定をします

警告を無視します (例１)

＊config.inc.phpを修正します

$cfg['PmaNoRelation_DisableWarning'] = true;

phpmyadminという名前のデータベースを作ってリレーション機能を有効にします (例２)

＊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拡張をロードできません†

portupgrade -a したあとからのような気がするが、

の様な警告が出るようになった。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 2189：本日 1：昨日 0

Counter: 2189, today: 1, yesterday: 0