Table involved for the recording tracking

mysql> describe recording_track;
+-------------+--------------+------+-----+---------+----------------+
| Field       | Type         | Null | Key | Default | Extra          |
+-------------+--------------+------+-----+---------+----------------+
| id          | int(11)      | NO   | PRI | NULL    | auto_increment |
| primary_ext | varchar(20)  | YES  |     | NULL    |                |
| httplink    | varchar(100) | YES  |     | NULL    |                |
| filesize    | int(20)      | YES  |     | NULL    |                |
+-------------+--------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)

mysql> insert into recording_track values ("","3101","https://drive.google.com/folderview?id=0Bzw96Nl15-yLQlZYR0h2V1dxWmc&usp=sharing&invite=CKjF-ssJ",1250,"201406TnL");
Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> select * from recording_track;
+----+-------------+--------------------------------------------------------------------------------------------------+----------+-----------+
| id | primary_ext | httplink                                                                                         | filesize | name      |
+----+-------------+--------------------------------------------------------------------------------------------------+----------+-----------+
|  1 | 2801        |
https://drive.google.com/folderview?id=0Bzw96Nl15-yLbnJFd2Q1UkhtY1k&usp=sharing&invite=CPWiouII |      948 | 201406LS  |
|  2 | 2801        | https://drive.google.com/folderview?id=0Bzw96Nl15-yLbmh5THoxa1RNU0k&usp=sharing&invite=CImO6sYN  |      225 | 201405LS  |
|  3 | 3101        | https://drive.google.com/folderview?id=0Bzw96Nl15-yLQlZYR0h2V1dxWmc&usp=sharing&invite=CKjF-ssJ  |     1250 | 201406TnL |
+----+-------------+--------------------------------------------------------------------------------------------------+----------+-----------+

Activities on the early of the month

Besides generating bill for all customer by early of the month, the other important activity is to backup the recording .wav files, compress them and transfer them to the google drive. Set the http link for customer to access and also develop a GUI interface to access those download links.

cd /var/www/html
Modify the content of keeplogger.php and change the start - end date/time and master ext for the customer
Run the following command
php keeplogger.php > /mnt/ebs002/keeplogger/TnLJune2014/TnLJune2014.csv

cd /mnt/ebs002/keeplogger/TnLJune2014/
cat TnLJune2014.csv| awk -F'|' '{ print $7 }' > move
vi move

Copy all the .wav belong to this specific customer to the ebs002 directory
:1,$s/^/mv \/mnt\/ebs001\/asterisk\/monitor\//
:1,$s/$/ \./

sh move

tar cvf LSMay14.tar *.wav

gzip LSMay14.tar

scp the .tar.gz to the local PC directory

and then copy to the google drive directory.

Create the link and set to the GUI

Struggling with registration issue

This was the major issue that the client SIP Phone unable to register with the server intermittently. This is particular sensitive to the unifi original DIR-615 modem. From the server's messages log, you can see that the registration attempt was replied with "ChallengeSent" but some how, the client was not receiving this reply.

Trying out many methods including replacing the router with Asus 12HP and the latter seems to make the reoccurring lesser but still didn't fully resolve the problem. Even replacing the Asus router for TMS at Kota Damansara but still out of 6 ip phones (GXP1405), it's always one or two of them unable to register. It seems that the router was blocking the ip phone MAC addresses for some reasons.

The workaround is to replace those problematic ip phone and for Asus 12HP router, once it's connected, there is no issue so far for GSS amd TMS. But it is a hassle to replace the router as most customers prefer to retain the existing unifi router.

The worth to try possible solution was to set the outbound proxy server to the SIP server domain or IP address. So far, I have set this setting onto both TnL and LoanStreet (except the CS 2807 or 2804). Those ip phones still under close monitoring. If still not working, will have to figure out alternate solution

8.8.2014 - based on the last status, the registration fail doesn't happen to those phones with outbound proxy IP set. still under close monitoring