Tuesday, May 24, 2011

How to increase the size of import in phpmyadmin(other parameters also)

PhpMyAdmin gives the import size of 2mb only and if you had to import the database of larger than this size it does not except it so we can increase the size of the import option by following steps..

go to:
#vi /etc/php.ini       //php main setting file

find the following lines and replace these by the requirements you have i am giving you an example.

Original lines:
post_max_size = 8M
upload_max_filesize = 2M
max_execution_time = 30
max_input_time = 60
memory_limit = 8M

Change it to:
post_max_size = 750M
upload_max_filesize = 750M
max_execution_time = 5000
max_input_time =5000
memory_limit = 1000M

restart your httpd service and refresh your phpmyadmin to take effect.

Wednesday, May 18, 2011

How to install phpMyAdmin in Linux(Redhat or equivalent)

PhpMyAdmin is very important thing for any DBA or System admin as it gives full execess to our Mysql database as well as php configuration. The best part is it has GUI mode for handling all the related issues.

First install all the reated files to run Mysql, php, Apache

#Yum install apache
#yum install php-mysql
#yum install mysql-server

configure your Apache web server( If you have any problem regarding that you can look in my post "How to configure Apache wb server")

check in the /etc/httpd/conf.d that there is php.conf file is present

start all the required services

#service httpd start
#service mysqld start

Download the required phpMyAdmin interface from the net(just google phpmyadmin download u will get it)

After downloading it uncompress it

#tar -xjvf php.......(depending upon the version u downloaded)

move this folder to your web directory in which your site is located and remane it to your likings as i have done php.
move to the folder and open the configuration file, make changes in the setting so that you can excess it via http

# vi config.inc.php

73 $cfg['Servers'][$i]['auth_type']     = 'http';    (enter http here in '', line no 73)
:wq!             //save and quit

restart the httpd service and excess it via web browser, enter in the address browser your ip/php to excess

#service httpd restart
in web browser yourip/php

if you had set any password for your mysql than use that other wise it is blank

if you want to know the username and password of your phpMyAdmin go to
# vi config.inc.php
and see in
74    $cfg['Servers'][$i]['user']          = 'root';      // MySQL user
75    $cfg['Servers'][$i]['password']      = '';          // MySQL password

How to install openfiler

Openfiler is Linux based kernel which runs on anaconda also, here are the steps to install openfiler, i have installed it in through VmWare but same process will work in physical system also.

*boot the openfiler

*check your CD media if you want

*after that boot loader will start

*you will set a welcome screen ->next

*select your keyboard type

select automatic if you want openfiler to do default setting else manual for doing user define disk spacing,iam choosing manual.  

*you will get the disk setup menu

 *using new add new mount points according to your requirements

*add swap memory also in this  and required fields

*click yes to confirm it

*if you have DHCP configured use that to assign IP or you can enter manually by going to edit 

*enter the IP and network mask which you want to assign 

*Do rest of setting as you have your network 

 *select your region

*select yes to confirm it

*enter the password for the openfiler

*next to confirm it

*system installation will start

*reboot system to complete installation

*after reboot you will get main screen in which GUI address and openfiler login will be available

*you can login here it self by your username and password

*in your web browser enter your openfiler IP with port no to login ex:-

*enter username and password to enter

Default username and password for openfiler are

Setup fully configurable EFK Elasticsearch Fluentd Kibana setup in Kubernetes

In the following setup, we will be creating a fully configurable Elasticsearch, Flunetd, Kibana setup better known as EKF setup. There is a...