Shabat Closer

Monday, March 21, 2022

.htaccess for laravel + angular

 Angular files in folder : /public/dist

Laravel url location : /api/

.htaccess : in folder /public


<IfModule mod_rewrite.c>
    <IfModule mod_negotiation.c>
        Options -MultiViews -Indexes
    </IfModule>

    RewriteEngine On


    # Handle Authorization Header
    RewriteCond %{HTTP:Authorization} .
    RewriteRule .* - [E=HTTP_AUTHORIZATION:%{HTTP:Authorization}]

    # Redirect Trailing Slashes If Not A Folder...
    RewriteCond %{REQUEST_FILENAME} !-d
    RewriteCond %{REQUEST_URI} (.+)/$
    RewriteRule ^ %1 [L,R=301]
	

	
	# Send api/ Requests To Front Controller...	
	RewriteCond %{REQUEST_URI} api/.*
    RewriteRule ^api\/.* index.php [END]
  
  
	

	RewriteCond %{REQUEST_URI} !dist/
	RewriteRule (.*) /dist/$1 [L]

    RewriteCond %{REQUEST_FILENAME} !-d
    RewriteCond %{REQUEST_FILENAME} !-f
    RewriteRule ^ /dist/index.html [L]
  	
</IfModule>



Thursday, April 26, 2018

JS : recall function when variable not init

Java Script : recall function when some variable not init


 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
var init=false;
function someFunction(){
   if (!init){
      var t=this,f=arguments.callee,a=arguments;
      setTimeout(function(){f.apply(t,a);},100);
      return;
   } 
   console.log("init=",init);
}
someFunction();
init=true;


Sunday, May 29, 2016

TECH : Enable haproxy log

TECH : Enable haproxy log


  1. at the top of /etc/haproxy/haproxy.cfg
  2. global
        log         127.0.0.1 local2
    

  3. in file /etc/rsyslog.conf
  4. # Provides UDP syslog reception
    $ModLoad imudp
    $UDPServerRun 514
    $UDPServerAddress 127.0.0.1
    
  5. in file  /etc/rsyslog.d/haproxy.conf
  6. local2.*     /var/log/haproxy.log
    

  7. restart services
    service rsyslog restart
    service haproxy restart
    

Enjoy!

TECH : Block DDOS attack with Cloudflare and haproxy and fail2ban.

Survive DDOS attack with Cloudflare and haproxy and fail2ban.


This configuration tested in live attack of 72 servers with 10,000 requests per  minute


  1. Configure Cloudflare for maximum security
    1. https://support.cloudflare.com/hc/en-us/articles/200170196-I-am-under-DDoS-attack-what-do-I-do-
  2. Enable  haproxy log
    1. http://moshez.blogspot.co.il/2016/05/tech-enable-haproxy-log.html
  3. Enable custom log for haproxy by changes to /etc/haproxy/haproxy.cfg
  4. frontend  main
     bind *:80
     
     log   global
     capture request header X-Forwarded-For len 25
     log-format %hr[%r]
  5. Remove from default section the log global because we move it to frontend  main for more performance
  6. configure fail2ban 
    1. jail config - /etc/fail2ban/jail.conf

    2. [haproxy]
      enabled = true
      port    = http,https
      filter  = haproxy
      banaction = cloudflare
      maxretry = 2
      findtime  = 5
      logpath  = /var/log/haproxy.log
      bantime = 7200
      

    3. filter config /etc/fail2ban/filter.d/haproxy.conf
    4. this will catch all / requests.
      # Fail2Ban filter for haproxy
      # by MosheZ http://moshez.blogspot.com
      
      
      [INCLUDES]
      
      # Read common prefixes. If any customizations available -- read them from
      # common.local
      before = common.conf
      
      [Definition]
      
      _daemon = haproxy
      
      failregex = ^\s.*: {<HOST>}(.*GET / HTTP/1.1.*)\s*$
      
      ignoreregex = 
      
      [Init]
      
      # "maxlines" is number of log lines to buffer for multi-line regex searches
      maxlines = 10
      
    5. action config /etc/fail2ban/action.d/cloudflare.conf
    6. [Definition]
      
      
      actionban = curl -s -o /dev/null https://www.cloudflare.com/api_json.html -d 'a=ban' -d 'tkn=<cftoken>' -d 'email=<cfuser>' -d 'key=<ip>'
      
      
      #actionunban = curl -s -o /dev/null https://www.cloudflare.com/api_json.html -d 'a=nul' -d 'tkn=<cftoken>' -d 'email=<cfuser>' -d 'key=<ip>'
      
      [Init]
      
      # If you like to use this action with mailing whois lines, you could use the composite action
      # action_cf_mwl predefined in jail.conf, just define in your jail:
      #
      # action = %(action_cf_mwl)s
      # # Your CF account e-mail
      # cfemail  = 
      # # Your CF API Key
      # cfapikey = 
      
      cftoken = dfgb0390bfe31ed1e931c1b6ae (REPLACE THIS)
      
      cfuser = example@example.com (REPLACE THIS)
    7. Restart services
      service haproxy restart
      service fail2ban restart

  7. Enjoy!

Sunday, March 20, 2016

PHP : save session Handler to redis by class

PHP : save session Handler to redis by class

use this class to save session to redis by class




1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
<?php
/**
 * Redis & PHP Session Handler
 */

 define("SESSION_REDIS_HOST","127.0.0.1") // Redis server address
 
if(! interface_exists('SessionHandlerInterface'))
{
  interface SessionHandlerInterface {
    public function close();
    public function destroy($session_id);
    public function gc($maxlifetime);
    public function open($save_path, $name);
    public function read($session_id);
    public function write($session_id, $session_data);
  }
}

class Redis_SessionHandler implements SessionHandlerInterface{

  /**
   * @var seleced Redis db
   */
  public $redis_db = 1;
   
  /**
   * @var int
   */
  public $lifeTime;

  /**
   * @var Redis
   */
  public $redis=null;

  /**
   * @var string
   */
  public $initSessionData;

  /**
   * interval for session expiration update in the DB
   * @var int
   */
  protected $_refreshTime = 1800; //30 minutes

  private $sessionPrefix="";
  
  

  /**
   * constructor of the handler - initialises Redis object
   *
   * @return bool
   */
  public function __construct()
  { 
 $this->sessionPrefix="session.";
 
    // this ensures to write down and close the session when destroying the
    // handler object
    ini_set('session.save_handler', 'user');
    register_shutdown_function("session_write_close");

    $this->lifeTime = intval(ini_get("session.gc_maxlifetime"));
    $this->initSessionData = null;

    session_set_save_handler(
        array($this, "open"),
        array($this, "close"),
        array($this, "read"),
        array($this, "write"),
        array($this, "destroy"),
        array($this, "gc"));

    return true;
  } // __construct()






  /**
   * Init Redis connection.
   */
  protected function initRedis()
  {
 $this->redis = new Redis();
 $this->redis->connect(SESSION_REDIS_HOST, 6379);
 $this->redis->select($this->redis_db);
    return true;
  } // initRedis()



  /**
   * opening of the session - mandatory arguments won't be needed
   * we'll get the session id and load session data, it the session exists
   *
   * @param string $savePath
   * @param string $sessionName
   * @return bool
   */
  public function open($savePath, $sessionName)
  {
    $this->initRedis();

    $session_id = session_id();
    if ($session_id !== "") {
      $this->initSessionData = $this->read($session_id);
    }

    return true;
  } // open()



  /**
   * closing the session
   *
   * @return bool
   */
  public function close()
  {
    $this->lifeTime = null;
    $this->initSessionData = null;

    unset($this->redis);
    return true;
  } // close()



  /**
   * reading of the session data
   *
   * @param string $session_id
   * @return string
   */
  public function read($session_id)
  {
    $now = time();
    $data = $this->redis->get($this->sessionPrefix.$session_id);
    $this->redis->expire($this->sessionPrefix.$session_id, $this->lifeTime);
    return $data ? $data : '';
  } // read()



  /**
   * cache write - this is called when the script is about to finish,
   * or when session_write_close() is called
   * data are written only when something has changed
   *
   * @param string $session_id
   * @param string $data
   * @return bool
   */
  public function write($session_id, $data){
    // we store time of the db record expiration in the Redis
    $result = $this->redis->set($this->sessionPrefix.$session_id, $data, $this->lifeTime);
 return $result;
  } // write()



  /**
   * destroy of the session
   *
   * @param string $session_id
   * @return bool
   */
  public function destroy($session_id){
    $this->redis->delete($this->sessionPrefix.$session_id);
    return true;
  } // destroy()



  /**
   * called by the garbage collector
   *
   * @param int $maxlifetime
   * @return bool
   */
  public function gc($maxlifetime){
    return true;
  } // gc()
}

// Initialize custom session management.
new Redis_SessionHandler();

Useage :



1
2
3
<?php
// Initialize custom session management.
new Redis_SessionHandler();


Enjoy!

PHP : save session Handler to memcached by class

PHP : save session Handler to memcached by class


use this class to save session to memcache by class


<?php
/**
 * Memcache PHP Session Handler
*/
define("SESSION_MEMCACHED_HOST","127.0.0.1"); //Memcache server address

if(! interface_exists('SessionHandlerInterface'))
{
  interface SessionHandlerInterface {
    public function close();
    public function destroy($session_id);
    public function gc($maxlifetime);
    public function open($save_path, $name);
    public function read($session_id);
    public function write($session_id, $session_data);
  }
}

class Memcached_SessionHandler implements SessionHandlerInterface{
   
  /**
   * @var int
   */
  public $lifeTime;

  /**
   * @var Memcached
   */
  public $memcached;

  /**
   * @var MySQLi
   */
  public $mysqli;

  /**
   * @var string
   */
  public $initSessionData;

  /**
   * interval for session expiration update in the DB
   * @var int
   */
  protected $_refreshTime = 1800; //30 minutes

  private $sessionPrefix="";
  
  

  /**
   * constructor of the handler - initialises Memcached object
   *
   * @return bool
   */
  public function __construct()
  {
 $this->sessionPrefix=".session.";
 
    // this ensures to write down and close the session when destroying the
    // handler object
    ini_set('session.save_handler', 'user');
    register_shutdown_function("session_write_close");

    $this->lifeTime = intval(ini_get("session.gc_maxlifetime"));
    $this->initSessionData = null;

    session_set_save_handler(
        array($this, "open"),
        array($this, "close"),
        array($this, "read"),
        array($this, "write"),
        array($this, "destroy"),
        array($this, "gc"));

    return true;
  } // __construct()






  /**
   * Init memcached connection.
   */
  protected function initMemcached()
  {
  /*
    if($this->memcached instanceOf Memcached)
    {
      return false;
    }
 */
    $this->memcached = new Memcache;
 $this->memcached->addServer(SESSION_MEMCACHED_HOST, 11211);
    return true;
  } // initMemcached()



  /**
   * opening of the session - mandatory arguments won't be needed
   * we'll get the session id and load session data, it the session exists
   *
   * @param string $savePath
   * @param string $sessionName
   * @return bool
   */
  public function open($savePath, $sessionName)
  {
    $this->initMemcached();

    $session_id = session_id();
    if ($session_id !== "") {
      $this->initSessionData = $this->read($session_id);
    }

    return true;
  } // open()



  /**
   * closing the session
   *
   * @return bool
   */
  public function close()
  {
    $this->lifeTime = null;
    $this->initSessionData = null;

    unset($this->memcached);
    return true;
  } // close()



  /**
   * reading of the session data
   * if the data couldn't be found in the Memcache, we try to load it from the
   * DB we have to update the time of data expiration in the db using
   * _updateDbExpiration() the life time in Memcache is updated automatically
   * by write operation
   *
   * @param string $session_id
   * @return string
   */
  public function read($session_id)
  {
    $now = time();
    $data = $this->memcached->get($this->sessionPrefix.$session_id);
    $this->memcached->set($this->sessionPrefix.$session_id, $data,MEMCACHE_COMPRESSED, $this->lifeTime);
    return $data ? $data : '';
  } // read()



  /**
   * cache write - this is called when the script is about to finish,
   * or when session_write_close() is called
   * data are written only when something has changed
   *
   * @param string $session_id
   * @param string $data
   * @return bool
   */
  public function write($session_id, $data){
    // we store time of the db record expiration in the Memcache
    $result = $this->memcached->set($this->sessionPrefix.$session_id, $data, MEMCACHE_COMPRESSED,$this->lifeTime);
 return $result;
  } // write()



  /**
   * destroy of the session
   *
   * @param string $session_id
   * @return bool
   */
  public function destroy($session_id){
    $this->memcached->delete($this->sessionPrefix.$session_id);
    return true;
  } // destroy()



  /**
   * called by the garbage collector
   *
   * @param int $maxlifetime
   * @return bool
   */
  public function gc($maxlifetime){
    return true;
  } // gc()
}


Useage :


<?php
// Initialize custom session management.
new Memcached_SessionHandler();


Enjoy!

Thursday, January 14, 2016

IT Linux : Csync2 - error "Received record packet of unknown type 73" [solve]

IT Linux : Csync2 : "Received record packet of unknown type 73"


this error apper when you run command "csync2 -xv"

Received record packet of unknown type 73
While syncing file /var/www/html/index.php

error details: 
direcotry structrue mismatch between the servers.

Slove:
  1. make  in server 2 the missing directories
    1. mkdir -p /var/www/html
  2. run the command "csync2 -xv" again.
enjoy!

Sunday, July 19, 2015

JS SCRIPT : multiple release domains lock on 1&1 hosting.

JS SCRIPT : Unlock a Domains for Transfer


1.login to your account on 1&1.
2.goto domains page.
3.open console mode (F12)
4.pate this code and click enter.

function run(index){
 $(".checkbox-button").eq(index).click();
 setTimeout(TransferDomain,1000);
}

function TransferDomain(){
 $("#auth-info-value").html("");
 $("[for='menu_transfers_1']").click(); 
 printCode();
}
function printCode(){
 if ($("#auth-info-value").text()==""){
  setTimeout(printCode,1000);
  return;
 }
 console.log($(".form-key").parent().find("span:first").text());
 releaseDomain();
}

function DialogOk(){
 if ($(':contains("Edit Domain Transfer Lock"):last').length==1){
  $(':contains("Edit Domain Transfer Lock"):last').parent().parent().find(".rain_modal_button:last").click();
 }
 setTimeout(RunNext,5000);
}

function releaseDomain(){
 if ($("#transferlock-value").text()=="Enabled"){
  $("#transferlock-value").parent().find("div:first").find("div:first").find("div:first").find("span:first").click();
 }else{
  setTimeout(RunNext,1);
  return;
 }
 setTimeout(DialogOk,5000);
}
var run_index=0;
function RunNext(){
 run(run_index);
 run_index++;
}
RunNext();


Thursday, May 22, 2014

TECH Windows Server 2008 - Power Shell: Auto delete old Shadow copies - script

TECH Windows Server 2K8 - Power Shell: Auto delete old Shadow copies - script

this script keep only the follwing  shadow copies
last 7 days : Daly at 12 A.M
after 7 days : only the days  Sunday and Wednesday for each week. (at 12 A.M)



$vss=vssadmin List Shadows
$vssContents=($vss,"" -split("Contents of shadow copy"))
foreach ($vssContent in $vssContents){
  if ($vssContent.length -gt 620 ){
  $ContentId=($vssContent,"" -split("Shadow Copy ID: {"))[1]
  $ContentId=($ContentId,"" -split("}"))[0]
  
  $CreationTime=($vssContent,"" -split("time: "))[1]
  $CreationTime=($CreationTime,"" -split("  "))[0]

  $CreationTime=[datetime]::Parse($CreationTime)
  $Diff=(New-TimeSpan $($CreationTime) $(Get-Date)).Days

  if  ($Diff-ge 1)
   if (($CreationTime.Hour -ne 0))
    cmd /c "vssadmin Delete Shadows /shadow={$ContentId} /Quiet"

  if  ($Diff-gt 5) 
   if (($CreationTime.DayOfWeek -ne "Sunday") -and ($CreationTime.DayOfWeek -ne "Wednesday"))
    cmd /c "vssadmin Delete Shadows /shadow={$ContentId} /Quiet"
 }
}
exit

Monday, December 30, 2013

TECH - Exchange 2010 : No existing ‘PublicFolder’ matches the following Identity. ‘\’.

TECH - Exchange 2010 :  No existing ‘PublicFolder’ matches the following Identity. ‘\’.

Error:
No existing ‘PublicFolder’ matches the following Identity. ‘\’.  Make sure that you specified the correct ‘PublicFolder’ Identity and that you have the necessary permissions to view ‘PublicFolder’.  It was running the command ‘get-publicfolder -getchildren -identity ‘\’ -server ExchangeServer

Solution:
  1. I try to fix the homeMDB  homeMTA  in ADSI Edit but it's not fix my problem
  2. I remove my admin mailbox and create it again. <- that's fix my problem.

Sunday, December 29, 2013

Mysql - Function : Count Occurence of Character in a String / Word

Mysql : Count Occurrence of Character in a String / Word  Function

CREATE FUNCTION `getCount`(`myStr` VARCHAR(4096), `myword` VARCHAR(100)) RETURNS int(11)
    READS SQL DATA
    DETERMINISTIC
RETURN 
    ROUND (   
        (
            LENGTH(myStr)
            - LENGTH( REPLACE ( myStr, myword, "") ) 
        ) / LENGTH(myword)        
    )




Usage :



Select  getCount('Moshe Test My Code','M')
#Returns : 2

Thursday, August 1, 2013

C# : Disable Alert box javascript in c# webbrower control

if you want to disable all alerts in a website in your webbrower.

the following code disable :

  • Alert window.
  • Print window
  • confirm window.


/************Disable alert/print function()**********************/
HtmlElement head = WebBrowser1.Document.GetElementsByTagName("head")[0];
HtmlElement scriptEl = WebBrowser1.Document.CreateElement("script");
IHTMLScriptElement element = (IHTMLScriptElement)scriptEl.DomElement;
string alertBlocker = @"window.alert = function () { }; 
                        window.print=function () { };
                        window.confirm=function () { };
                    ";
element.text = alertBlocker;
head.AppendChild(scriptEl);
WebBrowser1.ScriptErrorsSuppressed = true;
/****************************************************************/


Enjoy!

Tuesday, July 30, 2013

TECH - MySQL 5.5 / 5.6 : disable MySQL slave replication

if you want to disable the slave replication.

run the query :
  • RESET SLAVE ALL;
to verify run the query
  • SHOW SLAVE STATUS
enjoy!

Tuesday, April 23, 2013

TECH: auto load many sitemaps to google webmaster

upload multiple sitemaps to google, by automation javascript script.

auto load many sitemaps to google webmaster

  1. Login to google webmaster
  2. go to Sitemap TAB.
  3. Press F12 on keyboard.
  4. go to Console TAB.
  5. click on Multi Line Mode
  6. paste the following 

/****************************************************
* Variables :                                       *
* the following variables will upload               *
* the sitemap files                                 *
*   from : xmlmap.php?index=0                       *
*   to   : xmlmap.php?index=10                      *
*                                                   *
*  Upload FILE: baseSiteMapName + (jump * index)    *
*****************************************************/
var jump = 1;                               //Jump index count(Only if you need it...).
var index = 0;                              //Start index position.
var end = 10;                               //End index position.
var baseSiteMapName = "xmlmap.php?index=";  //sitemap file.
var UploadDelay = 1000;                     //Delay between uploads.
/**************
* the code   *
**************/
var head = document.getElementsByTagName('head')[0];
var script = document.createElement('script');
script.type = 'text/javascript';
script.src = '//ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js';
head.appendChild(script);
function upload_smap() {
    document.getElementById("gwt-uid-58").click();
    document.getElementById("gwt-uid-77").click();
    $("input[type='text']").val(baseSiteMapName + (jump * index));
    document.getElementById("gwt-uid-67").click();
    console.log(index);
    index++;
    if (index > end)
        clearInterval(uploadInt);
}
var uploadInt = setInterval(upload_smap, UploadDelay);

  1. change the variables to your site configuration.
  2. Click "Run Script"

Enjoy!

Wednesday, April 17, 2013

PHP: GODADDY Class - Change Godaddy DNS record Script

PHP Godaddy Class  - script to add/delete record from godaddy dns.

<?php
/**
 * The main class for sending and parsing server requests to the
 * GoDaddy?® TotalDNS management system. Eventually this class
 * could split into multiple classes representing the various
 * components such as the Service, Account, Zone, and Record(s).
 */
class GoDaddyDNS{
 /**
  * Class variables
  */
 private $_config;
 private $_curlHandle;
 private $_lastResponse;
 
 /**
  * Initialize the configuration array with configuration defaults.
  */
 public function __construct($config = array()) {
  // Apply default configuration settings
  $this->_config = array_merge(array(
   'username'       =>'',
   'password'       =>'',
   'domain'       =>'',
   'cookie_file'                 => tempnam(sys_get_temp_dir(), 'Curl'),
   'auto_remove_cookie_file'     => true,
   'auto_logout'                 => true,
   'godaddy_dns_zonefile_url'    => 'https://dns.godaddy.com/ZoneFile.aspx?zoneType=0&sa=&zone=',
   'godaddy_dns_zonefile_ws_url' => 'https://dns.godaddy.com/ZoneFile_WS.asmx'
   ), $config);
  
  $this->_authenticate($this->_config["username"],$this->_config["password"],$this->_config["domain"]);
 }

 /**
  * Destroy the curl handle and unlink the cookies file.
  */
 public function __destruct() {
  if ($this->_config['auto_logout']) {
   $this->logout();
  }
  if ($this->_curlHandle) {
   curl_close($this->_curlHandle);
  }
  if ($this->_config['auto_remove_cookie_file'] && file_exists($this->_config['cookie_file'])) {
   unlink($this->_config['cookie_file']);
  }
 }


 /**
  * Login to the user's account, returning an error if the credentials are
  * invalid or the login fails.
  */
 private function _authenticate($username, $password,$domain) {
  $this->_lastResponse = $this->_fetchURL($this->_config['godaddy_dns_zonefile_url'].$domain);
  if (!$this->isLoggedIn($username)) {
   // User is not already logged in, build and submit a login request
   $postUrl = curl_getinfo($this->_curlHandle, CURLINFO_EFFECTIVE_URL);

   $post = array(
    'Login$userEntryPanel2$LoginImageButton.x' => 0,
    'Login$userEntryPanel2$LoginImageButton.y' => 0,
    'Login$userEntryPanel2$UsernameTextBox' => $username,
    'Login$userEntryPanel2$PasswordTextBox' => $password,
    '__EVENTARGUMENT' => $this->_getField('__EVENTARGUMENT'),
    '__EVENTTARGET' => $this->_getField('__EVENTTARGET'),
    '__VIEWSTATE' => $this->_getField('__VIEWSTATE'),
    );
   $this->_lastResponse = $this->_fetchURL($postUrl, $post);

   if (!$this->isLoggedIn($username, $this->_lastResponse)) {
    // Invalid username/password or unknown response received
    return false;
   }
  }
  return true;
 }

 /**
  * Check to see if the expected user is logged in.
  */
 public function isLoggedIn($username) {
  if (preg_match('#Welcome:&nbsp;<span id="ctl00_lblUser" .*?\>(.*)</span>#', $this->_lastResponse, $match)) {
   if (strtolower($match[1]) == strtolower($username) || $match[2] == $username) {
    return true;
   } else {
    // An unexpected user was logged in
    $this->logout();
   }
  }
  return false;
 }

 /**
  * Log the user out.
  */
 public function logout() {
  if (preg_match('#<a [^>]+href="(.*?)"[^>]*>Log Out</a>#', $this->_lastResponse, $match)) {
   $this->_lastResponse = $this->_fetchURL($match[1]);
   if (preg_match('#<img src="([^"]+)" height="1" width="1" />#', $this->_lastResponse, $match)) {
    $this->_lastResponse = $this->_fetchURL($match[1]);
    return true;
   }
  }
  return false;
 }
 
 /**
 * Add new record
 */
 public function AddRecord($host,$type = 'A',$pointsTo,$ttl=3600){
  $domain=$this->_config["domain"];
  $next_record_id=$this->_nextRecordIndex();
  switch (strtoupper($type)) {
   case 'A':
    $post = array(
     'sInput' => '<PARAMS>
         <PARAM name="host" value="'.$host.'" />
         <PARAM name="pointsTo" value="'.$pointsTo.'" />
         <PARAM name="lstIndex" value="'.$next_record_id.'" />
         <PARAM name="ttl" value="'.$ttl.'" />
        </PARAMS>',
     );
    $calloutResponse = $this->_fetchURL($this->_config['godaddy_dns_zonefile_ws_url'] . '/AddNewARecord', http_build_query($post, '', '&'));
    if (strpos($calloutResponse, 'SUCCESS') === false) {
     return false;
    }
    
    // Commit the updates
    $post = array(
     'sInput' => '<PARAMS>
         <PARAM name="domainName" value="' . $domain . '" />
         <PARAM name="zoneType" value="0" />
         <PARAM name="aRecEditCount" value="1" />
         <PARAM name="aRecEdit0Index" value="'.$next_record_id.'" />
         <PARAM name="aRecDeleteCount" value="0" />
         <PARAM name="cnameRecEditCount" value="0" />
         <PARAM name="cnameRecDeleteCount" value="0" />
         <PARAM name="mxRecEditCount" value="0" />
         <PARAM name="mxRecDeleteCount" value="0" />
         <PARAM name="txtRecEditCount" value="0" />
         <PARAM name="txtRecDeleteCount" value="0" />
         <PARAM name="srvRecEditCount" value="0" />
         <PARAM name="srvRecDeleteCount" value="0" />
         <PARAM name="aaaaRecEditCount" value="0" />
         <PARAM name="aaaaRecDeleteCount" value="0" />
         <PARAM name="soaRecEditCount" value="0" />
         <PARAM name="soaRecDeleteCount" value="0" />
         <PARAM name="nsRecEditCount" value="0" />
         <PARAM name="nsRecDeleteCount" value="0" />
        </PARAMS>',
     );
    $calloutResponse = $this->_fetchURL($this->_config['godaddy_dns_zonefile_ws_url'] . '/SaveRecords', http_build_query($post, '', '&'));
    if (strpos($calloutResponse, 'SUCCESS') === false) {
     return false;
    }
    return true;
   
   
   default:
    // Other record types are currently unsupported
    throw new Exception('Unknown record type encountered: ' . $type);
  }
 }

 /**
 * Delete record
 */
 public function deleteRecord($record){
  $host=$record["host"];
  $domain=$this->_config["domain"];
  switch (strtoupper($record["type"])) {
   case 'A':
    $post = array(
     'sInput' => $record['index'].'|true',
     );
    $calloutResponse = $this->_fetchURL($this->_config['godaddy_dns_zonefile_ws_url'] . '/FlagARecForDeletion', http_build_query($post, '', '&'));
    if (strpos($calloutResponse, 'SUCCESS') === false) {
     return false;
    }
    
    // Commit the updates
    $post = array(
     'sInput' => '<PARAMS>
         <PARAM name="domainName" value="' . $domain . '" />
         <PARAM name="zoneType" value="0" />
         <PARAM name="aRecEditCount" value="0" />
         <PARAM name="aRecDeleteCount" value="1" />
         <PARAM name="aRecDelete0Index" value="' . $record['index'] . '" />
         <PARAM name="cnameRecEditCount" value="0" />
         <PARAM name="cnameRecDeleteCount" value="0" />
         <PARAM name="mxRecEditCount" value="0" />
         <PARAM name="mxRecDeleteCount" value="0" />
         <PARAM name="txtRecEditCount" value="0" />
         <PARAM name="txtRecDeleteCount" value="0" />
         <PARAM name="srvRecEditCount" value="0" />
         <PARAM name="srvRecDeleteCount" value="0" />
         <PARAM name="aaaaRecEditCount" value="0" />
         <PARAM name="aaaaRecDeleteCount" value="0" />
         <PARAM name="soaRecEditCount" value="0" />
         <PARAM name="soaRecDeleteCount" value="0" />
         <PARAM name="nsRecEditCount" value="0" />
         <PARAM name="nsRecDeleteCount" value="0" />
        </PARAMS>',
     );
    $calloutResponse = $this->_fetchURL($this->_config['godaddy_dns_zonefile_ws_url'] . '/SaveRecords', http_build_query($post, '', '&'));
    if (strpos($calloutResponse, 'SUCCESS') === false) {
     return false;
    }
    return true;
   case 'CNAME':
   case 'MX':
   case 'TXT':
   case 'SRV':
   case 'AAAA':
   case 'NS':
   default:
    // Other record types are currently unsupported
    throw new Exception('Unknown record type encountered: ' . $type);
  }
 }
 
 /**
  * Find and return the details about a host record, return false if nothing is found.
 *
 * Note: The only type of records currently supported are "A" records.
  */
 public function findRecords($host,$type = 'A') {
  $domain=strtolower($this->_config["domain"]);
  $currentZone = $this->_getField('ctl00$cphMain$hdnCurrentZone');
  if (strtolower($currentZone) != strtolower($domain)) {
   // Request zone details if not already loaded - 
   // could keep a separate cache of each zone's records in the future
   $this->_lastResponse = $this->_fetchUrl($this->_config['godaddy_dns_zonefile_url'] . $domain);
  }
  
  $records=array();
  $offset=0;
  while(preg_match("#Undo{$type}Edit\('tbl{$type}Records_([0-9]+)?', '({$host})', '([^']+)?', '([^']+)?', '([^']+)?', '([^']+)?', '([^']+)?'\);#is", $this->_lastResponse, $match,0,$offset)) {
   array_push($records,array_combine(array('match', 'index', 'host', 'data', 'ttl', 'host_td', 'points_to', 'rec_modified','type'), array_merge($match,array($type))));
   $offset=strpos($this->_lastResponse,$match[0],$offset)+strlen($match[0]);
  }
  return $records;
 }

 private function _nextRecordIndex($type = 'A'){
  return preg_match_all("#Undo{$type}Edit\('tbl{$type}Records_([0-9]+)?', '([^']+)', '([^']+)?', '([^']+)?', '([^']+)?', '([^']+)?', '([^']+)?'\);#is", $this->_lastResponse, $match,0,$offset);
 }
 /**
  * Connect to the remote server using CURL.
  */
 private function _fetchURL($url, $post = null, $referer = '', $agent = 'Mozilla/5.0 (compatible; PHP; cURL)', $language = 'en', $timeout = 30) {
  // Initialize CURL
  if (!$this->_curlHandle) {
   if (!function_exists('curl_init')) {
    die('CURL is not loaded or compiled into this version of PHP.');
   }
   if (!is_writable($this->_config['cookie_file'])) {
    die('Cookie jar file is not writable: ' . $this->_config['cookie_file']);
   }

   $this->_curlHandle = curl_init();

   curl_setopt_array($this->_curlHandle, array(
    CURLOPT_CONNECTTIMEOUT => $timeout,
    CURLOPT_TIMEOUT        => $timeout,
    CURLOPT_HEADER         => false,
    CURLOPT_RETURNTRANSFER => true,
    CURLOPT_FOLLOWLOCATION => true,
    CURLOPT_AUTOREFERER    => true,
    CURLOPT_SSL_VERIFYPEER => false,
    CURLOPT_SSL_VERIFYHOST => false,
    CURLOPT_COOKIEJAR      => $this->_config['cookie_file'],
    CURLOPT_COOKIEFILE     => $this->_config['cookie_file'],
    ));
  }

  // Set the options
  curl_setopt($this->_curlHandle, CURLOPT_URL, $url);
  curl_setopt($this->_curlHandle, CURLOPT_REFERER, $referer);
  curl_setopt($this->_curlHandle, CURLOPT_USERAGENT, $agent);
  $extraHeaders = array(
   'Accept-Language: ' . $language,
   );
  curl_setopt($this->_curlHandle, CURLOPT_HTTPHEADER, $extraHeaders);
  if ($post) {
   curl_setopt($this->_curlHandle, CURLOPT_POST, true);
   curl_setopt($this->_curlHandle, CURLOPT_POSTFIELDS, $post);
  } else {
   curl_setopt($this->_curlHandle, CURLOPT_HTTPGET, true);
  }

  // Execute the request, returning the results
  return curl_exec($this->_curlHandle);
 }

 /**
  * Parse and return a named field's value from the last response.
  */
 private function _getField($name) {
  if (preg_match_all('#<input[^>]+>#is', $this->_lastResponse, $matches, PREG_SET_ORDER)) {
   foreach ($matches as $match) {
    $fieldHtml = $match[0];
    if ($this->_getFieldAttribute('name', $fieldHtml) == $name) {
     return $this->_getFieldAttribute('value', $fieldHtml);
    }
   }
  }
  return false;
 }

 /**
  * Get the attribute from a field's html.
  */
 private function _getFieldAttribute($attribute, $fieldHtml) {
  if (preg_match('#' . $attribute . '=["\']([^"\']+)?["\']#is', $fieldHtml, $match)) {
   return $match[1];
  }
  return false;
 }
}
?>


Usage: Add record

<?
$dns = new GoDaddyDNS(array(
 "username"=>'username',
 "password"=>'password',
 'domain'  =>'domain.com'
));
$dns->AddRecord("@","A","123.123.123.123",3600);
?>

Usage: Delete record

<?php
$dns = new GoDaddyDNS(array(
 "username"=>'username',
 "password"=>'password',
 'domain'  =>'domain.com'
));
$records = $dns->findRecords("@");
foreach ($records as $record){
 if ($record["data"]=="123.123.123.123"){
  $dns->deleteRecord($record);
 }
}
$dns->deleteRecord($record);
?>


Sunday, March 31, 2013

c#: save and open hashtable to file.

Save Hashtable object in file:


static void SaveHashtableFile(Hashtable ht,string path){
            BinaryFormatter bfw = new BinaryFormatter();
            FileStream file = File.OpenWrite(path);
            StreamWriter ws = new StreamWriter(file);
            bfw.Serialize(ws.BaseStream, ht);
            file.Close();
        }


Open the save Hashtable file



static Hashtable OpenHashtableFile(string path) {
            FileStream filer = File.OpenRead(path);
            StreamReader readMap = new StreamReader(filer);
            BinaryFormatter bf = new BinaryFormatter();
            Hashtable ret = (Hashtable)bf.Deserialize(readMap.BaseStream);
            file.Close();
            return ret;
        }
usage:

//Open Hash table file
Hashtable ht=OpenHashtableFile("ha.dat");

//Save Hash table into file


SaveHashtableFile(ht,"ha.dat");


Thursday, February 21, 2013

TECH:postfix mail server: filter email by php script

Howto: create simple scrip using PHP to filter incoming email on POSTFIX MAIL SERVER

read article :  http://www.postfix.org/FILTER_README.html ("Simple content filter example")

for the sample we use /etc/postfix to save the script files.

Step 1: create script file  "/etc/postfix/content-filter.sh"


#!/bin/sh

# Localize these. The -G option does nothing before Postfix 2.3.
INSPECT_DIR=/var/spool/filter
SENDMAIL="/usr/sbin/sendmail -G -i" # NEVER NEVER NEVER use "-t" here.

# Exit codes from <sysexits.h>
EX_TEMPFAIL=75
EX_UNAVAILABLE=69

# Clean up when done or when aborting.
trap "rm -f in.$$" 0 1 2 3 15

# Start processing.
cd $INSPECT_DIR || {
 echo $INSPECT_DIR does not exist; exit $EX_TEMPFAIL; }

cat >in.$$ || { 
 echo Cannot save mail to file; exit $EX_TEMPFAIL; }

/./etc/postfix/mail-cleaner.php in.$$
$SENDMAIL "$@" <in.$$

exit $?

Step 2: create php content filter file "/etc/postfix/mail-cleaner.php"



#!/usr/bin/php
<?php
//read mail file.
$file=$argv[1];
$data=file_get_contents($file);

$mail_parts=explode("\n\n",$data);
//Get header
$header=$mail_parts[0];

//Get all mail parts.
$mail_parts[0]="";
$content=implode($mail_parts,"\n\n");

//Remove all email address from  mail content
$content=preg_replace("/[^\s]*@[^@\s]*\.[^@\s]*/", "***@***.***", $content);

//Remove all websites from mail contant
$content=preg_replace("/[a-zA-Z]*[:\/\/]*[A-Za-z0-9\-_]+\.+[A-Za-z0-9\.\/%&=\?\-_]+\.+/i", "www.***.***", $content);

//Save the new email.
file_put_contents($file,$header."\n\n".$content);
?>

Step 3: add configuration to "/etc/postfix/master.cf"

add the following lines to "master.cf"




filter    unix  -       n       n       -       10      pipe
    flags=Rq user=filter null_sender=
    argv=/etc/postfix/content-filter.sh -f ${sender} -- ${recipient}









add option "-o content_filter=filter:dummy" to smtp service 


smtp      inet  n       -       -       -       -       smtpd
 -o content_filter=filter:dummy







Step 4: Create user "filter" and add premissions 
simple run commands :


# (for centOS 6) create new user without home directory
useradd -M filter 

#add execute permissions to script files
chmod +rx /etc/postfix/content-filter.sh   
chmod +rx /etc/postfix/mail-cleaner.php

#create directory filter
mkdir /var/spool/filter

#change owner and group to filter
chown filter /var/spool/filter
chgrp filter /var/spool/filter

Step 5: (*) Disable SELinux security
to running the scripts we must to trun off the selinux security
http://www.crypt.gen.nz/selinux/disable_selinux.html

change the in file "/etc/selinux/config"

from :

SELINUX=enforcing

to:
SELINUX=disabled

Step 6: Reboot.

enjoy!

Attention :
(*) if you don't disable the  SELinux you will see in the maillog file ("/var/log/maillog")
the errors:
Sep 9 18:50:22 localhost postfix/pipe[2960]: 9F2349ABB01: to=<em...@domain.com>, relay=postfixfilter, delay=7441, delays=7441/0.08/0/0.65, dsn=4.3.0, status=deferred (temporary failure. Command output: pipe: fatal: pipe_command: execvp /etc/postfix/content-filter.sh: Permission denied )




Monday, February 11, 2013

Mysql: encode / decode IP to HEX

MYSQL Function to encode IP to HEX

CREATE  FUNCTION `ip_encode`(`ip` VARCHAR(25)) RETURNS char(8) CHARSET utf8
    NO SQL
return concat(
conv(SUBSTRING_INDEX( ip , '.', 1 ),10,16 ) ,
conv(SUBSTRING_INDEX(SUBSTRING_INDEX( ip , '.', 2 ),'.',-1) ,10,16),
conv(SUBSTRING_INDEX(SUBSTRING_INDEX( ip , '.', -2 ),'.',1) ,10,16),
conv(SUBSTRING_INDEX( ip , '.', -1 ),10,16 )


MYSQL Function to decode ip (HEX to IP)


CREATE FUNCTION `ip_decode`(`session_ip` VARCHAR(25)) RETURNS char(50) CHARSET utf8
    DETERMINISTIC
RETURN concat_ws('.',
CONV(substr(session_ip,1,2),16,10),
CONV(substr(session_ip,3,2),16,10),
CONV(substr(session_ip,5,2),16,10),
CONV(substr(session_ip,7,2),16,10),
CONV(substr(session_ip,9,2),16,10))