llacroix
New Contributor II
Joined 4 years ago
User Profile
User Widgets
Contributions
Mysql ssl public key authentication
I need to connect to a MySQL instance in Google Cloud that requires username/password + SSL. This is not the same as using an SSH Tunnel, per the options in the MySQL Database Account settings. The other clients I use to connect to the database have options for both SSH Tunnel and for SSL, and the SSH Tunnel options are unchecked. With the other clients, I specify the three files provided by the MySQL instance: cert, ca cert, and private key. I’ve uploaded a pkcs12 keystore with the three items, but have not been successful at creating a MySQL Database Account that can authenticate to the database. Has anyone successfully connected to Google Cloud MySQL? What steps am I missing?1.7KViews0likes0CommentsRe: No Pagination Support on REST Post Snap?
@koryknick Thanks for the workaround idea. I haven’t had a chance to try it, but it makes perfect sense after I read through it a couple of times. Basically the child pipeline acts as a proxy/wrapper to the eventual API endpoint, translating at the protocol level.2.7KViews1like0CommentsRe: No Pagination Support on REST Post Snap?
Kurt, did this get turned into a feature request that I could up-vote, or did you get a good alternative solution from support? I have the same issue with the Dropbox Business API List Members endpoint. I have a workaround but it is rather unsatisfying. It requires three pipelines, nested two deep, and saves the cursor state between POSTS in a database table. I could avoid the issue with the cursor if Execute Pipeline supported recursion, but it doesn’t. -Les2.7KViews0likes2CommentsActive Directory List Users date conversion?
Active Directory stores some of its user object dates in units of the number of 100 nanosecond intervals since January 1, 1601 (UTC). For example, the value 132886760307330764 becomes “2/6/2022 8:53:50 PM” when translated to a standard datetime object. The Active Directory List Users snap returns these values as a string of decimal digits, e.g. “132886760307330764”. I need to convert these values to a normal datetime in order to do date arithmetic and compare them to “now”. Any ideas for how I can approach this? I found an article on doing the translation in java, but I’m pretty new to SnapLogic and don’t have a handle on turning that java code into something actionable in SnapLogic. Thanks! -Les1.7KViews0likes0Comments
Groups
Higher Ed Users Group
This user group is for customers within higher education.0 Posts
