[opencms-dev] export / import user database

Christian Steinert christian_steinert at web.de
Wed Aug 9 11:54:36 CEST 2006


ruben martin schrieb:
> Hi EveryB at dy,
> 
> Thanks Christian for you answere, but...
> 
> Hmm....About using the patch...we would like not to depend on it, we
> would like to do it by this another way...so , thanks for this .
> 
> On the other hand , i do not remember exacly, since i see a lot of webs
> , but i can tell you that the field USER_ID into the table CMS_USERS
> which is call by  other filds into another tables , exactly i do not
> know  now ...sorry...
> 
> So, there is any tool created for do it ????

The only tool for this that I know of is the database export tool.
Probably the UUID of a user will be used, if you specify user-related
permissions. But if user-Ids and files are exported and imported
together (which the database tool does) I do not know if that would
create problems. I don't know if the UUID of the Admin user and the
default usergroups is identical on all systems or if it is created when
the system is installed. If these IDs are identical on all systems, then
I don't think that there could be trouble in this area.

Apart from this I do not know where UUIDs could create trouble. Their
only point is to generate unique keys. After a key is generated, it does
not matter anymore, if the key-generation used the MAC address of your
computer or of another one. The only question would be if that key is
used in tables that you cannot export/import.

As already mentioned I can only think of the user and the groups table
here, but you could easily try if this leads to trouble or not.

christian

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3269 bytes
Desc: S/MIME Cryptographic Signature
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20060809/66f92a41/attachment.bin>


More information about the opencms-dev mailing list