/usr/share/gforge/bin/install-db.sh is in gforge-db-postgresql 5.3.2+20141104-3+deb8u3.
This file is owned by root:root, with mode 0o755.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 | #! /bin/bash
#
# Configure postgresql database for GForge
# Roland Mas, gforge
# Simple function to know if a db exists
exist_db(){
export db_name=$1
su -s /bin/sh postgres -c "psql $1 >/dev/null 2>&1 </dev/null"
}
# this function export in var pg_hba_dir the directory of postgresql
# exit from this script if it do not find the directory of postgresql
# TODO : try to use function getdist from novaforge
function get_pg_hba_dir() {
# postgresql on debian
if [ -d /etc/postgresql/${pg_version}/main/ ]
then
export pg_hba_dir=/etc/postgresql/${pg_version}/main/
return
fi
# postgresql on redhat, fedora, centos
if [ -d /var/lib/pgsql/data/ ]
then
export pg_hba_dir=/var/lib/pgsql/data/
return
fi
echo "No pg_hba_dir found — exiting with error"
exit 1
}
# this function export in var pg_version the version of postgresql
# exit from this script if it do not find the version of postgresql
# TODO : try to use function getdist from novaforge
function get_pg_version() {
# postgresql on debian
if [ -f /usr/bin/pg_lsclusters ]
then
pg_version=`/usr/bin/pg_lsclusters | grep 5432 | grep online | cut -d' ' -f1`
return
fi
# postgresql on redhat, fedora, centos
if [ -f /var/lib/pgsql/data/PG_VERSION ]
then
pg_version=`cat /var/lib/pgsql/data/PG_VERSION`
return
fi
echo "No database found online on port 5432"
echo "Couldn't initialize or upgrade gforge database"
exit 1
}
set -e
if [ $(id -u) != 0 ] ; then
echo "You must be root to run this, please enter passwd"
exec su -c "$0 $1 $2"
fi
if [ $# = 0 ]
then
exec $0 default
else
target=$1
fi
export LC_ALL=C
# We are with new postgresql working with clusters
# This is probably not te most elegant way to deal with database
# I install or upgrade on the default cluster if it is online
# or I quit gently with a big message
get_pg_version
get_pg_hba_dir
case "$target" in
default)
echo "Usage: $0 {configure-files|configure|purge|purge-files|dump|restore}"
exit 1
;;
configure-files)
# Tell PostgreSQL to let us use the database
export FUSIONFORGE_NO_PLUGINS=true
db_passwd=$(forge_get_config database_password)
db_name=$(forge_get_config database_name)
db_user=$(forge_get_config database_user)
pattern=$(basename $0).XXXXXX
# PostgreSQL configuration for versions from 7.3 on
cp -a ${pg_hba_dir}/pg_hba.conf ${pg_hba_dir}/pg_hba.conf.gforge-new
cur=$(mktemp /tmp/$pattern)
if ! grep -q 'BEGIN GFORGE BLOCK -- DO NOT EDIT' ${pg_hba_dir}/pg_hba.conf.gforge-new ; then
# Make sure our configuration is inside a delimited BLOCK
if grep -q "^host.*gforge_passwd$" ${pg_hba_dir}/pg_hba.conf.gforge-new ; then
perl -e "open F, \"${pg_hba_dir}/pg_hba.conf.gforge-new\" or die \$!; undef \$/; \$l=<F>; \$l=~ s/^host.*gforge_passwd\$/### BEGIN GFORGE BLOCK -- DO NOT EDIT\n### END GFORGE BLOCK -- DO NOT EDIT/s; print \$l;" > $cur
cat $cur > ${pg_hba_dir}/pg_hba.conf.gforge-new
elif grep -q "^### Next line inserted by GForge install" ${pg_hba_dir}/pg_hba.conf.gforge-new ; then
perl -e "open F, \"${pg_hba_dir}/pg_hba.conf.gforge-new\" or die \$!; undef \$/; \$l=<F>; \$l=~ s/^### Next line inserted by GForge install\nhost $db_name $db_user [0-9. ]+ password/### BEGIN GFORGE BLOCK -- DO NOT EDIT\n### END GFORGE BLOCK -- DO NOT EDIT/s; print \$l;" > $cur
cat $cur > ${pg_hba_dir}/pg_hba.conf.gforge-new
else
perl -e "open F, \"${pg_hba_dir}/pg_hba.conf.gforge-new\" or die \$!; undef \$/; \$l=<F>; \$l=~ s/^host $db_name $db_user.*password\$/### BEGIN GFORGE BLOCK -- DO NOT EDIT\n### END GFORGE BLOCK -- DO NOT EDIT/s; print \$l;" > $cur
cat $cur > ${pg_hba_dir}/pg_hba.conf.gforge-new
fi
fi
echo "### BEGIN GFORGE BLOCK -- DO NOT EDIT" > $cur
echo "### END GFORGE BLOCK -- DO NOT EDIT" >> $cur
cat ${pg_hba_dir}/pg_hba.conf.gforge-new >> $cur
cat $cur > ${pg_hba_dir}/pg_hba.conf.gforge-new
rm -f $cur
cur=$(mktemp /tmp/$pattern)
perl -e "open F, \"${pg_hba_dir}/pg_hba.conf.gforge-new\" or die \$!; undef \$/; \$l=<F>; \$l=~ s/^### BEGIN GFORGE BLOCK -- DO NOT EDIT.*### END GFORGE BLOCK -- DO NOT EDIT\$/### BEGIN GFORGE BLOCK -- DO NOT EDIT\n# user which is used by libnss to access the DB (see \/etc\/nss-pgsql.conf)\nlocal $db_name ${db_user}_nss trust\nlocal $db_name list ident\nlocal $db_name ${db_user}_mta md5\n### END GFORGE BLOCK -- DO NOT EDIT/ms; print \$l;" > $cur
cat $cur > ${pg_hba_dir}/pg_hba.conf.gforge-new
rm -f $cur
;;
configure)
# Create the appropriate database user
export FUSIONFORGE_NO_PLUGINS=true
db_passwd=$(forge_get_config database_password)
db_name=$(forge_get_config database_name)
db_user=$(forge_get_config database_user)
pattern=$(basename $0).XXXXXX
tmp1=$(mktemp /tmp/$pattern)
tmp2=$(mktemp /tmp/$pattern)
if su -s /bin/sh postgres -c "/usr/bin/psql template1" 1> $tmp1 2> $tmp2 <<-EOF
SET LC_MESSAGES = 'C' ;
CREATE USER $db_user WITH PASSWORD '$db_passwd' ;
EOF
then
rm -f $tmp1 $tmp2
else
echo "Cannot create PostgreSQL user... This shouldn't have happened."
echo "Maybe a problem in your PostgreSQL configuration?"
echo "Please report a bug to the Debian bug tracking system"
echo "Please include the following output:"
echo "CREATE USER's STDOUT:"
cat $tmp1
echo "CREATE USER's STDERR:"
cat $tmp2
rm -f $tmp1 $tmp2
exit 1
fi
if su -s /bin/sh postgres -c "/usr/bin/psql template1" 1> $tmp1 2> $tmp2 <<-EOF
SET LC_MESSAGES = 'C' ;
CREATE USER ${db_user}_nss WITH PASSWORD '${db_user}_nss' ;
EOF
then
rm -f $tmp1 $tmp2
else
echo "Cannot create PostgreSQL user... This shouldn't have happened."
echo "Maybe a problem in your PostgreSQL configuration?"
echo "Please report a bug to the Debian bug tracking system"
echo "Please include the following output:"
echo "CREATE USER's STDOUT:"
cat $tmp1
echo "CREATE USER's STDERR:"
cat $tmp2
rm -f $tmp1 $tmp2
exit 1
fi
if su -s /bin/sh postgres -c "/usr/bin/psql template1" 1> $tmp1 2> $tmp2 <<-EOF
SET LC_MESSAGES = 'C' ;
CREATE USER ${db_user}_mta WITH PASSWORD '${db_user}_mta' ;
EOF
then
rm -f $tmp1 $tmp2
else
echo "Cannot create PostgreSQL user... This shouldn't have happened."
echo "Maybe a problem in your PostgreSQL configuration?"
echo "Please report a bug to the Debian bug tracking system"
echo "Please include the following output:"
echo "CREATE USER's STDOUT:"
cat $tmp1
echo "CREATE USER's STDERR:"
cat $tmp2
rm -f $tmp1 $tmp2
exit 1
fi
if su -s /bin/sh postgres -c "/usr/bin/psql template1" 1> $tmp1 2> $tmp2 <<-EOF
SET LC_MESSAGES = 'C' ;
CREATE USER list ;
EOF
then
rm -f $tmp1 $tmp2
else
echo "Cannot create PostgreSQL user... This shouldn't have happened."
echo "Maybe a problem in your PostgreSQL configuration?"
echo "Please report a bug to the Debian bug tracking system"
echo "Please include the following output:"
echo "CREATE USER's STDOUT:"
cat $tmp1
echo "CREATE USER's STDERR:"
cat $tmp2
rm -f $tmp1 $tmp2
exit 1
fi
# Create the appropriate database
if ! exist_db $db_name ; then
tmp1=$(mktemp /tmp/$pattern)
tmp2=$(mktemp /tmp/$pattern)
if su -s /bin/sh postgres -c "/usr/bin/psql template1" 1> $tmp1 2> $tmp2 <<EOF \
&& [ "$(tail -n +2 $tmp1 | head -1)" = 'CREATE DATABASE' ] ;
SET LC_MESSAGES = 'C' ;
CREATE DATABASE $db_name WITH TEMPLATE template0 ENCODING 'UNICODE';
EOF
then
# Creation OK
echo -n ""
rm -f $tmp1 $tmp2
need_admin_pw=true
else
echo "Cannot create PostgreSQL database... This shouldn't have happened."
echo "Maybe a problem in your PostgreSQL configuration?"
echo "Please report a bug to the Debian bug tracking system"
echo "Please include the following output:"
echo "CREATE DATABASE's STDOUT:"
cat $tmp1
echo "CREATE DATABASE's STDERR:"
cat $tmp2
rm -f $tmp1 $tmp2
exit 1
fi
fi
# Grant appropriate permissions to the database (for schema creation)
tmp1=$(mktemp /tmp/$pattern)
tmp2=$(mktemp /tmp/$pattern)
if su -s /bin/sh postgres -c "/usr/bin/psql template1" 1> $tmp1 2> $tmp2 <<EOF \
&& [ "$(tail -n +2 $tmp1 | head -1)" = 'GRANT' ] ;
SET LC_MESSAGES = 'C' ;
GRANT CREATE ON DATABASE $db_name TO $db_user ;
EOF
then
# Grant OK
echo -n ""
rm -f $tmp1 $tmp2
else
echo "Cannot grant permissions to PostgreSQL database... This shouldn't have happened."
echo "Maybe a problem in your PostgreSQL configuration?"
echo "Please report a bug to the Debian bug tracking system"
echo "Please include the following output:"
echo "GRANT CREATE's STDOUT:"
cat $tmp1
echo "GRANT CREATE's STDERR:"
cat $tmp2
rm -f $tmp1 $tmp2
exit 1
fi
# Enable plpgsql language
if [ -f /usr/bin/createlang ]
then
if [ `su -s /bin/sh postgres -c "/usr/bin/createlang -l $db_name | grep plpgsql | wc -l"` != 1 ]
then
su -s /bin/sh postgres -c "/usr/bin/createlang plpgsql $db_name"
else
echo "Procedural language on $db_name already enabled"
fi
else
echo "No way found to enable plpgsql on $db_name here"
fi
# Install/upgrade the database contents (tables and data)
$(forge_get_config source_path)/bin/old-db-upgrade.pl 2>&1 | grep -v ^NOTICE: | grep -v ^DETAIL: | grep -v ^WARNING: \
&& p=${PIPESTATUS[0]} \
|| p=${PIPESTATUS[0]}
if [ $p != 0 ] ; then
exit $p
fi
$(forge_get_config source_path)/bin/upgrade-db.php
if [ "$need_admin_pw" = "true" ] ; then
exit 100
fi
;;
purge-files)
cp -a ${pg_hba_dir}/pg_hba.conf ${pg_hba_dir}/pg_hba.conf.gforge-new
perl -pi -e "BEGIN { undef \$/; } s/^### BEGIN GFORGE BLOCK -- DO NOT EDIT.*### END GFORGE BLOCK -- DO NOT EDIT\n//ms;" ${pg_hba_dir}/pg_hba.conf.gforge-new
;;
purge)
export FUSIONFORGE_NO_PLUGINS=true
db_name=$(forge_get_config database_name)
db_user=$(forge_get_config database_user)
su -s /bin/sh postgres -c "dropdb $db_name" > /dev/null 2>&1 || true
su -s /bin/sh postgres -c "dropuser $db_user" > /dev/null 2>&1 || true
;;
#
# only only for migrating users of the sourceforge package
#
dump)
export FUSIONFORGE_NO_PLUGINS=true
db_name=$(forge_get_config database_name)
if [ "x$2" != "x" ] ;then
DUMPFILE=$2
else
DUMPFILE=$(forge_get_config data_path)/dumps/db_dump
fi
if [ "x$3" != "x" ] ;then
DB=$3
else
DB=$db_name
fi
echo "Dumping $DB database in $DUMPFILE"
su -s /bin/sh $DB -c /usr/lib/postgresql/bin/pg_dump $DB > $DUMPFILE
;;
#
# only only for migrating users of the sourceforge package
#
restore)
pg_name=postgresql-$pg_version
export FUSIONFORGE_NO_PLUGINS=true
db_name=$(forge_get_config database_name)
pattern=$(basename $0).XXXXXX
newpg=$(mktemp /tmp/$pattern)
localtrust="local all all trust"
echo "### Next line inserted by GForge restore" > $newpg
echo "$localtrust" >> $newpg
#echo "host all 127.0.0.1 255.255.255.255 trust" >> $newpg
cat ${pg_hba_dir}/pg_hba.conf >> $newpg
mv $newpg ${pg_hba_dir}/pg_hba.conf
chmod 644 ${pg_hba_dir}/pg_hba.conf
# Trying "postgresql" init script...
v=0
invoke-rc.d postgresql restart || v=$?
if test x"$v" = x"100"; then
# No "postgresql" init script (for packages << 8.4.4-2)
pg_name=postgresql-$pg_version
invoke-rc.d ${pg_name} restart
elif test x"$v" != x"0"; then
# Needed, since we run under "set -e"...
exit $v
fi
if [ "x$2" != "x" ] ;then
RESTFILE=$2
else
RESTFILE=$(forge_get_config data_path)/dumps/db_dump
fi
echo "Restoring $RESTFILE"
su -s /bin/sh postgres -c "dropdb $db_name" || true
su -s /bin/sh postgres -c "createdb --encoding=UNICODE $db_name" || true
su -s /bin/sh postgres -c "/usr/bin/psql -f $RESTFILE $db_name"
perl -pi -e "s/### Next line inserted by GForge restore\n//" ${pg_hba_dir}/pg_hba.conf
perl -pi -e "s/$localtrust\n//" ${pg_hba_dir}/pg_hba.conf
# Trying "postgresql" init script...
v=0
invoke-rc.d postgresql reload || v=$?
if test x"$v" = x"100"; then
# No "postgresql" init script (for packages << 8.4.4-2)
pg_name=postgresql-$pg_version
invoke-rc.d ${pg_name} reload
elif test x"$v" != x"0"; then
# Needed, since we run under "set -e"...
exit $v
fi
;;
esac
|