Skip to content
This repository was archived by the owner on Aug 31, 2021. It is now read-only.

[[ PostgreSQL SSL ]] Updated dbpostgresql to support secure connections.#3067

Merged
livecodemichael merged 6 commits intolivecode:developfrom
livecodemichael:feature-postgresql_ssl
Oct 20, 2015
Merged

[[ PostgreSQL SSL ]] Updated dbpostgresql to support secure connections.#3067
livecodemichael merged 6 commits intolivecode:developfrom
livecodemichael:feature-postgresql_ssl

Conversation

@livecodemichael
Copy link
Copy Markdown
Contributor

This pull request relies on livecode/livecode-thirdparty#31

…secure connections.

The dbpostgresql database driver was updated to weakly link against libcrypto and libssl.
The revOpenDatabase function was updated for postgres to take 6 extra parameters that determine the nature of the SSL connection.
dbpostgresql was updated to connect using PQconnectdbParams, passing through the extra SSL paramters.
…tion options as key value pairs.

It was decided that key=value parameters were easier to use than one specific parameter per SSL option.
Now any number of additional paramters can be passed to revOpenDatabase (for PostgreSQL connections) each specifying an SSL option in the form option_name=option_value.
The docs note and dictionary entry have been updated accordingly.
@peter-b
Copy link
Copy Markdown
Contributor

peter-b commented Oct 15, 2015

@livecodemichael: The 64-bit Linux build failed on Travis. Could you please investigate? Thanks. 👍

@runrevmark
Copy link
Copy Markdown
Contributor

@livecodemichael: I think the third-party submodule pointer hasn't been updated

Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

You shouldn't really do this - the string is a const char * - it probably shouldn't be mutated ;)

@runrevmark
Copy link
Copy Markdown
Contributor

@livecode-vulcan review ok d05fb6e

@livecode-vulcan
Copy link
Copy Markdown
Contributor

💙 review by @runrevmark ok d05fb6e

livecode-vulcan added a commit that referenced this pull request Oct 19, 2015
…_ssl

[[ PostgreSQL SSL ]] Updated dbpostgresql to support secure connections.

This pull request relies on livecode/livecode-thirdparty#31
@livecode-vulcan
Copy link
Copy Markdown
Contributor

😎 test success d05fb6e

livecodemichael added a commit that referenced this pull request Oct 20, 2015
[[ PostgreSQL SSL ]] Updated dbpostgresql to support secure connections.
@livecodemichael livecodemichael merged commit 3f2443c into livecode:develop Oct 20, 2015
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.

Projects

None yet

Development

Successfully merging this pull request may close these issues.

4 participants