Foros de discusión
Mysql database population commands
Ishan Sahore, modificado hace 11 años.
Mysql database population commands
Junior Member Mensajes: 56 Fecha de incorporación: 26/04/12 Mensajes recientes
Hi all,
I want to know where are all the sql commands(queries) stored in liferay when we configure it for using MySQL by which default tables and data get populated into the database 'lportal'. I want to make it able to store web content in Multiple languages ,e.g. hindi. For this I need to modify the database and table creation commands in it.
Any help is appreciated.
Thanks,
Ishan Sahore
I want to know where are all the sql commands(queries) stored in liferay when we configure it for using MySQL by which default tables and data get populated into the database 'lportal'. I want to make it able to store web content in Multiple languages ,e.g. hindi. For this I need to modify the database and table creation commands in it.
Any help is appreciated.
Thanks,
Ishan Sahore
Debasis Padhi, modificado hace 11 años.
RE: Mysql database population commands
Junior Member Mensajes: 54 Fecha de incorporación: 23/03/12 Mensajes recientes
Configure the data base details In side /tomcat-7.0.23/webapps/ROOT/WEB-INF/classes/ portal-ext.properties
If you want to prepare a portlet for language then You can use the existing Language portlet
By Hook you can also customize this
If you want to prepare a portlet for language then You can use the existing Language portlet
By Hook you can also customize this
Jignesh Vachhani, modificado hace 11 años.
RE: Mysql database population commands
Liferay Master Mensajes: 803 Fecha de incorporación: 10/03/08 Mensajes recientes
Hi Ishan,
I am not sure from where exact it's getting populated.But you can find sql folder in portal source.
And there we will have 2 .sql files portal-tables.sql and portal-data-common.sql exist which could be included in some dependency jar i think.
I am not sure which jar its referring.
I am not sure from where exact it's getting populated.But you can find sql folder in portal source.
And there we will have 2 .sql files portal-tables.sql and portal-data-common.sql exist which could be included in some dependency jar i think.
I am not sure which jar its referring.
Priyanka Dhingra, modificado hace 11 años.
RE: Mysql database population commands
Liferay Master Mensajes: 501 Fecha de incorporación: 20/12/11 Mensajes recientes
hi,
check this
Creating the database and tables #
http://www.liferay.com/community/wiki/-/wiki/Main/Database+Configuration
check this
Creating the database and tables #
You will first need to create the database, make sure that this matches the value in the url of your ROOT.xml.
For most versions of Liferay, you will have 2 sets of sql scripts, one which will create the Liferay tables with sample data (the Liferay public website) or with just the bare minimal data. You can find both sets of scripts in the portal code:
portal\sql\portal\portal-mysql.sql
and
portal\sql\portal-minimal\portal-minimal-mysql.sql
If you..
dont have the portal source code,
you can download all the scripts online here: http://www.liferay.com/web/guest/downloads/additional or http://sourceforge.net/projects/lportal and download the portal SQL scripts.
dont see the scripts in source,
you will have to run "ant start" from your portal source folder which will generate the appropriate files.
http://www.liferay.com/community/wiki/-/wiki/Main/Database+Configuration
Wieteke den Uijl, modificado hace 11 años.
RE: Mysql database population commands
Junior Member Mensajes: 56 Fecha de incorporación: 19/04/11 Mensajes recientes
Hi Ishan,
Any chance you can move these forum conversations to another part of the Liferay Forum. You're currently posting in the Dutch forum about the Dutch Liferay Community and although your questions are interesting they have very little to do with the Netherlands or the Liferay community there. Thanks!
Regards,
Wieteke
Any chance you can move these forum conversations to another part of the Liferay Forum. You're currently posting in the Dutch forum about the Dutch Liferay Community and although your questions are interesting they have very little to do with the Netherlands or the Liferay community there. Thanks!
Regards,
Wieteke