Procedure to Upgrade Asterisk 12 to 13

Asterisk Asterisk Support
1

Hi All,

I am running Asterisk 12.8.2 on Ubuntu 12.0.4 and I want to upgrade this to stable Asterisk 13 version.
I am searching for the same on net, but cant find any procedure to upgrade, all articles are for new installation.
Please advice me the best way to upgrade my Asterisk from 12.8.2 to any stable version of 13.

Thanks & Regards,
Piyush Aghera

2

In every version of Asterisk there is an UPGRADE.txt which details things to be aware of when upgrading. Otherwise you just install the new version.

3

Thank you. i have upgraded Asterisk to 13.7.2

4

The reason behind upgrading my Asterisk from 12 to 13 was that CDR table was not capturing correct date time, it always records default date time value of 0000-00-00 00:00:00; and somewhere i read that there is problem with Asterisk 12 and should upgrade to 13.
But still i have problem with CDR table, still it records default value rather than server value:
| 0000-00-00 00:00:00 | “Extension1” <60001> | 60001 | 60002 | from-internal | SIP/60001-00000000 | | Dial | SIP/60002,15,TtrIb(func-apply-sipheaders^s^1) | 16 | 15 | ANSWERED | 3 | | 1458553535.0 | | | | 60001 | Extension1 | | | |
| 0000-00-00 00:00:00 | “Extension1” <60001> | 60001 | 60002 | from-internal | SIP/60001-00000001 | | Dial | SIP/60002,15,TtrIb(func-apply-sipheaders^s^1) | 6 | 6 | ANSWERED | 3 | | 1458553637.9 | | | | 60001 | Extension1 | | | |

any idea what am i doing wrong and how do i resolve this issue.

Regards,
Piyush Aghera

5

you can alter the date time to be generated automatically . alter the calldate field …

calldate timestamp NOT NULL default CURRENT_TIMESTAMP

6

thank you for your feedback.
However i think i understood what is happening here post 10.x versions.
Asterisk stores 3 datetime values for each call - start, answer and end - so if i do not specify anything, i believe Asterisk is not able to understand what to store and hence storing the default value.
So i added an alias in /etc/asterisk/cdr_adaptive_odbc.conf as below, to give Asterisk a directive on which value to store in CDR:
[adaptive_connection]
connection=asteriskcdr
table=cdr
alias start => calldate

Reloaded the cdr_adaptive_odbc.so module and voila!!! CDR table started recording correct date and time!!!