The p_usrloc module is built upon the usrloc module and provides the same usrloc export to the registrar module (for example). The usrloc module must not be loaded at the same time with the p_usrloc module. The parameters and the interface for the p_usrloc module are thus almost the same, so in this document only extra parameters (specific only to p_usrloc module) and differences are noted. For a complete description of the parameters that are inherited from usrloc see the page here. Note that the modparam statement must still refer to the p_usrloc module. The goal of the p_usrloc module is to provide partitioned user location service to Kamailio/SER. This provides three major benefits: * Redundancy Failure of a location database does not mean that the location service is down * Load Balancing DB performance is greatly increased as queries are automatically split on a pool of ID(number configurable at runtime). Furthermore, a read only db handler can be used to further increase the spread of the "select" queries. * Failover A faulty DB server is detected and taken out. When it recovers, the module makes sure that no stale contacts are returned from it. Write queries are replicated to two or more databases, depending on some distribution keys, e.g. the username and domain the subscribers. The number of databases used for replication is configurable at compile time by modifying the DB_NUM define. Its main field of application is for storing and retrieving location data. The act
| Parámetro | Tipo | Descripción |
|---|---|---|
| write_db_url | string | 3.2. read_db_url (string) 3.3. reg_db_table (string) 3.4. id_column (string) 3.5. num_column (string) 3.6. url_column (string) 3.7. status_column (string) 3.8. failover_time_column (string) 3.9. spare |
| read_db_url | string | 3.3. reg_db_table (string) 3.4. id_column (string) 3.5. num_column (string) 3.6. url_column (string) 3.7. status_column (string) 3.8. failover_time_column (string) 3.9. spare_flag_column (string) 3.10 |
| reg_db_table | string | 3.4. id_column (string) 3.5. num_column (string) 3.6. url_column (string) 3.7. status_column (string) 3.8. failover_time_column (string) 3.9. spare_flag_column (string) 3.10. error_column (string) 3.1 |
| id_column | string | 3.5. num_column (string) 3.6. url_column (string) 3.7. status_column (string) 3.8. failover_time_column (string) 3.9. spare_flag_column (string) 3.10. error_column (string) 3.11. risk_group_column (st |
| num_column | string | 3.6. url_column (string) 3.7. status_column (string) 3.8. failover_time_column (string) 3.9. spare_flag_column (string) 3.10. error_column (string) 3.11. risk_group_column (string) 3.12. expire_time ( |
| url_column | string | 3.7. status_column (string) 3.8. failover_time_column (string) 3.9. spare_flag_column (string) 3.10. error_column (string) 3.11. risk_group_column (string) 3.12. expire_time (int) 3.13. db_err_thresho |
| status_column | string | 3.8. failover_time_column (string) 3.9. spare_flag_column (string) 3.10. error_column (string) 3.11. risk_group_column (string) 3.12. expire_time (int) 3.13. db_err_threshold (int) 3.14. failover_leve |
| failover_time_column | string | 3.9. spare_flag_column (string) 3.10. error_column (string) 3.11. risk_group_column (string) 3.12. expire_time (int) 3.13. db_err_threshold (int) 3.14. failover_level (int) 3.15. db_retry_interval (in |
| spare_flag_column | string | 3.10. error_column (string) 3.11. risk_group_column (string) 3.12. expire_time (int) 3.13. db_err_threshold (int) 3.14. failover_level (int) 3.15. db_retry_interval (int) 3.16. db_use_transactions (in |
| error_column | string | 3.11. risk_group_column (string) 3.12. expire_time (int) 3.13. db_err_threshold (int) 3.14. failover_level (int) 3.15. db_retry_interval (int) 3.16. db_use_transactions (int) 3.17. db_transaction_leve |
| risk_group_column | string | 3.12. expire_time (int) 3.13. db_err_threshold (int) 3.14. failover_level (int) 3.15. db_retry_interval (int) 3.16. db_use_transactions (int) 3.17. db_transaction_level (string) 3.18. write_on_master_ |
| expire_time | int | 3.13. db_err_threshold (int) 3.14. failover_level (int) 3.15. db_retry_interval (int) 3.16. db_use_transactions (int) 3.17. db_transaction_level (string) 3.18. write_on_master_db (int) 3.19. mdb_avail |
| db_err_threshold | int | 3.14. failover_level (int) 3.15. db_retry_interval (int) 3.16. db_use_transactions (int) 3.17. db_transaction_level (string) 3.18. write_on_master_db (int) 3.19. mdb_availability_control(str) 3.20. wr |
| failover_level | int | 3.15. db_retry_interval (int) 3.16. db_use_transactions (int) 3.17. db_transaction_level (string) 3.18. write_on_master_db (int) 3.19. mdb_availability_control(str) 3.20. write_on_db (int) 3.21. conne |
| db_retry_interval | int | 3.16. db_use_transactions (int) 3.17. db_transaction_level (string) 3.18. write_on_master_db (int) 3.19. mdb_availability_control(str) 3.20. write_on_db (int) 3.21. connection_expires (int) 3.22. alg_ |
| db_use_transactions | int | 3.17. db_transaction_level (string) 3.18. write_on_master_db (int) 3.19. mdb_availability_control(str) 3.20. write_on_db (int) 3.21. connection_expires (int) 3.22. alg_location (int) 3.23. domain_db(s |
| db_transaction_level | string | 3.18. write_on_master_db (int) 3.19. mdb_availability_control(str) 3.20. write_on_db (int) 3.21. connection_expires (int) 3.22. alg_location (int) 3.23. domain_db(str) 3.24. default_db_type(str) 3.25. |
| write_on_master_db | int | 3.19. mdb_availability_control(str) 3.20. write_on_db (int) 3.21. connection_expires (int) 3.22. alg_location (int) 3.23. domain_db(str) 3.24. default_db_type(str) 3.25. db_ops_ruid (int) 3.26. db_upd |
| mdb_availability_control | str | 3.20. write_on_db (int) 3.21. connection_expires (int) 3.22. alg_location (int) 3.23. domain_db(str) 3.24. default_db_type(str) 3.25. db_ops_ruid (int) 3.26. db_update_as_insert (string) 3.27. default |
| write_on_db | int | 3.21. connection_expires (int) 3.22. alg_location (int) 3.23. domain_db(str) 3.24. default_db_type(str) 3.25. db_ops_ruid (int) 3.26. db_update_as_insert (string) 3.27. default_db_url(str) 3.28. match |
| connection_expires | int | 3.22. alg_location (int) 3.23. domain_db(str) 3.24. default_db_type(str) 3.25. db_ops_ruid (int) 3.26. db_update_as_insert (string) 3.27. default_db_url(str) 3.28. matching_mode(int) 3.29. UTC_timesta |
| alg_location | int | 3.23. domain_db(str) 3.24. default_db_type(str) 3.25. db_ops_ruid (int) 3.26. db_update_as_insert (string) 3.27. default_db_url(str) 3.28. matching_mode(int) 3.29. UTC_timestamps(int) 3.30. use_domain |
| domain_db | str | 3.24. default_db_type(str) 3.25. db_ops_ruid (int) 3.26. db_update_as_insert (string) 3.27. default_db_url(str) 3.28. matching_mode(int) 3.29. UTC_timestamps(int) 3.30. use_domain_crc32(str) |
| default_db_type | str | 3.25. db_ops_ruid (int) 3.26. db_update_as_insert (string) 3.27. default_db_url(str) 3.28. matching_mode(int) 3.29. UTC_timestamps(int) 3.30. use_domain_crc32(str) |
| db_ops_ruid | int | 3.26. db_update_as_insert (string) 3.27. default_db_url(str) 3.28. matching_mode(int) 3.29. UTC_timestamps(int) 3.30. use_domain_crc32(str) |
| db_update_as_insert | string | 3.27. default_db_url(str) 3.28. matching_mode(int) 3.29. UTC_timestamps(int) 3.30. use_domain_crc32(str) |
| default_db_url | str | 3.28. matching_mode(int) 3.29. UTC_timestamps(int) 3.30. use_domain_crc32(str) |
| matching_mode | int | 3.29. UTC_timestamps(int) 3.30. use_domain_crc32(str) |
| UTC_timestamps | int | 3.30. use_domain_crc32(str) |
| use_domain_crc32 | str | 3.1. write_db_url (string) |
Copyright © 2007 1&1 Internet AG