No users of coppermine in usermambo after bridging

[seb123]

Upgrading en bridging went fine with mambo. Only the registrated users in mambo can automaticly use coppermine. But the users of coppermine (before bridging) can't login with the login of mambo. How do I put the users of coppermine in mambo, so that they also can login?

[Nibbler]

You'll need to convert them to mambo users by transfering them into the mambo users table. I can't provide detailed instructions though.

[seb123]

Do you know somebody who can? Do i have to use phpMyAdmin or a script?

[Joachim Müller]

there's no script nor automatic method available - you have to do this manually.
http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#integrating_users_start

[seb123]

I manual made the users of coppermine in de Mos_users. (first made new users in mambo admin and then changed the id to the id of coppermine). The first few users was not a problem, but when i finished this the integration didn't work at all. If a (new) user logged in with mambo he is now not logged in in coppermine. Does somebody know what i did wrong and how a can change this. I already tried to disable and enable ingetration, but that didn't work.

[Joachim Müller]

hard to say without knowing what you did exactly.

[seb123]

I made a new user (example; rob)in mambo (in admin panel). Then i went to phpMyAdmin, changed the id of rob in mos_users for example: id:87 into id:4. Because id 4 is the id of rob in coppermine.

[Joachim Müller]

ok, I'm afraid that this might collide with mambo's user management - you shouldn't change the ids. Instead, you'd have to go through coppermine's database and change all references to the user with the id "4" to the id "87".

[seb123]

Thanks for the support. I brought my db settings for coppermine back to normal and als the mos_user. But if i want to bridge again it seems that it isn't working. I made the change of mambo.inc. If i click on log in in coppermine i'm going to the mainpage and logging in as admin of mambo. When i'm going to coppermine i'm not logged in coppermine. And if i'm clicking on the albums of other users it's saying that there are no albums of users, but they are!
Does somebody knows what the problem might be? Before changing the mos_user it all was working perfectly.
Help!!!!! :\'(

[Joachim Müller]

I made the change of mambo.inc.

What change?

[seb123]

// Connect to db
      $this->connect();
      
      // Delete old sessions
      $past = time()-$mosConfig_lifetime;
      $sql = 'delete from '.$this->sessionstable.' where (time < '.$past.');';
      cpg_db_query($sql, $this->link_id);
      
      }

[Joachim Müller]

who told you to change the file?

[seb123]

http://forum.coppermine-gallery.net/index.php?topic=20049.msg97532#msg97532

[gram]

seb123:

If you are going to create new users in Mambo, you need to leave thier userid's intact.  Mambo creates several entries in its user groups tables that correlate to the userid it assigns.  It cannot be modified without extensive knowledge of how to make correlating changes in the other tables.

If you choose to use the bridge supplied with CPG 1.4, you do not need to change thier ids in Mambo to match those in Coppermine.

After entering each new user, just make sure that their group affiliation allows them to do what you want them to do in CPG.  CPG will use the groups assigned by Mambo, and your settings for those groups in CPG to setup their rights and access under CPG.

The userid's don't have to match, as CPG will ignore its own user table when you have the bridge activated.  Mambo users who are either Super Administrators, or Administrators  will be admins under CPG.  Be careful of one issue.  If you want a user to be an administrator under CPG, don't just set them up as Super Admins under Mambo.  MAmbo has no way to derank or delete them once they are super admins.

GRAM

GRAM