Just figured it out, mysql sock was pointing to macOS's MAMP path, instead the developer should've made it a mandatory field for user to specify the location of the sock or use default location for each OS. For anyone having the same issue here's the solution.
-
First use ssh to login to mysql: mysql -u root -p
-
Enter your root password then type: show variables like 'socket';
-
You will get something like this:
+---------------+---------------------------+
| Variable_name | Value |
+---------------+---------------------------+
| socket | /var/lib/mysql/mysql.sock |
+---------------+---------------------------+
This the sock path you need /var/lib/mysql/mysql.sock
now exit
mysql and open index.js
file located in nodebb-plugin-import-xenforo
and edit this line https://github.com/akhoury/nodebb-plugin-import-xenforo/blob/master/index.js#L24 to reflect your sock path, save the file and restart the forum.
Note: After you select an exporter and before starting the migration make sure to check the box Skip the module install
or it'll replace the file index.js
and reverse all the work you just did.
The importer should work now if everything is set properly. Hope this helps someone.