Hi all,
I am using debian jessie, I just installed kamailio 4.4 from source and trying to create kamailio database using kamdbctl but when i try to run the kamdbctl create i am getting following charset error.
/usr/local/sbin/kamdbctl create MySQL password for root: INFO: creating database kamailio ... ERROR 1115 (42000) at line 1: Unknown character set: 'ISO'
Mysql Version : 5.5.52
Thank you in advance
-- View this message in context: http://sip-router.1086192.n5.nabble.com/kamdbctl-error-tp155288.html Sent from the Users mailing list archive at Nabble.com.
Hello,
Did you run it only once? Were you asked for characters set while running the command?
Cheers, Daniel
On 23/01/2017 11:39, Venkatesh Macha wrote:
Hi all,
I am using debian jessie, I just installed kamailio 4.4 from source and trying to create kamailio database using kamdbctl but when i try to run the kamdbctl create i am getting following charset error.
/usr/local/sbin/kamdbctl create MySQL password for root: INFO: creating database kamailio ... ERROR 1115 (42000) at line 1: Unknown character set: 'ISO'
Mysql Version : 5.5.52
Thank you in advance
-- View this message in context: http://sip-router.1086192.n5.nabble.com/kamdbctl-error-tp155288.html Sent from the Users mailing list archive at Nabble.com.
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
Hi Daniel,
Thanks for your response, I think there is character set mismatch in my VM. Is there any posibility to set character set while running the command.
Thanks
-- View this message in context: http://sip-router.1086192.n5.nabble.com/kamdbctl-error-tp155288p155314.html Sent from the Users mailing list archive at Nabble.com.
Hello,
try to set CHARSET env variable either in shell, command line or kamctlrc. For example:
# CHARSET=latin1 kamdbctl create
Cheers, Daniel
On 24/01/2017 10:50, Venkatesh Macha wrote:
Hi Daniel,
Thanks for your response, I think there is character set mismatch in my VM. Is there any posibility to set character set while running the command.
Thanks
-- View this message in context: http://sip-router.1086192.n5.nabble.com/kamdbctl-error-tp155288p155314.html Sent from the Users mailing list archive at Nabble.com.
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
Thanks, Denial. It is working now.
-- View this message in context: http://sip-router.1086192.n5.nabble.com/kamdbctl-error-tp155288p155345.html Sent from the Users mailing list archive at Nabble.com.
Great! I added an option to kamctlrc to allow setting it there and make it more visible that can be changed as an option:
- https://github.com/kamailio/kamailio/commit/c58a829af6d14a7b85fa03618f58ff31...
Cheers, Daniel
On 24/01/2017 18:46, Venkatesh Macha wrote:
Thanks, Denial. It is working now.
-
Daniel-Constantin Mierla -
Venkatesh Macha