problems (emergency recovery)

[mindwall]

I have the following issue when trying to bridge coppermine and phpBB:

1) I can log-in as admin, but I can't turn-off the bridge
ie. I can't log-in the "Bridge Manager: emergency recovery"

2) When I bridged I already had users in the gallery, and the result was a mixup in the users's and galleries. How can I move/create albums in my USERs without knowing their passwords in order to recreate the proper albums, Or maybe there is a way to re-assign which user from the gallery corresponds to a user in the forum? (how can this be done, what would you recommend?)

3) I don't know if this is result from the bridge, but I set an album with a password. Unfortunately no one can get in because the album is not Visible unless you are logged with the user who created the album (which defies the whole idea of having a separe pass for an album)... is this supposed to work this way?

4) When I choose "last uploads" I can only see one page, the links to the second, 3rd.. etc link to non-existant pages.

4.5) this may be linked to the above, but the same thing happened when I had 2 pages of users, and the second page link was non existent leadin to nowhere, and some of the user accounts were left unaccessible (this was tested before I upgraded to last version, the previous was 1.4.3 if I recall correctly)

5) Can't batch upload to users' albums (it shows only public/(and probably own) albums when placing batch uploaded files)

(some of the problems may not be result from the bridge)
The biggest problem right now is that I cannot administer (move/create) albums of my users. The previous version at least allowed me to batch-upload to users' albums, and now I can't even do that after the update... any suggestions?

Coppermine install: http://www.46it.ca/gallery/
Forum install: http://www.46it.ca/forum/
FRAME INTERFACE (buttons on right): http://www.46it.ca
(press the little green BTR-ON button to turn red to avoid listening to radio)
Coppermine version: 1.4.5 (stable)
Forum version: phpBB 2.0.19
Test user account: tester/tester

BridgeManager settings:
Forum URL:  http://www.46it.ca/forum/
Relative path to your BBS's config file:  ../forum/ 
Use post-based groups?:  yes

[Nibbler]

I have the following issue when trying to bridge coppermine and phpBB:

You already agreed to a 1 question per thread policy, please respect it in the future

1) I can log-in as admin, but I can't turn-off the bridge
ie. I can't log-in the "Bridge Manager: emergency recovery"

Use your Coppermine admin details - what happens when you try?

2) When I bridged I already had users in the gallery, and the result was a mixup in the users's and galleries. How can I move/create albums in my USERs without knowing their passwords in order to recreate the proper albums, Or maybe there is a way to re-assign which user from the gallery corresponds to a user in the forum? (how can this be done, what would you recommend?)

This is why this is not recommended. You can only resolve this by manually editing the database entries.

3) I don't know if this is result from the bridge, but I set an album with a password. Unfortunately no one can get in because the album is not Visible unless you are logged with the user who created the album (which defies the whole idea of having a separe pass for an album)... is this supposed to work this way?

Normal - if you want 'private' icons displayed then you should enable them in config.

4) When I choose "last uploads" I can only see one page, the links to the second, 3rd.. etc link to non-existant pages.

The SEF urls plugin is *experimental*. If you are not comfortable with debugging experimental code then don't use it.

4.5) this may be linked to the above, but the same thing happened when I had 2 pages of users, and the second page link was non existent leadin to nowhere, and some of the user accounts were left unaccessible (this was tested before I upgraded to last version, the previous was 1.4.3 if I recall correctly)

Probably the same thing.

5) Can't batch upload to users' albums (it shows only public/(and probably own) albums when placing batch uploaded files)

Normal - batch adding into user galleries is not supported and this has been enforced in recent Coppermine versions.

[mindwall]

sorry about the multiple problem post,
if I turn the debug ON, as I go to "recovery" I become a guest, and the debug info is below...
it basicaly does not recognize my login/pass later (but not I have to wait 1450 seconds... to see the error message when login is attempted)

USER:
------------------
Array
(
    [ID] => db6cbfad6dea410ba91102eb6a06c7f2
    [am] => 1
    [lang] => english
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 0
    [user_name] => Guest
    [groups] => Array
        (
           

• => 3
          )
  
      [group_quota] => 0
      [can_rate_pictures] => 1
      [can_send_ecards] => 0
      [can_post_comments] => 0
      [can_upload_pictures] => 0
      [can_create_albums] => 0
      [pub_upl_need_approval] => 1
      [priv_upl_need_approval] => 1
      [upload_form_config] => 3
      [num_file_upload] => 5
      [num_URI_upload] => 3
      [custom_user_upload] => 0
      [disk_max] => 0
      [disk_min] => 0
      [ufc_max] => 3
      [ufc_min] => 3
      [has_admin_access] => 0
      [group_name] => Guests
      [can_see_all_albums] => 0
      [group_id] => 3
  )
  
  ==========================
  Queries:
  ------------------
  Array
  (
     
• => SELECT extension, mime, content, player FROM cpg143_filetypes; (0s)
      [1] => select * from cpg143_plugins order by priority asc; (0s)
      [2] => delete from `46it_ca_-_gallery`.cpg143_sessions where time<1147466764 and remember=0; (0s)
      [3] => delete from `46it_ca_-_gallery`.cpg143_sessions where time<1146260764; (0s)
      [4] => select user_id from `46it_ca_-_gallery`.cpg143_sessions where session_id=md5("ccea3fa54bfcb36e5c6dcca01b198d355673e4d5989ccda9f72480b5a46b47e9"); (0s)
      [5] => select user_id as id, user_password as password from `46it_ca_-_gallery`.cpg143_users where user_id=0 (0s)
      [6] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as  priv_upl_need_approval FROM cpg143_usergroups WHERE group_id in (3) (0s)
      [7] => SELECT group_name FROM  cpg143_usergroups WHERE group_id= 3 (0s)
      [8] => update `46it_ca_-_gallery`.cpg143_sessions set time='1147470364' where session_id=md5('ccea3fa54bfcb36e5c6dcca01b198d355673e4d5989ccda9f72480b5a46b47e9'); (0s)
      [9] => DELETE FROM cpg143_banned WHERE expiry < '2006-05-12 16:46:04' (0s)
      [10] => SELECT * FROM cpg143_banned WHERE (ip_addr='72.137.62.51' OR ip_addr='72.137.62.51' OR user_id=0) AND brute_force=0 (0s)
      [11] => SELECT aid FROM cpg143_albums WHERE visibility != '0' AND visibility !='10000' AND visibility NOT IN (3) (0s)
      [12] => SELECT value FROM cpg143_bridge WHERE name = 'recovery_logon_timestamp' (0s)
      [13] => SELECT value FROM cpg143_bridge WHERE name = 'recovery_logon_failures' (0s)
  )
  
  ==========================
  GET :
  ------------------
  Array
  (
  )
  
  ==========================
  POST :
  ------------------
  Array
  (
  )
  
  ==========================
  Page generated in 0.067 seconds - 14 queries in 0 seconds - Album set : AND aid NOT IN (45,52) ; Meta set: ;

[Nibbler]

Have you verified the username and password with phpmyadmin ?

[mindwall]

Have you verified the username and password with phpmyadmin ?

no, I just assumed that since I can log-in with the admin account it's the same.
I'll try phpmyadmin ...

[Nibbler]

You can't login with the Coppermine admin account - you are bridged.

[mindwall]

I had the same login/pass for both the forum and the gallery, so I can log-in... it's just when I go and try to use the recovery it asks me for a login again and does not accept the admin account.

[mindwall]

is the Recovery login case sensitive?
(now I have to wait a few hours to try again)

where can I find the login account I can use in the database recovery?
is that user with [user_id = 1] ?

[mindwall]

turns out that the for the admin account the USER NAME is CASE SENSITIVEwhen you are trying to recover from bridging!
(as if you login to the gallery as usual as admin it is not case sensitive)

[Joachim Müller]

usernames and passwords are always case-sensitive. Issue solved?

[mindwall]

yep, it's solved. (recovery was a success)

but I do login without proper case to the admin account and everything works, just the bridge-manager needs case sensetive username.
(my username there is "MindWall" and I login as "mindwall" without a problem, just the bridge-manager didn't want to "recover" (when I needed to recover the bridge I had to put in the proper login name "MindWall").
(I still login as "mindwall" without a problem)

I did another check, I made a TeSteR/tester account in the gallery with a mixed-case username, and you can login successfully with just lower case "tester" too... so it appears that the username is not case sensitive here...