Wireshark compilation from source-code

for Ubuntu
        step1: sudo apt-get install autoconf bison flex libtool libgtk2.0-dev libpcap-dev libc-ares-dev /
libsmi2-dev libgnutls-dev libgcrypt11-dev libkrb5-dev libcap2-bin libgeoip-dev libortp-dev /
libportaudio-dev

step2: tar -xvf wireshark-1.8.0.tar.bz2

step3: cd /tmp/wireshark-1.8.0

step4: ./configure --enable-setcap-install

step5: make

step6: make install

step7: ldconfig

Importing Large MySql File Using phpMyAdmin

For importing large MySQL file using phpmyadmin follow the below procedure
i am using XAMPP, same should work with WAMP also

1) Go to the phpmyadmin folder D:\xampp\phpMyAdmin  or D:\xampp\phpMyAdmin\libraries\config.default.php
2) Open the file config.inc.php
3) find the line or insert the below line, this says the upload folder should be where we will be storing the sql file for importing
 $cfg['UploadDir'] = 'upload';
4) Create a folder  ‘upload'  in C:\xampp\phpMyAdmin

Now we can place large sql file, created using mysqldump or mysql export. I had placed a sql file with file name test-db-dump.sql

5) Now go the DB through phpMyAdmin and click on the import tab as seen below,



 
  In the combo box you can see the file we copied,  Now  hit the Go button in the bottom of the page, it will import the whole sql file to your database.


NOTE:
If you get the below error
 Fatal error: Maximum execution time of 300 seconds exceeded in

Edit the phpMyAdmin\libraries\config.default.php
$cfg['ExecTimeLimit'] = 300;

change the 300 to 1000 or more

Trimming all fields in MySQL database

UPDATE `table1` SET `tbl_column1`= trim(`tbl_column1`);

The above SQL query  will trim all the fields in the tbl_column1

adding user to sudo or admin group in ubuntu

If your system has an admin or sudo group, then we can add the user to that group using the following command.

adduser <username> admin or

adduser <username> sudo.

you should be in sudo or admin login to use the above command

after that if you are not able to get the sudo bash or su -, if you get the below message again

<username> is not in the sudoers file.  This incident will be reported.


Now login to the root user, if you  have permission or boot using Linux resuce CD or boot the PC in recovery mode

1) In root user mode, Type visudo and press enter
this will open /etc/sudoers
add one line...
<username>  ALL = (ALL) ALL

enabling or disabling MySQL log

To see the current status of mysql log, type the following command in XAMPP

SHOW VARIABLES LIKE  'general_log';

below output will come in the phpmyadmin

Variable_name	Value
general_log	OFF

To enable the log, type
SET GLOBAL general_log = 1;
Disabling log
SET GLOBAL general_log = 0;


To check where is the log file saved 
 SHOW VARIABLES LIKE  'general_log_file';

Below output will come
Variable_name    Value
general_log_file    \xampp\mysql\data\dino-laptop.log
 
The log files will be saved in the above mentioned path
 

disabling signup option in mantis bug tracker

For disabling the signup option in mantis bug tracker , open  the file mantis/config_inc.php

add the below line

 $g_allow_signup configuration = OFF; 

save the file. After this, int he mantis login page, there wont be option for new user signing up.

PHP Fatal error: Allowed memory size of 134217728 bytes exhausted

PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 89 bytes)

In my php script, i was  not able to get page view, the page was having lot of variables.  and some was taking lot since it was in foreach loop updating a big table output.

debugging foudn that, it was due to memory was not sufficient for the php to allocate.
In the php.ini we cam increase the memory with the  memory_limit = 128M configuration. After increasing the size form 128M to 256M, mine was working fine.

But i think i should re design the webpage as php consuming this much memory is not good in long term. There will be better way to reduce it .