Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.I have Domain Access and SSO working for several top level domain sites.
"
I was having a problem with duplicate URL's across the sites, such as "about", "advertising" etc...The type of pages that would appear on all sites, with just slightly different content to reflect the uniqueness of that site.
I thought table prefixing would help, so I enabled that module and created a new domain through the DA's "create domain record" procedure.
Upon heading to the new site, get "Access Denied" and at the top I get this error message:
Warning: Unknown column 's.domain' in 'where clause' query: SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = '6tdlbhdhsqri6ebdst9s2ht2k6' AND s.domain = 'newdomain.com' in C:\wamp\www\primarydadomain.com\includes\database.mysqli.inc on line 128
So currently im sharing a session across all my sites, and upon creating this new one...and attempting to share that session its having a problem with s.domain...Thats how I read it. Any way to solve this one?
| Comment | File | Size | Author |
|---|---|---|---|
| #8 | 632950_domain_prefix_sso_8.patch | 3.56 KB | zserno |
| #7 | 632950_domain_prefix_sso_4.patch | 2.84 KB | agentrickard |
| #4 | 632950_domain_prefix_sso_4.patch | 664 bytes | zserno |
Comments
Comment #1
Netbuddy commentedShould add that after I enabled the prefix module, I set it up so that upon creating this new site, DA would create (not copy) the URL alias table. I cant see how the above immediately relates to to that table...but thats what I get.
Comment #2
bleen commentedI am just trying to get DA to work with SSO and I am getting the same error. I do not have domain_prefix enabled but I do have:
domain_access
domain_alais
domain_config
domain_nav
domain_source
domain_theme
domain_views
all enabled. Any luck with this error since your original post?
Comment #3
zserno commentedI did some debugging and it turned out that Domain Access overwrites $db_prefix if that's an array. See corresponding part of domain_prefix module's INSTALLATION.txt:
So it's clear that this is a conflict between these modules at the moment. I think it's rather a DA issue though.
Comment #4
zserno commentedAttached patch fixes domain_prefix.module's behavior.
Also, assigning it to Domain module to discuss if this is the proper way to get these modules work together.
Note: if we get agentrickard's blessing on this, we'll need to update Domain prefix's INSTALLATION.txt respectively.
Comment #5
agentrickardI see. This also needs to be tested with #883180: domain_set_domain(0, TRUE); does not bootstrap main domain.
Comment #6
zserno commentedBoth patches apply nicely to HEAD and they're working well together: SSO works fine as well as domain_set_domain() using the test code from http://drupal.org/node/883180#comment-3360480.
Comment #7
agentrickardFixed up the patch and added/removed documentation. Now formatted from domain root.
I'd like to get one more once-over on this, then commit.
Comment #8
zserno commentedTested new patch: works as expected (with sso, too). Adjusted domain's INSTALL.txt as well.
Comment #9
agentrickardThanks. I'll commit this when I get some time.
Comment #10
agentrickardCommitted to 6.x and HEAD of Domain Prefix. Could use a backport to 5.
Comment #11
agentrickardD5 is dead.