Asterisk
  1. Asterisk
  2. ASTERISK-7246

[patch][post 1.4] Move SIP registration information out of sippeers table into it's own

    Details

    • Type: New Feature New Feature
    • Status: Closed
    • Severity: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Target Release Version/s: None
    • Labels:
      None
    • SVN Revision Number:
      47050
    • Mantis ID:
      7443
    • Regression:
      No

      Description

      I'm in the process of restructuring my database, and realized that it would be a lot simpler if asterisk didn't update the same table that the configurations were in. This patch moves everything that asterisk actually updates regarding sip peers in the database into it's own table (I used the name sipregs for the table). The fields that have been moved are fullcontact, ipaddr, port, regseconds, and username. There is also a name field (for ID) so that's one thing you have to put in the table yourself (or set up triggers or however else you want to do it). With this configuration, you can set up multiple tables that control phone configurations and create a view with the info you need to use as sippeers, without having to worry about so much duplicated information in a database.

        Activity

        Hide
        Olle Johansson added a comment -

        I would suggest adding a line for this in "sip show settings" under realtime. Other than that - are we ready for commit? I like this change.

        Show
        Olle Johansson added a comment - I would suggest adding a line for this in "sip show settings" under realtime. Other than that - are we ready for commit? I like this change.
        Hide
        Aaron Daniel (Inactive) added a comment -

        The patch already has that under the Realtime SIP Settings section, I called it Realtime Regs.

        Show
        Aaron Daniel (Inactive) added a comment - The patch already has that under the Realtime SIP Settings section, I called it Realtime Regs.
        Hide
        Olle Johansson added a comment -

        is this up to date with svn trunk? If so, I'm ready for commit.

        Show
        Olle Johansson added a comment - is this up to date with svn trunk? If so, I'm ready for commit.
        Hide
        Aaron Daniel (Inactive) added a comment -

        The most recent version of the patch is up to date for svn trunk (sipregs-54521.patch). This has been active since it was created, and there haven't been any problems as of yet.

        Show
        Aaron Daniel (Inactive) added a comment - The most recent version of the patch is up to date for svn trunk (sipregs-54521.patch). This has been active since it was created, and there haven't been any problems as of yet.
        Hide
        Olle Johansson added a comment -

        Committed to svn trunk, rev 54574 with small, minor, changes.

        Thanks for your patience and for your contribution to Asterisk!

        /Olle

        Show
        Olle Johansson added a comment - Committed to svn trunk, rev 54574 with small, minor, changes. Thanks for your patience and for your contribution to Asterisk! /Olle

          People

          • Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development