9 Jul
2007
9 Jul
'07
1:51 p.m.
Hello everyone,
I am facing a problem trying to load data from MySQL in ser.cfg. I need to
load the subsciber's email address in order to pass it to SEMS. I've tried
two modules (avpops and db_ops) both with no success.
I am using Ser 2.0.0-rc1 and I added an 'email' column to the uri table.
Here is the DB schema (only 1 row shown without did, flags and scheme
colums):
+--------------+------------------------------+--------------------------+
| username | uid | email |
+--------------+------------------------------+--------------------------+
| sb4157762898 | sb4157762898(a)sq2.doclinx.com | sb4157762898(a)doclinx.com
| |
+--------------+------------------------------+--------------------------+
A. avpops module. I have the following module params:
modparam("avpops", "avp_table", "uri")
modparam("avpops", "uid_column", "uid");
modparam("avpops", "avp_aliases", "email=i:47")
modparam("avpops", "db_scheme",
"email_scheme:table=uri;uid_col=uid;value_col=email;value_type=string")
Then when I'm going to forward to SEMS:
avp_db_load("$to", "$email/$email_scheme");
xlog("L_INFO",
"route INBOUND[%rm]: voicemail, email=%$email, from: [%fu], To:
[%tu]\n");
append_hf("P-App-Name: voicemail\r\n");
append_hf("P-App-Param: Email-Address=%$email\r\n");
rewritehostport("127.0.0.1:5070");
t_relay_to_udp("127.0.0.1","5070");
Here is the appropriate excerpt from the SER log (from the xlog statement
above):
Jul 9 13:12:39 sq2 /usr/local/sbin/ser[5595]: route INBOUND[INVITE]:
voicemail, email=<null>, from: [sip:sb7037160791@sq2.doclinx.com], To:
[sip:sb4157762898@sq2.doclinx.com]
2. db_ops module. I have the following module params:
modparam("db_ops", "declare_query",
"select/uri/email/uid///%$t.uid");
Then when I'm going to forward to SEMS:
$email = @db_query[0];
xlog("L_INFO",
"route INBOUND[%rm]: voicemail, email=%$email, from: [%fu], To:
[%tu]\n");
append_hf("P-App-Name: voicemail\r\n");
append_hf("P-App-Param: Email-Address=%$email\r\n");
rewritehostport("127.0.0.1:5070");
t_relay_to_udp("127.0.0.1","5070");
This makes SER fail on startup with this message:
0(5693) Unable to resolve select 'db_query' at level 0
0(5693) BUG: route.c:492: Unable to resolve select
ERROR: error -1 while trying to fix configuration
I have followed the README file in db_ops to the letter. What am I missng?
I'd be be happy to post ser.cfg and the log file.
Thank you very much for your help.
Best regards,
- Ravin