void* RestoreThread::Entry()
{
wxDateTime now;
wxString msg;
try
{
msg.Printf(_("Connecting to server %s..."), serverM.c_str());
logImportant(msg);
IBPP::Service svc = IBPP::ServiceFactory(wx2std(serverM),
wx2std(usernameM), wx2std(passwordM));
svc->Connect();
now = wxDateTime::Now();
msg.Printf(_("Database restore started %s"), now.FormatTime().c_str());
logImportant(msg);
svc->StartRestore(wx2std(bkfileM), wx2std(dbfileM), pagesizeM, brfM);
while (true)
{
if (TestDestroy())
{
now = wxDateTime::Now();
msg.Printf(_("Database restore canceled %s"),
now.FormatTime().c_str());
logImportant(msg);
break;
}
const char* c = svc->WaitMsg();
if (c == 0)
{
now = wxDateTime::Now();
msg.Printf(_("Database restore finished %s"),
now.FormatTime().c_str());
logImportant(msg);
break;
}
msg = c;
logProgress(msg);
}
svc->Disconnect();
}
catch (IBPP::Exception& e)
{
now = wxDateTime::Now();
msg.Printf(_("Database restore canceled %s due to IBPP exception:\n\n"),
now.FormatTime().c_str());
msg += e.what();
logError(msg);
}
catch (...)
{
now = wxDateTime::Now();
msg.Printf(_("Database restore canceled %s due to exception"),
now.FormatTime().c_str());
logError(msg);
}
return 0;
}
//-----------------------------------------------------------------------------
bool Server::getService(IBPP::Service& svc, ProgressIndicator* progressind,
bool sysdba)
{
if (progressind)
{
progressind->initProgress(_("Connecting..."),
databasesM.size() + 2, 0, 1);
}
// check if we already had some successful connections
if (!serviceSysdbaPasswordM.isEmpty()) // we have sysdba pass
{
if (progressind)
{
progressind->setProgressMessage(_("Using current SYSDBA password"));
progressind->stepProgress();
}
try
{
svc = IBPP::ServiceFactory(wx2std(getConnectionString()),
"SYSDBA", wx2std(serviceSysdbaPasswordM));
svc->Connect();
return true;
}
catch(IBPP::Exception&) // keep going if connect fails
{
serviceSysdbaPasswordM.clear();
}
}
if (progressind && progressind->isCanceled())
return false;
// check if we have non-sysdba connection
if (!sysdba && !serviceUserM.isEmpty())
{
if (progressind)
{
progressind->setProgressMessage(QString::fromLatin1("Using current %1 password")
.arg(serviceUserM));
progressind->stepProgress();
}
try
{
svc = IBPP::ServiceFactory(wx2std(getConnectionString()),
wx2std(serviceUserM), wx2std(servicePasswordM));
svc->Connect();
return true;
}
catch(IBPP::Exception&) // keep going if connect fails
{
serviceUserM.clear();
servicePasswordM.clear();
}
}
// first try connected databases
for (DatabasePtrs::iterator ci = databasesM.begin();
ci != databasesM.end(); ++ci)
{
if (progressind && progressind->isCanceled())
return false;
if (!(*ci)->isConnected())
continue;
// Use the user name and password of the connected user
// instead of the stored ones.
IBPP::Database& db = (*ci)->getIBPPDatabase();
if (sysdba && std2wx(db->Username()).toUpper() != QString::fromLatin1("SYSDBA"))
continue;
if (progressind)
{
progressind->setProgressMessage(_("Using password of: ") +
std2wx(db->Username()) + QString::fromLatin1("@") + (*ci)->getName_());
progressind->stepProgress();
}
try
{
svc = IBPP::ServiceFactory(wx2std(getConnectionString()),
db->Username(), db->UserPassword());
svc->Connect();
if (sysdba)
serviceSysdbaPasswordM = std2wx(db->UserPassword());
else
{
serviceUserM = std2wx(db->Username());
servicePasswordM = std2wx(db->UserPassword());
}
return true;
}
catch(IBPP::Exception&) // keep going if connect fails
{
}
}
// when the operation is not canceled try to user/pass of disconnected DBs
for (DatabasePtrs::const_iterator ci = databasesM.begin();
ci != databasesM.end(); ++ci)
{
if (progressind && progressind->isCanceled())
return false;
if ((*ci)->isConnected())
continue;
QString user = (*ci)->getUsername();
QString pwd = (*ci)->getDecryptedPassword();
if (pwd.isEmpty() || sysdba && user.toUpper() != QString::fromLatin1("SYSDBA"))
continue;
if (progressind)
{
progressind->setProgressMessage(_("Using password of: ") +
user + QString::fromLatin1("@") + (*ci)->getName_());
progressind->stepProgress();
}
try
{
svc = IBPP::ServiceFactory(wx2std(getConnectionString()),
wx2std(user), wx2std(pwd));
svc->Connect();
if (sysdba)
serviceSysdbaPasswordM = pwd;
else
{
serviceUserM = user;
servicePasswordM = pwd;
}
return true;
}
catch(IBPP::Exception&) // keep going if connect fails
{
}
}
return false;
}
bool DatabaseInfoHandler::handleURI(URI& uri)
{
bool isEditSweep, isEditForcedWrites, isEditReserve, isEditReadOnly,
isEditPageBuffers;
isEditSweep = (uri.action == "edit_db_sweep_interval");
isEditForcedWrites = (uri.action == "edit_db_forced_writes");
isEditReserve = (uri.action == "edit_db_reserve_space");
isEditReadOnly = (uri.action == "edit_db_read_only");
isEditPageBuffers = (uri.action == "edit_db_page_buffers");
if (!isEditSweep && !isEditForcedWrites && !isEditReserve
&& !isEditReadOnly && !isEditPageBuffers)
{
return false;
}
DatabasePtr d = extractMetadataItemPtrFromURI<Database>(uri);
wxWindow* w = getParentWindow(uri);
// when either the database or the window does not exist
// return immediately. Because this function returns whether
// the specified uri is handled, return true.
if (!d || !w || !d->isConnected())
return true;
IBPP::Database& db = d->getIBPPDatabase();
IBPP::Service svc = IBPP::ServiceFactory(
wx2std(d->getServer()->getConnectionString()),
db->Username(), db->UserPassword());
svc->Connect();
if (isEditSweep || isEditPageBuffers)
{
long oldValue = 0;
wxString title, label;
if (isEditSweep)
{
oldValue = d->getInfo().getSweep();
title = _("Enter the new Sweep Interval");
label = _("Sweep Interval");
}
else if (isEditPageBuffers)
{
oldValue = d->getInfo().getBuffers();
title = _("Enter the new value for Page Buffers");
label = _("Page Buffers");
}
while (true)
{
wxString s;
long value = oldValue;
s = ::wxGetTextFromUser(title, label,
wxString::Format("%d", value), w);
// return from the iteration when the entered string is empty, in
// case of cancelling the operation.
if (s.IsEmpty())
break;
if (!s.ToLong(&value))
continue;
// return from the iteration when the interval has not changed
if (value == oldValue)
break;
if (isEditSweep)
svc->SetSweepInterval(wx2std(d->getPath()), value);
else if (isEditPageBuffers)
svc->SetPageBuffers(wx2std(d->getPath()), value);
// Before reloading the info, re-attach to the database
// otherwise the sweep interval won't be changed for FB Classic
// Server.
db->Disconnect();
db->Connect();
d->loadInfo();
break;
}
}
else if (isEditForcedWrites || isEditReserve || isEditReadOnly)
{
bool fw = !d->getInfo().getForcedWrites();
bool reserve = !d->getInfo().getReserve();
bool ro = !d->getInfo().getReadOnly();
// setting these properties requires that the database is
// disconnected.
db->Disconnect();
if (isEditForcedWrites)
svc->SetSyncWrite(wx2std(d->getPath()), fw);
if (isEditReserve)
svc->SetReserveSpace(wx2std(d->getPath()), reserve);
if (isEditReadOnly)
svc->SetReadOnly(wx2std(d->getPath()), ro);
db->Connect();
// load the database info because the info values are changed.
d->loadInfo();
}
svc->Disconnect();
return true;
}