How to add dynamic fields in OTRS

Go to Admin: Dynamic Field loan – Loan Number Frontend::Agent::Ticket::ViewFreeText -> Ticket::Frontend::AgentTicketFreeText###DynamicField -> loan 1 Frontend::Agent::Ticket::ViewZoom -> Ticket::Frontend::AgentTicketZoom###DynamicField -> loan 1 Frontend::Agent::Ticket::ViewSearch -> Ticket::Frontend::AgentTicketSearch###DynamicField -> loan 1 Frontend::Agent::Ticket::ViewSearch -> Ticket::Frontend::AgentTicketSearch###SearchCSVDynamicField -> loan 1 Frontend::Agent::Ticket::ViewSearch -> Ticket::Frontend::AgentTicketSearch###DefaultColumns -> loan 1 Frontend::Agent::Ticket::ViewQueue -> Ticket::Frontend::AgentTicketQueue###DefaultColumns -> DynamicField_loan 1

Your PHP installation appears to be missing the MySQL extension which is required by WordPress

On CENTOS If you are running your WordPress site on a CentOS VPS without any kind of control panel. Your first step would be to check the PHP version that you are running. php -v Will show you the PHP Version you are currently running. In our case, this is PHP 7.0. We need to install the PHP-MySQL extension for PHP 7.0. We can do this using the following command:… Read More »Your PHP installation appears to be missing the MySQL extension which is required by WordPress

Create Conference using AMI – PHP – Web App

  • by

$port = 5038; // Replace with your username. You can find it in /etc/asterisk/manager.conf. // If unsure look for a user with “originate” permissions, or create one as // shown at $username = “sam”; // Replace with your password (refered to as “secret” in /etc/asterisk/manager.conf) $password = “samconf”; // Internal phone line to call from $internalPhoneline = “101”; // Context for outbound calls. See /etc/asterisk/extensions.conf if unsure. $context =… Read More »Create Conference using AMI – PHP – Web App

Asterisk CDR csv conversion mysql

  • by

LOAD DATA INFILE ‘/var/log/asterisk/cdr-csv/Master.csv’ INTO TABLE cdrnew FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘"’ LINES TERMINATED BY ‘\n’ (accountcode, src,dst, dcontext, clid, channel, dstchannel, lastapp, lastdata, calldate, answertime, endtime, duration, billsec, disposition, amaflags, uniqueid,any_comumnname);

CDR Adaptive ODBC Configuration

  • by

[adaptive_connection] connection=asterisk table=cdr alias start => calldate alias cid => cid alias dial_code => dial_code alias region => region alias answer => answertime alias end => endtime

RES_ODBC Configuration

  • by

[asterisk] ; ; Permit disabling sections without needing to comment them out. ; If not specified, it is assumed the section is enabled. enabled => yes ; ; This value should match an entry in /etc/odbc.ini ; (or /usr/local/etc/odbc.ini, on FreeBSD and similar systems). dsn => asterisk-connect ; ; Username for connecting to the database. The user defaults to the context name if unspecified. username => user1 ; ; Password… Read More »RES_ODBC Configuration


  • by

yum update -y yum install wget wget tar -zxvf asterisk-16-current.tar.gz yum install bzip2 rdate unzip make patch gcc gcc-c++ subversion php php-devel php-gd gd-devel php-mbstring php-mcrypt php-imap php-ldap php-mysql php-odbc php-pear php-xml php-xmlrpc curl curl-devel perl-libwww-perl ImageMagick libxml2 libxml2-devel httpd libpcap libpcap-devel libnet ncurses ncurses-devel screen mysql-server mysql-devel ntp kernel* mutt glibc.i686 conntrack-tools telnet glibc-devel openssl-devel zlib-devel libedit.i686 libedit-devel.i686 libedit-devel uuid-dev epel-release dmidecode gcc-c++ ncurses-devel wget openssl-devel newt-devel kernel-devel… Read More »ASTERISK-INSTALLATION-16-8-ON-CENTOS-7

ODBC INI Configuration

  • by

[asterisk-connect] Description = MySQL ODBC Driver = MySQL Socket = /var/lib/mysql/mysql.sock Server = localhost User = root Password = Database = dbname Option = 3