LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (https://www.linuxquestions.org/questions/linux-server-73/)
-   -   setting up phpPgAdmin on CentOS 7 (https://www.linuxquestions.org/questions/linux-server-73/setting-up-phppgadmin-on-centos-7-a-4175517291/)

andrewm659 09-03-2014 11:56 AM

setting up phpPgAdmin on CentOS 7
 
I'm having some trouble getting phpPgAdmin working on CentOS 7. Here are some of the configs. I am getting page forbidden.


[root@asm-sql01 phpPgAdmin]# pwd
/usr/share/phpPgAdmin
[root@asm-sql01 phpPgAdmin]# ls -lah
total 748K
drwxr-xr-x 12 root root 4.0K Sep 3 02:28 .
drwxr-xr-x. 103 root root 4.0K Sep 3 11:36 ..
-rw-r--r-- 1 root root 29K Apr 14 2013 admin.php
-rw-r--r-- 1 root root 16K Apr 14 2013 aggregates.php
-rw-r--r-- 1 root root 2.5K Apr 14 2013 ajax-ac-insert.php
-rw-r--r-- 1 root root 18K Apr 14 2013 all_db.php
-rw-r--r-- 1 root root 3.0K Apr 14 2013 browser.php
-rw-r--r-- 1 root root 2.1K Apr 14 2013 casts.php
drwxr-xr-x 3 root root 139 Sep 3 02:28 classes
-rw-r--r-- 1 root root 12K Apr 14 2013 colproperties.php
drwxr-xr-x 2 root root 53 Sep 3 10:28 conf
-rw-r--r-- 1 root root 23K Apr 14 2013 constraints.php
-rw-r--r-- 1 root root 1.9K Apr 14 2013 conversions.php
-rw-r--r-- 1 root root 30K Apr 14 2013 database.php
-rw-r--r-- 1 root root 11K Apr 14 2013 dataexport.php
-rw-r--r-- 1 root root 7.5K Apr 14 2013 dataimport.php
-rw-r--r-- 1 root root 4.3K Apr 14 2013 dbexport.php
-rw-r--r-- 1 root root 27K Apr 14 2013 display.php
-rw-r--r-- 1 root root 19K Apr 14 2013 domains.php
-rw-r--r-- 1 root root 36K Apr 14 2013 fulltext.php
-rw-r--r-- 1 root root 6.3K Apr 14 2013 functions.js
-rw-r--r-- 1 root root 38K Apr 14 2013 functions.php
-rw-r--r-- 1 root root 8.9K Apr 14 2013 groups.php
drwxr-xr-x 2 root root 4.0K Sep 3 02:28 help
-rw-r--r-- 1 root root 1.6K Apr 14 2013 help.php
-rw-r--r-- 1 root root 6.1K Apr 14 2013 history.php
drwxr-xr-x 3 root root 19 Sep 3 02:28 images
-rw-r--r-- 1 root root 1.8K Apr 14 2013 indexes.js
-rw-r--r-- 1 root root 14K Apr 14 2013 indexes.php
-rw-r--r-- 1 root root 861 Apr 14 2013 index.php
-rw-r--r-- 1 root root 12K Apr 14 2013 info.php
-rw-r--r-- 1 root root 2.0K Apr 15 2013 intro.php
drwxr-xr-x 2 root root 64 Sep 3 02:28 js
drwxr-xr-x 2 root root 4.0K Sep 3 02:28 lang
-rw-r--r-- 1 root root 1.6K Apr 14 2013 languages.php
drwxr-xr-x 4 root root 116 Sep 3 02:28 libraries
-rw-r--r-- 1 root root 520 Apr 14 2013 links.js
-rw-r--r-- 1 root root 2.4K Apr 14 2013 login.php
-rw-r--r-- 1 root root 265 Apr 14 2013 logout.php
-rw-r--r-- 1 root root 220 Apr 14 2013 multiactionform.js
-rw-r--r-- 1 root root 1.9K Apr 14 2013 opclasses.php
-rw-r--r-- 1 root root 7.9K Apr 14 2013 operators.php
-rw-r--r-- 1 root root 121 Apr 14 2013 plugin.php
drwxr-xr-x 4 root root 36 Sep 3 02:28 plugins
-rw-r--r-- 1 root root 12K Apr 14 2013 privileges.php
-rw-r--r-- 1 root root 667 Apr 14 2013 redirect.php
-rw-r--r-- 1 root root 221 Apr 14 2013 robots.txt
-rw-r--r-- 1 root root 32K Apr 14 2013 roles.php
-rw-r--r-- 1 root root 7.4K Apr 14 2013 rules.php
-rw-r--r-- 1 root root 16K Apr 14 2013 schemas.php
-rw-r--r-- 1 root root 24K Apr 14 2013 sequences.php
-rw-r--r-- 1 root root 4.3K Apr 14 2013 servers.php
-rw-r--r-- 1 root root 6.5K Apr 14 2013 sqledit.php
-rw-r--r-- 1 root root 8.1K Apr 14 2013 sql.php
-rw-r--r-- 1 root root 740 Apr 14 2013 tables.js
-rw-r--r-- 1 root root 9.8K Apr 14 2013 tablespaces.php
-rw-r--r-- 1 root root 37K Apr 14 2013 tables.php
-rw-r--r-- 1 root root 28K Apr 14 2013 tblproperties.php
drwxr-xr-x 5 root root 83 Sep 3 02:28 themes
-rw-r--r-- 1 root root 13K Apr 14 2013 triggers.php
-rw-r--r-- 1 root root 25K Apr 14 2013 types.php
-rw-r--r-- 1 root root 16K Apr 14 2013 users.php
-rw-r--r-- 1 root root 19K Apr 14 2013 viewproperties.php
-rw-r--r-- 1 root root 28K Apr 14 2013 views.php
drwxr-xr-x 2 root root 42 Sep 3 02:28 xloadtree
[root@asm-sql01 phpPgAdmin]# ls -lahd
drwxr-xr-x 12 root root 4.0K Sep 3 02:28 .
[root@asm-sql01 phpPgAdmin]#





[root@asm-sql01 phpPgAdmin]# cat /etc/httpd/conf.d/phpPgAdmin.conf
#
# This configuration file maps the phpPgAdmin directory into the URL space.
# By default this application is only accessible from the local host.
#

Alias /phpPgAdmin /usr/share/phpPgAdmin
Alias /phppgadmin /usr/share/phpPgAdmin

<Location /phpPgAdmin>
<IfModule mod_authz_core.c>
# Apache 2.4
Require local
#Require host example.com
</IfModule>
<IfModule !mod_authz_core.c>
# Apache 2.2
Order deny,allow
#Deny from all
Allow from All
</IfModule>
</Location>

[root@asm-sql01 phpPgAdmin]#

[root@asm-sql01 phpPgAdmin]# cat /etc/phpPgAdmin/config.inc.php
<?php

/**
* Central phpPgAdmin configuration. As a user you may modify the
* settings here for your particular configuration.
*
* $Id: config.inc.php-dist,v 1.55 2008/02/18 21:10:31 xzilla Exp $
*/

// An example server. Create as many of these as you wish,
// indexed from zero upwards.

// Display name for the server on the login screen
$conf['servers'][0]['desc'] = 'PostgreSQL';

// Hostname or IP address for server. Use '' for UNIX domain socket.
// use 'localhost' for TCP/IP connection on this computer
$conf['servers'][0]['host'] = '10.150.1.80';

// Database port on server (5432 is the PostgreSQL default)
$conf['servers'][0]['port'] = 5432;

// Database SSL mode
// Possible options: disable, allow, prefer, require
// To require SSL on older servers use option: legacy
// To ignore the SSL mode, use option: unspecified
$conf['servers'][0]['sslmode'] = 'allow';

// Change the default database only if you cannot connect to template1.
// For a PostgreSQL 8.1+ server, you can set this to 'postgres'.
$conf['servers'][0]['defaultdb'] = 'template1';

// Specify the path to the database dump utilities for this server.
// You can set these to '' if no dumper is available.
$conf['servers'][0]['pg_dump_path'] = '/usr/bin/pg_dump';
$conf['servers'][0]['pg_dumpall_path'] = '/usr/bin/pg_dumpall';

// Example for a second server (PostgreSQL for Windows)
//$conf['servers'][1]['desc'] = 'Test Server';
//$conf['servers'][1]['host'] = '127.0.0.1';
//$conf['servers'][1]['port'] = 5432;
//$conf['servers'][1]['sslmode'] = 'allow';
//$conf['servers'][1]['defaultdb'] = 'template1';
//$conf['servers'][1]['pg_dump_path'] = 'C:\\Program Files\\PostgreSQL\\8.0\\bin\\pg_dump.exe';
//$conf['servers'][1]['pg_dumpall_path'] = 'C:\\Program Files\\PostgreSQL\\8.0\\bin\\pg_dumpall.exe';


/* Groups definition */
/* Groups allow administrators to logicaly group servers together under
* group nodes in the left browser tree
*
* The group '0' description
*/
//$conf['srv_groups'][0]['desc'] = 'group one';

/* Add here servers indexes belonging to the group '0' seperated by comma */
//$conf['srv_groups'][0]['servers'] = '0,1,2';

/* A server can belong to multi groups. Here server 1 is referenced in both
* 'group one' and 'group two'*/
//$conf['srv_groups'][1]['desc'] = 'group two';
//$conf['srv_groups'][1]['servers'] = '3,1';

/* A group can be nested in one or more existing groups using the 'parents'
* parameter. Here the group 'group three' contains only one server and will
* appear as a subgroup in both 'group one' and 'group two':
*/
//$conf['srv_groups'][2]['desc'] = 'group three';
//$conf['srv_groups'][2]['servers'] = '4';
//$conf['srv_groups'][2]['parents'] = '0,1';

/* Warning: Only groups with no parents appears at the root of the tree. */


// Default language. E.g.: 'english', 'polish', etc. See lang/ directory
// for all possibilities. If you specify 'auto' (the default) it will use
// your browser preference.
$conf['default_lang'] = 'auto';

// AutoComplete uses AJAX interaction to list foreign key values
// on insert fields. It currently only works on single column
// foreign keys. You can choose one of the following values:
// 'default on' enables AutoComplete and turns it on by default.
// 'default off' enables AutoComplete but turns it off by default.
// 'disable' disables AutoComplete.
$conf['autocomplete'] = 'default on';

// If extra login security is true, then logins via phpPgAdmin with no
// password or certain usernames (pgsql, postgres, root, administrator)
// will be denied. Only set this false once you have read the FAQ and
// understand how to change PostgreSQL's pg_hba.conf to enable
// passworded local connections.
$conf['extra_login_security'] = false;

// Only show owned databases?
// Note: This will simply hide other databases in the list - this does
// not in any way prevent your users from seeing other database by
// other means. (e.g. Run 'SELECT * FROM pg_database' in the SQL area.)
$conf['owned_only'] = false;

// Display comments on objects? Comments are a good way of documenting
// a database, but they do take up space in the interface.
$conf['show_comments'] = true;

// Display "advanced" objects? Setting this to true will show
// aggregates, types, operators, operator classes, conversions,
// languages and casts in phpPgAdmin. These objects are rarely
// administered and can clutter the interface.
$conf['show_advanced'] = false;

// Display "system" objects?
$conf['show_system'] = false;

// Minimum length users can set their password to.
$conf['min_password_length'] = 1;

// Width of the left frame in pixels (object browser)
$conf['left_width'] = 200;

// Which look & feel theme to use
$conf['theme'] = 'default';

// Show OIDs when browsing tables?
$conf['show_oids'] = false;

// Max rows to show on a page when browsing record sets
$conf['max_rows'] = 30;

// Max chars of each field to display by default in browse mode
$conf['max_chars'] = 50;

// Send XHTML strict headers?
$conf['use_xhtml_strict'] = false;

// Base URL for PostgreSQL documentation.
// '%s', if present, will be replaced with the PostgreSQL version
// (e.g. 8.4 )
$conf['help_base'] = 'http://www.postgresql.org/docs/%s/interactive/';

// Configuration for ajax scripts
// Time in seconds. If set to 0, refreshing data using ajax will be disabled (locks and activity pages)
$conf['ajax_refresh'] = 3;

/** Plugins management
* Add plugin names to the following array to activate them
* Example:
* $conf['plugins'] = array(
* 'Example',
* 'Slony'
* );
*/
$conf['plugins'] = array();

/*****************************************
* Don't modify anything below this line *
*****************************************/

$conf['version'] = 19;

?>
[root@asm-sql01 phpPgAdmin]#

halvy 09-06-2014 08:55 AM

sounds like.. a permissions problem on your web server.

andrewm659 09-07-2014 10:23 PM

Thoughts on how to resolve?

Would it be in the /etc/httpd/conf.d/phpPgAdmin.conf file?
File perms?


All times are GMT -5. The time now is 01:50 AM.