Thursday, 23 June 2016

550 CHMOD 666 *.php: Operation not permitted - proftpd

ProFTPd version 1.34 - Giving write permission to certain folder /directory in Linux centos 6.7


Issue : Allow write access to one user and Deny for all.

<Directory /var/www/uploads/*>
<Limit WRITE>
DenyAll
AllowUser FtpUserName
</Limit>
<Limit SITE_CHMOD>
DenyAll
AllowUser FtpUserName
</Limit>
</Directory>


If we do not define DenyAll and Deny ftpusername it will throw the error like

550 CHMOD 666 *.php: Operation not permitted if file permission is tried to change
or
Critical file transfer error  if file upload or transfer is initiated

Note : Deny Clause need to define else setting is not work (I do not find this on google but change only reflect once i added DENY)

Monday, 20 June 2016

AWS CLI in Cent OS 6.7 with Python 2.6.6 , Python 2.7 not required for aws cli

After searching in AWS doc it says upgrade your python to 2.7 before installing aws.

However we are stuck with centos 6.7 and if we upgrade to newer version it might impact other area of our application.

So we tried to install it without upgrading

Below are the commands to install aws cli without 2.7 python as root login


  • cd /opt
  • curl "https://s3.amazonaws.com/aws-cli/awscli-bundle.zip" -o "awscli-bundle.zip"
  • unzip awscli-bundle.zip  
  • sudo ./awscli-bundle/install -i /usr/local/aws -b /usr/local/bin/aws
  • aws --version
version output

aws-cli/1.10.38 Python/2.6.6 Linux/2.6.32-573.22.1.el6.centos.plus.x86_64 botocore/1.4.28


Saturday, 18 June 2016

Httpd apache Server-status via location match

Httpd Server-status via location match not working in Centos or Ubuntu 

For Server Monitoring Apache Server-status is very useful thing

However there are situation due to rewrite rules location match for Apache is not triggers or not working correctly

Spot the problem 

Confirm that in httpd.conf 

mod_status.so  should not be commented

Incorrect
#LoadModule status_module modules/mod_status.so

Correct (remove the # to uncomment)
LoadModule status_module modules/mod_status.so

If its already un-commented then check your rewrite rule if they overriding the location setting ?

How to check : You can check by simply http://yourip/server-status if it not display some stat regarding Apache and redirect to your website then rewrite rules are overriding 


Solution ?

Update your location path in your conf it might be httpd.conf or any other location
Note : This can be placed in last line of the conf file out of any <VirtualHost></VirtualHost> tags

<Location "/server-status.monitor">
SetHandler server-status
Order Deny,Allow
Deny from all
Allow from 127.0.0.1
Allow from <your pubic ip>
</Location>

Find the section where css,js and images are excluded from rewrite rule this rule can be found in httpd.cof or  .htaccess of your website

RewriteCond %{REQUEST_URI} !^(.*).(css|js|gif|png|jpg|jpeg|swf|monitor)$

Add |monitor in the end

Restart the httpd 

Now try http://yourip/server-status.monitor






Tuesday, 31 May 2016

MS Sql Server LocalDB connectivity via classic asp [Correct Connection String]

In this post I will show how to make connection string for LocalDB to use with Classic ASP ( Might also work with PHP)


After googling and visiting connection string websites I am still stuck with error like

Microsoft OLE DB Provider for SQL Server error '80040e4d'
Invalid authorization specification
/login.asp, line 19

or

Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/login.asp, line 19

or

ADODB.Connection Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Microsoft OLE DB Provider for ODBC Drivers error '80004005' 
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 


Here is the list of Possible correct connection string

DSN Based  -While setup ODBC DSN I supplied Sql server authentication 




#1 Driver={SQL Server};Data Source=localsqldb;

#2 DSN=localsqldb;Uid=sa;Pwd=urpassword;

Why DNS based : I do not know but all tries were failed until i setup and made 1 successful connectivity with asp application using DSN after that other methods are also start working 

SQLOLEDB Based

#1 Windows authentication , I setup application pool and site identity to  computers username and password
 Provider=SQLOLEDB;Integrated Security=SSPI;Server=np:\\.\pipe\LOCALDB#SH5E512B\tsql\query;  


#2 Sql server authentication 

Provider=SQLOLEDB;Persist Security Info=False;Initial Catalog=urDBName;Data Source=np:\\.\pipe\LOCALDB#SH5E512\tsql\query;User Id=sa;Password=urpassword


To Setup SA for your localdb 

1. Start Navicat and login to DB via Windows authentication as i mention in my last post and run these queries


ALTER LOGIN sa ENABLE ;
GO
ALTER LOGIN sa WITH PASSWORD = 'urpassword' ;
GO


Ref -> http://stackoverflow.com/questions/26403000/how-can-i-setup-my-sql-server-localdb-to-be-as-close-to-a-normal-sql-server

Note : We have navicat so other steps shown on ref page is not required.

Regards

Tuesday, 24 May 2016

LinWin - Heidisql Navicat connectivity with Microsofts' Sql server LocalDB

In this post I will show how to retrieve connection string for LocalDB to use with Database admin tools

Navicat to  LocalDB Connectivity
Heidisql  to  LocalDB Connectivity

locate SqlLocalDB.exe in win 10 64 bit its located at \Program Files\Microsoft SQL Server\120\Tools\Binn


Start cmd (open command prompt)
Navigate to ->  cd \Program Files\Microsoft SQL Server\120\Tools\Binn

If you want to create new DB then run

> SqlLocalDB create "localsql"  -- here localsql is the name for new instance

After creating DB you need to start it

> SqlLocalDB start "localsql"  -- here localsql is the name for instance which needed to be started

To get the connection string for Navicat or Heidisql

> SqlLocalDB info "localsql"

C:\Program Files\Microsoft SQL Server\120\Tools\Binn>SqlLocalDB info "localsql"
Name:               localsql
Version:            12.0.2000.8
Shared name:
Owner:              Home\DELL
Auto-create:        No
State:              Running
Last start time:    24-05-2016 01:03:05 PM
Instance pipe name: np:\\.\pipe\LOCALDB#03AD832F\tsql\query

we need to put
Instance pipe name: np:\\.\pipe\LOCALDB#03AD832F\tsql\query
to hostname in navicat or Heidisql



Enjoy :)

LinWin - The First Post Discuss as newbie

Hi Friends,

I started this blog , because i found that lots of knowledge to fix server related issue is still missing and i am bored to create account on lots of site and posting the solution which worked for me.

In this blog i will only post the solution which worked for me and my analysis As i working with E-commerce company i believe these information will beneficial to every one

Techs which is going to be covered are

  • AWS
  • Azure
  • Linux - Centos
  • Monitoring Tools 
  • Security Tools
  • SSL
  • CDN
  • Mysql
  • Ms-Sql
  • Oracle
  • DB Management Tools
  • Caching
  • Reporting
  • Development tools
In my site no registration is required for posting but i will moderate all the comments , so that we can discuss all the aspects.
Please post all the comment so that even a newbie can just copy paste the solution.

With Regards
LinWin