I’m referring specifically to the packages for Maria-ODBC. The rest of that wiki is for Stretch, though it is mostly correct for Buster also. Yes, with those packages on Debian 10, I have working odbc / cdr / cel.
Excellent!, Where did you get your mariadb odbc connector (libmaodbc.so) from? 3.1.1 nor 3.1.2 doesn’t work in Debian10 for me, neither on a DO x86 or a PI4. I must be missing something
No tricks, I just used the ones listed there in the wiki.
Install MariaDB ODBC
cd /usr/src/
wget Sangoma Documentation
wget Sangoma Documentation
dpkg -i mariadb-connector-client-library_3.0.8-1_amd64.deb
dpkg -i mariadb-connector-odbc_3.0.7-1_amd64.deb
When installing the second package I had to add --force-overwrite because the first package already populates some common config files.
I will add that to my recipe, thanks!. And that will also work on a PI? Also the UCP?
You’ll need to compile from source for the Raspberry Pi:
# Install MariaDB ODBC Connector
cd /usr/src
git clone https://github.com/MariaDB/mariadb-connector-odbc.git
cd mariadb-connector-odbc
git checkout tags/3.1.1-ga
mkdir build
cd build
cmake ../ -LH -DCMAKE_BUILD_TYPE=Release -DCMAKE_INSTALL_PREFIX=/usr/local -DWITH_SSL=OPENSSL\
-DDM_DIR=/usr/lib/arm-linux-gnueabihf -DCMAKE_C_FLAGS_RELEASE:STRING="-w"
cmake --build . --config Release
make install
# Configure ODBC
cat <<EOF > /etc/odbcinst.ini
[MySQL]
Description = ODBC for MySQL (MariaDB)
Driver = /usr/local/lib/libmaodbc.so
FileUsage = 1
EOF
cat <<EOF > /etc/odbc.ini
[MySQL-asteriskcdrdb]
Description = MySQL connection to 'asteriskcdrdb' database
Driver = MySQL
Server = localhost
Database = asteriskcdrdb
Port = 3306
Socket = /var/run/mysqld/mysqld.sock
Option = 3
EOF
CDR/CEL/UCP all work.
In fact, everything works on both Stretch and Buster, FreePBX 14 and 15, using:
https://www.dslreports.com/forum/r30661088-PBX-FreePBX-for-the-Raspberry-Pi
2 Likes
Excellent, already had the compile from source thing, followed your /etc/odbc*.ini setup, which I had effed up and now my script is slick as a soacs, Thanks so much
fwconsole ma list
No repos specified, using: [standard] from last GUI settings
+---------------------+-----------+---------+---------+
| Module | Version | Status | License |
+---------------------+-----------+---------+---------+
| accountcodepreserve | 13.0.2.2 | Enabled | GPLv2 |
| amd | 15.0.2 | Enabled | GPLv3+ |
| announcement | 15.0.3.6 | Enabled | GPLv3+ |
| api | 15.0.3.2 | Enabled | AGPLv3+ |
| arimanager | 15.0.3.3 | Enabled | GPLv3+ |
| asteriskinfo | 15.0.4.1 | Enabled | GPLv3+ |
| backup | 15.0.8.17 | Enabled | GPLv3+ |
| blacklist | 15.0.2.6 | Enabled | GPLv3+ |
| builtin | | Enabled | |
| bulkhandler | 13.0.14.8 | Enabled | GPLv3+ |
| calendar | 15.0.4.6 | Enabled | GPLv3+ |
| callback | 15.0.5 | Enabled | GPLv3+ |
| callforward | 15.0.8 | Enabled | AGPLv3+ |
| callrecording | 15.0.7.8 | Enabled | AGPLv3+ |
| callwaiting | 15.0.4.1 | Enabled | GPLv3+ |
| campon | 13.0.4.1 | Enabled | GPLv3+ |
| cdr | 15.0.11 | Enabled | GPLv3+ |
| cel | 15.0.11 | Enabled | GPLv3+ |
| certman | 15.0.10 | Enabled | AGPLv3+ |
| cidlookup | 15.0.7 | Enabled | GPLv3+ |
| conferences | 15.0.6.5 | Enabled | GPLv3+ |
| contactmanager | 15.0.8.9 | Enabled | GPLv3+ |
| core | 15.0.9.28 | Enabled | GPLv3+ |
| customappsreg | 15.0.11 | Enabled | GPLv3+ |
| customcontexts | 13.0.3.1 | Enabled | GPLv2+ |
| dashboard | 15.0.1.1 | Enabled | AGPLv3+ |
| daynight | 15.0.7 | Enabled | GPLv3+ |
| dictate | 15.0.4 | Enabled | GPLv3+ |
| directory | 15.0.12 | Enabled | GPLv3+ |
| disa | 15.0.4.6 | Enabled | AGPLv3+ |
| donotdisturb | 15.0.5 | Enabled | GPLv3+ |
| extensionsettings | 13.0.4 | Enabled | GPLv3+ |
| fax | 15.0.13 | Enabled | GPLv3+ |
| featurecodeadmin | 13.0.6.4 | Enabled | GPLv3+ |
| filestore | 15.0.3 | Enabled | AGPLv3 |
| findmefollow | 15.0.13 | Enabled | GPLv3+ |
| framework | 15.0.16 | Enabled | GPLv2+ |
| fw_langpacks | 14.0.1 | Enabled | GPLv3+ |
| hotelwakeup | 15.0.5.1 | Enabled | GPLv2 |
| iaxsettings | 15.0.5 | Enabled | AGPLv3 |
| infoservices | 15.0.2 | Enabled | GPLv2+ |
| irc | 13.0.1 | Enabled | GPLv3+ |
| ivr | 15.0.14 | Enabled | GPLv3+ |
| languages | 15.0.6 | Enabled | GPLv3+ |
| logfiles | 13.0.10.5 | Enabled | GPLv3+ |
| manager | 15.0.5 | Enabled | GPLv2+ |
| miscapps | 15.0.4 | Enabled | GPLv3+ |
| miscdests | 15.0.2.5 | Enabled | GPLv3+ |
| music | 15.0.11 | Enabled | GPLv3+ |
| outroutemsg | 15.0.7 | Enabled | GPLv3+ |
| paging | 15.0.4.10 | Enabled | GPLv3+ |
| parking | 15.0.9 | Enabled | GPLv3+ |
| pbdirectory | 2.11.0.6 | Enabled | GPLv3+ |
| phonebook | 15.0.7 | Enabled | GPLv3+ |
| pinsets | 15.0.1.6 | Enabled | GPLv3+ |
| pm2 | 15.0.3.6 | Enabled | AGPLv3+ |
| presencestate | 15.0.5 | Enabled | GPLv3+ |
| printextensions | 13.0.3.2 | Enabled | GPLv3+ |
| queueprio | 15.0.5 | Enabled | GPLv3+ |
| queues | 15.0.9 | Enabled | GPLv2+ |
| recordings | 15.0.3.4 | Enabled | GPLv3+ |
| ringgroups | 15.0.11 | Enabled | GPLv3+ |
| setcid | 15.0.4 | Enabled | GPLv3+ |
| sipsettings | 15.0.6.7 | Enabled | AGPLv3+ |
| soundlang | 15.0.4.1 | Enabled | GPLv3+ |
| speeddial | 2.11.0.4 | Enabled | GPLv3+ |
| superfecta | 15.0.2.13 | Enabled | GPLv2+ |
| timeconditions | 15.0.12 | Enabled | GPLv3+ |
| ttsengines | 15.0.4.3 | Enabled | AGPLv3 |
| ucp | 15.0.6.3 | Enabled | AGPLv3+ |
| userman | 15.0.8.2 | Enabled | AGPLv3+ |
| vmblast | 15.0.11 | Enabled | GPLv3+ |
| voicemail | 15.0.17.5 | Enabled | GPLv3+ |
| weakpasswords | 13.0.2 | Enabled | GPLv3+ |
| webrtc | 15.0.5 | Enabled | GPLv3+ |
+---------------------+-----------+---------+---------+
root@deb10-latest:~# fwconsole pm2 --list
+--------------+-------+--------+----------+----------------------+-----+---------+
| Process Name | PID | Status | Restarts | Uptime | CPU | Mem |
+--------------+-------+--------+----------+----------------------+-----+---------+
| core-fastagi | 17992 | online | 0 | 9 minutes, 7 seconds | 0% | 35.38MB |
| ucp | 18091 | online | 0 | 9 minutes, 5 seconds | 0% | 49.97MB |
+--------------+-------+--------+----------+----------------------+-----+---------+
root@deb10-latest:~# uname -a
Linux deb10-latest 4.19.0-5-cloud-amd64 #1 SMP Debian 4.19.37-5 (2019-06-19) x86_64 GNU/Linux
fwconsole -V
FW Console - FreePBX Utility 15.0.16
rasterisk -V
Asterisk 16.2.1~dfsg-1
took 8 minutes on a DO droplet, Now to do the same script on a Pi4
One of the reasons I prefer compiling Asterisk instead of using a package is I get the the latest release and don’t have to wait several months for it to be packaged:
rasterisk -V
Asterisk 16.4.1
And I totally agree, but that is easily script-able, but you have to wait several minutes for it to be installed, ( I can wait 8 minutes, 25 minutes kicks my add in 
) and so far this is just a POC (that looks solid) ,
Thus I prefer the “asterisk latest” as a separate process to do that, as a point of note on Buster you get asterisk 16 dot a while ago , but on Stretch it is a very long while ago. I wonder who is the “Debian VoIP Team”
Couple of notes for scripts that “swings both ways”
I think libsrtp?-dev is as yet platform dependent and as yet
icu-config
needs to work on debian for UCP to be installable
I recently started using libsrtp2-dev (on RPi) and the last I checked, nothing complained on either Stretch or Buster. I don’t do any SRTP, however, so I’m assuming it’s working.
ucp v14.0.3.6 and ucp v15.0.6.6 (both EDGE modules) now use pkg-config instead of libicu-dev to determine the underlying OS, allowing UCP to install and run on both Stretch and Buster.
1 Like
Both points noted, thanks! Pi4 is crunching . .
The 35 minutes on an RPi includes updating Raspbian, updating FreePBX modules to EDGE versions (optional, but pretty much required on FreePBX 15), installing additional sounds, installing iptables, exim4, and dnsmasq, and a number customizations. When the script finishes, everything is up to date and ready to go.
35 minutes for you, a little longer for me 
my (replacement) pi4 just died again, no, the PSU is a laboratory grade 5v 20a thing. and the pi was headless and heat sunk.
I started this project 6 years ago on an RPi-1. Today’s 35 minutes on an RPi-4 takes 5.5 hours on an RPi-1.
3 Likes
For the record. 16.4.1 is in the testing repos. I’m on it.
Look again. Since July 11, it’s been the CURRENT v16 release::
http://downloads.asterisk.org/pub/telephony/asterisk/asterisk-16-current.tar.gz
16.5.0 is currently in RC1 status.
Yup, my mistake. I read the repo numbering wrong. It’s 16.4.0 in there right now. I saw 16.4.0-1 as 16.4.1.
Is the script you’ve linked to up-to-date? I’d love to try it on my Pi, but I’m not super Linux-savvy.
Yes, I run it several times a week (last updated 7/16/2019).
You should find the instructions very easy to follow.
Can I ask because I’m a bit lost - what’s the difference/advantage to this method vs downloading the RasPBX image?
For starters, RasPBX hasn’t been updated in over a year, doesn’t support FreePBX 15, won’t run on a Raspberry Pi 4, …
2 Likes