@WLS-ITGuy How Was the Migration process?

@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:

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

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

I do not know if this matters maybe you should look into an FTP that caters between Linux and Macs poossibly.

@WLS-ITGuy Typically we use the time to rebuild. Any VM should, in theory, be quick and easy to rebuild. If it isn't, it's the perfect time to make it so.

If you absolutely have to convert rather than move through application migration, then there are disk conversation tools that change the format. There's very little needed for the migration.

@Pete-S said in Debian 11 & php8:

Not a challenge at all but the reason to run "stable" is for stability.

Once you start abandoning the integration, though, you are abandoning stability. The idea of using an LTS and then replacing the parts of the OS that aren't up to date is counterproductive. Choose the most up to date, best supported, most stable version and use the fully tested and integrated components instead.

The idea of "stable" is not stability in IT terms, that's a myth. It's actually against that. The idea of current is for IT stability. Stable, in reference to an OS like this, is in reference to the versions of products remaining stable so that unsupported, out of date software from bad vendors can be used without updating for long periods of time. Not a positive stable, it's a bad stable.

@Dashrender Check this thread
https://learn.microsoft.com/en-us/answers/questions/955731/who-deleted-an-appointment-from-a-shared-calendar

@Fredtx said in Who's making the move to vSphere 8:

@dafyre said in Who's making the move to vSphere 8:

We are. Currently, my day job is heavily invested in the VMware ecosystem, and there's no likelihood that will change any time soon... So we are already at the point of testing it, though that probably wont' happen until after the New Year.

I haven’t looked at the vmware hcl, but I heard a lot of hardware is no longer supported. I also read that vmware no longer recommends booting from sd cards.

That's all correct. Part of the point of VMware (and to their credit) is to dramatically limit you to a small pool of high quality, well tested hardware. That's partially how they maintain stability.

KVM has a small pool of hardware smart to use. But "supports" almost anything. It's handy to know it will always work, but sucks because people deploy it on crap all of the time.

@pete-s said in P2V conversion:

@wls-itguy said in P2V conversion:

I have two physical servers that would take a great deal of time to rebuild to virtual so a conversion from P2V would be ideal. What are you guys using to do P2V conversions?

I was looking for VMWare's converter but I don't think it exists anymore.

It's better to just reinstall on a new Windows (I'm guessing) and do whatever upgrades that are needed at the same time.

P2V is not a good generic solution. Consider it for quick and dirty band-aid solutions only.

Totally agree. Use migration time as a good time to run side by side and migrate the app and update / cleanup with a fresh install. If you have good procedures, this will be trivial. If you don't, even better, this is a chance to catch gaps in the knowledge base.

@pete-s said in FreePBX DAHDI card not connecting:

@wls-itguy said in FreePBX DAHDI card not connecting:

@pete-s

Doesn't FreePBX use their own distro though? Or is that something different?

I don't know. I was always under the impression it was CentOS, which until recently is the same as RedHat Enterprise Linux.

I'm sure @JaredBusch knows more.

FreePBX is Sangoma 7, a fork of CentOS 7.
They had a private alpha of FreePBX 15 or 16 built on CentOS 8 that was never public. That was killed when RedHat killed CentOS 8.

FreePBX 16 is still Sangoma 7, but with PHP 7.4 ported in and a few other updates.

There has been no announcement yet, but a few threads on, choosing a new fork to go forward with.

@stacksofplates said in KVM or VMWare:

@pete-s said in KVM or VMWare:

It isn't the ability to automate that is the problem. It's the availablility of easy to use tools that is the problem.

Thats the whole point I'm making.

KVM is hard to automate. Not that it's impossible, but the tooling doesn't exist to where you can easily automate like with VMware.

Agreed, and I don't think that that's the point of concern here. The issue at hand should be "does that automation that VMware offers get used by or should be used by the OP?" I believe that the answer is no to being used today and likely no to should it be used. It's a very small deployment. The overhead to the automation, even when you have VMware, is too high. And regardless, even if we agree that it should be used, probably because an MSP/ITSP is brought in to effectively make the environment larger and changing some of the scale discussions, the bigger question would be "will the OP's environment opt to do that anyway?" If that answer is "no", in the practical sense, then the automation point becomes moot.

I "think" we can all agree that VMware has better standard built in automation. And that KVM is completely automatable if you put in the extra, non-standard effort. So if we were considering standard automation then VMware would have an important edge in that area. That point shouldn't be in dispute. We can argue how close KVM gets, while still being behind, sure.

But the key point here, for me, is that I believe based on knowing the environment a bit that that automation is not, and won't be, used if VMware remains.

@gjacobse said in Any way to get firmware for an HP ML350 G6?:

Is this what you are looking for:

** CRITICAL ** System ROMPaq Firmware Upgrade for HP ProLiant ML350 G6 (D22) Servers (For USB Key-Media)

Interesting, I looked earlier and it had a lock on the download button.

Option 2:
Use the built in and use a connector that is IP auth'd

284bc4ae-b73b-42cd-a6a4-0366ca32847e-image.png

21ee0999-596f-4931-bad8-517bb0dd8f3a-image.png

bcfcfc92-41a6-4349-ab24-fc0a73b578fa-image.png

@jaredbusch said in Fast/painless remote access:

@scottalanmiller said in Fast/painless remote access:

@wls-itguy said in Fast/painless remote access:

@scottalanmiller I'd be happy just to see the desktop at this point.

Most messaging platforms (Teams, Jitsi, Zoho Cliq, Slack, RocketChat, etc.) are going to do that for you.

Right, just to see? You can do Jitsi so easy. it is all a web page.

But also, almost everyone can use Zoom any more. and it also has screen sharing.

Forgot that is a feature in Zoom. Works for what I needed.

Thanks everyone!

@Pete-S said in PHP 8 upgrade:

It's a little early I think. PHP is currently only on 8.0.3 and none of the big distros are yet running 8.x branch.

@dbeato said in PHP 8 upgrade:

I haven't tested yet to be honest. We shall see.

I've got clones of the WordPress and Moodle servers that I think I'm going to play with. I though I saw WordPress pushing php 8 recently.

NONE STUCK IN THE QUEUE!

Thanks for the help @JaredBusch, @dbeato @Dashrender

@WLS-ITGuy Here you go.
https://www.mangolassi.it/topic/21589/upgrade-freepbx-14-to-freepbx-15

@WLS-ITGuy said in Aastra phone replacement:

I don't see a firmware for the T54W nor is the EXP50 available.

These phones are basically new since October or so. They will not be in EPM anytime soon because of how that has traditionally worked. The device manufacturer has to sing an agreement with Sangoma (Schmoozecom) to get a device supported. I assume, but do not know for a fact, that the agrement includes monetary compensation also, as anything in EPM is fully tested by Sangoma also, and testing takes manpower (money).

With Appflow you need to make sure you have authentication enabled for the users so it tracks per user. The Data Collection is for sure nice but it is only the top sites and no much information.
https://www.sonicwall.com/support/knowledge-base/help-with-user-level-authentication-settings-like-local-users-ldap-radius/170503274714653/

https://www.sonicwall.com/support/knowledge-base/configuring-app-flow-monitor-to-view-real-time-incoming-and-outgoing-network-data/170505632951042/

https://www.sonicwall.com/support/knowledge-base/how-can-i-track-which-users-or-ip-addresses-are-accessing-a-certain-website-using-appflow/170505832815323/

https://www.sonicwall.com/support/knowledge-base/how-can-i-collect-traffic-details-by-ip-address-on-the-firewall-through-log-reports-and-appflow/170503950787011/

@dbeato said in 550 5.0.350 Remote server returned an error:

@WLS-ITGuy said in 550 5.0.350 Remote server returned an error:

@dbeato said in 550 5.0.350 Remote server returned an error:

@WLS-ITGuy said in 550 5.0.350 Remote server returned an error:

571 Delivery not authorized, message refused

That messages means a lot of things but yeah Whitelist on their Spam Filter end, Adding your IP to your SPF record, check if there is anything on the body of the message triggering the block on their end (i.e. URL or site link).

It is Office 365 with Exchange - I have created all the records that Microsoft wanted me to.

So, just to be clear, this is 100% not on my end, correct?

It shouldn't be on your end, the message is coming from the recipient's end server.

Right, which means that they received it.