In this chapter we will learn how to use several database back-ends to authenticate SIP requests and provide persistence of data such as location and alias tables. Primarily, we will do everything with MySQL. This chapter is divided in two parts. In the first one we will learn how to implement authentication and in the second one we will learn how to deal with calls in each direction.
By the end of this chapter you will be able to:
Configure MySQL to authenticate SIP devices
Use the
openserctl
utility for basic operations such as adding and removing usersChange the
openser.cfg
script to configure MySQL authenticationImplement persistence for the subscriber table
Implement persistence for the location tables
Restart the server without loosing the location records
Deal correctly with inbound-to-inbound, inbound-to-outbound, outbound-to-inbound, and outbound-to-outbound sessions.
Deal correctly with CANCEL Requests.