[SR-Users] Freepbx 2.11.0rc1 with Asterisk 11.3.0 and Kamailio 4.0.1

[Daniel-Constantin Mierla]

Hello,

On 5/15/13 3:19 PM, Trevor Burt wrote:
>
> Dear All,
>
> using the following link:-
>
>
> http://kb.asipto.com/asterisk:realtime:kamailio-4.0.x-asterisk-11.3.0-astdb
>
> I have successfully integrated Asterisk and Kamailio on the same box 
> for testing, but am now facing the problem of getting Freepbx to use 
> the same MySQL database tables.
>
> My Kamailio and Asterisk install uses the following tables:-
>
> sipusers
> sipregs
> voicemail
> voicemail_data
> voicemail_messages
>
> However Freepbx uses the following tables.
>
> devices
> users
>
> Any idea on how I fully integrate Freepbx with my Asterisk and 
> Kamailio configuration using Mysql?
>
> My goal is to have a Kamailio LB to multiple Asterisk/Freepbx servers 
> sharing the same extension and voicemail databases.
>
> I will also probably integrate a2billing and share the a2billing 
> database between the Asterisk/Freepbx servers to create a fully 
> scalable solution.
>
> Any advice most gratefully received.
>
I'm not familair with freepbx, but probably you need to change it a bit 
not to save passwords for users in the default column, but in a custom 
one. That's the trick with kamailio-asterisk integration, the asterisk 
should not ask for user authentication.

Perhaps users table has more or less the role of sipusers, maybe devices 
is for sipregs. Anyhow, from kamailio point of view you just need to 
connect to the table storing user password and fetch it from there.

Cheers,
Daniel

-- 
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio Advanced Training, San Francisco, USA - June 24-27, 2013
   * http://asipto.com/u/katu *