by vicinewbie » Mon Jul 10, 2006 4:49 am
I found an error in mysql so now the table arnt empty..
# [fedora] Query Window
# Connection: fedora
# Host: localhost
# Saved: 2006-07-10 11:52:02
#
# Query:
# SELECT *
# FROM `live_channels`
#
'channel','server_ip','channel_group','extension','channel_data'
'Zap/pseudo-2010191840','192.168.0.31','[NULL]','ring','SIP/ring'
'Zap/17-1','192.168.0.31','[NULL]','Local/8600051@default','Local/8600051@default-58de,1'
# [fedora] Query Window
# Connection: fedora
# Host: localhost
# Saved: 2006-07-10 11:52:24
#
# Query:
# SELECT *
# FROM `live_sip_channels`
#
'channel','server_ip','channel_group','extension','channel_data'
'Local/8600051@default-58de,2','192.168.0.31','[NULL]','8600051','8600051'
'SIP/1002-69b3','192.168.0.31','[NULL]','8600051','8600051'
'Local/8600051@default-58de,1','192.168.0.31','[NULL]','Zap/g2/17275551213','Zap/g2/17275551213||tTo'
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
This is the o/p for the command /home/cron/AST_update.pl --debugX
channel: |SIP/1003-d40d|
extension: |8600051|
QRYchannel:|SIP/1003-d40d__8600051|
current sips: 2
DB 0|| |DB 1|| |DB 2|| |COUNT: 7|6|5769977
loop counter: |5769976|
|SELECT channel,extension FROM live_channels where server_ip = '192.168.0.31'|
zap/17-1|Local/8600051@default
Zap/pseudo-530729128|ring
SIP/1003-d40d|8600051
Local/8600051@default-201b,2|8600051
Local/8600051@default-201b,1|zap/17/17275551213
|UPDATE server_updater set last_update='2006-07-10 15:18:37' where server_ip='192.168.0.31'|
0|Response: Follows
1|Privilege: Command
2|zap/17-1:from-internal:s:1:Up:Bridged Call:Local/8600051@default-201b,1:::3::Local/8600051@default-201b,1
3|Local/8600051@default-201b,2:default:8600051:2:Up:MeetMe:8600051:::3:7:(None)
4|Local/8600051@default-201b,1:default:917275551213:2:Up:Dial:zap/17/17275551213||tTo:::3:7:zap/17-1
5|Zap/pseudo-530729128:from-internal:s:1:Rsrvd:(None)::::3::(None)
6|SIP/1003-d40d:default:8600051:2:Up:MeetMe:8600051:::3:10:(None)
concise: 11
lines: 6
DBchn: 1
DBsip: 2
-|0|Response: Follows|
EXcount: 0
+|0|Response SIP/ring|
-|1|Privilege: Command|
EXcount: 0
+|1|Privilege SIP/ring|
-|2|zap/17-1:from-internal:s:1:Up:Bridged Call:Local/8600051@default-201b,1:::3::Local/8600051@default-201b,1|
EXcount: 0
+|2|zap/17-1 Local/8600051@default-201b,1|
channel: |zap/17-1|
extension: |Local/8600051@default|
QRYchannel:|zap/17-1__Local/8600051@default|
current channels: 1
DB 0|| |DB 1|Zap/pseudo-530729128__ring| |-|3|Local/8600051@default-201b,2:default:8600051:2:Up:MeetMe:8600051:::3:7:(None)|
EXcount: 0
+|3|Local/8600051@default-201b,2 8600051|
channel: |Local/8600051@default-201b,2|
extension: |8600051|
QRYchannel:|Local/8600051@default-201b,2__8600051|
current sips: 2
DB 0|SIP/1003-d40d__8600051| |DB 1|| |DB 2|Local/8600051@default-201b,1__zap/17/17275551213| |-|4|Local/8600051@default-201b,1:default:917275551213:2:Up:Dial:zap/17/17275551213||tTo:::3:7:zap/17-1|
EXcount: 0
+|4|Local/8600051@default-201b,1 zap/17/17275551213||tTo|
channel: |Local/8600051@default-201b,1|
extension: |zap/17/17275551213|
QRYchannel:|Local/8600051@default-201b,1__zap/17/17275551213|
current sips: 2
DB 0|SIP/1003-d40d__8600051| |DB 1|| |DB 2|| |-|5|Zap/pseudo-530729128:from-internal:s:1:Rsrvd:(None)::::3::(None)|
EXcount: 0
+|5|Zap/pseudo-530729128 SIP/ring|
channel: |Zap/pseudo-530729128|
extension: |ring|
QRYchannel:|Zap/pseudo-530729128__ring|
current channels: 1
DB 0|| |DB 1|| |-|6|SIP/1003-d40d:default:8600051:2:Up:MeetMe:8600051:::3:10:(None)|
EXcount: 0
+|6|SIP/1003-d40d 8600051|
channel: |SIP/1003-d40d|
extension: |8600051|
QRYchannel:|SIP/1003-d40d__8600051|
current sips: 2
DB 0|| |DB 1|| |DB 2|| |COUNT: 7|6|5769976
loop counter: |5769975|
|SELECT channel,extension FROM live_channels where server_ip = '192.168.0.31'|
zap/17-1|Local/8600051@default
Zap/pseudo-530729128|ring
SIP/1003-d40d|8600051
Local/8600051@default-201b,2|8600051
Local/8600051@default-201b,1|zap/17/17275551213
|UPDATE server_updater set last_update='2006-07-10 15:18:37' where server_ip='192.168.0.31'|
0|Response: Follows
1|Privilege: Command
2|zap/17-1:from-internal:s:1:Up:Bridged Call:Local/8600051@default-201b,1:::3::Local/8600051@default-201b,1
3|Local/8600051@default-201b,2:default:8600051:2:Up:MeetMe:8600051:::3:7:(None)
4|Local/8600051@default-201b,1:default:917275551213:2:Up:Dial:zap/17/17275551213||tTo:::3:7:zap/17-1
5|Zap/pseudo-530729128:from-internal:s:1:Rsrvd:(None)::::3::(None)
6|SIP/1003-d40d:default:8600051:2:Up:MeetMe:8600051:::3:11:(None)
concise: 11
lines: 6
DBchn: 1
DBsip: 2
-|0|Response: Follows|
EXcount: 0
+|0|Response SIP/ring|
-|1|Privilege: Command|
EXcount: 0
+|1|Privilege SIP/ring|
-|2|zap/17-1:from-internal:s:1:Up:Bridged Call:Local/8600051@default-201b,1:::3::Local/8600051@default-201b,1|
EXcount: 0
+|2|zap/17-1 Local/8600051@default-201b,1|
channel: |zap/17-1|
extension: |Local/8600051@default|
QRYchannel:|zap/17-1__Local/8600051@default|
current channels: 1
DB 0|| |DB 1|Zap/pseudo-530729128__ring| |-|3|Local/8600051@default-201b,2:default:8600051:2:Up:MeetMe:8600051:::3:7:(None)|
EXcount: 0
+|3|Local/8600051@default-201b,2 8600051|
channel: |Local/8600051@default-201b,2|
extension: |8600051|
QRYchannel:|Local/8600051@default-201b,2__8600051|
current sips: 2
DB 0|SIP/1003-d40d__8600051| |DB 1|| |DB 2|Local/8600051@default-201b,1__zap/17/17275551213| |-|4|Local/8600051@default-201b,1:default:917275551213:2:Up:Dial:zap/17/17275551213||tTo:::3:7:zap/17-1|
EXcount: 0
+|4|Local/8600051@default-201b,1 zap/17/17275551213||tTo|
channel: |Local/8600051@default-201b,1|
extension: |zap/17/17275551213|
QRYchannel:|Local/8600051@default-201b,1__zap/17/17275551213|
current sips: 2
DB 0|SIP/1003-d40d__8600051| |DB 1|| |DB 2|| |-|5|Zap/pseudo-530729128:from-internal:s:1:Rsrvd:(None)::::3::(None)|
EXcount: 0
+|5|Zap/pseudo-530729128 SIP/ring|
channel: |Zap/pseudo-530729128|
extension: |ring|
QRYchannel:|Zap/pseudo-530729128__ring|
current channels: 1
DB 0|| |DB 1|| |-|6|SIP/1003-d40d:default:8600051:2:Up:MeetMe:8600051:::3:11:(None)|
EXcount: 0
+|6|SIP/1003-d40d 8600051|
channel: |SIP/1003-d40d|
extension: |8600051|
QRYchannel:|SIP/1003-d40d__8600051|
current sips: 2
DB 0|| |DB 1|| |DB 2|| |COUNT: 7|6|5769975
loop counter: |5769974|