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@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@voice-system.ro; serusers@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@voice-system.ro To: ashling.odriscoll@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
-------------------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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers