Authentication with database in Flexisip (Linphone SIP server)
<p>I successfully installed Flexisip on server CentOS 7.
But now I cannot config Authentication of Flexisip with database MySQL</p>

<p>My database has table users 'flexisip_users' with columns: id, username, password (not hashed).</p>

<p>This is my config:</p>

<pre><code>[module::Authentication]
enabled=true
db-implementation=odbc
datasource==DRIVER={MySQL};SERVER=localhost;DATABASE=voicechat;USER=root;PASSWORD=abc2016@123;OPTION=3;
hashed-passwords=false
request=select password from flexisip_users where username = :id
</code></pre>

<p>if I using db-implementation=file, authentication perfect working. But when i switch to 'odbc' with above config, client receive error "Internal server error'.</p>

<p>how do I fix it ?</p>