[Serusers] Speeddial

[Aisling]

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.