This tutorial does the installation from sources, uses MySQL as database server and unixodbc for Asterisk realtime.
OPENSER XLOG PASSWORD
The authentication module in Kamailio can be configured to connect to any database and fetch the password from custom table and column, therefore creation of a database view is not really required, unless you want for other purposes. Kamailio will be used to scale Asterisk, by handling the user authentication and registration.
However, this document uses the opposite approach - use Asterisk database to get the SIP user profile.
OPENSER XLOG UPGRADE
Soon I will take the time to upgrade that document for Kamailio 3.0.x and Asterisk 1.6.2, the latest stable versions.
The approach used in that document is to use Kamailio database and create database views for Asterisk, a good approach if you started with Kamailio and want to add Asterisk for media services, mainly being about voicemail. Asterisk 1.4.x and Kamailio 1.5.x Realtime Integration