Interesting. My odbc.ini looked the same as odbc.ini.rpmsave. I have since reverted my VM back to FreePBX 13.
If you figure out a fix, please share!
LOL, merci!
Nicolas
Hi!
I believe it is two different problems… The end result appears to be the same but the cause apparently different…
Hopefully we can figure out what is missing.
Was the file /usr/lib64/asterisk/modules/res_odbc.so actually present on your disk?
Mike, when you retry this and especially if it is on the system that has a Sangoma A200, please let me know.
Once booted my system works but I am experiencing very slow boot and it seems to be directly related to my DAHDI hardware… I am wondering if you have the same problem as well…
As for your system I am sure that if we compare a system where CDR works to your non-working one I am sure we can figure out what is missing.
The first thing I would check if if the file is there, it looks like it is not… That would suggest the asterisk*-odbc package didn’t get installed somehow…
Good luck and have a nice day!
Nick
In my case /usr/lib64/asterisk/modules/res_odbc.so is not present.
odbc.ini matches odbci.ini.rpmsave
But the output from the rpm query gives:
rpm -q -a | grep odbc
php56w-odbc-5.6.31-2.sng7.x86_64
mysql-connector-odbc-5.2.5-6.el7.x86_64
So it looks like I have no odbc…
Bonjour Jacques!
(Hi Jacques!)
Now things are starting to make sense…
Can you do
yum install asterisk13-odbc
(if you are running Asterisk 13)
or
yum install asterisk14-odbc
(if you are running Asterisk 14)
and post the results back?
Do you get any error message, warnings about missing depencies, etc…?
If it installs properly, can you retry reloading the module (it might require a reboot but I don’t think so, at least to try to load it).
Good luck and have a nice day!
Nick
Bonjour!
(while I have a French name… I alas speak no French other than 4 years in high school that was a long time ago. I would love to be able to spend enough time in Montreal to rectify that situation:)
yum install asterisk13-odbc
Loaded plugins: fastestmirror, versionlock
Loading mirror speeds from cached hostfile
Resolving Dependencies
--> Running transaction check
---> Package asterisk13-odbc.x86_64 0:13.17.1-2.sng7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
=================================================================================================================================================================================
Package Arch Version Repository Size
=================================================================================================================================================================================
Installing:
asterisk13-odbc x86_64 13.17.1-2.sng7 sng-pkgs 62 k
Transaction Summary
=================================================================================================================================================================================
Install 1 Package
Total download size: 62 k
Installed size: 208 k
Is this ok [y/d/N]: y
Downloading packages:
asterisk13-odbc-13.17.1-2.sng7.x86_64.rpm | 62 kB 00:00:00
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : asterisk13-odbc-13.17.1-2.sng7.x86_64 1/1
Verifying : asterisk13-odbc-13.17.1-2.sng7.x86_64 1/1
Installed:
asterisk13-odbc.x86_64 0:13.17.1-2.sng7
Complete!
[root@vps1486485000 /]# rpm -q -a | grep odbc
php56w-odbc-5.6.31-2.sng7.x86_64
asterisk13-odbc-13.17.1-2.sng7.x86_64
mysql-connector-odbc-5.2.5-6.el7.x86_64
And checking the CDR report now shows that call detailed reporting is now working.
Merci!
Bonjour Jacques!
(Hi Jacques!)
Both your first and last name is so very much French sounding that I had absolutely no doubt you spoke it…
If you want to be sure you have almost no choice but to speak in French, don’t go to Montréal… 
While there are people who only speak French there (they learned it in school and forgot) it is quite easy to find someone who speaks English…
Yay!!! 
I wonder why it didn’t get installed initially…
I was somewhat expecting to see a conflict or something similar but it got installed without problems…
@waldrondigital, @GameGamer43, installing the appropriate asterisk*-obbc was the fix this time… It somehow never got installed during the upgrade…
De rien!
(You are welcome!)
Have a nice day!
Nicolas
On a upgrade we only yum update so it would seem he did not have odbc installed before hence why a yum update does not pick it up.
Hi Tony!
Unlikely since he would likely have noticed the problem earlier but you are right, it’s one of the possibilities…
@waldrondigital, since you seem to have the same problem could you make a list of all the (asterisk, at least) modules you have before attempting the upgrade again and let us know if you do end up with the same problem @jpaquin had…
I wonder if it is the only package missing or the only one we noticed was missing…
The system I can compare with is itself a result of an in-place upgrade but this is what I have
asterisk13-13.17.1-2.sng7.x86_64
asterisk13-addons-13.17.1-2.sng7.x86_64
asterisk13-addons-bluetooth-13.17.1-2.sng7.x86_64
asterisk13-addons-core-13.17.1-2.sng7.x86_64
asterisk13-addons-mysql-13.17.1-2.sng7.x86_64
asterisk13-addons-ooh323-13.17.1-2.sng7.x86_64
asterisk13-core-13.17.1-2.sng7.x86_64
asterisk13-curl-13.17.1-2.sng7.x86_64
asterisk13-dahdi-13.17.1-2.sng7.x86_64
asterisk13-doc-13.17.1-2.sng7.x86_64
asterisk13-flite-2.2.1.3-3_3118e6a.sng7.x86_64
asterisk13-odbc-13.17.1-2.sng7.x86_64
asterisk13-ogg-13.17.1-2.sng7.x86_64
asterisk13-resample-13.17.1-2.sng7.x86_64
asterisk13-voicemail-13.17.1-2.sng7.x86_64
with Asterisk 13
and
asterisk14-addons-bluetooth.x86_64 0:14.6.1-2.sng7
asterisk14-addons-core.x86_64 0:14.6.1-2.sng7
asterisk14-addons-mysql.x86_64 0:14.6.1-2.sng7
asterisk14-addons-ooh323.x86_64 0:14.6.1-2.sng7
asterisk14-addons.x86_64 0:14.6.1-2.sng7
asterisk14-core.x86_64 0:14.6.1-2.sng7
asterisk14-curl.x86_64 0:14.6.1-2.sng7
asterisk14-dahdi.x86_64 0:14.6.1-2.sng7
asterisk14-doc.x86_64 0:14.6.1-2.sng7
asterisk14-flite.x86_64 0:2.3.1.3-4_c5b9348.sng7
asterisk14-odbc.x86_64 0:14.6.1-2.sng7
asterisk14-ogg.x86_64 0:14.6.1-2.sng7
asterisk14-resample.x86_64 0:14.6.1-2.sng7
asterisk14-voicemail.x86_64 0:14.6.1-2.sng7
asterisk14.x86_64 0:14.6.1-2.sng7
with Asterisk 14.
These are only the modules which have the Asterisk version in them.
@jpaquin, do you have all these packages now?
Have a nice day!
Nick
Bear in mind that there are two methodologies to populate the mysql(like 
) asteriskcdrdb database tables, for many years the now deprecated “cdr-mysql” (as per “make menuselect” while building Asterisk) and the newer cleaner “cdr_adaptive_odbc” (also in make menuselet, but lower down 
) , with some irony, if you have them both working then the asteriskcdrdb cdr table will have duplicates, so if you have migrated an older system , the who knows, if for 10 years he used cdr-mysql. but now mariadb or something “deprecated to termination” then he will have to move singularly to the odbc thingy. Basically , either way needs configuring appropriately the connection to asteriskcdrdb, either by direct mysql or through odbc.
1 Like
Hi dicko!
We are talking of the FreePBX distro though so if it was ever using the older way of accessing the database tables it should have been properly migrated to the current way a while ago…
I am really looking forward to @waldrondigital posting his findings when he attempts upgrading again to see if the package is there to start with and somehow not being properly updated on his box…
Have a nice day!
Nick
Actually @waldrondigital never actually stated that he was using “The Distro”, that is surely just your projection
LOL, in this specific message, you are right…
But…
and
https://issues.freepbx.org/browse/FREEPBX-15489
By the way, you did post in at least one thread where his problems with the distro upgrader were mentioned and he provided input about them so I thought you knew he was having problems with the distro upgrader “script”…
Now it’s not impossible he could have been talking about another system which is not running the FreePBX distro but I have not seen any mention of people having problem with the upgrader module, only about the distro upgrader “script”. I also noticed, from reading past messages of his, that he seems to be normally using the FreePBX distro so it was easy to assume he is talking about a FreePBX distro system…
You are right, I did make a small assumption and I know what happens when you assume…
Have a nice day!
Nick
Then is it just possible that the “Distro” upgrade needs to be fixed so the cdr records still work ?, I don’t personally have that problem, but I also don’t use “The Distro”, everything in cdr land works hunky-dory for me
Yes, that is what the devs are currently doing, fixing all reported problems with the distro upgrader “script”…
There is, at least, two known problems after the distro upgrade…
-
The existing /etc/odbc.ini is renamed to /etc/odbc.ini.rpmsave but nothing is put in its place. I logged that problem in FREEPBX-15491 the 8th of August. I believe the problem was fixed but there’s probably more than one reason this happens because some people still have this problem…
-
The asterisk*-odbc package is needed but not installed… That’s a new one…
To each is own…
Have a nice day,
Nick
For those that don’t use the “The Distro” , you probably won’t have that problem.
JM2CWAE
Actually if they do it will be of their own making because it is something they will have setted up incorrectly…
That being said unless the upgrader module does way more than I think it does when it comes to upgrading to FreePBX 14 only the distro upgrader “script” users will possibly have that problem…
(Not everyone has that problem…)
Have a nice day,
Nick
I see your post as a series of non-sequitors please clarify what you expect the upgrader module to do, and if you use the Distro , then does upgrading it then break the odbc cdr’s ? . Please one thing at a time.