On 15 May 2013 14:19, Trevor Burt <trevorjburt@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@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users