I dont know, maybe you are correct. Have you ever tried updating your axelor version from 5.0 to 5.1?
Yes but it was too difficult, I just add my personalisations in 5.1 manually and I installed it on a new database
this is my application.properties from:
C:\Program Files\Apache Software Foundation\Tomcat 8.5\webapps\ROOT_\WEB-INF\classes\application.properties
################################################################################
Application Configuration
################################################################################
Database settings Original
~~~~~
#db.default.driver = org.postgresql.Driver
#db.default.ddl = update
#db.default.url = jdbc:postgresql://localhost:5432/axelor-business-suite
#db.default.user = axelor
#db.default.password = *****
Database settings Original
~~~~~
db.default.driver = org.postgresql.Driver
db.default.ddl = update
db.default.url = jdbc:postgresql://localhost:5432/axelor
db.default.user = axelor
db.default.password = axelor
Application Information
~~~~~
application.name = Axelor Business Suite
application.description = Axelor Entreprise Application
application.version = 5.1.0
application.author = Axelor
link to be used with header logo
application.home = http://www.axelor.com
application header logo, should be 40px in height
~~~~~
application.logo = img/axelor.png
Set default language
application.locale = fr
Set default CSS theme, for example blue
application.theme = theme-default
Application Mode
~~~~~
Set to ‘dev’ for development mode else ‘prod’
application.mode = dev
Date Format
~~~~~
date.format = dd/MM/yyyy
Timezone
~~~~~
date.timezone = UTC
Menu
~~~~~
Set menu style (left, top, both)
application.menu = both
View options
~~~~~
application.view.toolbar-title = hide
Link to the online help
~~~~~
application.help = http://wiki.axelor.fr/confluence/display/AxelorERP
Application time out in minutes
~~~~~
session.timeout = 480
Data export (csv) encoding
~~~~
Use Windows-1252, ISO-8859-1 or ISO-8859-15 if targeting ms excel
(excel does not recognize utf8 encoded csv)
data.export.encoding = ISO-8859-15
Encrypted fields
~~~~
Old encryption password for migration
#encryption.password.old = *****
Encryption password
ENSURE THAT YOU DON’T LOSE IT.
If you lose this password, you will be unable to access variables stored in database.
encryption.password = MySuperSecretKey
Algorithm mode (CBC or GCM)
encryption.algorithm = CBC
User password pattern
~~~~
at least 8 characters with at least three of these four types: lowercase, uppercase, digit, special
user.password.pattern = (((?=.[a-z])(?=.[A-Z])(?=.\d))|((?=.[a-z])(?=.[A-Z])(?=.\W))|((?=.[a-z])(?=.\d)(?=.\W))|((?=.[A-Z])(?=.\d)(?=.\W))).{8,}
Storage path for export action
~~~~~
data.export.dir = {java.io.tmpdir}/axelor
Storage path for upload files (attachments)
~~~~~
use {user.home} key to save files under user home directory, or
use absolute path where server user have write permission.
file.upload.dir = {java.io.tmpdir}/axelor
Maximum upload size (in MB)
~~~~~
file.upload.size = 5
Indicate if the birt engine to use is the embedded engine or external engine
Default : true
~~~~~
axelor.report.use.embedded.engine =
Link to report enginePath (external engine)
Example : http://localhost:8080/birt
Default : {webapps server}/birt
~~~~~
axelor.report.engine =
Reports resource path (external engine)
Default : report
~~~~~
axelor.report.resource.path =
Enable/disable demo data
~~~~~
data.import.demo-data = false
Custom context values
~~~~~
context.app = com.axelor.apps.base.service.app.AppService
context.appLogo = com.axelor.apps.base.service.user.UserService:getUserActiveCompanyLogo
Hibernate full-text search
~~~~~
hibernate.search.default.directory_provider = none
hibernate.search.default.indexBase = {java.io.tmpdir}/axelor
HikariCP connection pool
~~~~~
hibernate.hikari.minimumIdle = 5
hibernate.hikari.maximumPoolSize = 20
hibernate.hikari.idleTimeout = 300000
CORS configuration to allow cross origin requests
~~~~~
regular expression to test allowed origin or * to allow all (not recommended)
#cors.allow.origin = *
#cors.allow.credentials = true
#cors.allow.methods = GET,PUT,POST,DELETE,HEAD,OPTIONS
#cors.allow.headers = Origin,Accept,X-Requested-With,Content-Type,Access-Control-Request-Method,Access-Control-Request-Headers
Logging
~~~~~
Custom logback configuration can be provided with logging.config
property pointing
to a custom logback.xml
. In this case, all the logging configuration provided here
will be ignored.
Following settings can be used to configure logging system automatically.
#logging.path = {user.home}/.axelor/logs
#logging.pattern.file = %d{yyyy-MM-dd HH:mm:ss.SSS} %5p ${PID:- } — [%t] %-40.40logger{39} : %m%n
#logging.pattern.console = %clr(%d{yyyy-MM-dd HH:mm:ss.SSS}){faint} %clr(%5p) %clr(${PID:- }){magenta} %clr(—){faint} %clr([%15.15t]){faint} %clr(%-40.40logger{39}){cyan} %clr(:){faint} %m%n
logging.level.root = ERROR
logging.level.com.axelor = DEBUG
Log everything. Good for troubleshooting
#logging.level.org.hibernate = INFO
Log all SQL DML statements as they are executed
#logging.level.org.hibernate.SQL = DEBUG
#logging.level.org.hibernate.engine.jdbc = DEBUG
Log all SQL DDL statements as they are executed
#logging.level.org.hibernate.tool.hbm2ddl = INFO
Log all JDBC parameters
#logging.level.org.hibernate.type = ALL
Log transactions
#logging.level.org.hibernate.transaction = DEBUG
Log L2-Cache
#logging.level.org.hibernate.cache = DEBUG
Log JDBC resource acquisition
#logging.level.org.hibernate.jdbc = TRACE
#logging.level.org.hibernate.service.jdbc = TRACE
Log connection pooling
#logging.level.com.zaxxer.hikari = INFO
Quartz scheduler
~~~~~
#quartz.enable = true
#quartz.threadCount = 5
Allows to open maximum 10 Tabs
view.tabs.max = 10
try to name your folder “axelor” and to type localhost:8080/axelor
it’s just to have clear log file and to avoid any conflict.
The naming rule of the war as “root.war” is absolutely not mandatory, it’s just a proposal to be able to have a context as “/” .
Hi,
From my point of view the better way is to create a manual install which is more easy:
- download the lastest tomcat version http://apache.mediamirrors.org/tomcat/tomcat-9/v9.0.14/bin/apache-tomcat-9.0.14.zip
- unzip the file (you will have now a folder named apache-tomcat-9.0.14);
- before creating the war (gradlew --no-daemon -x test war) edit the application.properties file that you could find inside the src/main/ressources of the abs-webapp source dir;
- put the generated war (axelor-erp-5.1.0.war) inside the webapps folder
- using a cmd: CD to the apache-tomcat-9.0.14/bin folder and enter “startup”.
- When the server is fully started should see […Server startup…] message) try to access localhost:8080/axelor-erp-5.1.0
It should work
Hi,
i’ve follow your instruction, but still got error like this
here’s the catalina:
09-Jan-2019 18:48:21.887 INFO [main] org.apache.catalina.startup.Catalina.load Server initialization in [1,705] milliseconds
09-Jan-2019 18:48:21.934 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
09-Jan-2019 18:48:21.934 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet engine: [Apache Tomcat/9.0.14]
09-Jan-2019 18:48:21.950 INFO [main] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive [C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\axelor-erp-5.1.0.war]
09-Jan-2019 18:49:03.631 INFO [main] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
09-Jan-2019 18:51:49.549 SEVERE [main] org.apache.catalina.startup.HostConfig.deployWARs Error waiting for multi-thread deployment of WAR files to complete
java.util.concurrent.ExecutionException: java.lang.OutOfMemoryError: Java heap space
at java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.util.concurrent.FutureTask.get(FutureTask.java:192)
at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:779)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:427)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1577)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:309)
at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:123)
at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:424)
at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:367)
at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:934)
at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:831)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1382)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1372)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:134)
at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:907)
at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
at org.apache.catalina.core.StandardService.startInternal(StandardService.java:423)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:933)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
at org.apache.catalina.startup.Catalina.start(Catalina.java:637)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:350)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:492)
Caused by: java.lang.OutOfMemoryError: Java heap space
at java.util.Arrays.copyOf(Arrays.java:3332)
at java.lang.AbstractStringBuilder.ensureCapacityInternal(AbstractStringBuilder.java:124)
at java.lang.AbstractStringBuilder.append(AbstractStringBuilder.java:448)
at java.lang.StringBuilder.append(StringBuilder.java:136)
at org.hibernate.loader.JoinWalker.selectString(JoinWalker.java:1116)
at org.hibernate.loader.AbstractEntityJoinWalker.initStatementString(AbstractEntityJoinWalker.java:108)
at org.hibernate.loader.AbstractEntityJoinWalker.initStatementString(AbstractEntityJoinWalker.java:89)
at org.hibernate.loader.AbstractEntityJoinWalker.initAll(AbstractEntityJoinWalker.java:71)
at org.hibernate.loader.AbstractEntityJoinWalker.initAll(AbstractEntityJoinWalker.java:58)
at org.hibernate.loader.entity.CascadeEntityJoinWalker.(CascadeEntityJoinWalker.java:37)
at org.hibernate.loader.entity.CascadeEntityLoader.(CascadeEntityLoader.java:28)
at org.hibernate.persister.entity.AbstractEntityPersister.createLoaders(AbstractEntityPersister.java:4039)
at org.hibernate.persister.entity.AbstractEntityPersister.postInstantiate(AbstractEntityPersister.java:3964)
at org.hibernate.metamodel.internal.MetamodelImpl.initialize(MetamodelImpl.java:203)
at org.hibernate.internal.SessionFactoryImpl.(SessionFactoryImpl.java:297)
at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:452)
at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:889)
at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:58)
at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:55)
at com.google.inject.persist.jpa.JpaPersistService.start(JpaPersistService.java:108)
at com.google.inject.persist.PersistFilter.init(PersistFilter.java:79)
at com.google.inject.servlet.FilterDefinition.init(FilterDefinition.java:111)
at com.google.inject.servlet.ManagedFilterPipeline.initPipeline(ManagedFilterPipeline.java:99)
at com.google.inject.servlet.GuiceFilter.init(GuiceFilter.java:226)
at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
at org.apache.catalina.core.ApplicationFilterConfig.(ApplicationFilterConfig.java:102)
at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4511)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5157)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:713)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:690)
09-Jan-2019 18:51:49.903 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\docs]
09-Jan-2019 18:51:50.360 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\docs] has finished in [458] ms
09-Jan-2019 18:51:50.361 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\manager]
09-Jan-2019 18:51:50.474 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\manager] has finished in [113] ms
09-Jan-2019 18:51:50.474 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\ROOT]
09-Jan-2019 18:51:50.557 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\ROOT] has finished in [83] ms
09-Jan-2019 18:51:50.562 INFO [1] org.apache.catalina.startup.Catalina.start Server startup in [208,669] milliseconds
09-Jan-2019 18:51:50.564 SEVERE [1] org.apache.catalina.core.StandardServer.await Failed to create server shutdown socket on address [localhost] and port [8005] (base port [8005] and offset [0])
java.net.BindException: Address already in use: JVM_Bind
at java.net.DualStackPlainSocketImpl.bind0(Native Method)
at java.net.DualStackPlainSocketImpl.socketBind(DualStackPlainSocketImpl.java:106)
at java.net.AbstractPlainSocketImpl.bind(AbstractPlainSocketImpl.java:387)
at java.net.PlainSocketImpl.bind(PlainSocketImpl.java:190)
at java.net.ServerSocket.bind(ServerSocket.java:375)
at java.net.ServerSocket.(ServerSocket.java:237)
at org.apache.catalina.core.StandardServer.await(StandardServer.java:587)
at org.apache.catalina.startup.Catalina.await(Catalina.java:725)
at org.apache.catalina.startup.Catalina.start(Catalina.java:671)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
Hi,
Your problem seems to comes from the allowed memory to Tomtcat (see java.lang.OutOfMemoryError error) not from Axelor app itself. It’s really strange because the default memory size is normally enough to start the app. How many free memory is available on your computer with Postgres running and Tomcat not running ?
- You can win memory by removing all folders in webapps (exepted Axelor of course)
- You can ovveride some envar to set upper memory size values. Addin your env
JAVA_OPTS=-Xms1024m -Xmx1024m -XX:MaxPermSize=512m
. Be sure to restart a CMD windows after apply to take it in considération. See explanations of these values here: https://alvinalexander.com/blog/post/java/java-xmx-xms-memory-heap-size-control.
Please specify you machine config and the used JDK
shutdown / startup of tomcat is required
hi @femtonext,
cool…
i was successful install axelor 5.1.0 after upgrade java memory size like you mentioned above. Great thanks @femtonext
it’s a good news. Pleasure to help you.
Please mark this topics as resolved
He can’t, admin created it
Installation in windows resolved
you’re right
Hi. May I know how you import your files from the axelor to BIRT Eclipse? Thank you so much. I’ve been struggling with this really. It will be a great help if you can instruct me.