[ASTPPCOM-107] Issue with odbc.in/mysql.sock resulting in DB connection errors - how to fix Created: 10/Sep/16  Updated: 01/Apr/21  Resolved: 01/Apr/21

Status: Closed
Project: ASTPP Community
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug
Reporter: landman16 Assignee: Unassigned
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

Dear Community,

This bug is present right out of the box (even in v3.0 the latest version), so if your using CentOS 7 you will for sure most possibly have this issue. The symptoms will be you wont hear anything when trying to call using a sip trunk, even though it may seam to have registered. You also may well not be able to call out at all. And if you trail the ASTPP log files by exicuting the following command in SSH/terminal "fs_cli" removing the " of course, you will see fatal database connection errors.

This bug is still present, but thought i would share how to fix it on your own without having to wait for ASTPP to reply that can often take a while.

Locate your odbc.ini file (useually in /etc) if your using CentOS 7

Find the following line of code:

Socket = /var/etc/mysql/mysql.sock (or what ever it says)

And replace it with your mysql.sock path (useually: /var/lib/mysql/mysql.sock)

Then save the file, reboot to make sure the changes take effect, although ive never needed to reboot and then you should be fixed



 Comments   
Comment by dev-astpp [ 04/Nov/16 ]

This issue has been fixed now !

Comment by dev-astpp [ 18/Nov/16 ]

There is not any update for this issue from this user, So now we are closing this issue

Generated at Sat Feb 10 07:14:13 CET 2024 using Jira 8.13.3#813003-sha1:22ebedbb75c99b147c66f14e031dd8a2d214753a.