Search This Blog

2016-04-26

Linux, bash and cygwin tips and tricks


LINUX , UNIX , BASH AND CYGWIN TIPS AND TRICKS

This document contains linux unix bash cygwin related code snippets

1. FILE AND DIRS MANAGEMENT

This section contains tips and tricks on files and dirs management.

1.1. how-to create a symlink

how-to create a symlink
# START === create symlink
export link_path=/vagrant
export target_path=/mnt/hgfs/vagrant
mkdir -p `dirname $link_path`
unlink $link_path
ln -s "$target_path" "$link_path"
ls -la $link_path;
# STOP === create symlink

1.2. how-to search and replace line feeds in a selection in excel

1. Select the cells.
2. Ctrl + H to present the find and replace dialog
3. For search: press the Alt num and from the Num keyboard type : 013 or 011
4. For replace: type the char to replace with
5. Replace all the occurrencies by : Alt + A

1.3. how-to search and replace strings in file contents recursively

In order to search and replace strings in the file and dir contents perform the copy paste the following code in your bash shell terminal.
# START -- how-to search and replace recursively 
export dir=/var/aktia/3rdparty/docs/docx; 
export to_search="emric"
export to_replace="t24"

#-- search and replace in file contents
find "$dir/" -type f -exec perl -pi -e "s#$to_search#$to_replace#g" {} \;
find "$dir/" -type f -name '*.bak' | xargs rm -f
# STOP  -- how-to rename files recursively

1.4. how-to search and replace strings in file and dirnames recursively

In order to search and replace strings in the file and dir paths perform the copy paste the following code in your bash shell terminal.
# START -- how-to search and replace recursively 
export dir=/var/aktia/3rdparty/docs/docx; 
export to_search="emric"
export to_replace="t24"
#-- search and replace in file names
find "$dir/" -type d |\
perl -nle '$o=$_;s#'"$to_search"'#'"$to_replace"'#g;$n=$_;`mkdir -p $n` ;'
find "$dir/" -type f |\
perl -nle '$o=$_;s#'"$to_search"'#'"$to_replace"'#g;$n=$_;rename($o,$n) unless -e $n ;'

2. PACKING AND UNPACKING

Bunch of commands for packing and unpacking on Linux

2.1. how-to unpack a *.tar.gz package

Run the followint commands in the bash shell:
export dir=<>
cd $dir
# upack !!!
gzip -dc *.tar.gz | tar xvf -

2.2. how-to unpack a tar package

how-to unpack a tar package
#how-to unpack tar file
tar xvf $file

2.3. how-to check which ports are listening

how-to check which ports are listening + others netstta
# which processes are listening on my system
netstat --tcp --listening --programs
netstat --tcp
netstat --route

2.4. how-to implement public private key authentication

Start on the client , check the comments when to move on the server.
# START === how-to implement public private key ( pkk ) authentication 
# create pub priv keys on server
# START copy 
ssh-keygen -t rsa
# copy the rsa pub key to the ssh server
scp ~/.ssh/id_rsa.pub $ssh_user@$ssh_server:/home/$ssh_user/


# STOP copy  
# Hit enter twice 
# START copy 
cat id_rsa.pub >> ~/.ssh/authorized_keys
cat ~/.ssh/authorized_keys
chmod -v 0700 ~/.ssh
chmod -v 0600 ~/.ssh/authorized_keys
chmod -v 0600 ~/.ssh/id_rsa
chmod -v 0644 ~/.ssh/id_rsa.pub
find ~/.ssh -exec stat -c "%U:%G %a %n" {} \;
rm -fv ~/id_rsa.pub
# STOP COPY

# START copy 
ssh-keygen -t dsa
# STOP copy  
# Hit enter twice 
# START copy 
cat id_dsa.pub >> ~/.ssh/authorized_keys
cat ~/.ssh/authorized_keys
chmod -v 0700 ~/.ssh
chmod -v 0600 ~/.ssh/authorized_keys
chmod -v 0600 ~/.ssh/id_dsa
chmod -v 0644 ~/.ssh/id_dsa.pub
find ~/.ssh -exec stat -c "%U:%G %a %n" {} \;
rm -fv ~/id_dsa.pub
# STOP COPY
# STOP === how-to implement public private key authentication

2016-04-21

how do you recognize the professional integrator

- You have a lot of Systems in your Organization
- You feel that you need a Person who has a good overview of the whole, but could also drill down to the nuts and bolts of any of the Systems if needed
- You need a Person who can draw in a comprehensive and easy to understand manner those Systems and their interactions
- You need a Person who can design and connect those Systems


So how do you find this Person ?
When new Systems are introduced this Person will be the first to be able to connect and configure those by himself and show the configurations to the others, he will deliberately regardless of his position draw a schema of what's new ... He will surprise you with all the new capabilities which could be added all the time ...

And at the end you will lose this guy to the competition by promoting others ...

tips for doing quick ui prototyping


The example bellow shows the following tips:

- use minimal amount of dependencies
- display in the ui what is the purpose of this demo code
- display in the ui what is the behavior 
- display in the ui previous and next code 
- display in the ui explanations about the key points in the code ...  


 
<html>
<head> <title>draggable-2 demo</title>
 
    <link rel="stylesheet" type="text/css" href="../../lib/jQueryUI-1.11.4/jquery-ui.min.css"/>
    <link rel="stylesheet" type="text/css" href="../../lib/jquery-layout/layout-default.css"/>
    <link rel="stylesheet" type="text/css" href="../../css/screen/themes/default/site/site.css" />
    <link rel="stylesheet" type="text/css" href="../../css/nice-table.css"/>
    <link rel="stylesheet" type="text/css" href="../../css/screen/themes/default/tech_doc.css" />
 
    <script type="text/javascript" src="../../lib/jQuery-2.1.4/jquery-2.1.4.min.js"></script>
    <script type="text/javascript" src="../../lib/jQueryUI-1.11.4/jquery-ui.min.js"></script>
 
<style>
 
  #draggable-2 { width: 100px; height: 100px; padding: 0.5em; float: left; margin: 10px 10px 10px 0; }
  #droppable { width: 150px; height: 150px; padding: 0.5em; float: left; margin: 10px; }
</style>
 
  <script>
  $(function() {
    $( "#draggable-2" ).draggable();
    $( "#droppable" ).droppable({
      drop: function( event, ui ) {
          var id = ui.draggable.attr("id");
        $( this )
          .addClass( "ui-state-highlight" )
          .find( "p" )
          .html( "Dropped the draggable elemement with following id: " + id );
      }
    });
  });
  </script>
 
 
</head>
<body>
<p></p>
<h3 style="margin-top: 20px"> draggable-2 demo </h3>
 
<div id="con_draggable" style="clear:both">
<ol>
    <li>
    This demo uses <a href="https://jqueryui.com/droppable"> the droppabl jquery ui page </a> as a source. 
    </li><li>
    The purpose is to drag  the draggable into a dropable element and trigger the drop event
    </li><li>
    Also the following <a href="http://stackoverflow.com/a/10665924/65706"> stackoverflow answer </a>
    </li><li>
    The next step will be to integrate a ajax calling function on the drop event doing post to the server    
    </li><li>
    Go to the <a href="http://localhost:3000/protos/draggable/draggable-3.html"> next proto page </a>
    </li>
 
<div id="draggable-2" class="ui-widget-content">
  <p>Drag me to my target</p>
</div>
 
<div id="droppable" class="ui-widget-header">
  <p>Drop here the draggable </p>
</div>
 
</div><!-- eof con_draggable -->
 
 
 
 
</body>
</html>

2016-04-19

a good database modelling link

http://www.databaseanswers.org/data_models/index.htm

2016-04-10

excel shortcuts ( revised )


This document contains collection with the most usefull Excel shortcuts in the English language.
sorts ascending the actively selected column of the data table
sorts ascending the actively selected column of the data table
switches forth and back the Excel sheets
shows / hides the ribbon in Excel
opens the activates cell in excel for editing
goes to the end of the series - very good at accessing large Excel tables
Displays the shortcuts on the Ribbon
Intend left
Select the entire current table column
Select the entire current row
Rename a table
change the width of a column
works only if the table has been named ( menu - design , on the top left in the Ribbon , type the name of the table )
Select the area to convert the text to number and press Alt + Menu + C
Select the area to ignore the warning that numbers are stored as text and press the Alt + MenuKey + I

Labels

perl (41) Cheat Sheet (25) how-to (24) sql server 2008 (13) windows (13) oracle (12) sql (12) Unix (11) linux (11) cmd windows batch (10) mssql (10) cmd (9) script (9) textpad (9) netezza (8) sql server 2005 (8) cygwin (7) meta data mssql (7) metadata (7) code generation (6) Informatica (5) cheatsheet (5) energy (5) tsql (5) utilities (5) bash (4) excel (4) future (4) generic (4) html (4) perl modules (4) programs (4) settings (4) sh (4) shortcuts (4) поуки (4) принципи (4) Focus Fusion (3) Solaris (3) cool programs (3) development (3) economy (3) example (3) freeware (3) fusion (3) git cheat sheet (3) morphus (3) mssql 2005 (3) nuclear (3) nz (3) parse (3) python (3) sftp (3) sofware development (3) source (3) sqlplus (3) table (3) vim (3) .Net (2) C# (2) China (2) GUI (2) Google (2) GoogleCL (2) Solaris Unix (2) ascii (2) awk (2) batch (2) cas (2) chrome extensions (2) code2html (2) columns (2) configuration (2) conversion (2) duplicates (2) excel shortcuts (2) export (2) file (2) free programs (2) informatica sql repository (2) logging (2) mssql 2008 (2) mysql (2) next big future (2) nsis (2) nz netezza cheat sheet (2) nzsql (2) ora (2) prediction (2) publish (2) release management (2) report (2) security (2) single-click (2) sqlserver 2005 (2) sqlserver 2008 (2) src (2) ssh (2) template (2) tools (2) vba (2) video (2) xlt (2) xml (2) youtube videos (2) *nix (1) .vimrc (1) .virmrc vim settings configs (1) BSD license (1) Bulgaria (1) Dallas (1) Database role (1) Dense plasma focus (1) Deployment (1) ERP (1) ExcelToHtml (1) GD (1) GDP (1) HP-UX (1) Hosting (1) INC (1) IT general (1) ITIL management bullshit-management (1) IZarc (1) Java Web Start (1) JavaScript anchor html jquery (1) Khan Academy (1) LINUX UNIX BASH AND CYGWIN TIPS AND TRICKS (1) Linux Unix rpm cpio build install configure (1) Linux git source build .configure make (1) ListBox (1) MIT HYDROGEN VIRUS (1) OO (1) Obama (1) PowerShell (1) Run-time (1) SDL (1) SIWA (1) SOX (1) Scala (1) Services (1) Stacks (1) SubSonic (1) TED (1) abstractions (1) ansible hosts linux bash (1) ansible linux deployment how-to (1) ansible yum pip python (1) apache (1) apache 2.2 (1) application life cycle (1) architecture (1) archive (1) arguments (1) avatar (1) backup (1) bash Linux open-ssh ssh ssh_server ssh_client public-private key authentication (1) bash perl search and replace (1) bash stub (1) bin (1) biofuels (1) biology (1) books (1) browser (1) bubblesort (1) bugs (1) build (1) byte (1) cas_sql_dev (1) chennai (1) chrome (1) class (1) claut (1) cmdow (1) code generation sqlserver (1) command (1) command line (1) conf (1) confluence (1) console (1) convert (1) cool programs windows free freeware (1) copy-paste (1) csv (1) ctags (1) current local time (1) cygwin X11 port-forwarding mintty xclock Linux Unix X (1) cygwin bash how-to tips_n_tricks (1) cygwin conf how-to (1) data (1) data types (1) db2 cheat sheet (1) db2 starter ibm bash Linux (1) debt (1) diagram (1) dictionaries (1) digital (1) disk (1) disk space (1) documentation (1) dos (1) dubai (1) e-cars (1) electric cars (1) electricity (1) emulate (1) errors (1) exponents (1) export workflow (1) extract (1) fast export (1) fexp (1) file extension (1) file permissions (1) findtag (1) firewall (1) for loop (1) freaky (1) functions (1) fusion research (1) german (1) git gitlab issues handling system (1) google cli (1) google code (1) google command line interface (1) gpg (1) ha (1) head (1) helsinki (1) history (1) hop or flop (1) host-independant (1) how-to Windows cmd time date datetime (1) ibm db2 cognos installation example db deployment provisioning (1) ideas (1) image (1) informatica oracle sql (1) informatica repo sql workflows sessions file source dir (1) informatica source files etl (1) install (1) it management best practices (1) java (1) jump to (1) keyboard shortcuts (1) ksh (1) level (1) linkedin (1) linux bash ansible hosts (1) linux bash commands (1) linux bash how-to shell expansion (1) linux bash shell grep xargs (1) linux bash tips and t ricks (1) linux bash unix cygwin cheatsheet (1) linux bash user accounts password (1) linux bash xargs space (1) linux cheat sheet (1) linux cheat-sheet (1) linux cheatsheet cheat-sheet revised how-to (1) linux how-to non-root vim (1) linux ssh hosts parallel subshell bash oneliner (1) london (1) make (1) me (1) metacolumn (1) metadata functions (1) metaphonre (1) method (1) model (1) movie (1) multithreaded (1) mysql cheat sheet (1) mysql how-to table datatypes (1) n900 (1) nano (1) neteza (1) netezza bash linux nps (1) netezza nps (1) netezza nps nzsql (1) netezza nz Linux bash (1) netezza nz bash linux (1) netezza nz nzsql sql (1) netezza nzsql database db sizes (1) non-password (1) nord pol (1) nps backup nzsql schema (1) number formatting (1) nz db size (1) nz table count rows (1) nzsql date timestamp compare bigint to_date to_char now (1) on-lier (1) one-liners (1) one-to-many (1) oneliners (1) open (1) open source (1) openrowset (1) oracle PL/SQL (1) oracle Perl perl (1) oracle installation usability (1) oracle number formatting format-model ora-sql oracle (1) oracle templates create table (1) oracle trigger generic autoincrement (1) oracle vbox virtual box cheat sheet (1) oracle virtual box cheat sheet (1) outlook (1) parser (1) password (1) paths (1) perl @INC compile-time run-time (1) perl disk usage administration Linux Unix (1) perl modules configuration management (1) permissions (1) php (1) picasa (1) platform (1) postgreSQL how-to (1) powerShell cmd cygwin mintty.exe terminal (1) ppm (1) predictions (1) prices (1) principles (1) productivity (1) project (1) prompt (1) proxy account (1) public private key (1) publishing (1) putty (1) qt (1) read file (1) registry (1) relationship (1) repository (1) rm (1) scp (1) scripts (1) scsi (1) sed (1) sendEmail (1) sh stub (1) shortcuts Windows sql developer Oracle (1) sidebar (1) silicon (1) smtp (1) software procurement (1) sofware (1) sort (1) sql script (1) sql_dev (1) sqlcmd (1) sqlite (1) sqlite3 (1) sshd (1) sshd cygwin (1) stackoverflow (1) stored procedure (1) stub (1) stupidity (1) subroutines (1) svn (1) sysinternals (1) tail (1) tar (1) temp table (1) templates (1) teradata (1) terminal (1) test (1) testing (1) theory (1) thorium (1) time (1) tip (1) title (1) tmux efficiency bash (1) tool (1) ui code prototyping tips and tricks (1) umask Linux Unix bash file permissions chmod (1) url (1) urls (1) user (1) utility (1) utils (1) vb (1) vim perl regex bash search for string (1) vim recursively hacks (1) vim starter (1) vim-cheat-sheet vim cheat-sheet (1) vimeo (1) visual stuio (1) warsaw (1) wiki (1) wikipedia (1) window (1) windows 7 (1) windows 8 (1) windows programs (1) windows reinstall (1) windows utility batch perl space Windows::Clipboard (1) wisdoms (1) workflow (1) worth-reading (1) wrapper (1) xp_cmdshell (1) xslt (1) youtube (1)

Blog Archive

Translate with Google Translate

My Blog List

VideoBar

This content is not yet available over encrypted connections.