Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3
h1.
Note

Use this tool at your own risk. It was hacked together somewhat hastily and may have unforseen issues.

Code Block

PIN

...

Retrieval

...

Tool

...

The

...

PIN

...

retrieval

...

tool

...

allows

...

sipXecs

...

administrators

...

the

...

ability

...

to

...

extract

...

all

...

user

...

PIN

...

numbers.

...

The

...

following

...

assumptions

...

are

...

made

...

by

...

the

...

tool:

...

  • PIN

...

  • numbers

...

  • are

...

  • ONLY

...

  • numeric

...

  • PIN

...

  • numbers

...

  • are

...

  • no

...

  • less

...

  • than

...

  • 4

...

  • numbers

...

  • PIN

...

  • numbers

...

  • are

...

  • no

...

  • more

...

  • than

...

  • 7

...

  • numbers

...

Though

...

these

...

assumptions

...

could

...

be

...

changed,

...

be

...

advised

...

that

...

PIN

...

numbers

...

larger

...

than

...

7

...

numbers

...

could

...

take

...

a

...

while

...

to

...

decrypt.

...

yum install postgresql-python

Code Block


Once you have copied the tool to your server you should make it executable:

chmod +x getpin.py

Code Block


h1. Usage
Before this tool can be used, you must change the *passwd_realm* variable to whatever your domain name is for your sipXecs system. If your PostgreSQL values are different than the variables in the script you must change those as well. Remember to keep either single or double quotes around your variable values. Here are the default values:

############################## Modify These ###############################
pg_host =

Installation

Download xecsuser:here.

This tool requires no installation, but you might need to install postgresql-python on your system:

Code Block
yum install postgresql-python

Once you have copied the tool to your server you should make it executable:

Code Block
chmod +x getpin.py

Usage

Before this tool can be used, you must change the passwd_realm variable to whatever your domain name is for your sipXecs system. If your PostgreSQL values are different than the variables in the script you must change those as well. Remember to keep either single or double quotes around your variable values. Here are the default values:

Code Block
############################## Modify These ###############################
pg_host = '127.0.0.1'

...


pg_port = 5432

...


pg_user = 'postgres'

...


pg_pass = ''

...


pg_db = 'SIPXCONFIG'

...


pg_table = 'users'

...


# The domain name of your system *required

...

*
passwd_realm = 'host.domain.tld'

...


# Change location of output file here *optional

...

*
outputfile = open('pinlist.csv','w')

...


###########################################################################

...

Once

...

you

...

have

...

changes

...

these

...

values

...

to

...

match

...

your

...

environment

...

simply

...

run

...

the

...

tool:

...

Code Block
./getpin.py

...

The program will, by default, output to pinlist.csv in the same folder as the tool.