<div dir="ltr">Many many thanks ... Is it in examples/pcscf? In the master branch?<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Fri, Apr 4, 2014 at 10:00 AM, Jason Penton <span dir="ltr"><<a href="mailto:jason.penton@smilecoms.com" target="_blank">jason.penton@smilecoms.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi Andrea,<div><br></div><div>I have just added the schema to git repo.</div><div><br></div><div>Cheers</div>
<div>Jason</div></div><div class="gmail_extra"><br><br><div class="gmail_quote"><div><div class="h5">On Fri, Apr 4, 2014 at 10:17 AM, Andrea Meroni <span dir="ltr"><<a href="mailto:rucola8968@gmail.com" target="_blank">rucola8968@gmail.com</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5"><div dir="ltr"><div>Edit: i successfully make it working, by adding the proper columns in the database. However, i still have some issues ... Does anyone know where i can get a description of the DB structure of Kamailio? Especially the tables needed for the modules i mentioned in the previous mail?<span><font color="#888888"><br>
<br></font></span></div><span><font color="#888888">Andrea<br></font></span></div><div><div><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Apr 3, 2014 at 2:49 PM, Andrea Meroni <span dir="ltr"><<a href="mailto:rucola8968@gmail.com" target="_blank">rucola8968@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div><div><div>Hi all,<br><br></div>i am trying to configure an IMS Core Kamailio-based: while configuring the P-CSCF, i set up the parameters 'db_url' and 'db_mode' of the module ims_usrloc_pcscf respectively to 'mysql://kamailio:kamailiorw@localhost/kamailio' and 1 (because i want a DB for persistence). I had created successfully the DB using kamdbctl, and loaded the module 'db_mysql' in kamailio.cfg. Then i tried to run Kamailio, and i got this error:<br>
<br></div>ERROR: db_mysql [km_dbase.c:122]: db_mysql_submit_query: driver error on query: Unknown column 'aor' in 'field list'<br><br></div>What am i missing? Consider then when i created the DB i answer yes to all the questions about creating additional tables ... <br>
<span><font color="#888888">
<br></font></span></div><span><font color="#888888">Andrea<br></font></span></div>
</blockquote></div><br></div>
</div></div><br></div></div>_______________________________________________<br>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br>
<a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a><br>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr"><div><table style="width:450pt" border="0" cellpadding="0" cellspacing="0" width="600"><tbody><tr><td style="padding:0cm" valign="top"><p></p>
</td></tr></tbody></table><table style="font-family:monospace" border="0" cellpadding="0" cellspacing="0" width="320px"><tbody><tr><td style="font-family:Arial,sans-serif;font-size:16px;color:rgb(117,179,67);line-height:18px;padding-left:15px;padding-top:10px">
<strong>Jason Penton</strong></td></tr><tr><td style="font-family:Arial,sans-serif;font-size:16px;color:rgb(117,179,67);line-height:18px;padding-left:15px;padding-top:10px"><strong>Senior Manager: Applications and Services</strong></td>
</tr><tr><td style="font-family:Arial,sans-serif;font-size:16px;color:rgb(134,145,154);line-height:18px;padding-left:15px;padding-top:10px"><strong>Smile Communications Pty (Ltd)</strong></td></tr><tr><td><table cellpadding="0" cellspacing="0" width="100%">
<tbody><tr><td style="font-family:Arial,sans-serif;font-size:16px;color:rgb(134,145,154);line-height:18px;padding-left:15px;padding-top:10px" width="27%"><strong>Mobile:</strong></td><td style="font-family:Arial,sans-serif;font-size:16px;color:rgb(134,145,154);line-height:18px;padding-left:10px;padding-top:10px" width="73%">
<a href="tel:%2B27%20%280%29%2083%20283%207000" value="+27832837000" target="_blank">+27 (0) 83 283 7000</a></td></tr><tr><td style="font-family:Arial,sans-serif;font-size:16px;color:rgb(134,145,154);line-height:18px;padding-left:15px;padding-top:10px">
<strong>Skype:</strong></td><td style="font-family:Arial,sans-serif;font-size:16px;color:rgb(134,145,154);line-height:18px;padding-left:10px;padding-top:10px">
jason.barry.penton</td></tr></tbody></table></td></tr><tr><td style="font-family:Arial,sans-serif;font-size:16px;color:rgb(117,179,67);line-height:18px;padding-left:15px;padding-top:10px"><a href="mailto:name.surname@smilecoms.com" style="font-family:Arial;color:rgb(117,179,67);text-decoration:none" target="_blank">jason.penton@smilecoms.com</a></td>
</tr><tr><td style="font-family:Arial,sans-serif;font-size:16px;color:rgb(117,179,67);line-height:18px;padding-left:15px;padding-top:10px"><a href="http://www.smilecoms.com/" style="font-family:Arial;color:rgb(117,179,67)" target="_blank">www.smilecoms.com</a><br>
<img src="http://196.33.227.129/~smlcoms/sigs/pty/images/smile_signature_07_09.jpg" height="144" width="420"><br></td></tr></tbody></table></div><br></div>
</div>
<br>
<span><font color="#888888"><pre>This email is subject to the disclaimer of Smile Communications at <a href="http://www.smilecoms.com/home/email-disclaimer/" target="_blank">http://www.smilecoms.com/home/<u></u>email-disclaimer/</a><a href="http://www.smilecoms.com/disclaimer" target="_blank"></a></pre>
</font></span><br>_______________________________________________<br>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br>
<a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br>
<br></blockquote></div><br></div>