@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

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

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

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.

@jnaugle also worth noting, no one actually delivers PRI today, that entire market is a scam. It's actually SIP and then they translate the SIP to PRI on your network edge to make it "sound cool" for people who are out of date and remember when PRI was both still available and actually practical (early 1990s and earlier.) PRI is not nearly as powerful as SIP, nor as cheap, so phone providers long ago "all" moved to providing SIP instead (PRI isn't possible without a physical T1) and "virtualizing" PRI on top of it. All the PRI does it increase cost and lower performance, flexibility and reliability.
So the best solution is to get the phone provider to stop pretending to do PRI and just give you the raw SIP. This improves your phone quality by removing unnecessary steps and limitations, removes the need for you to convert back to SIP (gateway, card, however you do it) and makes everything better for everyone. The PRI interface has no advantages, only disadvantages. It takes the better SIP, and cripples it.
For people running ancient phone systems from before VoIP, SIP isn't possible, so these terrible PRI interfaces are useful for them to continue to be able to hook up those ancient phone systems while still being able to connect to current phone companies. They aren't totally useless, but they are useful only for that one terrible niche case.

@iroal said in Guacamole 0.9.14 on CentOS 7:
@jackmartins_ said in Guacamole 0.9.14 on CentOS 7:
@iroal Did you solve this problem? I got the same error
I reinstall using this tutorial.
https://cstan.io/?p=11405&lang=en
Regards.
Those instructions is pretty good. He did leave out information about the default user and password for it.

@jaredbusch said in Someone tell me WTF is wrong with my rync skills this morning:
tired or stupid or something this morning..
works perfectly when one specifies the correct data directory on the source.
/home/owncloud/data/
sent 1764471 bytes received 178175 bytes 56308.58 bytes/sec
total size is 148236697158 speedup is 76306.59 (DRY RUN)
I hate that. You always have a few outliers before you standardize on things and they are always the gotchas. This has happened to me on many occasions.

@black3dynamite said in Setup Zimbra 8.8.6 on CentOS 7:
If I were to set this up at home behind a Comcast gateway modem, I would need to setup MTA to do HostLookup Native?
And to clarify, that is if you don't want to do split DNS.

@black3dynamite said in Nextcloud 12/CentOS 7 -- Problem with code integrity check:
@emad-r said in Nextcloud 12/CentOS 7 -- Problem with code integrity check:
@black3dynamite
I ll try my best to answer:
You can have either but not both, PHP as Apache HTTPD module or PHP as FPM, If you want to setup PHP-FPM on centos instead of PHP module or mod_php, and then PHP-FPM starts as an systemctl service, you will need to carry on those steps:
Install Apache:
yum -y install httpd
systemctl enable httpd
systemctl start httpd
Install PHP-FPM:
yum -y install php
yum -y install php-fpm
Configure Apache httpd:
nano /etc/httpd/conf.d/php.conf
<FilesMatch \.php$>
# SetHandler application/x-httpd-php
SetHandler "proxy:fcgi://127.0.0.1:9000"
</FilesMatch>
Then:
systemctl start php-fpm
systemctl enable php-fpm
systemctl restart httpd
For me if I want to make any web app, I just simply go this route, back in the day I would make it faster by running Nginx, but most third party web apps expect apache, and I found out the by simply using PHP-FPM with Apache I can make the web app as responsive and fast as ever, and I never found scenario where that is not compatible, what you simply do is remove PHP being child of apache, and giving it daemon of its own with children, and it becomes very fast.
The setup on CentOS is different compare to Fedora 27.
Installing php also installs php-fpm.
[root@localhost hjohnson]# dnf install php
Last metadata expiration check: 2:30:05 ago on Wed 07 Feb 2018 08:46:00 AM MST.
Dependencies resolved.
============================================================================================================================================================================================================
Package Arch Version Repository Size
============================================================================================================================================================================================================
Installing:
php x86_64 7.1.14-1.fc27 updates 2.8 M
Installing dependencies:
nginx-filesystem noarch 1:1.12.1-1.fc27 fedora 20 k
php-cli x86_64 7.1.14-1.fc27 updates 4.2 M
php-common x86_64 7.1.14-1.fc27 updates 1.0 M
php-json x86_64 7.1.14-1.fc27 updates 72 k
Installing weak dependencies:
php-fpm x86_64 7.1.14-1.fc27 updates 1.5 M
And its already configured /etc/httpd/conf.d/php.conf
# Redirect to local php-fpm if mod_php is not available
<IfModule !mod_php5.c>
<IfModule !mod_php7.c>
# Enable http authorization headers
SetEnvIfNoCase ^Authorization$ "(.+)" HTTP_AUTHORIZATION=$1
<FilesMatch \.(php|phar)$>
SetHandler "proxy:unix:/run/php-fpm/www.sock|fcgi://localhost"
</FilesMatch>
</IfModule>
</IfModule>
Yup I noticed this with Fedora, and when I jump to Fedora , or when Centos gets updated to reach Fedora levels like in 3-5 years I will worry about that. I never reached scenario where I needed bleeding edge server, and if that is the case usually it is Ubuntu and not Fedora.

@zachary715
You can turn on debug by changing false to true in .env file, so you can see more information instead of Whoops, looks like something went wrong.
# REQUIRED: BASIC APP SETTINGS
# --------------------------------------------
APP_ENV=production
APP_DEBUG=true
APP_KEY=
APP_URL=
APP_TIMEZONE=America/Denver
APP_LOCALE=en

@lakshmana said in Centos 7.3 Wifi Issue:
@scottalanmiller said in Centos 7.3 Wifi Issue:
@lakshmana said in Centos 7.3 Wifi Issue:
@scottalanmiller Installed Ubuntu now
But OLD Ubuntu, that is expected to have lots of issues because it is not up to date, right?
Yes Now WiFi Detected will go with KVM and then Centos will run it
Great!