myusername = the username you want to give access to the database
mypassword = the password you want to assign to the user
sudo -u postgres psql
create database mydb;
create user myusername with encrypted password 'mypassword';
grant all privileges on database mydb to myusername;
I usually do not fear updates, but when it comes to databases, I am getting really careful with updating them. It wouldn’t be the first time when a database goes plonk after this.
So what happened? My MySQL docker got updated becuase I simply misclicked and of course, the thing broke. The update script, which was set to “latest”, performed an upgrade to 9.x instead of sticking to the latest 8.x version.
After some research, I read that one can enter “mysql:8.2.0” in the repository field. After entering this and starting the docker, the software got reinstalled with the proper version and everything worked again. I must’ve been lucky that the database itself was not migrated to v9 already, I guess.
I found in my notes from 2017 a method to fix the header of a M4A file. Appartently I needed this back then to repair a file, and then forgot about the note. So here ya go:
ffmpeg -f aac -analyzeduration 100M -probesize 100M -i broken.m4a -c copy fixed.m4a
I happily run my own OpenSim server that is hooked onto OSGrig.org. My account there dates from 2007 and it got broken after the big crash in 2010.
It took quite a long time for them to restore the data and after a few years I decided to go back and see if i could revive my sims from the backups. And in 2013, I did so, successfully. You have no idea how great it is to see a backup rise from the dust and see, live, a sim being rebuilt. Since then, another 9 sims have been added and more landscaping has been done. Go have a look!
Sometimes though, my server crashes and I think I have now fixed it. Perhaps things got a bit too busy on a few cores, so I reserved 4 specifically for this server. Let’s see how that works! ^^
If the link to the grid does not work then open your viewer, log into the OSGrid and look for one of the following sims:
RynFox HQ1
RynFox HQ2
Himalchuli
Cho Oyu
Pumori
Saipal
Nuptse
Annapurna
Makalu
Yangra
Shishapangma
Lhotse
Jannu
Kangchenjunga
Dhaulagiri
Manaslu
If you detect a recurring theme in this list, then you are absolutely right 😉
It is the second time that I have to fix this issue where the trigger fails to release the hammer.
Symptom: The lever is not closing completely and then you cannot pull the trigger.
Cause: There is a small piece of steel in the “roof” of the action that has come loose and slides forward.
Fix: Fix the steel insert in its place, now with a much stronger adhesive. I used Loctite 648 this time.
Okay, first you need to make everything super clean and free of grease. Then you sand the slot with some fine sanding paper first as another cleaning step and then you use a coarser sanding paper to roughen up the surface.
Next, clean the insert thoroughly and use fine sanding paper first, then coarser paper.
I chose for a stronger loctite this time, because I want to wait with more intrusive ways to affix this part. Have I noted that this part should never have come out in the first place? It’s not even noted in any parts list…
There, all fitted together and now I will give it plenty time to dry and cure. Was briefly pondering about heating it up, but that’s a bit of a weird thing to do with glue as you can also often use heat to undo glued together parts.
I’ll go try it out tomorrow with some beefy ammo. I bought CCI EX Stingers that will yeet the nope with 1640 feet per second. If that breaks the glue bond, I’ll have to figure out another way to affix the insert.