fbpx

Root access is disabled

Securing and Optimizing Linux Some SSH servers can disable SSH logins for certain users and may even disable root logins by default. If you're using Open SSH server, you have to edit /etc/ssh/sshd_config and make sure that it doesn't contain one of the following lines: PermitRootLogin no PermitRootLogin without-password Both result in a simple...

Read more...

Server Management Articles

How To Share PHP Sessions on Multiple Memcached Servers on Ubuntu 14.04 How To Set Up a Firewall Using IPTables on Ubuntu 14.04 How To Setup a Firewall with UFW on an Ubuntu and Debian Cloud Server

Read more...

Sync windows desktop to dropbox account

Open your user folder, right-click on the folder Desktop, select properties, open the "Location" Tab, and click Move; now pick the new location dropbox folder and click Apply. Now your windows desktop will be sync via dropbox. Enjoy ;)

Read more...

Access memcache on remote servers

By default memcache server is restricted to localhost and cannot be accessed outside server. You have to make configuration changes to  allow others to listen memcache server. Now make changes in memcache configuration. vi /etc/memcached.conf Keep in mind that the -l parameter is set to 0.0.0.0, which essentially allows connections from ANY...

Read more...

Installing Oracle in WAMP environment

Installing Oracle in WAMP environment Download Oracle Express Edition (Free download) from the link. Download Oracle SQL Developer which is a free download too from the link below: If you dont have any experience working with Oracle SQL Developer, you can read this article Install wamp server 2.5 enable php_oci8.dll extension in php modules You...

Read more...

Finding duplicate records in mysql

We have two tables epaper and epaper_pages. Every epaper_pages table recrod has a specific page number assigned. We have to check that each epaper_pages table record  has no epaper_page_no duplicate number. SELECT ( SELECT COUNT(*) FROM epaper_pages WHERE epaper_pages.epaper_id = epaper.id GROUP BY epaper_pages.epaper_page_no HAVING COUNT(*) > 1 ) AS dublicate_count, epaper.* FROM epaper ORDER BY dublicate_count DESC  

Read more...

Split a file into multiple files and combine again

You need to be in a directory in which you want to split The command below will create smaller files and postfix a alphabets for smaller files. You can change the size according to your needs. split -b 10m "file-to-split.sql.gz" "file-to-split.sql.gz.part-" Finally, when you want to join the split files. cat file-to-split.sql.gz.part-* > file-to-split.sql.gz You...

Read more...

Install nginx server and configure a website

In this toturial you will learn how to install and configure nginx server and run a website on virtual host. According to the nginx website, virtual hosts are called Server Blocks on the nginx. Install nginx on the ubuntu server sudo apt-get install nginx Start nginx server sudo service nginx start Install php-fpm which...

Read more...