kelvinewilliams

<?xml version="1.0"?>
<!DOCTYPE Configure PUBLIC "-//Mort Bay Consulting//DTD Configure//EN" "http://jetty.mortbay.org/configure.dtd">

<Configure class="org.eclipse.jetty.webapp.WebAppContext">
    <New id="LERG" class="org.eclipse.jetty.plus.jndi.Resource">
        <Arg></Arg>
        <Arg>jdbc/LERG</Arg>
        <Arg>
            <New class="org.postgresql.ds.PGPoolingDataSource">
                <Set name="user">redacted</Set>

kelvinewilliams

lrn_prefix,interstate,intrastate
1201200,0.0029,0.0028
1201203,0.0029,0.0024
1201205,0.0005,0.0005
1201206,0.0005,0.0005
1201207,0.0006,0.0006
1201209,0.0029,0.0028
1201210,0.0025,0.0025
1201212,0.0005,0.0005
1201213,0.0006,0.0006

kelvinewilliams

*** EFFECTIVE DATE: 2016-04-18 00:00:01 UTC ***

Attached you will find an updated Rate Schedule that updates pricing for Voice Termination Services. This Rate Schedule contains a complete list of all codes and rates 373K currently offers for its Voice Termination Services.

This rate notification and the attached rate schedule appends, supersedes, and replaces any and all previous offers or schedules (written, electronic or otherwise) from 373K. These rates shall apply until such time as 373K notifies you of any subsequent rate schedule changes.

Terms & Conditions:

1.  The Rate Schedule is effective as of the date and time provided herein (the "Effective Date and Time"). All dates and times are UTC.
2.  The destination rate for a call is based upon the LRN (Location Routing Number, if any) query result at the time the call is placed.

kelvinewilliams

What Started it:

https://twitter.com/373KInc/status/701160957112950784

Print: 

http://www.thenewcivilrightsmovement.com/georgia_based_telecom_says_time_to_relocate_after_lawmakers_pass_anti_gay_religious_freedom_bill

http://www.rawstory.com/2016/02/telecom-company-abandoning-georgia-after-sweeping-anti-gay-bill-passes-we-dont-tolerate-that-crap/

kelvinewilliams

What Started it:

https://twitter.com/373KInc/status/701160957112950784

Print: 

http://www.thenewcivilrightsmovement.com/georgia_based_telecom_says_time_to_relocate_after_lawmakers_pass_anti_gay_religious_freedom_bill

http://www.rawstory.com/2016/02/telecom-company-abandoning-georgia-after-sweeping-anti-gay-bill-passes-we-dont-tolerate-that-crap/

kelvinewilliams

Create a socket client that will create a query packet (see below) and send to the server, then wait for the response upon receiving the response parse it and print to stdout.

THIS MUST RUN ON LINUX!  The Dialed Digits and responses are ASCII.

Query Packet:
[Size][DialedDigits]
	- Size: 4 bytes, Little Endian, Number of bytes of the Dialed Digits.
	- Dialed Digits: Ten digit NANP telephone number.
		- RegEx checks would be nice [2-9][0-9]{2}[2-9][0-9]{2}[0-9]{4}

kelvinewilliams

(gdb) bt full
#0  0x00007f39d1c51107 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
        resultvar = 0
        pid = 27197
        selftid = 27221
#1  0x00007f39d1c524e8 in __GI_abort () at abort.c:89
        save_stage = 2
        act = {__sigaction_handler = {sa_handler = 0x7ffca784ee3f, sa_sigaction = 0x7ffca784ee3f}, sa_mask = {__val = {139886310445473, 139886175582220, 8989, 4, 139886160984864, 307224387136, 139885072237208, 4294967296, 0, 0, 0, 21474836480, 139886310444999, 139886160985016, 139886344691712, 139886310460648}}, sa_flags = -909241664, sa_restorer = 0x7f39c9ce2150 <__func__.15562>}
        sigs = {__val = {32, 0 <repeats 15 times>}}
#2  0x00007f39d1c4a226 in __assert_fail_base (fmt=0x7f39d1d80ce8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x7f39c9ce12c0 "pleted || orq->orq_queue == sa->sa_out.terminated", file=file@entry=0x7f39c9cdf80c <__PRETTY_FUNCTION__.13330+11> "eue", line=line@entry=8989, function=function@entry=0x7f39c9ce2

kelvinewilliams

FreeSWITCH (Version 1.7.0 git 3f3b855 2015-11-05 17:31:49Z 64bit)

(gdb) bt full
#0  0x00007f05a9d6a107 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
        resultvar = 0
        pid = 11627
        selftid = 11649
#1  0x00007f05a9d6b4e8 in __GI_abort () at abort.c:89
        save_stage = 2
        act = {__sigaction_handler = {sa_handler = 0x7ffd2c994e14, sa_sigaction = 0x7ffd2c994e14}, sa_mask = {__val = {139662302208417, 139662167344716, 8989, 4, 139661129280288, 9999228480, 139660860921304, 4294967296, 0, 0, 0, 21474836480, 139662302207943, 139661129280440, 139662336450560, 139662302223592}}, sa_flags = -1579179776, sa_restorer = 0x7f05a1dfaf90 <__PRETTY_FUNCTION__.17413>}

kelvinewilliams

derecho=# select * from lcr.rates where lrn_prefix @> '1404543' and sdc_penalty = false order by interstate;
 carrier_id | lrn_prefix |  interstate  |  intrastate  |        effective_date         | expiration_date | min_inc | add_inc | sdc_penalty | permanent
------------+------------+--------------+--------------+-------------------------------+-----------------+---------+---------+-------------+-----------
      82638 | 1404543    | 0.0018700000 | 0.0018700000 | 2015-10-29 00:00:00+00        |                 |       6 |       6 | f           | f
      26663 | 1404543    | 0.0021000000 | 0.0021000000 | 2015-12-07 18:48:36.199341+00 |                 |       6 |       6 | f           | f
      47565 | 1404543    | 0.0022000000 | 0.0019000000 | 2015-11-13 00:00:01+00        |                 |       6 |       6 | f           | f
      78272 | 1404543    | 0.0023000000 | 0.0020000000 | 2015-10-16 19:17:50.585582+00 |                 |       6 |       6 | f           | f
      76263 | 1404543    | 0.0023600000 

kelvinewilliams

lrn_prefix,interstate,intrastate
1201007,0.00232258050,0.00177419400
1201032,0.00648150000,0.00648150000
1201040,0.00578700000,0.00635250000
1201200,0.00435483900,0.00435483900
1201201,0.02055008850,0.01921182300
1201202,0.00298350000,0.00311700000
1201203,0.00465000000,0.00412419300
1201204,0.00507741900,0.00272700000
1201205,0.00058500000,0.00060000000