<html>
  <head>
    <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <p>
      <meta http-equiv="content-type" content="text/html; charset=utf-8">
    </p>
    <p>
      <title></title>
      <meta name="generator" content="LibreOffice 5.1.6.2 (Linux)">
      <style type="text/css">
                @page { margin: 2cm }
                p { margin-bottom: 0.25cm; line-height: 120% }
        </style>
      <p style="margin-bottom: 0cm; line-height: 100%">Hi Leighton, Hi
        all,<br>
      </p>
      <p style="margin-bottom: 0cm; line-height: 100%">in which table
        can i
        find the value of attribute „peer_auth_user“ no idea why it is
        not in table voip_preferences.</p>
      <p style="margin-bottom: 0cm; line-height: 100%">Is there a schema
        spy picture site available?</p>
      <p style="margin-bottom: 0cm; line-height: 100%">From my analysis
        i can see that ngcp-panel/lib/NGCP/Panel/Utils/Sems.pm make use
        of this attribute.</p>
      <p style="margin-bottom: 0cm; line-height: 100%">Sems.pm is able
        to rewrite the INVITE From-Header with from_display attribute:<br>
      </p>
      <p style="margin-bottom: 0cm; line-height: 100%">MariaDB
        [provisioning]> select id, preference_id, label, value from
        voip_preferences_enum <br>
      </p>
      <p style="margin-bottom: 0cm; line-height: 100%">where label like
        'From-Display%';<br>
        +----+---------------+------------------+--------------+<br>
        | id | preference_id | label            | value        |<br>
        +----+---------------+------------------+--------------+<br>
        | 21 |            71 | From-Displayname | from_display |<br>
        | 26 |            72 | From-Displayname | from_display |<br>
        +----+---------------+------------------+--------------+<br>
        <br>
      </p>
      <p style="margin-bottom: 0cm; line-height: 100%">But Sems.pm is
        not able to rewrite with peer_auth_user.</p>
      <p style="margin-bottom: 0cm; line-height: 100%">[provisioning]>
        select id, preference_id, label, value from
        voip_preferences_enum </p>
      <p style="margin-bottom: 0cm; line-height: 100%"> where label like
        'Peer auth%';</p>
      <p style="margin-bottom: 0cm; line-height: 100%">+-----+---------------+--------------------------+----------------+</p>
      <p style="margin-bottom: 0cm; line-height: 100%">| id |
        preference_id | label | value |</p>
      <p style="margin-bottom: 0cm; line-height: 100%">+-----+---------------+--------------------------+----------------+</p>
      <p style="margin-bottom: 0cm; line-height: 100%">| 116 | 73 | Peer
        authentication name | peer_auth_user |</p>
      <p style="margin-bottom: 0cm; line-height: 100%">| 117 | 75 | Peer
        authentication name | peer_auth_user |</p>
      <p style="margin-bottom: 0cm; line-height: 100%">| 118 | 76 | Peer
        authentication name | peer_auth_user |</p>
      <p style="margin-bottom: 0cm; line-height: 100%">+-----+---------------+--------------------------+----------------+
      </p>
      <p style="margin-bottom: 0cm; line-height: 100%"><br>
      </p>
      <p style="margin-bottom: 0cm; line-height: 100%">[provisioning]>
        select attribute, label, data_type, read_only from
        voip_preferences </p>
      <p style="margin-bottom: 0cm; line-height: 100%">where attribute
        like
        'peer_auth%';</p>
      <p style="margin-bottom: 0cm; line-height: 100%">+--------------------+------------------------------+-----------+-----------+</p>
      <p style="margin-bottom: 0cm; line-height: 100%">| attribute |
        label | data_type | read_only |</p>
      <p style="margin-bottom: 0cm; line-height: 100%">+--------------------+------------------------------+-----------+-----------+</p>
      <p style="margin-bottom: 0cm; line-height: 100%">| peer_auth_pass
        | Peer Authentication Password | string | 0 |</p>
      <p style="margin-bottom: 0cm; line-height: 100%">| peer_auth_realm
        | Peer Authentication Domain | string | 0 |</p>
      <p style="margin-bottom: 0cm; line-height: 100%">|
        peer_auth_register
        | Enable Peer Authentication | boolean | 0 |</p>
      <p style="margin-bottom: 0cm; line-height: 100%">| peer_auth_user
        | Peer Authentication User | string | 0 |</p>
      <p style="margin-bottom: 0cm; line-height: 100%">+--------------------+------------------------------+-----------+-----------+</p>
      <p style="margin-bottom: 0cm; line-height: 100%"><br>
      </p>
      <p style="margin-bottom: 0cm; line-height: 100%">Best regards,</p>
      <p style="margin-bottom: 0cm; line-height: 100%">Georg<br>
      </p>
      <p style="margin-bottom: 0cm; line-height: 100%"><br>
      </p>
    </p>
    <br>
    <div class="moz-cite-prefix">On 25.05.2017 23:45, Leighton Brennan
      wrote:<br>
    </div>
    <blockquote
cite="mid:CAMwvYi6X33fdMfktTeP8HAQFOxRaQ-W8Dk+CnAO=D_upLy-zGA@mail.gmail.com"
      type="cite">
      <div>Are you registering to your peer. </div>
      <div><br>
      </div>
      <div>I think you need to in order to show the auth username in the
        invite. </div>
      <div><br>
      </div>
      <div>Don't have access to test right now. </div>
      <div><br>
      </div>
      <div><br>
        <div class="gmail_quote">
          <div>On Thu 25 May 2017 at 19:59, gh <<a
              moz-do-not-send="true" href="mailto:gh@heissa.de">gh@heissa.de</a>>
            wrote:<br>
          </div>
          <blockquote class="gmail_quote" style="margin:0 0 0
            .8ex;border-left:1px #ccc solid;padding-left:1ex">I post my
            question again because of text format error in my first
            mail!<br>
            <br>
            <br>
            sip:provider CE mr5.2.1<br>
            <br>
            outbound_from_user setting in peering settings does not work
            as expected.<br>
            My current setting is as follow:<br>
            Peer Host "peerhost" - Preferences<br>
            <br>
            Access Restrictions<br>
            <br>
            Number Manipulations<br>
            <br>
            outbound_from_user >Outbound From-Username Field >Peer
            authentication name<br>
            <br>
            <br>
            With this setting I would expect to get somthing like:<br>
            <br>
            From: "12081" <<a moz-do-not-send="true"
              href="mailto:sip%3Apeer_authusername@sip.ownhost.de"
              target="_blank">sip:peer_authusername@sip.ownhost.de</a>><br>
            <br>
            but what i get is:<br>
            <br>
            From: "12081" <<a moz-do-not-send="true"
              href="mailto:sip%3A498932168@sip.ownhost.de"
              target="_blank">sip:498932168@sip.ownhost.de</a>>;tag=080164C5-59270.<br>
            <br>
            where 32168 is the subscriber number in my case.<br>
            <br>
            <br>
            <br>
            Thanks for any help<br>
            <br>
            Georg<br>
            <br>
            <br>
            _______________________________________________<br>
            Spce-user mailing list<br>
            <a moz-do-not-send="true"
              href="mailto:Spce-user@lists.sipwise.com" target="_blank">Spce-user@lists.sipwise.com</a><br>
            <a moz-do-not-send="true"
              href="https://lists.sipwise.com/listinfo/spce-user"
              rel="noreferrer" target="_blank">https://lists.sipwise.com/listinfo/spce-user</a><br>
          </blockquote>
        </div>
      </div>
      <div dir="ltr">-- <br>
      </div>
      <div data-smartmail="gmail_signature">Best Regards<br>
        Leighton<br>
      </div>
    </blockquote>
    <br>
  </body>
</html>