• K
    KLN

    @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.

    posted in Mango Automation general Discussion read more
  • K
    KLN

    My variable name:JAVA_HOME
    0_1555568250060_java version.png

    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

    posted in User help read more
  • K
    KLN

    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

    posted in User help read more
  • K
    KLN

    Hi,
    0_1555495209374_Mango No SQL.png

    Please refer attachment, I highlighted in RED color in Search Box in Firefox, I couldn't able to find NoSQL Module, It is deleted.

    posted in Mango Automation general Discussion read more
  • K
    KLN

    Hi phildunlap,

    Please find attached Environmental Setup screen shot.

    0_1555482256287_env.png

    Mango path on my PC as below.

    C:\Mango
    ![alt text]0_1555483009417_mango path.jpg

    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
    

    posted in User help read more
  • K
    KLN

    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.

    posted in Mango Automation general Discussion read more
  • K
    KLN

    Hi,

    Thanks for your reply, Let me follow your instruction and revert back.

    posted in Mango Automation general Discussion read more
  • K
    KLN

    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?

    posted in Mango Automation general Discussion read more
  • K
    KLN

    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 . . .

    posted in User help read more
  • K
    KLN

    Yes We installed installservice.bat as Administrator, after installation I can able to see Mango service listed.(refer attachement)0_1555429858524_service.jpg
    But when we start our service, It stops immediately, (BuI i can able to run in Command prompt mode)

    posted in User help read more