4 perl -e'require "/etc/gforge/local.pl"; print "*:*:$sys_dbname:$sys_dbuser:$sys_dbpasswd\n"' > $tmp3
6 projects=$(echo "SELECT g.unix_group_name from groups g, group_plugin gp, plugins p where g.group_id = gp.group_id and gp.plugin_id = p.plugin_id and p.plugin_name = 'mediawiki' ;" \
7 | PGPASSFILE=/tmp/tmp.wOirlBjmDn /usr/bin/psql -U gforge gforge \
11 wdprefix=/var/lib/gforge/plugins/mediawiki/wikidata
13 for project in $projects ; do
14 if [ ! -d $wdprefix/$project/images ] ; then
15 mkdir -p $wdprefix/$project/images
16 chown www-data $wdprefix/$project/images
17 touch $wdprefix/$project/LocalSettings.php
18 filteredprojects="$filteredprojects $project"
22 projects=$filteredprojects
24 for project in $projects ; do
25 schema=$(echo plugin_mediawiki_$project | sed s/-/_/g)
30 if su -s /bin/sh postgres -c "/usr/bin/psql gforge" 1> $tmp1 2> $tmp2 <<-EOF \
31 && [ "$(tail -n +2 $tmp1 | head -1)" = 'CREATE SCHEMA' ] ;
32 SET LC_MESSAGES = 'C' ;
33 CREATE SCHEMA $schema ;
34 ALTER SCHEMA $schema OWNER TO gforge;
39 echo "CREATE SCHEMA's STDOUT:"
41 echo "CREATE SCHEMA's STDERR:"
43 rm -f $tmp1 $tmp2 $tmp3
50 if PGPASSFILE=$tmp3 /usr/bin/psql -U gforge gforge 1> $tmp1 2> $tmp2 <<-EOF \
51 && true || [ "$(tail -1 $tmp1)" = 'COMMIT' ] ;
52 SET search_path = "$schema" ;
53 \i /usr/share/mediawiki/maintenance/postgres/tables.sql
54 CREATE TEXT SEARCH CONFIGURATION $schema.default ( COPY = pg_catalog.english );
60 echo "Database creation STDOUT:"
62 echo "Database creation STDERR:"
64 rm -f $tmp1 $tmp2 $tmp3