Cannot create simple bridge between Joomla and CPG

[ferrer]

Hi,

I have been reading and reading and reading on this. No anwsers..
I have my joomla site, and a coppermine install. All I want to do is sycronise the users / passwords and have a unified login. I use the bridge included with coppermine (selecting the mambo option), but then coppermine doesnt error, but wont see me as logged in. If i click on the "login" buttone i just get redirected to my joomla index.php. I login again, and no joy in my coppermine install. Does not see me as logged in.

i know about the copperminevis component, but its commericial. Anyone got a joomla integration working?
Other info.

joomla site is on www.site.com/content
coppermine is on www.site.com/gallery

Both have different MySQl databases, but permissions to read / write to both.

I have read the installation / intergration instructions

(GauGau - i have read your requirements for posting on here, but my site is on an intranet and not available externally, i dont mean to make life difficult)



help!

[Nibbler]

It sounds like a cookie issue. Make sure that the joomla cookies are readable from where Coppermine is located. That means that the path should be '/'. Posting debug info would help in this case.

[ferrer]

My cookie path is set to / in the coppermine config. Are there any permissions I should check on the server?

How do i get my debug info?

Thank you very much for your quick reply.

T

[Nibbler]

I was referring to the cookie path in joomla. Debug info can be obtained by enabling debug mode in config. Make sure you post the debug info that you get when you should in theory be logged into coppermine with your joomla user.

[ferrer]

I cannot find a setting in admin of joomla to check / alter my cookie path. Im googling now, to see if there is something I am missing.

[ferrer]

I added a new user in joomla and it passed it WAS pased on to coppermine, but when clicking "users" in coppermine, i got this error

While executing query "SELECT id as user_id, username as user_name, email as user_email, UNIX_TIMESTAMP(registerDate) as user_regdate, UNIX_TIMESTAMP(lastvisitDate) as user_lastvisit, 1-block as user_active, COUNT(pid) as pic_count, ROUND(SUM(total_filesize)/1024) as disk_usage, group_name, group_quota FROM `joomla`.jos_users AS u INNER JOIN cpg143_usergroups AS g ON u.gid+100 = g.group_id LEFT JOIN cpg143_pictures AS p ON p.owner_id = u.id GROUP BY user_id ORDER BY user_regdate DESC LIMIT 0, 25;" on Resource id #17

mySQL error: Table 'joomla.cpg143_usergroups' doesn't exist

debug info

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

==========================
USER DATA:
------------------
Array
(
    [user_id] => 65
    [user_name] => test
    [groups] => Array
        (
           

• => 1
          )
  
      [disk_max] => 0
      [disk_min] => 0
      [can_rate_pictures] => 1
      [can_send_ecards] => 1
      [ufc_max] => 3
      [ufc_min] => 3
      [custom_user_upload] => 0
      [num_file_upload] => 5
      [num_URI_upload] => 3
      [can_post_comments] => 1
      [can_upload_pictures] => 1
      [can_create_albums] => 1
      [has_admin_access] => 1
      [pub_upl_need_approval] => 0
      [priv_upl_need_approval] => 0
      [group_name] => Administrators
      [upload_form_config] => 3
      [group_quota] => 0
      [can_see_all_albums] => 1
      [group_id] => 1
  )
  
  ==========================
  Queries:
  ------------------
  Array
  (
     
• => SELECT extension, mime, content, player FROM cpg143_filetypes; (0.001s)
      [1] => select * from cpg143_plugins order by priority asc; (0s)
      [2] => SELECT * FROM cpg143_bridge (0s)
      [3] => delete from `joomla`.jos_session where (time < 1139243584); (0s)
      [4] => select userid from `joomla`.jos_session where session_id=md5("b4d80edeb06640331032f26ead2a050c"); (0.001s)
      [5] => select id, password from `joomla`.jos_users where id=65 (0s)
      [6] => SELECT u.id AS id, u.username AS username, u.password AS password, u.gid+100 AS group_id FROM `joomla`.jos_users AS u INNER JOIN `joomla`.jos_core_acl_aro_groups AS g ON u.gid=g.group_id WHERE u.id='65' (0s)
      [7] => 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 (1) (0.001s)
      [8] => SELECT group_name FROM  cpg143_usergroups WHERE group_id= 1 (0s)
      [9] => update `joomla`.jos_session set time="1139244484" where session_id=md5("b4d80edeb06640331032f26ead2a050c"); (0s)
      [10] => SELECT user_favpics FROM cpg143_favpics WHERE user_id = 65 (0s)
      [11] => DELETE FROM cpg143_banned WHERE expiry < '2006-02-06 16:48:04' (0s)
      [12] => SELECT * FROM cpg143_banned WHERE (ip_addr='80.41.61.194' OR ip_addr='80.41.61.194' OR user_id=65) AND brute_force=0 (0s)
      [13] => DELETE FROM cpg143_users WHERE user_name = '' LIMIT 1 (0s)
      [14] => SELECT COUNT(*) FROM cpg143_pictures WHERE approved = 'NO' (0s)
      [15] => SELECT count(*) FROM `joomla`.jos_users WHERE 1 (0.001s)
      [16] => SELECT id as user_id, username as user_name, email as user_email, UNIX_TIMESTAMP(registerDate) as user_regdate, UNIX_TIMESTAMP(lastvisitDate) as user_lastvisit, 1-block as user_active, COUNT(pid) as pic_count, ROUND(SUM(total_filesize)/1024) as disk_usage, group_name, group_quota FROM `joomla`.jos_users AS u INNER JOIN cpg143_usergroups AS g ON u.gid+100 = g.group_id LEFT JOIN cpg143_pictures AS p ON p.owner_id = u.id GROUP BY user_id ORDER BY user_regdate DESC LIMIT 0, 25; (0.002s)
  )
  
  ==========================
  GET :
  ------------------
  Array
  (
  )
  
  ==========================
  POST :
  ------------------
  Array
  (
  )
  
  ==========================
  VERSION INFO :
  ------------------
  PHP version: 5.1.1 - OK
  ------------------
  mySQL version: 4.1.16-nt
  ------------------
  Coppermine version: 1.4.3(stable)
  ==========================
  Module: GD
  ------------------
  GD Version: bundled (2.0.28 compatible)
  FreeType Support: 1
  FreeType Linkage: with freetype
  T1Lib Support: 1
  GIF Read Support: 1
  GIF Create Support: 1
  JPG Support: 1
  PNG Support: 1
  WBMP Support: 1
  XPM Support:
  XBM Support: 1
  JIS-mapped Japanese Font Support:
  
  ==========================
  Module: mysql
  ------------------
  MySQL Supportenabled
  Active Persistent Links 0
  Active Links 2
  Client API version 4.1.7
  ==========================
  Module: zlib
  ------------------
  ZLib Support enabled
  Stream Wrapper support compress.zlib://
  Stream Filter support zlib.inflate, zlib.deflate
  Compiled Version 1.2.3
  Linked Version 1.2.3
  ==========================
  Server restrictions (safe mode)?
  ------------------
  Directive | Local Value | Master Value
  safe_mode | Off | Off
  safe_mode_exec_dir | no value | no value
  safe_mode_gid | Off | Off
  safe_mode_include_dir | no value | no value
  safe_mode_exec_dir | no value | no value
  sql.safe_mode | Off | Off
  disable_functions | no value | no value
  file_uploads | On | On
  include_path | .;C:\PHP\pear | .;C:\PHP\pear
  open_basedir | no value | no value
  ==========================
  email
  ------------------
  Directive | Local Value | Master Value
  sendmail_from | me@localhost.com | me@localhost.com
  sendmail_path | no value | no value
  SMTP | localhost | localhost
  smtp_port | 25 | 25
  ==========================
  Size and Time
  ------------------
  Directive | Local Value | Master Value
  max_execution_time | 30 | 30
  max_input_time | 60 | 60
  upload_max_filesize | 2M | 2M
  post_max_size | 8M | 8M
  ==========================
  Page generated in 0.172 seconds - 17 queries in 0.006 seconds - Album set : ; Meta set: ;

[ferrer]

No changes, and it doesnt recognise my test login anymore. Is there anything more i can post that may help?

[Nibbler]

I don't know enough about mambo/joomla to fix this, sorry.

[ferrer]

Thanks for your candour...

its very strange, hopefully someone else has succesfully achieved this.

Thanks anyway, t

[ferrer]

After more research It seems this is a common problem. Perhaps there is a problem with the bridge included with this release, do any members of the dev team have any ideas?

Thanks for your help, and work on a great product.

Tristan