SOLVED Upgrade RasPi to Incredible PBX 2021

[dallas]

After applying the new voicemail patch Incredible 2021 statistics in the dashboard has old network stats and no asterisk stats since applying the patch. Date and time on the system is correct.

Edit... After a couple of hours it's all good!
Edit2. Added a trunk and it's gone again.

 

[wardmundy]

Check these 4 files then: systemctl restart mysqld && fwconsole restart

#cat  /etc/odbc.ini

[MySQL-asteridex]
Description     = asteridex MySQL ODBC
Driver          = MySQL
Socket          = /var/lib/mysql/mysql.sock
Server          = localhost
User            = root
Password        = passw0rd
Port            = 3306
Database        = asteridex
Option          = 3

[MySQL-asterisk]
Description     = asterisk MySQL ODBC
Driver          = MySQL
Socket          = /var/lib/mysql/mysql.sock
Server          = localhost
User            = root
Password        = passw0rd
Port            = 3306
Database        = asterisk
Option          = 3

[MySQL-asteriskcdrdb]
Description     = asteriskcdrdb MySQL ODBC
Driver          = MySQL
Socket          = /var/lib/mysql/mysql.sock
Server          = localhost
User            = root
Password        = passw0rd
Port            = 3306
Database        = asteriskcdrdb
Option          = 3

[MySQL-avantfax]
Description     = avantfax MySQL ODBC
Driver          = MySQL
Socket          = /var/lib/mysql/mysql.sock
Server          = localhost
User            = root
Password        = passw0rd
Port            = 3306
Database        = avantfax
Option          = 3

[MySQL-information_schema]
Description     = information_schema MySQL ODBC
Driver          = MySQL
Socket          = /var/lib/mysql/mysql.sock
Server          = localhost
User            = root
Password        = passw0rd
Port            = 3306
Database        = information_schema
Option          = 3

[MySQL-mysql]
Description     = mysql MySQL ODBC
Driver          = MySQL
Socket          = /var/lib/mysql/mysql.sock
Server          = localhost
User            = root
Password        = passw0rd
Port            = 3306
Database        = mysql
Option          = 3

[MySQL-performance_schema]
Description     = performance_schema MySQL ODBC
Driver          = MySQL
Socket          = /var/lib/mysql/mysql.sock
Server          = localhost
User            = root
Password        = passw0rd
Port            = 3306
Database        = performance_schema
Option          = 3

[MySQL-timeclock]
Description     = timeclock MySQL ODBC
Driver          = MySQL
Socket          = /var/lib/mysql/mysql.sock
Server          = localhost
User            = root
Password        = passw0rd
Port            = 3306
Database        = timeclock
Option          = 3

[MySQL-voicemail]
Description     = asterisk ODBC voicemail
Driver          = MySQL
Socket          = /var/lib/mysql/mysql.sock
Server          = localhost
User            = root
Password        = passw0rd
Port            = 3306
Database        = asterisk
Option          = 1

#=================
#cat  /etc/odbcinst.ini

[MySQL]
Description = ODBC for MySQL
Driver = /usr/local/lib/libmaodbc.so
Setup = /usr/lib/arm-linux-gnueabihf/odbc/libodbcmyS.so
FileUsage = 1

#==========================
#cat /etc/asterisk/res_odbc_custom.conf

[MySQL-asteridex]
enabled => yes
dsn => MySQL-asteridex
username => root
password => passw0rd
preconnect => yes

[MySQL-asterisk]
enabled => yes
dsn => MySQL-asterisk
username => root
password => passw0rd
preconnect => yes

[MySQL-asteriskcdrdb]
enabled => yes
dsn => MySQL-asteriskcdrdb
username => root
password => passw0rd
preconnect => yes

[MySQL-avantfax]
enabled => yes
dsn => MySQL-avantfax
username => root
password => passw0rd
preconnect => yes

[MySQL-information_schema]
enabled => yes
dsn => MySQL-information_schema
username => root
password => passw0rd
preconnect => yes

[MySQL-mysql]
enabled => yes
dsn => MySQL-mysql
username => root
password => passw0rd
preconnect => yes

[MySQL-performance_schema]
enabled => yes
dsn => MySQL-performance_schema
username => root
password => passw0rd
preconnect => yes

[MySQL-timeclock]
enabled => yes
dsn => MySQL-timeclock
username => root
password => passw0rd
preconnect => yes

[MySQL-voicemail]
enabled => yes
dsn => MySQL-voicemail
username => root
password => passw0rd
preconnect => yes

============================================
#cat /etc/asterisk/cdr_mysql.conf

[global]
hostname = localhost
dbname=asteriskcdrdb
password = passw0rd
user = root
userfield=1
;port=3306
;sock=/var/lib/mysql/mysql.sock

 

[wardmundy]

NOTE: If you're using the latest incrediblepbxfax2020.3 image from SourceForge for Incredible PBX 2020 for Raspbian and then upgraded to Incredible PBX 2021 with the script published on Nerd Vittles, we are not seeing a problem with the CDR and CEL entries. None of the above file changes should be necessary.

 

[dallas]

Well it started life as incrediblepbxfax2020.3 but I had updated both Asterisk and the GUI before running the upgrade script.
I went back to my image of Asterisk 16.17.0 and Incredible GUI 15.0.12.68, ran the update utility, and downloaded and ran the upgrade script and now all is ok.
Thanks for you assistance.

 

[wardmundy]

This is why it's important to get the "whole story" documented when describing a problem you're having. Manually updating Asterisk probably led to these issues depending upon the choices made during that process.

 

[dallas]

@wardmundy I should have explained that all of those updates were made inside the IncrediblePBX ecosystem.
Asterisk was update using your script update-asterisk16 and the incredible GUI using the fwconsole ma update all.

 

[dallas]

When did you do the upgrade? I did mine on 29 June and it went to Asterisk 18.5.0.
The upgrade script downloads http://downloads.asterisk.org/pub/telephony/asterisk/asterisk-18-current.tar.gz
Maybe the mirror you connected to was out of date.

 

[dallas]

Make a backup and run it again.
I meant back up you SD card...

 

[ostridge]

About backup SD card: I have 2020 running Ast on rpi3 from ssd for / and /boot/

RTFM then

My guess is I need to do incrediblebackup, and move that to PC
then clone the ssd back to microSD card.
Then dd the sd card to file, move that to PC

Then run from SD to follow @wardmundy upgrade method?

Is that a plan?

 

[wardmundy]

@ostridge: You might try building a clean 2020 RasPi and upgrade it to 2021. Then load the Bulk Handler module on both of your machines and push the extensions, trunks, etc to the new 2021 machine that way. It may get everything you need.