Mickaƫl Andrieu
09/15/2022, 2:55 PMMarcos Marx (Airbyte)
09/15/2022, 3:03 PMMickaƫl Andrieu
09/15/2022, 3:04 PMSomething went wrong
The provided configuration does not fulfill the specification. Errors: json schema validation failed when comparing the data to the json schema. Errors: $.replication_method: string found, object expected, $.replication_method: should be valid to one and only one of the schemas Schema: { "type" : "object", "title" : "MySql Source Spec", "$schema" : "<http://json-schema.org/draft-07/schema#>", "required" : [ "host", "port", "database", "username", "replication_method" ], "properties" : { "ssl" : { "type" : "boolean", "order" : 6, "title" : "SSL Connection", "default" : true, "description" : "Encrypt data using SSL." }, "host" : { "type" : "string", "order" : 0, "title" : "Host", "description" : "The host name of the database." }, "port" : { "type" : "integer", "order" : 1, "title" : "Port", "default" : 3306, "maximum" : 65536, "minimum" : 0, "examples" : [ "3306" ], "description" : "The port to connect to." }, "database" : { "type" : "string", "order" : 2, "title" : "Database", "description" : "The database name." }, "password" : { "type" : "string", "order" : 4, "title" : "Password", "description" : "The password associated with the username.", "airbyte_secret" : true }, "ssl_mode" : { "type" : "object", "oneOf" : [ { "title" : "preferred", "required" : [ "mode" ], "properties" : { "mode" : { "enum" : [ "preferred" ], "type" : "string", "const" : "preferred", "order" : 0, "default" : "preferred" } }, "description" : "Preferred SSL mode." }, { "title" : "required", "required" : [ "mode" ], "properties" : { "mode" : { "enum" : [ "required" ], "type" : "string", "const" : "required", "order" : 0, "default" : "required" } }, "description" : "Require SSL mode." }, { "title" : "Verify CA", "required" : [ "mode", "ca_certificate" ], "properties" : { "mode" : { "enum" : [ "verify_ca" ], "type" : "string", "const" : "verify_ca", "order" : 0, "default" : "verify_ca" }, "client_key" : { "type" : "string", "order" : 3, "title" : "Client key", "multiline" : true, "description" : "Client key (this is not a required field, but if you want to use it, you will need to add the <b>Client certificate</b> as well)", "airbyte_secret" : true }, "ca_certificate" : { "type" : "string", "order" : 1, "title" : "CA certificate", "multiline" : true, "description" : "CA certificate", "airbyte_secret" : true }, "client_certificate" : { "type" : "string", "order" : 2, "title" : "Client certificate", "multiline" : true, "description" : "Client certificate (this is not a required field, but if you want to use it, you will need to add the <b>Client key</b> as well)", "airbyte_secret" : true }, "client_key_password" : { "type" : "string", "order" : 4, "title" : "Client key password (Optional)", "description" : "Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.", "airbyte_secret" : true } }, "description" : "Verify CA SSL mode." }, { "title" : "Verify Identity", "required" : [ "mode", "ca_certificate" ], "properties" : { "mode" : { "enum" : [ "verify_identity" ], "type" : "string", "const" : "verify_identity", "order" : 0, "default" : "verify_identity" }, "client_key" : { "type" : "string", "order" : 3, "title" : "Client key", "multiline" : true, "description" : "Client key (this is not a required field, but if you want to use it, you will need to add the <b>Client certificate</b> as well)", "airbyte_secret" : true }, "ca_certificate" : { "type" : "string", "order" : 1, "title" : "CA certificate", "multiline" : true, "description" : "CA certificate", "airbyte_secret" : true }, "client_certificate" : { "type" : "string", "order" : 2, "title" : "Client certificate", "multiline" : true, "description" : "Client certificate (this is not a required field, but if you want to use it, you will need to add the <b>Client key</b> as well)", "airbyte_secret" : true }, "client_key_password" : { "type" : "string", "order" : 4, "title" : "Client key password (Optional)", "description" : "Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.", "airbyte_secret" : true } }, "description" : "Verify-full SSL mode." } ], "order" : 7, "title" : "SSL modes", "description" : "SSL connection modes. <li><b>preferred</b> - Automatically attempt SSL connection. If the MySQL server does not support SSL, continue with a regular connection.</li><li><b>required</b> - Always connect with SSL. If the MySQL server doesn't support SSL, the connection will not be established. Certificate Authority (CA) and Hostname are not verified.</li><li><b>verify-ca</b> - Always connect with SSL. Verifies CA, but allows connection even if Hostname does not match.</li><li><b>Verify Identity</b> - Always connect with SSL. Verify both CA and Hostname.</li></ul>Read more <a href=\"<https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-reference-using-ssl.html>\"> in the docs</a>." }, "username" : { "type" : "string", "order" : 3, "title" : "Username", "description" : "The username which is used to access the database." }, "tunnel_method" : { "type" : "object", "oneOf" : [ { "title" : "No Tunnel", "required" : [ "tunnel_method" ], "properties" : { "tunnel_method" : { "type" : "string", "const" : "NO_TUNNEL", "order" : 0, "description" : "No ssh tunnel needed to connect to database" } } }, { "title" : "SSH Key Authentication", "required" : [ "tunnel_method", "tunnel_host", "tunnel_port", "tunnel_user", "ssh_key" ], "properties" : { "ssh_key" : { "type" : "string", "order" : 4, "title" : "SSH Private Key", "multiline" : true, "description" : "OS-level user account ssh key credentials in RSA PEM format ( created with ssh-keygen -t rsa -m PEM -f myuser_rsa )", "airbyte_secret" : true }, "tunnel_host" : { "type" : "string", "order" : 1, "title" : "SSH Tunnel Jump Server Host", "description" : "Hostname of the jump server host that allows inbound ssh tunnel." }, "tunnel_port" : { "type" : "integer", "order" : 2, "title" : "SSH Connection Port", "default" : 22, "maximum" : 65536, "minimum" : 0, "examples" : [ "22" ], "description" : "Port on the proxy/jump server that accepts inbound ssh connections." }, "tunnel_user" : { "type" : "string", "order" : 3, "title" : "SSH Login Username", "description" : "OS-level username for logging into the jump server host." }, "tunnel_method" : { "type" : "string", "const" : "SSH_KEY_AUTH", "order" : 0, "description" : "Connect through a jump server tunnel host using username and ssh key" } } }, { "title" : "Password Authentication", "required" : [ "tunnel_method", "tunnel_host", "tunnel_port", "tunnel_user", "tunnel_user_password" ], "properties" : { "tunnel_host" : { "type" : "string", "order" : 1, "title" : "SSH Tunnel Jump Server Host", "description" : "Hostname of the jump server host that allows inbound ssh tunnel." }, "tunnel_port" : { "type" : "integer", "order" : 2, "title" : "SSH Connection Port", "default" : 22, "maximum" : 65536, "minimum" : 0, "examples" : [ "22" ], "description" : "Port on the proxy/jump server that accepts inbound ssh connections." }, "tunnel_user" : { "type" : "string", "order" : 3, "title" : "SSH Login Username", "description" : "OS-level username for logging into the jump server host" }, "tunnel_method" : { "type" : "string", "const" : "SSH_PASSWORD_AUTH", "order" : 0, "description" : "Connect through a jump server tunnel host using username and password authentication" }, "tunnel_user_password" : { "type" : "string", "order" : 4, "title" : "Password", "description" : "OS-level password for logging into the jump server host", "airbyte_secret" : true } } } ], "title" : "SSH Tunnel Method", "description" : "Whether to initiate an SSH tunnel before connecting to the database, and if so, which kind of authentication to use." }, "jdbc_url_params" : { "type" : "string", "order" : 5, "title" : "JDBC URL Params", "description" : "Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3)." }, "replication_method" : { "type" : "object", "oneOf" : [ { "title" : "STANDARD", "required" : [ "method" ], "properties" : { "method" : { "enum" : [ "STANDARD" ], "type" : "string", "const" : "STANDARD", "order" : 0, "default" : "STANDARD" } }, "description" : "Standard replication requires no setup on the DB side but will not be able to represent deletions incrementally." }, { "title" : "Logical Replication (CDC)", "required" : [ "method" ], "properties" : { "method" : { "enum" : [ "CDC" ], "type" : "string", "const" : "CDC", "order" : 0, "default" : "CDC" } }, "description" : "CDC uses the Binlog to detect inserts, updates, and deletes. This needs to be configured on the source database itself." } ], "order" : 8, "title" : "Replication Method", "description" : "Replication method to use for extracting data from the database." } } }
Mickaƫl Andrieu
09/15/2022, 3:10 PMA sync is already running for: 8e3cfef1-f431-4f6c-8e71-0714d155ea7e
Mickaƫl Andrieu
09/15/2022, 3:17 PMMickaƫl Andrieu
09/16/2022, 1:01 PMMarcos Marx (Airbyte)
09/16/2022, 1:29 PMMickaƫl Andrieu
09/16/2022, 1:45 PMMickaƫl Andrieu
09/16/2022, 1:47 PMMarcos Marx (Airbyte)
09/16/2022, 3:52 PMMickaƫl Andrieu
09/19/2022, 9:12 AM