PhpMyAdmin: Difference between revisions

From Q
Jump to navigation Jump to search
Tgurr (talk | contribs)
No edit summary
Tgurr (talk | contribs)
No edit summary
Line 1: Line 1:
== Apache Konfiguration ==
== Apache vhost configuration ==


{{Box File|/etc/apache2/vhosts.d/phpmyadmin.<domain>.conf|
{{Box File|/etc/apache2/vhosts.d/phpmyadmin.<domain>.conf|
Line 21: Line 21:
     php_admin_value upload_tmp_dir /var/www/phpmyadmin.<domain>/tmp
     php_admin_value upload_tmp_dir /var/www/phpmyadmin.<domain>/tmp
     php_admin_value session.save_path /var/www/phpmyadmin.<domain>/session
     php_admin_value session.save_path /var/www/phpmyadmin.<domain>/session
    Alias / /var/www/phpmyadmin.<domain>/htdocs/phpmyadmin/
</VirtualHost>
</VirtualHost>
</pre>
</pre>
Line 39: Line 36:
{{Codeline|# emerge phpmyadmin}}
{{Codeline|# emerge phpmyadmin}}


{{Codeline|# webapp-config -I -h phpmyadmin.<domain> -d phpmyadmin phpmyadmin <version>}}
{{Codeline|# webapp-config -I -h phpmyadmin.<domain> phpmyadmin <version>}}


{{Codeline|# mysql -u root -p < /usr/share/webapps/phpmyadmin/<version>/htdocs/scripts/create_tables_mysql_4_1_2+.sql}}
{{Codeline|# mysql -u root -p < /usr/share/webapps/phpmyadmin/<version>/htdocs/scripts/create_tables.sql}}
 
http://phpmyadmin.<domain>/scripts/setup.php aufrufen. Auf "Servers" - "Add" klicken, "Authentification Type" - "http" wählen und die Konfiguration anschließend unter /var/www/phpmyadmin.<domain>/htdocs/phpmyadmin/config.inc.php ablegen.
Damit niemand die Setup Skripte aufrufen kann kopiert man am besten noch die .htaccess Datei in das entsprechende Verzeichnis:
{{Codeline|# cp /var/www/phpmyadmin.<domain>/htdocs/phpmyadmin/libraries/.htaccess /var/www/phpmyadmin.<domain>/htdocs/phpmyadmin/scripts/}}




== Configuration ==
== Configuration ==


{{Box File|/var/www/phpmyadmin.<domain>/htdocs/phpmyadmin/config.inc.php|
{{Box File|/var/www/phpmyadmin.<domain>/htdocs/config.inc.php|
<pre>
<pre>
$cfg['PmaAbsoluteUri'] = 'http://phpmyadmin.<domain>/';
$cfg['PmaAbsoluteUri'] = 'http://phpmyadmin.<domain>/';
Line 85: Line 78:
</pre>
</pre>
}}
}}
To make the setup scripts inaccessible you should copy the .htaccess file to the scripts directory.
{{Codeline|# cp /var/www/phpmyadmin.<domain>/htdocs/libraries/.htaccess /var/www/phpmyadmin.<domain>/htdocs/scripts/}}




Line 91: Line 88:
{{Codeline|# emerge phpmyadmin}}
{{Codeline|# emerge phpmyadmin}}


{{Codeline|# webapp-config -U -h phpmyadmin.<domain> -d phpmyadmin phpmyadmin <neueversion>}}
{{Codeline|# webapp-config -U -h phpmyadmin.<domain> phpmyadmin <newversion>}}


{{Codeline|# <nowiki>CONFIG_PROTECT="/var/www/phpmyadmin.<domain>/htdocs/phpmyadmin//libraries" etc-update</nowiki> }}
{{Codeline|# <nowiki>CONFIG_PROTECT="/var/www/phpmyadmin.<domain>/htdocs//libraries" etc-update</nowiki> }}


{{Codeline|# 1}}
{{Codeline|# 1}}
Line 103: Line 100:
{{Codeline|# y}}
{{Codeline|# y}}


{{Codeline|# emerge -C phpmyadmin-<alteversion>}}
{{Codeline|# emerge -C phpmyadmin-<oldversion>}}

Revision as of 15:22, 14 October 2010

Apache vhost configuration

Template:Box File


Installation

Template:Box File

# emerge phpmyadmin

# webapp-config -I -h phpmyadmin.<domain> phpmyadmin <version>

# mysql -u root -p < /usr/share/webapps/phpmyadmin/<version>/htdocs/scripts/create_tables.sql


Configuration

Template:Box File

To make the setup scripts inaccessible you should copy the .htaccess file to the scripts directory.

# cp /var/www/phpmyadmin.<domain>/htdocs/libraries/.htaccess /var/www/phpmyadmin.<domain>/htdocs/scripts/


Update

# emerge phpmyadmin

# webapp-config -U -h phpmyadmin.<domain> phpmyadmin <newversion>

# CONFIG_PROTECT="/var/www/phpmyadmin.<domain>/htdocs//libraries" etc-update

# 1

# q

# 2

# y

# emerge -C phpmyadmin-<oldversion>