How to install Asterisk app mysql: Difference between revisions
No edit summary |
No edit summary |
||
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
app_mysql is no longer the recommended way of connecting Asterisk to a MySQL database server. The recommended way is via | app_mysql is no longer the recommended way of connecting Asterisk to a MySQL database server. The recommended way is via ODBC (see this [[How to set up an Asterisk ODBC data source on Linux|link]] for instructions on installing and configuring ODBC). Nevertheless many people prefer the simplicity of setting it up, though it does have limitations (such as no SSL support). | ||
<strong>Installing asterisk from source</strong> | <strong>Installing asterisk from source</strong> | ||
| Line 9: | Line 9: | ||
Go to the Add-ons menu and there choose app_mysql, save and Exit. Following this you may proceed with the normal compilation steps (make, make install). | Go to the Add-ons menu and there choose app_mysql, save and Exit. Following this you may proceed with the normal compilation steps (make, make install). | ||
<strong>Using the FreePBX distribution</strong> | <strong>Using the FreePBX distribution or the Asterisk Now distribution</strong> | ||
When using the FreePBX distribution there is nothing to do since app_mysql is already installed. You can check it at the asterisk CLI (asterisk -r) with the following command: | When using the FreePBX distribution there is nothing to do since app_mysql is already installed. You can check it at the asterisk CLI (asterisk -r) with the following command: | ||
| Line 18: | Line 18: | ||
<pre>MYSQL: Do several mySQLy things</pre> | <pre>MYSQL: Do several mySQLy things</pre> | ||
Latest revision as of 09:19, 12 June 2016
app_mysql is no longer the recommended way of connecting Asterisk to a MySQL database server. The recommended way is via ODBC (see this link for instructions on installing and configuring ODBC). Nevertheless many people prefer the simplicity of setting it up, though it does have limitations (such as no SSL support).
Installing asterisk from source
By default app_mysql will not be installed when compiling Asterisk from source code from version 1.8 and later. To include app_mysql in the compilation do the following after having run configure and before running make.
make menuselect
Go to the Add-ons menu and there choose app_mysql, save and Exit. Following this you may proceed with the normal compilation steps (make, make install).
Using the FreePBX distribution or the Asterisk Now distribution
When using the FreePBX distribution there is nothing to do since app_mysql is already installed. You can check it at the asterisk CLI (asterisk -r) with the following command:
core show applications
The output should contain something like this:
MYSQL: Do several mySQLy things