Having issues with XenForo importer

[Cyb3r]

Hey guys. Been trying for the last 2 days to import my XenForo database to NodeBB for testing purposes. But I couldn't get it to work it just try to install the XenForo importer plugin and break on setup. I have done everything required and tried both locally and on my VPS but I always get the same result.

If someone can help i'll be much appreciated.

[Cyb3r]

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.

[julian]

@cyb3r Thanks for sharing your difficulties with the MySQL connection. Hopefully it will help someone

[Cyb3r]

@julian Happy to help!