Guest User

Untitled

a guest
Mar 1st, 2018
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. ::: in your database.yml
  2. # stuff common to several databases
  3. login: &login
  4. adapter: mysql
  5. username: fad
  6. password: fad
  7. host: localhost
  8.  
  9. fad_2007:
  10. <<: *login
  11. database: fad_2007
  12.  
  13. development:
  14. <<: *login
  15. database: fad_development
  16.  
  17. test:
  18. <<: *login
  19. database: fad2_test
  20.  
  21. production:
  22. <<: *login
  23. database: fad2_production
  24.  
  25. # Exernal Database Connection, through SSL
  26. grumpy:
  27. adapter: mysql
  28. host: grumpy.msu.montana.edu
  29. username: some_username
  30. password: a_delicious_password
  31. database: external_datbase_name
  32. sslca: /Users/mongrel/SSL/ca-cert.pem
  33. sslkey: /Users/mongrel/SSL/client-key.pem
  34. sslcert: /Users/mongrel/SSL/client-cert.pem
  35.  
  36. ::: Then in your Model
  37. class UdarCourse < ActiveRecord::Base
  38. establish_connection :grumpy
  39. # for some reason, setting table names explicitly on external connections
  40. # resolved problems I was having.
  41. set_table_name "udar_courses"
  42.  
  43. end
Add Comment
Please, Sign In to add comment