File: //usr/local/brainycp/ssh/postgres/phpPgAdmin.sh
#! /bin/bash
## Разработка этого модуля Колесник Алена
a=$1
ver=`cat /etc/brainy/globals.php | grep 'OS_VERSION' | tr -d '\n'\\$GLOBALS['OS_VERSION']=\\"\\'\\ \\;\\:`
if [[ $a == "install" ]];then
if [ $ver != "debian8" ];then
rpm -qa | grep -E 'phpPg|php-pgsql' | xargs rpm -e --nodeps
#rpm -qa | grep -E 'phpPgAdmin' | xargs rpm -e --nodeps
yum -y install phpPgAdmin php-pgsql
#php-pgsql
echo 'Install'
fi
# echo 'Alias /phpPgAdmin /usr/share/phpPgAdmin' > /etc/httpd/conf.d/phpPgAdmin.conf
# echo '<Location /phpPgAdmin>' >> /etc/httpd/conf.d/phpPgAdmin.conf
# echo ' <IfModule mod_authz_core.c>' >> /etc/httpd/conf.d/phpPgAdmin.conf
# echo ' Require all granted' >> /etc/httpd/conf.d/phpPgAdmin.conf
# echo ' </IfModule>' >> /etc/httpd/conf.d/phpPgAdmin.conf
# echo ' <IfModule !mod_authz_core.c>' >> /etc/httpd/conf.d/phpPgAdmin.conf
# echo ' Order deny,allow' >> /etc/httpd/conf.d/phpPgAdmin.conf
# echo ' Deny from all' >> /etc/httpd/conf.d/phpPgAdmin.conf
# echo ' Allow from 127.0.0.1' >> /etc/httpd/conf.d/phpPgAdmin.conf
# echo ' Allow from ::1' >> /etc/httpd/conf.d/phpPgAdmin.conf
# echo ' </IfModule>' >> /etc/httpd/conf.d/phpPgAdmin.conf
# echo '</Location> ' >> /etc/httpd/conf.d/phpPgAdmin.conf
echo 'Alias /phpPgAdmin /usr/share/phpPgAdmin' > /usr/local/brainycp/src/compiled/brainy/conf/conf.d/phpPgAdmin.conf
echo 'Alias /phppgadmin /usr/share/phpPgAdmin' > /usr/local/brainycp/src/compiled/brainy/conf/conf.d/phpPgAdmin.conf
echo '<Directory /usr/share/phpPgAdmin>' >> /usr/local/brainycp/src/compiled/brainy/conf/conf.d/phpPgAdmin.conf
echo ' Order Deny,Allow' >> /usr/local/brainycp/src/compiled/brainy/conf/conf.d/phpPgAdmin.conf
echo ' Deny from all' >> /usr/local/brainycp/src/compiled/brainy/conf/conf.d/phpPgAdmin.conf
echo ' Allow from all' >> /usr/local/brainycp/src/compiled/brainy/conf/conf.d/phpPgAdmin.conf
echo '</Directory>' >> /usr/local/brainycp/src/compiled/brainy/conf/conf.d/phpPgAdmin.conf
#sed -i 's@#listen_addresses@listen_addresses@g' /var/lib/pgsql/data/postgresql.conf
#sed -i "s@conf\['servers'\]\[0\]\['host'\] = ''@conf\['servers'\]\[0\]\['host'\] = 'localhost'@g" /etc/phpPgAdmin/config.inc.php
sed -i "s@conf\['servers'\]\[0\]\['host'\] = ''@conf\['servers'\]\[0\]\['host'\] = '127.0.0.1'@g" /etc/phpPgAdmin/config.inc.php
sed -i "s@conf\['extra_login_security'\] = true@conf\['extra_login_security'\] = false@g" /etc/phpPgAdmin/config.inc.php
sed -i "s@conf\['owned_only'\] = false@conf\['owned_only'\] = true@g" /etc/phpPgAdmin/config.inc.php
sed -i 's@passthru($cmd);@echo passthru($cmd);@g' /usr/share/phpPgAdmin/dbexport.php
sed -i 's@$exe . " -i";@$exe;@g' /usr/share/phpPgAdmin/dbexport.php
service postgresql restart
echo 'Complete'
#service brainy restart
fi
if [ "$a" == "delete" ];then
rpm -qa | grep -E 'phpPgAdmin|php-pgsql' | xargs rpm -e --nodeps
#rpm -qa | grep -E 'phpPgAdmin' | xargs rpm -e --nodeps
#rm -rf /usr/local/brainycp/src/compiled/brainy/conf/conf.d/phpPgAdmin.conf
echo 'Succesfully deleted'
#service brainy restart
fi