19 Sep
2005
19 Sep
'05
3:04 p.m.
Yes, sorry maybe I should have clarified that ...I have changed this- I
am using the speed_dial table. It contains:
"("2092", "x.x.x.x", "3",
"x.x.x.x","sip:3500@x.x.x.x").
But I still have the errors mentioned below. I get " submit_query():
Table 'ser.speed' doesn't exist" when I have the line
"sd_lookup("speed
dial");". Following on from this I changed the line to
"sd_lookup("speed_dial");" and get "submit_query(): Unknown
column
'real_uri' in 'field list'".
Regards,
Aisling.
-----Original Message-----
From: Steve Blair [mailto:blairs@isc.upenn.edu]
Sent: 19 September 2005 13:32
To: Aisling
Cc: 'William Towfiq'; serusers(a)lists.iptel.org
Subject: Re: [Serusers] Speeddial
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
-------------------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.
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@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@intelejet.com]
Sent: 18 September 2005 02:20
To: Aisling O'Driscoll
Cc: ramona(a)voice-system.ro; serusers(a)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(a)voice-system.ro
>To: ashling.odriscoll(a)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@x.x.x.x").
>
>
>
>
>>Regards,
>>Ramona
>>
>>
>>