Configure postgres to accept password logins
@@ -30,13 +30,22 @@ before_test:
- cmd: echo Running scripts before build...
- cmd: |-
PATH=C:\Program Files\PostgreSQL\9.6\bin\;C:\Program Files\MySQL\MySQL Server 5.7\bin\;%PATH%
- SET MYSQL_PWD="Password12!"
+
+ # Set up MySQL
+ SET MYSQL_PWD=Password12!
mysql -u root --password=Password12! -e "create database test_db;"
mysql -u root test_db --password=Password12! < extensions\database\test\conf\travis-mysql.sql
- SET PGUSER="postgres"
- SET PGPASSWORD="Password12!"
+
+ # Set up PostgreSQL
+ echo "localhost:*:test_db:postgres:Password12!" > C:\Program Files\PostgreSQL\9.6\pgpass.conf
+ echo "localhost:*:test_db:postgres:Password12!" > pgpass.conf
+ echo "localhost:*:test_db:postgres:Password12!" > %userprofile%\pgpass.conf
+ SET PGPASSFILE=C:\Program Files\PostgreSQL\9.6\pgpass.conf
+ SET PGPASSWORD=Password12!
+ SET PGUSER=postgres
createdb test_db
psql -U postgres test_db < extensions\database\test\conf\travis-pgsql.sql
+
copy extensions\database\test\conf\appveyor_int_tests.xml extensions\database\test\conf\int_tests.xml
test_script:
