@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

@scottalanmiller said in Get Active User Login Count from Dovecot: cat /var/log/maillog | grep pop3-login:\ Login | sed -e 's/.Login: user=<(.)>, method=.*/\1/g' | sort | uniq | wc -l This tiny variation will get you all logins from all logs that you have stored. cat /var/log/maillog* | grep pop3-login:\ Login | sed -e 's/.*Login: user=<\(.*\)>, method=.*/\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

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

@black3dynamite said in Deploying NodeBB 1.11.1 on CentOS 7 with MongoDB 4: @scottalanmiller said in Deploying NodeBB 1.11.1 on CentOS 7 with MongoDB 4: @black3dynamite said in Deploying NodeBB 1.11.1 on CentOS 7 with MongoDB 4: @scottalanmiller said in Deploying NodeBB 1.11.1 on CentOS 7 with MongoDB 4: @JaredBusch said in Deploying NodeBB 1.11.1 on CentOS 7 with MongoDB 4: Otherwise, there is no reason to use CentOS, nor avoid the Fedora RPM packages. Actually there is, the RPM packages for MongoDB are "breaking". You can't auto-update with them without bringing your forum down. Several updates in the last two years were not just breaking, but very breaking. Fedora RPM for NodeJS is acceptable, but would put you several versions behind typically. For MongoDB, it would put you behind with updates while creating a risk that a seemingly trivial update to the OS would be expected to totally hose the database (3.4 to 3.6 to 4.0 are all updates that have to be manually handled for MongoDB with the actual data being massaged to handle it, but the OS just changes the engine version and lets the data stop working.) Its probably be best to start using the MongoDB repo instead of using RHEL and Fedora repo, with the news about them planning on removing MongoDB from their repo. I do that anyway. MongoDB is very good about their repos. You do the same with nodejs on Fedora too? There are lots of ways to do it, but I like this model for control. NVM is good, too.

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.

@StorageNinja said in Why I Feel KVM Is the Easiest HyperVisor to Learn the Basics On: @Dashrender said in Why I Feel KVM Is the Easiest HyperVisor to Learn the Basics On: The question is - why is the quality so bad? Isn't the process supposed to catch bad quality? Their process is consider the windows insider group (extreme power users) to be a good enough replacement for proper QE teams, and writing automated build tests. Right, the new process isn't to catch bad things, it's actually to see bad things as "not all that bad." Presumably because a shift from viewing their products as being for business to being for entertainment. Remember when Windows 95 was a key tool for businesses, but by Windows 98 they had made sure to put a "for entertainment purposes only" label on the product to make sure no one confused it with something that was intended for business use? I feel like that's where they are now. At least internally, no one is really thinking of this as a business tool.

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

Sorry, ignore me. I got this figured out. I was being really dumb and had the wrong config.json file open and didn't know what I was looking at. Just ignore. Yes, the socket.io settings were missing, but were on my screen so I was sure that they were there.

@black3dynamite said in Red Hat Discontinuing KDE in RHEL and CentOS: @travisdh1 said in Red Hat Discontinuing KDE in RHEL and CentOS: @scottalanmiller said in Red Hat Discontinuing KDE in RHEL and CentOS: @travisdh1 said in Red Hat Discontinuing KDE in RHEL and CentOS: @black3dynamite Aha! They both did it! Yes, I have a thing about an entire desktop worth of space getting forced down into one little bar, and the menu being at least 2 clicks deeper than it was. Why is the menu deeper? I don't prefer this setup either, but it's no deeper. It's still a button on the desktop for me. Because as the admin/geek, everything I want/need to use is a submenu of the all programs menu. Granted I mostly just favorite a terminal emulator and be done with it, but it is much farther to move around and menus for me to get through. Give me Cinnamon with a hotkey set for the menu any day. As long as the search function works, I usually find what I need by searching for it. ^ this

@scottalanmiller and all, I don't know why you still loosing time. Use my rpms and install freeswitch/fusionpbx in minutes https://okay.network/blog-news/rpm-repositories-for-centos-6-and-7.html

@dustinb3403 Hi, You cant but the /boot as raid However the / or root part can be placed as raid, I did this and I will show you how to do this, but please don't do it. Here where it gets bad. You wish to update the system and kernel and all this can affect the RAID/ now the config for the raid is done in the kernel and stored in boot part, so you always updating this and your always keeping the disks busy, even on network packet level. Everything happens will happen on the / What you want to do is look into purchasing a small reliable drive Like 64 GB or 128 GB NVMe SSD and using that as your / or If that is too fancy or expensive, get USB thumb drive and pair it with samsung SD card and install the root part Then create RAID 10 on the 4 other drives, cause even if the /root fails it wont matter . pop another one and it will auto detect the raid , with cockpit it is very easy to detect the RAID and activate it and mount it

@dafyre said in Centos AND Ubuntu Package Mirrors Down: I disable IPv6 as a matter of defaults on my home network... I'd like to do it at work too, but I never have any issues like that there. Mee neither. It was weird thing I rebooted everything from the router side and it got fixed, so disregard.

yum-cron and dnf-automatic do not use postfix or any other MTA. They simply open and send with a direct SMTP connection by default.

Thanks to you guys I got it sorted out now!