Add different port ssh CentOS 7

Begin by opening the configuration file with your text editor as root: The first option that you may want to change is the port that SSH runs on. Find the line that looks like this: Change this to a different port Reload ssh After saving, don’t exit until you’ve completed these steps. By default, SELinux … Read more

Netstat Commands for DDoS Checking

Useful commands to check if a server is getting ddos’d Show IPs with more than 10 connections open: Show # of connections open per IP Number of connections per IP Haynie’s version(better sorting): Drop ips with 100 or more connections: Graphic netstat connections(# of connections open per host) # netstat -an | grep ESTABLISHED | … Read more

WordPress Optimization

Some info on optimizing wordpress https://codex.wordpress.org/WordPress_Optimization  https://documentation.cpanel.net/display/ALD/Optimize+Website http://code.tutsplus.com/articles/10-quick-tips-optimizing-speeding-up-your-wordpress-site–wp-23148

Opencart View Order Error

Viewing the orders in opencart admin – the following errors appear: [Wed Apr 01 14:51:21 2015] [warn] [client 67.81.xxx.xx] mod_fcgid: read data timeout in 45 seconds, referer: https://www.domainname.com/admin/index.php?route=sale/order&token=96d6680034320729c7df84d678589324 Try to increase the timeout in the /etc/httpd/conf.d/fcgid.conf file to 90 seconds.

Remote Access from Management Studio to SQL Server

You experience the following error message: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open … Read more

Compressing web pages with mod_deflate

The mod_deflate module allows the Apache2 web service to compress files and deliver them to clients (browsers) that can handle them. With mod_deflate you can compress HTML, text or XML files by up to 70% of their original sizes. Thus, saving you server traffic and speeding up page loads. Compressing files will increase load on … Read more

Mysql Import with phpmyadmin errors – The used command is not allowed with this MySQL version

Trying to LOAD DATA with phpmyadmin #1085 – The file ‘/tmp/phpqcXPYv’ must be in the database directory or be readable by all #1148 – The used command is not allowed with this MySQL version /etc/mysql/my.cnf [mysqld] local-infile=0 If this is set to local-infile=1 – and restart mysql – this should work Also – if that … Read more