I'm trying to get Liferay 5.2.1 installed on a fresh jetty 5.1.1 instance and I can't figure out how to configure liferay to use MySQL either...
I've followed (what I think are) the latest instructions in the liferay-admin-guide and on context startup, the liferay war still tries to connect to a HSQL source.
I created the database as described in the instructions by running the create-minimal.sql script such that my "lportal" database now contains these tables:
1
2mysql> show tables;
3+--------------------------------+
4| Tables_in_lportal |
5+--------------------------------+
6| Account_ |
7| Address |
8| AnnouncementsDelivery |
9| AnnouncementsEntry |
10....
11| WikiNode |
12| WikiPage |
13| WikiPageResource |
14+--------------------------------+
15140 rows in set (0.00 sec)
My jetty.xml includes this new service block, and that's all I could find in the documentation about what needed to be done. Is there anything else? Some config file somewhere that tells Liferay to use MySql?
1 2 <Call name="addService">
3 <Arg>
4 <New class="org.mortbay.jetty.plus.JotmService">
5 <Set name="Name">TransactionMgr</Set>
6 <Call name="addDataSource">
7 <Arg>jdbc/LiferayPool</Arg>
8 <Arg>
9 <New class="org.enhydra.jdbc.standard.StandardXADataSource">
10 <Set name="DriverName">com.mysql.jdbc.Driver</Set>
11 <Set name="Url">jdbc:mysql://localhost/lportal?useUnicode=true&characterEncoding=UTF-8</Set>
12 <Set name="User">root</Set>
13 <Set name="Password">xxx</Set>
14 </New>
15 </Arg>
16 <Arg>
17 <New class="org.enhydra.jdbc.pool.StandardXAPoolDataSource">
18 <Arg type="Integer">4</Arg>
19 <Set name="MinSize">4</Set>
20 <Set name="MaxSize">15</Set>
21 </New>
22 </Arg>
23 </Call>
24 </New>
25 </Arg>
26 </Call>
On startup, there's this block that makes me suspect I'm not using HSQL:
1
2SLF4J: This version of SLF4J requires log4j version 1.2.12 or later. See also http://www.slf4j.org/codes.html#log4j_version
3
411020 [main] INFO com.liferay.portal.spring.hibernate.DialectDetector - Determining dialect for HSQL Database Engine 1
511021 [main] WARN com.liferay.portal.spring.hibernate.DialectDetector - Liferay is configured to use Hypersonic as its database. Do NOT use Hypersonic in production. Hypersonic is an embedded database useful for development and demo'ing purposes. The database settings can be changed in portal.properties.
611161 [main] INFO com.liferay.portal.spring.hibernate.DialectDetector - Using dialect org.hibernate.dialect.HSQLDialect
7Loading jar:file:/opt/liferay/jetty-5.1.1/webapps/root/WEB-INF/lib/portal-impl.jar!/captcha.properties
Answer