[Serusers] Speeddial

Steve Blair blairs at isc.upenn.edu
Mon Sep 19 14:32:05 CEST 2005


Earlier in this message someone commented that the table name was
usr_preferences . You should be using the speed_dial table if you are using
the "default" mysql build scripts.



Aisling wrote:

>Hi William,
>
>Thanks for the comment below. I made the change as suggested and when I
>dialed '3' I got the following errors:
>
>submit_query(): Table 'ser.speed' doesn't exist
>submit_query(): Error while submitting query
>sd_lookup: error querying database
>
>>From this I changed the code so that "sd_lookup("speed dial");" became
>"sd_lookup("speed_dial");" I then got these errors:
>
>submit_query(): Unknown column 'real_uri' in 'field list'
>submit_query(): Error while submitting query
>sd_lookup: error querying database
>
>Table speed_dial exists in my ser database. My entry in the database is
>"("2092", "x.x.x.x", "3", "x.x.x.x","sip:3500 at x.x.x.x").
>
>Could this be something got to do with my modparam settings?...or was I
>incorrect changing the sd_lookup query?
>
>I have:
>
>modparam("speeddial", "db_url", "mysql://root:password@localhost/ser")
>modparam("speeddial", "user_column", "userid")
>modparam("speeddial", "sd_user_column", "short_user")
>modparam("speeddial", "sd_domain_column", "short_domain")
>modparam("speeddial", "new_uri_column", "real_uri")
>
>Any ideas?
>Many thanks to those who have helped so far,
>Aisling.
>
>
>-----Original Message-----
>From: William Towfiq [mailto:william at intelejet.com] 
>Sent: 18 September 2005 02:20
>To: Aisling O'Driscoll
>Cc: ramona at voice-system.ro; serusers at lists.iptel.org
>Subject: Re: [Serusers] Speeddial
>
>Hi Aisling,
>Since you are doing a one digit speeddial make sure you have
>
>if ((method=="INVITE") && (uri=~"^sip:[0-9]@.*")){
>
>sd_lookup("speed dial");
>
>};
>rather than
>
>if ((method=="INVITE") && (uri=~"^sip:[0-9]{2}@.*")){
>
>sd_lookup("speed dial");
>
>};
>
>so that the uri matches and the lookup is done properly.
>
>William Towfiq
>
>Aisling O'Driscoll wrote:
>
>  
>
>>Thanks Ramona.
>> 
>>
>>    
>>
>>>---- Original Message ----
>>>From: ramona at voice-system.ro
>>>To: ashling.odriscoll at cit.ie
>>>Subject: Re: [Serusers] Speeddial
>>>Date: Thu, 15 Sep 2005 20:10:56 +0200
>>>
>>>   
>>>
>>>      
>>>
>>>>Aisling wrote:
>>>>
>>>>     
>>>>
>>>>        
>>>>
>>>>>Hello.
>>>>>
>>>>>I would really appreciate if someone could show me an example of
>>>>>       
>>>>>
>>>>>          
>>>>>
>>>how a 
>>>   
>>>
>>>      
>>>
>>>>>speed-dialing entry should be added to the ser mysql database?
>>>>>
>>>>>E.g. If user 2092 dials 3 it rings user 3500.
>>>>>
>>>>>I tried : insert into usr_preferences (username, domain,
>>>>>       
>>>>>
>>>>>          
>>>>>
>>>sd_username, 
>>>   
>>>
>>>      
>>>
>>>>>sd_domain, new_uri) values ("2092", "x.x.x.x", "3500", "x.x.x.x",
>>>>>       
>>>>>
>>>>>          
>>>>>
>>>"3")
>>>   
>>>
>>>      
>>>
>>>>Hello Aisling,
>>>>
>>>>the entry should be ("2092", "x.x.x.x", "3", "x.x.x.x",
>>>>     
>>>>
>>>>        
>>>>
>>>"sip:3500 at x.x.x.x").
>>>   
>>>
>>>      
>>>
>>>>Regards,
>>>>Ramona
>>>>
>>>>        
>>>>
>
>
>
>-------------------Legal  Disclaimer---------------------------------------
>
>The above electronic mail transmission is confidential and intended only for the person to whom it is addressed. Its contents may be protected by legal and/or professional privilege. Should it be received by you in error please contact the sender at the above quoted email address. Any unauthorised form of reproduction of this message is strictly prohibited. The Institute does not guarantee the security of any information electronically transmitted and is not liable if the information contained in this communication is not a proper and complete record of the message as transmitted by the sender nor for any delay in its receipt.
>
>_______________________________________________
>Serusers mailing list
>serusers at lists.iptel.org
>http://lists.iptel.org/mailman/listinfo/serusers
>  
>




More information about the sr-users mailing list