[SR-Users] Documentation "error" acc module 4.1

[Daniel-Constantin Mierla]

Hello,

thanks for pointing out. I added a note about MySQL InnoDB in the readme.

There is no ENGINE value enforced now by kamdbctl script, the default 
for MySQL is used and latest versions of mysql use innodb.

Cheers,
Daniel

On 02/01/14 16:47, Daniel Tryba wrote:
> Regarding
> http://www.kamailio.org/docs/modules/4.1.x/modules/acc.html#acc.p.db_insert_mode
>
> "If set to 1, use INSERT DELAYED to add records to accounting tables when the
> DB driver has support for it. If no INSERT DELAYED support is offered by DB
> driver, then standard INSERT is used."
>
> With the switch to InnoDB in 4.1 acc is by default no longer a table that
> supports INSERT DELAYED. Mysqld generates an error when trying INSERT DELAYED
> on a backend that doesn't support this, the driver does support delayed but is
> oblivious to this not working on acc:
>
> /usr/sbin/kamailio[19378]: ERROR: db_mysql [km_dbase.c:122]:
> db_mysql_submit_query(): driver error on query: DELAYED option not supported
> for table 'acc'
> /usr/sbin/kamailio[19378]: ERROR: <core> [db_query.c:235]: db_do_insert_cmd():
> error while submitting query
> /usr/sbin/kamailio[19378]: ERROR: acc [acc.c:504]: acc_db_request(): failed to
> insert delayed into database
>
> So beware if you use InnoDB and INSERT DELAYED. Maybe the documentation should
> mentioning the fact that the 4.1 defaults don't work for mysql. But people
> will figure this out fast when there is no accounting :)
>

-- 
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda