Use AVPOPS module, you can connect to any database and runny any SQL on it from within opensips.cfg,<div><br></div><div><a href="http://www.opensips.org/html/docs/modules/1.8.x/avpops.html#id292750">http://www.opensips.org/html/docs/modules/1.8.x/avpops.html#id292750</a><br>
<div><br></div><div>However, using this method is mostly recommended for databases other then opensips own native database. If you can give some details about what you are trying to do then may be we can advise some OpenSIPs module or function to do the job without manually querying the native database.</div>
<div><br></div><div>Thank you.</div><div><br><br><div class="gmail_quote">On Fri, Aug 24, 2012 at 1:54 PM, Pieri Mavarez <span dir="ltr"><<a href="mailto:pasaportefacil@gmail.com" target="_blank">pasaportefacil@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi, im trying to read the content from the table Presentity, more specifically, i want to read the file from 'body' field and use this information. <div>
<br></div><div>How can i enter the database from the opensips.cfg file to use this info?</div>
<div><br></div><div>Thanks</div><div><br></div><div>Pierina M</div>
<br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br>Muhammad Shahzad<br>-----------------------------------<br>CISCO Rich Media Communication Specialist (CRMCS)<br>CISCO Certified Network Associate (CCNA)<br>
Cell: +92 334 422 40 88<br>MSN: <a href="mailto:shari_786pk@hotmail.com">shari_786pk@hotmail.com</a><br>Email: <a href="mailto:shaheryarkh@googlemail.com">shaheryarkh@googlemail.com</a><br>
</div></div>