On Friday 17 October 2008 01:09:18 Lee, John (Sydney) wrote:
> So, at this stage, my res_config_mysql.c is still not writing anything
> into table queue_log despite having: a) correct res_mysql.conf b)
> extconfig.conf c) mysql up and running d) res_config_mysql.c start up
> okay
>
> I believe that
> I did not know what I did but I bumped into something in the log that
says:
> [Oct 16 ...] ERROR[24536] res_config_mysql.c: MySQL RealTime: Ping
failed
> (2006). Trying an explicit reconnect.
> [Oct 16 ...] DEBUG[24536] res_config_mysql.c: MySQL RealTime: Server
Error
> (2006): MySQL server has
> Also i would suggest enabling full log, as it's one place you can see
> everything. Then use grep to search for realtime messages. Your
> logger.conf should already have commented line:
>
> full => notice,warning,error,debug,verbose
>
Yes, I did that.
> # tail -fn0 /var/log/asterisk/full | grep
Hi John,
this is getting quite strange, and i'm becoming quite curios why it's
not working :)
Could you try first setting up realtime for SIP or queues? This should
work out-of-the-box on 1.4.
http://www.voip-info.org/wiki/view/Asterisk+RealTime+Sip
http://www.voip-info.org/wiki/view/Asterisk+Re
Hi Atis,
> queue_log => mysql,asteriskcdrdb,queue_log
> that is ,,
> If it's wrong, you should see some warnings when asterisk is starting
up.
>
Thanks for the suggestion. I did not put in queue_log for and
it has just taken the default which is queue_log.
In the console startup, you can see be
> You might want to double check the socket path. Some distributions
use
> /var/run/mysqld/mysqld.sock as the socket file.
Thanks for the suggestion Tilghman.
I am using Redhat and the socket file is indeed
/var/run/mysql/mysqld.sock.
Actually, if you specify the wrong socket file, you will see
On Monday 13 October 2008 18:57:41 Lee, John (Sydney) wrote:
> By the way, did you see anything wrong with my config files?
>
> /etc/asterisk/res_mysql.conf
> [general]
> dbhost = localhost
> dbname = db1
> dbuser = user
> dbpass = password
> dbport = 3306
> dbsock = /var/lib/mysql/mysql.sock
You
hannels);
> + va_start(ap, fmt);
> + fprintf(qlog, "%ld|%s|%s|%s|%s|",
> (long)time(NULL), callid, queuename, agent, event);
> [...]
> + }
>}
>
>> -Original Message-
>> From: Atis
:[EMAIL PROTECTED]
> Sent: Monday, 13 October 2008 8:02 PM
> To: Lee, John (Sydney)
> Cc: Asterisk Users Mailing List - Non-Commercial Discussion
> Subject: Re: [asterisk-users] realtime queue_log to mySQL backport to
1.4
>
> Hi John,
>
>
> On Mon, Oct 13, 2008 at 9:51 AM, Le
2008 8:02 PM
> To: Lee, John (Sydney)
> Cc: Asterisk Users Mailing List - Non-Commercial Discussion
> Subject: Re: [asterisk-users] realtime queue_log to mySQL backport to
1.4
>
> Hi John,
>
>
> On Mon, Oct 13, 2008 at 9:51 AM, Lee, John (Sydney)
> <[EMAIL PROT
Hi John,
On Mon, Oct 13, 2008 at 9:51 AM, Lee, John (Sydney)
<[EMAIL PROTECTED]> wrote:
>> http://ftp.iq-labs.net/queue_log-
>> 1.4/asterisk_queue_log_realtime_1.4.19.patch
Haven't you forgotten this one? ;)
if you have applied everything correctly - queue_log file shoudln't
have any more lines
> http://ftp.iq-labs.net/queue_log-
> 1.4/asterisk_queue_log_realtime_1.4.19.patch
>
> This uses standardized realtime/mysql library from asterisk addons.
> For it to support SQL inserts in 1.4, you would also need to apply
> both patches from (1 for asterisk, another for asterisk-addons)
>
> htt
12 matches
Mail list logo