Data base configuration...

[Raja Sekhar Kanugula, modificado hace 15 años.]

HI...

I am new to the liferay.I downloaded the liferay-portal-jboss-tomcat-4.2-5.1.2 war file.
I am running this applicaition using run.bat file(with out any changes or configurations.).
Can any one tell me where can i change the data base configuration.
Please any one tell me the source/link where I will get the more information about Technical details etc.

-Raj

[James Min, modificado hace 15 años.]

/jboss42/server/default/deploy/liferay-ds.xml

Liferay Admin Guide:

http://www.liferay.com/web/guest/community/documentation/5_1

[Raja Sekhar Kanugula, modificado hace 15 años.]

Hi james,

I copied /docs/examples/jca/mysql-ds.xml to the /server/default/deploy directory and cahaged the file as below.
Is this correct DB configuration?
can you help me .
Thanks in advance.
-raj

<datasources>
<local-tx-datasource>
<jndi-name>MySqlDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/lportal</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
<password>sa</password>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
<metadata>
<type-mapping>mySQL</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>

[James Min, modificado hace 15 años.]

If you downloaded the jboss-tomcat bundle there should be a liferay-ds.xml file there already.

Here is what my liferay-ds.xml looks like for local MySQL:

<?xml version="1.0"?>



<datasources>

<local-tx-datasource>

<jndi-name>jdbc/LiferayPool</jndi-name>

<connection-url>
jdbc:mysql://localhost/lportal
</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
<password>asdf</password>

<min-pool-size>5</min-pool-size>

</local-tx-datasource>

</datasources>


Yours should be similar but of course you may have a different username and password.

[Raja Sekhar Kanugula, modificado hace 15 años.]

Hi James,
I tried the database configuration as you mentioned(modifying the liferay-ds.xml).
Then only it creates the tables with Test data.
Thanks a lot.

[nek konstantopoulos, modificado hace 15 años.]

Hi Sekhar

if you want to use MySql the 1st thing you have to do is to download the sql scripts.
Then you must create a database with name lportal and then execute the script (for my sql) .
The script its create for you all the necessary tables

Then you must configure the liferay-ds.xml as James describe to you..