7 – Eduguru

HeidiSQL : MySQL client

February 24, 2016September 17, 2014 by eduguru

One of the best MySQL client i have used is HeidiSQL. HeidiSQL runs fine on Windows (XP, Vista, 7, 8) and – with Wine – on any Linux and newer MacOS X versions. On Windows 64bit, if you have a 32bit version installed in C:Program Files (x86)…, then the 64bit version is installed separately, and can be … Read more

Asterisk cmd MYSQL

June 6, 2014 by eduguru

This is an ADD-ON of asterisk, is not installed by default and must be downloaded and installed with the asterisk-addons package. However, in Asterisk 1.8 the addons have been integrated back into Asterisk. MYSQL(): Basic MYSQL Database Functionality (note that the help information returned from ‘show application MYSQL’ is a little misleading – what’s shown … Read more

vicidial / extras / MySQL_AST_CREATE_tables.sql

October 10, 2013 by eduguru

CREATE TABLE phones ( extension VARCHAR(100), dialplan_number VARCHAR(20), voicemail_id VARCHAR(10), phone_ip VARCHAR(15), computer_ip VARCHAR(15), server_ip VARCHAR(15), login VARCHAR(15), pass VARCHAR(10), status VARCHAR(10), active ENUM(‘Y’,’N’), phone_type VARCHAR(50), fullname VARCHAR(50), company VARCHAR(10), picture VARCHAR(19), messages INT(4), old_messages INT(4), protocol ENUM(‘SIP’,’Zap’,’IAX2′,’EXTERNAL’) default ‘SIP’, local_gmt VARCHAR(6) default ‘-5.00’, ASTmgrUSERNAME VARCHAR(20) default ‘cron’, ASTmgrSECRET VARCHAR(20) default ‘1234’, login_user VARCHAR(20), login_pass … Read more

astrerisk dialplan configuration file – extensions.conf

June 28, 2013 by eduguru

; extensions.conf – the Asterisk dial plan ; ; Static extension configuration file, used by ; the pbx_config module. This is where you configure all your ; inbound and outbound calls in Asterisk. ; ; This configuration file is reloaded ; – With the “dialplan reload” command in the CLI ; – With the “reload” … Read more