Solon Zenetzis, Author at SBZ Systems

Problem with opening call monitoring recording file, 404 File not found! (Elastix)

If each time you try to open monitor recordings on Elastix you receive the message 404 File not found!, this is a simple solution for the issue (worked for elastix-2.5.0-1): Go to

1	/var/www/html/modules/monitoring

and edit index.php On line 384 insert the line:

1	$namefile=str_replace(" ","+",$namefile);

so it will look like that:

...

if (is_null($record) || !preg_match('/^[[:digit:]]+\.[[:digit:]]+$/', $record)) {

// Missing or invalid uniqueid

Header('HTTP/1.1 404 Not Found');

die("404 "._tr("no_file")." ");

}

// Check record is valid and points to an actual file

$namefile=str_replace(" ","+",$namefile);

$filebyUid = $pMonitoring->getAudioByUniqueId($record, $namefile);

if (is_null($filebyUid) || count($filebyUid) <= 0) {

// Uniqueid does not point to a record with specified file

Header('HTTP/1.1 404 Not Found');

die("404 "._tr("no_file")." ");

}

...

save it.

Solon Zenetzis Last modified.: 26/01/2019 Asterisk (Issabel, FreePBX, Elastix, Trixbox)

Secure Issabel and Elastix PBX (asterisk)

Change default sip port from 5060 to something else for example 11333.

1 2	cd /etc/asterisk nano sip_general_custom.conf

add the following to the file:

1	bindport=5060

(Change 5060 to your new port).

1 2	amportal stop amportal start

Don’t forget to add the new port into Fail2Ban.

1 2	cd /etc/fail2ban nano jail.local

Define the new port on firewall Disable unused rules and add a one with the new port Reduce […]

Solon Zenetzis Last modified.: 10/12/2018 Asterisk (Issabel, FreePBX, Elastix, Trixbox)

Wincor Nixdorf customer display setup

In order to set up the customer display of Wincor Nixdorf Ba63 and Ba64 models (BA64_Operating_Manual_english.pdf) follow these steps: 1. Install spos.exe (activate the option for RS232 device connector during EMDI installation). 2. Edit (with any notepad) the file sposbridge.ini (in EMDI installation folder) to look like the following (copy and paste):

[Display]

hexcommands_line2=$1b$5b$32$3b$30$31$48

hexcommands_line1=$1b$5b$31$3b$30$31$48

oem=0

datafolder=C:\Users\user\AppData\Local\Temp\

epson_mode=0

keyword_change=Change

keyword_total=Value

only_numbers=0

ad5=

ad4=

ad3=

ad2= * EMDI RESTAURANT *

ad1= * SBZ SYSTEMS *

maintext=Next Customer

currencychar=€

totaltitle=Total

charsperline=20

parity=Odd

stopbits=1

databits=8

BaudRate=9600

Port=COM1

Title=Display

3. User […]

Solon Zenetzis Last modified.: 28/11/2018 Uncategorized @en

Delete cache on TablePress plugin for WordPress

TablePress cache saved on database. So in order to delete it you have to execute:

delete FROM `wp_options`

where option_name like '_transient_tablepress_c%'

or option_name like '_transient_timeout_tablepress_c%'

Solon Zenetzis Web development

Easy ISPConfig installation on Ubuntu 18

After a successful ubuntu installation type the following:

apt-get update && apt-get -y upgrade

apt-get install -y unzip

cd /tmp

wget --no-check-certificate -O installer.tgz "https://github.com/servisys/ispconfig_setup/tarball/master"

tar zxvf installer.tgz

cd *ispconfig*

bash install.sh

Source: https://www.howtoforge.com/tutorial/ispconfig-automated-install-script/

Solon Zenetzis Linux general issues

Easy install Issabel PBX on Centos 7

After a successful centos installation type the following:

yum update

yum -y install wget

wget -O - http://repo.issabel.org/issabel4-netinstall.sh | bash

Source: https://forum.issabel.org/d/1145-install-in-a-vps

Solon Zenetzis Last modified.: 02/11/2018 Asterisk (Issabel, FreePBX, Elastix, Trixbox)

Let’s Encrypt certificate installation problem (Issabel PBX)

If you try to install Let’s Encrypt certificate via Issabel web interface and it is failed you can installed from ssh.

1 2	cd \etc letsencrypt certonly --standalone -d sbz-tel.freeextra.com

If you get the message “Problem binding to port 80: Could not bind to IPv4 or IPv6.” try

service httpd stop

cd /etc

letsencrypt certonly --standalone -d yourdomain.com

service httpd start

After the certification creation via ssh, you can renew it easily via web interface.

Solon Zenetzis Asterisk (Issabel, FreePBX, Elastix, Trixbox)

Missed calls Notification on Email (Issabel, FreePBX, Elastix, Asterisk)

This is a simple cronJob to send automatic a custom CDR email every 10 minutes that will include all missed calls of this period. Create a php file named missed_calls.php

<?php

//error_reporting(0);

/*------------------------------------------------------------------------

# @license - http://www.gnu.org/licenses/gpl-2.0.html GNU/GPL

# Websites: https://www.sbzsystems.com

-------------------------------------------------------------------------*/

header("Cache-Control: no-cache, must-revalidate"); // HTTP/1.1

header('Content-Type: text/html; charset=UTF-8');

//error_reporting(0);

$host = 'localhost';

$user = 'root';

$password = 'XXXXXXXX';

$db = 'asteriskcdrdb';

$logfile='/usr/local/issabel/missed_calls.log';

// Connects to your Database

$link=mysqli_connect("$host", $user, $password) or die(mysqli_error($link));

mysqli_select_db($link,"$db") or die(mysqli_error($link));

mysqli_set_charset($link,'utf8');

//GET SQL TIME INTERVAL 10 MINUTE

$query="

select calldate AS Timestamp, src AS CallerID from cdr

where calldate > date_sub(now(), interval 1 MINUTE)

/*and dst=600*/

group by CallerID, Timestamp

$data = mysqli_query($link,$query) or die(mysqli_error($link));

//AND disposition like 'NO ANSWER'

$txt='';

while($alldata = mysqli_fetch_array( $data ))

{

if (strlen($alldata['CallerID'])>5) {

$txt=$txt. $alldata['Timestamp'].' <a href="tel:'.$alldata['CallerID'].'">'.$alldata['CallerID'].'</a> ';

}

mysqli_close($link);

//file_put_contents($logfile, '#'.$txt.'#'.$query.'#'."\n", FILE_APPEND | LOCK_EX);

if ($txt) {

$to = "info@bikemall.gr";

$subject = "Missed calls";

$headers = "MIME-Version: 1.0" . "\r\n";

$headers .= "Content-type:text/html;charset=UTF-8" . "\r\n";

$headers .= "From: info@bikemall.gr" . "\r\n";

mail($to,$subject,$txt,$headers);

}

and store it here

1	/usr/local/issabel

Finally create an every minute cronjob named missed_calls.cron

1	* * * * * root /usr/bin/php -q /usr/local/issabel/missed_calls.php

and store it here

1	/etc/cron.d/

Solon Zenetzis Last modified.: 31/10/2018 Asterisk (Issabel, FreePBX, Elastix, Trixbox)

SBZ systems at Market Expo Trade Show

SBZ Systems has successfully presented its extensive retail solutions as part of its participation at the Market Expo Trade Show, held from 5 to 7 October 2018 at the Metropolitan Expo Conference Center. EMDI Retail POS is ideal for professionals in food, beverage, toy, tobacco, commercial and manufacturing businesses. In Hall 1 – H25 booth of […]

Solon Zenetzis Last modified.: 12/10/2018 News

Import voucher status from excel

Courier companies usually send an excel file with the status of orders which includes delivery date. This date can be imported in EMDI: In Settings give a name for Custom field 1: In Documents list right click and select the custom field for the column to appear: Select the document and click on the menu (at […]

Solon Zenetzis Last modified.: 18/09/2018 Customers / Suppliers, Data Import, Invoices / Payments, Products / Services (Inventory), Settings

Author: sbz