[asterisk-bugs] [JIRA] (ASTERISK-28356) app_queue: set ringinuse for realtime member not working
Michael (JIRA)
noreply at issues.asterisk.org
Mon Apr 1 14:38:47 CDT 2019
[ https://issues.asterisk.org/jira/browse/ASTERISK-28356?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=246737#comment-246737 ]
Michael commented on ASTERISK-28356:
------------------------------------
I'm being difficult? Help Me? lol. It is actually me that is trying to help out the Asterisk project. I'm trying to help you. I myself am not concerned with this problem. I don't believe i'm being difficult at all. If you're not interested in this issue, that's fine. just close the ticket. Or i can send you empty config files if you absolutely insist on me sending you files.
I have created the tables using the provided mysql_config.sql in the asterisk source:
/opt/src/asterisk/contrib/realtime/mysql/mysql_config.sql
MariaDB [hpbx3]> desc queues;
+-----------------------------+------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------------+------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| name | varchar(128) | NO | PRI | NULL | |
| musiconhold | varchar(128) | YES | | NULL | |
| announce | varchar(128) | YES | | NULL | |
| context | varchar(128) | YES | | NULL | |
| timeout | int(11) | YES | | NULL | |
| ringinuse | enum('yes','no') | YES | | NULL | |
| setinterfacevar | enum('yes','no') | YES | | NULL | |
| setqueuevar | enum('yes','no') | YES | | NULL | |
| setqueueentryvar | enum('yes','no') | YES | | NULL | |
| monitor_format | varchar(8) | YES | | NULL | |
| membermacro | varchar(512) | YES | | NULL | |
| membergosub | varchar(512) | YES | | NULL | |
| queue_youarenext | varchar(128) | YES | | NULL | |
| queue_thereare | varchar(128) | YES | | NULL | |
| queue_callswaiting | varchar(128) | YES | | NULL | |
| queue_quantity1 | varchar(128) | YES | | NULL | |
| queue_quantity2 | varchar(128) | YES | | NULL | |
| queue_holdtime | varchar(128) | YES | | NULL | |
| queue_minutes | varchar(128) | YES | | NULL | |
| queue_minute | varchar(128) | YES | | NULL | |
| queue_seconds | varchar(128) | YES | | NULL | |
| queue_thankyou | varchar(128) | YES | | NULL | |
| queue_callerannounce | varchar(128) | YES | | NULL | |
| queue_reporthold | varchar(128) | YES | | NULL | |
| announce_frequency | int(11) | YES | | NULL | |
| announce_to_first_user | enum('yes','no') | YES | | NULL | |
| min_announce_frequency | int(11) | YES | | NULL | |
| announce_round_seconds | int(11) | YES | | NULL | |
| announce_holdtime | varchar(128) | YES | | NULL | |
| announce_position | varchar(128) | YES | | NULL | |
| announce_position_limit | int(11) | YES | | NULL | |
| periodic_announce | varchar(50) | YES | | NULL | |
| periodic_announce_frequency | int(11) | YES | | NULL | |
| relative_periodic_announce | enum('yes','no') | YES | | NULL | |
| random_periodic_announce | enum('yes','no') | YES | | NULL | |
| retry | int(11) | YES | | NULL | |
| wrapuptime | int(11) | YES | | NULL | |
| penaltymemberslimit | int(11) | YES | | NULL | |
| autofill | enum('yes','no') | YES | | NULL | |
| monitor_type | varchar(128) | YES | | NULL | |
| autopause | enum('yes','no','all') | YES | | NULL | |
| autopausedelay | int(11) | YES | | NULL | |
| autopausebusy | enum('yes','no') | YES | | NULL | |
| autopauseunavail | enum('yes','no') | YES | | NULL | |
| maxlen | int(11) | YES | | NULL | |
| servicelevel | int(11) | YES | | NULL | |
| strategy | enum('ringall','leastrecent','fewestcalls','random','rrmemory','linear','wrandom','rrordered') | YES | | NULL | |
| joinempty | varchar(128) | YES | | NULL | |
| leavewhenempty | varchar(128) | YES | | NULL | |
| reportholdtime | enum('yes','no') | YES | | NULL | |
| memberdelay | int(11) | YES | | NULL | |
| weight | int(11) | YES | | NULL | |
| timeoutrestart | enum('yes','no') | YES | | NULL | |
| defaultrule | varchar(128) | YES | | NULL | |
| timeoutpriority | varchar(128) | YES | | NULL | |
+-----------------------------+------------------------------------------------------------------------------------------------+------+-----+---------+-------+
55 rows in set (0.00 sec)
MariaDB [hpbx3]> desc queue_members;
+-----------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+-------------+------+-----+---------+----------------+
| queue_name | varchar(80) | NO | PRI | NULL | |
| interface | varchar(80) | NO | PRI | NULL | |
| membername | varchar(80) | YES | | NULL | |
| state_interface | varchar(80) | YES | | NULL | |
| penalty | int(11) | YES | | NULL | |
| paused | int(11) | YES | | NULL | |
| uniqueid | int(11) | NO | UNI | NULL | auto_increment |
| wrapuptime | int(11) | YES | | NULL | |
+-----------------+-------------+------+-----+---------+----------------+
8 rows in set (0.00 sec)
for table permissions, i just allow to the whole db:
MariaDB [hpbx3]> select Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv from mysql.db;
+------+-------+-----------+-------------+-------------+-------------+-------------+
| Host | Db | User | Select_priv | Insert_priv | Update_priv | Delete_priv |
+------+-------+-----------+-------------+-------------+-------------+-------------+
| % | hpbx3 | hpbx3_ast | Y | Y | Y | Y |
+------+-------+-----------+-------------+-------------+-------------+-------------+
1 row in set (0.00 sec)
> app_queue: set ringinuse for realtime member not working
> --------------------------------------------------------
>
> Key: ASTERISK-28356
> URL: https://issues.asterisk.org/jira/browse/ASTERISK-28356
> Project: Asterisk
> Issue Type: Bug
> Security Level: None
> Components: Applications/app_queue
> Affects Versions: 16.2.0
> Environment: debian 9 amd64
> asterisk v16.2.0
> using pjsip
> mysql ODBC
> Reporter: Michael
> Assignee: Michael
> Severity: Minor
> Labels: pjsip
>
> when changing the ringinuse option for a queue member added via realtime sql, failure occures.
> *CLI>queue show techsupport
> techsupport has 0 calls (max unlimited) in 'ringall' strategy (0s holdtime, 0s talktime), W:0, C:0, A:0, SL:0.0%, SL2:0.0% within 0s
> Members:
> Mike (PJSIP/52501) (ringinuse enabled) (dynamic) (Not in use) has taken no calls yet
> Mike (PJSIP/5250) (ringinuse enabled) (realtime) (Not in use) has taken no calls yet
> No Callers
> *CLI>queue set ringinuse no on PJSIP/52501 in techsupport
> Set ringinuse on interface 'PJSIP/52501' from queue 'techsupport'
> *CLI>queue set ringinuse no on PJSIP/5250 in techsupport
> Set ringinuse on interface 'PJSIP/5250' from queue 'techsupport'
> [Mar 27 16:49:49] WARNING[19466]: res_odbc.c:439 ast_odbc_print_errors: SQL Prepare returned an error: 42000: [MySQL][ODBC 8.0(a) Driver][mysqld-5.5.5-10.1.37-MariaDB-0+deb9u1]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE uniqueid=?' at line 1
> [Mar 27 16:49:49] WARNING[19466]: res_config_odbc.c:122 custom_prepare: SQL Prepare failed! [UPDATE queue_members SET WHERE uniqueid=?]
> [Mar 27 16:49:49] WARNING[19466]: res_odbc.c:439 ast_odbc_print_errors: SQL Prepare returned an error: 42000: [MySQL][ODBC 8.0(a) Driver][mysqld-5.5.5-10.1.37-MariaDB-0+deb9u1]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE uniqueid=?' at line 1
> [Mar 27 16:49:49] WARNING[19466]: res_config_odbc.c:122 custom_prepare: SQL Prepare failed! [UPDATE queue_members SET WHERE uniqueid=?]
--
This message was sent by Atlassian JIRA
(v6.2#6252)
More information about the asterisk-bugs
mailing list