php/mysql setup for mod_xml_curl

I adapted all the following example setup, including database and PHP code, from the book "Costruire centralini telefonici con FreeSWITCH", written by FreeSWITCH Italian champion Christian Bergamaschi. Look it up on Amazon and elsewhere! (in Amazon.IT you can even have it as printed paper book).

For testing, you can install webserver, php, and mysql on the same FreeSWITCH machine. For production you want them to be on a separate hardware on the same gigabit LAN.

In Debian 8 Jessie you do:

apt-get install mysql-server nginx php5-fpm php5-mysql 

You'll be asked for a root password for mysql server, set it to something you remember, you'll need it again.

Create and populate the Database

From the Linux root command line, type:

mysql -A -p 

Then, from the mysql console:

create database freeswitch; 
use freeswitch; 
CREATE TABLE `extensions` ( `userid` varchar(5) NOT NULL DEFAULT '', `password` varchar(30) NOT NULL DEFAULT '', `displayname` varchar(14) NOT NULL DEFAULT...