CMS Integration

Danny, the error from yesterday (navigationLocale) is fixed in my dev version (not online, because I'm working on the search hook too).
I'll investigate in the _done() call, thanks.
btw: do I have to activate this logging functionality in xaraya because, my var/log/ folder is still empty... (or just chmod it to writable?)?

Valiant, I started a Bug Report about Xaraya behaviour with the Gallery2 Modul under

http://bugs.xaraya.com/show_bug.cgi?id=3834

It would be good, if you have a look at the Bug and give your expertise.

Thanks,

Danny

the container div (id="gallery") already exists.. the css just doesn't use it. I agree it should.

Danny, AFAIK there's an option to disable the title in the image block "heading" or something like that in the instance config.

mindless, I guess I need the image block without precompiled HTML, just the vars: thumb download url, fullsize download url, fullsize showitem url, titile, date, ... = unrendered imageblock.
i didn't check if it's already possible, is it?

thanks - Andy

Danny, very probably my fault, gonna correct it when i'm at home.

Thousand thanks, it works!

Hey,

I love your work here. When I try to install your Gallery2 module in Xaraya 0.9.11 I get the error indicating I need to update Gallery to version .8.8 (now .8.6).

So my question is:
What are the requirements now for the module? Should I use the CVS version of Gallery 2, which version of Xaraya do you require?

Keep the good work up!
Michel

Just a small question: I know you are all mainly busy with integration in xaraya but do you know if any work has been done/started to integrate G2 into Mambo ?

I'm really in a desperate need of this integration (even if G2 is still in alpha). I know some posts were done on the Mambo forum asking for developers but it seems nobody replied. (If I had any notion of PHP, I would gladly start coding myself).

Kind regards,
DrBob

I have Gallery CVS now integrated into Xaraya .9.11. I have coupled some dynamic data to the roles module.. so when adding a user he has some dynamic data.

When adding a user it all works great.

When deleting him then I get:

Failed to change G2 password to a random password during xaraya delete role process of role with extId [13]!
Explanation:

De functie is correct uitgevoerd, maar het resultaat is mislukt. (=function worked, but result failed)
Stack:

at _gallery2_adminapi_deleterolehook(deletehook.php:115)
at gallery2_adminapi_deletehook(deletehook.php:34)

If you want I can mail the complete error.

Michel

I have three new methods on my desktop for proposal to embed.php.

- getSyncMap(), Get map for syncing by mapping type.
In the xaraya code both types are readed at once. That's not a good solution where you do syncing for such users that do overlap. You have old data in the arrays after the database is updated by g2addexternalMapEntry. The method is a bit modified from the xaraya code.

- addSyncMapEntry(), Adds an entry for the map used for syncing.
Also from xaraya code.

- setProperty(), Set property for configure the way integration/embedding is done.
A delegate method for GalleryCapabilities::set(). I think it's easiest if integrations can consentrate only on one object GalleryEmbed for all the integration needs.

How about testacases. Does GalleryEmbed has it's own?

The code. I haven't tested it even yet. What do you think?

  /**
   * Get map for syncing by mapping type.
   *
   * @param string the id ('entityId' or 'externalId') used as key for the returned array 
   * @return array(object GallerySuccess, array(Id => array(externalId => integer,
   *                             entityId => integer, entityType => string)))
   */
  function getSyncMap($key)
  {
    $query = 'SELECT [ExternalIdMap::entityId], [ExternalIdMap::externalId], [ExternalIdMap::entityType]
		FROM [ExternalIdMap]';
    
    list ($ret, $results) = $gallery->search($query, array());
    if ($ret->isError()) {
      return array($ret->wrap(__FILE__, __LINE__), null);
    }
    $map = array();
    while ($result = $results->nextResult()) {
        $entry = array('externalId' => $result[1], 'entityId' => $result[0], 'entityType' => $result[2]);
        if ($type == 'externalId') {
	    	$map[$result[0]] = $entry;
	    } else if ($type == 'entityId') {
		    $map[$result[1]] = $entry;
		}
    }
    return array(GalleryStatus::success(), $map); 	
  }	  
  
  /**
   * Adds an entry for the map used for syncing.
   *
   * @access public
   * @param integer the externalId
   * @param integer the entityId
   * @param string the roles type, 'GalleryGroup' for groups, 'GalleryUser' for users
   * @return object GalleryStatus
   */
  function addSyncMapEntry($externalId, $entityId, $entityType)
  {
    $ret = ExternalIdMap::addMapEntry(array('externalId' => $externalId, 'entityType' => $entityType, 'entityId' => $entityId));
    if ($ret->isError()) {
      return array($ret->wrap(__FILE__, __LINE__), null);
    }
    return GalleryStatus::success();
  }
  
  /**
   * Set property for configure the way integration/embedding is done.
   * Valid keys are: showSidebar, showPathbar
   *
   * @access public
   * @param the key for the property
   * @param the value for the property
   * @return object GalleryStatus
   */
  function setProperty($key, $value)
  {
    $ret = GalleryCapabilities::set($key, $value);
    if ($ret->isError()) {
      return array($ret->wrap(__FILE__, __LINE__), null);
    }
    return GalleryStatus::success();
  }

Only for collecting all embedding methods in one place.

good news on the xaraya front. the status of xaraya bug 3535 has been changed to a xaraya 1.0 blocker. that means that i get my delete/create events (hooks) in xaraya, when a user/group gets deleted/purged/recalled.

EmAppUsers = {List of EmApp Users}
G2Users = {List of G2 Users}
Map = {List of mapped/sync'ed Users}

These lists are stored in the databases.
Cached Lists = arrays / hashes / ..., are images of the lists created one point in time and are not up to date.

Algorithm:

(01) Get cached Lists of EmAppUsers, G2Users and Map denoted as EmAppUsers_cache, G2Users_cache and Map_cache respectively;
(02) For each g2User in G2Users_cache do
(03)     if g2User NOT in Map_cache then
(04)         Create User in EmApp with user data from g2User;
(05)         Insert new mapping into Map;
(06)         Insert new mapping into Map_cache;
(07)     end if;
(08) end for;
(09) For each emAppUser in EmAppUsers_cache do
(10)     if emAppUser NOT in Map_cache then
(11)         Create User in G2 with user data from emAppUser;
(12)         Insert new mapping into Map;
(13)     else
(14)         Update User in G2 with user data from emAppUser;
(15)     end if;
(16) end for;

My point is as follows:
The cached Lists, especially the Map, needs either a refresh/update between line (8) and (9) of the code or as I did it here, it gets updated on each insert.
The point in having Map_cache organized by externalId AND by entityId is that in (3) and (10), we need a different structure of this Map list.

Note: (11) and (12) can be done with a single method call from GalleryEmbed.

I still don't understand why having two copies of a cached version of Map is worse than having only one as you propose.

Einstein, ah I see what you mean. Right. For the first iteration only Map by entityId is needed and for the second iteration Map by externalId. Ok, then I agree with your proposal of the function, only 1 list is needed per iteration.
Here's the slightly modified algorithm, I'll add it to the docs (which don't exist at the moment)

(01) Get cached lists of EmAppUsers, G2Users and Map by entityId denoted as EmAppUsers_cache, G2Users_cache and Map_by_entityId_cache respectively;
(02) For each g2User in G2Users_cache do
(03)     if g2User NOT in Map_by_entityId_cache then
(04)         Create User in EmApp with user data from g2User;
(05)         Insert new mapping into Map;
(06)     end if;
(07) end for;
(08) Get cached list of Map by externalId Map_by_externalId_cache;
(09) For each emAppUser in EmAppUsers_cache do
(10)     if emAppUser NOT in Map_by_externalId_cache then
(11)         Create User in G2 with user data from emAppUser;
(12)         Insert new mapping into Map;
(13)     else
(14)         Update User in G2 with user data from emAppUser;
(15)     end if;
(16) end for; 

PS: This is the way I did it in xaraya. Well, I get the Map always for both both Map_caches, but basically it's the same.
Group import/export and group memberships make the whole thing bloated, plus the exceptions that have to do with group membership incompatiblities between xaraya and G2. But basically, as you see, it's straight forward and easy.

Want to add that a conflict is where username same but password differ.

That's the scary thing ... usernames can be hijacked. Let's say you have SuperG2User in Gallery. For hijacking you register SuperG2User into EmApp. After the sync the second user have control over the first users Gallery information.

I finally undertood your algorithm the "right way". It's not possible to do it your way by overwriting passwords, if you want to solve the conflicts.

I leave the conflicts unmapped. After that you can run the sync again to get everything in order.

And your explanation why my way of resolving "conflicts" is incorrect is the "Superg2User" example? You can't call that hijacking. You know what happens during synchronization, you are in control of both applications. Just prepare the applications before the initial synchronzation.

But how do you know that a user with same username is the really the same user without checking the password? You don't know.

Say we have two users ... both use username bill. The first one has a username only to gallery. The second bill has only a username to EmApp. With your way the "gallery bill" cannot get into your system anymore.

Your way isn't incorrect .. but it can cause username problems if you integrate big userbases.

That's OK ... but it's good to ducument what other objects can be of use in i integration.

Hey,

I have Xaraya snap 050220 running with the CVS version of Gallery 2 and the integration module.
Install works fine, but when I go to configure the module there are some problems:

First, the config says:
Status of the Gallery2 module: The current configuration could not be verified successfully. Here is the error message:
[roles module was not hooked to our gallery2 module, but that is fixed now.]

I already did the hooks, before going to the gallery config, so why this message? At some times, this message is skipped.

Then, trying to synch the roles/users, I get:

Functie ontbreekt. (Function missing)

Failed to update special G2 group by extId [5]. Here is the error message from G2: <br /> [Error (GALLERY_SUCCESS)<UL><LI><B>in</B> <B>at line</B> 0</UL>]
Explanation:

De functie is correct uitgevoerd, maar het resultaat is mislukt. (result failed)
Stack:

at g2updatespecialroles(xargallery2helper.php:1181)
at g2xarusergroupimportexport(xargallery2helper.php:1262)

Array
(
[0] => 2
[1] => FUNCTION_FAILED
[2] => systemexception Object
(
[msg] => Failed to update special G2 group by extId [5]. Here is the error message from G2: <br /> [Error (GALLERY_SUCCESS)<UL><LI><B>in</B> <B>at line</B> 0</UL>]
[id] => 0
[major] => 0
[defaults] =>
[title] =>
[short] =>
[long] =>
[hint] =>
[stack] => Array
(
)

[product] =>
[component] =>
[module] => gallery2
)

)

at gallery2_admin_updateconfig(updateconfig.php:82)
at xarmodfunc(xarMod.php:871)
at xarmain(index.php:91)

Any idea where I should look to get it working again?

Michel

Versions are all latest CVS, or maybe a few days older. I am noticing that Xaraya is getting stricter in dealing with all kinds of variables. In between 9.11 and now some things 'break'.

I will try you suggestion of deleting g2_externalIdmap-entries

Hooks: the readme says only roles is needed. I also hooked dynamic data, but that didn't solve anything.

Thanks,
Michel

Deleted the entries in g2_externalIdmap, hit the button, received this error:

Functie ontbreekt.

Could not get extId for g2groupid [1].
Explanation:

De functie is correct uitgevoerd, maar het resultaat is mislukt.
Stack:

at g2xarusergroupimportexport(xargallery2helper.php:1500)
at gallery2_admin_updateconfig(updateconfig.php:82)

Array
(
[0] => 2
[1] => FUNCTION_FAILED
[2] => systemexception Object
(
[msg] => Could not get extId for g2groupid [1].
[id] => 0
[major] => 0
[defaults] =>
[title] =>
[short] =>
[long] =>
[hint] =>
[stack] => Array
(
)

[product] =>
[component] =>
[module] => gallery2
)

)

at xarmodfunc(xarMod.php:871)
at xarmain(index.php:91)
____
Retry:
____

Functie ontbreekt.

Failed to create a extmap entry for role uid [24] and entityId [1], entityType [GalleryGroup]. Here is the error message from G2: <br />
[Error (ERROR_STORAGE_FAILURE)<UL><LI><B>in</B> modules/core/classes/GalleryStorage/DatabaseStorage.class <B>at line</B> 1208 (gallerystatus::error) <LI><B>in</B> modules/core/classes/GalleryStorage.class <B>at line</B> 261 (mysqldatabasestorage::addmapentry) <LI><B>in</B> modules/core/classes/interfaces/ExternalIdMap.inc <B>at line</B> 96 (gallerystorage::addmapentry) <LI><B>in</B> embed.php <B>at line</B> 766 (externalidmap::addmapentry) <LI><B>in</B> /home/sensor/www/modules/gallery2/xargallery2helper.php <B>at line</B> 585 (galleryembed::addexternalidmapentry) <LI><B>in</B> /home/sensor/www/modules/gallery2/xargallery2helper.php <B>at line</B> 1367 (xargallery2helper::g2addexternalmapentry) <LI><B>in</B> /home/sensor/www/modules/gallery2/xaradmin/updateconfig.php <B>at line</B> 82 (xargallery2helper::g2xarusergroupimportexport) <LI><B>in</B> /home/sensor/www/includes/xarMod.php <B>at line</B> 871<LI><B>in</B> /home/sensor/www/index.php <B>at line</B> 91<LI><B>in</B> /home/sensor/www/index.php <B>at line</B> 159</UL>]
Explanation:

De functie is correct uitgevoerd, maar het resultaat is mislukt.
Stack:

at g2addexternalmapentry(xargallery2helper.php:590)
at g2xarusergroupimportexport(xargallery2helper.php:1367)

Array
(
[0] => 2
[1] => FUNCTION_FAILED
[2] => systemexception Object
(
[msg] => <DELETED>
[id] => 0
[major] => 0
[defaults] =>
[title] =>
[short] =>
[long] =>
[hint] =>
[stack] => Array
(
)

[product] =>
[component] =>
[module] => gallery2
)

)

at gallery2_admin_updateconfig(updateconfig.php:82)

Array
(
[0] => 24
[1] => 1
[2] => 1
)

at xarmodfunc(xarMod.php:871)
at xarmain(index.php:91)

The Gallery groups are updated, the gallery users not.

Michel

Yes, the error is when I hit the sync button. So the synchronizing causes the error.

Valiant,

Awsome work so far.

Not sure if its me or not but I am having the same problem as above, I did figure out to comment out the G2 version section and did get modify config to work but when I synced users I got a ton of errors and gallery was no longer working.

I use the current zip files of Xaraya and G2 and cvs'ed your integration into xaraya just yesterday, I do think I know what the problem is, I actually deleted the table and not the entries in it. this casued me to have to reinstall all of the G2.

I re ran the module setup and then ran the sync users and get the same error, its the usergroup function that I am having problems with.

Just to let you know:
After upgrading gallery2 to version 9 and updating the integration module to latest CVS, I still get the same error:

Failed to create a extmap entry for role uid [24] and entityId [1], entityType [GalleryGroup]. Here is the error message from G2: <br />
[Error (ERROR_STORAGE_FAILURE)<UL><LI><B>in</B> modules/core/classes/GalleryStorage/DatabaseStorage.class <B>at line</B> 1204 (gallerystatus::error) <LI><B>in</B> modules/core/classes/GalleryStorage.class <B>at line</B> 261 (mysqldatabasestorage::addmapentry) <LI><B>in</B> modules/core/classes/interfaces/ExternalIdMap.inc <B>at line</B> 96 (gallerystorage::addmapentry) <LI><B>in</B> embed.php <B>at line</B> 766 (externalidmap::addmapentry) <LI><B>in</B> www/modules/gallery2/xargallery2helper.php <B>at line</B> 585 (galleryembed::addexternalidmapentry) <LI><B>in</B> /www/modules/gallery2/xargallery2helper.php <B>at line</B> 1369 (xargallery2helper::g2addexternalmapentry) <LI><B>in</B> /www/modules/gallery2/xaradmin/updateconfig.php <B>at line</B> 82 (xargallery2helper::g2xarusergroupimportexport) <LI><B>in</B> /www/includes/xarMod.php <B>at line</B> 871<LI><B>in</B> /www/index.php <B>at line</B> 91<LI><B>in</B> /www/index.php <B>at line</B> 159</UL>]

I have to think about you accessing my box... are we the only ones with this problem?
Maybe easier to do a new install...

Michel

mm, I cannot install the latest CVS of Gallery2. Version error. I'll try with the beta release.

Michel