Codeigniter mode rewrite not working in AWS EC2 Ubuntu

The server is newly deployed in AWS EC2 running Ubuntu 16.04, Apache/2.4.18 web server with PHP 7.0.33

After uploading the new Codeigniter files into the server, the route is not working. In my case, i am uploading the files to /var/www/html/myfiles and i access through IP address for example:
http://xxx.xxx.xxx.xxx/myfiles

The files in running well in my local.

There are a few steps that need to perform in order to get it working

Step 1 — Enabling mod_rewrite
We need to activate mod_rewrite. It’s already installed, but it’s disabled on a default Apache installation. Use the a2enmod command to enable the module:

sudo a2enmod rewrite

This will activate the module or alert you that the module is already enabled. To put these changes into effect, we need to restart Apache.

sudo systemctl restart apache2


Step 2 — Enable AllowOverrideAll in default.conf

sudo nano /etc/apache2/sites-available/000-default.conf

Inside that file, you will find a <VirtualHost *:80> block starting on the first line. Inside of that block, add the following new block so your configuration file looks like the following. Make sure that all blocks are properly indented.

/etc/apache2/sites-available/000-default.conf

<VirtualHost *:80>
    <Directory /var/www/html>
        Options Indexes FollowSymLinks MultiViews
        AllowOverride All
        Require all granted
    </Directory>

    . . .
</VirtualHost>

Save and close the file. To put these changes into effect, we need to restart Apache.

sudo systemctl restart apache2

Now, we need to create an .htaccess file in the web root.

sudo nano /var/www/html/.htaccess

Add this line at the top of the new file to activate the rewrite engine.

/var/www/html/.htaccess

RewriteEngine on

Save the file and exit.

Now, it working well when I access to http://xxx.xxx.xxx.xxx/myfiles

Permissions 0644 for xxxx.pem are too open. It is required that your private key files are NOT accessible by others. This private key will be ignored. Permission denied (publickey)

Facing error when try to SSH to my ubuntu server from Mac


@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@         WARNING: UNPROTECTED PRIVATE KEY FILE!          @
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
Permissions 0644 for '/Users/xxxx/Desktop/Working Folder/xxxx.pem' are too open.
It is required that your private key files are NOT accessible by others.
This private key will be ignored.
Load key "/Users/xxxx/Desktop/Working Folder/xxxx.pem": bad permissions
ubuntu@xxx.xxx.xxx.xxx: Permission denied (publickey).
Keiths-MBP:~ keith$ ssh -i '/Users/xxxx/Desktop/Working Folder/xxxx.pem' ubuntu@xxx.xxx.xxx.xxx
_________________________________________________________________________________

To solve the problem, change the file 'xxxx.pem' permission to 600.

Open Mac Terminal and enter command line below.

sudo chmod 600  '/Users/xxxx/Desktop/Working Folder/xxxx.pem'

try the SSH again, problem solved.

Touch screen not working in Google Chrome after upgrade to Windows 10

I have upgraded to windows 10 from windows 8.1 and following with the upgrade, touch screen in google chrome become not working. After google around, i found one solution which solve my problem.

1. Enter chrome://flags in the URL

2. Change the "Enable Touch Events" setting from "Automatic" to "Enable".

Restart google chrome and try again.

i am using Dell Inspiron 14 7000 series. It works for me. It works in Asus, Lenovo, Toshiba, Surface Pro and etc.

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