All posts by patrick.preuss

Uncategorized

Excel INET_ATON / INET_NTOA

Option Explicit

Public Function INET_ATON(IP As String) As Double

   Dim IPArray As Variant

   IPArray = Split(IP, ".")
   INET_ATON = (IPArray(0) * 256 ^ 3) 
   INET_ATON = INET_ATON + (IPArray(1) * 256 ^ 2) 
   INET_ATON = INET_ATON + (IPArray(2) * 256) 
   INET_ATON = INET_ATON + IPArray(3)

End Function
Public Function INET_NTOA(IPNumber As Double) As String

   INET_NTOA = (IPNumber \ 256 ^ 3)
   INET_NTOA = INET_NTOA & "." 
   INET_NTOA = INET_NTOA & ((IPNumber Mod (256 ^ 3)) \ 256 ^ 2)
   INET_NTOA = INET_NTOA & "." 
   INET_NTOA = INET_NTOA & (((IPNumber Mod (256 ^ 3)) Mod (256 ^ 2)) \ 256)
   INET_NTOA = INET_NTOA & "." 
   INET_NTOA = INET_NTOA & (((IPNumber Mod (256 ^ 3)) Mod (256 ^ 2)) Mod 256)

End Function
=VALUE(LEFT(A1,FIND(".",A1)-1))*2^24+VALUE(MID(A1,FIND(".",A1)+1,FIND(".",A1,FIND(".",A1)+1)-FIND(".",A1)-1))*2^16+VALUE(MID(A1,FIND(".",A1,FIND(".",A1)+1)+1,FIND(".",A1,FIND(".",A1,FIND(".",A1)+1)+1)-FIND(".",A1,FIND(".",A1)+1)-1))*2^8+VALUE(RIGHT(A1,LEN(A1)-FIND(".",A1,FIND(".",A1,FIND(".",A1)+1)+1)))
Uncategorized

ASA Failover SNMP

[dedus033 ~]$ snmpwalk -v 2c -c public10.2.0.250 1.3.6.1.4.1.9.9.147.1.2.1.1.1
CISCO-SMI::ciscoMgmt.147.1.2.1.1.1.2.4 = STRING: “Failover LAN Interface”
CISCO-SMI::ciscoMgmt.147.1.2.1.1.1.2.6 = STRING: “Primary unit”
CISCO-SMI::ciscoMgmt.147.1.2.1.1.1.2.7 = STRING: “Secondary unit (this device)”
CISCO-SMI::ciscoMgmt.147.1.2.1.1.1.3.4 = INTEGER: 2
CISCO-SMI::ciscoMgmt.147.1.2.1.1.1.3.6 = INTEGER: 4
CISCO-SMI::ciscoMgmt.147.1.2.1.1.1.3.7 = INTEGER: 9
CISCO-SMI::ciscoMgmt.147.1.2.1.1.1.4.4 = STRING: “Failover Vlan899”
CISCO-SMI::ciscoMgmt.147.1.2.1.1.1.4.6 = STRING: “Unit has failed”
CISCO-SMI::ciscoMgmt.147.1.2.1.1.1.4.7 = STRING: “Active unit”
[dedus033 ~]$ snmpwalk -v 2c -c public10.2.0.140 1.3.6.1.4.1.9.9.147.1.2.1.1.1
CISCO-SMI::ciscoMgmt.147.1.2.1.1.1.2.4 = STRING: “Failover LAN Interface”
CISCO-SMI::ciscoMgmt.147.1.2.1.1.1.2.6 = STRING: “Primary unit (this device)”
CISCO-SMI::ciscoMgmt.147.1.2.1.1.1.2.7 = STRING: “Secondary unit”
CISCO-SMI::ciscoMgmt.147.1.2.1.1.1.3.4 = INTEGER: 2
CISCO-SMI::ciscoMgmt.147.1.2.1.1.1.3.6 = INTEGER: 9
CISCO-SMI::ciscoMgmt.147.1.2.1.1.1.3.7 = INTEGER: 10
CISCO-SMI::ciscoMgmt.147.1.2.1.1.1.4.4 = STRING: “Failover GigabitEthernet0/2”
CISCO-SMI::ciscoMgmt.147.1.2.1.1.1.4.6 = STRING: “Active unit”
CISCO-SMI::ciscoMgmt.147.1.2.1.1.1.4.7 = STRING: “Standby unit”
[dedus033 ~]$ snmpwalk -v 2c -c public10.2.0.141 1.3.6.1.4.1.9.9.147.1.2.1.1.1
CISCO-SMI::ciscoMgmt.147.1.2.1.1.1.2.4 = STRING: “Failover LAN Interface”
CISCO-SMI::ciscoMgmt.147.1.2.1.1.1.2.6 = STRING: “Primary unit”
CISCO-SMI::ciscoMgmt.147.1.2.1.1.1.2.7 = STRING: “Secondary unit (this device)”
CISCO-SMI::ciscoMgmt.147.1.2.1.1.1.3.4 = INTEGER: 2
CISCO-SMI::ciscoMgmt.147.1.2.1.1.1.3.6 = INTEGER: 9
CISCO-SMI::ciscoMgmt.147.1.2.1.1.1.3.7 = INTEGER: 10
CISCO-SMI::ciscoMgmt.147.1.2.1.1.1.4.4 = STRING: “Failover GigabitEthernet0/2”
CISCO-SMI::ciscoMgmt.147.1.2.1.1.1.4.6 = STRING: “Active unit”
CISCO-SMI::ciscoMgmt.147.1.2.1.1.1.4.7 = STRING: “Standby unit”

Computer, Debian, Linux, Operating Systems, Uncategorized

Linux Serial Console – Grub

# If you change this file, run 'update-grub' afterwards to update
# /boot/grub/grub.cfg.

GRUB_DEFAULT=0
GRUB_TIMEOUT=1
GRUB_DISTRIBUTOR=`lsb_release -i -s 2> /dev/null || echo Debian`
GRUB_CMDLINE_LINUX_DEFAULT="console=tty0 console=ttyS0,9600n8"

# Uncomment to disable graphical terminal (grub-pc only)
GRUB_TERMINAL=serial
GRUB_SERIAL_COMMAND="serial --speed=9600 --unit=0 --word=8 --parity=no --stop=1"

# The resolution used on graphical terminal
# note that you can use only modes which your graphic card supports via VBE
# you can see them in real GRUB with the command `vbeinfo'
#GRUB_GFXMODE=640x480

# Uncomment if you don't want GRUB to pass "root=UUID=xxx" parameter to Linux
#GRUB_DISABLE_LINUX_UUID=true

/etc/inittab

T0:2345:respawn:/sbin/getty -L ttyS0 9600 vt100
Computer, E-Mail, Uncategorized

Exim

### auth/30_exim4-config_examples
plain:
  driver = plaintext
  public_name = PLAIN
  client_send = "${if !eq{$tls_cipher}{}{\
             ^${extract{1}{::}\
               {${lookup{$host}lsearch*{CONFDIR/passwd.client}{$value}fail}}}\
             ^${extract{2}{::}\
               {${lookup{$host}lsearch*{CONFDIR/passwd.client}{$value}fail}}}\
           }fail}"

login:
  driver = plaintext
  public_name = LOGIN
  client_send = "${if !eq{$tls_cipher}{}{}fail}\
                 : ${extract{1}{::}\
                {${lookup{$host}lsearch*{CONFDIR/passwd.client}{$value}fail}}} \
                 : ${extract{2}{::}\
             {${lookup{$host}lsearch*{CONFDIR/passwd.client}{$value}fail}}}"

### transport/30_exim4-config_remote_smtp
remote_smtp:
  debug_print = "T: remote_smtp for [EMAIL PROTECTED]"
  driver = smtp
  hosts_try_auth = DCsmarthost

### CONFDIR/passwd.client
smtp.1und1.com:m12345678-9:beispielpasswort

http://www.mail-archive.com/debian-user-german@lists.debian.org/msg67453.html

Computer, Debian, Life, Linux, Programming

Subversion Homedir

Preparing the software:

apt-get install subversion libapache2-svn
sudo mkdir  /mnt/var/svn
chown www-data:www-data -R /mnt/var/svn

Apache Config:

<Location /svn>
DAV svn
   SVNParentPath /mnt/var/svn
   <LimitExcept GET PROPFIND OPTIONS REPORT>
      AuthType Basic
      AuthName "Authorization Realm"
      AuthUserFile /mnt/var/svn/svnauthusers.txt
      Require valid-user
   </LimitExcept>
</Location>
sudo htpasswd -c /mnt/var/svn/svnauthusers.txt patrick.preuss 
sudo chown www-data:www-data /mnt/var/svn/svnauthusers.txt

sudo svnadmin create /mnt/var/svn/patrick.preuss
sudo chown www-data:www-data -R /mnt/var/svn/patrick.preuss

svn co http://10.0.12.10/svn/patrick.preuss