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 :)