| Note |
|---|
Use this tool at your own risk. It was hacked together somewhat hastily and may have unforseen issues.
| Code Block |
|---|
h1. 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. h1. |
...
Installation |
...
Download [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 = |^getpin.py] This tool requires no installation, but you might need to install *postgresql-python* on your system: |
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 = '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')
...
###########################################################################Code Block Once you have changes these values to match your environment simply run the tool:
...
- ./getpin.py
Code Block
The program will, by default, output to pinlist.csv in the same folder as the tool.