Install Postgres database on Windows and allow password less access

By Subharanjan in Database, PHP, Software Tricks 0 Comment

Install Postgres Database on Windows and allow password less access for the database to be used in various applications.

  1. Install Postgres database on Windows machine by downloading the executable file from here: https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
  2. pgAdmin tool can be downloaded and setup on Windows machine to view and manage the databases and tables by downloading the executable file from here: https://www.pgadmin.org/download/ Make sure to check the Postgres version and compatible version of the pgAdmin tool.
  3. phpPgAdmin can be downloaded and setup on Apache server to manage the databases from a web based enviornment. http://phppgadmin.sourceforge.net/doku.php?id=download

Now, for applications running on private & internal LAN setup, a password less access to the the postgres database is required. To allow login into the database without a password, a simple modification to the pg_hba.conf file is required.

  1. Edit postgre configuration file: C:\Program Files\PostgreSQL\9.2\data\pg_hba.conf
  2. Change all configuration access to:
    PHP
    1
    2
    3
    4
    5
    6
    7
    8
    9
     
    # TYPE  DATABASE USER ADDRESS     METHOD
     
    # IPv4 local connections:
    host    all       all     127.0.0.1/32   trust
     
    # IPv6 local connections:
    host    all       all     ::1/128       trust
     
  3. Restart the postgres server. Go to Control Panel > Administrative Tools > Services > Restart the Postgres service.

Just completed my WP 5k 2016 walk :)

By Subharanjan in Odisha, Social Life, WordPress 0 Comment

Feeling little tired but happy as I have just now completed my WP 5k 2016 walk ( #WWWP5K ) !! If you aren’t aware of the WP 5k 2016, it’s a 5-kilometer run/walk/hike/hop in between September 19th to September 25th. Wherever you are, whatever you are doing, if you are anyway involved with WordPress, just participate and blog about it.

Today morning I thought about taking part in the Worldwide WP 5k 2016 by walking the distance of 5 Km. Started off from my home and went to the Buddha Park and walked until I cover the WP 5k 2016 🙂 It’s really awesome to get up early and walk around that too for WordPress’s Worldwide WP 5k 2016.

I have been involved with WordPress for more than 5 years now, currently working as a WordPress developer at Axelerant. Love to unite with worldwide bloggers, runners, WP developers !!

Here is the map of my walk !!
subharanjan_wwwp5k

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Selfie afterward:

subharanjan_wwwp5k_after

How to fix 302 redirect issue when updating posts in WordPress? [Solved]

By Subharanjan in PHP, WordPress 1 Comment

Recently, while writing a blog post I found that I am not able to update/publish any post on my WordPress website dashboard rather it redirects me to the website front page when I click the “Update” button. Now, I was unsure what’s creating this trouble and how to fix this 302 redirect when updating posts in WordPress.

Debug:

To check what could be the issue, I tried the followings :

  • I checked for any javascript errors through chrome dev tool’s console, but no errors there.
  • I deactivated all the plugins
  • Even changed the theme to the default Twenty Sixteen

Root Cause:

Still, the issue was there. After debugging a little more I found the cause of this. It was the strict Mode_Security which was causing the trouble. Now the question is: “What is Mod_Security?”

ModSecurity is an open source, cross-platform web application firewall (WAF) module. Known as the “Swiss Army Knife” of WAFs, it enables web application defenders to gain visibility into HTTP(S) traffic and provides a power rules language and API to implement advanced protections.

Basically, this is an Apache module that is installed on most servers by default to help protect your website from various attacks. It is used to block commonly known exploits by use of regular expressions and rule sets. This sometimes blocks the POST requests being generated after a post is updated or published because of the complex HTML content having all the tags, embed code, shortcodes etc. which get caught by the ModSecurity’s rule set.

cPanel-Mod-Security-Subharanjan

Solution:

To fix this issue simply disable the module on your server. This can be achieved through the Modsec Manager plugin for cPanel if you are on a shared server. Read the following to know how to disable manually on VPS and Dedicated servers. http://www.inmotionhosting.com/support/website/modsecurity/what-is-modsecurity-and-why-is-it-important

I am sure there are a ton of other reasons for a 302 redirect issue but in my case, this was Mod_Security causing the problem and after disabling the module I am able to update and publish the posts. 🙂

List of useful tools for WordPress development

By Subharanjan in PHP, WordPress 0 Comment

When a developer starts WordPress development and tries to make the process easier and faster, generally he searches for best tools and various boiler plates which can alleviate the manual task of starting the development from scratch.

wpgearWordPress Gear (WPgear.org) is a website which lists out lots of useful tools those are free and GPL(OpenSource). The list includes tools and its related information for all aspects of WordPress development. Starting from WordPress base tools to Debug tools, PHP boiler plates, Meta fields frameworks, Theme development tools and lot more..

New and latest tools are being added constantly into this list as this is a community driven site. Whole of the code for this page resides in Github and anybody can add any free tool into the list. Just fork the project, add/edit your tool with a link, submit a pull request.

Visit WPGear.org to browse the complete list of tools. Happy WP Coding 🙂
1) http://wpgear.org/
2) https://github.com/wycks/WordPress-Gear

Timthumb not showing images and throws “Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. ” error. [Solved]

By Subharanjan in PHP, Software Tricks, WordPress 2 Comments

timthumbRecently I faced a situation where the timthumb script was unable to crop the images and was throwing error messages. There are themes those still use timthumb even though its a bad practice to use in themes when we have already functions available in core WordPress. Anyway I had to fix the issue as I was not state to replace the timthumb functionality with core WordPress functions.

Here is the error message:

PHP
1
2
3
4
5
6
7
 
Warning: file_exists() [function.file-exists]: open_basedir restriction in effect.
File(/usr/local/apache/htdocs/wp-content/uploads/2014/02/nandankanan-national-park.jpg)
is not within the allowed path(s): (/home/:/usr/lib/php:/tmp)
in /home/a9582221/public_html/wp-content/themes/kingsize/timthumb.php
on line 862
 

This issue occurs in several hosts, mainly the free hosts available these days. So, the trick is to find where the $docRoot variable was set and set it to my public_html folder manually in my home directory. In my file it was on line number 825. I did the following…

PHP
1
2
3
4
 
// $docRoot = @$_SERVER['DOCUMENT_ROOT'];
$docRoot = '/home/a9582221/public_html';
 

Obviously the /a9582221/ would be your username.

Where to make this changes ??
Search for the file timthumb.php and make the above changes. Thats it. The issue got resolved now.