Attachment #205587 for bug #238430

View | Details | Raw Unified | Return to bug 238430
Collapse All | Expand All




# $FreeBSD$

PORTNAME=	openemm2015
PORTVERSION=	0.1
CATEGORIES=	mail java www
MASTER_SITES=	SF/openemm/OpenEMM%20software/OpenEMM%202015/ \
		http://central.maven.org/maven2/com/lowagie/itext/2.1.7/:MAVEN2

LICENSE=	CPAL-1.0
LICENSE_FILE=	${WRKSRC}/other/LICENSE.txt

BROKEN=	depends on expired www/tomcat8
BROKEN_powerpc64=	fails to build: gmake[1]: clang: Command not found

LIB_DEPENDS=	libslang.so:devel/libslang2 \
		libsa.so:net/ossp-sa
BUILD_DEPENDS=	${TOMCATHOME}/bin/bootstrap.jar:www/tomcat85 \
		${ANT_CMD}:devel/apache-ant
RUN_DEPENDS=	${TOMCATHOME}/bin/bootstrap.jar:www/tomcat85 \
		py27-MySQLdb>=1.2.3:databases/py-MySQLdb

USES=	dos2unix gmake python:2.7,run

CC=	clang
CXX=	clang++

TOMCATVER=	apache-tomcat-8.5
TOMCATDIR=	${PREFIX}/${TOMCATVER}
TOMCATHOME=	${LOCALBASE}/${TOMCATVER}
#WEBAPPDIR=	${TOMCATDIR}/webapps


	# create log files
	${MKDIR} ${STAGEDIR}/var/log/${PORTNAME}
	${TOUCH} ${STAGEDIR}/var/log/${PORTNAME}/openemm.log
	${TOUCH} ${STAGEDIR}/var/log/${PORTNAME}/openemm-ws.log
	${TOUCH} ${STAGEDIR}/var/log/${PORTNAME}/openemm_core.log
	${TOUCH} ${STAGEDIR}/var/log/${PORTNAME}/userlogs.log
	${TOUCH} ${STAGEDIR}/var/log/${PORTNAME}/openemm_axis.log





To integrate the OpenEMM 2015 to the installed Tomcat add this
chunk to the server.xml of Tomcat:
TOMCAT_HOME= %%PREFIX%%/apache-tomcat-8.5/lib/

vi TOMCAT_HOME/conf/server.xml


	<!-- add this part END -->
   </Engine>

Change the Engine name="Catalina" to point to defaultHost="OpenEMM"
Don't forget securing tomcat, or add a httpd in front secured

additional for the jndi database connect:

        ....
        <Resource
                name="jdbc/openemm_db"
                driverClassName="com.mysql.cj.jdbc.Driver"
                type="javax.sql.DataSource"
                maxTotal="30"
                maxActive="50"
                maxWait="10000"
                auth="Container"
                username="agnitas"
                password="openemm"
                url="jdbc:mysql://localhost/openemm?useUnicode=yes&amp;characterEncoding=UTF-8&amp;useOldAliasMetadataBehavior=true&amp;zeroDateTimeBehavior=convertToNull"
=convertToNull"
        />

        <Resource
                name="jdbc/openemm_cms_db"
                driverClassName="com.mysql.cj.jdbc.Driver"
                type="javax.sql.DataSource"
                maxTotal="30"
                maxActive="50"
                maxWait="10000"
                auth="Container"
                username="agnitas"
                password="openemm"
                url="jdbc:mysql://localhost/openemm_cms?useUnicode=yes&amp;characterEncoding=UTF-8&amp;useOldAliasMetadataBehavior=true&amp;zeroDateTimeBehavior=convertToNull
vior=convertToNull"
        />
</Context>


# to keep this change permanent change cron info in /etc/newsyslog.conf
# change line /var/log/maillog                      644  7     *    @T00  JC

#if not change tracking of mail sending / bounces is not working correct

# don't forget to add the link for mysql driver jar to tomcat
# if not already installed add:  pkg install mysql-connector-java
ln -s %%PREFIX%%/share/java/classes/mysql-connector-java.jar TOMCAT_HOME/lib
chown -h www TOMCAT_HOME/lib/mysql-connector-java.jar

# setup the database scripts
#in the installed mysql add 2 databases

in the installed mysql add 2 databases

create database openemm;
create database openemm_cms;

#grant the privileges for the 2 db's from where you want to access
grant all privileges on openemm.* to agnitas@'X.Y.%' identified by 'openemm';
grant all privileges on openemm_cms.* to agnitas@'X.Y.%' identified by 'openemm';



# startup config for tomcat and OpenEMM
add to /etc/rc.conf
# Tomcat85 Server startup with initial config params for OpenEMM
tomcat85_enable="YES"
tomcat85_java_opts="-server -Djava.awt.headless=true -Xms256m -Xmx512m -Xss256k"

# Openemm 2015
openemm2015_enable="YES"


#NOW you are ready to start the tomcat and OpenEMM

service tomcat85 start
service openemm2015 start
or
%%PREFIX%%/etc/rc.d/openemm2015 start

Lines 6023-6032 Link Here

(-)pkg-plist (+9 lines)
6023	%%PORTDOCS%%%%DOCSDIR%%/update_openemm-6.RC2-6.0.sql	6023	%%PORTDOCS%%%%DOCSDIR%%/update_openemm-6.RC2-6.0.sql
6024	@mode 555	6024	@mode 555
6025	%%PORTDOCS%%%%DOCSDIR%%/upgrade-postproc.sh	6025	%%PORTDOCS%%%%DOCSDIR%%/upgrade-postproc.sh
		6026	@mode 755
6026	@(www,www,) /var/log/%%APP_HOME%%/daily.log	6027	@(www,www,) /var/log/%%APP_HOME%%/daily.log
		6028	@mode 755
		6029	@(www,www,) /var/log/%%APP_HOME%%/openemm.log
		6030	@mode 755
		6031	@(www,www,) /var/log/%%APP_HOME%%/openemm-ws.log
		6032	@mode 755
6027	@(www,www,) /var/log/%%APP_HOME%%/openemm_axis.log	6033	@(www,www,) /var/log/%%APP_HOME%%/openemm_axis.log
		6034	@mode 755
6028	@(www,www,) /var/log/%%APP_HOME%%/openemm_core.log	6035	@(www,www,) /var/log/%%APP_HOME%%/openemm_core.log
		6036	@mode 755
6029	@(www,www,) /var/log/%%APP_HOME%%/userlogs.log	6037	@(www,www,) /var/log/%%APP_HOME%%/userlogs.log
		6038	@mode 755
6030	@dir(www,www,) /var/log/%%APP_HOME%%	6039	@dir(www,www,) /var/log/%%APP_HOME%%
6031	@dir %%DOCSDIR%%/ThirdPartyLicences	6040	@dir %%DOCSDIR%%/ThirdPartyLicences
6032	@dir %%DOCSDIR%%	6041	@dir %%DOCSDIR%%

Return to bug 238430

Lines 2-8 Link Here

(-)Makefile (-5 / +6 lines)
2	# $FreeBSD$	2	# $FreeBSD$
3		3
4	PORTNAME= openemm2015	4	PORTNAME= openemm2015
5	PORTVERSION= 0	5	PORTVERSION= 0.1
6	CATEGORIES= mail java www	6	CATEGORIES= mail java www
7	MASTER_SITES= SF/openemm/OpenEMM%20software/OpenEMM%202015/ \	7	MASTER_SITES= SF/openemm/OpenEMM%20software/OpenEMM%202015/ \
8	http://central.maven.org/maven2/com/lowagie/itext/2.1.7/:MAVEN2	8	http://central.maven.org/maven2/com/lowagie/itext/2.1.7/:MAVEN2
Lines 16-29 Link Here
16	LICENSE= CPAL-1.0	16	LICENSE= CPAL-1.0
17	LICENSE_FILE= ${WRKSRC}/other/LICENSE.txt	17	LICENSE_FILE= ${WRKSRC}/other/LICENSE.txt
18		18
19	BROKEN= depends on expired www/tomcat8
20	BROKEN_powerpc64= fails to build: gmake[1]: clang: Command not found	19	BROKEN_powerpc64= fails to build: gmake[1]: clang: Command not found
21		20
22	LIB_DEPENDS= libslang.so:devel/libslang2 \	21	LIB_DEPENDS= libslang.so:devel/libslang2 \
23	libsa.so:net/ossp-sa	22	libsa.so:net/ossp-sa
24	#BUILD_DEPENDS= ${TOMCATHOME}/bin/bootstrap.jar:www/tomcat8 \	23	BUILD_DEPENDS= ${TOMCATHOME}/bin/bootstrap.jar:www/tomcat85 \
25	${ANT_CMD}:devel/apache-ant	24	${ANT_CMD}:devel/apache-ant
26	#RUN_DEPENDS= ${TOMCATHOME}/bin/bootstrap.jar:www/tomcat8 \	25	RUN_DEPENDS= ${TOMCATHOME}/bin/bootstrap.jar:www/tomcat85 \
27	py27-MySQLdb>=1.2.3:databases/py-MySQLdb	26	py27-MySQLdb>=1.2.3:databases/py-MySQLdb
28		27
29	USES= dos2unix gmake python:2.7,run	28	USES= dos2unix gmake python:2.7,run
Lines 35-41 Link Here
35	CC= clang	34	CC= clang
36	CXX= clang++	35	CXX= clang++
37		36
38	TOMCATVER= apache-tomcat-8.0	37	TOMCATVER= apache-tomcat-8.5
39	TOMCATDIR= ${PREFIX}/${TOMCATVER}	38	TOMCATDIR= ${PREFIX}/${TOMCATVER}
40	TOMCATHOME= ${LOCALBASE}/${TOMCATVER}	39	TOMCATHOME= ${LOCALBASE}/${TOMCATVER}
41	#WEBAPPDIR= ${TOMCATDIR}/webapps	40	#WEBAPPDIR= ${TOMCATDIR}/webapps
Lines 228-233 Link Here
228		227
229	# create log files	228	# create log files
230	${MKDIR} ${STAGEDIR}/var/log/${PORTNAME}	229	${MKDIR} ${STAGEDIR}/var/log/${PORTNAME}
		230	${TOUCH} ${STAGEDIR}/var/log/${PORTNAME}/openemm.log
		231	${TOUCH} ${STAGEDIR}/var/log/${PORTNAME}/openemm-ws.log
231	${TOUCH} ${STAGEDIR}/var/log/${PORTNAME}/openemm_core.log	232	${TOUCH} ${STAGEDIR}/var/log/${PORTNAME}/openemm_core.log
232	${TOUCH} ${STAGEDIR}/var/log/${PORTNAME}/userlogs.log	233	${TOUCH} ${STAGEDIR}/var/log/${PORTNAME}/userlogs.log
233	${TOUCH} ${STAGEDIR}/var/log/${PORTNAME}/openemm_axis.log	234	${TOUCH} ${STAGEDIR}/var/log/${PORTNAME}/openemm_axis.log

Lines 6-12 Link Here

(-)files/pkg-message.in (-21 / +16 lines)
6		6
7	To integrate the OpenEMM 2015 to the installed Tomcat add this	7	To integrate the OpenEMM 2015 to the installed Tomcat add this
8	chunk to the server.xml of Tomcat:	8	chunk to the server.xml of Tomcat:
9	TOMCAT_HOME= %%PREFIX%%/apache-tomcat-8.0/lib/	9	TOMCAT_HOME= %%PREFIX%%/apache-tomcat-8.5/lib/
10		10
11	vi TOMCAT_HOME/conf/server.xml	11	vi TOMCAT_HOME/conf/server.xml
12		12
Lines 28-33 Link Here
28	<!-- add this part END -->	28	<!-- add this part END -->
29	</Engine>	29	</Engine>
30		30
		31	Change the Engine name="Catalina" to point to defaultHost="OpenEMM"
31	Don't forget securing tomcat, or add a httpd in front secured	32	Don't forget securing tomcat, or add a httpd in front secured
32		33
33	additional for the jndi database connect:	34	additional for the jndi database connect:
Lines 38-67 Link Here
38	....	39	....
39	<Resource	40	<Resource
40	name="jdbc/openemm_db"	41	name="jdbc/openemm_db"
41	driverClassName="com.mysql.jdbc.Driver"	42	driverClassName="com.mysql.cj.jdbc.Driver"
42	type="javax.sql.DataSource"	43	type="javax.sql.DataSource"
43	maxCount="30"	44	maxTotal="30"
44	maxActive="50"
45	maxWait="10000"
46	auth="Container"	45	auth="Container"
47	username="agnitas"	46	username="agnitas"
48	password="openemm"	47	password="openemm"
49	url="jdbc:mysql://localhost/openemm?useUnicode=yes&characterEncoding=UTF-8&useOldAliasMetadataBehavior=true&zeroDateTimeBehavior	48	url="jdbc:mysql://localhost/openemm?useUnicode=yes&characterEncoding=UTF-8&useOldAliasMetadataBehavior=true&zeroDateTimeBehavior=convertToNull"
50	=convertToNull"
51	/>	49	/>
52		50
53	<Resource	51	<Resource
54	name="jdbc/openemm_cms_db"	52	name="jdbc/openemm_cms_db"
55	driverClassName="com.mysql.jdbc.Driver"	53	driverClassName="com.mysql.cj.jdbc.Driver"
56	type="javax.sql.DataSource"	54	type="javax.sql.DataSource"
57	maxCount="30"	55	maxTotal="30"
58	maxActive="50"
59	maxWait="10000"
60	auth="Container"	56	auth="Container"
61	username="agnitas"	57	username="agnitas"
62	password="openemm"	58	password="openemm"
63	url="jdbc:mysql://localhost/openemm_cms?useUnicode=yes&characterEncoding=UTF-8&useOldAliasMetadataBehavior=true&zeroDateTimeBeha	59	url="jdbc:mysql://localhost/openemm_cms?useUnicode=yes&characterEncoding=UTF-8&useOldAliasMetadataBehavior=true&zeroDateTimeBehavior=convertToNull
64	vior=convertToNull"
65	/>	60	/>
66	</Context>	61	</Context>
67		62
Lines 81-100 Link Here
81	# to keep this change permanent change cron info in /etc/newsyslog.conf	76	# to keep this change permanent change cron info in /etc/newsyslog.conf
82	# change line /var/log/maillog 644 7 * @T00 JC	77	# change line /var/log/maillog 644 7 * @T00 JC
83		78
84	if not change tracking of mail sending / bounces is not working correct	79	#if not change tracking of mail sending / bounces is not working correct
85		80
86	# don't forget to add the link for mysql driver jar to tomcat	81	# don't forget to add the link for mysql driver jar to tomcat
		82	# if not already installed add: pkg install mysql-connector-java
87	ln -s %%PREFIX%%/share/java/classes/mysql-connector-java.jar TOMCAT_HOME/lib	83	ln -s %%PREFIX%%/share/java/classes/mysql-connector-java.jar TOMCAT_HOME/lib
88	chown -h www TOMCAT_HOME/lib/mysql-connector-java.jar	84	chown -h www TOMCAT_HOME/lib/mysql-connector-java.jar
89		85
90	# setup the database scripts	86	# setup the database scripts
		87	#in the installed mysql add 2 databases
91		88
92	in the installed mysql add 2 databases
93
94	create database openemm;	89	create database openemm;
95	create database openemm_cms;	90	create database openemm_cms;
96		91
97	grant the privileges for the 2 db's from where you want to access	92	#grant the privileges for the 2 db's from where you want to access
98	grant all privileges on openemm.* to agnitas@'X.Y.%' identified by 'openemm';	93	grant all privileges on openemm.* to agnitas@'X.Y.%' identified by 'openemm';
99	grant all privileges on openemm_cms.* to agnitas@'X.Y.%' identified by 'openemm';	94	grant all privileges on openemm_cms.* to agnitas@'X.Y.%' identified by 'openemm';
100		95
Lines 111-119 Link Here
111		106
112	# startup config for tomcat and OpenEMM	107	# startup config for tomcat and OpenEMM
113	add to /etc/rc.conf	108	add to /etc/rc.conf
114	# Tomcat8 Server startup with initial config params for OpenEMM	109	# Tomcat85 Server startup with initial config params for OpenEMM
115	tomcat8_enable="YES"	110	tomcat85_enable="YES"
116	tomcat8_java_opts="-server -Djava.awt.headless=true -Xms256m -Xmx512m -XX:MaxPermSize=256m -Xss256k"	111	tomcat85_java_opts="-server -Djava.awt.headless=true -Xms256m -Xmx512m -Xss256k"
117		112
118	# Openemm 2015	113	# Openemm 2015
119	openemm2015_enable="YES"	114	openemm2015_enable="YES"
Lines 120-126 Link Here
120		115
121	#NOW you are ready to start the tomcat and OpenEMM	116	#NOW you are ready to start the tomcat and OpenEMM
122		117
123	service tomcat8 start	118	service tomcat85 start
124	service openemm2015 start	119	service openemm2015 start
125	or	120	or
126	%%PREFIX%%/etc/rc.d/openemm2015 start	121	%%PREFIX%%/etc/rc.d/openemm2015 start