Support | Downloads Archives - Page 2 of 12

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><br>';

}

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)

Restarting Firebird

If Firebird stopped (and emdi displaying a message that says it was terminated because one of the following database-related problems arose), we can go from the Windows control panel and restart by pressing the Start button. If we can’t start Firebird Server Manager on the control panel, another way is to go to the Windows […]

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

Import / export excel, text, csv from settings.

At EMDI in addition to the ability to import data from sales, customers,inventory we can also import data through the settings. First we open the settings and we choose the field which we want to import or export data. In the example above I use the sub-category items field to import some categories in this […]

Sakis Kozikopoulos Last modified.: 29/08/2018 Data Import

Importing data from a file into pricing.

EMDI offers the ability to import text, csv or excel products into pricing. The file that can be imported into EMDI must be in Microsoft Excel 97-2003 format (.xls) or plain text delimited by a character (.csv). It must be a Microsoft Excel worksheet or export to Excel or csv. The steps to import into [...]

Sakis Kozikopoulos Last modified.: 29/08/2018 Data Import

Change unwanted language – keyboard layout (windows 10)

Set your preferred input language. Open Powershell with administrator rights. Run this command to get a list of installed languages:

1	Get-WinUserLanguageList

If your preferred language is US English, run this command and hit Enter:

1	$1 = New-WinUserLanguageList en-US

Finally run this command to set the order of installed input languages:

1	Set-WinUserLanguageList $1

The issue should be fixed.

Solon Zenetzis Last modified.: 31/07/2018 Windows general issues

Import an SQL file using the command line in MySQL – Centos linux

Use the following:

1	mysql -u database_username -p database_name < database_file.sql

If your database has errors and you want to import it anyway, use the –force (-f) flag. Rather than stopping on the offending statement, MySQL will continue and just log the errors to the console: