Advertisement
Guest User

Untitled

a guest
Jul 22nd, 2017
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.09 KB | None | 0 0
  1. FATAL: password authentication failed for user "[username]"
  2.  
  3. conn = database('dbname','username','password','org.postgresql.Driver',
  4. 'jdbc:postgresql:dm-userdb.geomar.de:users:ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory&');
  5.  
  6. install.packages("rpostgres")
  7. library(RPostgreSQL)
  8. drv <- dbDriver("PostgreSQL")
  9. con <- dbConnect(drv, host = "dm-userdb.geomar.de", dbname="users", tty = "NULL", user="****", password = "******", port = "5432")
  10.  
  11. % Add jar file to classpath (ensure it is present in your current dir)
  12. %javaclasspath('postgresql-9.0-801.jdbc4.jar');
  13.  
  14. % Username and password you chose when installing postgres
  15. props=java.util.Properties;
  16. props.setProperty('user', 'username');
  17. props.setProperty('password', 'password');
  18. props.setProperty('ssl','true');
  19.  
  20. % Create the database connection
  21. driver=org.postgresql.Driver;
  22. url = 'jdbc:postgresql://databaseURL/dbname';
  23. conn=driver.connect(url, props);
  24.  
  25. dbConn = com.allied.pgmex.pgmexec('connect',[...
  26. 'host=<yourhost> dbname=<yourdb> port=<yourport> '...
  27. 'user=<your_postgres_username> password=<your_postgres_password>']);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement