aMember Pro Configuration : vBulletin3 config error

Discussion in 'Integration' started by bodywatch, Jan 3, 2011.

  1. bodywatch

    bodywatch New Member

    Joined:
    Nov 3, 2010
    Messages:
    4
    Hello

    I would appreciate knowing what I am doing wrong setting up the above

    Firstly if I set dbname in vBulletin3 Db and Prefix section WITHOUT 'vb_' then I get RED ERROR when saving (DB - [dbname] - incorrect value. Error: Table dbname.dbuser' doesn't exist)

    However if I set 'vb_dbname' in the vBulletin3 Db and Prefix section then the error is (Access denied for user 'dbname'@'localhost' (using password: YES)

    So I believe use of 'vb_' is correct, and so....

    I have read Auto-detected values for the field:
    if there are no choices, it means that your third-party
    script database is unaccessible with aMember MySQL settings. You
    can fix it by going to Webhosting Control Panel -> MySQL Databases
    and allowing access to your third-party script table for aMember's
    Mysql user (dbname_amemdb), or your can specify MySQL database user,
    hostname and password on this page specially for use with
    the integration plugin and press Save button to see new choices.

    Hosting has cPanel - I have given user "dbname_amemdb" access to "dbname_vbulletin" as well as "dbname_amember"

    Perhaps I am missing something obvious

    Look forward to a reply

    Phil
  2. bodywatch

    bodywatch New Member

    Joined:
    Nov 3, 2010
    Messages:
    4
    I know it's early in the new year but I have a launch in 5 days - I would really appreciate feedback please ;-)
  3. skippybosco

    skippybosco CGI-Central Partner Staff Member

    Joined:
    Aug 22, 2006
    Messages:
    2,526
    couple of things to consider:

    1) You have [dbname] listed as your username in your example.. typically your database name and database user are different.

    2) Also keep in mind many ISPs include the account name as part of the database and/or username (ie. account_dbuser or account_database) so be sure that you are taking that into account with your configuration settings.
  4. bodywatch

    bodywatch New Member

    Joined:
    Nov 3, 2010
    Messages:
    4
    @skippybosco

    Thanks for getting back to me...

    1) I have similar name sets but there is a subtle difference
    "dbname_amemdb" access to "dbname_vbulletin" as well as "dbname_amember"

    Did I understand you correctly?

    2) I pulled the DB name and username from the config file... do you have any suggestions for double checking my work?

    Thanks in advance
  5. alexander

    alexander Administrator Staff Member

    Joined:
    Jan 8, 2003
    Messages:
    6,279
    Try to use this setting:
    dbname_vbulletin.vb_
  6. bodywatch

    bodywatch New Member

    Joined:
    Nov 3, 2010
    Messages:
    4
    Got it..

    Thanks for your help on this... appreciated:cool:

Share This Page