u/MrGuam

hi, first time using a vps and i just one today (ovh vps). tried doing the basic securing of the vps and ran into some trouble where i tried to set the ssh pub key but after manually setting the key in authorized_keys, i could not ssh into the server anymore. it just gets stuck without returning anything. or granting access. when i tried it but with loggin this was the log

debug1: Offering public key: /[home directore redacted for security reasons]/.ssh/id_ed25519 ED25519 SHA256:Cve1[redacted for security reasons] agent debug3: send packet: type 50 debug2: we sent a publickey packet, wait for reply debug3: receive packet: type 51 debug1: Authentications that can continue: publickey,password debug1: Offering public key: [local machine root & host] ED25519 SHA256:TcH[redacted for security reasons] agent debug3: send packet: type 50 debug2: we sent a publickey packet, wait for reply debug3: receive packet: type 60 debug1: Server accepts key: [local machine root & host] ED25519 SHA256:TcH[redacted for security reasons] agent debug3: sign_and_send_pubkey: using publickey-hostbound-v00@openssh.com with ED25519 SHA256:TcH[redacted for security reasons]debug3: sign_and_send_pubkey: signing using ssh-ed25519 SHA256:TcH[redacted for security reasons]

i'm not sure what the error is and i've tried debugging in rescue mode but just couldnt work. so i want to reinstall the vps from ovh console. but now i'm not sure which to choose. the first time it came with ubuntu 26, but i'm thinking 24 might not give me the issue this one just gave me.

i may not explain things properly, thanks for your assistance in advance!

What’s the systems design behind Spotify’s now playing sync between devices and it can resume the song from where it was on the other device ??

What’s the systems design behind Spotify’s now playing sync between devices and it can resume the song from where it was on the other device ??

I have been handed a project that uses mysql and the db already has some data that cant be lost. i want to migrate the database to postgres because i'm more comfortable working with mysql and it doesn't have some annoying nuances. i have a dump file from the db and i have explored a lot of options like using pgloader, but pgloader doesnt work with this error

2026-06-30T15:59:44.235006Z ERROR mysql: Failed to connect to mysql at "localhost" (port 3306) as user "pgloader": Condition QMYND:MYSQL-UNSUPPORTED-AUTHENTICATION was signalled. (pgloader is a user i created just to by pass the caching_sha2_password issue ).

i have tried to manually modify the dump sql file and alter all the conflicts that may arise from things like datetime, bigint, enums and the id's not incrementing from the max id etc. i'm pretty sure there's going to be a bug and i need a better way to achieve this. Are there any services like pgloader that can make this easier. thanks in advance!

Edit: I found a solution with pgloader v4.0.0 and it worked by creating a migration.load file to specify the type casting I wanted etc. and running it as specified in the docs

i want to set up a cron job to perform scheduled backups of my postgresdb in my docker container. what is the best way to go about it? do i use docker exec to achieve this?

not sure i'm explaining it well, but i want to get analytics data when a link is clicked in Express js. i'm currently using express-useragent middleware, but is there a better way to get more precise analytics data like location and language etc?

Hi, new to using docker and i keep failing to understand how this should work. AI is not giving me the type of answer thats convincing enough so i need a form of human intervention.

i'm trying to set use docker for my small project. mostly for learning purposes, but intend to also have it hosted on a vps later.

now, from the documentation on the official docker webstie, they seem to be mixing both dev and prod in the same file. is this the right approach? my node app runs fine locally on my device, but i want to move it into a container. the section where there's " volumes" it has the postgres volume and others but not in the one for dev. AI suggested a docker compose override file, but i dont know if thats the best way of going about it. also i want to use nginx, rabbitmq (not installed yet) and redis (locally installed on my fedora) for the project, but inside the docker container.

pardon my question being everywhere but it's all jumbled up in my head and i am not seeing any youtube video talking about this particular situation (i also dont want to have to sit through 1h+ tutorial). i want to learn it as i build. please any help would be greatly appreciated, thx!