Fortinac-F Upload database backup via WinSCP

[doncacciatoconsuting]

The goal is to restore a saved database from my PC to a new Fortinac build running Forti-OS v7.2.8.

Following this article.

https://community.fortinet.com/t5/FortiNAC/Technical-Tip-Restore-FortiNAC-Database-from-CLI/ta-p/201...

Having two issues:

1- Using WinSCP, I connect to Fortinac, get authenticated, but it stalls out at "starting the session". Same result on multiple NAC appliances.

2- Looking at my directory structure in the linux shell, I do not even have this directory: "/bsc/campusMgr/master_loader/mysql/"

Any ideas ?

[ebilcari · Accepted solution]

This guide is based on older version of FNAC running in CentOS. In FNAC-OS, Winscp can no longer be used but FNAC can still transfer files using SCP, FTP and TFTP, some details can be found here.

For the database restore there is a direct command that can be used:

# execute restore database scp
Usage: execute restore database scp <host> <username> <password> <backup>
Restore database using a remote database backup downloaded via scp
<host> Remote host
<username> Remote username
<password> Remote password
<backup> Path to database backup on remote host (.gz)

Also FTP or TFTP can be used to first copy the old database in this path '/bsc/backups/database/' and than use the local restore command: # execute restore database local

[doncacciatoconsuting]

thanks, that worked perfectly !