Geotab Support Forum

Hello

i noticed web server in version 5.3.1. Please explain how to configure and use

Thank You

Helllo,

I’ve attached the help documentation for Checkmate 5.3.1 Web Server. Please let me know if you require more information.

Regards,

Tony

i followed the steps, but could not log in on the web. Below is the log file, and config files. support user has been given required permissions. used version Checkmate.5.3.1.10012.
LOG
====================================
Log opened on 9/2/2009 10:42:55 AM
9/2/2009 10:42:55 AM: Starting Web Service up...
9/2/2009 10:42:55 AM: StatusRunning
9/2/2009 10:42:55 AM: Reading Config Files...
9/2/2009 10:42:55 AM: Connection is secured by the server cetifcate: CN=sqlserverproxy.geotab
9/2/2009 10:42:55 AM: Listening on port 443
9/2/2009 10:42:55 AM: Reading 'C:\Documents and Settings\All Users\Application Data\GEOTAB\Checkmate\Host Config\Cascadelle.config' ...
9/2/2009 10:42:55 AM: Starting 'C:\Documents and Settings\All Users\Application Data\GEOTAB\Checkmate\Demo.mdb' ...
9/2/2009 10:42:55 AM: Started Host Service.
9/2/2009 10:42:55 AM: Running!
9/2/2009 10:43:59 AM: Accepted connection from 127.0.0.1:4390 of total 1
9/2/2009 10:43:59 AM: Geotab.Checkmate.Database.SqlLoginFailedException: DbUnavailableException: Login failed for user
Login failed for user 'supportuser'.( 18456 ) ---> System.Data.SqlClient.SqlException: Login failed for user 'supportuser'.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Geotab.Checkmate.Database.TransactedConnection.OpenConnectionWithPoolErrorCheck(IDbConnection connection)
at Geotab.Checkmate.Database.MSSql2000Store.CreateUnTransactedConnection()
at Geotab.Checkmate.Database.SqlStore.CreateConnection()
--- End of inner exception stack trace ---
at Geotab.Checkmate.Database.SqlStore.CreateConnection()
at Geotab.Checkmate.Database.SystemSettingsBridge.GetDataStoreVersion()
at Geotab.Checkmate.Database.SqlStore.GetDataStoreVersion()
at Geotab.Checkmate.Database.DatabaseUpgrader.InitializeCheckmateDatabase()
at Geotab.Checkmate.Database.SqlStore.InitUserDatastore(String logonName, String logonPassword, UserAuthenticationType loginType, Boolean silentUpgrade)
at Geotab.Checkmate.ObjectModel.SqlServerDataStoreFactory.GetDataStore()
at Geotab.Checkmate.Net.SqlServerProxy.ProxyConnection.ValidateConnectionAndLogin(String& sqlServerHost, Nullable`1& sqlServerPort, String dbName, String sqlLogin, String checkmateUser, String checkmatePassword)


Security
===========================



<!-- Dictionary items that specify database 'login:user@server,port' for a given database name ('@server:port' is optional) /-->
<!-->add database="GEOTAB1" login="geotabuser:vircom43" /-->




Host
=============================



MSSqlServer2000
true
false
Reza\SqlExpress
Cascadelle

false
false
false

false
false
false
true
false
false
false
2008-03-11T00:00:00.0000000-04:00
60
true
2005-01-01T23:00:00.0000000-05:00


1200
za.service.geotab.com
443


1200
service.geotab.com
3992


8080
false
false


gps2go.geotab.com
443
http://webservice1.geotab.com/gotwo/


false
true
false
\\remotehost\DataManager

C:\Documents and Settings\All Users\Application Data\GEOTAB\Checkmate\Maps

Hello
Please refer to the "Configure Database Security" section on page 4 of the setup documentation. Please let me know if the security.config file has the correct password for the user you are creating

Yes, I did create SQL login geotabuser with password vircom43.I then assigned relevant premission on the cascadelle db.

Hi

i worked when i modified the then security config as follows



well, i created another user, but it worked when i added @Reza\SQLExpress

Hello again. Well i was able to configure the web server after adding sqlUser:sqlPassword@server in security

now i'm having another issue. i suppose we must allow external users (wan user) to access the web server. i suppose we need to need to do port forwarding to the web server. which port or config to use?

Please advise

Thank you

Reza

Hello,

Checkmate web server uses port 80 and port 443. To allow external users, ensure that exceptions for both ports are created in the firewall.

Thanks for the info.
What if I have an IIS website already running in the server that checkmate is running? Is there any way I can setup web service under the existing website?

Thanks.

Hello,

If IIS is running and using Port 80 or Port 443, you must install Checkmate web server on a different computer.

The issue is that Checkmate web server requires port 80 and 443. One option is to configure IIS to use a different port other than 80 and 443.