No announcement yet.

MySQL 5 View + VB Users Table

  • Filter
  • Time
  • Show
Clear All
new posts

  • MySQL 5 View + VB Users Table

    So let me just say first that I'm running VB 3.5.2 so if pluggable authentication has been added since that version, sorry for this post. Essentially I need to have VB authenticate against an existing users database. Currently, I'm using plugins to sync the data each time someone logs in, but that's not an ideal strategy. I'm upgrading VB and my server, and was thinking about moving to MySQL 5. One interesting thing about MySQL 5 is that it now supports views. So I was thinking about creating a special vb_user_addl table that holds all the VB-specific data, and then creating a VIEW that joins the data from my users table with the data from the vb_user_addl table (and makes all necessary changes to the column names).

    Now while I'm pretty sure I could make this work, I'm not sure about the performance issues. Has anyone tried this? Any tips? Any thoughts on a better solution?


  • #2
    I have never tried that nor have I heard of anyone else trying it.

    For user / login integration solutions I recommend you post on


    • #3
      OK, sorry. Posted question at:


      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.