How old is this backup?

- September 9th. But there is no backup.
It's a standalone workstation. Current location - my kitchen.
I'll check now if it has its own database.
There are also overdue tasks. But probably no more than 200-400 of them.
I see two projects in BOINC Manager: H@F and Gerasim@home.
I'll go to the kitchen now and see what else is there.
:)

But Gerasim crashed on August 31. Have you figured out time travel?

====
Gerasim is not the only one like this.
And each Gerasim operates with his own SQL server, or with a link to a shared SQL DB.
And it seems it's time to make a manual text copy of the Gerasim server.
Starting with "create database" and ending with "xml restore DB, countries, users, teams..." and the project on GitHub.
This should have been done a long time ago, but...
====
That's how it is, guys.
Hello everyone and have a good mood. :)

SerVal has a backup of the Gerasim databases dated 10 days prior to the crash. I downloaded the files to my linux box, installed microsoft SQL server, restored the databases, and ran dbcc to check their integrity. The databases are good. I perused some of the tables; there is a lot of data there and it all appears to be in working order.

My suggestion is to use these backups to restore the databases on the Gerasim server. This would leave us with only 10 days of lost credit. I already have the results from about 5 days prior to the crash, so it doesn't help with that.
1. I would help with this myself, but am not familiar with Microsoft databases. Maybe someone else familiar with database administration on Microsoft could help. It's a matter of getting SerVal's permission, logging in remotely, and then doing the restore.
2. I think SerVal has some backend scripts for doing various functions, and he might want to get that working first before restoring the databases. For example, I upload tasks via a zip file and the website automatically generates the work. I believe much of this is SerVal's home brew and I don't understand how it interfaces with the normal BOINC server. That makes it hard to help, not to mention the language barrier.

Hopefully this can get the discussion going...

If I can get a copy of this database I can see what I can do on it. I'm not familiar with Microsoft databases, but have some pretty decent knowledge on MySQL/MariaDB. I maintain a rather large one after all.

What I would probably end up doing is just converting that database to MySQL since that's what BOINC uses natively anyway. Getting it setup and working in a Linux environment. Then figuring out how to export that data in a format that Microsoft datbase can use or just running the project with Linux and the native BOINC Linux server like it was intended in the first place.

Assuming the database isn't damaged beyond repair though.

Their are already tools available to convert MSSQL to MySQL and vise verse. Its just a matter of making sure the database isn't corrupted before doing so. Otherwise you'll have to repair the database.

SerVal has a backup of the Gerasim databases dated 10 days prior to the crash. I downloaded the files to my linux box, installed microsoft SQL server, restored the databases, and ran dbcc to check their integrity. The databases are good. I perused some of the tables; there is a lot of data there and it all appears to be in working order.

My suggestion is to use these backups to restore the databases on the Gerasim server. This would leave us with only 10 days of lost credit. I already have the results from about 5 days prior to the crash, so it doesn't help with that.
1. I would help with this myself, but am not familiar with Microsoft databases. Maybe someone else familiar with database administration on Microsoft could help. It's a matter of getting SerVal's permission, logging in remotely, and then doing the restore.
2. I think SerVal has some backend scripts for doing various functions, and he might want to get that working first before restoring the databases. For example, I upload tasks via a zip file and the website automatically generates the work. I believe much of this is SerVal's home brew and I don't understand how it interfaces with the normal BOINC server. That makes it hard to help, not to mention the language barrier.

Hopefully this can get the discussion going...

If I can get a copy of this database I can see what I can do on it. I'm not familiar with Microsoft databases, but have some pretty decent knowledge on MySQL/MariaDB. I maintain a rather large one after all.

What I would probably end up doing is just converting that database to MySQL since that's what BOINC uses natively anyway. Getting it setup and working in a Linux environment. Then figuring out how to export that data in a format that Microsoft datbase can use or just running the project with Linux and the native BOINC Linux server like it was intended in the first place.

Assuming the database isn't damaged beyond repair though.

Their are already tools available to convert MSSQL to MySQL and vise verse. Its just a matter of making sure the database isn't corrupted before doing so. Otherwise you'll have to repair the database.

I have copies of the backups that I could get to you. They are ~3.7 GB so I will need to upload them to Google Drive.

Note there are 2 databases - the standard BOINC database and then a science database where results were stored. I'm pretty sure they are good since they passed the dbcc check with no errors.

But what is the objective here? Converting to MySQL does no good if SerVal plans to host Gerasim as he has in the past, using microshit SQL.

Its with my understanding that the hacked up job of getting a BOINC Server running on Windows isn't working. No one knows how to fix this as it's a territory no one has done before except the Gerasim project. Since the database is in MSSQL just running it on Linux wont be possible afaik and it will need to be converted to MySQL.

No one knows how to fix this
But if you want to, you can try.
Does MySQL have insert, select, update, and execute stored procedure?
I can tell you how do it without convert DB -> <- туда сюда и обратно. :)

I have over a decade of experience with microsoft SQL and servers.

Serval, I can help. Will need to ask you some questions. I'd prefer to get onto an instant messenger like Discord or whatsapp to discuss

Just read more of the thread. Microsoft SQL can absolutely be run on linux fully natively. Its not 2010 anymore😆

I have over a decade of experience with microsoft SQL and servers.

Serval, I can help. Will need to ask you some questions. I'd prefer to get onto an instant messenger like Discord or whatsapp to discuss

If you can work with SerVal and figure out what he needs, that would be great.

But I think we still need a game plan. From my understanding, the problem is more than the database. Here's what I think needs to be done:
1. Get the Gerasim server working as it was before, with a new empty database. This is the hard part because SerVal is doing this under windows but BOINC was designed for linux. For this reason, most project admins don't have a clue how to help.
2. Use the backups of the old database to restore all the user accounts and their credits. This *should* be easy for an expert with MS-SQL.

I have over a decade of experience with Microsoft SQL and servers.
Microsoft SQL can absolutely be run on Linux fully natively. It's not 2010 anymore.
I have no doubt. But why?
====
I would prefer to discuss this in a messenger, for example, in Discord or WhatsApp.
* Google is heavily restricted in Russia. And Discord, WhatsApp and VPN are completely banned. :(
====
Maybe we should start here using PM? We can't do without Eric anyway.
I don't even have WU for testing - 2-3k...
Write your questions in PM and I will definitely answer them.
Regards, SerVal
====
p.s. I don't write English well, but I think better than you write in Russian. :)

I don't even have WU for testing - 2-3k...

I will get you some WUs for testing.

I have messaged you both Serval and Eric to get your discord details

I have messaged you both Serval and Eric to get your discord details

I sent you my username. But SerVal stated that discord is banned in Russia...

I missed that. Let me rather get your email addresses. I need both of you to have visibility of the same discussion so you can chime in as needed, so the PM system on this forum is not going to work.

Did you try Telegram?

I see the Gerasim website is up and the server status page claims to have work available to send out and work outstanding.

PROJECT FORUMS ARE NOT AVAILABLE.

None of my computers can get work and my Linux/Ubuntu box lost all its credits and every time it contact the project it gets a new ID.

The accounts and credits have been restored
very well,
but I want to join the project with a new PC, which is not possible at the moment.
Otherwise, congratulations, very good work.

There has been no official announcement about the project's restoration yet.
Restoration work is still ongoing.
There could be various glitches.
I hope SerVal will update everyone when everything is back to normal.

Try "reset" the project in Boinc-Manager and then "update" it.

On Gerasim one of my computers can't be seen when listing my computers.
I can only see it when I click on Your Results.
It is computer Host 61551 and shows as "Anonymous Computer 61551"

Any way to make it not anonymous?

Conan

EDIT:: Also like Dr Who Fan, when updating my existing computers Gerasim gives a new ID and lists the computer more than once.
Possibly due to [error] Missing code sign key signature

---

Got it.
Thank you.
We'll check that out.

UPDATE: Sorry. But this ID (61551) belongs to another user from another team, has a different crossproject-ID.

I suspect your new computer hasn't registered.
Try re-registering it.

UPDATE 2:
Check yours id 62493, 63122, 65973