Unwanted database entries in the bundle installed

[Deepak Bhatia，修改在14 年前。]

Hi,

I have installed the liferay bundle with tomcat 5.5.

So I am able to login as [e-mail] and password as test.

But I see lot of organizations, users etc.

How can I make my installation free of such entries ?

Thanks

Deepak Bhatia

[Shagul Khaja，修改在14 年前。]

Which version are you running? See if the below property helps. If it is false in portal.properties, you could override them in portal-ext.properties.

 #
    # Set this to to true to populate with the minimal amount of data. Set this
    # to false to populate with a larger amount of sample data.
    #
    schema.run.minimal=true

[Babu Janarthanan，修改在14 年前。]

Hi,
Assuming that you have executed the create-mysql.sql.
in this case, you will be getting large amount of datas.
to get minimal amount of datas, you have to just mention the DB name and required credentials of the Database in portal-ext.properties, make sure the property schema.run.minimal is set to true, i.e, schema.run.minimal=true.

and start your server, no need to execute any scripts.

Hope this helps you....

Thx,
Babu

[Deepak Bhatia，修改在14 年前。]

Hi,

Please send me example if possible.

Thanks

Deepak Bhatia

[Babu Janarthanan，修改在14 年前。]

Steps to be followed for creating minimal amount of datas.

1. create data base name in mysql
eg. create database lportal;

2. in portal-ext.properties, configure the data base name(lportal) and specify the DB credentials.

jdbc.default.driverClassName=com.mysql.jdbc.Driver
jdbc.default.url=jdbc:mysql://localhost/lportal?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false
jdbc.default.username=username
jdbc.default.password=****

3. check the property name schema.run.minimal is set to true, this property will be available in portal.properties
schema.run.minimal=true

4. start the server and check for this message in console "Create tables and populate with default data"

5. find the screen shot for your reference.

hope this helps you.

Thx,
Babu

[Deepak Bhatia，修改在14 年前。]

Thanks for your help.

But when we using liferay 5.2.3 bundle with Tomcat 5.5, the database comes populated with users, organizations etc.

How do I know what is the current database name ?

Also how do I access the mysql that comes with bundle ?

Regards

Deepak Bhatia

[Babu Janarthanan，修改在14 年前。]

But when we using liferay 5.2.3 bundle with Tomcat 5.5, the database comes populated with users, organizations etc.

I guess you have executed create-mysql.sql. in this case all data will be populated.

How do I know what is the current database name ?

You can check portal-ext.properties.

Also how do I access the mysql that comes with bundle ?

are you talking about script or ?

[Juan Antonio Gálvez Jiménez，修改在14 年前。]

Hi Deepak,

I think Liferay 5.2.3 use 7cogs hook, it creates organization, users, etc.

You have to remove sevencogs-hook, sevencogs-theme and wol-portlet before start tomcat the first time.

If you have alredy run it, drop database, remove the 7cogs stuff and run it again.


get luck.

[Deepak Bhatia，修改在14 年前。]

Juan Antonio Gálvez Jiménez:

Hi Deepak,

I think Liferay 5.2.3 use 7cogs hook, it creates organization, users, etc.

You have to remove sevencogs-hook, sevencogs-theme and wol-portlet before start tomcat the first time.

If you have alredy run it, drop database, remove the 7cogs stuff and run it again.


get luck.

Thanks for your response.

How do I remove sevencogs-hook, sevencogs-theme and wol-portlet ?

Also how do Install Mysql ?

Thanks

Deepak

[Babu Janarthanan，修改在14 年前。]

How do I remove sevencogs-hook, sevencogs-theme and wol-portlet ?

you can delete it from the webapps folder of your server....
localtion:
tomcat-6.0.18\webapps\
you can find those folder

Also how do Install Mysql ?

you can install using mysql installer. you can visit mysql site for more information.

hope it helps you.

Thx,
Babu

[Deepak Bhatia，修改在14 年前。]

Hi Thanks,

I have used Liferay 5.2.3 with Tomcat 5.5 bundle.

Which folders should I delete from tomcat-5.5.27\webapps ?

There is a ROOT Folder and tunnel-web folder.

Regards

Deepak

Babu Janarthanan:

How do I remove sevencogs-hook, sevencogs-theme and wol-portlet ?

you can delete it from the webapps folder of your server....
localtion:
tomcat-6.0.18\webapps\
you can find those folder

Also how do Install Mysql ?

you can install using mysql installer. you can visit mysql site for more information.

hope it helps you.

Thx,
Babu

[Deepak Bhatia，修改在14 年前。]

Hi Thanks,

I have created a new database and update protal-ext.properties

mail.session.mail.smtp.host=10.0.0.6
mail.session.mail.smtp.port=587
mail.session.mail.transport.protocol=smtp
jdbc.default.driverClassName=com.mysql.jdbc.Driver
jdbc.default.url=jdbc:mysql://localhost/lportal?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false
jdbc.default.username=root
jdbc.default.password=password
schema.run.minimal=true

So I think I need not remove seven-cogs application. But let me know the better method that I remove seven-cogs as well.

Regards

Deepak

[Babu Janarthanan，修改在14 年前。]

Hi,
you can take a look at this Link for removing seven cogs themes.

hope it helps you.

Thx,
Babu