@anthonyh said in GPO Software Deployment Woes:

Just a side note: I can confirm that @Dashrender 's suggestion of creating a CNAME works like a charm. I created a new software deployment GPO and added the source via the CNAME record and deployment was successful.

Glad to see that I was mistaken 🙂

@DustinB3403 said in Nomad - Manage Mac OS in Windows/AD Environment - Anyone Used It?:

I've heard of it, and it's supposedly a really good product, the issue with it is the cost. At least at the time.

The product now is JAMF Connect. So it looks to be a dead product that was replaced.

Interesting. I'll look into that. I didn't see any mention of jamf.

@black3dynamite said in Setting Up a Standard MySQL or MariaDB Database for an Application:

@JaredBusch said in Setting Up a Standard MySQL or MariaDB Database for an Application:

I like my approach to setting this up.

Obviously, install MySQL/MariaDB first as noted above.

Then do the following. This all needs done in the same SSH session, but otherwise things are simple.

Choose once of these exports for your DB root password.

The first one is for you to specify, the second generates a random one and echo's it back to you.

# Specify your own password for MariaDB root user export DB_ROOT_PASS="somebigpasswordgoeshere" # Generate a random password for MariaDB root user export DB_ROOT_PASS="$(head /dev/urandom | tr -dc A-Za-z0-9 | head -c 30)" echo "This is your MariaDB root password: $DB_ROOT_PASS" Specify the application database name and application user name # Database user to use for application export DB_USER='yourusername' # Database name to use for application export DB_NAME='yourdatabasename' Generate or specify a random password for the database user # Specify your own password for the application's database user export DB_PASS="somebigpasswordgoeshere" # Generate a random password for the application's database user export DB_PASS="$(head /dev/urandom | tr -dc A-Za-z0-9 | head -c 30)" echo "This is your password for the application user: $DB_PASS" Then create the application database, use, and grant access. mysql -e "CREATE DATABASE $DB_NAME;" mysql -e "CREATE USER '$DB_USER'@'localhost' IDENTIFIED BY '$DB_PASS';" mysql -e "GRANT ALL ON $DB_NAME.* TO '$DB_USER'@'localhost';" mysql -e "FLUSH PRIVILEGES;" Finally, lock down the system without the interactive requirement of mysql_secure_installation # Secure MariaDB (this does what mysql_secure_installation performs without interaction) mysql -e "UPDATE mysql.user SET Password=PASSWORD('$DB_ROOT_PASS') WHERE User='root';" mysql -e "DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1', '::1');" mysql -e "DELETE FROM mysql.user WHERE User='';" # Beginning on some version of MariaDB after Fedora 29 was released, the test DB is no longer there by defualt. mysql -e "DROP DATABASE test;" mysql -e "FLUSH PRIVILEGES;"

Your approach makes it easier to use as part of a script.

It also generates random passwords, which I prefer.

@LilAng said in Copy / Paste from Excel on Mac to Outlook Web Access Creates Image Rather than Table:

In Excel, use File > Save as web page, then attach the web page to your email message?

Yeah, we found that process. That's a pretty huge "fail" process.

@gjacobse said in Wifi Card Not Being Seen:

have you tried using a Linux OS? This could be helpful in determination of the Hardware and OS

everything else works fine except the wifi for some reason just kicks off to the point the card itself is not recognized even with drivers re loaded , until you physically unplug and plug back in.

@Dashrender said in Make an osTicket Database Backup:

Total DB Admin noob here - so bare with me.

Does this include the username/password setup for this DB? or does that need to be maintained separately?

i.e. you have to rebuild from this backup - do you just create a brand new SQL user and grant them rights to this DB upon import, then use that new account to give access to the app?

In typing out my question I kinda assume the answer is the second bit - you just create a new user and assign them rights.

Correct. The user and the database are separate things.

@DustinB3403 said in Losing mouse via hyper v manager:

Anyone can login to the console, as the local admin, and have no additional logging (admin login to console from system-name. . .) for example.

So, there are compliance and logging reasons to not use the console that are general recommendations to "just do".

What? Who has the administrator account password? Hopefully only the most trusted of all people, a subset of the IT team. So that shouldn't be a real issue.

As for logging - I have no idea what logging in available in Hyper-V itself when the Hyper-V Manager is logged into and accesses a Hyper-V host - but I would assume that connection itself is logged based upon the username/password of that IT member - and if they have the Administrator name/password - well, there you go.

As for the actual console - well, there really isn't a way to access a VM from the physical console on the server, so that's a non issue.

@NashBrydges said in Mass upload sound files into FreePBX:

Very useful stuff, thanks for this.

Self serving. I’m buildinging a mass import right now using this process.

OSTicket is not a solution I can use, because I need time tracking also.

I never saw a plugin for that for OSTicket.

@flaxking said in Traefik Reverse Proxy:

Are you currently using it in production?

Not at work. I'm using it for projects outside of that though. My docker compose stack at home uses it.

@JaredBusch said in KVM VM Replication:

@scottalanmiller said in KVM VM Replication:

Just using the search is best

Tags.

yeah, having tags on the topics makes them better than pinning.

@brandon220 said in DNS A record:

It had to be fixed by GoDaddy support. They cleared out the forwarder and all is well.
I need to look in to Cloudfare.

oh yeah, they are so good.

@black3dynamite Good call. I had to make some adjustments to SELinux.

0.2.9-z is working for us here. Thanks!

I figure I'd just throw this out there just for the heck of it...

For what it's worth, I use a Cisco ISR 2851 as an FXS and FXO gateway in my home lab and am very happy with it. You can nab them pretty cheap on eBay (either a 2851 or 2821 would work). You'd just need either two VIC2-4FXO cards or for the more adventurous an EVM-HD-8FXS/DID with two EM-HDA-6FXO daughter cards and something to terminate the RJ21 connector with (like a 66 block or a breakout cable)...the former is likely easier though :grinning_face_with_smiling_eyes:

I'd normally keep swap space too but I know for sure you can run without it successfully because we used to do that with embedded linux for years - with devices that had years of uptime.

With memory ballooning you can overcommit RAM and the hypervisor can swap guest RAM to disk if it comes to that. I don't know which hypervisors supports it though. As always it depends on how much you want to cram out of your gear.

@gjacobse said in UBNT: UniFi Controller Issue:

Follow up, controller is running again under Win10.

I’ll address a Linux system in the future at some point and move over so it can run full time.

Worth it if you have a hypervisor running somewhere with enough extra resources for it - otherwise, in a home environment - not worth it.

Uninstalling FF and deleting all folders from c:\users%username%\Appdata that are either FireFox or Mozilla, the rebooting and reinstalling - solved the problem.

Now to do that to Chrome.