<!-- Kamailio Project uses GitHub Issues only for bugs in the code or feature requests. Please use this template only for bug reports.
If you have questions about using Kamailio or related to its configuration file, ask on sr-users mailing list:
* http://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
If you have questions about developing extensions to Kamailio or its existing C code, ask on sr-dev mailing list:
* http://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-dev
Please try to fill this template as much as possible for any issue. It helps the developers to troubleshoot the issue.
If there is no content to be filled in a section, the entire section can be removed.
You can delete the comments from the template sections when filling.
You can delete next line and everything above before submitting (it is a comment). -->
### Description
<!-- When I am installed Kamailio and send to create the database with the command: kamdbctl create It gives me an error -->
### Troubleshooting
#### Reproduction
<!-- In the installation run: kamdbctl create -->
#### Debugging Data
<!-- If you got a core dump, use gdb to extract troubleshooting data - full backtrace, local variables and the list of the code at the issue location.
gdb /path/to/kamailio /path/to/corefile bt full info locals list
If you are familiar with gdb, feel free to attach more of what you consider to be relevant. -->
``` (paste your debugging data here) ```
#### Log Messages
<!-- Check the syslog file and if there are relevant log messages printed by Kamailio, add them next, or attach to issue, or provide a link to download them (e.g., to a pastebin site). -->
``` (paste your log messages here) ```
#### SIP Traffic
<!-- If the issue is exposed by processing specific SIP messages, grab them with ngrep or save in a pcap file, then add them next, or attach to issue, or provide a link to download them (e.g., to a pastebin site). -->
``` (paste your sip traffic here) ```
### Possible Solutions
<!-- If you found a solution or workaround for the issue, describe it. Ideally, provide a pull request with a fix. -->
### Additional Information
* **Kamailio Version** - output of `kamailio -v`
``` [root@localhost ~]# kamailio -version version: kamailio 5.3.4 (x86_64/linux) 117ff9
```
* **Operating System**:
<!-- Centos 7.8 -->
``` MySQL password for root: INFO: test server charset INFO: creating database kamailio ... INFO: granting privileges to database kamailio ... INFO: creating standard tables into kamailio ... INFO: Core Kamailio tables succesfully created. Install presence related tables? (y/n): y INFO: creating presence tables into kamailio ... INFO: Presence tables succesfully created. Install tables for imc cpl siptrace domainpolicy carrierroute drouting userblacklist htable purple uac pipelimit mtree sca mohqueue rtpproxy rtpengine secfilter? (y/n): y INFO: creating extra tables into kamailio ... ERROR 1067 (42000) at line 1: Invalid default value for 'action' ERROR: Creating extra tables failed at secfilter!
```
Have a look to this commits: - b0f1486f8a656922aac02020c9e3141639f2ecb9 - 59c49af039f468466b0d853a4ceab8fe7f566215 They are already backported in 5.3 branch, but came to late for 5.3.4 release.
Closed #2328.
Hi , I am finding this similar issue while creating database in version 5.3.4
Just do that Go to path where mysql scrip is there, in my case is: cd /usr/share/kamailio/mysql/ rm -rf secfilter-create.sql wget https://raw.githubusercontent.com/kamailio/kamailio/master/utils/kamctl/mysq...
and then, try to create againg.
Best Regards,
Rodrigo Cuadra
On Fri, May 22, 2020 at 5:55 PM sudo-riyad notifications@github.com wrote:
Hi , I am finding this similar issue while creating database in version 5.3.4
— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/kamailio/kamailio/issues/2328#issuecomment-632947211, or unsubscribe https://github.com/notifications/unsubscribe-auth/AHKISLBCDOWXKITAJ5D7DQDRS4GGFANCNFSM4NBE76PA .