IGOS Nusantara dan phpPgAdmin: Perbedaan revisi
Dari IGNwiki
(←Membuat halaman berisi ' == Pasang == # yum -y install phpPgAdmin == Konfigurasi == vi /etc/phpPgAdmin/config.inc.php # line 18: add $conf['servers'][0]['host'] = 'localhost'; # line ...') |
|||
| Baris 5: | Baris 5: | ||
== Konfigurasi == | == Konfigurasi == | ||
vi /etc/phpPgAdmin/config.inc.php | vi /etc/phpPgAdmin/config.inc.php | ||
| − | # | + | # Baris 18: tambahkan |
$conf['servers'][0]['host'] = 'localhost'; | $conf['servers'][0]['host'] = 'localhost'; | ||
| − | # | + | # baris 88: ubah true, menjadi false |
$conf['extra_login_security'] =false; | $conf['extra_login_security'] =false; | ||
| − | # | + | # baris 94: ubah false, menjadi true |
$conf['owned_only'] =true; | $conf['owned_only'] =true; | ||
| Baris 17: | Baris 17: | ||
vi /var/lib/pgsql/data/pg_hba.conf | vi /var/lib/pgsql/data/pg_hba.conf | ||
# line 70: change | # line 70: change | ||
| − | local all all | + | local all all md5 |
| − | # | + | # baris 72: ubah |
| − | host all all 127.0.0.1/32 md5 | + | host all all 127.0.0.1/32 md5 |
| + | host all all 192.168.0.0/24 md5 | ||
| − | + | # baris 75: ubah | |
| − | + | local all all ::1/128 md5 | |
| − | # | + | |
| − | local all all ::1/128 | + | |
# vi /etc/httpd/conf.d/phpPgAdmin.conf | # vi /etc/httpd/conf.d/phpPgAdmin.conf | ||
| − | # | + | # baris 11: tambah IP yg dibolehkan |
Allow from 127.0.0.1 10.0.0.0/24 | Allow from 127.0.0.1 10.0.0.0/24 | ||
| − | + | == Restart == | |
| − | /etc/rc.d/init.d/postgresql restart | + | # /etc/rc.d/init.d/postgresql restart |
| − | + | # /etc/rc.d/init.d/httpd reload | |
| − | /etc/rc.d/init.d/httpd reload | + | |
Revisi per 17 April 2012 06.39
Pasang
# yum -y install phpPgAdmin
Konfigurasi
vi /etc/phpPgAdmin/config.inc.php # Baris 18: tambahkan $conf['servers'][0]['host'] = 'localhost'; # baris 88: ubah true, menjadi false $conf['extra_login_security'] =false;
# baris 94: ubah false, menjadi true $conf['owned_only'] =true;
vi /var/lib/pgsql/data/pg_hba.conf # line 70: change local all all md5 # baris 72: ubah host all all 127.0.0.1/32 md5 host all all 192.168.0.0/24 md5 # baris 75: ubah local all all ::1/128 md5 # vi /etc/httpd/conf.d/phpPgAdmin.conf # baris 11: tambah IP yg dibolehkan Allow from 127.0.0.1 10.0.0.0/24
Restart
# /etc/rc.d/init.d/postgresql restart # /etc/rc.d/init.d/httpd reload
