Archive

Posts Tagged ‘Asterisk’

Fixing queues display in trixboxGraph

March 21st, 2012 No comments

I recently installed the trixboxGraph package to my trixbox CE asterisk PBX, and discovered that the functions related to queues were borken. I investigated and fixed it. There are two lines that need updating in tb-trixboxgraph/index.php.

--- index.orig.php 2012-03-21 10:02:54.000000000 -0700
+++ index.php 2012-03-21 10:04:51.000000000 -0700
@@ -136,7 +136,7 @@
fwrite ($f, "node [ style=\"filled\", fillcolor=\"#ffffff\" ];\n");

if ($showQueues) {
- $sql = "select distinct id from queues";
+ $sql = "select distinct id from queues_details";
if (!$res = mysql_query ($sql)) {
die ($sql . " => " . mysql_error ());
}
@@ -148,7 +148,7 @@
}
}
mysql_free_result ($res);
- $sql = "select id,data from queues where keyword='member'";
+ $sql = "select id,data from queues_details where keyword='member'";
if (!$res = mysql_query ($sql)) {
die ($sql . " => " . mysql_error ());
}

You can download the diff file here.

Using a sound card as a Music on Hold source in Asterisk

December 15th, 2007 6 comments

Using the line-in port with Trixbox or PBX-in-a-Flash (PiaF)

Asterisk is a fantastic piece of software. You get world class PBX functionality for free, in a package that you can reliably run on a desktop computer.

One area that Asterisk isn’t as world class in is Music on Hold (MoH). Sure, it’s there and it works, but it starts playing a file from the beginning whenever someone is placed on hold. If you have customers who call regularly, they’re hearing the same part of the same files all the time – not ideal.

What I wanted to do was use my MP3 player as a MoH source Read more…