SSL access of Postgres

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default SSL access of Postgres

    Hi all, I am trying to ssl all transactions between my CFMX 6.1 server and a
    remote server running Postgres. Is there a way to do this without using the
    cfhttp tags? I was hoping there was some method, via the datasources and
    secured JDBC but haven't found much. Any ideas would be greatly appreciated.
    Tom

    autoprof Guest

  2. Similar Questions and Discussions

    1. php + postgres
      I've got this connection script for my database: <?php $password = md5("xxxxx"); $user = "user"; $host = "localhost"; $database = "base"; $link...
    2. Mac OS X and ruby-postgres again
      Hello, Yes I am new around here and to ruby in general. I have checked the archive enough to know this question has come up before. I post it...
    3. postgres
      I'm trying to access a PostgreSQL database on my machine, however, I get the following error: irb(main):003:0> conn = PGconn.connect("localhost",...
    4. [OT] postgres
      > I can connect through DBI, but not using the postgres module. Very Hm. Does your postgres startup command have a "-i" in it somewhere? Tom
    5. [OT] postgres
      > It doesn't appear to. ps aux | grep postgresql doesn't show anything You might try adding a "-i" to the "postmaster start" command. That'll...
  3. #2

    Default Re: SSL access of Postgres

    autoprof wrote:
    > Hi all, I am trying to ssl all transactions between my CFMX 6.1 server and a
    > remote server running Postgres. Is there a way to do this without using the
    > cfhttp tags? I was hoping there was some method, via the datasources and
    > secured JDBC but haven't found much. Any ideas would be greatly appreciated.
    You should be able to just add ?SSL=true to the JDBC URL. (Maybe
    it should be lowercase.)

    Jochem

    --
    Jochem van Dieten
    Team Macromedia Volunteer for ColdFusion, beer and fun.
    Jochem van Dieten - TMM Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139