https://bugzilla.wikimedia.org/show_bug.cgi?id=37602
--- Comment #16 from Tim Landscheidt <[email protected]> --- Created attachment 16741 --> https://bugzilla.wikimedia.org/attachment.cgi?id=16741&action=edit My test script for reference. I use the attached script. The user Jenkins runs the test as has to be a PostgreSQL superuser that can create other users and databases, for example authenticated by password or identd. You would probably set TESTID to the Jenkins job number if that is unique. Then: | psql -c "CREATE USER \"$TESTID\" WITH PASSWORD 'abc';" template1 | psql -c "CREATE DATABASE \"$TESTID\" WITH OWNER \"$TESTID\";" template1 | php ./maintenance/install.php --dbtype=postgres \ | --dbport 5432 \ | --dbuser "$TESTID" \ | --dbpass abc \ | --dbname "$TESTID" \ | --pass testpass \ | --server http://localhost \ | --scriptpath /$SOMETHING_MEANINGFUL \ | postgresqltest WikiAdmin should create the user, database and install MediaWiki there (assuming standard ports; my development server runs on port 5433 and thus my script uses that). I haven't looked at how MediaWiki is installed in the SQLite tests, but keeping them in sync makes sense. If passwords need to be random, you can probably use something like: | TESTPW="$(base64 /dev/urandom | head -c8)" and then replace 'abc' with '"$TESTPW"'. To remove the database and user: | psql -c "DROP DATABASE \"$TESTID\";" template1; | psql -c "DROP USER \"$TESTID\";" template1; (If TESTID doesn't contain dashes ("-") or other SQL syntax, you could probably get away without the quotes, but they won't hurt.) -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
