Creating a Redhat package repository

First check the repolist with below command.

# yum repolist
Loaded plugins: product-id, refresh-packagekit, security, subscription-manager
This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
repolist: 0

Run below command to check your CD or ISO file mounted on you machine.



# mount | grep iso9660
/dev/sr0 on /media/RHEL_6.4 x86_64 Disc 1 type iso9660 (ro,nosuid,nodev,uhelper=udisks,uid=500,gid=500,iocharset=utf8,mode=0400,dmode=0500)



Now You can make repo file to listen repo management.

# nano /etc/yum.repos.d/RHEL64.repo

and paste below mentioned lines.

[RHEL64]
name=RHEL64
baseurl="file:///media/RHEL_6.4 x86_64 Disc 1/"
gpgcheck=0


Once created repo file check with below.
# yum repolist

Loaded plugins: product-id, refresh-packagekit, security, subscription-manager
This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
repo id                                                     repo name                                                           status
RHEL_6.4_Disc                                               RHEL_6.4_x86_64_Disc                                                3,648
repolist: 3,648




Now You can able to install default packages which is stored in you Disk like below.


[root@vm ~]# yum install httpd
Loaded plugins: product-id, refresh-packagekit, security, subscription-manager
This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package httpd.x86_64 0:2.2.15-26.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package       Arch           Version               Repository             Size
================================================================================
Installing:
 httpd         x86_64         2.2.15-26.el6         RHEL64         821 k

Transaction Summary
================================================================================
Install       1 Package(s)

Total download size: 821 k
Installed size: 2.9 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : httpd-2.2.15-26.el6.x86_64                                   1/1
  Verifying  : httpd-2.2.15-26.el6.x86_64                                   1/1

Installed:
  httpd.x86_64 0:2.2.15-26.el6                                                 

Complete!

Read More

PDOException: SQLSTATE[42000]: 1148 The used command is not allowed with this MySQL version in AWS RDS

To Resolve this error you have to connect mysql with below command then you can able to run LOCAL INFILE command in mysql console or drupal.


# mysql --local-infile=1 -h rds-amazon-url.com -uroot -p


Now you can able to run LOCAL INFILE command in RDS.

#mysql>LOAD DATA LOCAL INFILE '/tmp/foo.txt' INTO TABLE foo
COLUMNS TERMINATED BY '\t';

Read More