GUIDE: Backup and restore GpsGate Server

[johan]

Note: for an updated version of this and other articles, we recommend you to check our knowledge base here

How to backup and restore a GpsGate Server installation

Database

Here is how to backup and restore the MySQL database https://support.gpsgate.com/hc/en-us/articles/360002904993

Backup GpsGate Server files

GpsGate Server is typically installed under C:\GpsGateServer or under C:\Inetpub\wwwroot\GpsGateServer

Backup the following folders to an off site location

"Deploy"
"Franson NMEA Service"
"IIS"
"opt" (except the content of the "opt\gpsgate\messagebus" subfolder)


Note that you should backup the files to some remote place.

Every time you install or update a plugin the GpsGate Server files needs to be backed up.


Restore GpsGate Server files

If you want to restore a backup on a new server. For example if you want to move to a larger server, or if your old server hard disk has crashed.

First of all restore the database as described in the link above.

Secondly restore the GpsGate Server files using the following steps:

1. Install Java JRE:
http://www.oracle.com/technetwork/java/javase/downloads/jre8-downloads-2133155.html

2. Download GpsGate Server here:
http://gpsgate.com/download

3. Run GpsGateServer.exe on NEW server.

NOTE!! Cancel the Wizard when it starts!

4. Delete the following folders

C:\GpsGateInstall\GpsGateServer\Deploy
C:\GpsGateInstall\GpsGateServer\Franson NMEA Service
C:\GpsGateInstall\GpsGateServer\IIS
C:\GpsGateInstall\GpsGateServer\opt

NOTE!! The folder is GpsGateInstall!

5. Copy your backup GpsGate Server files to C:\GpsGateInstall\GpsGateServer replacing the folders you deleted in the step above.

Now you have a new installer with the correct files!!

6. Run C:\GpsGateInstall\Install.exe on your new server.

During install selected the restored database.


LARGER INSTALLATIONS > 5000 units

For larger installations we recommend to use AWS.

Use AWS Aurora as database. It has a lot of very nice features. Real time backup. Easy to scale up.
https://aws.amazon.com/rds/aurora/details/mysql-details/

The Windows instances AWS offers are easy to scale up as your installations grows.

GpsGate 5 can also run parts of the functionality in a cluster. We do not have any public guides (yet) on how to setup and manage a GpsGate cluster. Setup can currently only be done by GpsGate Support.


Regards,
Johan

GpsGate Support

[Hus]

hi
i am stuck in somewhere restoring database as in first step
kindly note that i have canceled the installation according to instructions and then i installed mysql and created same data base name same password, i have replaced the folders according to step 4
then i tried to restore the gpsgateserver.mysqldump file
the error is:
C:\PROGRA~1\MySQL\MySQL Server 5.5\bin>mysql.exe --database mygpsgateserver -h localhost -p123456 -u root < c:\gpsgateserver.mysqldump
ERROR 1064 (42000) at line 662: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''C:\\GpsGateServer\\Deploy\\DeployPackages\\com.GpsGate\\Core\\IIS\\Packages\\Gp' at line 1

C:\PROGRA~1\MySQL\MySQL Server 5.5\bin>

[Hus]

hi
the above procedure was correct 100% every thing is working perfectly now , as Johan told me via email it was database problem "database corrupted " try to make another backup .
i assumed sending the cause of the problem and the result will help others thanks for support

[Job Accommodation]

Hi Johan,

We have restored the mysql database and follow the rest of the GpsGate Server restore procedure. When we enter to the application in the server: http://localhost/GpsGateServer/VehicleT ... index.aspx and enter our username and password, we get this error:

Database error - could not fill data

How can we check the program is correctly connected to the database?

Thanks in advance!!!

[johan]

Check the log files for more specific errors.

Regards,
Johan

GpsGate Support

[Job Accommodation]

Hi Johan,

Thanks for your answer and sorry for being late. In the log files we get this error:

2012-10-11 11:59:25.2500 | Error | 6 | MySQLOdbcConnector.CheckReconnect | OdbcNativeError = 0 |
2012-10-11 11:59:25.2675 | Error | 6 | DAOBase.Update | System.Data.Odbc.OdbcException | System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 5.2(w) Driver][mysqld-5.1.66-community]Server does not support 4-byte encoded UTF8 characters.
en Franson.DAO.DAOConnector.RetryConnect(Exception ex, Boolean bThrow)
en Franson.DAO.DAOBase.Update()
2012-10-11 11:59:25.2880 | Error | 6 | LoggerImpl.Write | Table sessions |
2012-10-11 11:59:25.2880 | Error | 6 | LoginControl.Login | Exception during login | Error updating database (Franson.DAO.UpdateDBException)
en Franson.DAO.DAOBase.Update()
en Franson.DAO.DAOItem.Update()
en Franson.DAO.BOItem.Update()
en Franson.Directory.AuthenticationManager.Authenticate(String strUsername, String strPassword, String strSourceAddress, User userCustom, Session sessCustom)
en Franson.Directory.AuthenticationManager.Authenticate(String strUsername, String strPassword, String strSourceAddress)
en GpsGate.WebControls.LoginControl.Login(String strUsername, String strPassword)
ERROR [HY000] [MySQL][ODBC 5.2(w) Driver][mysqld-5.1.66-community]Server does not support 4-byte encoded UTF8 characters. (System.Data.Odbc.OdbcException)
en Franson.DAO.DAOConnector.RetryConnect(Exception ex, Boolean bThrow)
en Franson.DAO.DAOBase.Update()

We have not found anything useful in Google.

Looking forward for your answer.

Thanks in advance!!!

Regards,

[johan]

When I search for your error message "Server does not support 4-byte encoded UTF8 characters." on Google I get answers like:

http://stackoverflow.com/questions/1890 ... characters
http://drupal.org/node/1314214

Regards,
Johan

GpsGate Support

[sene]

Johan,

I have tried exactly the method describe in this guide but still i am not able to restore my database on a new server.

So i have tried by
1. Installing mysql on my new server
2. Create a database called gpsgateserver

I then run the restore script ""C:\Program Files\MySQL\MySQL Server 5.1\bin\mysql.exe" --database GpsGateServer -h localhost -ppassword -u root < C:\backups\GpsGateServer.mysqldump"

My dump is in the correct folder as well as the MySQL installation folder.

What am i missing?.

sene

[qtech]

hello

I migrate my data from mysql administrator and has work perfectly.

[piter197]

Hi Support,

My previous installation was in E:\GpsServer inside it with subfolder
E:\GpsServer\Deploy
E:\GpsServer\Franson NMEA Service
E:\GpsServer\IIS

How to restore this GGS installation to drive E:\ ? (other than default C:\GpsGateInstall)

Thank you.



Best Regards,
piter197

[adminlocjack]

hi support

i have a error when try to install the vehicular track

An error ocurred: could not copy application. Object reference not set to an instance of object

see the error log for more details

[rajiv]

Is there a guide for back and restore of MSSQL database ?

[abarnard]

Hi,

Wow - that worked flawlessly, I just migrated from an old machine to a new virtual machine inside our new server.

As I followed the flow as instructed and created the database before installing GpsGateServer on the new machine I needed to install MySQL without the assistance of the Gpsgate installer.

Just in case it helps anyone else:
- The ODBC drivers need to be installed separately before GPSgate but would not install on my machine (Win7) until the Microsoft visual C++ redistributable 2010 was installed (both 32-bit and 64-bit and it needed to be 2010 not 2015 for MySQL 5.7)

regards,
Andy

[rajiv]

We are planning to migrate our GPS gate to a new hosted site. This will change the current IP address of the gpsgate server will change and will involve changing the server IP addresses on devices , changing dns entry for the web site. I guess we will have to suspend NMEA services during the migration.

Can some one pl elaborate on detail migration procedure to be followed in this case ?

[johan]

A simple way to migrate, where new server has same IP address:

1. Stop your original server. (This will make all devices start buffer data).

2. Make a backup + restore to new server as described in this guide:
topic.asp?TOPIC_ID=13322

3. Check that you new server works.

4. Move new server to IP address of old server. Now all devices will start sending up buffered data.

A more advanced method to migrate, where new server has new IP address:

A useful tool for keeping the servers in sync during migration is the DataForward plugin.

DataForward the unmodified data sent from a device to one or many other servers. topic.asp?TOPIC_ID=16118

1. Setup DataForward on your original server to send data to the new (not yet existing server).

2. Stop your original server. (This will make all devices start buffer data).

3. Make a backup + restore to new server as described in this guide:
topic.asp?TOPIC_ID=13322

4. Check that you new server works.

5. Start your original server again. Now all devices will start sending up buffered data. And DataForward makes sure data comes to both original and new server.

6. Start migrating applications/devices to send data directly to new server.

Regards,
Johan

GpsGate Support