Hi people, I'm trying to retrieve data from the database (server MySQL). I have the following dial plan: exten => s,1,Noop(Start) exten => s,n,MYSQL(Connect connid localhost user pass asteriskcdrdb) exten => s,n,Noop(Connid: ${connid}) ... The problem is that the 3? line is not showing the connid. How can I know the error? Thanks, _________________________________________________________________ Nuevo Windows Live, un mundo lleno de posibilidades. Desc?brelo. http://www.microsoft.com/windows/windowslive/default.aspx -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20090921/ba95fbb9/attachment.htm
Anahi Ludue?a wrote:> ... > > The problem is that the 3? line is not showing the connid. How can I > know the error?Why don't you give us some of the basics. Version of Asterisk Version of your Asterisk addons A sanitized bit of the console output.. Doug -- Ben Franklin quote: "Those who would give up Essential Liberty to purchase a little Temporary Safety, deserve neither Liberty nor Safety."
On Monday 21 September 2009 03:37:03 pm Anahi Ludue?a wrote:> Hi people, I'm trying to retrieve data from the database (server MySQL). > I have the following dial plan: > > exten => s,1,Noop(Start) > exten => s,n,MYSQL(Connect connid localhost user pass asteriskcdrdb) > exten => s,n,Noop(Connid: ${connid}) > ... > > The problem is that the 3? line is not showing the connid. How can I know > the error? Thanks,The typical problem here is in the socket file being in the wrong place. Make sure that the path of the socket file is specified in /etc/my.cnf (or /etc/mysql/my.cnf). The socket should be specified in the "[client]" section. Ensure that the corresponding path exists. If you've enabled TCP connections on the host, you could also change the word 'localhost' to '127.0.0.1', as this will force MySQL to use the TCP layer for connecting, instead of the socket file. There should also be a corresponding WARNING printed to the console (and to the messages log) as to the particular MySQL error. -- Tilghman