How to setup Network Configuration in Ubuntu Server 14.04

Open Network Configuration file.

#nano /etc/network/interface

Then Add below mentioned lines and make changes as per your need.

auto eth0
iface eth0 inet static
address 192.168.0.101
gateway 192.168.0.1
netmask 255.255.0.0
network 192.168.0.0
broadcast 192.168.0.255

Now Save file.

Open DNS Configuration file

#/etc/resolv.conf

Add below mentioned lines with your DNS IPs.

nameserver 8.8.8.8
nameserver 8.8.4.4

Save file.

Open Second DNS conf file.

#nano /etc/resolvconf/resolv.conf.d/base

add below mentioned lines with your DNS IPs.

nameserver 8.8.8.8
nameserver 8.8.4.4

Save file and restart your Networking service with below command.

#/etc/init.d/networking restart or #service networking restart

Read More

Amazon RDS Restore MySQL Backup with functions

1) Open the RDS web console.

2) Open the “Parameter Groups” tab.





3) Create a new Parameter Group. On the dialog, select the MySQL family compatible to your MySQL database version, give it a name and confirm.



4) Select the just created Parameter Group and issue “Edit Parameters”.



 
5) Look for the parameter ‘log_bin_trust_function_creators’ and set its value to ‘1’ Save the changes.


5) Open the “Instances” tab. Expand your MySQL instance and issue the “Instance Action” named “Modify”. Find Database Options and Select Newly created parameter Group.











6) Select the just created Parameter Group and enable “Apply Immediately”.
Click on “Continue” and confirm the changes.



 
7) Again, open the “Instances” tab. Expand your MySQL instance and issue the “Instance Action” named “Reboot”.

 

All Done in AWS RDS now.. Need to made some changes in MySQL DB Backup.

Open your .sql backup file in any editor and find "CREATE DEFINER" from all functions lines as below and Delete "DEFINER='user'@'localhost' " and Save the .sql file and Restore your backup.


e.g. Default 
--
-- Functions
--
CREATE DEFINER=`user`@`localhost` FUNCTION `gettime`(`ts` DATETIME) RETURNS varchar(100) CHARSET latin1

e.g. After Remove 
--
-- Functions
--
CREATE FUNCTION `gettime`(`ts` DATETIME) RETURNS varchar(100) CHARSET latin1
 

That’s all! 

Read More