Billmax Integration

Preseem can read account and service data from BillMax.
Preseem needs read access to the billmax mysql database.
It reads the following fields:
servdef table: all fields
service table: number, generation, user, servdef, state, d01, d02, d03, d04, d05, d06, d07, d08, d09, d10
servicechange table: changeon, service, generation, servdef, d01, d02, d03, d04, d05, d06, d07, d08, d09, d10
user table: number, account, fname, lname
account table: number, company

To integrate with BillMax, create a new user for Preseem with read access to the above tables, and allow it to connect from the following IP addresses:
 * 206.174.180.53
 * 35.192.219.237

 

 

Blurb of introduction ... get the data tagged with Subscriber and Network information.

 

To integrate with Billmax, we need access to the MySQL database that contains the Billmax database schema.  Could you please send me the hostname of the server, and user credentials (a user and password)?  The Preseem server will need read access at least to the following tables:

servdef table: all fields
service table: number, generation, user, servdef, state, d01, d02, d03, d04, d05, d06, d07, d08, d09, d10
servicechange table: service, generation, servdef, d01, d02, d03, d04, d05, d06, d07, d08, d09, d10
user table: number, account, fname, lname
account table: number, company

From this access, Preseem can read account and service data from BillMax.

We also need a list of Access Point details (at least the IP addresses), and the name of an SNMP read community that the Preseem device can use to poll them.  We also need "Tower" and "Sector" information for each, and can read these details from SNMP (sysLocation and sysName), or you can also provide those in the data you send.

 


NOTES:
 we need access to the MySQL database that contains the billmax database schema.  If you can send me the hostname of the server, and a user and password, I will set this up.  It will connect from the Preseem server.

We also need a list of APs and SNMP read community we can use to poll them.

Just read access to the following tables:

servdef
service
servicechange
user
1mth

For APs, the most basic information is just the IP address of each one.  We also need "Tower" and "Sector" for each.  We can read these from SNMP (sysLocation and sysName), or you can also provide those in the data you send.  Aside from that we just need a SNMP read community to poll them on.

Preseem can read account and service data from BillMax.
Preseem needs read access to the billmax mysql database.
It reads the following fields:
servdef table: all fields
service table: number, generation, user, servdef, state, d01, d02, d03, d04, d05, d06, d07, d08, d09, d10
servicechange table: service, generation, servdef, d01, d02, d03, d04, d05, d06, d07, d08, d09, d10
user table: number, account, fname, lname
account table: number, company

To integrate with BillMax, create a new user for Preseem with read access to the above tables, and allow it to connect from the following IP addresses:
 * 206.174.180.53
 * 35.192.219.237