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…
"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