UGCCMon service starts and stops. WIN2016Server x64

Having problems with the panel? Have questions? Post here!
Post Reply
Anky
Posts: 14
Joined: Sat Jul 09, 2016 12:55 pm

UGCCMon service starts and stops. WIN2016Server x64

Post by Anky »

Operating System: Windows 2016 Standard
Arch: 64bit
Install method : Manual
Database being used: mysql
If manual install; installing just the monitor service
Steps to reproduce issue: I have gone into the Service.msc to manual start. It will start and then state that the service started and stopped.
Any troubleshooting steps you've tried:
1. I have uninstalled, rebooted, reconfigured new install per the directions.
2. I have installed MySQL Workbench, configured connection to the MySQL database and confirmed that the server is able to connect.

Relevant log entries and/or event viewer messages:
EVENT ERROR:

- System

- Provider

[ Name] UGCCMon

- EventID 0

[ Qualifiers] 0

Level 2

Task 0

Keywords 0x80000000000000

- TimeCreated

[ SystemTime] 2016-12-30T11:16:39.136713700Z

EventRecordID 568

Channel Application

Computer ARMA3-Liberation

Security


- EventData

Service cannot be started. Mono.Data.Sqlite.SqliteException: SQLite error no such table: config at Mono.Data.Sqlite.SQLite3.Prepare(SqliteConnection cnn, String strSql, SqliteStatement previous, UInt32 timeoutMS, String& strRemain) at Mono.Data.Sqlite.SqliteCommand.BuildNextCommand() at Mono.Data.Sqlite.SqliteDataReader.NextResult() at Mono.Data.Sqlite.SqliteDataReader..ctor(SqliteCommand cmd, CommandBehavior behave) at Mono.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Mono.Data.Sqlite.SqliteCommand.ExecuteScalar() at MashToolsSharp.sqlite.get_data(Object table, Object returnfld, Object wherefld, Object wherefldmatch, Object wherefld2, Object wherefldmatch2, Object wherefld3, Object wherefldmatch3, Object sortfld, Boolean sortdesc) at #=qqGEs_fFXV4$9UBDfeuLroldnhKIP7b39TYeTyGfB0jY=.#=qwTa4y$oQ6OiI3gBas0RdPw==(String #=qyDDFONUoeZ$QE7xQu6h5Ng==, String #=qBP1Fri$KwN$lbz5h2wYb0Q==, String #=qcet$F2sOOm3CR8QRoon2oQ==, String #=q2HXqRGXiVmVH9j459eTYXQ==, String #=qSW5D0itZpgzfX65P...
Masher
Site Admin
Posts: 3612
Joined: Thu Apr 20, 2006 2:54 pm
Location: America's Heartland
Contact:

Re: UGCCMon service starts and stops. WIN2016Server x64

Post by Masher »

Double check your database settings in windows\system32\ugccmon.cfg. Only use notepad, wordpad, or another 64 bit editor to edit the file.

The error indicates it is trying to connect to a sqlite database.
Masher
-----------
Please do not PM me unless asked to! We are a small company. If you have an issue or question it would be best to post it in the forums where it can help others in the future.

NEW Join our Discord!
Anky
Posts: 14
Joined: Sat Jul 09, 2016 12:55 pm

Re: UGCCMon service starts and stops. WIN2016Server x64

Post by Anky »

Will give it another go.
I used Notepad.exe in the System32 folder and ran it as Admin.
If it does not work this time, I will try another server. I will request a license transfer.
Just not getting the warm feeling with Win2016Server.
Anky
Posts: 14
Joined: Sat Jul 09, 2016 12:55 pm

Re: UGCCMon service starts and stops. WIN2016Server x64

Post by Anky »

ok. so I gave up on the Win 2016 server for now and stood up a Win2012r2 server x64.
I moved all my Arma3 files over and installed the monitor service, transferred the license file and restarted the service.
***The ugccmon service is stuck at "Starting".***
No error logs in Event Viewer.
No logs in UGCC folder as well.
Running the service as "system" or "Administrator"
I have checked the permissions to the UGCC folder and verified that the permission is "Modify".
Masher
Site Admin
Posts: 3612
Joined: Thu Apr 20, 2006 2:54 pm
Location: America's Heartland
Contact:

Re: UGCCMon service starts and stops. WIN2016Server x64

Post by Masher »

Can you post your ugccmon.cfg? Mask out any passwords and other sensitive information.
Masher
-----------
Please do not PM me unless asked to! We are a small company. If you have an issue or question it would be best to post it in the forums where it can help others in the future.

NEW Join our Discord!
Anky
Posts: 14
Joined: Sat Jul 09, 2016 12:55 pm

Re: UGCCMon service starts and stops. WIN2016Server x64

Post by Anky »

//!!!!This config file is ONLY read from c:\windows\system32 on windows and the same folder as executable on linux.
//Windows users--only use notepad/wordpad on 64 bit Operating systems to edit this file!!!
//PLEASE NOTE: The // is not a real comment, the line immediately following the [setting] is used regardless
//whether it's prefixed with // or not

//Database Engine type to use--valid options are mysql or sqlite
//sqlite uses a db3 file, while mysql uses MySQL
//Use the same database the panel uses
[DBEngine]
mysql

//Database configuration string
//Make sure this points to the same DB the panel uses!!!!!!
//Example for MySQL:
//Database=ugcc;Data Source=localhost;Port=3306;User Id=root;Password=pw
//Example for sqlite
//Data Source=c:\program files\ugcc\ugcc.db3
[DBConfig]
Database=ugcc;Data Source=10.5.xxx.xxx;Port=3306;User Id=******;Password=************

//Where to save log file
[LogConfig]
c:\Program Files\UGCCMon

//Where to find the license file
[License]
C:\Program Files\UGCC

//How often to check that the servers are running
//You can use .25 for 15 second interval, .5 for 30 second interval, specify whole minutes otherwise
[ServerCheck]
1

//How long to pause between starting servers when the monitor starts (i.e. during reboot)
//Enter a whole value in seconds
[FirstBootPause]
10

//Enable integrated FTP Server? (True/False)
[FTP]
True

//Listen port for FTP Server.
//Default port is 21
[FTPPort]
21

//Mininum port number for integrated ftp server to use for passive mode data channel
[FTPDataMinPort]
2000

//Maxinum port number for integrated ftp server to use for passive mode data channel
[FTPDataMaxPort]
65535

//Enable HiResTimer? aka fps boosting
//Only works on windows
[HiResTimer]
True

//Email Payment reminders?
//This only needs to be enabled for one monitor on the system
[PayReminders]
False

//Send a copy of emails to bcc address?
//This setting will send a blind carbon copy of all restart notifications emails sent by the monitor.
[BccEmails]
False

//Enable remote/slave mode? This is requried if web portion of UGCC doesn't run on this computer.
//If set to False the rest of the settings below don't matter
[Remote]
True

//Port to listen on
[Port]
3432

//Shared Secret
[Secret]
******

//This is the ID number associated with this computer's server definition within UGCC
//Very important that this is set correctly if Remote mode is enabled
[ID]
4
Masher
Site Admin
Posts: 3612
Joined: Thu Apr 20, 2006 2:54 pm
Location: America's Heartland
Contact:

Re: UGCCMon service starts and stops. WIN2016Server x64

Post by Masher »

This looks good. Only thing I would try changing is having the license and logconfig paths be the same.

Use task manager to kill the ugccmonsvc.exe process and try restarting the service. If that doesn't help please let me know.
Masher
-----------
Please do not PM me unless asked to! We are a small company. If you have an issue or question it would be best to post it in the forums where it can help others in the future.

NEW Join our Discord!
Anky
Posts: 14
Joined: Sat Jul 09, 2016 12:55 pm

Re: UGCCMon service starts and stops. WIN2016Server x64

Post by Anky »

ok. doing it now.
Anky
Posts: 14
Joined: Sat Jul 09, 2016 12:55 pm

Re: UGCCMon service starts and stops. WIN2016Server x64

Post by Anky »

made the change per your recommendation.

//Where to save log file
[LogConfig]
c:\Program Files\UGCC

//Where to find the license file
[License]
C:\Program Files\UGCC

Went to the task manager - Services - clicked on stop... nothing
switched to the Processes tab -> right clicked on UGCC Monitor Service -> End task.
back to the Services tab, the UGCCMon service was "Stopped"
Right clicked on UGCCMon service and clicked "Start" it still states "Starting" for the last five minutes.
I have checked the Event Viewer, no errors.
Masher
Site Admin
Posts: 3612
Joined: Thu Apr 20, 2006 2:54 pm
Location: America's Heartland
Contact:

Re: UGCCMon service starts and stops. WIN2016Server x64

Post by Masher »

Is there anything in the ugccmon.log file? Should be in c:\pf\ugcc
Masher
-----------
Please do not PM me unless asked to! We are a small company. If you have an issue or question it would be best to post it in the forums where it can help others in the future.

NEW Join our Discord!
Anky
Posts: 14
Joined: Sat Jul 09, 2016 12:55 pm

Re: UGCCMon service starts and stops. WIN2016Server x64

Post by Anky »

hmmm, not 100% but maybe this is the issue...
Taken from the log

12/31/2016 1:51:41 PM UGCCMon Started (1.88) | Dbtype=mysql | Interval=60000ms | OS: Win | Config file: C:\Windows\system32\ugccmon.cfg | User: LIBERATION\Administrator
12/31/2016 1:51:42 PM Expecting version 64 of the database; but version 63 was found. If you've updated and haven't logged in to the panel yet this is normal. Please update the monitor or login into the panel as an admin user to update the database. Sleeping for 30 seconds and will recheck...
Anky
Posts: 14
Joined: Sat Jul 09, 2016 12:55 pm

Re: UGCCMon service starts and stops. WIN2016Server x64

Post by Anky »

updating to 1.88 and trying the monitor again. will report back.
Anky
Posts: 14
Joined: Sat Jul 09, 2016 12:55 pm

Re: UGCCMon service starts and stops. WIN2016Server x64

Post by Anky »

Masher!
Thank you! I am up and running. The problem was that the database was not at version 64. Upgraded using EZUGCC and logged in to the panel as admin to upgrade the database from 63 to 64. AND now I am connected, the UGCCMon service is running like it should.

Issue Solved!

When in doubt, read the log.
Masher
Site Admin
Posts: 3612
Joined: Thu Apr 20, 2006 2:54 pm
Location: America's Heartland
Contact:

Re: UGCCMon service starts and stops. WIN2016Server x64

Post by Masher »

Great, glad you got it working!
Masher
-----------
Please do not PM me unless asked to! We are a small company. If you have an issue or question it would be best to post it in the forums where it can help others in the future.

NEW Join our Discord!
Post Reply