15 Sep
2005
15 Sep
'05
9:47 p.m.
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
Hello Aisling,
the entry should be (2092, x.x.x.x, 3, x.x.x.x, sip:3500@x.x.x.x).
-------------------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.
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)
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.
>
> 
18 Sep
18 Sep
3:20 a.m.
New subject: [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
-------------------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(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
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.
>
>
19 Sep
19 Sep
11:32 a.m.
New subject: [Serusers] Speeddial
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(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
>>
-------------------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.
2:32 p.m.
New subject: [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
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
>>
>>
>>
-------------------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(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
3:04 p.m.
New subject: [Serusers] Speeddial
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
>>
>>
>>
7011
days inactive
7015
days old
4 comments
4 participants
participants (4)
-
Aisling -
Aisling O'Driscoll
-
Steve Blair -
William Towfiq