{"id":267,"date":"2015-09-07T16:10:50","date_gmt":"2015-09-07T16:10:50","guid":{"rendered":"http:\/\/onlinelab.info\/?p=267"},"modified":"2015-09-07T16:10:50","modified_gmt":"2015-09-07T16:10:50","slug":"manage-postgresql-using-phppgadmin-on-centos-7","status":"publish","type":"post","link":"https:\/\/www.asianux.org.vn\/index.php\/2015\/09\/07\/manage-postgresql-using-phppgadmin-on-centos-7\/","title":{"rendered":"Manage PostgreSQL using phpPgAdmin on CentOS 7"},"content":{"rendered":"

\"phpPgAdmin\"phpPgAdmin is a web based administration tool for managing PostgreSQL database, it is very similar in look of phpMyAdmin. If you have a work experience on phpMyAdmin, you wont take much time in finding the way to work with. This guide will help you to setup phpPgAdmin on CentOS 7 \/ RHEL 7.<\/p>\n

Installing phpPgAdmin:<\/strong><\/h3>\n

Before installing, take a look at how to install PostgreSQL on CentOS 7<\/a>. If you have followed PostgrqSQL install, you do not need to steup EPEL.<\/p>\n

Here is the link to setup EPEL repository on CentOS 7<\/a>.<\/p>\n

\n\n\n\n
\n
yum -y install phpPgAdmin php-pgsql httpd php<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
Configuring phpPgAdmin:<\/strong><\/h3>\n
Edit\u00a0 \/etc\/phpPgAdmin\/config.inc.php file, we have to modify the admin file to enable the browser access.<\/p>\n
\n\n\n\n
\n
vi \/etc\/phpPgAdmin\/config.inc.php<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
Add the localhost in the following server parameter.<\/p>\n
\n\n\n\n
\n
$conf['servers'][0]['host'] = 'localhost';<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
If extra login security is true, then logins via phpPgAdmin with no password or certain usernames (pgsql, postgres, root, administrator<\/strong>) will be denied. To enable the postgres login, change it to false.<\/p>\n
\n\n\n\n
\n
$conf['extra_login_security'] = false;<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
To simply hide other databases in the list make following condition to true \u2013 this does not in any way prevent your users from seeing other database by other means.<\/p>\n
\n\n\n\n
\n
$conf['owned_only'] = true;<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
Configuring PostgreSQL:<\/strong><\/h3>\n
Modify config file to accept the authentication from the remote networks.<\/p>\n
\n\n\n\n
\n
vi \/var\/lib\/pgsql\/9.3\/data\/pg_hba.conf<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
Please enter the value as per your requirements inIPv4 and Ipv6 connections and make sure it accepts md5 passwords.<\/p>\n
\n\n\n\n
\n
# IPv4 local connections:\nhost\u00a0\u00a0\u00a0 all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 127.0.0.1\/32\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 md5\nhost\u00a0\u00a0\u00a0 all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 192.168.2.0\/24\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 md5\n# IPv6 local connections:\nhost\u00a0\u00a0\u00a0 all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ::1\/128\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 md5<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
Configuring Apche:<\/strong><\/h3>\n
By-default phpPgAdmin places the web config file in \/etc\/httpd\/conf.d<\/strong> directory; it has the rules and access permission for the web access. In CentOS 7, web access is managed by mod_authz_core.c<\/strong>module; so normal allow or deny rules wont work even if you modify.<\/p>\n
\n\n\n\n
\n
vi \/etc\/httpd\/conf.d\/phpPgAdmin.conf<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
Default config will look like below.<\/p>\n
\n
Alias \/phpPgAdmin \/usr\/share\/phpPgAdmin<\/p>\n
<Location \/phpPgAdmin>
\n<IfModule mod_authz_core.c>
\n# Apache 2.4
\nRequire local
\n#Require host example.com
\n<\/IfModule>
\n<IfModule !mod_authz_core.c>
\n# Apache 2.2
\nOrder deny,allow
\nDeny from all
\nAllow from 127.0.0.1
\nAllow from ::1
\n# Allow from .example.com
\n<\/IfModule>
\n<\/Location><\/p>\n<\/div>\n
Please comment Require local<\/strong> and add Require all granted<\/strong> just below to commented line, it will look like below.<\/p>\n
\n
Alias \/phpPgAdmin \/usr\/share\/phpPgAdmin<\/p>\n
<Location \/phpPgAdmin>
\n<IfModule mod_authz_core.c>
\n# Apache 2.4
\n# Require local<\/strong>
\nRequire all granted<\/strong>
\n#Require host example.com
\n<\/IfModule>
\n<IfModule !mod_authz_core.c>
\n# Apache 2.2
\nOrder deny,allow
\nDeny from all
\nAllow from 127.0.0.1
\nAllow from ::1
\n# Allow from .example.com
\n<\/IfModule>
\n<\/Location><\/p>\n<\/div>\n
Restart the services.<\/p>\n
\n\n\n\n
\n
systemctl restart postgresql-9.3.service\n\u00a0\nsystemctl restart httpd.service<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
Accessing phpPgAdmin:<\/strong><\/h3>\n
Now access the phpPgAdmin from the browser, url will be http:\/\/your-ip-address\/phpPgAdmin<\/strong>.<\/p>\n
\"CentOS
CentOS 7 \u2013 phpPgAdmin Home page<\/figcaption><\/figure>\n
Login by using postgres user.<\/p>\n
\"CentOS
CentOS 7 \u2013 phpPgAdmin Login page<\/figcaption><\/figure>\n
You will get the database page.<\/p>\n
\"CentOS
CentOS 7 \u2013 phpPgAdmin Databases<\/figcaption><\/figure>\n
That\u2019s All. Hope this helped you, we welcome your comments.<\/p>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
phpPgAdmin is a web based administration tool for managing PostgreSQL database, it is very similar in look of phpMyAdmin. If you have a work experience on phpMyAdmin, you wont take much time in finding the…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-267","post","type-post","status-publish","format-standard","hentry","category-database"],"_links":{"self":[{"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/posts\/267","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/comments?post=267"}],"version-history":[{"count":0,"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/posts\/267\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/media?parent=267"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/categories?post=267"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/tags?post=267"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}