[asterisk-users] realtime queue_log to mySQL backport to 1.4

[Atis Lezdins]

Hi John,


On Mon, Oct 13, 2008 at 9:51 AM, Lee, John (Sydney)
<John.Lee at compuware.com> 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 (except init when restarting asterisk).

Regards,
Atis

>>
>> 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)
>>
>> http://ftp.iq-labs.net/realtime_store_destroy-1.4/
>>
>> This will later allow you to upgrade to 1.6 and having everything
>> working without patching.
>
> I have patched in asterisk 1.4
> . main/logger.c
> . include/asterisk/config.h
> . main/config.c
>
> I have patched in asterisk-addons 1.4
> . res/res_config_mysql.c
>
> I have re-installed asterisk and asterisk-addons.
>
> I created a database called db1 and in there created a table called
> queue_log as per instruction
> http://www.voip-info.org/wiki/view/Asterisk+queue_log+on+MySQL
>
> I changed /etc/asterisk/extconfig.conf to add the following line:
> [settings]
> queue_log => mysql,db1
>
> I changed /etc/asterisk/res_mysql.conf to add the following:
> [general]
> dbhost = localhost
> dbname = db1
> dbuser = user
> dbpass = password
> dbport = 3306
> dbsock = /var/lib/mysql/mysql.sock
>
> 1) However, whenever I perform an agent login, no row is written to
> table queue_log.  I checked /var/log/asterisk/queue_log and a new entry
> is written there.
> 2) I set debug to 10 on the console in asterisk and re-did the test but
> there were no error messages in /var/log/asterisk/messages.
> 3) I set debug on in mysqld and there are no information for inserting
> into table queue_log, except the cdr logging as below.
> Tcp port: 0  Unix socket: (null)
> Time                 Id Command    Argument
> 081013 15:59:36       1 Connect     user at localhost on db1
>                      2 Connect     user at localhost on db1
> 081013 16:00:32       1 Query       INSERT INTO cdr_log ...
> 081013 16:01:42       1 Query       INSERT INTO cdr_log ...
>
> Is there anyone who can help me?
>
>



-- 
Atis Lezdins,
VoIP Project Manager / Developer,
atis at iq-labs.net
Skype: atis.lezdins
Cell Phone: +371 28806004
Cell Phone: +1 800 7300689
Work phone: +1 800 7502835