[asterisk-bugs] [JIRA] (ASTERISK-25813) res_config_mysql dbsock parameter

[Joshua Colp (JIRA)]

     [ https://issues.asterisk.org/jira/browse/ASTERISK-25813?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Joshua Colp updated ASTERISK-25813:
-----------------------------------

    Component/s:     (was: Addons/res_config_mysql)
                 Addons/app_mysql

> res_config_mysql dbsock parameter 
> ----------------------------------
>
>                 Key: ASTERISK-25813
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-25813
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Addons/app_mysql
>    Affects Versions: 13.1.0
>            Reporter: Mc GRATH Ricardo
>
> I'm struggle with  mysql application, specifically dbsock parameter, it WARNING message connection; Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'.
> weird issue Asterisk  invokes a  socket path connection no relationship to any logic configuration, strange whatever make parameters changes such as; dbname, dbuser, dbpass, on res_config_mysql.conf it seems it works, even if detect no database  found, Asterisk will use the default values.
> But not happens with dbsock parameter, whatever set onto res_config_mysql.conf no meaning Asterisk it doesn't assume any condition and always use the path; '/var/lib/mysql/mysql.sock'.
> The most strange point I couldn't  found any configuration file to change these default value.
> Asterisk 13.1.0 built by root @ Asterisk-SoyoM on a i686 running Linux on 2015-01-16 20:52:42 UTC
> res_config_mysql.conf
> {noformat}
> [general]
> dbhost = localhost
> dbname = asterisk
> dbuser = myuser
> dbpass = mypass
> dbport = 3306
> dbsock = =/var/run/mysqld/mysqld.sock
> dbcharset = latin1
> requirements=warn ; or createclose or createchar
> {noformat}
> extensions.conf
> {noformat}
> [bases]
> exten => s,1,MYSQL(Connect connid localhost asterisk mypass credit utf8)
> exten => s,2,MYSQL(Query resultid ${connid} SELECT username,credit FROM credit WHERE callerid=${CALLERIDNUM})
> exten => s,3,MYSQL(Fetch fetchid ${resultid} datavar1 datavar2)
> exten => s,4,GotoIf(${fetchid}?5:7)
> exten => s,5,Festival("User ${datavar1} currently has credit balance of ${datavar2} dollars.")
> exten => s,6,Goto(s,3)
> exten => s,7,MYSQL(Clear ${resultid})
> exten => s,8,MYSQL(Disconnect ${connid})
> {noformat}
> etc/my.conf
> {noformat}
> [mysqld]
> datadir=/var/lib/mysql
> bind-address =localhost
> socket=/var/run/mysql/mysql.sock
> skip-networking
> user=mysql
> # Disabling symbolic-links is recommended to prevent assorted security risks
> symbolic-links=0
> [mysqld_safe]
> log-error=/var/log/mysqld.log
> pid-file=/var/run/mysqld/mysqld.pid
> [client]
> host=localhost
> socket=/var/run/mysql/mysql.sock
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.2#6252)