Re: [SR-Users] Error in db_mysql while using presence

2019-01-10 Thread Henning Westerholt
Am Donnerstag, 10. Januar 2019, 11:01:27 CET schrieb Ravindrakumar Bhatt: > Thanks Daniel for your suggestion but i am using default database created > by kamdbctl create so database engine is surely InnoDB. > As per your suggestion Henning, i have checked query logs of mysql and i > noticed one st

Re: [SR-Users] Error in db_mysql while using presence

2019-01-10 Thread Ravindrakumar Bhatt
Thanks Daniel for your suggestion but i am using default database created by kamdbctl create so database engine is surely InnoDB. As per your suggestion Henning, i have checked query logs of mysql and i noticed one strange thing that even kamailio is sending query for watcher table it is only locki

Re: [SR-Users] Error in db_mysql while using presence

2019-01-09 Thread Daniel-Constantin Mierla
Hello, just throwing blindly a suggestion here: check the database table types, if you did the installation very long time ago, it might be MyISAM and iirc, it may require to change it to InnoDB in order to enable some of the features related to transactions and locking. Cheers, Daniel On 09.01.

Re: [SR-Users] Error in db_mysql while using presence

2019-01-09 Thread Henning Westerholt
Am Mittwoch, 9. Januar 2019, 09:47:07 CET schrieb Ravindrakumar Bhatt: > I tried on command line with LOCK TABLES watchers write; and it works > fine. also i am usinf root@localhost with all permissions still same errors > show continuously. please tell if any more details are required for same. >

Re: [SR-Users] Error in db_mysql while using presence

2019-01-08 Thread Henning Westerholt
Am Dienstag, 8. Januar 2019, 14:57:21 CET schrieb Ravindrakumar Bhatt: > I am using latest kamailio stable version. i have used it for presenece and > BLF. i am facing issue in presence related method when i am setting > sub_db_mode to any db related mode like 3. Hello Ravindrakumar, the presence

[SR-Users] Error in db_mysql while using presence

2019-01-08 Thread Ravindrakumar Bhatt
Hello, I am using latest kamailio stable version. i have used it for presenece and BLF. i am facing issue in presence related method when i am setting sub_db_mode to any db related mode like 3. Version : version: kamailio 5.2.0 (x86_64/linux) 535e13 flags: STATS: Off, USE_TCP, USE_TLS, USE_SCTP, T