[asterisk-bugs] [Asterisk 0018477]: MySQL Realtime - musicclass/musiconhold ignored

[Asterisk Bug Tracker]

The following issue requires your FEEDBACK. 
====================================================================== 
https://issues.asterisk.org/view.php?id=18477 
====================================================================== 
Reported By:                rossbeer
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   18477
Category:                   Channels/chan_sip/General
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     feedback
Asterisk Version:           1.6.2.15 
JIRA:                        
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2010-12-15 11:46 CST
Last Modified:              2010-12-16 10:56 CST
====================================================================== 
Summary:                    MySQL Realtime - musicclass/musiconhold ignored
Description: 
The variables 'musicclass' / 'musiconhold' variables are ignored when
making or receiving a call on a channel.

If a call is made from one SIP channel to another directly using the
following:

Dial(Sip/100)

The music on hold class is always the default class even though the
realtime MySQL database contains music classes defined in 'musicclass' /
'musiconhold'.

As I understand this from the documentation, by setting the two variables
above this should override the default music class per extension and be
reloaded when the peer is read from the database, which is not currently
the case.
====================================================================== 

---------------------------------------------------------------------- 
 (0129686) lmadsen (administrator) - 2010-12-16 10:56
 https://issues.asterisk.org/view.php?id=18477#c129686 
---------------------------------------------------------------------- 
Additional information is required. Ideally you should show us the SQL
commands that are being received by your MySQL server. This would be the
logging enabled on the MySQL side. A SELECT statement will be sent from
Asterisk.

Also show the table layout and the relative information in the row being
selected by Asterisk.

Provide the musiconhold.conf configuration.

Provide the console output from the Asterisk console with debug level
logging so we can see what is going on.

It'll be necessary to reproduce this issue to resolve it, so all the above
information is required. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-12-16 10:56 lmadsen        Note Added: 0129686                          
2010-12-16 10:56 lmadsen        Status                   new => feedback     
======================================================================