Asterisk GUI phpMyEdit
I have developed a Web-based GUI for Asterisk using phpMyEdit.
This quickly provides a powerful interface to View/Add/Modify/Delete records.
All users are stored in a MySQL table:
CREATE TABLE `bit_users` (
`mailbox` varchar(4) NOT NULL default '',
`shortname` varchar(20) NOT NULL default '',
`fullname` varchar(40) NOT NULL default '',
`email` varchar(40) NOT NULL default '',
`password` varchar(20) NOT NULL default '',
`AccountCode` varchar(20) NOT NULL default '',
`location` varchar(6) NOT NULL default '',
`pickupgroup` char(2) NOT NULL default '',
`Language` char(2) NOT NULL default 'en',
`CallDiversion` varchar(4) NOT NULL default '',
`DivertUnavailable` varchar(4) NOT NULL default '',
`DnD` char(1) NOT NULL default '0',
`template` varchar(20) NOT NULL default '',
`options` varchar(20) NOT NULL default '',
`pager` varchar(20) NOT NULL default '',
`context` varchar(20) NOT NULL default 'default',
`type` varchar(5) NOT NULL default 'user',
PRIMARY KEY (`mailbox`)
) TYPE=MyISAM COMMENT='Users of the Asterisk PBX';
Users can roam between SIP & IAX clients
(Note that I use the templates functionality of chan_sip2, so user-agent settings are pulled from the ‘template’ field)
I have modified the PHP script to call an external script whenever any data is modified.
Changes need to be hooked into these 3 functions:
do_add_record()
do_change_record()
do_delete_record()
// Reload Asterisk to activate new settings
exec(“sudo /usr/local/bin/update-asterisk.pl & >/dev/null”);
This script writes out text-files which get #included into the main configuration files.
Then it restarts Asterisk by using the Asterisk manager API interface.
– this works better than simply calling “asterisk -r -x reload” as it returns quicker.
update-asterisk.pl:
use DBI;
use Net::Telnet ();
################### BEGIN OF CONFIGURATION ####################
# MySQL configuration
$dbuser = "asteriskro";
$dbpass = "password";
$dbhost = "localhost";
$dbname = "asterisk";
$dbtable_users = "users";
# Asterisk Manager configuration
$mgruser = "reload";
$mgrpass = "password";
$mgrhost = "127.0.0.1";
$mgrport = "5038";
$conf_path = "/etc/asterisk/";
$conf_file_users_sip = "users-sip.conf"; # User accounts accessible via SIP
$conf_file_users_iax = "users-iax.conf"; # User accounts accessible via IAX
$conf_file_voicemail = "users-voicemail.conf"; # Voicemail
$conf_file_mapping = "mapping.conf"; # Map incoming <sip:username@domain> requests to extensions
################### END OF CONFIGURATION #######################
$conf_users_sip = "$conf_path" . "$conf_file_users_sip";
$conf_users_iax = "$conf_path" . "$conf_file_users_iax";
$conf_voicemail = "$conf_path" . "$conf_file_voicemail";
$conf_mapping = "$conf_path" . "$conf_file_mapping";
$dbh = DBI->connect("dbi:mysql:dbname=$dbname;host=$dbhost", "$dbuser", "$dbpass");
$statement = "SELECT mailbox,template,password,fullname,pickupgroup,AccountCode,language,shortname,email,location from $dbtable_users";
my $result = $dbh->selectall_arrayref($statement);
unless ($result) {
# check for errors after every single database call
print "dbh->selectall_arrayref($statement) failed!\n";
print "DBI::err=[$DBI::err]\n";
print "DBI::errstr=[$DBI::errstr]\n";
exit;
}
my @resultSet = @{$result};
if ( $#resultSet > -1 ) {
open CONF, ">$conf_users_sip" || die "Cannot create/overwrite file: $conf_users_sip\n";
open CONF2, ">$conf_users_iax" || die "Cannot create/overwrite file: $conf_users_iax\n";
foreach $row (@{ $result }) {
my @result = @{ $row };
$mailbox=$result[0];
$template=$result[1];
$password=$result[2];
$fullname=$result[3];
$pickupgroup=$result[4];
$accountcode=$result[5];
$language=$result[6];
$shortname=$result[7];
$email=$result[8];
$location=$result[9];
if ($location eq "gboxf") {
if ($template eq "firefly" | $template eq "iaxcomm") {
print CONF2 "[$mailbox]\n";
print CONF2 "type=friend\n";
print CONF2 "host=dynamic\n";
print CONF2 "context=lan-phones\n";
print CONF2 "permit=0.0.0.0/0.0.0.0\n";
print CONF2 "secret=$password\n";
print CONF2 "callerid=\"$fullname\" <$mailbox>\n";
print CONF2 "accountcode=$accountcode\n";
print CONF2 "language=$language\n";
print CONF2 "mailbox=$mailbox\@lan\n";
print CONF2 "\n";
} else {
print CONF "[$mailbox]\n";
print CONF "template=$template\n";
print CONF "type=friend\n";
print CONF "username=$mailbox\n";
print CONF "secret=$password\n";
print CONF "callerid=\"$fullname\" <$mailbox>\n";
if ($pickupgroup eq"") {
} else {
print CONF "callgroup=$pickupgroup\n";
print CONF "pickupgroup=$pickupgroup\n";
}
print CONF "accountcode=$accountcode\n";
print CONF "language=$language\n";
print CONF "mailbox=$mailbox\@lan\n";
print CONF "\n";
}
}
}
close CONF;
close CONF2;
open CONF, ">$conf_voicemail" || die "Cannot create/overwrite file: $conf_voicemail\n";
foreach $row (@{ $result }) {
my @result = @{ $row };
$mailbox=$result[0];
$password=$result[2];
$fullname=$result[3];
$language=$result[6];
$email=$result[8];
print CONF "$mailbox => $password,$fullname,$email,,attach=no|review=yes|language=$language\n";
}
close CONF;
open CONF, ">$conf_mapping" || die "Cannot create/overwrite file: $conf_mapping\n";
foreach $row (@{ $result }) {
my @result = @{ $row };
$mailbox=$result[0];
$shortname=$result[7];
print CONF "exten => $shortname,1,Goto(lan,$mailbox,1)\n";
}
close CONF;
}
# Reload Asterisk
$tn = new Net::Telnet (Port => $mgrport,
Prompt => '/.*[\$%#>] $/',
Output_record_separator => '',
# Errmode => Return,
);
#$fh = $tn->dump_log("./telnet.log");
$tn->open("$mgrhost");
$tn->waitfor('/0\n$/');
$tn->print("Action: Login\nUsername: $mgruser\nSecret: $mgrpass\n\n");
$tn->waitfor('/Authentication.*/'); # print auth accepted
$command="Action: command\nCommand: reload\n\n";
$tn->cmd(String => "$command", Prompt => '/--END COMMAND--/');
exit 0;
Note that sudo is used to allow the web interface to write to the Asterisk config files.
/etc/sudoers:
Defaults:apache !lecture
apache localhost = NOPASSWD: /usr/local/bin/update-asterisk.pl
I have further extended the functionality by using app_dbodbc.
Again, the same 3 functions in the PHP script need to have additional lines added
do_add_record():
// Update app_dbodbc's astdb
$extension = $newvals[mailbox];
if ($newvals[template] == "firefly"){
$protocol = "IAX2";
} else {
$protocol = "SIP";
}
$dnd = $newvals[DnD];
$cd = $newvals[CallDiversion];
$cdu = $newvals[DivertUnavailable];
$location = $newvals[location];
$query_dbodbc = "INSERT INTO astdb VALUES ('Protocol','$extension','$protocol')";
$res = $this->myquery($query_dbodbc, __LINE__);
$query_dbodbc = "INSERT INTO astdb VALUES ('dnd','$extension','$dnd')";
$res = $this->myquery($query_dbodbc, __LINE__);
$query_dbodbc = "INSERT INTO astdb VALUES ('cd','$extension','$cd')";
$res = $this->myquery($query_dbodbc, __LINE__);
$query_dbodbc = "INSERT INTO astdb VALUES ('cdu','$extension','$cdu')";
$res = $this->myquery($query_dbodbc, __LINE__);
$query_dbodbc = "INSERT INTO astdb VALUES ('location','$extension','$location')";
$res = $this->myquery($query_dbodbc, __LINE__);
I have a similar UI which users can use to amend their own settings.
They just see their own details (of course) & login using their shortname & password (authentication is controlled using mod_auth_mysql).
See also:
back to Asterisk GUI
April 7, 2023
Phone System 