FreeBSD phpMyadmin の履歴の現在との差分(No.2)

履歴一覧
差分を表示
ソースを表示
履歴を表示
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)
追加された行はこの色です。
削除された行はこの色です。
CONTENTS
#contents
----
Lastmodified　&lastmod;
----
[[MySQL-GUI]]
#contents
----
*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
 
 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 [#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]);