wmacdonald
Posts: 31
Joined: Fri Jul 31, 2015 2:56 am
Location: Canada

Fresh install NMEA wont start

Wed Oct 28, 2015 9:16 pm

Just installed on a clean server, and NMEA service starts and then stops. Heres the error log. Any suggestions

at Franson.Install.DB.Module.Install(Boolean bDoNotCreate)
at Franson.Install.DB.Package.Install(Boolean bDoNotCreate)
at GpsGate.Online.GateApplication.m_InstallAvailableDatabasePackages()
at GpsGate.Online.GateApplication.m_StartService()
at GpsGate.Online.GateApplication.m_BackGroundStartup(Object o)
2015-10-28 11:10:12.3141 | Fatal | 6 | GateApplication.GateApplication_UnhandledException | Unhandled exception - Franson.Install.DB.ModuleExecutionException: Error executing 'C:\GpsGateServer\IIS\Packages\GpsGateServerModule_1.1.0.170.sql' ---> Failed to execute 'ALTER TABLE settings MODIFY COLUMN setting_id INTEGER NOT NULL DEFAULT NULL AUTO_INCREMENT;' (Franson.DAO.ExecuteDBException)
at Franson.DAO.DAOBase.ExecuteNonQuery(String strCommand)
at Franson.Install.DB.Module.Install(Boolean bDoNotCreate)
ERROR [HY000] [MySQL][ODBC 5.1 Driver][mysqld-5.7.9-log]All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead (System.Data.Odbc.OdbcException)
at Franson.DAO.DAOConnector.RetryConnect(Exception ex, Boolean bThrow)
at Franson.DAO.DAOBase.ExecuteNonQuery(String strCommand)

--- End of inner exception stack trace ---
at Franson.Install.DB.Module.Install(Boolean bDoNotCreate)
at Franson.Install.DB.Package.Install(Boolean bDoNotCreate)
at GpsGate.Online.GateApplication.m_InstallAvailableDatabasePackages()
at GpsGate.Online.GateApplication.m_StartService()
at GpsGate.Online.GateApplication.m_BackGroundStartup(Object o)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading._ThreadPoolWaitCallback.PerformWaitCallbackInternal(_ThreadPoolWaitCallback tpWaitCallBack)
at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback(Object state) |

wmacdonald
Posts: 31
Joined: Fri Jul 31, 2015 2:56 am
Location: Canada

RE: Fresh install NMEA wont start

Thu Oct 29, 2015 10:11 am

Sorry here's the full log, I've again tried with a different freshly rebuilt VM. (server was running fine prior to rebuilding the VM) and re downloading gpsgate.

What am I doing wrong?

2015-10-29 00:06:21.4511 | Error | 6 | TargetConfig.get_Target | Could not create LogTarget instance. Assembly = GpsGate.Terminal.Profiler Type = GpsGate.Terminal.Profiler.TerminalProfilingTarget | System.IO.FileNotFoundException: Could not load file or assembly 'GpsGate.Terminal.Profiler' or one of its dependencies. The system cannot find the file specified.
File name: 'GpsGate.Terminal.Profiler'
at System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)
at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
at System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
at System.Reflection.Assembly.Load(String assemblyString)
at Franson.Profiling.ProfilerConfiguration.TargetConfig.get_Target()

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

2015-10-29 00:06:22.2674 | Error | 6 | TargetConfig.get_Target | Could not create LogTarget instance. Assembly = GpsGate.Terminal.Profiler Type = GpsGate.Terminal.Profiler.TerminalProfilingTarget | System.IO.FileNotFoundException: Could not load file or assembly 'GpsGate.Terminal.Profiler' or one of its dependencies. The system cannot find the file specified.
File name: 'GpsGate.Terminal.Profiler'
at System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)
at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
at System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
at System.Reflection.Assembly.Load(String assemblyString)
at Franson.Profiling.ProfilerConfiguration.TargetConfig.get_Target()

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

2015-10-29 00:06:50.7823 | Error | 6 | Module.Install | Error executing query. Error 1171: Failed to execute 'ALTER TABLE settings MODIFY COLUMN setting_id INTEGER NOT NULL DEFAULT NULL AUTO_INCREMENT;' |
2015-10-29 00:06:51.2493 | Error | 6 | MySQLOdbcConnector.CheckReconnect | OdbcNativeError = 1146 |
2015-10-29 00:06:51.3780 | Fatal | 6 | GateApplication.m_BackGroundStartup | Could not start GpsGate Service | Franson.Install.DB.ModuleExecutionException: Error executing 'C:\GpsGateServer\IIS\Packages\GpsGateServerModule_1.1.0.170.sql' ---> Failed to execute 'ALTER TABLE settings MODIFY COLUMN setting_id INTEGER NOT NULL DEFAULT NULL AUTO_INCREMENT;' (Franson.DAO.ExecuteDBException)
at Franson.DAO.DAOBase.ExecuteNonQuery(String strCommand)
at Franson.Install.DB.Module.Install(Boolean bDoNotCreate)
ERROR [HY000] [MySQL][ODBC 5.1 Driver][mysqld-5.7.9-log]All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead (System.Data.Odbc.OdbcException)
at Franson.DAO.DAOConnector.RetryConnect(Exception ex, Boolean bThrow)
at Franson.DAO.DAOBase.ExecuteNonQuery(String strCommand)

--- End of inner exception stack trace ---
at Franson.Install.DB.Module.Install(Boolean bDoNotCreate)
at Franson.Install.DB.Package.Install(Boolean bDoNotCreate)
at GpsGate.Online.GateApplication.m_InstallAvailableDatabasePackages()
at GpsGate.Online.GateApplication.m_StartService()
at GpsGate.Online.GateApplication.m_BackGroundStartup(Object o)
2015-10-29 00:06:51.9436 | Fatal | 6 | GateApplication.GateApplication_UnhandledException | Unhandled exception - Franson.Install.DB.ModuleExecutionException: Error executing 'C:\GpsGateServer\IIS\Packages\GpsGateServerModule_1.1.0.170.sql' ---> Failed to execute 'ALTER TABLE settings MODIFY COLUMN setting_id INTEGER NOT NULL DEFAULT NULL AUTO_INCREMENT;' (Franson.DAO.ExecuteDBException)
at Franson.DAO.DAOBase.ExecuteNonQuery(String strCommand)
at Franson.Install.DB.Module.Install(Boolean bDoNotCreate)
ERROR [HY000] [MySQL][ODBC 5.1 Driver][mysqld-5.7.9-log]All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead (System.Data.Odbc.OdbcException)
at Franson.DAO.DAOConnector.RetryConnect(Exception ex, Boolean bThrow)
at Franson.DAO.DAOBase.ExecuteNonQuery(String strCommand)

--- End of inner exception stack trace ---
at Franson.Install.DB.Module.Install(Boolean bDoNotCreate)
at Franson.Install.DB.Package.Install(Boolean bDoNotCreate)
at GpsGate.Online.GateApplication.m_InstallAvailableDatabasePackages()
at GpsGate.Online.GateApplication.m_StartService()
at GpsGate.Online.GateApplication.m_BackGroundStartup(Object o)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading._ThreadPoolWaitCallback.PerformWaitCallbackInternal(_ThreadPoolWaitCallback tpWaitCallBack)
at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback(Object state) |

User avatar
Gabor
GpsGate
Posts: 86
Joined: Thu May 16, 2013 3:43 pm

RE: Fresh install NMEA wont start

Thu Oct 29, 2015 7:17 pm

Hi,

Thank you for your feedback. We managed to reproduce the issue, it occurs when using new MySQL version (5.7). We will release a new installer to fix this.


Regards,
Gabor
GpsGate Support

wmacdonald
Posts: 31
Joined: Fri Jul 31, 2015 2:56 am
Location: Canada

RE: Fresh install NMEA wont start

Thu Oct 29, 2015 9:35 pm

Thank you. I was beginning to lose my mind thinking I was doing something wrong repeatedly.
in the meantime which version of MYSQL should I download to ensure there are no further issues.

Thanks again!

Return to “GpsGate Server - How to setup and use”