Database Administration: UDR and SDR [Документация VAS Experts]
Документация VAS Experts Документация VAS Experts-mobile
in

Settings

  • Show page
  • Old revisions
  • Export to PDF
  • Fold/unfold all
  • ODT export
  • Backlinks
  • Show page
  • Old revisions
  • Export to PDF
  • Fold/unfold all
  • ODT export
  • Backlinks

    • Differences

    This shows you the differences between two versions of the page.

    Link to this comparison view

    Both sides previous revisionPrevious revision
    en:dpi:dpi_components:platform:dpi_admin:admin_db [2025/07/17 07:25] – elena.krasnobryzhen:dpi:dpi_components:platform:dpi_admin:admin_db [2026/04/08 08:43] (current) – [Database Administration: UDR and SDR] elena.krasnobryzh
    Line 10: Line 10:
     <note warning>Global rules for vlan drop/pass/hide/permit, previously set using the CLI command vlan group, will be converted and moved from UDR to SDR and deleted from UDR. When downgrading from version 14 to 13, data from SDR will be lost, so manual transfer is required by saving a copy of SDR before the update.</note> <note warning>Global rules for vlan drop/pass/hide/permit, previously set using the CLI command vlan group, will be converted and moved from UDR to SDR and deleted from UDR. When downgrading from version 14 to 13, data from SDR will be lost, so manual transfer is required by saving a copy of SDR before the update.</note>
      
    -**List of Tables in UDR**+===List of Tables in UDR===
     ^ Table             ^ Purpose                                                       ^ ^ Table             ^ Purpose                                                       ^
     | bindings          | Link between login and address                               | | bindings          | Link between login and address                               |
    Line 21: Line 21:
     | vchannel_policing | Policing settings for channels                               | | vchannel_policing | Policing settings for channels                               |
      
    -**SDR Structure**\\+===SDR Structure===
     In the SDR directory /var/db/dpisdr, depending on the enabled modes, the database files are located: In the SDR directory /var/db/dpisdr, depending on the enabled modes, the database files are located:
       * fdpi.mdb: general data   * fdpi.mdb: general data
    Line 41: Line 41:
     <note tip>The maximum size of each .mdb file is set by the udr_size parameter.</note> <note tip>The maximum size of each .mdb file is set by the udr_size parameter.</note>
      
    -Backup: save copies of .mdb files from the SDR directory (preferably when fastDPI is stopped)   +===Backup and Restore=== 
    -Restore: copy .mdb files to the SDR directory+  - :!: Stop fastDPI 
     +  - **Creating a backup:** save copies of the .mdb files from the SDR directory: ''/var/db/dpisdr/'' 
     +  - **Restoring a backup:** copy the saved .mdb files to the SDR directory: ''/var/db/dpisdr/''
      
     ==== Activation of Built-in UDR ==== ==== Activation of Built-in UDR ====