A few weeks back I covered connecting ODBC to MS-SQL, but today we are going to do the same thing with MySQL. The process is very similar. One might ask, why use ODBC driver in the first place? The reason is simple, there are many flavors of SQL and the ODBC driver allows one standard [...]
Last week at work(VoiceIP Solutions) I did some research for Asterisk PBX integration with Microsoft CRM. The customer likes open source Asterisk because of the cost savings, but they requires screen pop-ups, and click to dial from their Customer Relationship Management software. So while my manager worked on the TAPI middleware, I was charged with [...]
The standard method of configuring users in Asterisk 1.2 and early 1.4 was to define an agent in the agents.conf configuration file. This agent is tied to no particular phone or SIP extension. When the Agent log’s in he is prompted for three things by the dial plan application, ‘AgentCallBackLogin()’: 1. Agent Number 2. Agent [...]
I told a customer for the company I for that I would figure out how to logout agents by CID(Caller ID). So I figured, why not kill two birds with one stone. Today we will create a single Queue, Agent, and dial plan to accomplish this goal. I’m using Asterisk 1.4, Fedora 10 and a [...]
What makes Asterisk so great is the growing ecosystem of 3rd party software. For call centers based on Asterisk PBX, the best on the market is Queuemetrics. This solution allows for over 150 different statistics to be collected. Here is just a few: Number of calls Total call length Average call length Average call waiting [...]
In my opinion the best IP business phones on the market are made by Polycom. Anyone that knows anything about the VoIP Industry knows that! High quality Polycom desk phones combined with Asterisk are a great combination of quality/price. So to that end we’re doing this lab. Polycom employs several methods of provisioning the SIP [...]
I got an Asterisk Appliance from VoiceIP Solutions for the purpose of writing up some labs. I just got my hands on the unit and the first thing we are a going to do is upgrade the firmware. I’m going to start by plugging my laptop’s ethernet into the LAN port on the Asterisk Appliance. [...]
VoiceIP Solutions is a Asterisk ‘consulting & deployment’ company in Seattle Washington. They deploy Asterisk solutions for businesses of all sizes. From small offices to universities and call centers. They have sites deployed all over the United States, but mostly on the West Coast. I’ve been following them for some time; I guess they started [...]
The other day I was doing an Asterisk 1.2 –> 1.4 upgrade. I have a MySQL database that Asterisk records the Call Detail Record’s(CDR) too. I deleted the asterisk 1.2 modules, then compiled/installed asterisk 1.4 & asterisk-addons 1.4. Being that I hadn’t set up the CDR MySQL stuff in a while I loaded the res_mysql.conf, [...]
A while back I wrote an article for asteriskvoipnews.com about routing loops occurring from misconfigured DNS(or lack there of). My article was about routing loops caused by Asterisk attempting to send mail outside the network when the mail server destination is internal. To correct this issue the Asterisk PBX needs to define a ‘mail relay’(mail [...]