Migrating tuitionads from iwebhosting to ipserverone

Due to slow and security concern, I have decided to migrate the tuitionads to ipserverone.
Firstly, I need to get the migration code from iwebhosting - easy, there is a way from their menu itself
then, I share with ipserverone support and they trigger the migration process
Within 3-5 days, the domain is migrated but I need to move the wordpress over

backup the entire public_html directory and ftp to the ipserverone
backup the database and restore onto the new ipserverone xxxxwp5
but there are few more changes required... wp_config,
change the domain from tuitionads.com www.tuitionads.com
change all the pages with db connection - to using new databse, user and password.
surprisingly, ip serverone doesn't allow to change the db name or even create new user

How to identify the AMI (for the instance) and also the creation date

As we creating more and more instances, it's important to know that the instance was created based on which AMI. First, there is a relationship between the snapshots and AMI in the snapshot's description. based on that, you shall be able to tell the creation date of those AMI.
E.g

The jinercel instance was created based on the ami-6cce9c3e
Refer to snapshot this ami is created on the May 14 2014
So in order to determine the earlier AMI which was without the A2Billing,
It shall be the AMI created for the alwaysblue instance (ami-b096dce2)
which was created on Oct 14 2013

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

Retransmission timeout error - SIP NAT issue

when you have this problem in the /var/log/asterisk/full as below .....

[May 15 15:29:09] WARNING[2376] chan_sip.c: Retransmission timeout reached on transmission ZTlmMDZlNjk1ODVkNWU5ZGRlNmI2ZWFhZGM5MDU5NGY. for seqno 2 (Critical Response) -- See https://wiki.asterisk.org/wiki/display/AST/SIP+Retransmissions
Packet timed out after 6401ms with no response
[May 15 15:29:09] WARNING[2376] chan_sip.c: Hanging up call ZTlmMDZlNjk1ODVkNWU5ZGRlNmI2ZWFhZGM5MDU5NGY. - no reply to our critical packet (see https://wiki.asterisk.org/wiki/display/AST/SIP+Retransmissions).
[May 15 15:29:09] VERBOSE[2420][C-00000000] res_agi.c:     -- AGI Script a2billing.php completed, returning 4
[May 15 15:29:09] VERBOSE[2420][C-00000000] pbx.c:   == Spawn extension (PSTNOutBound, 60383215500, 9) exited non-zero on 'SIP/5106-00000000'

It was due to /var/www/html/admin/modules/core/etc/sip.conf
externip= (MUST SET TO THE CORRECT EXTERNAL IP Address)

How to plan order for new domain on ip serverone

Login to https://portal.ipserverone.com/customer/account/login_owner
login - checkerbox88@gmail.com
password - XXXXXXX
Buy a new domain and picking back on the existing host - RM38
Paid thru maybank2u and now waiting for their sales to revert on the domain registration