search

POSSA / freepbx-trunk-balancing

Restrict outbound calls or balance calls over multiple trunks based on user specified parameters
http://pbxossa.org/files/trunkbalance/
37 stars 30 forks source link

help plzzzz #27

Closed zm52 closed 9 years ago

zm52 commented 9 years ago 
Launched AGI Script /var/lib/asterisk/agi-bin/trunkbalance.php
       > trunkbalance.php,1,0631908787: Running SQL Command SELECT * FROM `trunks` WHERE trunkid='1'
       > trunkbalance.php,1,0631908787: Connected to MySQL database OK.
       > trunkbalance.php,1,0631908787: Selected database OK.
    -- trunkbalance.php,1,0631908787: This trunk mod is balanced. Evaluating rules
       > trunkbalance.php,1,0631908787: Running SQL Command SELECT * FROM `trunkbalance` WHERE description='mod'
       > trunkbalance.php,1,0631908787: Running SQL Command SELECT * FROM `trunks` WHERE trunkid='2'
       > trunkbalance.php,1,0631908787: Running SQL Command SELECT COUNT(*) FROM `cdr` WHERE disposition='ANSWERED' AND dongle/r1/$OUTNUM$
       > trunkbalance.php,1,0631908787: Connected to MySQL database OK.
       > trunkbalance.php,1,0631908787: Selected database OK.
 trunkbalance.php,1,0631908787: MySQL Error: Unknown column 'dongle' in 'where clause' with query SELECT COUNT(*) FROM `cdr` WHERE disposition='ANSWERED' AN      D dongle/r1/$OUTNUM$
    -- trunkbalance.php,1,0631908787: 2 max calls. This trunk has now only  calls - Rule passed
    -- trunkbalance.php,1,0631908787: SELECT COUNT(*) FROM `cdr` WHERE disposition='ANSWERED' AND dongle/r1/$OUTNUM$
       > trunkbalance.php,1,0631908787: Running SQL Command SELECT SUM(billsec) FROM `cdr` WHERE disposition='ANSWERED' AND dongle/r1/$OUTNUM$
 trunkbalance.php,1,0631908787: MySQL Error: Unknown column 'dongle' in 'where clause' with query SELECT SUM(billsec) FROM `cdr` WHERE disposition='ANSWERED      ' AND dongle/r1/$OUTNUM$
    -- trunkbalance.php,1,0631908787: 1 max minutes. This trunk has now only 0 min. - Rule passed
    -- trunkbalance.php,1,0631908787: Call authorized. The new trunk number is 2
    -- <SIP/70891322-00000000>AGI Script trunkbalance.php completed, returning 0
lgaetz commented 9 years ago

You appear to be using a modified version of the module based on a post by @dandantheitman. We have no way of testing or providing support.