Re: [ASTPP] mysql.sock missing

[Samir Doshi]

You need to change odbc files from /etc/ folder. 

Best Regards
--
Samir Doshi
iNextrix Technologies Pvt. Ltd.
http://www.inextrix.com

Disclaimer:
The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful.

On Tue, Feb 28, 2017 at 3:09 PM, Giri <girish.d...@gmail.com> wrote:

Guys,

[ERR] switch_odbc.c:368 STATE: 08S01 CODE 2002 ERROR: [unixODBC][MySQL][ODBC 5.2(w) Driver]Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)

[CRIT] switch_core_sqldb.c:508 Failure to connect to ODBC ASTPP!

2017-02-28 15:49:34.799336 [ERR] freeswitch_lua.cpp:367 Connection failed.  DBH NOT Connected.

2017-02-28 15:49:34.799336 [DEBUG] switch_cpp.cpp:1360 [ASTPP] Database connection fail...!!!

2017-02-28 15:49:34.819333 [DEBUG] switch_cpp.cpp:1360 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM system WHERE group_title IN ('global','opensips','callingcard')

2017-02-28 15:49:34.819333 [ERR] freeswitch_lua.cpp:460 DBH NOT Connected.

2017-02-28 15:49:34.819333 [ERR] mod_lua.cpp:203 /usr/local/freeswitch/scripts/astpp/lib/astpp.functions.lua:32: assertion failed!

stack traceback:

I am getting the below error by actually mysql is running at /var/lib/mysql/mysql.sock. How can I change astpp configration file to modify the mysql configuraition. Which is the file and location.

Regards,

Giri

--
=====================================================================
Documentation : https://astppdoc.atlassian.net/
Please contact at sa...@inextrix.com for commercial support.
---
You received this message because you are subscribed to the Google Groups "ASTPP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to astpp+unsubscribe@googlegroups.com.
To post to this group, send email to as...@googlegroups.com.
Visit this group at https://groups.google.com/group/astpp.
To view this discussion on the web visit https://groups.google.com/d/msgid/astpp/73981372-bb36-4108-9508-b169e1500b7b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Rahul Mallick]

Please can you guide what do i need to change?? We have this file

/etc/odbc.ini

[ASTPP]

Driver = /usr/lib64/libmyodbc5.so

SERVER = xx.xx.xx.xx

PORT = 3306

DATABASE = abcd

USERNAME = root

PASSWORD = abcd9876

OPTION = 67108864

Socket = /var/run/mysql/mysql.sock

charset = utf8

 /etc/odbcinst.ini

[MySQL]

Description     = ODBC for MySQL

Driver          = /usr/lib64/libmyodbc5.so

Setup           = /usr/lib64/libodbcmyS.so

FileUsage       = 1

To unsubscribe from this group and stop receiving emails from it, send an email to astpp+un...@googlegroups.com.

[Samir Doshi]

Are you able to connect your database using isql ASTPP? 

Sent with Mailtrack

Best Regards
--
Samir Doshi
iNextrix Technologies Pvt. Ltd.
http://www.inextrix.com

Disclaimer:
The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Please notify the sender immediately and destroy all copies of this message and any attachments contained in it.

To unsubscribe from this group and stop receiving emails from it, send an email to astpp+unsubscribe@googlegroups.com.

To post to this group, send email to as...@googlegroups.com.
Visit this group at https://groups.google.com/group/astpp.

To view this discussion on the web visit https://groups.google.com/d/msgid/astpp/d3fce14e-6b3c-4582-b7e8-5fa1d70c1eeb%40googlegroups.com.

[Gilbert Arias]

Just update the socks path, identify what is your current path and update it there

To view this discussion on the web visit https://groups.google.com/d/msgid/astpp/d3fce14e-6b3c-4582-b7e8-5fa1d70c1eeb%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
=====================================================================
Documentation : https://astppdoc.atlassian.net/
Please contact at sa...@inextrix.com for commercial support.
---
You received this message because you are subscribed to the Google Groups "ASTPP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to astpp+un...@googlegroups.com.
To post to this group, send email to as...@googlegroups.com.
Visit this group at https://groups.google.com/group/astpp.

To view this discussion on the web visit https://groups.google.com/d/msgid/astpp/CAFABgc3f2xPGknaqg6Kk7PyTszaPgYSBVxbgnkmRd7%3D9odqZNg%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

--

Gilbert N. Arias Feliz

CEO @ Treblig Web Design & IT Solutions

Unix/Linux Administrator

Windows Server Administrator

VoIP Engineer 

BackTrack Network Security Tester Team

[Unos Sueñan... Otros Hacemos Realidad Nuestros Sueños...]

[ASTPP]

Hi Guys

I am having same issue with recent fresh install of ASTPP on debian 9.5 

did you manage to fix this issue if yes how ??

thanks

Harry