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

[Barry Flanagan]

On 15 May 2013 14:19, Trevor Burt <trevorjburt at googlemail.com> 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.
>
>
Freepbx does not use Asterisk Realtime. It writes out the database table
contents to /etc/asterisk/*.conf

That said, all the information does exist in the database, and you should
be able to either change the Kamailio auth_db parameters to match your
db_url, user_column and password_column, etc to suit, or create a view out
of the FPBX tables that Kamailio can read.

You would also need to do something similar for alias_db settings for your
sip users table so that Kamailio can resolve these. That is pretty much the
only part of the Asterisk database Kamailio needs

Having said that, if you make a change in FPBX but have not yet clicked on
the "Apply changes" (which writes out the .conf files) your database data
might be out of sync with Asterisk. Probably not a huge issue.

Hope this helps.

-Barry Flanagan



> 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.
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20130516/b04fe9ab/attachment.html>