import of public users does not work

View: New views
6 Messages — Rating Filter:   Alert me  

import of public users does not work

by Bert Leunis :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Some parts of this message have been removed. Learn more about Nabble's security policy.

Hi All,

 

I had to delete my mysql database because of some corruption. I exported the public users before that and tried to import them in the new database. Unfortunately I did not succeed.

 

The exported xml (users.public.xml) does contain the folders and user data as existed in my database.

I tried several of the options in the Tools / Import function, but the users do not show up under Security / Public Users. When I check the database table “users_node” I can see that there are a lot of nodes there. The node_id’s are the same as the uuid’s of the users I have in my xml file. So something WAS imported, but I can’t see the public users in AdminCentral, nor can I log in as one of the public users.

 

 Is there an error in the Import or do I make some mistake?

 

I tried:

Repository: always “users”.

Base path: “/” or “/public” or “” or “public”… none of them worked

Keep versions: did not check that box

UUIDs: tried all 3 options with all options of the Base path.

 

I’m a bit stuck now. Can someone help?

 

Best regards, Bert

 




----------------------------------------------------------------
For list details see
http://www.magnolia-cms.com/home/community/mailing-lists.html
To unsubscribe, E-mail to: <user-list-unsubscribe@...>
----------------------------------------------------------------

Re: import of public users does not work

by Jan Haderka-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


in theory ... would need to see your export file tho ... and i don't
think you should be sending it over to just anybody as it contains
passwords of your users.
The idea is that the node structure is not of the same type as expected
which is why the users are not visible. But as I said to find out, one
would have to export your users workspace again and compare it to the
previously exported file as well as to export file from some other
healthy instance.

BTW, are you sure that the old and new instance have exactly same
version of all the libraries?

And you might also try re-indexing the users workspace.

Jan


On Fri, 2009-10-30 at 11:16 +0100, Bert Leunis wrote:

> Hi All,
>
>  
>
> I had to delete my mysql database because of some corruption. I
> exported the public users before that and tried to import them in the
> new database. Unfortunately I did not succeed.
>
>  
>
> The exported xml (users.public.xml) does contain the folders and user
> data as existed in my database.
>
> I tried several of the options in the Tools / Import function, but the
> users do not show up under Security / Public Users. When I check the
> database table “users_node” I can see that there are a lot of nodes
> there. The node_id’s are the same as the uuid’s of the users I have in
> my xml file. So something WAS imported, but I can’t see the public
> users in AdminCentral, nor can I log in as one of the public users.
>
>  
>
>  Is there an error in the Import or do I make some mistake?
>
>  
>
> I tried:
>
> Repository: always “users”.
>
> Base path: “/” or “/public” or “” or “public”… none of them worked
>
> Keep versions: did not check that box
>
> UUIDs: tried all 3 options with all options of the Base path.
>
>  
>
> I’m a bit stuck now. Can someone help?
>
>  
>
> Best regards, Bert
>
>  
>
>
>
>
>
> ______________________________________________________________________
> ----------------------------------------------------------------
> For list details see
> http://www.magnolia-cms.com/home/community/mailing-lists.html
> To unsubscribe, E-mail to: <user-list-unsubscribe@...>
> ----------------------------------------------------------------


----------------------------------------------------------------
For list details see
http://www.magnolia-cms.com/home/community/mailing-lists.html
To unsubscribe, E-mail to: <user-list-unsubscribe@...>
----------------------------------------------------------------


RE: import of public users does not work

by Bert Leunis :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi Jan,

Thanks for your answers. The corruption was in some dialog node, but of course you can never know.
I did restart the server and deleted the indexes. Both instances had exactly the same libraries.

I exported the users workspace, and compared that to an export of a healty workspace. I think I found the source of my problem. Take a look at the attached picture. Besides the system and admin node there are 5 nodes named public. Sure all of them the result of my attempts to upload the public users. Some of the public nodes are empty, like the one in the blue box. The one in the red box is the one I want. Clearly I added the nodes giving them another UUID, instead of overwriting them. My mistake.

Do you have a tip how to get rid of the unwanted nodes?

Regards, Bert


> -----Original Message-----
> From: user-list-owner@... [mailto:user-list-
> owner@...] On Behalf Of Jan Haderka
> Sent: vrijdag 30 oktober 2009 12:38
> To: Magnolia User-List
> Subject: Re: [magnolia-user] import of public users does not work
>
>
> in theory ... would need to see your export file tho ... and i don't
> think you should be sending it over to just anybody as it contains
> passwords of your users.
> The idea is that the node structure is not of the same type as expected
> which is why the users are not visible. But as I said to find out, one
> would have to export your users workspace again and compare it to the
> previously exported file as well as to export file from some other
> healthy instance.
>
> BTW, are you sure that the old and new instance have exactly same
> version of all the libraries?
>
> And you might also try re-indexing the users workspace.
>
> Jan
>
>
> On Fri, 2009-10-30 at 11:16 +0100, Bert Leunis wrote:
> > Hi All,
> >
> >
> >
> > I had to delete my mysql database because of some corruption. I
> > exported the public users before that and tried to import them in the
> > new database. Unfortunately I did not succeed.
> >
> >
> >
> > The exported xml (users.public.xml) does contain the folders and user
> > data as existed in my database.
> >
> > I tried several of the options in the Tools / Import function, but
> the
> > users do not show up under Security / Public Users. When I check the
> > database table “users_node” I can see that there are a lot of nodes
> > there. The node_id’s are the same as the uuid’s of the users I have
> in
> > my xml file. So something WAS imported, but I can’t see the public
> > users in AdminCentral, nor can I log in as one of the public users.
> >
> >
> >
> >  Is there an error in the Import or do I make some mistake?
> >
> >
> >
> > I tried:
> >
> > Repository: always “users”.
> >
> > Base path: “/” or “/public” or “” or “public”… none of them worked
> >
> > Keep versions: did not check that box
> >
> > UUIDs: tried all 3 options with all options of the Base path.
> >
> >
> >
> > I’m a bit stuck now. Can someone help?
> >
> >
> >
> > Best regards, Bert
> >
> >
> >
> >
> >
> >
> >
> >
> ______________________________________________________________________
> > ----------------------------------------------------------------
> > For list details see
> > http://www.magnolia-cms.com/home/community/mailing-lists.html
> > To unsubscribe, E-mail to: <user-list-unsubscribe@...>
> > ----------------------------------------------------------------
>
>
> ----------------------------------------------------------------
> For list details see
> http://www.magnolia-cms.com/home/community/mailing-lists.html
> To unsubscribe, E-mail to: <user-list-unsubscribe@...>
> ----------------------------------------------------------------


----------------------------------------------------------------
For list details see
http://www.magnolia-cms.com/home/community/mailing-lists.html
To unsubscribe, E-mail to: <user-list-unsubscribe@...>
----------------------------------------------------------------


public users.PNG (50K) Download Attachment

RE: import of public users does not work

by Jan Haderka-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message



> Do you have a tip how to get rid of the unwanted nodes?

Many different options, for example:
- make the users workspace visible in jcr broswer (brace yourself, it
will look weird w/ some nodes seemingly duplicated) and delete the
copies of "public" you don't want
- delete those nodes directly using BSH shell and shell module
- write a custom class to delete those extra nodes
- export whole users workspace, fix the export file, put it in the
bootstrap folder, shutdown, delete users workspace, startup and hope for
the best

... your pick ;)

cheers,
Jan


----------------------------------------------------------------
For list details see
http://www.magnolia-cms.com/home/community/mailing-lists.html
To unsubscribe, E-mail to: <user-list-unsubscribe@...>
----------------------------------------------------------------


RE: import of public users does not work

by Bert Leunis :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


Thanks Jan,

I added some lines to the start() method of a ModuleLifecycle class like this:

                        Content contentByUUID = ContentUtil.getContentByUUID(ContentRepository.USERS, "a7e7df3b-2547-47dd-942b-c57afdf02976");
                        Content parent = contentByUUID.getParent();
                        contentByUUID.delete();
                        parent.save();

And that worked beautifully. I let this here to run once of course.

Have a good weekend, Bert


> -----Original Message-----
> From: user-list-owner@... [mailto:user-list-
> owner@...] On Behalf Of Jan Haderka
> Sent: vrijdag 30 oktober 2009 14:23
> To: Magnolia User-List
> Subject: RE: [magnolia-user] import of public users does not work
>
>
>
> > Do you have a tip how to get rid of the unwanted nodes?
>
> Many different options, for example:
> - make the users workspace visible in jcr broswer (brace yourself, it
> will look weird w/ some nodes seemingly duplicated) and delete the
> copies of "public" you don't want
> - delete those nodes directly using BSH shell and shell module
> - write a custom class to delete those extra nodes
> - export whole users workspace, fix the export file, put it in the
> bootstrap folder, shutdown, delete users workspace, startup and hope
> for
> the best
>
> ... your pick ;)
>
> cheers,
> Jan
>
>
> ----------------------------------------------------------------
> For list details see
> http://www.magnolia-cms.com/home/community/mailing-lists.html
> To unsubscribe, E-mail to: <user-list-unsubscribe@...>
> ----------------------------------------------------------------


----------------------------------------------------------------
For list details see
http://www.magnolia-cms.com/home/community/mailing-lists.html
To unsubscribe, E-mail to: <user-list-unsubscribe@...>
----------------------------------------------------------------


Re: import of public users does not work

by Åke Argéus :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


 From an earlier experience with broken nodes causing admincentral to  
be unavailable we have included something we call EvilDeleteCommand in  
one of our magnolia-setups. It's a JMX-Mbean with one call that it  
deletes a single node based on the parameters "repository" and "path".  
You can see how we came up with the name ;)

/Åke

30 okt 2009 kl. 16.13 skrev Bert Leunis:

>
> Thanks Jan,
>
> I added some lines to the start() method of a ModuleLifecycle class  
> like this:
>
> Content contentByUUID = ContentUtil.getContentByUUID
> (ContentRepository.USERS, "a7e7df3b-2547-47dd-942b-c57afdf02976");
> Content parent = contentByUUID.getParent();
> contentByUUID.delete();
> parent.save();
>
> And that worked beautifully. I let this here to run once of course.
>
> Have a good weekend, Bert
>
>
>> -----Original Message-----
>> From: user-list-owner@... [mailto:user-list-
>> owner@...] On Behalf Of Jan Haderka
>> Sent: vrijdag 30 oktober 2009 14:23
>> To: Magnolia User-List
>> Subject: RE: [magnolia-user] import of public users does not work
>>
>>
>>
>>> Do you have a tip how to get rid of the unwanted nodes?
>>
>> Many different options, for example:
>> - make the users workspace visible in jcr broswer (brace yourself, it
>> will look weird w/ some nodes seemingly duplicated) and delete the
>> copies of "public" you don't want
>> - delete those nodes directly using BSH shell and shell module
>> - write a custom class to delete those extra nodes
>> - export whole users workspace, fix the export file, put it in the
>> bootstrap folder, shutdown, delete users workspace, startup and hope
>> for
>> the best
>>
>> ... your pick ;)
>>
>> cheers,
>> Jan
>>
>>
>> ----------------------------------------------------------------
>> For list details see
>> http://www.magnolia-cms.com/home/community/mailing-lists.html
>> To unsubscribe, E-mail to: <user-list-unsubscribe@...>
>> ----------------------------------------------------------------
>
>
> ----------------------------------------------------------------
> For list details see
> http://www.magnolia-cms.com/home/community/mailing-lists.html
> To unsubscribe, E-mail to: <user-list-unsubscribe@...>
> ----------------------------------------------------------------
>


----------------------------------------------------------------
For list details see
http://www.magnolia-cms.com/home/community/mailing-lists.html
To unsubscribe, E-mail to: <user-list-unsubscribe@...>
----------------------------------------------------------------