[SR-Users] Integrating Kamailio 4.x with Freeswitch using Postgresql

Hello All,

I have been following bits of this guide http://kb.asipto.com/freeswitch:kamailio-3.3.x-freeswitch-1.2.x-sbc and bits from other posts to get Kamailio 4.0 integrated with FusionPBX & Freeswitch 1.2.12 using Postgres instead of MySQL.

My reason for using Postgres is simply because Freeswitch now supports Postgres natively and FusionPBX also uses Postgres for its backend DB. So it made sense to keep things consistent.

The main functions of Kamailio in this scenario are as follows:

- NAT Traversal - Security, Anti-flood, some DDOS attack protection - Load-balancing in future

So far I have the registrations working somewhat and the registrations are visible in the Kamailio locations table but I also Freeswitch also needs to have access to these registrations as well so that we have access to the functionality within FusionPBX.

Here are the relevant bits of my script with the real public IPs substituted:

#######

# *** Value defines - IDs used later in config #!ifdef WITH_PGSQL #!define DBURL "postgres://kamailio:kamailiorw@localhost/kamailio" #!endif . . #!ifdef WITH_FREESWITCH #!define DBFSURL "postgres://fusionpbx:fusionpbx@1.2.3.4:5432/fusionpbx" #!endif . . #!ifdef WITH_FREESWITCH freeswitch.bindip = "1.2.3.4" desc "FreeSWITCH IP Address" freeswitch.bindport = "5060" desc "FreeSWITCH Port" # kamailio.bindip = "2.2.2.2" desc "Kamailio IP Address" kamailio.bindport = "5065" desc "Kamailio Port" #!endif . . #!ifdef WITH_POSTGRES loadmodule "db_postgres.so" #!endif . . . # ----- usrloc params ----- /* enable DB persistency for location entries */ #!ifdef WITH_USRLOCDB modparam("usrloc", "db_url", "postgres://kamailio:kamailiorw@localhost /kamailio") modparam("usrloc", "db_mode", 2) modparam("usrloc", "use_domain", MULTIDOMAIN) #!endif

# ----- auth_db params ----- #!ifdef WITH_AUTH modparam("auth_db", "calculate_ha1", yes) modparam("auth_db", "load_credentials", "")

#!ifdef WITH_FREESWITCH modparam("auth_db", "user_column", "extension") modparam("auth_db", "password_column", "password") modparam("auth_db", "domain_column", "user_context") modparam("auth_db", "db_url", DBFSURL) modparam("auth_db", "version_table", 0) modparam("auth_db", "use_domain", MULTIDOMAIN) #!else modparam("auth_db", "db_url", DBURL) modparam("auth_db", "password_column", "password") modparam("auth_db", "use_domain", MULTIDOMAIN) #!endif . . # authentication route(AUTH);

# record routing for dialog forming requests (in case they are routed) # - remove preloaded route headers remove_hf("Route"); if (is_method("INVITE|SUBSCRIBE")) record_route_preset("2.2.2.2");

# account only INVITEs if (is_method("INVITE")) { setflag(FLT_ACC); # do accounting }

# dispatch requests to foreign domains route(SIPOUT);

# handle presence related requests route(PRESENCE);

# handle registrations route(REGISTRAR);

if ($rU==$null) { # request with no Username in RURI sl_send_reply("484","Address Incomplete"); exit; } . . . # Authentication route route[AUTH] { #!ifdef WITH_AUTH

#!ifdef WITH_FREESWITCH # do not auth traffic from FreeSWITCH - trusted! if(route(FROMFREESWITCH)) return; #!endif

#!ifdef WITH_IPAUTH if((!is_method("REGISTER")) && allow_source_address()) { # source IP allowed return; } #!endif

if (is_method("REGISTER") || from_uri==myself) { # authenticate requests #!ifdef WITH_FREESWITCH if (!auth_check("$fd", "v_extensions", "1")) { #!else if (!auth_check("$fd", "subscriber", "1")) { #!endif auth_challenge("$fd", "0"); exit; } # user authenticated - remove auth header if(!is_method("REGISTER|PUBLISH")) consume_credentials(); } # if caller is not local subscriber, then check if it calls # a local destination, otherwise deny, not an open relay here if (from_uri!=myself && uri!=myself) { sl_send_reply("403","Not relaying"); exit; }

#!endif return; } . . . # Routing to foreign domains route[SIPOUT] { if (!uri==myself) { append_hf("P-hint: outbound\r\n"); route(RELAY); } } . . . # Handle SIP registrations route[REGISTRAR] { if (is_method("REGISTER")) { if(isflagset(FLT_NATS)) { setbflag(FLB_NATB); # uncomment next line to do SIP NAT pinging setbflag(FLB_NATSIPPING); } # without param, here would allows multiple contacts, with 0x04 param, last register wins (fifo) #if (!save("location")) if (!save("location", "0x04")) sl_reply_error();

#!ifdef WITH_FREESWITCH route(REGFWD); #!endif

exit; } } . . . #######

I hope I haven't missed anything important.

With my current config I am able to dial feature code in FusionPBX and also make outbound calls but not able to dial between extensions because as far as Freeswitch is concerned the extensions are not registered.

Any assistance would be greatly appreciated.

Thanks

Errol