want to integrate CPG with mambo! But cant lose CPG users table

[FearlessX]

Hi! im completely new to MySQL & PHP. So im lack in "skills".. i would like to integrate CPG with mambo! But cant lose CPG users table.. what should i do?

[Joachim Müller]

there's no converter script available to convert coppermine users to mambo users. You won't lose coppermine's user table though when enabling integration, it just won't be taken into account (meaning you can savely go back to the state your coppermine gallery was in before enabling integration). If you need the coppermine users to exist in your mambo user tables, you will have to create them in mambo and edit the reference to their personal galleries manually in your favorite database tool (e.g. phpMyAdmin) I'm afraid. There's no easy fix, it depends on the number of users you have if this method is actually applicable for you.

Joachim

[FearlessX]

i'm a little confused here.. is it difficult to be done? the password hashes (whatever you call it..  ) will be the same in mambo?   im new  
and btw, so u mean my albums will remain intact? how about users' albums? will they have problems (permissions etc) accessing it?

i was actually thinking of using the wrapper function in mambo and customising the 'links' in my mambo website to coppermine based so i wouldnt need to integrate the database together. so.. in short i'll just wrap everything up in mambo.. 

[Joachim Müller]

let me explain the whole point of integration: when using integration/bridging, coppermine still is a standalone application that does visually not blend into your mambo pages. It only uses the user accounts and groups you created in mambo. If you already have user accounts in coppermine, they are not deleted or lost, but just not taken into account as long as you have enabled integration (there's a single switch to toggle integration on/off). The pics in your public galleries (the ones the admin uploaded) will remain unchanged when you enable integration - only the reference between your coppermine users (which are not being taken into account) and your mambo users accounts is not there when you enable integration. Once you enable integration you have to "tell" coppermine that the coppermine user account X refers to the mambo user account Y (but only if you need to keep reference between the personal galleries your coppermine user created and your mambo users). You won't have to start from scratch, all files will still be there anyway - in the worst case (i.e. if you don't/can't manually edit references between coppermine and mambo users), the ownership of user galleries will be mixed up.
I suggest you just enable integration and take a look how it works - you can savely switch it off it it doesn't work for you.

Joachim

[jernst]

Thanks for the very helpful explanation of how integration works.  I only have one question: how does one "tell" coppermine which "coppermine user account X refers to the mambo user account Y"?  I understand that it will take the use of a database admin tool, but what column in what table do I need to modify?

[kegobeer]

After integration, Coppermine doesn't use it's own usertables anymore, it only uses your bbs's usertables.  If you have Coppermine users, you'll have to create users in your bbs with exactly the same login names before you do the integration.

[jernst]

Great news!

If I understand this correctly I should be able to migrate my existing Coppermine users into any of the bridged BBS's, and as long as the usernames (and presumably user id's) remain the same I can safely delete them from the Coppermine user's table (along with the unencrypted passwords!).  This will prevent the loss of all existing user pictures as described in the documentation.  Then, going forward, all new users will be entered through the BBS and everyone will play nice together, right?

Thanks a bunch!