Upgrade instructions ==================== From version 6.6.x to version 6.7.0 Apply the changes from setup/mysql/alter_tables.mysql Changes in global.inc configuration file: - Replace $RatingEngine['CDRS_class'] with $RatingEngine['cdr_source'] - Replace db_class_siponline with db_registrar - Replace $CDRToolModules=array("openser") to $CDRToolModules=array("opensips") - Replace datasource name ser_radius with opensips_radius - Replace OpenSERQuota to OpenSIPSQuota - Replace AccountsDBClass to db_subscribers - Replace DB_openser to DB_opensips - Replace sipTraceDataSource with sipTrace - Replace mediaTraceDataSource with mediaTrace - Replace mediaServers used by MediaProxy1 with mediaDispatcher used by MediaProxy2 in the format tls:hostname:port - Add mediaTrace to the sip_trace datasource - Move if present $CDRTool['normalize']['E164Class'] to E164_class inside each datasource Changes in /etc/cron.d/cdrtool: - Replace the path scripts/SER/ with scripts/OpenSIPS Grant access to the datasource opensips_radius in the Login page for accounts that had acesss to ser_radius. Version 5.3.0 ------------- Support for ENUM based discounts require the following changes: 1. Setup OpenSER to log a new Radius attribute ENUM-TLD: modparam("acc", "radius_extra", "Sip-RPid=$avp(s:rpid); \ ... ENUM-TLD=$avp(s:enum_tld)") if (enum_query("e164.arpa.")) { xlog("L_INFO", "Found E2U+sip address in e164.arpa: $ru"); avp_delete("$avp(s:enum_tld)/g"); avp_write("e164.arpa", "$avp(s:enum_tld)"); } 2. update OpenSER radius dictionary with: ATTRIBUTE ENUM-TLD 232 string 3. reload the SQL stored procedures into the radius database from: setup/radius/OpenSER/radius_accounting.proc 4. update Freeradius OpenSER dictionary with: ATTRIBUTE ENUM-TLD 232 string 5. update Freeradius configuration with the new configuration from: setup/radius/OpenSER/radius_accounting.conf 6. restart Feeradius server 7. rename the column FramedProtocol to ENUMtld in all radiusYYYYMMDD tables. This operation can take a long time to complete depending on the number of records in the table. During this modification no accounting records can be written to the table. When using table auto-rotation with SQL stored procedures, it is best to apply these changes in the first day of the month imediately after the table rotation moment. alter table radacctYYYMMDD change column FramedProtocol ENUMtld varchar(64) not NULL; 8. apply the changes from setup/mysql/alter_tables.mysql Version 9.9.0 ------------- Reload the SQL stored procedures into the radius database from: setup/radius/OpenSIPS/radius_accounting.proc Update Freeradius sql configuration: setup/radius/OpenSIPS/sql.conf