peerdb icon indicating copy to clipboard operation
peerdb copied to clipboard

error creating MySQL Peer

Open sapisuper opened this issue 1 year ago • 1 comments

hi I want to create peer connection mysql but getting error.

step to do :

  1. login into peerdb psql "port=9900 host=127.0.0.1 password=peerdb user=postgres"

  2. execute command CREATE PEER CREATE PEER mysql_peer FROM MYSQL WITH ( host='127.0.0.1', port=3306, user='root', password='', database='v1_test', disable_tls=false );

error come up :

postgres=> CREATE PEER mysql_peer FROM MYSQL WITH (
postgres(>     host='127.0.0.1',
postgres(>     port=3306,
postgres(>     user='root',
postgres(>     password='',
postgres(>     database='v1_test',
postgres(>     disable_tls=false
postgres(> );
ERROR:  User provided error: ErrorInfo { severity: "ERROR", code: "internal_error", message: "failed to create peer: invalid config for MYSQL peer mysql_peer", detail: None, hint: None, position: None, internal_position: None, internal_query: None, where_context: None, file_name: None, line: None, routine: None }

sapisuper avatar Aug 26 '24 07:08 sapisuper

MySQL peer creation is now supported in the UI

serprex avatar Mar 13 '25 01:03 serprex