As an update to this, the issue is not resolved, but I purged a couple old nextcloud user accounts, that once deleted, and got enough space to get the needed users fully sync'd again.

I'll be spinning up a new Nextcloud instance and simply manually migrating users to it I think.

@Pete-S said in MariaDB Package Issues While Updating from CentOS 7 to CentOS 8:

But nobody in their right mind...

...uses LTS releases. So we have to accept we are working from a crippled situation anytime that this comes up. It means we are already dealing with politics over function. So knowing that, it should explain why we have to deal with what we have to deal with. Would have been super fast to do a fresh install.

But you'd not do a fresh install of CentOS 8 or Streams if it wasn't for politics. We'd be putting in Fedora, Ubuntu, or OpenSuse. So not getting to do a fresh install is just one artefact of many when doing what's best for the application platform isn't what drives decision making.

@marcinozga said in Install Skyetel Postcards on CentOS 7:

@scottalanmiller said in Install Skyetel Postcards on CentOS 7:

@marcinozga said in Install Skyetel Postcards on CentOS 7:

@black3dynamite said in Install Skyetel Postcards on CentOS 7:

Still preferred fallocate instead of dd to create a swap file?

dd if=/dev/zero of=/swapfile count=4096 bs=1MiB && chmod 600 /swapfile && mkswap /swapfile && swapon /swapfile && echo "/swapfile swap swap defaults 0 0">>/etc/fstab

Still using swap file? Memory is cheap. I don't recall a server where I created swap partition or swap file.

Memory is NOT cheap, not at all.

It is if you own it. If you rent your hardware, yeah, it adds up.

Even if I own it, throwing away 2-3GB of RAM makes no sense. Now, if I own it, I can easily assign 4GB of RAM then remove it once installed, by why? That's harder to script and still no benefit.

It's a bad habit to see resources as cheap and so waste them just because you can. Extra memory doesn't improve performance, it hurts it (just the tiniest bit). And it's not free, if you always apply twice as much RAM as you use (or four times, here), that gets costly one way or another. Either you wasted money overspeccing in the beginning, or you are stuck buying more now.

@IT-ADMIN said in logrotats vs simple cron job:

by the way you like jesse pinkman yo yo

Ha that's the first time I've heard that.

While I would generally agree with that, it feels as if I'm just missing 1 step to this process.

Yep choosing an https mirror seems to be working.

@Dashrender said in Snipe-IT Departmental Reporting:

@wirestyle22 said in Snipe-IT Departmental Reporting:

@Dashrender said in Snipe-IT Departmental Reporting:

@wirestyle22 said in Snipe-IT Departmental Reporting:

Got it to work. Edit the below file.

app/Console/Commands/LdapSync.php

Edit max_execution time and memory_limit

ini_set('max_execution_time', 1200); //600 seconds = 10 minutes ini_set('memory_limit', '1000M');

what was the default in those?

ini_set('max_execution_time', 600); //600 seconds = 10 minutes
ini_set('memory_limit', '500M');

Wow - so it took more than 10 or more than 500 M RAM to import all that - due to your numbers, I 'm guessing it was the RAM more than the time.

Not sure honestly--it took awhile. I spoke to a snipe-it Dev and they could sync 15k accounts with these settings. I needed this functionality so I can create a script to sync users every day at 1:00 AM.

@JaredBusch said in Prerequisites for Yealink YDMP Install:

@DustinB3403 worked with this I believe...

I did, but the install process was pretty easy.

https://drive.google.com/open?id=1-2hh-5N-vg-s2w8MS3GVaqDRVetLmbpp

@wirestyle22 said in Mitigating Nextcloud Two Factor Authentication Error:

I upgraded Nextcloud and for some reason two-factor authentication activated on my admin account. Since I couldn't access my admin account I needed to find a way via cli to disable two factor authentication, but because it wasn't configured there was no folder in /var/www/html/nextcloud/apps for me to rename, etc. Below is the command I found that worked for me.

sudo -u apache php occ config:system:set twofactor_enforced --value=false

Note: You have to run the command as apache, or if you're using Debian www-data.

You also need to be in the right folder

By default on Fedora

cd /var/www/html/nextcloud

Or

sudo -u apache php /var/www/html/nextcloud/occ config:system:set twofactor_enforced --value=false

same system before and after the fedora 31 upgrade.

9cae9dc1-45c5-4d1a-bdb9-3373dfe3d5de-image.png

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

@Emad-R said in Installing MS SQL Server Express on CentOS:

Et me guess it is much faster on Linux than on Windows server

No idea, but it is one less Windows Server license needed.

Also MS SQL Server Express works well for many tasks.

@JaredBusch I don't know if you ever finished up with this client, but for $1236 you can get a decent server that would work well.

f88a7503-2bae-409f-b906-64cf361d69d0-image.png

Add $99 if you wanted the 3 year warranty

@scottalanmiller said in Zimbra Services Fail to Start; Removing Stale PIDs:

@dbeato said in Zimbra Services Fail to Start; Removing Stale PIDs:

@dbeato said in Zimbra Services Fail to Start; Removing Stale PIDs:

@scottalanmiller said in Zimbra Services Fail to Start; Removing Stale PIDs:

@dbeato said in Zimbra Services Fail to Start; Removing Stale PIDs:

I have only had this happened on the upgrades between versions and OS upgrade.

This happened to us while simply up and running. Middle of the day. Very odd.

Weird

What version?

8.8.10_GA_3716

Hmmm I just upgraded from 8.8.9 to 8.8.11 last week or two weeks ago.

@bnrstnr said in Deploying NodeBB 1.11.1 on CentOS 7 with MongoDB 4:

What specific reasons for the CentOS recommendation here?

Revisiting a little...

Basically the three main Linux releases supported by MongoDB are CentOS, Ubuntu, and Debian. CentOS and Ubuntu here are mostly six of one. But CentOS 8 Stream I like a little more than the Ubuntu LTS options. We use Ubuntu a little more often than CentOS today, but in this case I feel that CentOS is slightly better for us. But really, all three options are perfectly fine. We just have to pick one.

That is so weird.

@dbeato said in Zimbra Update Fails with Validating LDAP Configuration, Cannot Create TLS Connection to LDAP Masters:

@scottalanmiller said in Zimbra Update Fails with Validating LDAP Configuration, Cannot Create TLS Connection to LDAP Masters:

So it worked by rebooting. WTF

Weird.

Very

Good to know, I use Ubuntu/Debian so I will check for that.