Xaraya Integration Failure

Building a new test server hoping things are read for me to update production to Xaraya and G2. Installed G2 from CVS and most seems okay (fails to load some of my images but I'll get to that later). Installed Xaraya-0.9.11 and that too is running okay. Installed Andy's gallery2 module for Xaraya and ran into two things; one I can deal with, the other is fatal.

First, the tolerable one... It seems the g2 installation must be somewhere within the Xaraya installation. Tried to track down the reason with no luck. Found another posting suggesting moving g2 and tied it. Worked. Figured I'd repost here in case someone is listening and interested in a fix. I'd like to be able to store g2 independant of xaraya.

The fatal problem is that after setting up the g2 module in xaraya, the xaraya admin menu is no longer accessable. I redid everything a couple times and get the same thing every time. No errors in the apache logs, no errors in the generated pages.

Hmmm.... Suggestions?

----

Gallery URL (optional): dugas.homeip.net
Gallery version: g2-cvs-20050107
Webserver (with version): apache 2.0.52
Datatabase (with version): mysql 3.23.58
PHP version (eg 4.2.1): 4.3.10
phpinfo URL (optional):
Graphics Toolkit(s): gd-2.0.28, ImageMagick-6.0.7.1, netpbm-10.25
Operating system: Linux, Fedora Core 3
Web browser/version: Firefox-1.0

@1. Long time retentive system admin here. Don't like things installed all on top of the others without apackage manager so... I have a /usr/local/www/gallery2 and a /use/local/www/xaraya and I use apache to set the "root" of a virtual to xaraya an an "alias" support /gallery requests. Gallery is certainly accessable, just not in the document root. Any thoughts on whan in your module prevents this from working?

@2. I've been poking around again and it looks like xaraya thinks I shouldn't get access to the admin menu. I'm going to start over and see if I can get a look at the xar roles (read: users) table before and after installing the module. I suspect the added "myself" user is screwing with something. I wonder if you might explain to this non-gallery, non-xaraya guy what the deal is with the user sync stuff?

I should add that the integration worked for me a while back but I decided to reinstall Xaraya to start over. At the moment, the only thing I remember being different with the installs was that I select "Public Site" now. I think this just adjusts the default permissions but someone more femilliar with Xaraya will have to verify this.

I will open up the system to you to poke around if it comes to that but I agree. Let's redo it with your updated module in a caouple days.

@2. good point. I only tested it with "Community Site", not with "Public Site". Once I tried a different site style and something with the permissions didn't work with my module.
The myself user is from xaraya, not G2. But after the first gallery2 module configuration (=initial user/group synchronization (import/export)), this myself user will exist in G2 too.
My code shouldn't remove/add any permissions in xaraya. The whole integration works simplex, from xaraya to G2, not the other way around.
The one exception is the initial user/group synchronization. All users/groups of G2 that don't exist in xaraya, will be created in xaraya.
I'll look into this "Public Site" today.

@1. Ok, didn't think of that. What the xar gallery2 module does: take the relative path you specify and expects realpath(dirname($_SERVER['SCRIPT_FILENAME']) . '/' . $relativeG2Path) . '/'; to be the directory of G2. I don't accept absolute paths (starting with '/').
dirname($_SERVER['SCRIPT_FILENAME']) returns the absolute path to your xaraya directory. I don't know if it returns the alias or the location in the webroot.
Maybe you know more about this now knowing what I do with the relative path you specify, do you?

@2. Reinstalled Xaraya-0.9.11 from scratch and selected "Community Site". Installed your 12/18 module and it seems to be working. Interesting.

@1. First my details. Gallery2 is installed in /usr/local/www/gallery2. Its data is in /usr/loca/www/g2data. Xaraya is installed in /usr/local/www/xaraya-0.9.11. The DocumentRoot for Apache is set to /usr/local/xaraya-0.9.11/html and there is an Alias mapping "/gallery" to /usr/local/www/gallery2. I entered "../../gallery2/" into the module config as the path to gallery. The module init was accepted.

When I it the gallery module within xaraya, I get the page contents as expected but the images are missing. Looking into the generates source, the URLs are "http://gallery2/maim.php...". I think the "../.." in the path-to-gallery that I entered is resulting in the host portion of the URL being removed.

Would is be wise to consider having users enter two paths? One relative path for PHP to use when looking for the gallery embed.php and others. Another for the URL path to gallery? Seems like for most installs, they'd be the same but for people like me who like to be difficult, ... ;)

Now that I think some more about it (after more coffee and some food), The filesystem path to my g2 install ends in gallery2 but URL ends in just gallery (no "2"). There's no way you can know what the correct URLs should be without an additional config option if there are others with tricky webserver configs like me. If I read this correctly, in the modules current state, g2 must be installed in the same DocumentRoot as Xaraya.

@1. fixed, or i guess so. please download the new xaraya module version and let me know how it works. and if you have better help texts for the new paths, post them please

@2. quite big problem. in xaraya, admins must not be in the all users group and in G2, they must be members of the users group.
I'll have to change / add some code in a few places to make this exception.
it was only luck that this problem didn't show up with xaraya community sites.
expect a fix within 2 weeks, i have a lot of other things to do.

Hi, gets this error when trying to integrate gallery2 into xaraya.

Function failed

Could not create a xar role for a G2 user 'admin'.
Explanation:

The function executed correctly, but the result was a failure.
Stack:

at g2xarusergroupimportexport(xargallery2helper.php:1459)
at gallery2_admin_updateconfig(updateconfig.php:87)

Array
(
[0] => Array
(
)

)

at xarmodfunc(xarMod.php:880)

Array
(
[0] => gallery2
[1] => admin
[2] => updateconfig
)

at xarmain(index.php:85)

Any idea on how to fix this?

My system:
Gallery version 2.0-alpha-4+
PHP version 4.3.10-1.dotdeb.0 apache
Webserver Apache/1.3.26 (Unix) Debian GNU/Linux PHP/4.3.10-1.dotdeb.0
Database mysql 4.1.7-log
Toolkits ImageMagick, NetPBM
Operating system Linux torungen 2.4.28 #1 SMP Thu Dec 2 08:25:21 CET 2004 i686
Browser Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7) Gecko/20041013 Firefox/0.9.3 (Ubuntu

fcd, can you retry with debug output enabled in config.php and find the database error near the bottom of the output?

Well there seems to be a whole bunch of errors so I guess I'll start at the top as it where.

http://216.235.149.51//gallery/gallery.log

1. cvs / bk /cvs
2. This is a new group.

Does he have any tables that end with "sequenceid" in his database? We create those when we configure the database .. but I see he's using a different prefix so maybe something went wrong there.

mindless / bharat, yes it is this bug.
/modules/core/classes/GalleryStorage/DatabaseStorage/
MySqlDatabaseStorage.class

the bug is fixed in the mysql file (function newEntity) but not in
PostgreSqlDatabaseStorage.class and
OracleDatabaseStorage.class as function newEntity is not redefined in these files.

Could you fix it? (Either fix it in DatabaseStorage.class function newEntity or in all implementations of DatabaseStorage.class)
Thanks!

thanks!

fcd, that means for you that G2 is fixed. You should get the next nightly snapshot and try again.

fcd, does G2 work in standalone mode? First, G2 has to be installed (run through the install wizard) in standalone mode, if it is working, run through the xaraya gallery2 config.
this error should show up, if something's wrong with G2...

fcd, how old is your G2? is it a very recent nightly snapshot?
the issue with the sequenceId should have been solved with our fix.
I'll install G2/xaraya today again to see if i have the same problems.

<sigh/>
if xaraya wants to hack adodb i'm not sure what we can do...

// XARAYA MODIFICATION - START
        //var $_genIDSQL = "SELECT NEXTVAL('%s')";
        //var $_genSeqSQL = "CREATE SEQUENCE %s START %s";
        //var $_dropSeqSQL = "DROP SEQUENCE %s";
    // Prefix the sequence number to make it unique
    var $_genIDSQL = "SELECT NEXTVAL('seq%s')";
    var $_genSeqSQL = "CREATE SEQUENCE seq%s START %s";
        var $_dropSeqSQL = "DROP SEQUENCE seq%s";
    // XARAYA MODIFICATION - END

xaraya's postgres adodb sticks "seq" on the front of the name you pass to GenID. i suppose you can create a sequenced called seqg2_SequenceId.. but then make very sure not to use G2 standalone to avoid duplicate ids (or modify G2 standalone to also use seqg2_SequenceId)

It is latest CVS. (Or as of yesterday). I don't know if this http://bugs.xaraya.com/show_bug.cgi?id=3905 bug has anything to do with it. This line "SELECT NEXTVAL('seqg2_SequenceId')" is definitely wrong. The sequence name is g2_SequenceId. When I look at my xaraya sequences (which adodb auto-gens for non-mysql I think, there is also a sequence for every table) they begin with 'seq'.

here's a workaround for this...
1) get the latest G2 code
2) make this patch to modules/core/classes/GalleryStorage/DatabaseStorage.class

change: $id = $this->_db->GenId($this->_tablePrefix . DATABASE_SEQUENCE_ID); to: $id = $this->_db->GenId('seq' . $this->_tablePrefix . DATABASE_SEQUENCE_ID);
change: $recordSet = $this->_db->CreateSequence($this->_tablePrefix . $sequenceId); to $recordSet = $this->_db->CreateSequence('seq' . $this->_tablePrefix . $sequenceId);
change: $recordSet = $this->_db->DropSequence($this->_tablePrefix . $sequenceId); to: $recordSet = $this->_db->DropSequence('seq' . $this->_tablePrefix . $sequenceId);
change: $lockId = $db->GenId($this->_tablePrefix . DATABASE_SEQUENCE_LOCK); to: $lockId = $db->GenId('seq' . $this->_tablePrefix . DATABASE_SEQUENCE_LOCK);

3) now do a clean G2 install
4) after successful install now undo the first and last changes shown above
5) set embed-only mode in config.php --- G2 will not work in standalone mode now!
6) access G2 via xaraya

This will install G2 using the 'seq' prefix for sequences.

fcd, I worked closely together with the xaraya devs and there's now a development tree of xaraya that is compatible with G2 AND postgres (mysql worked also before). The development tree is called xaraya core/adodbupdate and chances are very good that it will be merged into the release tree in a few days/weeks.