Vista combinada Visión Plana Vista de árbol
Discusiones [ Anterior | Siguiente ]
toggle
Roman Hoyenko
Make Public pages private
26 de diciembre de 2007 14:59
Respuesta

Roman Hoyenko

Ranking: Liferay Master

Mensajes: 868

Fecha de incorporación: 8 de octubre de 2007

Mensajes recientes

I have a website with a lot of public pages that need to be made private.

What I tried to do is to update tables to change 'PUB.' to 'PRI.' in different tables, but there are some problems.

Here is what I did:

update Resource_ r set r.primKey=(replace(r.primKey, 'PUB.1028', 'PRI.1028'));

update Layout l set l.ownerId = (replace(l.ownerId, 'PUB.1028', 'PRI.1028'));

update LayoutSet set pageCount = 5 where ownerId='PRI.1028';
update LayoutSet set pageCount = 0 where ownerId='PUB.1028';

update JournalContentSearch set ownerId='PRI.1028' where ownerId='PUB.1028';

The problems I have:

The theme changed. Should I update some other table to have the theme changed?

Journal Content articles do not show content. What do I need to do so I can see the content? The portlets are still there, they just don't show the content.
Roman Hoyenko
RE: Make Public pages private
8 de noviembre de 2007 16:24
Respuesta

Roman Hoyenko

Ranking: Liferay Master

Mensajes: 868

Fecha de incorporación: 8 de octubre de 2007

Mensajes recientes

I got it, I missed this table:

update PortletPreferences set ownerId='PRI.1028' where ownerId='PUB.1028';

worked fine after update.
Man V K
RE: Make Public pages private
21 de diciembre de 2007 1:08
Respuesta

Man V K

Ranking: Regular Member

Mensajes: 139

Fecha de incorporación: 4 de diciembre de 2007

Mensajes recientes

Hi Roman,
I have similar situation, i have one public page under the community i have created, now every one can see the contents(portlet)of the page without login, i want make this page to view only after the successful login. how to do this ??

Thanks
Vin
Man V K
RE: Make Public pages private
21 de diciembre de 2007 1:08
Respuesta

Man V K

Ranking: Regular Member

Mensajes: 139

Fecha de incorporación: 4 de diciembre de 2007

Mensajes recientes

Hi Roman,
I have similar situation, i have one public page under the community i have created, now every one can see the contents(portlet)of the page without login, i want make this page to view only after the successful login. how to do this ??

Thanks
Vin
Ray Augé
Re: [Liferay Forums][5. Portal Framework]RE: Make Public pages private
21 de diciembre de 2007 6:16
Respuesta

Ray Augé

LIFERAY STAFF

Ranking: Liferay Legend

Mensajes: 1171

Fecha de incorporación: 7 de febrero de 2005

Mensajes recientes

1) Both users must be part of the community in question.
2) Visit the "Manage Pages (or Page settings)", select the page you want
to protect/share.
3) On the "Page" tab, click the "Permissions" button.
4) Remove all "Guest" permissions, (and depending on your version,
remove all "Community" permissions).
5) Assign VIEW permission to whoever should have access to the page.
Ray Augé
Re: [Liferay Forums][5. Portal Framework]RE: Make Public pages private
21 de diciembre de 2007 6:31
Respuesta

Ray Augé

LIFERAY STAFF

Ranking: Liferay Legend

Mensajes: 1171

Fecha de incorporación: 7 de febrero de 2005

Mensajes recientes

You can get around this first requirement if the user is part of a "User
Group" and you give VIEW permission to the "public" page to this User
Group. BUT, they won't have the Community in their "My Places"
submenu...so they'll have to know the URL.

>
> 1) Both users must be part of the community in question.
> 2) Visit the "Manage Pages (or Page settings)", select the page you want
> to protect/share.
> 3) On the "Page" tab, click the "Permissions" button.
> 4) Remove all "Guest" permissions, (and depending on your version,
> remove all "Community" permissions).
> 5) Assign VIEW permission to whoever should have access to the page.
shaun pollock
RE: Re: [Liferay Forums][5. Portal Framework]RE: Make Public pages private
19 de febrero de 2008 11:03
Respuesta

shaun pollock

Ranking: New Member

Mensajes: 5

Fecha de incorporación: 16 de febrero de 2008

Mensajes recientes

How do i change the behavior of the Add Page link to add private pages to the user rather than a community wide page , which it does by default ?

Thx
Tommy Tommson
RE: Re: [Liferay Forums][5. Portal Framework]RE: Make Public pages private
2 de julio de 2009 11:07
Respuesta

Tommy Tommson

Ranking: Junior Member

Mensajes: 30

Fecha de incorporación: 25 de mayo de 2009

Mensajes recientes

Is there a possibility to make public pages really private without only fixing the permissions? So that they appear as private pages when I select them via the control bar > My Places > Community > Private ?
Senthil Chockalingam
RE: Make Public pages private
5 de abril de 2012 7:58
Respuesta

Senthil Chockalingam

Ranking: New Member

Mensajes: 3

Fecha de incorporación: 30 de noviembre de 2009

Mensajes recientes

Hi Hoyenko,

I am using the Liferay 5.2.3 version with Mysql server in linux environment.

And in my lportal schema, ownerId field is missing in Layout, LayoutSet tables.

Please let me know that, how can run the below queries in my db.

  • update Layout l set l.ownerId = (replace(l.ownerId, 'PUB.1028', 'PRI.1028'));
  • update LayoutSet set pageCount = 5 where ownerId='PRI.1028';
  • update LayoutSet set pageCount = 0 where ownerId='PUB.1028';


And in my Resource_ table, the primKey field contains only 5 digit no like (47655). It is not like this format PRI 47655.

So tell me how to run the below query

  • update Resource_ r set r.primKey=(replace(r.primKey, 'PUB.1028', 'PRI.1028'));


As well as, in JournalContentSearch table, same issue.

The ownerId field is missing.


Please guide me, to move the public community pages to private community pages using DB.

Regards,
Senthil
David H Nebinger
RE: Make Public pages private
5 de abril de 2012 8:03
Respuesta

David H Nebinger

Ranking: Liferay Legend

Mensajes: 7252

Fecha de incorporación: 1 de septiembre de 2006

Mensajes recientes

Senthil Chockalingam:
Please guide me, to move the public community pages to private community pages using DB.


Not possible. Liferay purposefully obfuscates their DB because the API relies upon it heavily. There's also indexing and other portions of Liferay that can break if you go tinkering w/ the database.

A golden rule of using Liferay is to never modify the database directly.
Senthil Chockalingam
RE: Make Public pages private
5 de abril de 2012 8:24
Respuesta

Senthil Chockalingam

Ranking: New Member

Mensajes: 3

Fecha de incorporación: 30 de noviembre de 2009

Mensajes recientes

Hi David,

Thanks for the Quick response.

But one of my client is created a community (with 130 public pages). I want to bring that community as private i.e(In any way i have to bring that community under group url).

Is there any possibilities emoticonemoticon
Senthil Chockalingam
RE: Make Public pages private
5 de abril de 2012 8:28
Respuesta

Senthil Chockalingam

Ranking: New Member

Mensajes: 3

Fecha de incorporación: 30 de noviembre de 2009

Mensajes recientes

Some times the bulk Export/Import is not functioning properly.
Hitoshi Ozawa
RE: Make Public pages private
14 de abril de 2012 5:56
Respuesta

Hitoshi Ozawa

Ranking: Liferay Legend

Mensajes: 7954

Fecha de incorporación: 23 de marzo de 2010

Mensajes recientes

I think you may need to change permission/role tables too. Pages are very complicated and I've found out it's better not to try to do it directly using sql commands. I've also found that it can be done easily with portlets.