17 psql_create_tables.sql and psql_default_data.sql. |
17 psql_create_tables.sql and psql_default_data.sql. |
18 |
18 |
19 3. Configure a data source in your application servlet or servlet container |
19 3. Configure a data source in your application servlet or servlet container |
20 |
20 |
21 You may use absolutely anything: Tomcat, TomEE, Glassfish, Payara, you name it. |
21 You may use absolutely anything: Tomcat, TomEE, Glassfish, Payara, you name it. |
|
22 If it supports Servlet 6.0, JSP 3.1, and EL 5.0, you are good to go. |
22 Just make sure to configure a data source with the name jdbc/lightpit/app. |
23 Just make sure to configure a data source with the name jdbc/lightpit/app. |
23 If you want another name, you can configure the JNDI resource in the |
24 If you want another name, you can configure the JNDI resource in the |
24 WEB-INF/web.xml and META-INF/context.xml files. It is highly recommended to use |
25 WEB-INF/web.xml and META-INF/context.xml files. It is highly recommended to use |
25 the lightpit_app user which has less privileges to create the data source and |
26 the lightpit_app user which has less privileges to create the data source and |
26 leave the lightpit_dbo user for the database operator. |
27 leave the lightpit_dbo user for the database operator. |
27 |
28 |
28 4. Make sure JDBC driver and JSTL libraries are available |
29 4. Deploy the WAR file of lightpit |
29 |
|
30 This step may be optional depending on the container you are using. Most |
|
31 application servers already have JSTL libraries installed. More basic servlet |
|
32 containers like Tomcat don't. In that case you have to put the libraries of the |
|
33 javax.servlet:jstl:1.2 artifact manually into the library dir of your servlet |
|
34 container (jstl-1.2.jar and jstl-impl-1.2.jar). |
|
35 |
|
36 In most cases you also have to put the postgresql JDBC driver into the library |
|
37 directory of your server (e.g. postgres-42.x.x.jar). |
|
38 |
|
39 5. Deploy the WAR file of lightpit |
|
40 |
30 |
41 This is the most straight forward step. Just deploy the WAR file as you usually |
31 This is the most straight forward step. Just deploy the WAR file as you usually |
42 do in your application server. |
32 do in your application server. |
43 |
33 |
44 6. Configuring a web server and authentication |
34 5. Configuring a web server and authentication |
45 |
35 |
46 LightPIT can optionally detect the authenticated user. You may freely decide |
36 LightPIT can optionally detect the authenticated user. You may freely decide |
47 whether to enable authentication in your application server or put a web server |
37 whether to enable authentication in your application server or put a web server |
48 in front. The latter is recommended, but keep in might that forwarding the |
38 in front. The latter is recommended, but keep in might that forwarding the |
49 authentication information may only work with AJP for certain servlet |
39 authentication information may only work with AJP for certain servlet |