![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
CONTENTS #contents ---- Lastmodified &lastmod; ---- [[MySQL-GUI]] #contents ---- *Hotshot 2012 1 29 portinstall [#d5d72bf6] ===> Found saved configuration for diablo-jdk-1.6.0.07.02_18 *Blackcube2 portinstall [#tde78805] ===> 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 Because of licensing restrictions, you must fetch the distribution manually. phpMyAdmin-4.1.7 has been installed into: Please access /usr/local/www/phpMyAdmin http://www.FreeBSDFoundation.org/cgi-bin/download?download=diablo-caffe-freebsd7-i386-1.6.0_07-b02.tar.bz2 Please edit config.inc.php to suit your needs. with a web browser and "Accept" the End User License Agreement for "Caffe Diablo 1.6.0". To make phpMyAdmin available through your web site, I suggest that you add something like the following to httpd.conf: Please open For Apache versions earlier than 2.4: http://www.oracle.com/technetwork/java/javase/downloads/index.html Alias /phpmyadmin/ "/usr/local/www/phpMyAdmin/" 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. <Directory "/usr/local/www/phpMyAdmin/"> Options none AllowOverride Limit 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. Order Deny,Allow Deny from all Allow from 127.0.0.1 .example.com </Directory> Please place the downloaded file(s) in /usr/ports/distfiles. For Apache version 2.4.x or above: *** Error code 1 Alias /phpmyadmin/ "/usr/local/www/phpMyAdmin/" 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: <Directory "/usr/local/www/phpMyAdmin/"> Options None AllowOverride Limit 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 Require local Require host .example.com </Directory> Consider adjusting the PKG_CONFIG_PATH environment variable if you installed software in a non-standard prefix. 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. 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 ===> Cleaning for phpMyAdmin-4.1.7 *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 ＊(例１)または(例２)の設定をします 警告を無視します (例１) ＊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拡張をロードできません [#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]);
