<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /></head><body style='font-size: 10pt; font-family: Verdana,Geneva,sans-serif'>
<p>On 2016-07-02 15:16, Derek Bolichowski wrote:</p>
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0"><!-- html ignored --> <!-- head ignored --><!-- meta ignored --> <!-- meta ignored -->
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size: 11.0pt; font-family: 'Calibri',sans-serif;">Hi Leandro,<!-- o ignored --></span></p>
<p class="MsoNormal"><span style="font-size: 11.0pt; font-family: 'Calibri',sans-serif;">I believe if you check /usr/local/src/astersisk-13.9.1/contrib/mysql you will find a .SQL file that would build the default tables for you.<!-- o ignored --></span></p>
<p class="MsoNormal"><span style="font-size: 11.0pt; font-family: 'Calibri',sans-serif;"><!-- o ignored --> </span></p>
<p class="MsoNormal"><span style="font-size: 11.0pt; font-family: 'Calibri',sans-serif;">Looking in the file, it appears there is a table created called `sippeers` which has a column `regserver VARCHAR(20),`<!-- o ignored --></span></p>
<p class="MsoNormal"><span style="font-size: 11.0pt; font-family: 'Calibri',sans-serif;"><!-- o ignored --> </span></p>
<p class="MsoNormal"><span style="font-size: 11.0pt; font-family: 'Calibri',sans-serif;">It will also create the other PJSIP-related tables such as ps_endpoints, ps_aors, etc.<!-- o ignored --></span></p>
<p class="MsoNormal"><span style="font-size: 11.0pt; font-family: 'Calibri',sans-serif;"><!-- o ignored --> </span></p>
<p class="MsoNormal"><span style="font-size: 11.0pt; font-family: 'Calibri',sans-serif;">I could be mistaken but perhaps `sippeers` is the table you're looking for.<!-- o ignored --></span></p>
<p class="MsoNormal"><span style="font-size: 11.0pt; font-family: 'Calibri',sans-serif;"><!-- o ignored --> </span></p>
<p class="MsoNormal"><span style="font-size: 11.0pt; font-family: 'Calibri',sans-serif;">Thanks<!-- o ignored --></span></p>
<p class="MsoNormal"><span style="font-size: 11.0pt; font-family: 'Calibri',sans-serif;">Derek B.<!-- o ignored --></span></p>
<p class="MsoNormal"><span style="font-size: 11.0pt; font-family: 'Calibri',sans-serif; mso-fareast-language: EN-US;"><!-- o ignored --> </span></p>
<p class="MsoNormal" style="margin-left: 36.0pt;"><strong><span style="font-size: 11.0pt; font-family: 'Calibri',sans-serif;">From:</span></strong><span style="font-size: 11.0pt; font-family: 'Calibri',sans-serif;"> asterisk-users-bounces@lists.digium.com [mailto:asterisk-users-bounces@lists.digium.com] <strong>On Behalf Of </strong>Leandro Dardini<br /> <strong>Sent:</strong> July 2, 2016 2:59 PM<br /> <strong>To:</strong> Asterisk Users Mailing List - Non-Commercial Discussion <asterisk-users@lists.digium.com><br /> <strong>Subject:</strong> [asterisk-users] Registration server with PJSIP<!-- o ignored --></span></p>
<p class="MsoNormal" style="margin-left: 36.0pt;"><!-- o ignored --> </p>
<div>
<p class="MsoNormal" style="margin-left: 36.0pt;">Hello,<!-- o ignored --></p>
<div>
<p class="MsoNormal" style="margin-left: 36.0pt;">I am moving from realtime chan_sip to pjsip and one of the problem I am facing is the lack of "sipregs". With chan_sip, when an extension registers, the server where it has registered to is stored in sipregs.<!-- o ignored --></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size: 11.0pt; font-family: 'Calibri',sans-serif;"><!-- o ignored --> </span></p>
</div>
<div>
<p class="MsoNormal" style="margin-left: 36.0pt;">Is there something similar in pjsip? How can I find on which server the pjsip extension has registered to?<!-- o ignored --></p>
</div>
<div>
<p class="MsoNormal" style="margin-left: 36.0pt;"><!-- o ignored --> </p>
</div>
</div>
</div>
</blockquote>
<p>Actually sippeers is the table for realtime sip and not related to pjsip at all. I do not know if there is an equivalent field for the pjsip tables.</p>
<div>-- <br />
<div class="pre" style="margin: 0; padding: 0; font-family: monospace">Telecomunicaciones Abiertas de México S.A. de C.V.<br /> Carlos Chávez<br /> dCAP #1349<br /> +52 (55)9116-91161</div>
</div>
</body></html>