Wednesday, March 29, 2017

Install Elastix from USB Step by Step

Install Elastix from USB Step by Step

Elastix is one of the best Open Source Unified Communications Servers available today, it is very easy to install but the installer is designed to be run from CDROM and we can make the installation in several devices that don´t have an optical drive.  This document will guide you to modify the installer so you can install entirely from an USB Flash drive.

Warning:
The Server Security is a very important and serious aspect in a VoIP server, this guide will not cover that but there is plenty of information on that topic in the Internet. If you are looking for a professional installation contact me and I'll be glad to help you for a
very reasonable price.

Wednesday, March 22, 2017

JQuery autocomplete tutorial with PHP and MySQL

My goal was to make an autocomplete on a site that passed also another value as the selected to the new page.

I have a MySQL database with a table called Customer with several fields but the important ones are :

For the HTML I used a simple inputfield (which can be in a form) :

Using jQuery autocomplete one combines the autocomplete to the inputfield so at the page is a piece of Javascript.
For this I inserted the jQuery scripts that you can find here.

Friday, January 27, 2017

GeneralSQL: TempDB running out of space

GeneralSQL: TempDB running out of space: First of all need to check, if any stored procedure (or nested) are running in Transaction. If transaction is very long means there are lot...

SmartTutorials - php mysql jquery javascript ajax html5 css3 CAKEPHP tutorial: Export MySQL SELECT Query into CSV File

SmartTutorials - php mysql jquery javascript ajax html5 css3 CAKEPHP tutorial: Export MySQL SELECT Query into CSV File: Sometimes we need to export MySQL SELECT query results into CSV format for testing or some other purpose. Here we are going to see how to o...

Monty says: In search of a BSD/LGPL/Apache licensed client lib...

Monty says: In search of a BSD/LGPL/Apache licensed client lib...: We have received many requests for a client library for MariaDB (and MySQL) under a license other than the GPL, and decided that it's no...

mySQL DBA, Architecture, Dev, Scale, HA, Code : Building a realtime Feed with RabbitMQ Node.js AMQ...

mySQL DBA, Architecture, Dev, Scale, HA, Code : Building a realtime Feed with RabbitMQ Node.js AMQ...: Being a backend programmer, I rarely code in JavaScript. Today I code a lot of cross browser JavaScript with the fantastic lib jquery and it...

mySQL DBA, Architecture, Dev, Scale, HA, Code : Federating THE friends table in a Sharded mySQL en...

mySQL DBA, Architecture, Dev, Scale, HA, Code : Federating THE friends table in a Sharded mySQL en...: A friends table is the cornerstone of social applications. Its purpose is to define relationships and help answer the question what are my ...