m_manager(new QNetworkAccessManager),

m_progress(nullptr),

m_currentReply(nullptr)

{

// Set up SSL configuration

m_sslConfiguration = QSslConfiguration::defaultConfiguration();

m_sslConfiguration.setPeerVerifyMode(QSslSocket::VerifyPeer);

// Load CA certs from resource file

QDir dirCaCerts(":/certs");

QStringList caCertsList = dirCaCerts.entryList();

QList<QSslCertificate> caCerts;

foreach(const QString& caCertName, caCertsList)

caCerts += QSslCertificate::fromPath(":/certs/" + caCertName);

m_sslConfiguration.setCaCertificates(caCerts);

// Load settings and set up some more stuff while doing so

reloadSettings();

// Set up signals

connect(m_manager, &QNetworkAccessManager::finished, this, &RemoteDatabase::gotReply);

connect(m_manager, &QNetworkAccessManager::encrypted, this, &RemoteDatabase::gotEncrypted);

connect(m_manager, &QNetworkAccessManager::sslErrors, this, &RemoteDatabase::gotError);

{

// Load all configured client certificates

m_clientCertFiles.clear();

auto client_certs = Settings::getSettingsValue("remote", "client_certificates").toStringList();

foreach(const QString& path, client_certs)

{

QFile file(path);

file.open(QFile::ReadOnly);

QSslCertificate cert(&file);

file.close();

m_clientCertFiles.insert(path, cert);

}

// TODO Add support for proxies here

{

// Check if network is accessible. If not, abort right here

if(m_manager->networkAccessible() == QNetworkAccessManager::NotAccessible)

{

QMessageBox::warning(0, qApp->applicationName(), tr("Error: The network is not accessible."));

return;

}

// Check if client cert exists

bool https = QUrl(url).scheme().compare("https", Qt::CaseInsensitive) == 0;

const QSslCertificate& cert = m_clientCertFiles[clientCert];

if(https && cert.isNull())

{

QMessageBox::warning(0, qApp->applicationName(), tr("Error: Invalid client certificate speicified."));

return;

}

// Build network request

QNetworkRequest request;

request.setUrl(url);

request.setRawHeader("User-Agent", QString("%1 %2").arg(qApp->organizationName()).arg(APP_VERSION).toUtf8());

// Set SSL configuration when trying to access a file via the HTTPS protocol

if(https)

{

// Load private key for the client certificate

QFile fileClientCert(clientCert);

fileClientCert.open(QFile::ReadOnly);

QSslKey clientKey(&fileClientCert, QSsl::Rsa, QSsl::Pem, QSsl::PrivateKey);

while(clientKey.isNull())

{

// If the private key couldn't be read, we assume it's password protected. So ask the user for the correct password and try reading it

// again. If the user cancels the password dialog, abort the whole process.

QString password = QInputDialog::getText(0, qApp->applicationName(), tr("Please enter the passphrase for this client certificate in order to authenticate."));

if(password.isEmpty())

return;

clientKey = QSslKey(&fileClientCert, QSsl::Rsa, QSsl::Pem, QSsl::PrivateKey, password.toUtf8());

}

fileClientCert.close();

// Set client certificate (from the cache) and private key (just loaded)

m_sslConfiguration.setLocalCertificate(cert);

m_sslConfiguration.setPrivateKey(clientKey);

// Apply SSL configuration

request.setSslConfiguration(m_sslConfiguration);

}

// Fetch database and save pending reply. Note that we're only supporting one active download here at the moment.

m_currentReply = m_manager->get(request);

// Initialise the progress dialog for this request

if(!m_progress)

m_progress = new QProgressDialog();

m_progress->setWindowModality(Qt::ApplicationModal);

m_progress->setCancelButtonText(tr("Cancel"));

m_progress->setLabelText(tr("Downloading remote database from\n%1.").arg(url));

m_progress->show();

qApp->processEvents();

connect(m_currentReply, &QNetworkReply::downloadProgress, this, &RemoteDatabase::updateProgress);

{

// Verify the server's certificate using our CA certs

auto verificationErrors = reply->sslConfiguration().peerCertificate().verify(m_sslConfiguration.caCertificates());

bool good = false;

if(verificationErrors.size() == 0)

{

good = true;

} else if(verificationErrors.size() == 1) {

// Ignore any self signed certificate errors

if(verificationErrors.at(0).error() == QSslError::SelfSignedCertificate || verificationErrors.at(0).error() == QSslError::SelfSignedCertificateInChain)

good = true;

}

// If the server certificate didn't turn out to be good, abort the reply here

if(!good)

reply->abort();

{

// Check if request was successful

if(reply->error() != QNetworkReply::NoError)

{

QMessageBox::warning(0, qApp->applicationName(),

tr("Error opening remote database file from %1.\n%2").arg(reply->url().toString()).arg(reply->errorString()));

reply->deleteLater();

return;

}

// Ask user where to store the database file

QString saveFileAs = FileDialog::getSaveFileName(0, qApp->applicationName(), FileDialog::getSqlDatabaseFileFilter(), reply->url().fileName());

if(!saveFileAs.isEmpty())

{

// Save the downloaded data under the selected file name

QFile file(saveFileAs);

file.open(QIODevice::WriteOnly);

file.write(reply->readAll());

file.close();

// Tell the application to open this file

emit openFile(saveFileAs);

}

// Delete reply later, i.e. after returning from this slot function

m_currentReply = nullptr;

m_progress->hide();

reply->deleteLater();

{

// Are there any errors in here that aren't about self-signed certificates and non-matching hostnames?

// TODO What about the hostname mismatch? Can we remove that from the list of ignored errors later?

bool serious_errors = false;

foreach(const QSslError& error, errors)

{

if(error.error() != QSslError::SelfSignedCertificate && error.error() != QSslError::HostNameMismatch)

{

serious_errors = true;

break;

}

}

// Just stop the error checking here and accept the reply if there were no 'serious' errors

if(!serious_errors)

{

reply->ignoreSslErrors(errors);

return;

}

// Build an error message and short it to the user

QString message = tr("Error opening remote database file from %1.\n%2").arg(reply->url().toString()).arg(errors.at(0).errorString());

QMessageBox::warning(0, qApp->applicationName(), message);

// Delete reply later, i.e. after returning from this slot function

m_progress->hide();

reply->deleteLater();

{

// Update progress dialog

if(bytesTotal == -1)

{

// We don't know anything about the current progress, but it's still downloading

m_progress->setMinimum(0);

m_progress->setMaximum(0);

m_progress->setValue(0);

} else if(bytesReceived == bytesTotal) {

// The download has finished

m_progress->hide();

} else {

// It's still downloading and we know the current progress

m_progress->setMinimum(0);

m_progress->setMaximum(bytesTotal);

m_progress->setValue(bytesReceived);

}

// Check if the Cancel button has been pressed

qApp->processEvents();

if(m_currentReply && m_progress->wasCanceled())

{

m_currentReply->abort();

m_progress->hide();

}