FreeBSD phpMyadmin
をテンプレートにして作成
[
トップ
] [
新規
|
一覧
|
検索
|
最終更新
|
ヘルプ
|
ログイン
]
開始行:
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 su...
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...
remote vulnerabilities discovered in the past, some allo...
attackers to execute arbitrary code with the web server'...
All known problems have been fixed, but the FreeBSD Secu...
advises that any instance be protected with an additiona...
e.g. a different access control mechanism implemented by...
as shown in the example. Do consider enabling phpMyAdmi...
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:...
===> 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 su...
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)
**リンクテーブルを処理するための追加機能が無効になってい...
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_c...
＊SQLクエリを発行してデータベースを作成します
＊phpmyadminで用意されているsqlファイルを読み込みます
# mysql -u root -p < /home/www/myhome/phpmyadmin/scripts...
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のようなのだ...
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/Makef...
/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...
configuration file to automatically load the installed e...
extension=mcrypt.so
********************************************************...
とのこと。で、解決。
----
----
Total access &counter(total);：本日 &counter(today);：昨...
#counter([total|today|yesterday]);
終了行:
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 su...
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...
remote vulnerabilities discovered in the past, some allo...
attackers to execute arbitrary code with the web server'...
All known problems have been fixed, but the FreeBSD Secu...
advises that any instance be protected with an additiona...
e.g. a different access control mechanism implemented by...
as shown in the example. Do consider enabling phpMyAdmi...
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:...
===> 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 su...
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)
**リンクテーブルを処理するための追加機能が無効になってい...
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_c...
＊SQLクエリを発行してデータベースを作成します
＊phpmyadminで用意されているsqlファイルを読み込みます
# mysql -u root -p < /home/www/myhome/phpmyadmin/scripts...
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のようなのだ...
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/Makef...
/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...
configuration file to automatically load the installed e...
extension=mcrypt.so
********************************************************...
とのこと。で、解決。
----
----
Total access &counter(total);：本日 &counter(today);：昨...
#counter([total|today|yesterday]);
ページ名:
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
