Search This Blog

Loading...

Sunday, November 9, 2014

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.

Saturday, November 1, 2014

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.

Thursday, October 16, 2014

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




Friday, September 26, 2014

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
 *
 */

Thursday, September 4, 2014

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;

Sunday, August 10, 2014

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.

Tuesday, June 3, 2014

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

Sunday, May 4, 2014

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.

Wednesday, March 5, 2014

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


Sunday, March 2, 2014

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.