Use the following command to dump and restore mysql database
mysqldump -u root -p dbName > /var/www/dbBackup.sql
mysql -u root -p dbName < /var/www/dbBackup.sql
Friday, December 17, 2010
Monday, December 13, 2010
SCP command to transfer files using putty or shell
transfer the files from user localhost machine to remote server
$scp -r /home/myfolder/* root@remote server ip:/root/myfolder
if remote server running on different port
$scp -r -P remoteserverportnumer /home/myfolder/* root@remote server ip:/root/myfolder
$scp -r /home/myfolder/* root@remote server ip:/root/myfolder
if remote server running on different port
$scp -r -P remoteserverportnumer /home/myfolder/* root@remote server ip:/root/myfolder
Monday, November 29, 2010
install clamAV on httpd server
We need to check following
php-devel and clamav-devel.
To check for the software, use the commands below:
If nothing is returned from either rpm command, you will need to install the devel for the appropriate version.
If not installed the php-devel and clamav-devel install using yum
like
CODE
yum install php-devel
extract the library
Note: /usr/lib/php/modules is my modules directory. Your module directory may be different. Search /etc/php.ini for extension_dir to get yours.
Edit /etc/php.ini (Make sure you make a backup!)
Add the following under the "Dynamic Extensions" section:
Note: My clamav.dbpath may be different than yours. Do a simple locate main.cvd for the db directory.
Test to see if it works:
[PHP] echo cl_info() . "
";
$file = "/tmp/eicar.com";
cl_scanfile_ex($file, CL_SCAN_STDOPT, $virus, $retcode);
if ($retcode == CL_VIRUS)
echo $file . " returns: " . cl_pretcode($retcode) . " virus name: " . $virus . "
";
else
echo $file . " returns: " . cl_pretcode($retcode) . "
";
?>[/PHP]
Go to http://www.phpclamavlib.org/ for more information on the functions included with this module.
Good luck!
php-devel and clamav-devel.
To check for the software, use the commands below:
CODE
rpm -q php-devel
CODE
rpm -q clamav-devel
If nothing is returned from either rpm command, you will need to install the devel for the appropriate version.
If not installed the php-devel and clamav-devel install using yum
like
CODE
yum install php-devel
extract the library
CODE
tar xvzf php-clamavlib-0.12a.tar.gz
CODE
cd php-clamav-0.1
CODE
phpize
CODE
./configure --with-clamav
CODE
make
CODE
cp modules/clamav.so /usr/lib/php/modules
Note: /usr/lib/php/modules is my modules directory. Your module directory may be different. Search /etc/php.ini for extension_dir to get yours.
Edit /etc/php.ini (Make sure you make a backup!)
Add the following under the "Dynamic Extensions" section:
CODE
extension=clamav.so
[clamav]
clamav.dbpath="/var/clamav"
clamav.maxreclevel=0
clamav.maxfiles=0
clamav.archivememlim=0
clamav.maxfilesize=0
clamav.maxratio=0
[clamav]
clamav.dbpath="/var/clamav"
clamav.maxreclevel=0
clamav.maxfiles=0
clamav.archivememlim=0
clamav.maxfilesize=0
clamav.maxratio=0
Note: My clamav.dbpath may be different than yours. Do a simple locate main.cvd for the db directory.
Test to see if it works:
[PHP] echo cl_info() . "
";
$file = "/tmp/eicar.com";
cl_scanfile_ex($file, CL_SCAN_STDOPT, $virus, $retcode);
if ($retcode == CL_VIRUS)
echo $file . " returns: " . cl_pretcode($retcode) . " virus name: " . $virus . "
";
else
echo $file . " returns: " . cl_pretcode($retcode) . "
";
?>[/PHP]
Go to http://www.phpclamavlib.org/ for more information on the functions included with this module.
Good luck!
Mysql dump and restore database
To dump and restore all database of mysql server use following command
mysqldump -u root -psecret --all-databases > /var/www/backup.sql
mysql -u root -psecret < /var/www/backup.sql
mysqldump -u root -psecret --all-databases > /var/www/backup.sql
mysql -u root -psecret < /var/www/backup.sql
Thursday, November 18, 2010
mysql access denied for user 'root@localhost' using password yes
we are getting the comman error for phpmyadmin login
or doing the new set of mysql and trying to connect mysql
mysql access denied for user 'root@localhost' using password yes
Solution
or doing the new set of mysql and trying to connect mysql
mysql access denied for user 'root@localhost' using password yes
Solution
root@localhost$ mysqladmin -u root password NEWPASSWORD OR you want to update root@localhost$ mysqladmin -u root -p 'OLDPASSWORD' password NEWPASSWORD
issue get resolved... if still issue try to do following... 1) Restart mysql service myqsql restart
if still issue do following
1) execute following command$ mysqlmysql > use mysqlmysql >UPDATE mysql.user SET Password=PASSWORD("*******")WHERE User="root"; mysql > FLUSH PRIVILEGES;
mysql > quit;
Update the root password for mysql database
To update the password of mysql database for root user
1) Login in into mysql prompt.
mysql>UPDATE mysql.user SET Password=PASSWORD("*******") WHERE User="root";
mysql>FLUSH PRIVILEGES;
done.
1) Login in into mysql prompt.
mysql>UPDATE mysql.user SET Password=PASSWORD("*******") WHERE User="root";
mysql>FLUSH PRIVILEGES;
done.
Wednesday, November 17, 2010
check/repair file system - Linux
Use fsck command to check/repair file system in linux
e.g
1) if file system is ext3 and you want to check the disk mounted on sda1 then use following command
fsck -t ext3 /dev/sda1
1) if file system is ext4 and you want to check the disk mounted on sda2 then use following command
fsck -t ext4 /dev/sda2
How to check which file system is installed.
Run following command
mount
How to check the mounted file system,
Run following command
fdisk -l
e.g
1) if file system is ext3 and you want to check the disk mounted on sda1 then use following command
fsck -t ext3 /dev/sda1
1) if file system is ext4 and you want to check the disk mounted on sda2 then use following command
fsck -t ext4 /dev/sda2
How to check which file system is installed.
Run following command
mount
How to check the mounted file system,
Run following command
fdisk -l
Thursday, May 20, 2010
<style>
html, body {
height: 100%;
}
#container {
min-height: 100%;
margin-bottom: -80px;
position: relative;
}
#footer {
height: 80px;
position: relative;
}
.clearfooter {
height: 80px;
clear: both;
}
</style>
<html>
<body>
<div id="container">
<div id="header">Header</div>
<div id="nav">
<ul>
<li><a href="#">Home</a></li>
<li><a href="#">Page 1</a></li>
<li><a href="#">Page 2</a></li>
</ul>
</div>
<div id="content">Content Here.</div>
<div class="clearfooter"></div>
</div><!--End Container-->
<div id="footer">Footer Here.</div>
</body>
</html>
html, body {
height: 100%;
}
#container {
min-height: 100%;
margin-bottom: -80px;
position: relative;
}
#footer {
height: 80px;
position: relative;
}
.clearfooter {
height: 80px;
clear: both;
}
</style>
<html>
<body>
<div id="container">
<div id="header">Header</div>
<div id="nav">
<ul>
<li><a href="#">Home</a></li>
<li><a href="#">Page 1</a></li>
<li><a href="#">Page 2</a></li>
</ul>
</div>
<div id="content">Content Here.</div>
<div class="clearfooter"></div>
</div><!--End Container-->
<div id="footer">Footer Here.</div>
</body>
</html>
Tuesday, March 9, 2010
Play WMV in Browser
1) Replace "http://www.example.com/myfile.wmv" with your file name.
2) Replace "[" with "<"
3) Replace "]" with ">"
[object id="MediaPlayer" width=640 height=480 classid="CLSID:22D6f312-B0F6-11D0-94AB-0080C74C7E95" standby="Loading Windows Media Player components..." type="application/x-oleobject" codebase="http://activex.microsoft.com/activex/controls/mplayer/en/nsmp2inf.cab#Version=6,4,7,1112"]
[param name="filename" value="http://www.example.com/myfile.wmv"]
[param name="Showcontrols" value="True"]
[param name="autoStart" value="FALSE"]
[embed type="application/x-mplayer2" src="http://www.example.com/myfile.wmv" width=640 height=480][/embed]
[/object]
Enjoy the code
2) Replace "[" with "<"
3) Replace "]" with ">"
[object id="MediaPlayer" width=640 height=480 classid="CLSID:22D6f312-B0F6-11D0-94AB-0080C74C7E95" standby="Loading Windows Media Player components..." type="application/x-oleobject" codebase="http://activex.microsoft.com/activex/controls/mplayer/en/nsmp2inf.cab#Version=6,4,7,1112"]
[param name="filename" value="http://www.example.com/myfile.wmv"]
[param name="Showcontrols" value="True"]
[param name="autoStart" value="FALSE"]
[embed type="application/x-mplayer2" src="http://www.example.com/myfile.wmv" width=640 height=480][/embed]
[/object]
Enjoy the code
Tuesday, February 9, 2010
One to Many Relation in RDBMS single SQL to fetch data
Many times we need a single sql that fetch the data from one to many relation ship.
in mysql database we can achive this with the help of OUTER JOIN.
let say employee table having the record with emp_id and each employee have multiple contact number in table emp_contact so we fetch the record in single sql employee with there contact list.
SELECT
emp.*,
con.contact_number_list
FROM
emp
LEFT OUTER JOIN (
SELECT emp_id, GROUP_CONCAT( CAST(contact_num as CHAR ) ) as contact_number_list
FROM emp_contact
GROUP BY emp_id
) AS con ON con.emp_id = emp.emp_id
in mysql database we can achive this with the help of OUTER JOIN.
let say employee table having the record with emp_id and each employee have multiple contact number in table emp_contact so we fetch the record in single sql employee with there contact list.
SELECT
emp.*,
con.contact_number_list
FROM
emp
LEFT OUTER JOIN (
SELECT emp_id, GROUP_CONCAT( CAST(contact_num as CHAR ) ) as contact_number_list
FROM emp_contact
GROUP BY emp_id
) AS con ON con.emp_id = emp.emp_id
Tuesday, January 19, 2010
Magento after installtion can not able to login
Solution:
I googled and found these solutions:-
a) Use 127.0.0.1 instead of localhost in your url, i.e. using http://127.0.0.1/magento/index.php/admin instead of http://localhost/magento/index.php/admin . But this didn’t solve my problem.
b) Since I am using Linux, I was suggested to open "hosts" file from /etc/hosts and have 127.0.0.1 point to something like magento.localhost or even 127.0.0.1 point to http://www.localhost.com.
But this option i not tested.
c) This solution finally helped me out of this problem. The solution was to modify the core Magento code. Open app/code/core/Mage/Core/Model/Session/Abstract/Varien.php.
Comment out the lines 80 to 83. The line number may vary according to the Magento version. But these lines are present somewhere near line 80. You have to comment the comma (,) in line: $this->getCookie()->getPath()//,
// set session cookie params
session_set_cookie_params(
$this->getCookie()->getLifetime(),
$this->getCookie()->getPath()//,
//$this->getCookie()->getDomain(),
//$this->getCookie()->isSecure(),
//$this->getCookie()->getHttponly()
);
I googled and found these solutions:-
a) Use 127.0.0.1 instead of localhost in your url, i.e. using http://127.0.0.1/magento/index.php/admin instead of http://localhost/magento/index.php/admin . But this didn’t solve my problem.
b) Since I am using Linux, I was suggested to open "hosts" file from /etc/hosts and have 127.0.0.1 point to something like magento.localhost or even 127.0.0.1 point to http://www.localhost.com.
But this option i not tested.
c) This solution finally helped me out of this problem. The solution was to modify the core Magento code. Open app/code/core/Mage/Core/Model/Session/Abstract/Varien.php.
Comment out the lines 80 to 83. The line number may vary according to the Magento version. But these lines are present somewhere near line 80. You have to comment the comma (,) in line: $this->getCookie()->getPath()//,
// set session cookie params
session_set_cookie_params(
$this->getCookie()->getLifetime(),
$this->getCookie()->getPath()//,
//$this->getCookie()->getDomain(),
//$this->getCookie()->isSecure(),
//$this->getCookie()->getHttponly()
);
Magento installtion Deprecated error for php5.3
Deprecated errors
a) split is deprecated.
to override these issue please make following changes of reporting error
y:\magento\index.php in these file replace error_reporting with following one
error_reporting(E_ALL & E_STRICT & ~E_DEPRECATED);
y:\magento\downloader\Maged\Pear.php in these file replace error_reporting with following one
error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED);
y:\magento\lib\Varien\Pear.php in these file replace error_reporting with following one
error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED);
a) split is deprecated.
to override these issue please make following changes of reporting error
y:\magento\index.php in these file replace error_reporting with following one
error_reporting(E_ALL & E_STRICT & ~E_DEPRECATED);
y:\magento\downloader\Maged\Pear.php in these file replace error_reporting with following one
error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED);
y:\magento\lib\Varien\Pear.php in these file replace error_reporting with following one
error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED);
Saturday, January 16, 2010
Magento not working on PHP 5.3
Fatal error: Method Varien_Object::__tostring() cannot take arguments in /magento/lib/Varien/Object.php
Change 1) /lib/Varien/Object.php (Line 484)
Change from
public function ___toString(array $arrAttributes = array(), $valueSeparator=’,')
To this
public function __invoke(array $arrAttributes = array(), $valueSeparator=’,')
Change 2) File /app/code/core/Mage/Core/Controller/Request/Http.php (Line 274)
Change from
$host = split(‘:’, $_SERVER['HTTP_HOST']);
To this
$host = explode(‘:’, $_SERVER['HTTP_HOST']);
Change 1) /lib/Varien/Object.php (Line 484)
Change from
public function ___toString(array $arrAttributes = array(), $valueSeparator=’,')
To this
public function __invoke(array $arrAttributes = array(), $valueSeparator=’,')
Change 2) File /app/code/core/Mage/Core/Controller/Request/Http.php (Line 274)
Change from
$host = split(‘:’, $_SERVER['HTTP_HOST']);
To this
$host = explode(‘:’, $_SERVER['HTTP_HOST']);
Thursday, January 14, 2010
PHP5 foreach loop using reference variable
// In PHP5 foreach loop using reference variable
// Example
$arr = array(2,3,4,5);
print_r($arr); // Array ( [0] => 2 [1] => 3 [2] => 4 [3] => 5 )
foreach ($arr as &$value) {
if($value == 4) { $value = 77; }
}
print_r($arr); // Array ( [0] => 2 [1] => 3 [2] => 77 [3] => 5 )
// Example
$arr = array(2,3,4,5);
print_r($arr); // Array ( [0] => 2 [1] => 3 [2] => 4 [3] => 5 )
foreach ($arr as &$value) {
if($value == 4) { $value = 77; }
}
print_r($arr); // Array ( [0] => 2 [1] => 3 [2] => 77 [3] => 5 )
Wednesday, January 13, 2010
PHP Variables passed by value or by reference?
//PHP Variables passed by value or by reference?
//
//Variable is passed by value.
// for PHP5 Object passed by Reference, Object handler (Object variable) passed by // value
// for PHP4 Object passed by value, Object handler (Object variable) passed by value
//example
function test1($a) {
$a=2;
}
function test2(&$a) {
$a=2;
}
$a = 1;
echo $a; // output 1
test1($a);
echo $a; // output 1
// as variable is passed by value
//case for passed by reference
$a = 1;
echo $a; // output 1
test2($a);
echo $a; // output 2
// as variable is passed by reference
// now interesting case about objects
// in PHP 5 Object are always passed by reference
// in PHP 4 Object are passed by value
// object handler (Object variables) are passed by value
// see example
class Test {
var $strVal = 1;
function getValue() {
return $this->strVal;
}
}
function test($obj) {
echo $obj->getValue();
$obj->strVal = 2;
}
// now test cases
$obj1 = new Test();
test($obj1);
echo " ".$obj1->strVal;
// output 1 2 (In PHP5)
// output 1 1 (In PHP4)
// now explanation
// $obj1 is new object created. $obj1 is represent the handler for that new object
// test is called then handler is passed by value and object is passed by reference
// so $obj1 and $obj are object handler pointing to same object
// so you will get out put as 1 2 in PHP 5
// in case of PHP4 output will be 1 1 because object passed by values
// so $obj1 and $obj are two object handler pointing two different instances of Test class.
// now for PHP 4 if you want to pass object as reference then just changes test method as // follows
// add the & sign before parameter
function test(&$obj) {
echo $obj->getValue();
$obj->strVal = 2;
}
//
//Variable is passed by value.
// for PHP5 Object passed by Reference, Object handler (Object variable) passed by // value
// for PHP4 Object passed by value, Object handler (Object variable) passed by value
//example
function test1($a) {
$a=2;
}
function test2(&$a) {
$a=2;
}
$a = 1;
echo $a; // output 1
test1($a);
echo $a; // output 1
// as variable is passed by value
//case for passed by reference
$a = 1;
echo $a; // output 1
test2($a);
echo $a; // output 2
// as variable is passed by reference
// now interesting case about objects
// in PHP 5 Object are always passed by reference
// in PHP 4 Object are passed by value
// object handler (Object variables) are passed by value
// see example
class Test {
var $strVal = 1;
function getValue() {
return $this->strVal;
}
}
function test($obj) {
echo $obj->getValue();
$obj->strVal = 2;
}
// now test cases
$obj1 = new Test();
test($obj1);
echo " ".$obj1->strVal;
// output 1 2 (In PHP5)
// output 1 1 (In PHP4)
// now explanation
// $obj1 is new object created. $obj1 is represent the handler for that new object
// test is called then handler is passed by value and object is passed by reference
// so $obj1 and $obj are object handler pointing to same object
// so you will get out put as 1 2 in PHP 5
// in case of PHP4 output will be 1 1 because object passed by values
// so $obj1 and $obj are two object handler pointing two different instances of Test class.
// now for PHP 4 if you want to pass object as reference then just changes test method as // follows
// add the & sign before parameter
function test(&$obj) {
echo $obj->getValue();
$obj->strVal = 2;
}
About PHP5
PHP5 has improved support for OOPS when compared to PHP4. The 4 pillars of OOPS are fully supported by PHP5 i.e. Encapsulation, Inheritance, Polymorphism and abstraction. You can also create interfaces; if you have been designing classes for a
while, you know how important interfaces are.
PHP5 also provides performance improvements as it has made significant changes to its
core ‘C’ code. This means that the execution of PHP5 programs will now gain the
needed performance improvement.
PHP5 has an integrated support for SOAP as it provides in-built classes for SOAP calls.
PHP5 offers Exception handling mechanism that was missing in its earlier version. You no longer have to write your own logic to return different type of values from one function to another in case of errors. You can now surround your code by try..catch blocks and write necessary logic inside your functions and raise an Exception. You can also extend from the existing Exception class to create your own Exception class.
while, you know how important interfaces are.
PHP5 also provides performance improvements as it has made significant changes to its
core ‘C’ code. This means that the execution of PHP5 programs will now gain the
needed performance improvement.
PHP5 has an integrated support for SOAP as it provides in-built classes for SOAP calls.
PHP5 offers Exception handling mechanism that was missing in its earlier version. You no longer have to write your own logic to return different type of values from one function to another in case of errors. You can now surround your code by try..catch blocks and write necessary logic inside your functions and raise an Exception. You can also extend from the existing Exception class to create your own Exception class.
Subscribe to:
Posts (Atom)