diff options
| author | Noah Misch <noah@leadboat.com> | 2014-06-19 21:41:26 -0400 |
|---|---|---|
| committer | Noah Misch <noah@leadboat.com> | 2014-06-19 21:41:26 -0400 |
| commit | c82725edfa1aec1cad940b15b6e22ee3dbd57f20 (patch) | |
| tree | 9a8115e87847fee717d2c1457c2097bf9ec2d53d /src/interfaces/ecpg/test/connect/test5.pgc | |
| parent | f28d9b10f73440adcb2e094440b4b213673e491b (diff) | |
| download | postgresql-c82725edfa1aec1cad940b15b6e22ee3dbd57f20.tar.gz postgresql-c82725edfa1aec1cad940b15b6e22ee3dbd57f20.zip | |
Let installcheck-world pass against a server requiring a password.
Give passwords to each user created in support of an ECPG connection
test case. Use SET SESSION AUTHORIZATION, not a fresh connection, to
reduce privileges during a dblink test case.
To test against such a server, both the "make installcheck-world"
environment and the postmaster environment must provide the default
user's password; $PGPASSFILE is the principal way to do so. (The
postmaster environment needs it for dblink and postgres_fdw tests.)
Diffstat (limited to 'src/interfaces/ecpg/test/connect/test5.pgc')
| -rw-r--r-- | src/interfaces/ecpg/test/connect/test5.pgc | 18 |
1 files changed, 10 insertions, 8 deletions
diff --git a/src/interfaces/ecpg/test/connect/test5.pgc b/src/interfaces/ecpg/test/connect/test5.pgc index d3efecbf62b..5ba59eb8222 100644 --- a/src/interfaces/ecpg/test/connect/test5.pgc +++ b/src/interfaces/ecpg/test/connect/test5.pgc @@ -21,7 +21,9 @@ exec sql end declare section; ECPGdebug(1, stderr); exec sql connect to connectdb as main; + exec sql alter user connectdb ENCRYPTED PASSWORD 'insecure'; exec sql alter user connectuser ENCRYPTED PASSWORD 'connectpw'; + exec sql commit; exec sql disconnect; /* <-- "main" not specified */ strcpy(db, "connectdb"); @@ -38,28 +40,28 @@ exec sql end declare section; exec sql connect to 'connectdb' as main; exec sql disconnect main; - exec sql connect to as main user connectdb; + exec sql connect to as main user connectdb/insecure; exec sql disconnect main; - exec sql connect to connectdb as main user connectuser/connectdb; + exec sql connect to connectdb as main user connectuser/connectpw; exec sql disconnect main; - exec sql connect to unix:postgresql://localhost/connectdb as main user connectuser; + exec sql connect to unix:postgresql://localhost/connectdb as main user connectuser/connectpw; exec sql disconnect main; - exec sql connect to "unix:postgresql://localhost/connectdb" as main user connectuser; + exec sql connect to "unix:postgresql://localhost/connectdb" as main user connectuser/connectpw; exec sql disconnect main; - exec sql connect to 'unix:postgresql://localhost/connectdb' as main user :user; + exec sql connect to 'unix:postgresql://localhost/connectdb' as main user :user USING "connectpw"; exec sql disconnect main; - exec sql connect to unix:postgresql://localhost/connectdb?connect_timeout=14&client_encoding=latin1 as main user connectuser; + exec sql connect to unix:postgresql://localhost/connectdb?connect_timeout=14&client_encoding=latin1 as main user connectuser/connectpw; exec sql disconnect main; - exec sql connect to "unix:postgresql://200.46.204.71/connectdb" as main user connectuser; + exec sql connect to "unix:postgresql://200.46.204.71/connectdb" as main user connectuser/connectpw; exec sql disconnect main; - exec sql connect to unix:postgresql://localhost/ as main user connectdb; + exec sql connect to unix:postgresql://localhost/ as main user connectdb IDENTIFIED BY insecure; exec sql disconnect main; /* connect twice */ |