Module: sems Branch: master Commit: 86359d9de644a02c6646fd3f15b4a83fe9f3cc78 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sems/?a=commit;h=86359d9de644a02c6646fd3f15b4a83fe9f3cc78
Author: Stefan Sayer <[email protected]> Committer: Stefan Sayer <[email protected]> Date: Fri Jun 10 14:21:35 2011 +0200 db_reg_agent: removed adding colon iof query in the code --- apps/db_reg_agent/DBRegAgent.cpp | 2 +- apps/db_reg_agent/etc/db_reg_agent.conf | 5 ++--- 2 files changed, 3 insertions(+), 4 deletions(-) diff --git a/apps/db_reg_agent/DBRegAgent.cpp b/apps/db_reg_agent/DBRegAgent.cpp index f2fbac0..71c486a 100644 --- a/apps/db_reg_agent/DBRegAgent.cpp +++ b/apps/db_reg_agent/DBRegAgent.cpp @@ -237,7 +237,7 @@ bool DBRegAgent::loadRegistrations() { string query_string, table; - query_string = joined_query + ";"; + query_string = joined_query; DBG("querying all registrations with : '%s'\n", query_string.c_str()); diff --git a/apps/db_reg_agent/etc/db_reg_agent.conf b/apps/db_reg_agent/etc/db_reg_agent.conf index f330efe..7f43a59 100644 --- a/apps/db_reg_agent/etc/db_reg_agent.conf +++ b/apps/db_reg_agent/etc/db_reg_agent.conf @@ -13,11 +13,10 @@ mysql_passwd=mypass123 # registrations_table="registrations" # query joining subscriber info with registration table -# (without trailing ';' such that where clause can appended) -joined_query="select subscribers.subscriber_id as subscriber_id, subscribers.user as user, subscribers.pass as pass, subscribers.realm as realm, registrations.registration_status as registration_status, registrations.expiry as expiry, registrations.last_registration as last_registration from subscribers left join registrations on subscribers.subscriber_id=registrations.subscriber_id" +joined_query="select subscribers.subscriber_id as subscriber_id, subscribers.user as user, subscribers.pass as pass, subscribers.realm as realm, registrations.registration_status as registration_status, registrations.expiry as expiry, registrations.last_registration as last_registration from subscribers left join registrations on subscribers.subscriber_id=registrations.subscriber_id;" #example with contact: -# joined_query="select subscribers.subscriber_id as subscriber_id, subscribers.user as user, subscribers.pass as pass, subscribers.realm as realm, subscribers.contact as contact, registrations.registration_status as registration_status, registrations.expiry as expiry, registrations.last_registration as last_registration from subscribers left join registrations on subscribers.subscriber_id=registrations.subscriber_id" +# joined_query="select subscribers.subscriber_id as subscriber_id, subscribers.user as user, subscribers.pass as pass, subscribers.realm as realm, subscribers.contact as contact, registrations.registration_status as registration_status, registrations.expiry as expiry, registrations.last_registration as last_registration from subscribers left join registrations on subscribers.subscriber_id=registrations.subscriber_id;" # contact_hostport=<host:port> - overriding contact host:port # sets the contact host:port portion that is registered _______________________________________________ Semsdev mailing list [email protected] http://lists.iptel.org/mailman/listinfo/semsdev
