Posts made by Mario Jakovina

Hello everybody!
(I'm sad to see Mangolassi dead, but here is a topic from me)

1. Can you give me some recommendation for new home Wifi router?
Here is description of my "system":

• internet link is 300/30 Mbps
• 15 devices should be connected to it (6 phones, 4 laptops, 3 TVs, one WiFi access point + occasionally ,some guest or our HTPC
• of these 15 devices, 3 should be connected via LAN (2 TVs, one HTPC), others via WiFi

Reason for buying is that my internet provider changed the router type (after upgrade of speed from 200/20 to 300/30, but this new device seems to struggle with the load).

2. Is there some Mikrotik device that you would recommend for this? (we have good local Mikrotik dealer here)

3. If I put telecom's router in "bridge mode" and put better router behind it, is it reasonable to expect that the telecom's router's should not be a noticeable bottleneck (or not as much)?

Thank you

@WLS-ITGuy If you wanted to say that old domain is part of usernames, and you want to change only that part of the usernames, there is no single SQL statement, but I see 2 solutions:

1. Write SQL script that will use LOOP to iterate through all records in table users and then replace username with new username....

2. Use spreadsheet calculator (Excel or similar) to prepare multiple simple SQL UPDATE statements:

• Export table "users" (just necessary columns) and import it to Excel or similar _ - prepare new usernames in new column (use SUBSTITUTE() function in Excel)
• prepare simple UPDATE command for each username (in new column in Excel) - you can use functions like SUBSTITUTE or CONCATENTE to prepare you UPDATE statements with your usernames from previous column, i.e. =CONCATENATE("UPDATE users SET username = '", ....
• copy UPDATE statements from Excel and execute them

I think secong approach (Excel) is much safer because you see results in spreadsheet before you execute UPDATEs.
Always use WHERE clause when you use UPDATE

If you want more exact statements/formulas, give more detailed structure of your table and usernames

@Woti said in Fedora 39 Server as host with HAproxy and Qemu/KVM virtual machines. Trouble with communication.:

Yes, I tried bridge mode. That hadn't worked. But I found the error at least and the bridge between the host and the VMs works now. I can ping the VMs from the host and vice versa, with IP address and domain name.

However, I can only reach the VMs via their local IP address, not via the domains when using a browser.

I think you should first solve the issue why you can't reach your VMs from outside your LAN (I mean before you setup HAproxy).
I would first test, can I reach them via external IP address. (have you tried this?)
If that is OK, then test access via DynDNS domain.

@Woti How many LAN cards/ports do you have on your physical host?

If you want to share the same physical LAN for multiple VMs, you need to use "Bridged mode", not "Direct attachment".

Have you even tried with Bridged mode?

@Woti said in Fedora 39 Server as host with HAproxy and Qemu/KVM virtual machines. Trouble with communication.:

With my DynDNS provider I have created corresponding domains for the respective VMs,

Why would you need more then one DynDNS domain for your VMs, if they are both on same external IP?
(I know this is not the question, but I wonder)

@nadnerB said in One app to rule them all:

It'll have to be hosted/cloud based, as none of them have an inkling about technical setup/maintenance

Nextcloud at hetzner.com starts at 4,29 EUR/month (5 USD) for 1TB space
https://www.hetzner.com/storage/storage-share/

I use them for years

@scottalanmiller said in Can you run a Windows desktop OS as a server to run AVImark Veterinary Software?:

Why is it piracy?

Windows Server 2022 and CALs are not a separate product or code base from Windows 11. Windows 11 is a limited use case of Windows 2022 under which you commit to not using the Server 2022 features.

While I agree this is piracy, I do not agree with you reasoning.

W11 and WinServer2022 are different products because MS said so!!!
They package them with different features and license rights, different brand names....
So they are different products in many imporant aspects: marketing, legal....

Volkswagen and Audi cars also have very much in common under the hood, but they are not same products.

@scottalanmiller said in Is it racist? I think it is.:

@Mario-Jakovina said in Is it racist? I think it is.:

On the other hand, I do not find it "discriminatory" either.

It's literally a mechanism to discriminate by the perceived ownership of an IP address by a group of people. It's as discriminatory as it gets.

No it is not.
It's literally a mechanism to block access from certain IP adresses.

Is it discriminatory or not? It depend on the motives of those who set up geoblocking on that site.

Without knowing the motives, you cannot prove is it discriminatory or not.
I do not find it discriminatory - You are free to feel it is discriminatory.
Neither of us have a proof.

@CCWTech said in Is it racist? I think it is.:

@Mario-Jakovina said in Is it racist? I think it is.:

@CCWTech said in Is it racist? I think it is.:

https://gephardtdaily.com/

There is one example.

It is geo blocked in my country.
But I do not find it racist

Should we call it unnecessarily discriminatory (Instead of racist?)

Yes, OK. Because otherwise, I think we are misusing term "racism" and that is not good (true meening of the word would be lost slowly)

On the other hand, I do not find it "discriminatory" either.
I think people are free to geoblock their sites if they think it is usefull for them and if they do not break any law etc.
I do not think we are "entitled" to access all sites by default - if someone do not want it's site to be accessible from Europe, I'm find with it.

But we do not now what site was in question here in the first place (so I cannot claim that there is nothing discriminatory with site in question)

@CCWTech said in Is it racist? I think it is.:

https://gephardtdaily.com/

There is one example.

It is geo blocked in my country.
But I do not find it racist

@scottalanmiller said in Is it racist? I think it is.:

The world has always seen Europe alone as having about seven major races... Celtic, German, Slavic, Hellenic, Latin, Iberian, and Magyar plus the tiny race that is in Finland, Estonia and the Basque country.

This is ridiculous
I am from Europe and I do not know or heard anyone talking that these are "seven major races".
Whole Europe is (natively) of White/Caucasian race and I never heard anyone calling Slavic od Hellenic, for example, as a race.
Celtic, Slavic German... are groups of languages, not race or DNA.

I work for a production&retail company that need some ticketing system to track requests from its internal users in 60 retail outlets and 4 production sites (maybe 10 departments in them)
Requests that we want to track first are requests for servicing & maintenace of different non-IT equipment (owens, refrigerators, air-conditioners etc.)

So, all users would be non-IT people - and it is crucial that the system is easy to learn and use,

I saw this thread from 2020: https://mangolassi.it/topic/21061/helpdesk-options

Options I consider are:

• Zammad
• osTicket
• SpiceWorks HelpDesk

What are your recommendations and experience, especially for non-IT usage?
Thank you

@siringo I can't find "dell inspiron 1650" are you sure it's correct model number?

I am not US citizen, but I do not see what is a big deal about giving your SSN to anybody?
Isn't it just a unique number of a citizen in public records? It is not some secret code, right?

@JasGot For my personal task list, todoist.com is the best for me. But for tracking projects that involves more than one person, I do not find it good.
Asana, Freedcamp and monday.com were good from my experience.
Monday.com is somewhat unusual, but more flexible for different stuff. Asana and Freedcamp are "classic" project tracking apps and I find them good.

But I never managed to find "ideal" or "best" app for project tracking

@Oksana said in Windows Server 2022 Hyper-V VM Licensing: What’s New?:

Discover all the nuances of Windows Server 2022 Hyper-V VM licensing in the article by Dmitriy Dolgiy, a freelance storage consultant.

Very poorly written article about an old topic.
And the licensing it describes has nothing to do with Hyper-V.

@JaredBusch said in Is it legal? Windows 10 or 11 as a server:

Tell your "client" that you will be happy to report them to Microsoft.

WTF?
Why would anyone "be happy to report client" to any other vendor (here Microsoft) for violating any agreements between you customer and other vendor?

EDIT: I am not saying that you should not refuse to work with such client, but "reporting" them?!?

@CCWTech I hope that you are aware that thousands of IT pros lost their jobs in last few months in USA, so this is the harder period for getting a new job.