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