I ran into a problem trying to use the nifty Host Node Map.
It worked great for one domain name, but then I wanted to add the www. to the same node, to handle the guys that always prepend this to every domain name.
Basically the datamodel was set to use the node_id as the primary key in the map table host_node_map, and the foreign key constraint on the node_id was set to the acs_objects.object_id, when it actually comes from the site_nodes table. Here is the original sql for the table:
create table host_node_map (
host varchar(200),
node_id integer
primary key references acs_objects(object_id)
);
To get my hack to work, I change the table to:
create table host_node_map (
host varchar(200) primary key not null,
node_id integer references site_nodes
);
It seems to work great. Now I can mount multiple domains/hostnames on one node.
