Difference between revisions of "Adminer"

From ArchWiki
Jump to: navigation, search
(Installation: A bit easier to understand, pdo_mysql instead of mysqli)
(Configuration under Nginx: Clean-up, few spelling fixes)
Line 29: Line 29:
 
Ensure that the [[nginx#PHP configuration|php FastCGI interface]] is configured correct.
 
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.
+
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.
  
 
Afterwards restart the server with {{ic|systemctl restart nginx.service}}.
 
Afterwards restart the server with {{ic|systemctl restart nginx.service}}.
Line 48: Line 48:
 
                 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>}}
 
</nowiki>}}
  

Revision as of 21:47, 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

Install adminerAUR - Adminer will be installed as /usr/share/webapps/adminer/index.php. Ensure the correct extensions in /etc/php/php.ini are uncommenting, e.g. extension=pdo_mysql.so should provide MySQL database management.

Warning: As of PHP 5.5, 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
Note: The Adminer can be accessed by your browser on http://localhost/adminer.

In case there is an (403) error, comment the php_admin_value line inside /etc/httpd/conf/extra/httpd-adminer.conf.

Configuration under Nginx

Ensure that the php FastCGI interface is configured correct.

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.

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;
        }
}

See also