dicko
(dicko)
July 18, 2019, 1:47am
20
And the “adaptive odbc cdr/cel” /libicu (UCP) also ?
what does “fwconsole pm2 --list” issue?
Are the the cdr/cel tables being populated?
But to answer, Yes, on Stretch it all works with php5.6 or php7.0, On Debian 10 (either amd64 or arm) not so much. None will be happy with php7.+ not even Stretch
Wasn’t this whole thing started of with attempting FreePBX 15 on Buster on a Pi4 (or any cpu for that matter) ?
This is where I will wait for mariadb to catch up. . .
billsimon
(Bill Simon)
July 18, 2019, 1:53am
21
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.
dicko
(dicko)
July 18, 2019, 2:04am
22
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
billsimon
(Bill Simon)
July 18, 2019, 2:07am
23
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.
dicko
(dicko)
July 18, 2019, 2:09am
24
I will add that to my recipe, thanks!. And that will also work on a PI? Also the UCP?
reraikes
(RonR)
July 18, 2019, 2:30am
25
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
dicko
(dicko)
July 18, 2019, 3:20am
26
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
reraikes
(RonR)
July 18, 2019, 3:45am
27
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
dicko
(dicko)
July 18, 2019, 3:57am
28
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
reraikes
(RonR)
July 18, 2019, 4:17am
29
dicko:
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
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
dicko
(dicko)
July 18, 2019, 4:21am
30
Both points noted, thanks! Pi4 is crunching . .
reraikes
(RonR)
July 18, 2019, 4:28am
31
dicko:
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) ,
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.
dicko
(dicko)
July 18, 2019, 4:36am
32
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.
reraikes
(RonR)
July 18, 2019, 4:46am
33
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.
reraikes
(RonR)
July 18, 2019, 5:13pm
35
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.
comtech
(Com Tech)
July 19, 2019, 1:26pm
37
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.
reraikes
(RonR)
July 19, 2019, 5:42pm
38
Yes, I run it several times a week (last updated 7/16/2019).
You should find the instructions very easy to follow.
dan_ce
(D E)
July 20, 2019, 6:39pm
39
Can I ask because I’m a bit lost - what’s the difference/advantage to this method vs downloading the RasPBX image?