Asterisk Insecure

Report
Question

This setting specifies how to handle connections with peers. By default Asterisk will authenticate all connections (this is the same as insecure=no). The parameters invite and port were added in v1.2.x  (and are to be used when you trust the IP of the caller), yes and very were removed in v1.6.x. Note: yes/very are deprecated in 1.8

Initial Configuration of Asterisk 3.4 years ago 0 Answers

res_odbc.conf and cdr_odbc.conf sample files for MySQL/MariaDB

Report
Question

On a previous opportunity we configured our Asterisk installation to connect with MariaDB (or MySQL) database through ODBC, using unixODBC. Well, this is a sample of the res_odbc.conf and cdr_odbc.conf files that would work just out of the box with that configuration:   This is the /etc/asterisk/res_odbc.conf file, where we configure our DSNs as available resources for Asterisk. Remember The default context name expected by Asterisk is 'asterisk', but it could have been called whatever you want as long as you remember that name and configure it correctly in the…

Initial Configuration of Asterisk 4.1 years ago 0 Answers

Asterisk unixODBC configuration files for MySQL and MariaDB

Report
Question

1.0 Asterisk + unixODBC

Having almost all of our Asterisk configuration based on our preferred Database Management System is one of the greatest advantages that we have at the moment to deploy a VoIP solution. Now, having the possibility of building and integrated and unified communication solution in a non-intrusive way for client's company, while at the same time assuring scalability and flexibility, that's a mayor thing. That's precisely what we have at the moment of using Asterisk+unixODBC. unixODBC "allows the user or the system administrator to easily configure an application to use any ODBC compliant data source. This is…

Initial Configuration of Asterisk 4.1 years ago 0 Answers

MySQL and MariaDB voicemessages Schema

Report
Question

If you are using MySQL or MariaDB, and are planning to use ODBC storage for Voicemail, this table schema for voicemessages table could be useful. The storage engine has explicitly been defined as 'MyISAM'. Recent versions of MySQL use InnoDB by default, you can also use XtraDB (drop-in replacement for InnoDB in MariaDB).

CREATE TABLE `voicemessages` (
  `msgnum` int(11) unsigned DEFAULT NULL,
  `dir` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `context` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `macrocontext` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `callerid` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `origtime` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `duration` varchar(20) COLLATE utf8_unicode_ci…

Initial Configuration of Asterisk 4.1 years ago 0 Answers

MySQL/MariaDB CDR Schema

Report
Question

If you are using MySQL or MariaDB, this table schema for CDR table could be useful:  

CREATE TABLE `cdr` (                                                                                                                        
  `calldate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `clid` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  `src` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  `dst` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  `dcontext` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  `channel` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  `dstchannel` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  `lastapp` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  `lastdata` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  `duration` int(11) NOT NULL DEFAULT '0',
  `billsec` int(11) NOT NULL DEFAULT '0',
  `disposition` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `amaflags` int(11) NOT…

Initial Configuration of Asterisk 4.1 years ago 0 Answers

MySQL CEL Table Schema

Report
Question

From the Asterisk Wiki, we have this description of CEL: "CEL, or Channel Event Logging, has been written with the hopes that it will help solve some of the problems that were difficult to address in CDR records. Some difficulties in CDR generation are the fact that the CDR record stores three events: the "Start" time, the "Answer" time, and the "End" time. Billing time is usually the difference between "Answer" and "End", and total call duration was the difference in time from "Start" to "End". The trouble with this direct and simple approach is the fact that calls can…

Initial Configuration of Asterisk 4.1 years ago 0 Answers

Asterisk 1.8 and 1.4 SlackBuilds for Slackware Linux

Report
Question

I've been working with a set of SlackBuilds that might be helpful for people that want to install Asterisk 1.4/1.8 from source, but, maintaining the possibility to easily (painlessly) update/upgrade/uninstall/patch/recompile Asterisk. The Scripts are located here: https://bitbucket.org/jespinal/slackbuilds/overview You just need to do:

$ hg clone https://bitbucket.org/jespinal/slackbuilds
And look for instructions on README file. These scripts might save you some time if you like to maintain your own packages and/or are planning to write an automated installation script based on customized packages. There are some pre-created configuration file that might be used as samples or drop in files for…

Installing Asterisk 4.3 years ago 0 Answers