Gerasim is not working

Author	Message
SerVal Send message Joined: 1 Jan 20 Posts: 44 Credit: 26,247,629 RAC: 385,595	Message 3944 - Posted: 31 Aug 2025, 1:02:41 UTC Что случилось - я не знаю, но боюсь, что это надолго. :( ID: 3944 · Rating: 0 · rate: / Reply Quote

Eric Driver Project administrator Project developer Project tester Project scientist Send message Joined: 8 Jul 11 Posts: 1426 Credit: 786,485,349 RAC: 842,218	Message 3945 - Posted: 31 Aug 2025, 15:01:16 UTC - in response to Message 3944. Что случилось - я не знаю, но боюсь, что это надолго. :( Ok. Keep us updated. Thanks! ID: 3945 · Rating: 0 · rate: / Reply Quote

bluestang Send message Joined: 21 May 18 Posts: 10 Credit: 52,012,266 RAC: 351,038	Message 3946 - Posted: 1 Sep 2025, 18:45:29 UTC Explains the enormous amount of points now missing from accounts. ID: 3946 · Rating: 0 · rate: / Reply Quote

Skillz Send message Joined: 8 Jul 17 Posts: 13 Credit: 191,288,198 RAC: 1,477,802	Message 3947 - Posted: 2 Sep 2025, 1:02:20 UTC @SerVal I have a database backup of the gerasim credits for teams, hosts and users. If you need this to restore users/teams credits let me know I can provide it for you. ID: 3947 · Rating: 0 · rate: / Reply Quote

Skillz Send message Joined: 8 Jul 17 Posts: 13 Credit: 191,288,198 RAC: 1,477,802	Message 3948 - Posted: 2 Sep 2025, 2:04:09 UTC - in response to Message 3947. @SerVal I have a database backup of the gerasim credits for teams, hosts and users. If you need this to restore users/teams credits let me know I can provide it for you. Forgot to mention that it's from stats.xml files generated by the project before it went down. ID: 3948 · Rating: 0 · rate: / Reply Quote

SerVal Send message Joined: 1 Jan 20 Posts: 44 Credit: 26,247,629 RAC: 385,595	Message 3949 - Posted: 3 Sep 2025, 7:01:57 UTC - in response to Message 3948. @SerVal I have a database backup of the gerasim credits for teams, hosts and users. If you need this to restore users/teams credits let me know I can provide it for you. Forgot to mention that it's from stats.xml files generated by the project before it went down. Thank you, Skillz . Your help would be very welcome. I have a backup for the SQL server, the problem is that I can't use it! The SQL server starts and then stops. :( I think the best thing to do would be to kill these two unfortunate Databases: "Gerasim" and "GerasimScience". Then restore them from the backup. The main thing is to get the SQL server working. For now, I'm trying to restore it. ID: 3949 · Rating: 0 · rate: / Reply Quote

DKlimax Send message Joined: 8 Jun 23 Posts: 27 Credit: 37,678,979 RAC: 1,333	Message 3950 - Posted: 3 Sep 2025, 9:06:24 UTC - in response to Message 3949. Is there anything in Eventlog? (Not sure if you can access SQL's own, but some events get logged in Windows Event log under Applications) ID: 3950 · Rating: 0 · rate: / Reply Quote

SerVal Send message Joined: 1 Jan 20 Posts: 44 Credit: 26,247,629 RAC: 385,595	Message 3951 - Posted: 3 Sep 2025, 11:47:51 UTC - in response to Message 3950. Thanks for the response. DKlimax. I have 2 of my own computers (Windows 2016 & 2019). Yesterday I bought a clean HDD, installed Windows 2019. Today I installed SQL server, and I'm trying to fit a backup into it. .... Restore Database from backup failed. :( Never mind, we'll fit it in :) ID: 3951 · Rating: 0 · rate: / Reply Quote

Yeti Send message Joined: 30 Apr 18 Posts: 2 Credit: 57,973,901 RAC: 106,862	Message 3952 - Posted: 3 Sep 2025, 13:20:03 UTC - in response to Message 3951. Which SQL-Server ? Name, Version, ... ID: 3952 · Rating: 0 · rate: / Reply Quote

Skillz Send message Joined: 8 Jul 17 Posts: 13 Credit: 191,288,198 RAC: 1,477,802	Message 3953 - Posted: 3 Sep 2025, 13:20:23 UTC What kind of help do you need? I can assist if I'm able. ID: 3953 · Rating: 0 · rate: / Reply Quote

SerVal Send message Joined: 1 Jan 20 Posts: 44 Credit: 26,247,629 RAC: 385,595	Message 3954 - Posted: 3 Sep 2025, 15:59:07 UTC - in response to Message 3953. Which SQL-Server ? Name, Version, ... - Windows Server 2016 & 2019 Standard. Just restored Gerasim database from backup ( on second host). Restored, but very old - more than 5 years ago. Main SQL server still doesn't work. :( Http server IIS also doesn't work. ID: 3954 · Rating: 0 · rate: / Reply Quote

Skillz Send message Joined: 8 Jul 17 Posts: 13 Credit: 191,288,198 RAC: 1,477,802	Message 3955 - Posted: 3 Sep 2025, 22:14:11 UTC - in response to Message 3954. Which SQL-Server ? Name, Version, ... - Windows Server 2016 & 2019 Standard. Just restored Gerasim database from backup ( on second host). Restored, but very old - more than 5 years ago. Main SQL server still doesn't work. :( Http server IIS also doesn't work. What happened to the live/production database? Do you still have it or did you wipe it when you pulled a backup? What happened in the first place? What failed? What were the errors? What was the symptoms? ID: 3955 · Rating: 0 · rate: / Reply Quote

zlodeck Send message Joined: 14 May 18 Posts: 2 Credit: 7,417,117 RAC: 0	Message 3956 - Posted: 3 Sep 2025, 23:08:24 UTC - in response to Message 3955. Any changes at the moment? The start-and-immediate-stop issue of MS SQL - is it fixed now? ID: 3956 · Rating: 0 · rate: / Reply Quote

SerVal Send message Joined: 1 Jan 20 Posts: 44 Credit: 26,247,629 RAC: 385,595	Message 3957 - Posted: 4 Sep 2025, 3:02:30 UTC - in response to Message 3956. Any changes at the moment? The start-and-immediate-stop issue of MS SQL - is it fixed now? Пока всё также (никак). ID: 3957 · Rating: 0 · rate: / Reply Quote

zlodeck Send message Joined: 14 May 18 Posts: 2 Credit: 7,417,117 RAC: 0	Message 3958 - Posted: 4 Sep 2025, 5:00:30 UTC - in response to Message 3957. Ясно. Вроде как, один из вариантов подобного поведения - повреждение системных баз (master, tempdb..) Можно запустить с trace flag 3608 (указать сервису параметр запуска mssql.exe -T3608), тогда он будет восстанавливать master, а остальные проигнорирует. Ну или total reinstall. Возможно, и с виндой. ID: 3958 · Rating: 0 · rate: / Reply Quote

SerVal Send message Joined: 1 Jan 20 Posts: 44 Credit: 26,247,629 RAC: 385,595	Message 3959 - Posted: 4 Sep 2025, 10:41:46 UTC - in response to Message 3958. Вроде как, один из вариантов подобного поведения - повреждение системных баз (master, tempdb..) Можно запустить с trace flag 3608 (указать сервису параметр запуска mssql.exe -T3608), тогда он будет восстанавливать master, а остальные проигнорирует. Ну или total reinstall. Возможно, и с виндой. Злотек, Вы маленько отстали от событий. За прошедшие несколько дней я установил 2 базы данных, и одну Винду. подтвердит. :) Так что продвижение есть. И данные никуда не делись. А сейчас, Gerasim-у срочнейшим образом нужен специалист по настройке DNS. p.s Ах да. Во всём виноват электронный диск. Как-нибудь расскажу. :) ID: 3959 · Rating: 0 · rate: / Reply Quote

DKlimax Send message Joined: 8 Jun 23 Posts: 27 Credit: 37,678,979 RAC: 1,333	Message 3960 - Posted: 4 Sep 2025, 13:58:54 UTC - in response to Message 3954. Which SQL-Server ? Name, Version, ... - Windows Server 2016 & 2019 Standard. Just restored Gerasim database from backup ( on second host). Restored, but very old - more than 5 years ago. Main SQL server still doesn't work. :( Http server IIS also doesn't work. I wouldn't expect IIS to be affected too. Have you found anything in the Event Log? Many warnings and errors get logged there, they might provide some insight what's killing your server. Just a thought. Have you tried repair option? It was able to fix quite few instances. Another option would be to move data files out of datadir and do clean fresh install and reattach them after that. Another alternative would be to get datafiles to host with working SQL install and attach them there. ID: 3960 · Rating: 0 · rate: / Reply Quote

SerVal Send message Joined: 1 Jan 20 Posts: 44 Credit: 26,247,629 RAC: 385,595	Message 3966 - Posted: 8 Sep 2025, 15:05:10 UTC ========== Hello everyone! So, I installed HTTP server, SQL server, DNS server, and IISS admin. Theoretically, you can see what happened, but I can't! - certificates for HTTPS - are not there. Guys, tell me where these certificates are now found, and what to do with them. :) ========== Привет всем! Итак, я установил HTTP сервер, SQL сервер, DNS сервер, и IISS admin. Теоретически, можно смотреть что получилось, но не могу! - сертификатов для HTTPS - нетути. Ребятки, подскажете, где нынче водятся эти сертификаты, и что надо с ними делать. :) ID: 3966 · Rating: 0 · rate: / Reply Quote

Skillz Send message Joined: 8 Jul 17 Posts: 13 Credit: 191,288,198 RAC: 1,477,802	Message 3967 - Posted: 9 Sep 2025, 3:01:02 UTC I have absolutely no idea how Windows or IIS works. A quick Google search shows this. https://knowledge.digicert.com/quovadis/ssl-certificates/ssl-installation/how-do-i-install-an-ssl-certificate-into-microsoft-iis-10 This might all not even work on a BOINC installed setup though as that might need it's own certificate type. Again, I do not know. Certificates are only required for https. You can enable http to get the site back online and working (if its actually working) and then deal with the cert issue later. A lot of projects still use http anyway. ID: 3967 · Rating: 0 · rate: / Reply Quote

DKlimax Send message Joined: 8 Jun 23 Posts: 27 Credit: 37,678,979 RAC: 1,333	Message 3970 - Posted: 10 Sep 2025, 8:16:23 UTC - in response to Message 3966. ========== Hello everyone! So, I installed HTTP server, SQL server, DNS server, and IISS admin. Theoretically, you can see what happened, but I can't! - certificates for HTTPS - are not there. Guys, tell me where these certificates are now found, and what to do with them. :) ========== Привет всем! Итак, я установил HTTP сервер, SQL сервер, DNS сервер, и IISS admin. Теоретически, можно смотреть что получилось, но не могу! - сертификатов для HTTPS - нетути. Ребятки, подскажете, где нынче водятся эти сертификаты, и что надо с ними делать. :) Official documentation: https://learn.microsoft.com/en-us/iis/manage/configuring-security/how-to-set-up-ssl-on-iis Alt: https://woshub.com/install-ssl-certificate-iis-windows/ As for certificate location, they are in Certificate Store https://learn.microsoft.com/en-us/windows-hardware/drivers/install/certificate-stores ID: 3970 · Rating: 0 · rate: / Reply Quote