Difference between revisions of "Adminer"
m (typo) |
m (PHP 7.2 style php.ini) |
||
(24 intermediate revisions by 8 users not shown) | |||
Line 1: | Line 1: | ||
− | [[Category:Web | + | [[Category:Web admin interfaces]] |
[[cs:Adminer]] | [[cs:Adminer]] | ||
[[ja:Adminer]] | [[ja:Adminer]] | ||
− | [http://www.adminer.org/ Adminer] is a | + | [http://www.adminer.org/ Adminer] is a web-based database management tool written in PHP. It's possible to manage [[MySQL]], [[PostgreSQL]], [[Sqlite3]], MS SQL, [[Oracle]] and [[Elasticsearch]]. |
It's a simpler alternative to [[PhpMyAdmin]]. You can find more pieces of information about this project at the [http://www.adminer.org/en/ official page] or at [[Wikipedia:Adminer|Wikipedia]]. | It's a simpler alternative to [[PhpMyAdmin]]. You can find more pieces of information about this project at the [http://www.adminer.org/en/ official page] or at [[Wikipedia:Adminer|Wikipedia]]. | ||
== Installation == | == Installation == | ||
+ | [[Install]] the {{AUR|adminer}} package or [https://www.adminer.org/#download download Adminer] and place it manually in the document-root instead. | ||
− | + | When using the {{AUR|adminer}} package, Adminer will be installed as {{ic|/usr/share/webapps/adminer/index.php}}. | |
− | + | Ensure the correct extensions in {{ic|/etc/php/php.ini}} are uncommented, e.g. {{ic|<nowiki>extension=pdo_mysql</nowiki>}} should provide [[MySQL]] database management. | |
− | + | == Configuration == | |
− | + | === Apache === | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | == | ||
Add the following line to {{ic| /etc/httpd/conf/httpd.conf}}: | Add the following line to {{ic| /etc/httpd/conf/httpd.conf}}: | ||
Line 27: | Line 21: | ||
Include conf/extra/httpd-adminer.conf | Include conf/extra/httpd-adminer.conf | ||
− | Then [[restart]] your [[apache]] daemon. | + | Then [[restart]] your [[apache]] daemon. |
− | |||
− | + | Adminer can now be accessed by browsing to [http://localhost/adminer http://localhost/adminer]. | |
− | + | === Nginx === | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | + | Ensure that the [[nginx#FastCGI|PHP FastCGI interface]] is configured correctly. | |
− | |||
− | |||
− | |||
− | |||
− | Ensure that the [[nginx#PHP | ||
− | |||
− | |||
− | |||
− | |||
+ | Then add the following {{ic|server}} block to your {{ic|/etc/nginx/nginx.conf}} or place it in a file under {{ic|/etc/nginx/servers-available/}} and [[nginx#Managing server entries|enable]] it: | ||
{{hc|/etc/nginx/nginx.conf|<nowiki> | {{hc|/etc/nginx/nginx.conf|<nowiki> | ||
server { | server { | ||
Line 66: | Line 45: | ||
index index.php; | index index.php; | ||
try_files $uri $uri/ /index.php?$args; | try_files $uri $uri/ /index.php?$args; | ||
− | + | } | |
− | location ~ .php$ { | + | location ~ .php$ { |
− | + | include fastcgi.conf; | |
− | + | #fastcgi_pass localhost:9000; | |
− | + | fastcgi_pass unix:/run/php-fpm/php-fpm.sock; | |
− | + | fastcgi_index index.php; | |
− | + | fastcgi_param SCRIPT_FILENAME /usr/share/webapps/adminer$fastcgi_script_name; | |
} | } | ||
} | } | ||
+ | </nowiki>}} | ||
+ | |||
+ | Afterwards [[restart]] [[nginx]]. | ||
+ | |||
+ | === Hiawatha === | ||
+ | |||
+ | Ensure that the [[Hiawatha#PHP|PHP FastCGI interface]]{{Broken section link}} is configured correctly. | ||
+ | |||
+ | Then add the following {{ic|VirtualHost}} block to your {{ic|/etc/hiawatha/hiawatha.conf}}. | ||
+ | {{hc|head=/etc/hiawatha/hiawatha.conf|output= | ||
+ | VirtualHost { | ||
+ | |||
+ | # If you set WebsiteRoot to /usr/share/webapps/adminer you don't need followsymlinks | ||
+ | # I symlinked the adminer folder to '/srv/http/adminer' so that I can easily remember where it's located but | ||
+ | # still set 'WebsiteRoot' to the real source directory. You could point WebsiteRoot to the | ||
+ | # symlinked directory, but you will have to set 'FollowSymlinks = yes' for that to function properly | ||
+ | |||
+ | Hostname = db.domainname.dom | ||
+ | #FollowSymlinks = yes | ||
+ | #WebsiteRoot = /srv/http/adminer | ||
+ | WebsiteRoot = /usr/share/webapps/adminer | ||
+ | AccessLogfile = /var/log/hiawatha/adminer/access.log | ||
+ | ErrorLogfile = /var/log/hiawatha/adminer/error.log | ||
+ | StartFile = index.php | ||
+ | UseFastCGI = PHP7 | ||
+ | |||
+ | } | ||
+ | }} | ||
− | + | Then [[restart]] the {{ic|hiawatha.service}}. | |
== See also == | == See also == |
Revision as of 11:02, 18 March 2018
Adminer is a web-based database management tool written in PHP. It's possible to manage MySQL, PostgreSQL, Sqlite3, MS SQL, Oracle and Elasticsearch.
It's a simpler alternative to PhpMyAdmin. You can find more pieces of information about this project at the official page or at Wikipedia.
Installation
Install the adminerAUR package or download Adminer and place it manually in the document-root instead.
When using the adminerAUR package, Adminer will be installed as /usr/share/webapps/adminer/index.php
.
Ensure the correct extensions in /etc/php/php.ini
are uncommented, e.g. extension=pdo_mysql
should provide MySQL database management.
Configuration
Apache
Add the following line to /etc/httpd/conf/httpd.conf
:
Include conf/extra/httpd-adminer.conf
Then restart your apache daemon.
Adminer can now be accessed by browsing to http://localhost/adminer.
Nginx
Ensure that the PHP FastCGI interface is configured correctly.
Then add the following server
block to your /etc/nginx/nginx.conf
or place it in a file under /etc/nginx/servers-available/
and enable it:
/etc/nginx/nginx.conf
server { listen 80; server_name db.domainname.dom; root /usr/share/webapps/adminer; # If you want to use a .htpass file, uncomment the three following lines. #auth_basic "Admin-Area! Password needed!"; #auth_basic_user_file /usr/share/webapps/adminer/.htpass; #access_log /var/log/nginx/adminer-access.log; error_log /var/log/nginx/adminer-error.log; location / { index index.php; try_files $uri $uri/ /index.php?$args; } location ~ .php$ { include fastcgi.conf; #fastcgi_pass localhost:9000; fastcgi_pass unix:/run/php-fpm/php-fpm.sock; fastcgi_index index.php; fastcgi_param SCRIPT_FILENAME /usr/share/webapps/adminer$fastcgi_script_name; } }
Hiawatha
Ensure that the PHP FastCGI interface[broken link: invalid section] is configured correctly.
Then add the following VirtualHost
block to your /etc/hiawatha/hiawatha.conf
.
/etc/hiawatha/hiawatha.conf
VirtualHost { # If you set WebsiteRoot to /usr/share/webapps/adminer you don't need followsymlinks # I symlinked the adminer folder to '/srv/http/adminer' so that I can easily remember where it's located but # still set 'WebsiteRoot' to the real source directory. You could point WebsiteRoot to the # symlinked directory, but you will have to set 'FollowSymlinks = yes' for that to function properly Hostname = db.domainname.dom #FollowSymlinks = yes #WebsiteRoot = /srv/http/adminer WebsiteRoot = /usr/share/webapps/adminer AccessLogfile = /var/log/hiawatha/adminer/access.log ErrorLogfile = /var/log/hiawatha/adminer/error.log StartFile = index.php UseFastCGI = PHP7 }
Then restart the hiawatha.service
.