Monday, 22 February 2016

how to secure "http://localhost/phpmyadmin/" phpmyadmin on your LAN XAMPP 5.X

 goto C:\xampp\phpMyAdmin

open
 config.inc.php

edit the ff:

Set the Login type to use HTTP Basic authentication (cookie is default):
$cfg['Servers'][$i]['auth_type'] = 'http'; Configure phpMyAdmin to access MySQL directly on IP 127.0.0.1. *There is no point in resolving "localhost", and this will also remove the chance of localhost resolving to IPv6 loopback address "::1", which MySQL might not be bound to (causing all kinds of issues):
$cfg['Servers'][$i]['host'] = '127.0.0.1'; Allow users to login that have no password set (ex: root):
$cfg['Servers'][$i]['AllowNoPassword'] = true; Define phpMyAdmin's Control user (internal use):

$cfg['Servers'][$i]['controlhost'] = 'localhost';
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'pmapass';
Use all of the advanced phpMyAdmin features:

$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';
$cfg['Servers'][$i]['relation'] = 'pma__relation';
$cfg['Servers'][$i]['table_info'] = 'pma__table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma__column_info';
$cfg['Servers'][$i]['history'] = 'pma__history';
$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';
$cfg['Servers'][$i]['tracking'] = 'pma__tracking';
$cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords';
$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
$cfg['Servers'][$i]['recent'] = 'pma__recent';
$cfg['Servers'][$i]['users'] = 'pma__users';
$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';

Gilmon D. Bernal

Tuesday, 8 December 2015

NRR - Noise Reduction Rating

NRR - Noise Reduction Rating - Help

All hearing protectors supplied in the USA should be provided with an NRR figure. It can be used to estimate the sound level at the ear when wearing the protectors.
To calculate the level at the ear, fist measure the worker's noise exposure, either in dB(A) or dB(C). This level can be entered into the NRR Calculator, along with information about the regulations that you are following: OSHA or NIOSH as each of these uses a different calculation.
nrr calculator
The NoiseMeters NRR Calculator uses the following calculation methods:
Regs Freq.
Wgt
Calculation
     
OSHA A Lprot = L - (NRR - 7) / 2



  C Lprot = L - NRR / 2
     
NIOSH A Lprot = L - (NRR - 7)



  C Foam Earplugs:
  Lprot = L - (NRR * 0.5)
    Other Earplugs:
  Lprot = L - (NRR * 0.3)
    Earmuffs:
  Lprot = L - (NRR * 0.75)
Where:
L is the measured level or TWA
NRR is the Noise Reduction Rating provided by the hearing protector manufacturer
Lprot is the estimated sound level at the ear when wearing the hearing protection

for more info:  please see the ff: https://www.noisemeters.com/apps/occ/help/protector-nrr.asp

Monday, 26 October 2015

phpmyadmin security for xampp 1.8.1

how to secure your phpmyadmin
Steps
1. please see the link:  http://localhost/security/

make sure that your xampp are active

2. select your language

3. click the link on your page..

To fix the problems for mysql, phpmyadmin and the xampp directory simply use
=> http://localhost/security/xamppsecurity.php <=   [allowed only for localhost]

just follow the instructions and your good to go!!
 

Sunday, 25 October 2015

How To Setup Virtual Hosts Using XAMPP

steps

1. C:/xampp/apache/conf/extra

edit : httpd-vhosts.conf

add: 
<VirtualHost *:80>
DocumentRoot "C:/xampp/htdocs/testsite"
ServerName dev.test.com
ServerAlias dev.test.com
<Directory "c:/xampp/htdocs/testsite">
AllowOverride All
Require all Granted
</Directory>
</VirtualHost>
 
2.locate C:/Windows/System32/drivers/etc/
 
edit host file.
 
add the ff.
 
127.0.0.1             localhost
127.0.0.1             dev.test.com
 
restart xampp and now you have your vhost!!! 
  
 

Wednesday, 21 October 2015

How to add git(bitbucket) to existing source code folder?

Create a project with some code:
$ mkdir project_name
$ cd project_name
$ echo "sample txt" > name of file to update
 
Inside the project's folder, do an initial commit:
$ git init
$ git add file_name or --all if all files
$ git commit -m "Initial commit"
 
and remote and push up

$ git remote add file_name  user@host:repo
$ git push filename or --all 
 
 

Saturday, 3 October 2015