andorega
Posts: 15
Joined: Sat Aug 18, 2007 11:23 pm
Location: Spain

Service stopped in Server 2.0

Wed Jul 09, 2008 11:08 pm

Greetings.
in "GpsGate Server v1.3.2 build 483", the service is right when you start windows, to upgrade to "GpsGate Server 2.0 (BETA 2) build 784" released stopped this service should be initiated manually why?.

User avatar
johan
GpsGate
Posts: 15145
Joined: Wed Aug 04, 2004 10:40 pm
Location: Sweden
Contact: Website

RE: Service stopped in Server 2.0

Thu Jul 10, 2008 12:14 am

The service is set to autostart when Windows starts in 2.0 as well.

There is one difference, the service is started after the database installation in 2.0.

Regards,
Johan

Franson Support

andorega
Posts: 15
Joined: Sat Aug 18, 2007 11:23 pm
Location: Spain

RE: Service stopped in Server 2.0

Mon Jul 14, 2008 5:32 pm

Greetings Johan.

Updated to "GpsGate Server v2.0 BETA build 784", and in "GpsGate Server v2.0 BETA build 831" I have the same error: (service NMEA only)

(Message Windows error log)

----------------------------------------------------------

Not init service. Franson.DAO.DatabaseException: Unable to connect to the database. Please check that the database server is running and that the connection string in the Web/App.config is valid. Error: ERROR [HY000] [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on 'localhost' (10061)
ERROR [HY000] [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on 'localhost' (10061)
en Franson.DAO.DAOFactory.ResolveConnection(OdbcConnection templateConnection)
en Franson.DAO.DAOReaderBase.<Execute>d__0.MoveNext()
en Franson.Reflection.TypeInstanceReader.<get_LoadLoadableTypes>d__0.MoveNext()
en GpsGate.Online.GateApplication.m_RegisterListenerTypes()
en GpsGate.Online.GateApplication.Start()
en GpsGate.Online.NmeaServiceApplication.Start()
en GpsGate.Service.NmeaService.OnStart(String[] args)
en System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)

---------------------------------------------------------------------------------

Without firewalls, antivirus, and installed.

Initiated session after the upgrade as an administrator.

It is only possible Init Service NMEA manually.

The same is true in a new instalation of GpsGateServer.

Runnig: Windows XP SP3, Mysql-5.0.51b-win32, mysql-connector-odbc-5.1.4-win32.

In the version "GpsGate Server 1.3.2 build 483" entirely correct.

What is the problem?......... Thank you for your attention.

andorega
Posts: 15
Joined: Sat Aug 18, 2007 11:23 pm
Location: Spain

RE: Service stopped in Server 2.0

Mon Jul 14, 2008 5:46 pm

Other data of logfile_2008-07-14.log

--------------------------------
2008-07-14 13:59:10.9317 | Info | 1 | AuthenticationManager.Authenticate | Authentication OK: Username = admin |
2008-07-14 13:59:11.2321 | Info | 1 | LoginControl.m_AssemblyLogin | Login OK User = admin SessionId = admin |
2008-07-14 13:59:11.2722 | Info | 1 | DAOBase.AddTable | Table = user_groups Added |
2008-07-14 13:59:11.4324 | Error | 1 | DAOBase.RetryConnect | System.Data.Odbc.OdbcException | ERROR [42S02] [MySQL][ODBC 5.1 Driver][mysqld-5.0.51b-community-nt]Table 'gpsgateserver.server_version' doesn't exist
2008-07-14 13:59:11.4424 | Error | 1 | DAOBase.RetryConnect | OdbcNativeError = 1146 |
2008-07-14 13:59:11.4624 | Error | 1 | DAOBase.RetryConnect | Failed to connect to database. | ERROR [42S02] [MySQL][ODBC 5.1 Driver][mysqld-5.0.51b-community-nt]Table 'gpsgateserver.server_version' doesn't exist
2008-07-14 13:59:11.4724 | Warn | 1 | DAOBase.AddTable | System.Data.Odbc.OdbcException | ERROR [42S02] [MySQL][ODBC 5.1 Driver][mysqld-5.0.51b-community-nt]Table 'gpsgateserver.server_version' doesn't exist
2008-07-14 13:59:11.4825 | Error | 1 | InstallManager.IsServerVersionInstalled | Exception loading ServerVersion | ERROR [42S02] [MySQL][ODBC 5.1 Driver][mysqld-5.0.51b-community-nt]Table 'gpsgateserver.server_version' doesn't exist
2008-07-14 13:59:12.0733 | Info | 1 | DAOBase.AddTable | Table = version Added |
2008-07-14 13:59:16.8001 | Info | 1 | Index.GetCallbackResult | Enter |
2008-07-14 13:59:16.8502 | Info | 1 | DAOBase.AddTable | Table = version Added |
2008-07-14 13:59:22.8788 | Error | 1 | DAOBase.Update | Update. System.InvalidOperationException | Falta DataColumn 'created' en DataTable 'version' para SourceColumn 'created'.
2008-07-14 13:59:22.8788 | Warn | 1 | DAOBase.Update | System.InvalidOperationException | Falta DataColumn 'created' en DataTable 'version' para SourceColumn 'created'.
2008-07-14 13:59:22.8989 | Error | 1 | DAOBase.Update | Update. System.InvalidOperationException | Falta DataColumn 'created' en DataTable 'version' para SourceColumn 'created'.
2008-07-14 13:59:22.9089 | Warn | 1 | DAOBase.Update | System.InvalidOperationException | Falta DataColumn 'created' en DataTable 'version' para SourceColumn 'created'.
2008-07-14 13:59:22.9890 | Info | 1 | Index.GetCallbackResult | Installed package = GpsGate Server Package Upgrade 1.4.0.477 |
2008-07-14 13:59:23.0791 | Info | 1 | Index.GetCallbackResult | Enter |
2008-07-14 13:59:23.0891 | Info | 1 | DAOBase.AddTable | Table = version Added |
2008-07-14 13:59:24.5713 | Info | 1 | Index.GetCallbackResult | Installed package = GpsGate Server Package Upgrade 2.0.0.716 |
2008-07-14 13:59:24.6514 | Info | 1 | Index.GetCallbackResult | Enter |
2008-07-14 13:59:24.6714 | Info | 1 | DAOBase.AddTable | Table = version Added |
2008-07-14 13:59:24.8917 | Info | 1 | Index.GetCallbackResult | Installed package = StarsNav Package |
2008-07-14 13:59:24.9719 | Info | 1 | Index.GetCallbackResult | Enter |
2008-07-14 13:59:25.0119 | Info | 1 | DAOBase.AddTable | Table = version Added |
2008-07-14 13:59:25.2322 | Info | 1 | Index.GetCallbackResult | Installed package = TeamSharp Device Upgrade Package 2.0.0.722 |
2008-07-14 13:59:25.3224 | Info | 1 | Index.GetCallbackResult | Enter |
2008-07-14 13:59:25.3324 | Info | 1 | DAOBase.AddTable | Table = version Added |
2008-07-14 13:59:26.8345 | Info | 1 | Index.GetCallbackResult | Installed package = GpsGate Server Package Upgrade 2.0.0.785 |
2008-07-14 13:59:26.9347 | Info | 1 | Index.GetCallbackResult | Enter |
2008-07-14 13:59:26.9447 | Info | 1 | Index.GetCallbackResult | All package installed |
2008-07-14 13:59:26.9547 | Info | 1 | Index.m_createSiteAdmin | Enter |
2008-07-14 13:59:38.4713 | Error | 1 | Index.GetCallbackResult | Exception installing package: | You can not write data in the transport connection: An error occurred during the connection attempt because the party did not respond properly connected after a period of time, or if an error occurred in connection established as the host connected has failed to respond.
2008-07-14 14:00:03.7476 | Info | 1 | DAOBase.AddTable | Table = applications Added |


--------------------------------------

Greetings.

User avatar
johan
GpsGate
Posts: 15145
Joined: Wed Aug 04, 2004 10:40 pm
Location: Sweden
Contact: Website

RE: Service stopped in Server 2.0

Mon Jul 14, 2008 6:14 pm

1. Service doesn't start at reboot.

This is because the service needs MySQL to be running when started, and apparently "Franson NMEA Service" starts before MySQL. We'll look into this.

2. This looks OK. But the web page fails to start "Franson NMEA Service" , you can do this manually instead.

Regards,
Johan

Franson Support

altf4
Posts: 1035
Joined: Mon Feb 04, 2008 8:05 pm
Location: Thailand
Contact: Website

RE: Service stopped in Server 2.0

Tue Jul 15, 2008 6:20 am

strange is .. i have the same problem .. and it apears the service never comes up againg by itself.

i notice this problems since 2 days while dicovered a issue that the service getting out of control if a port is not closed.
on a machine with many units the service take forever to terminate .

--
Backups are for WIMPS!
http://0x8.in.th/where (website position GpsGate Powered)

User avatar
johan
GpsGate
Posts: 15145
Joined: Wed Aug 04, 2004 10:40 pm
Location: Sweden
Contact: Website

RE: Service stopped in Server 2.0

Tue Jul 15, 2008 12:38 pm

The case with the non-starting service is under control, we will fix this.

The case when you could not stop the service is new to us. If you send the log file and a short description to bigfile @ franson . com when you run into similar problems, we'll try to fix it.

Regards,
Johan

Franson Support

altf4
Posts: 1035
Joined: Mon Feb 04, 2008 8:05 pm
Location: Thailand
Contact: Website

RE: Service stopped in Server 2.0

Tue Jul 15, 2008 6:17 pm

sure sure .. i will keep it in mind ...
i did restart the server last time .... NMEA Services produced in this 2 hours period about 150MB Logfiles
where a normal day on this server is about 40Mb log.

the scenario was a driver hold the port open (like a unit never disconnects) ... the GpsGateService.exe got up to 80% CPU Load ..
net stop "franson NMEA Service" resulting in error

i restarted then the machine ... and everything goes back to normal (exept the issue that the services are not starting alone .. but the waiting issue for mysql make sense .. so i can live with this

--
Backups are for WIMPS!
http://0x8.in.th/where (website position GpsGate Powered)

User avatar
johan
GpsGate
Posts: 15145
Joined: Wed Aug 04, 2004 10:40 pm
Location: Sweden
Contact: Website

RE: Service stopped in Server 2.0

Tue Jul 15, 2008 6:24 pm

I am not sure if those things relate. I don't think that an open socket could cause that. As I said before, ZIP the logfile and send a link if you want us to take a closer look at this.

Regards,
Johan

Franson Support

andorega
Posts: 15
Joined: Sat Aug 18, 2007 11:23 pm
Location: Spain

RE: Service stopped in Server 2.0

Sat Jul 19, 2008 11:18 pm

A small solution, for the moment:

Create a file called NMEA.bat, edit and write the order:

NET START "Franson Service NMEA"

Place in the Windows Start folder.

Greetings.

P.D.: not always, sorry

User avatar
johan
GpsGate
Posts: 15145
Joined: Wed Aug 04, 2004 10:40 pm
Location: Sweden
Contact: Website

RE: Service stopped in Server 2.0

Sun Jul 20, 2008 2:18 pm

Thanks for the work around! We have fixed this issue, and the solution will be part of the next update.

Regards,
Johan

Franson Support

User avatar
johan
GpsGate
Posts: 15145
Joined: Wed Aug 04, 2004 10:40 pm
Location: Sweden
Contact: Website

RE: Service stopped in Server 2.0

Wed Jul 23, 2008 9:01 pm

This is fixed in GpsGate Server 2.0 BETA4 build 877

Regards,
Johan

Franson Support

andorega
Posts: 15
Joined: Sat Aug 18, 2007 11:23 pm
Location: Spain

RE: Service stopped in Server 2.0

Fri Jul 25, 2008 12:04 am

Updated to the new version and not present the problem.

PS: I have sent the new Spanish language file.

Thank you.

Domingo.

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