From ArchWiki
Revision as of 11:47, 14 December 2015 by Wabuo (talk | contribs) (formating)
Jump to navigation Jump to search

Adminer is a simple tool for database management. It's possible to manage MySQL, PostgreSQL, Sqlite3, MS SQL and Oracle.

It's a simpler alternative to PhpMyAdmin. You can find more pieces of information about this project at the official page or at Wikipedia.


Ensure you do not have a manually downloaded copy of Adminer installed!

Install adminerAUR.

Adminer will be installed as /usr/share/webapps/adminer/index.php.

Don't forget to enable in your /etc/php/php.ini by uncommenting following line:
Warning: As of PHP 5.5, is deprecated and will fill up your log files with error messages. It is no longer available in PHP 7.0.

Configuration under Apache

Add the following line to /etc/httpd/conf/httpd.conf:

Include conf/extra/httpd-adminer.conf

Then restart your apache daemon.

# systemctl restart httpd
Note: The Adminer can be accessed by your browser on http://localhost/adminer.

In case there is an (403) error, change the following lines inside the /etc/httpd/conf/extra/httpd-adminer.conf file:

Alias /adminer "/usr/share/webapps/adminer"
<Directory "/usr/share/webapps/adminer">
     AllowOverride All
     Require all granted
     #php_admin_value open_basedir "/srv/:/tmp/:/usr/share/webapps/:/etc/webapps:/usr/share/pear/"

Restart the restart apache daemon again.

# systemctl restart httpd

Configuration under Nginx

Ensure that the php FastCGI interface is configured correct.

Then ad the folwing server block to your /etc/nginx/nginx.conf or place it in a file under /etc/nginx/servers-available/ and enable it.

Afterwards restart the server with systemctl restart nginx.service.

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;

See also