Hi Liam,

Many thanks for this module. Hopefully you can quickly diagnose my problem...I sense it's something on my server and not your module. Here's what's happening with me:

1. Fill out configuration settings. Save.
2. Run test. Passes on all tests.
3. Click on the migrate data tab.
4. The screen quickly returns 1-5 below. Takes a while with #6. Then quickly through 7-9.

   1. Importing users...
   2. Importing forums...
   3. Importing threads...
   4. Importing posts...
   5. Importing polls...
   6. Importing files...
   7. Importing private messages...
   8. Rebuilding stats...
   9. Fixing BBCode...

Finished, go back

5. Click on "go back"
6. The resulting screen has a bunch of mysql errors all basically with the following pattern:

user warning: INSERT command denied to user 'vbulletin_user'@'mpaler-02.myserver.com' for table 'users_signature' query: INSERT IGNORE INTO drupal_test.users_signature (uid, signature) SELECT user.userid+1000000, signature FROM user INNER JOIN usertextfield ON user.userid=usertextfield.userid WHERE signature IS NOT NULL in /var/www/vhosts/mydomain.com/subdomains/dev/httpdocs/includes/database.mysql.inc on line 172.

From the looks of it, it looks like the script is trying to insert stuff into the drupal database using the vbulletin mysql user account.

Does this look like the correct assessment to you?

Thanks again,
Michael

Comments

liam mcdermott’s picture

liam mcdermott commented
Status: Active » Closed (works as designed)

I've just been wrestling with the same problem myself. :)

The problem is that MySQL is used to do the heavy lifting (it's the *only* way to do this), ergo the MySQL username importing to the Drupal database must have read access to the vBulletin database.

The only ways around this are to: 1. give the Drupal user read access to the vBulletin database, or; 2. mysqldump the vBulletin database, then import it to a database the Drupal user _does_ have access to.

*** EDIT ***
I actually got this the wrong way around. The vBulletin username has to have INSERT privileges on the Drupal database (as it's the vBulletin username that's used to do the import). Small distinction, but important. :)

mpaler’s picture

mpaler commented

To those who have a similar issue, you need to make sure the denied user is granted access from the host in the error msg.

For example, the error msg says:

vbulletin_user@mpaler-02.myserver.com

you need to grant access to vbulletin_user to the drupal database from mpaler-02.myserver.com or even better, any host.

If you don't have root db admin access, you'll need to have your host do this.

liam mcdermott’s picture

liam mcdermott commented

Setting Status back to by design. :)