Difference between revisions of "Adminer"

From ArchWiki
Jump to: navigation, search
(Installation under Apache > Added/changed to Apache 2.4, for fixing the for 403 error)
Line 13: Line 13:
 
Then [[Systemd#Using_units|restart]] your [[LAMP|apache]] daemon.  
 
Then [[Systemd#Using_units|restart]] your [[LAMP|apache]] daemon.  
 
  # systemctl restart httpd
 
  # systemctl restart httpd
 
{{Note|The Adminer can be accessed by your browser on [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:
 
In case there is an (403) error, change the following lines inside the {{ic|/etc/httpd/conf/extra/httpd-adminer.conf}} file:
Line 23: Line 21:
 
         #php_admin_value open_basedir      "/srv/:/tmp/:/usr/share/webapps/:/etc/webapps:/usr/share/pear/"
 
         #php_admin_value open_basedir      "/srv/:/tmp/:/usr/share/webapps/:/etc/webapps:/usr/share/pear/"
 
  </Directory>
 
  </Directory>
 +
 +
Restart the [[Systemd#Using_units|restart]] [[LAMP|apache]] daemon again.
 +
# systemctl restart httpd
 +
 +
{{Note|The Adminer can be accessed by your browser on [http://localhost/adminer http://localhost/adminer].}}
  
 
== See also ==
 
== See also ==

Revision as of 19:10, 16 March 2014

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 official page or Wikipedia.

Installation under Apache

Ensure you do not have an older copy of Adminer:

$ rm -r /srv/http/adminer

Install adminerAUR from the AUR and add the following line to /etc/httpd/conf/httpd.conf:

Include conf/extra/httpd-adminer.conf

Then restart your apache daemon.

# systemctl restart httpd

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/"
</Directory>

Restart the restart apache daemon again.

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

See also