MySQL Usernames for Different Plugins

Discussion in 'Integration' started by joe_asto2, Jan 17, 2007.

  1. joe_asto2

    joe_asto2 New Member

    Joined:
    Aug 22, 2006
    Messages:
    68
    On my hosting platform (Plesk), each database is owned by a different username. All the integration plugins use the main aMember database username as the database username for connecting to other MySQL databases.

    I need to use different MySQL usernames (and passwords) for different integration plugins.

    How can I do this?

    I tried looking in the code to see if I could hard-code my database login details, but I didn't succeed.

    I'm using the Joomla, Drupal and PHPList plugins.
  2. draj

    draj New Member

    Joined:
    Dec 29, 2006
    Messages:
    252
  3. joe_asto2

    joe_asto2 New Member

    Joined:
    Aug 22, 2006
    Messages:
    68
    Thanks Draj.

    Have you managed to get your code working?
  4. draj

    draj New Member

    Joined:
    Dec 29, 2006
    Messages:
    252
    Hi!

    I did not see a possbility! It requires a fundamental change, I beleive.

    The database calls needs to be sorted out in the manner that the could be associated to different db.

    So I beleive that it is currently not possible. Also I see that a super script like this _DOES_ require something like this.
  5. joe_asto2

    joe_asto2 New Member

    Joined:
    Aug 22, 2006
    Messages:
    68
    Implemented by this week

    Hi Draj,

    I tried to use the same changes myself, but the problem is that the script plugins call global variables, rather than specific ones. I think a separate variables file for plugins would have to be made.

    However, I raised a support ticket about this last week, and Alex said, "Joe, we will implement this by the next week" which is good news!
  6. draj

    draj New Member

    Joined:
    Dec 29, 2006
    Messages:
    252
    Hi!

    This a very nice news indeed. A feature that is MUCH needed.
  7. acquisitiveone

    acquisitiveone New Member

    Joined:
    Jan 20, 2007
    Messages:
    1
    I too have encountered this problem b/c my PHPBB and Amember database are separate with different usernames and passwords. Could you please let me know how you are able to fix this problem. I do not want to reinstall the PHPBB tables into the Amember database.
  8. alex

    alex aMember Pro Customer Staff Member

    Joined:
    Jan 24, 2004
    Messages:
    6,021
    Work is in progress, it will be ready and published soon.
  9. kevin_ch1

    kevin_ch1 New Member

    Joined:
    Aug 29, 2006
    Messages:
    1
    Just checked with support, and their response was that they plan to implement this in the near future. Didn't state how soon the near future was. Bummer!
  10. draj

    draj New Member

    Joined:
    Dec 29, 2006
    Messages:
    252

Share This Page