Re: [asterisk-users] queue_log/cel sqlite

2016-10-21 Thread Matt Fredrickson 
On Thu, Oct 20, 2016 at 9:45 AM, marek cervenka  wrote:
>
> Dne 20/10/2016 v 16:32 Matt Fredrickson napsal(a):
>>
>> On Thu, Oct 20, 2016 at 4:50 AM, marek cervenka 
>> wrote:
>>>
>>> i tested this
>>>
>>> # cat /etc/asterisk/extconfig.conf
>>> [settings]
>>> queue_log => sqlite3,cdrDb
>>>
>>> # cat /etc/asterisk/res_config_sqlite3.conf
>>> [cdrDb]
>>> dbfile = /var/lib/asterisk/realtime.sqlite3
>>>
>>> sqlite3 /var/lib/asterisk/realtime.sqlite3
>>>
>>> CREATE TABLE "queue_log" ("time" TEXT, "data1" TEXT, "data2" TEXT,
>>> "data3"
>>> TEXT, "data4" TEXT, "data5" TEXT, "event" TEXT, "agent" TEXT, "queuename"
>>> TEXT, "callid" TEXT);
>>>
>>> and it works
>>>
>>> sqlite> select * from queue_log;
>>> 2016-10-20 11:40:36.628804||QUEUESTART|NONE|NONE|NONE
>>> 2016-10-20 11:40:36.690313||CONFIGRELOAD|NONE|NONE|NONE
>>>
>>> column types needs modification to something more appropriate
>>>
>>> can someone with confluence access ad info to
>>>
>>>
>>> https://wiki.asterisk.org/wiki/display/AST/Realtime+Database+Configuration ?
>>
>> Which info are you referring to?  The table schema?
>>
>
> ideally add "correct" sql schema for sqlite to asterisk repo and link it to
>
> https://wiki.asterisk.org/wiki/display/AST/Realtime+Database+Configuration
>
>
> it was hard for me to find if queue_log can be logged with sqlite. imho it
> will be usefull document the example configuration for others
> but i'm not sure where is the best place
> maybe https://wiki.asterisk.org/wiki/display/AST/Queue+Logs ?

My suggestion would be to add a comment to the page with your proposed
changes.  That would be the best place to start, for the next time
someone works on that page.

-- 
Matthew Fredrickson
Digium, Inc. | Engineering Manager
445 Jan Davis Drive NW - Huntsville, AL 35806 - USA

-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

Join the Asterisk Community at the 13th AstriCon, September 27-29, 2016
  http://www.asterisk.org/community/astricon-user-conference

New to Asterisk? Start here:
  https://wiki.asterisk.org/wiki/display/AST/Getting+Started

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] queue_log/cel sqlite

2016-10-20 Thread marek cervenka 


Dne 20/10/2016 v 16:32 Matt Fredrickson napsal(a):

On Thu, Oct 20, 2016 at 4:50 AM, marek cervenka  wrote:

i tested this

# cat /etc/asterisk/extconfig.conf
[settings]
queue_log => sqlite3,cdrDb

# cat /etc/asterisk/res_config_sqlite3.conf
[cdrDb]
dbfile = /var/lib/asterisk/realtime.sqlite3

sqlite3 /var/lib/asterisk/realtime.sqlite3

CREATE TABLE "queue_log" ("time" TEXT, "data1" TEXT, "data2" TEXT, "data3"
TEXT, "data4" TEXT, "data5" TEXT, "event" TEXT, "agent" TEXT, "queuename"
TEXT, "callid" TEXT);

and it works

sqlite> select * from queue_log;
2016-10-20 11:40:36.628804||QUEUESTART|NONE|NONE|NONE
2016-10-20 11:40:36.690313||CONFIGRELOAD|NONE|NONE|NONE

column types needs modification to something more appropriate

can someone with confluence access ad info to

https://wiki.asterisk.org/wiki/display/AST/Realtime+Database+Configuration ?

Which info are you referring to?  The table schema?



ideally add "correct" sql schema for sqlite to asterisk repo and link it to

https://wiki.asterisk.org/wiki/display/AST/Realtime+Database+Configuration


it was hard for me to find if queue_log can be logged with sqlite. imho 
it will be usefull document the example configuration for others

but i'm not sure where is the best place
maybe https://wiki.asterisk.org/wiki/display/AST/Queue+Logs ?

--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

Join the Asterisk Community at the 13th AstriCon, September 27-29, 2016
 http://www.asterisk.org/community/astricon-user-conference

New to Asterisk? Start here:
 https://wiki.asterisk.org/wiki/display/AST/Getting+Started

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] queue_log/cel sqlite

2016-10-20 Thread Matt Fredrickson 
On Thu, Oct 20, 2016 at 4:50 AM, marek cervenka  wrote:
> i tested this
>
> # cat /etc/asterisk/extconfig.conf
> [settings]
> queue_log => sqlite3,cdrDb
>
> # cat /etc/asterisk/res_config_sqlite3.conf
> [cdrDb]
> dbfile = /var/lib/asterisk/realtime.sqlite3
>
> sqlite3 /var/lib/asterisk/realtime.sqlite3
>
> CREATE TABLE "queue_log" ("time" TEXT, "data1" TEXT, "data2" TEXT, "data3"
> TEXT, "data4" TEXT, "data5" TEXT, "event" TEXT, "agent" TEXT, "queuename"
> TEXT, "callid" TEXT);
>
> and it works
>
> sqlite> select * from queue_log;
> 2016-10-20 11:40:36.628804||QUEUESTART|NONE|NONE|NONE
> 2016-10-20 11:40:36.690313||CONFIGRELOAD|NONE|NONE|NONE
>
> column types needs modification to something more appropriate
>
> can someone with confluence access ad info to
>
> https://wiki.asterisk.org/wiki/display/AST/Realtime+Database+Configuration ?

Which info are you referring to?  The table schema?

Matthew Fredrickson


>
>
> is there somebody using it in production?
> thanks
>
> Dne 20/10/2016 v 10:16 marek cervenka napsal(a):
>
>> hi,
>>
>> is it possible log cel/queue_log to sqlite?
>>
>> via odbc?
>>
>> any experience?
>>
>> marek
>>
>>
>>
>
>
> --
> _
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
> Join the Asterisk Community at the 13th AstriCon, September 27-29, 2016
>  http://www.asterisk.org/community/astricon-user-conference
>
> New to Asterisk? Start here:
>  https://wiki.asterisk.org/wiki/display/AST/Getting+Started
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users



-- 
Matthew Fredrickson
Digium, Inc. | Engineering Manager
445 Jan Davis Drive NW - Huntsville, AL 35806 - USA

-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

Join the Asterisk Community at the 13th AstriCon, September 27-29, 2016
  http://www.asterisk.org/community/astricon-user-conference

New to Asterisk? Start here:
  https://wiki.asterisk.org/wiki/display/AST/Getting+Started

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] queue_log/cel sqlite

2016-10-20 Thread marek cervenka 

i tested this

# cat /etc/asterisk/extconfig.conf
[settings]
queue_log => sqlite3,cdrDb

# cat /etc/asterisk/res_config_sqlite3.conf
[cdrDb]
dbfile = /var/lib/asterisk/realtime.sqlite3

sqlite3 /var/lib/asterisk/realtime.sqlite3

CREATE TABLE "queue_log" ("time" TEXT, "data1" TEXT, "data2" TEXT, 
"data3" TEXT, "data4" TEXT, "data5" TEXT, "event" TEXT, "agent" TEXT, 
"queuename" TEXT, "callid" TEXT);


and it works

sqlite> select * from queue_log;
2016-10-20 11:40:36.628804||QUEUESTART|NONE|NONE|NONE
2016-10-20 11:40:36.690313||CONFIGRELOAD|NONE|NONE|NONE

column types needs modification to something more appropriate

can someone with confluence access ad info to

https://wiki.asterisk.org/wiki/display/AST/Realtime+Database+Configuration ?


is there somebody using it in production?
thanks

Dne 20/10/2016 v 10:16 marek cervenka napsal(a):

hi,

is it possible log cel/queue_log to sqlite?

via odbc?

any experience?

marek






--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

Join the Asterisk Community at the 13th AstriCon, September 27-29, 2016
 http://www.asterisk.org/community/astricon-user-conference

New to Asterisk? Start here:
 https://wiki.asterisk.org/wiki/display/AST/Getting+Started

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users

[asterisk-users] queue_log/cel sqlite

2016-10-20 Thread marek cervenka 

hi,

is it possible log cel/queue_log to sqlite?

via odbc?

any experience?

marek




--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

Join the Asterisk Community at the 13th AstriCon, September 27-29, 2016
 http://www.asterisk.org/community/astricon-user-conference

New to Asterisk? Start here:
 https://wiki.asterisk.org/wiki/display/AST/Getting+Started

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users