Difference between revisions of "Adminer"

From ArchWiki
Jump to navigation Jump to search
m (typo)
m (PHP 7.2 style php.ini)
(24 intermediate revisions by 8 users not shown)
Line 1: Line 1:
−
[[Category:Web server]]
+
[[Category:Web admin interfaces]]
 
[[cs:Adminer]]
 
[[cs:Adminer]]
 
[[ja:Adminer]]
 
[[ja:Adminer]]
−
[http://www.adminer.org/ Adminer] is a simple tool for database management. It's possible to manage [[MySQL]], [[PostgreSQL]], [[Sqlite3]], MS SQL and [[Oracle]].
+
[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.
  
−
Ensure you do not have a manually downloaded copy of Adminer installed!
+
When using the {{AUR|adminer}} package, Adminer will be installed as {{ic|/usr/share/webapps/adminer/index.php}}.
  
−
[[Install]] {{AUR|adminer}} from the [[AUR]].
+
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.
  
−
[[Install]] {{Pkg|php-sqlite}}.
+
== Configuration ==
  
−
Adminer will be installed as {{ic|/usr/share/webapps/adminer/index.php}}.
+
=== Apache ===
−
 
 
−
Don't forget to enable {{Pkg|php-sqlite}} in your {{ic|/etc/php/php.ini}} by uncommenting following line:
 
−
  extension=mysqli.so
 
−
 
 
−
{{Warning|As of PHP 5.5, {{ic|mysql.so}} is [http://www.php.net/manual/de/migration55.deprecated.php 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 {{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.
−
# systemctl restart httpd
 
  
−
{{Note|The Adminer can be accessed by your browser on [http://localhost/adminer http://localhost/adminer].}}
+
Adminer can now be accessed by browsing to [http://localhost/adminer http://localhost/adminer].
  
−
In case there is an (403) error, change the following lines inside the {{ic|/etc/httpd/conf/extra/httpd-adminer.conf}} file:
+
=== Nginx ===
−
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/"
 
−
</Directory>
 
  
−
Restart the [[restart]] [[apache]] daemon again.
+
Ensure that the [[nginx#FastCGI|PHP FastCGI interface]] is configured correctly.
−
# systemctl restart httpd
 
−
 
 
−
== Configuration under Nginx ==
 
−
 
 
−
Ensure that the [[nginx#PHP configuration|php FastCGI interface]] is configured correct.
 
−
 
 
−
Then ad the folwing {{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.
 
−
 
 
−
Afterwards restart the server with {{ic|systemctl restart nginx.service}}.
 
  
 +
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;
+
            include fastcgi.conf;
−
        #fastcgi_pass localhost:9000;
+
            #fastcgi_pass localhost:9000;
−
        fastcgi_pass unix:/run/php-fpm/php-fpm.sock;
+
            fastcgi_pass unix:/run/php-fpm/php-fpm.sock;
−
        fastcgi_index index.php;
+
            fastcgi_index index.php;
−
        fastcgi_param SCRIPT_FILENAME /usr/share/webapps/adminer$fastcgi_script_name;
+
            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
 +
 +
}
 +
}}
  
−
</nowiki>}}
+
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;
        }
}

Afterwards restart nginx.

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.

See also

Retrieved from "https://wiki.archlinux.org/index.php?title=Adminer&oldid=514065"