search

PiwikPRO / plugin-SiteMigration

Migrate websites and website data between two Piwik installations
17 stars 3 forks source link

SSL support for MySQL? #40

Open derekmorr opened 8 years ago

derekmorr commented 8 years ago

Does the plugin support using SSL for MySQL? I haven't seen how to configure it. If it doesn't, it should. I'm trying to use the plugin, but I'm reluctant to send MySQL login credentials and user data in cleartext across a network.

MegaphoneJon commented 6 years ago

You've probably long since solved your issue, but for others: I handled this by using SSH tunnels. From the old Piwik server, I connected to the new Piwik server with: 

ssh username@piwiknew.example.com -L 3307:localhost:3306

I then opened a second SSH session to the old Piwik server, and I could connect to the new Piwik server's MySQL instance on port 3307:

./console migration:site -H 127.0.0.1 --db-prefix=piwik_ --db-port=3307 1

Note that it's important to specify a host of 127.0.0.1 instead of localhost in most cases here, due to how MySQL handles credentials.