@DustinB3403 said in MySQL MariaDB password reset without knowing the password:

Just still seems weird to have the password in plaintext on in a config file.

has to be somewhere, how else can an application connect? Look at WordPress, for example, you have to enter the password into the application so that the application can connect to the database. Otherwise, the database would have to have no password protection at all or you'd need a human to log in and enter the password every time a database connection was needed (which is normally thousands of times a minute.)

@wrx7m said in Configure Nginx as Reverse Proxy for ScreenConnect to Enable Lets Encrypt:

Less to that than I thought there would be.

It's surprisingly simple and basic. It's really just passing one port to another, and using SSL. About the most basic setup you can have.

@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

Variation for Debian 10 + Dovecot 2.3.4.1:

cat /var/log/dovecot/dovecot.log | grep imap-login:\ Info:\ Login | sed -e 's/.*Login: user=<\(.*\)>, m ethod=.*/\1/g' | sort | uniq | wc -l

@FATeknollogee said in oVirt Host Choices for Production:

@EddieJennings I would start by using oVirt Node (it's based on CentOS), it's the simplest, least hassled way of setting up.

Yeah, they have their own Node deployer, I'd generally just use that.

@zachary715 said in Linux Options for Dell PowerEdge 2950 II:

Just curious what role this server will be playing...

Web server

So, easy fix, the ca_stag2 was a staging DB that was not needed and was not current. The whole thing appears to have corrupted. So I simply "moved" that entire directory to /tmp (just in case I had to put it back) and then MySQL could fire up.

@JaredBusch said in Wazuh Agent Install - CentOS:

Why are you disabling agent updates?

Wazuh doesn't understand how to maintain their own repository, so when OSSIM updates their stuff, it breaks Wazuh. It's silly, easily fixable, and I don't have the time to maintain the thing myself.

@scottalanmiller Sounds solid. The speed difference is dramatic. Thanks.

rpcbind services is not required for NFSv4

https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/8/html/deploying_different_types_of_servers/exporting-nfs-shares_deploying-different-types-of-servers
d4520326-8f0f-48df-b2bf-62e8b7a0040c-image.png

25c783d8-ba90-4aee-b652-017c220451b6-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.

@DustinB3403 said in Troubleshooting Help Requested:

@wrx7m said in Troubleshooting Help Requested:

VLANs?

No, and this VM is on the same vlan as other VMs on the same host.

PS I've restored this VM to a completely different hypervisor and the issue persists. So either its the VM or the gateway.

Have you tried a different IP, or even power down this machine and assign the same IP to another host to see if it gets blocked? Is the restored VM using the same MAC address as the original or has the restored version got a reinitialised MAC?

Do you have access to check the logs on the gateway / edge / router to see if it's blocking / intercepting / messing with your host

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

So, circling back. How is the backup project going?

@flaxking said in vTigerCRM Installation - Troubleshooting:

Is SuiteCRM's Cases feature decent?

Not a sales guy, not sure how it is.