Where Can I Find the Pipdream IP Addresses or Ranges for MySQL Connection?

user-1 · July 25, 2023, 4:27pm

Here’s the updated code using key-based authentication for the SSH connection in a single code block: ```
import mysql from “mysql2/promise”; import { Client } from “ssh2”; export default defineComponent({ props: { sshHost: { type: “string”, label: “SSH Host” }, sshPort: { type: “integer”, label: “SSH Port”, default: 22 }, sshUsername: { type: “string”, label: “SSH Username” }, sshPrivateKey: { type: “string”, label: “SSH Private Key”, secret: true }, mysqlHost: { type: “string”, label: “MySQL Host” }, mysqlPort: { type: “integer”, label: “MySQL Port”, default: 3306 }, mysqlUsername: { type: “string”, label: “MySQL Username” }, mysqlPassword: { type: “string”, label: “MySQL Password”, secret: true }, mysqlDatabase: { type: “string”, label: “MySQL Database” }, mysqlQuery: { type: “string”, label: “MySQL Query” }, }, async run({ $ }) { const sshClient = new Client(); const sshConfig = { host: this.sshHost, port: this.sshPort, username: this.sshUsername, privateKey: this.sshPrivateKey, }; const mysqlConfig = { host: this.mysqlHost, port: this.mysqlPort, user: this.mysqlUsername, password: this.mysqlPassword, database: this.mysqlDatabase, }; return new Promise((resolve, reject) => { sshClient .on(“ready”, () => { sshClient.forwardOut( “127.0.0.1”, 12345, mysqlConfig.host, mysqlConfig.port, async (err, stream) => { if (err) { sshClient.end(); return reject(err); } mysqlConfig.stream = stream; const connection = await mysql.createConnection(mysqlConfig); const [rows, fields] = await connection.execute(this.mysqlQuery); connection.end(); sshClient.end(); resolve(rows); } ); }) .connect(sshConfig); }); }, });

user-1 · July 25, 2023, 4:27pm

here is the error:
Error
Cannot parse privateKey: Unsupported key format
DETAILS

    at Client.connect (/tmp/__pdg__/dist/code/38b98f05c40e5354734d90e79066a6891a1aa34cd9385161092f7ba2bb48b711/node_modules/.pnpm/ssh2@1.14.0/node_modules/ssh2/lib/client.js:261:15)
    at null.null (file:///tmp/__pdg__/dist/code/38b98f05c40e5354734d90e79066a6891a1aa34cd9385161092f7ba2bb48b711/component.mjs:58:10)
    at null.Promise (null:null:null)
    at Object.run (file:///tmp/__pdg__/dist/code/38b98f05c40e5354734d90e79066a6891a1aa34cd9385161092f7ba2bb48b711/component.mjs:34:12)
    at null.executeComponent (/var/task/launch_worker.js:229:53)
    at MessagePort.messageHandler (/var/task/launch_worker.js:726:28)

Detailed/code mode
SSH Host
52.91.63.156
SSH Port
22
SSH Username
ubuntu
SSH Private Key
-----BEGIN RSA PRIVATE KEY----- MIIEogIBAAKCAQEAj0FytWKs1C161vOu7Am/t7+yCBaSjk50SaPPp1nsv94JRxz7 5DVGgKfMPo/NvOklXOCeYdmzqi/eX9e0iCLEMYUMHM5mIczAoMt7f1jnC+UhsBFP mpof9wrx2gk6aZ+p3FTcX7KkFBFXniK15uyLQdUQMiEC9MFRj0zAQrUXPr4Xp2cG 2vqAhLbX4n6StB5f1iHXOilKw+0i0cjuDaS+ytui9LU3NUWoc3YoEwGI6UADx+T7 0I8SLDYxkTif02ec3C7+iz8ULy/KkJ/9nVpsgI4N1wOGq0eAuOBiZDHMZACJFPoF zvCTv2O2jAXqm6OO9qwG/iF5A2LlJ7skOn2j5wIDAQABAoIBAEqxiljPEWQ0LneD aXJDBwaM2gvjkRjICVQYKH6OoaXM5LOChkgQCymr1A/OtSxJuCR8LbjBZS9YdC8u 7j+JORjE0XL3n0MCWnG8hzD4LsgB+ZWvAP2QXRhXSZEw/Jb0HAH48Uqof2rDPBcE 7Clyro1txVsN4VeysI7yKtDdUThx5q5jxilpvOqccSWa924ViQfuAoPu1lXdJVco epfezuE0PdI9S6U7k05sI2OWU7yYN3ZJ4kaF9Ia1xOoqzxeMxGZ8zMVCObn8yyyT LIodIm+aLAyY7Dnb4EwB2HtLwaHpx1a4XRpvJuls1YWguitCa2/RPYvzI3MHHm/f WaQBRvkCgYEA0Vri0B1zpZKmAB9Mr4zdiTN4gERYj16Os2iy59MylakmGmZxoQiU AtCGBnh0mrAyFJCAQ/1PSE62h5iKytkNHAkQW9j/Rx5gMeNrhOOBaQhzX0lLBUKe tLTmL7VNGVC8JdlHxzP6/WZabSU2jm8UD9asp5hxMMz0PqnseauSCDsCgYEAryxp NaFSN0N5y9uWTHqudOMkfEbnOkki7UTygBnoBcFwfzW9pnj+3iWJvkAa3dL1Gz3T hD3W/motHYgnwB5HBmw/ysEPdui9weLGluhy3+hqbSzK+z+eb0ijU+KukoDxajB0 Em2WZQ4sXQiybbKEC0N5K6aAfy+LBosCYqR5hEUCgYBxFW6+i6oUHYqdNkrt6GEh 4zOL1V8g0iqyrjM1FdeVD7ENQZjPKxsICirbA+W4SMREZ2lhUEqq/BmMVNFjkKqM Ijk745LAj5/WUsmZFmqomW/4YFatmLaxVaWgz4W9zuZSa3NiHqnMhqUBn8BAX6+u fn70aFt7yLmFv7OEZTCUUQKBgFOKk5ZvHD2c4X42eCR7Ma4vEZxvWCE09gJAKoKr WDs+eL9CSvMUq0AYmOtxuR5nWFuojbJ4p4rn6iI2Z/a4udi3UWkJz60+7BiGZX1c 2EQunGr6vMc8HPwnoTUFW4olEn05JHIRb3M8Yi3wUt/8DfstL6GAo7GEZAI302hl 1kodAoGAYlUo2SsHyOgmwM2utykeEqrGvkaL+vm1nAUBVv748CiTUKjo1or0t69b s5nMk00HVxQgKF36XWT337L6BLlpl1HnItuqmjcB2W7Y1VT7inkCXZxaT4WpI4Ox slBaGk/DrmP8VdlOeasBIMlQ+ihwsYR9Vv3eOtgUeheQVZSMtlo= -----END RSA PRIVATE KEY-----
MySQL Host
leadforge-1-instance-1.cxgt04l7qtnb.us-east-1.rds.amazonaws.com

MySQL Port
3306
MySQL Username
LeadForgeRD
MySQL Password
XZ8AkuIkreQqMr1o4vKG
MySQL Database
leadforge-1-instance-1
MySQL Query
Lead Score

python

CONFIGURE

CODE

RESULTS

python_1

CONFIGURE

CODE

RESULTS

python_2

CONFIGURE

CODE

RESULTS

create_row

CONFIGURE

RESULTS

code

CONFIGURE

CODE

RESULTS

Add_New_Contact_to_SubAccount_DB_GS

CONFIGURE

CODE

highlevel_oauth

CONFIGURE

CODE

RESULTS

get_current_time_in_specific_timezone

CONFIGURE

RESULTS

GHL_Get_Custom_Fields

CONFIGURE

CODE

RESULTS

REPLACED__Database_Storage_for_ChatGPT_Lead_Scoring

CONFIGURE

CODE

ChatGPT_Lead_Scoring

CONFIGURE

RESULTS

Testing_NEW_DB_storage

CONFIGURE

CODE

RESULTS

Extract_Lead_Score

CONFIGURE

RESULTS

Check_Lead_Score_and_get_Resources

CONFIGURE

CODE

RESULTS

ChatGPT_LeadForge_Responses

CONFIGURE

RESULTS

TESTING_Database_Storage_for_ChatGPT_LeadForge_Responses

CONFIGURE

CODE

RESULTS

Update_Contact_and_Custom_Fields_in_GHL

CONFIGURE

CODE

RESULTS

Merge_DataSets_to_include_Lead_Score_and_Conversation

CONFIGURE

CODE

RESULTS

chat

CONFIGURE

RESULTS

Webhook_to_Lead_Reporting

CONFIGURE

CODE

RESULTS

user-1 · July 25, 2023, 4:27pm

I’m sorry you’re experiencing an issue with the SSH connection. The error message you provided indicates that the private key format is not supported. Please make sure that your private key is in the correct format, and that there are no extra characters or spaces in the key. If you’re still having issues, please visit https://pipedream.com/support for more support options.