Questions

[wdoerr]

I have several questions about OX-HE:

1.
Is it possible to change the context ID after the context is created and users are created within that context?

2.
Is it possible to split up the MySQL dbs (oxdb_) in such a way that each db contains only the data from one context?

3.
The changecontext command doesn't seem to work.
Running
changecontext -c 1002 -N "foobar" -q 1024 -R "1002,foobar.de,foobar.eu"
followed by listcontext still shows foobar.de,foobar.eu

Thanks in advance for any help.

-Walter Dörr

[Carsten Hoeger]

I have several questions about OX-HE:

1.
Is it possible to change the context ID after the context is created and users are created within that context?

No.

2.
Is it possible to split up the MySQL dbs (oxdb_) in such a way that each db contains only the data from one context?

Yes, just set maxctx to 1 using the changedatabase command or API.

3.
The changecontext command doesn't seem to work.
Running
changecontext -c 1002 -N "foobar" -q 1024 -R "1002,foobar.de,foobar.eu"
followed by listcontext still shows foobar.de,foobar.eu

The cid cannot be removed from the mappings. But the server should issue an error message. That's a bug.

It works when you do not remove the 1002 in your -R parameters.

[Carsten Hoeger]

No.

The cid cannot be removed from the mappings. But the server should issue an error message. That's a bug.

I opened a bug:

http://bugs.open-xchange.com/cgi-bin/bugzilla/show_bug.cgi?id=11094

[Manuel Kraft]

have several questions about OX

I have several questions about OX-HE:

1.
Is it possible to change the context ID after the context is created and users are created within that context?

No, but you can create mappings for contexts at creation time and later with changecontext. So you can map context 1337<->test.org . No you could login with username@test.org instead of username@1337

2.
Is it possible to split up the MySQL dbs (oxdb_) in such a way that each db contains only the data from one context?

Yes, but this has to be done initially after ox installation. Please see file:

/opt/open-xchange/etc/admindaemon/plugin/hosting.properties

and set:

# amount of contexts per database schema
CONTEXTS_PER_SCHEMA=1000

to

CONTEXTS_PER_SCHEMA=1


This would be a method to backup single contexts because you could backup a single db.


3.
The changecontext command doesn't seem to work.
Running
changecontext -c 1002 -N "foobar" -q 1024 -R "1002,foobar.de,foobar.eu"
followed by listcontext still shows foobar.de,foobar.eu


You cannot remove the context id with -R . Try without the "1002" in the -R switch.


Regards,

Manuel Kraft

Thanks in advance for any help.

-Walter Dörr

See my comments above

[Manuel Kraft]

Removing mappings works without any problem. But that no error is shown when trying to remove the cid mapping entry seems to be a bug.

cutmasta:/opt/open-xchange/sbin# sh changecontext -c 2 -L nase
context 2 changed
cutmasta:/opt/open-xchange/sbin# sh listcontext
cid fid fname enabled qmax qused name lmappings
1 3 1_ctx_store true 5000 0 1 cutmasta.org,1
2 3 2_ctx_store true 5000 0 2 gmail.com,nase,2
3 3 3_ctx_store true 5000 0 koloa.de koloa.de,3
cutmasta:/opt/open-xchange/sbin# sh changecontext -c 2 -R 2,nase
context 2 changed
cutmasta:/opt/open-xchange/sbin# sh listcontext
cid fid fname enabled qmax qused name lmappings
1 3 1_ctx_store true 5000 0 1 cutmasta.org,1
2 3 2_ctx_store true 5000 0 2 gmail.com,2
3 3 3_ctx_store true 5000 0 koloa.de koloa.de,3
cutmasta:/opt/open-xchange/sbin#