FreeBSD phpMyadmin の履歴(No.6)

履歴一覧
差分を表示
現在との差分を表示
ソースを表示
FreeBSD phpMyadmin へ行く。
- 1 (2009-08-26 (水) 08:49:25)
- 2 (2009-08-26 (水) 09:12:46)
- 3 (2010-01-20 (水) 09:52:50)
- 4 (2010-01-28 (木) 08:20:44)
- 5 (2010-01-29 (金) 10:12:07)
- 6 (2012-01-29 (日) 08:24:58)

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

Hotshot 2012 1 29 portinstall†

===>  Found saved configuration for diablo-jdk-1.6.0.07.02_18

Because of licensing restrictions, you must fetch the distribution
manually.

Please access

    http://www.FreeBSDFoundation.org/cgi-bin/download?download=diablo-caffe-freebsd7-i386-1.6.0_07-b02.tar.bz2

with a web browser and "Accept" the End User License Agreement for
"Caffe Diablo 1.6.0".

Please open

    http://www.oracle.com/technetwork/java/javase/downloads/index.html

in a web browser and follow the "Download" link for "Java
Cryptography Extension (JCE) Unlimited Strength Jurisdiction
Policy Files 6" to obtain the JCE policy file, jce_policy-6.zip.

Please open http://www.oracle.com/technetwork/java/javase/downloads/index.html
in a web browser and follow the "Download" link for
"JDK DST Timezone Update Tool - 1_3_45" to obtain the
time zone update file, tzupdater-1_3_45-2011n.zip.

Please place the downloaded file(s) in /usr/ports/distfiles.

*** Error code 1

Stop in /usr/ports/java/diablo-jdk16.

checking for XTST... configure: error: Package requirements (x11 xext >= 1.0.99.4 xi recordproto >= 1.13.99.1 xextproto >= 7.0.99.3 inputproto) were not met:

Requested 'xext >= 1.0.99.4' but version of Xext is 1.0.5
Requested 'recordproto >= 1.13.99.1' but version of RecordProto is 1.13.2
Requested 'xextproto >= 7.0.99.3' but version of XExtProto is 7.0.5

Consider adjusting the PKG_CONFIG_PATH environment variable if you
installed software in a non-standard prefix.

Alternatively, you may set the environment variables XTST_CFLAGS
and XTST_LIBS to avoid the need to call pkg-config.
See the pkg-config man page for more details.

===>  Script "configure" failed unexpectedly.
Please report the problem to x11@FreeBSD.org [maintainer] and attach the
"/usr/ports/x11/libXtst/work/libXtst-1.2.0/config.log" including the output
of the failure of your make command. Also, it might be a good idea to provide
an overview of all packages installed on your system (e.g. an `ls
/var/db/pkg`).
*** Error code 1

Stop in /usr/ports/x11/libXtst.
--->  Installing the new version via the port
===>   libXtst-1.2.0 depends on file:  /usr/local/libdata/pkgconfig/recordproto.pc - found
===>   libXtst-1.2.0 depends on file: /usr/local/libdata/pkgconfig/xextproto.pc - found

↑

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

とのこと。で、解決。