Difference between revisions of "Adminer"
m (typo) |
m (typo) |
||
Line 17: | Line 17: | ||
Don't forget to enable {{Pkg|php-sqlite}} in your {{ic|/etc/php/php.ini}} by uncommenting following line: | Don't forget to enable {{Pkg|php-sqlite}} in your {{ic|/etc/php/php.ini}} by uncommenting following line: | ||
− | extension= | + | 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.}} | {{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.}} |
Revision as of 11:40, 14 December 2015
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.
Installation
Ensure you do not have a manually downloaded copy of Adminer installed!
Install adminerAUR from the AUR.
Adminer will be installed as /usr/share/webapps/adminer/index.php
.
Don't forget to enable php-sqlite in your /etc/php/php.ini
by uncommenting following line:
extension=mysqli.so
mysql.so
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
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
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
.
/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; } }