Just another couple of questions:
- now the tables are added simply when is run kamdbctl create?
- the modules read properly the infos from the db or are there others
open issues (i tried with my db, modified by hand, to registrate a user,
and it was ok; then i tried to make a call to another user, but i receive a
Forbidden: you must register with a S-CSCF first)?
Andrea
On Fri, Apr 4, 2014 at 10:13 AM, Andrea Meroni <rucola8968(a)gmail.com>wrote;wrote:
Ok, thank you very much
On Fri, Apr 4, 2014 at 10:06 AM, Jason Penton <
jason.penton(a)smilecoms.com> wrote:
> master, yes
>
> utils/kamctl/mysql/
>
>
> On Fri, Apr 4, 2014 at 11:02 AM, Andrea Meroni <rucola8968(a)gmail.com>wrote;wrote:
>
>> Many many thanks ... Is it in examples/pcscf? In the master branch?
>>
>>
>> On Fri, Apr 4, 2014 at 10:00 AM, Jason Penton <
>> jason.penton(a)smilecoms.com> wrote:
>>
>>> Hi Andrea,
>>>
>>> I have just added the schema to git repo.
>>>
>>> Cheers
>>> Jason
>>>
>>>
>>> On Fri, Apr 4, 2014 at 10:17 AM, Andrea Meroni <rucola8968(a)gmail.com
>>> > wrote:
>>>
>>>> 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?
>>>>
>>>> Andrea
>>>>
>>>>
>>>> On Thu, Apr 3, 2014 at 2:49 PM, Andrea Meroni <rucola8968(a)gmail.com
>>>> > wrote:
>>>>
>>>>> Hi all,
>>>>>
>>>>> 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:
>>>>>
>>>>> ERROR: db_mysql [km_dbase.c:122]: db_mysql_submit_query: driver
>>>>> error on query: Unknown column 'aor' in 'field list'
>>>>>
>>>>> What am i missing? Consider then when i created the DB i answer
>>>>> yes to all the questions about creating additional tables ...
>>>>>
>>>>> Andrea
>>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing
>>>> list
>>>> sr-users(a)lists.sip-router.org
>>>>
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>>>>
>>>>
>>>
>>>
>>> --
>>>
>>> *Jason Penton**Senior Manager: Applications and Services* *Smile
>>> Communications Pty (Ltd)* *Mobile:* +27 (0) 83 283 7000
*Skype:*jason.barry.penton
>>> jason.penton(a)smilecoms.com <name.surname(a)smilecoms.com>
>>>
www.smilecoms.com
>>>
>>>
>>>
>>> This email is subject to the disclaimer of Smile Communications at
http://www.smilecoms.com/home/email-disclaimer/
<http://www.smilecoms.com/disclaimer>
>>>
>>>
>>> _______________________________________________
>>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing
>>> list
>>> sr-users(a)lists.sip-router.org
>>>
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>>>
>>>
>>
>> _______________________________________________
>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing
>> list
>> sr-users(a)lists.sip-router.org
>>
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>>
>>
>
>
> --
>
> *Jason Penton**Senior Manager: Applications and Services* *Smile
> Communications Pty (Ltd)* *Mobile:* +27 (0) 83 283 7000 *Skype:*jason.barry.penton
> jason.penton(a)smilecoms.com <name.surname(a)smilecoms.com>
>
www.smilecoms.com
>
>
>
> This email is subject to the disclaimer of Smile Communications at
http://www.smilecoms.com/home/email-disclaimer/
<http://www.smilecoms.com/disclaimer>
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users(a)lists.sip-router.org
>
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org