<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Brian, thanks a lot for your reply. <div>To put it short - I am willing to do some call visualization with simple web application based on some incoming INVITE sip header values.<div>So I've been thinking, that watching for changes to sofia (or core) db is enough to represent my data.</div><div>The ESL is probably a way to go, right ?</div><div>Regards,</div><div>Pavel.<br><br><div><hr id="stopSpelling">From: my.post@hotmail.com<br>To: freeswitch-users@lists.freeswitch.org<br>Subject: SIP headers storage in core or sofia database.<br>Date: Tue, 1 Sep 2015 18:25:04 +0600<br><br>
<style><!--
.ExternalClass .ecxhmmessage P {
padding:0px;
}
.ExternalClass body.ecxhmmessage {
font-size:12pt;
font-family:Calibri;
}
--></style>
<div dir="ltr"><font face="Times New Roman, sans-serif" size="3">Hello !<br><br></font><div><font face="Times New Roman, sans-serif" size="3">I've set up an ODBC connection for core and sofia profile like this:<br><br></font></div><div><font face="Times New Roman, sans-serif" size="3"><param name="odbc-dsn" value="pgsql://hostaddr=127.0.0.1 dbname=freeswitch user=freeswitch password='' options='-c client_min_messages=NOTICE' application_name='freeswitch'" /></font></div><div><font face="Times New Roman, sans-serif" size="3"><span style="line-height:20px;white-space:pre-wrap;"><param name="core-db-dsn" value="pgsql://hostaddr=127.0.0.1 dbname=freeswitch user=freeswitch password='' options='-c client_min_messages=NOTICE' application_name='freeswitch'" /></span></font></div><div><font face="Times New Roman, sans-serif" size="3"><span style="line-height:20px;white-space:pre-wrap;"><br></span></font></div><div><font face="Times New Roman, sans-serif" size="3">Using PgAdmin I see some tables was created in Postgres DB. I want to retrieve all SIP invite headers from this DB. What table should I look for this information if, of course, it is stored at all ?</font></div><div><font face="Times New Roman, sans-serif" size="3"><br></font></div><div><font face="Times New Roman, sans-serif" size="3">Thanks.</font></div><div><font face="Times New Roman, sans-serif" size="3"><br></font></div><div><font face="Times New Roman, sans-serif" size="3">Regards,</font></div><div><font face="Times New Roman, sans-serif" size="3">Pavel.</font></div> </div></div></div></div> </div></body>
</html>