Connect to AWS RDS mysql remotely to VPC

There are different between connecting to MySQL (RDS) hosted in Amazon Web Services (AWS) in VPC and without VPC remotely from our computer/local.

For the RDS is not in VPC, we can add our local IP to RDS Dashboard -> Security Group.

The case is totally different if  RDS is in VPC. We are not allow to do any setting or add our local computer IP here.

In order for us to access/connect to MySQL (RDS) in AWS that is in VPC, we need to add our IP in VPC which is under EC2 Dashboard -> Security Group. Add local IP to the security group that is using the RDS. In My case is Default group.
Please follow the step by step guide in the print screen.

Hope this helps.

SQL Server 2008 is not a valid login or you do not have permission

Facing issue when try to install Microsoft SQL Server 2008 R2 in Windows 7.

TITLE: Microsoft SQL Server 2008 R2 Setup ------------------------------ The following error has occurred: '' is not a valid login or you do not have permission. For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&

Solution:

Most of the people will face this error if the computer name and the user name is the same. Once change one of these, problem will be solved.

404 - File or directory not found. when use codeigniter in windows iis

Facing error message when deploy codeigniter php site to windows server 2013 (iis8)

404 - File or directory not found.

The resource you are looking for might have been removed, had its name changed, or is temporarily unavailable.

The main issue is because of the url rewrite doesn't work in IIS without proper setting in web.config (IIS doesn't read .htacess)

What we need to do is open web.config

Add code below into the correct

<rewrite>
  <rules>
    <rule name="Rule" stopProcessing="true">
      <match url="^(.*)$" ignoreCase="false" />
      <conditions>
        <add input="{REQUEST_FILENAME}" matchType="IsFile" ignoreCase="false" negate="true" />
        <add input="{REQUEST_FILENAME}" matchType="IsDirectory" ignoreCase="false" negate="true" />
        <add input="{URL}" pattern="^/favicon.ico$" ignoreCase="false" negate="true" />
      </conditions>
      <action type="Rewrite" url="index.php/{R:1}" appendQueryString="true" />
    </rule>
  </rules>
</rewrite> 

>

If you are want to create the new web.config without others configuration, the web.config shoud looks like this

<?xml version="1.0" encoding="UTF-8"?>
<configuration>

<system.webServer>

    <httpErrors errorMode="Detailed" />
    <asp scriptErrorSentToBrowser="true"/>

   <rewrite>
  <rules>
    <rule name="Rule" stopProcessing="true">
      <match url="^(.*)$" ignoreCase="false" />
      <conditions>
        <add input="{REQUEST_FILENAME}" matchType="IsFile" ignoreCase="false" negate="true" />
        <add input="{REQUEST_FILENAME}" matchType="IsDirectory" ignoreCase="false" negate="true" />
        <add input="{URL}" pattern="^/favicon.ico$" ignoreCase="false" negate="true" />
      </conditions>
      <action type="Rewrite" url="index.php/{R:1}" appendQueryString="true" />
    </rule>
  </rules>
</rewrite> 

</system.webServer>


</configuration> 

Hope this helps

Cannot modify header information - headers already sent by

Facing error when try to use codeigniter and the page won't redirect after update / edit

 A PHP Error was encountered

    Severity: Warning

    Message: Cannot modify header information - headers already sent by (output started at xxxxx:1)

    Filename: libraries/Session.php

    Line Number: 675

 A PHP Error was encountered

    Severity: Warning

    Message: Cannot modify header information - headers already sent by (output started at xxxxx:1)

    Filename: helpers/url_helper.php

    Line Number: 542

How to solve my issue?

open index.php and add ob_start();  like below

ob_start();

/*
 *---------------------------------------------------------------
 * APPLICATION ENVIRONMENT
 *---------------------------------------------------------------
 *
 * You can load different configurations depending on your
 * current environment. Setting the environment also influences
 * things like logging and error reporting.
 *
 * This can be set to anything, but default usage is:
 *
 *     development
 *     testing
 *     production
 *
 * NOTE: If you change these, also change the error_reporting() code below
 *
 */

duplicate or clone MySQL database table

Many will facing issue when try to duplicate or clone database table in MySQL.
Below is the script and it's tested working well.

New table: tbltransaction_new
Existing table: tbltransaction

CREATE TABLE tbltransaction_new LIKE tbltransaction;
INSERT tbltransaction_new SELECT * FROM tbltransaction;

mozilla thunderbird not responding

I'm using the latest version of Mozilla Thunderbird which is version 31.0

Each time i try to send and receive email, it show Mozilla Thunderbird (Not Responding).

Not forgot to mention that i'm using McAfee Internet Security as antivirus. After doing some debugging, i've found out that disable Real Time Scanning can solve my problem. The issue is this might open to virus or spyware if i disable McAfee real time scanning. I go to McAfee FAQ and found that there is workaround stated in the FAQ.

McAfee recommend us to Disable Email Attachment Scan, steps as below

1.  Double-click the M icon in your taskbar.
2.  Open the Virus and Spyware Protection drawer.
3.  Select Real-Time Scanning.
4.  Open the Settings drawer.
5.  Remove the check from the box beside Scan these attachments and locations: Email attachments.

After disable the email attachment scanning, my mailbox work like normal.

Problem solved but i have to be extremely careful when open the email attachment. McAfee suggest that we manually scan the attachment before open it.

sign in to google drive ... stuck in one moment please

I've installed google drive in windows server 2012 for data backup purposes but when i try to login to google drive, it's stuck in one moment please without further action.

This can be solved by adding below link as trusted site in Internet Explorer.

• www.google.com:443/HTTPS
• accounts.google.com:443/HTTPS
• clients3.google.com:443/HTTPS
• talk.google.com:5222/XMPP
• drive.google.com:443/HTTPS
• www.googleapis.com:443/HTTPS
• ssl.gstatic.com:443/HTTPS
• *.docs.google.com:443/HTTPS
• *.drive.google.com:443/HTTPS
• *.googleusercontent.com:443/HTTPS

Once done, i can login to google drive without any problem.

Can refer to below link to know more.
https://support.google.com/drive/answer/2589954?hl=en&topic=14951&ctx=topic

Samsung Galaxy S2 auto rotate fail

My old Samsung Galaxy S2 with ICS auto rotation fail, i've try to follow some of the suggestion by doing both Calibration - Settings -> Display -> Horizontal Calibration,  Settings -> Display -> Gyroscope Calibration. Sorry to say, it's fail and nothing happen.

My solution:
My solution is pretty simple and it work for me. What i do is i shut down the mobile phone, remove the battery and simcard. After that put them back and start the mobile phone. It's like magic and it's working well now.

Download file from google drive directly from google drive without visit the page

Trying to make my file that already uploaded in Google Drive auto download without visit the page https://docs.google.com/file/d/0BxK6LimLvhcvQ2JUSXQzLXdtUzg and click on the download button.

Many suggest that https://docs.google.com/uc?export=download&id=fileID can work where fileID in my case is 0BxK6LimLvhcvQ2JUSXQzLXdtUzg 


I've tried to use https://docs.google.com/uc?export=download&id=0BxK6LimLvhcvQ2JUSXQzLXdtUzg but won't download automatically but it will stay and request user to click on the confirm download link. Maybe it's because the file exceeded certain file size.

There is another way which is working well https://googledrive.com/host/0BxK6LimLvhcvQ2JUSXQzLXdtUzg but the problem is the downloaded file name is the file id name

Unable to create directory wp-content/uploads/. Is its parent directory writable by the server?

I've upload and setup wordpress in windows server 2008 R2 using IIS. After successfully setup this application.

Facing error "Unable to create directory wp-content/uploads/2014/03. Is its parent directory writable by the server?". Prior to that, there are already some setting have been done, please check http://dotnetfish.blogspot.com/2013/10/error-message-500-internal-server-error.html

How to solve the problem? When upload the file to wordpress, the file will save into upload folder inside wp-content. What i do is add a modify permission to user IUSR and apply the setting to child folder as well.

After done the setting, problem solved.

Upgrade AWS EC2 micro instance to small instance running in windows

There are many discussion on upgrade Amazon Web Services (AWS) from micro instance to small instance in EC2, here i would like to share my experience on doing the upgrade safely for my micro instance that running in windows and also increate EBS size from 30GB (micro instance) to the desired EBS size (in my sample is 35GB) and also remap the elastic IP to the newly upgraded instance.

in general, there are a few steps

1. Create a AIM for current instance with desired EBS size (call it AIM-Today) 
2. Create new small instance with newly created AIM (AIM-Today)
3. Login to the server using remote desktop and extend the C drive volumn
4. Remap the elastic IP

Below are step by step on how to do it.

1. Under Instances - Instances
   Select/checked current instance that wish to upgrade from micro to small then click on Action button. In the dropdown list click on Create Image
    
   
   
   
2. After click on Create Image, a popup with image option will be displayed. Enter the Image name and change the root size from 30GB to 35GB (this is the desired ebs size) and click on Create Image button.
   
   
   
   
   
3. A popup will be displayed to shows that create image request received.
   
   
   
   
   
4. Under Images - AMIs
   Select/Check on newly created AMI and click on Launch button.
   
   
   
   
   
5. After click on Launch button, we need to choose instance type. For my case, i wish to upgrade to small instance so i select m1.small and click on Next: Configure Instance Details button.
   
   
   
   
   
6. Keep the default setting in Configure Instance and click on Next: Add Storage button.
   
   
   
   
   
7. In Add Storage stage, make sure the Size is a desired size. My case is 35GB which is correct. Click on Next: Tag Instance button to proceed
   
   
   
   
   
8. In Tag Instance stage, add Key Name and Value New Small Instance. This name can be changed later. Click on Next: Configure Security Group button to proceed.
   
   
   
   
   
9. In security group setting, i select my existing security group which is using in current server . Click on Review and Launch button to proceed.
   
   
   
   
   
10. In review stage, you can do changes if required. After all changes done, click on Launch button
    
    
    
    
    
    
11. You will be asked to enter key pair. In this case, i'll use existing key pair to launch the instance. Click on Launch Instance button after setting the key pair.
    
    
    
    
    
12. After Launch the instance we have to wait until it fully launched. Go to check the Public IP and remote into the server using Remote Desktop.
    
    
    
13. After remote into the server using Remote Desktop with the administrator login and password (Same as current server remote desktop login). Go to My Computer and check on the harddisk size. Notice that the size is exactly the same as Micro instance which is 30GB. This is because we haven't allocate the newly added 5GB into C drive. We will need to extend the volume to this drive in the next few steps.
    
    
    
    
    
14. Open on Server Manager and expend the Storage on the left menu. Click on Disk Manager to view the disk in this computer. Notice that there is unallocated 5GB.
    
    
    
    
    
15. Right Click on the C: in the bottom and Select Extend Volume ..
    
    
    
16. Follow the default setting and click on finish button once done.
    
    
    
    
17. Now we can go to My Computer to check on the C drive size again. Notice that the size increase to 35GB which is correct.
    
    
    
18. Now, we need to associate the elastic IP to the newly setup instance.
    Go to Network & Security - Elastic IPs
    Select/check the Elastic IP that wish to remap or reassociate to the newly setup instance and then Click on Associate Address button.
    
    
    
19. Popup screen display and you can select the instance which you wish to associate the IP. Click on Associate button once selected. Done.
    
    
    

By using above steps, there will be no downtime required. The upgrade is the safest way without losing any data.

How to determine MSSQL version and edition?

How to determine MS SQL version and edition?

1. Go to Open Query Analyzer 
2. Paste sql script below
   
   SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
3. Click on Execute button

There you can see the version and edition for Microsoft SQL server installed in your computer.

install wordpress in IIS - auto redirect to another folder

i’ve set up a wordpress blog in http://www.xxx.com/blog , whenever i go this this site, it will redirect me to http://www.xxx.com/xxx.com/blog/ and it will shows error message not found.

The site is hosted in godaddy window server.

The reason for this is cause the way Windows IIS handles the trailing slash. It show that you have the WordPress setup on a folder called blog on your aliased domain name. If you go to the url that is set in the WordPress it works. You will need to make sure you have it as http://www.xxx.com/blog/ or it will redirect incorrectly.