@CraigWeb
Every month 1st we rename existing table with suffix and create new pointvalues table. We did similar practice in older version of mango.
We will study and try noSQL.
@CraigWeb
Every month 1st we rename existing table with suffix and create new pointvalues table. We did similar practice in older version of mango.
We will study and try noSQL.
My variable name:JAVA_HOME
Now I changed back to
wrapper.java.command = %JAVA_HOME%/bin/java
While Starting Service Now I am getting error as
Error2: The system cannot find the file specified
Hi,
I just freshly installed service and below are the log file ( C:\Mango\yajsw\log\wrapper)
................
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:17|ahessian jmx service bound to port 15002
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:17|working dir C:\Mango\bin
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:17|started process with pid 9028
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:18|restart process due to default exit code rule
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:18|restart internal RUNNING
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:18|stopping process with pid/timeout 9028 45000
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:18|process exit code: 4
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:23|working dir C:\Mango\bin
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:23|started process with pid 8384
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:24|restart process due to default exit code rule
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:24|restart internal RUNNING
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:24|stopping process with pid/timeout 8384 45000
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:24|process exit code: 4
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:29|working dir C:\Mango\bin
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:29|started process with pid 10676
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:30|restart process due to default exit code rule
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:30|restart internal RUNNING
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:30|stopping process with pid/timeout 10676 45000
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:30|process exit code: 4
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:35|working dir C:\Mango\bin
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:35|started process with pid 504
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:36|restart process due to default exit code rule
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:36|restart internal RUNNING
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:36|stopping process with pid/timeout 504 45000
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:36|process exit code: 4
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:41|working dir C:\Mango\bin
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:41|started process with pid 4200
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:42|restart process due to default exit code rule
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:42|restart internal RUNNING
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:42|stopping process with pid/timeout 4200 45000
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:42|process exit code: 4
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:47|working dir C:\Mango\bin
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:47|started process with pid 2528
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:48|too many restarts
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:48|process not in state RUNNING -> Delaying stop
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:48|calling onStop
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:48|Win service stop - timeout: 30000
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:48|Win service wrapper.control -> stopping application
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:48|Win service stop - after shutdown
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:48|Win service stop - before notify
INFO|wrapper|Service com.serotonin.m2m2.Main|19-04-17 15:36:48|Win service terminated
Hi,
Please refer attachment, I highlighted in RED color in Search Box in Firefox, I couldn't able to find NoSQL Module, It is deleted.
Hi phildunlap,
Please find attached Environmental Setup screen shot.
Mango path on my PC as below.
C:\Mango
![alt text]
My Wrapper.conf file details are below..
# WARNING - Do not modify any of the properties when an application
# using this configuration file has been installed as a service or daemon.
# Please uninstall the service before modifying this file. The
# service must then be reinstalled.
#********************************************************************
# working directory
#********************************************************************
## Edit:
wrapper.working.dir=C:\\Mango\\bin\\
#********************************************************************
# tmp folder
# yajsw creates temporary files named in_.. out_.. err_.. jna..
# per default these are placed in jna.tmpdir.
# jna.tmpdir is set in setenv batch file to <yajsw>/tmp
#********************************************************************
wrapper.tmp.path = ${jna_tmpdir}
#********************************************************************
# Application main class or native executable
# One of the following properties MUST be defined
#********************************************************************
# Java Application main class
wrapper.java.app.mainclass=com.serotonin.m2m2.Main
#********************************************************************
# Wrapper Logging Properties
#********************************************************************
# Log Level for console output. (See docs for log levels)
wrapper.console.loglevel=INFO
# Log file to use for wrapper output logging.
wrapper.logfile=${wrapper_home}\/log\/wrapper.log
# Maximum size that the log file will be allowed to grow to before
# the log is rolled. Size is specified in bytes. The default value
# of 0, disables log rolling by size. May abbreviate with the 'k' (kB) or
# 'm' (mB) suffix. For example: 10m = 10 megabytes.
# If wrapper.logfile does not contain the string ROLLNUM it will be automatically added as suffix of the file name
wrapper.logfile.maxsize=10m
# Maximum number of rolled log files which will be allowed before old
# files are deleted. The default value of 0 implies no limit.
wrapper.logfile.maxfiles=10
#********************************************************************
# Application Console Properties
#********************************************************************
# Title to use when running as a console
wrapper.console.title=com.serotonin.m2m2.Main
#********************************************************************
# Wrapper Windows Service and Posix Daemon Properties
#********************************************************************
# Name of the service
wrapper.ntservice.name=Mango
# Display name of the service
wrapper.ntservice.displayname=Mango
# Description of the service
wrapper.ntservice.description=Mango Automation
#********************************************************************
# Wrapper Posix Daemon Properties
#********************************************************************
# The following grooy script should set it correctly for most distros
wrapper.daemon.run_level_dir=${if (new File('\/etc\/rc0.d').exists()) return '\/etc\/rcX.d' else return '\/etc\/init.d\/rcX.d'}
#********************************************************************
# Wrapper System Tray Properties
#********************************************************************
# enable system tray
wrapper.tray = true
# TCP/IP port. If none is defined multicast discovery is used to find the port
# Set the port in case multicast is not possible.
wrapper.tray.port = 15002
#********************************************************************
# Exit Code Properties
# Restart on non zero exit code
#********************************************************************
wrapper.on_exit.0=SHUTDOWN
wrapper.on_exit.default=RESTART
#********************************************************************
# Trigger actions on console output
#********************************************************************
# On Exception show message in system tray
wrapper.filter.trigger.0=Exception
wrapper.filter.script.0=scripts\/trayMessage.gv
wrapper.filter.script.0.args=Exception
#********************************************************************
# genConfig: further Properties generated by genConfig
#********************************************************************
placeHolderSoGenPropsComeHere=
wrapper.java.command = java
# Edit:
wrapper.java.classpath.1 = C:\\Mango\\overrides\\classes
wrapper.java.classpath.2 = C:\\Mango\\classes
wrapper.java.classpath.3 = C:\\Mango\\overrides\\properties
wrapper.java.classpath.4 = C:\\Mango\\overrides\\lib\\*.jar
wrapper.java.classpath.5 = C:\\Mango\\lib\\*.jar
wrapper.java.additional.1 = -server
wrapper.java.additional.2 = -Dma.home=C:\\Mango
Hi phildunlap,
Thanks for your input for changing pointvalue storage from No sql to MYSQL,we are familiar in MYSQL-PHP , and we have some customized reporting application developed and ready to use, so at present we need Bacnet data on MYSQL,
Any way thanks for your input.
Hi,
Thanks for your reply, Let me follow your instruction and revert back.
Hi phildunlap,
Thanks for your response, Is it possible to switch back from NOSQL to MYSQL, Because we have some requirement to customize some reports using PHP , to do that we need datas in MYSQL, is it possible to store datas on MYSQL pointvalues table?
Hi,
I couldn't able to see any updates on C:\Mango\logs\ma.log file recently, I too cleared log file and restarted the service No updates on ma.log
I tried running services on command prompt below are updates. but services stopped again..
C:\Mango\yajsw\bat>startservice.bat
C:\Mango\yajsw\bat>cd C:\Mango\yajsw\bat\
C:\Mango\yajsw\bat>call setenv.bat
"java" -Xmx30m -Djna_tmpdir="C:\Mango\yajsw\bat/../tmp" -Djava.net.preferIPv4Stack=true -jar "C:\Mango\yajsw\bat/../wrapper.jar" -t "C:\Mango\yajsw\bat/../conf/wrapper.conf"
YAJSW: yajsw-stable-11.11
OS : Windows 10/10.0/x86
JVM : Oracle Corporation/1.8.0_201/C:\Program Files (x86)\Java\jre1.8.0_201/32
Apr 16, 2019 9:42:14 PM org.apache.commons.vfs2.VfsLog info
INFO: Using "C:\Users\L&TTOD~1\AppData\Local\Temp\vfs_cache" as temporary files store.
************* STARTING Mango ***********************
Service Mango started
Press any key to continue . . .
Yes We installed installservice.bat as Administrator, after installation I can able to see Mango service listed.(refer attachement)
But when we start our service, It stops immediately, (BuI i can able to run in Command prompt mode)
I Installed Demo version of Mango, I added sample 3 nos of Bacnet Datapoints, Points show History, But I couldn't able to see Trend Graph.
Database:MYSQL
I couldn't able to see any data updation in mysql database on Pointvalues table
Is it depends on License or Am I missing something?
I Installed Mango on Windows 10 today,At present I am running Mango using command prompt, I kept Mango on C:\Mango and using below procedure I Download the zip file yajsw.zip Unzip the file to C:\Mango
In the command prompt cd to C:\Mango\yajsw\bat and they run installService.bat.
Service Installed and I can able to view services menu.
https://help.infiniteautomation.com/installing-services
But when I am trying to Run service I could not able to open(But when I am running command prompt i can able to see) Refer attachments.