Re: [SR-Users] Kamailio MySQL DB Creation

Hello Daniel, Thanks for your quick reply. You're right it's shell but got this MySQL password for root: INFO: test server charset Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. INFO: creating database kamailio ... Warning: Using a password on the command line interface can be insecure. INFO: granting privileges to database kamailio ... Warning: Using a password on the command line interface can be insecure. INFO: creating standard tables into kamailio ... Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. ERROR 1101 (42000) at line 2: BLOB/TEXT column 'body' can't have a default value ERROR: Creating core tables failed at msilo! I've followed wiki installation for Kamailio git 4.0 There is something I couldn't do you said in the wiki If you changed the password for the 'kamailio' user of MySQL, you have to update the value for 'db_url' parameters. In Fact I couldn't change it because I don't know what to put if I've change the db password @ kamdbctl Thanks, Amr From: sr-users-bounces(a)lists.sip-router.org [mailto:sr-users-bounces@lists.sip-router.org] On Behalf Of Daniel-Constantin Mierla Sent: Tuesday, March 12, 2013 10:53 AM To: Kamailio (SER) - Users Mailing List Subject: Re: [SR-Users] Kamailio MySQL DB Creation Hello, could be sh (shell) constrain issue. Can you execute the script with bash? Cheers, Daniel On 3/12/13 7:53 AM, Amr Elsharqawi wrote: Hello Kamailio Community!! I am newbie to Kamailio & SIP. And I am interested in Kamailio. I've used asterisk for some time then I heard about FreeSWITCH unfortunately FreeSWITCH was not good enough for me like Asterisk. I've found NAT problem with Asterisk Finally I've decided to work with Kamailio as SIP server & Asterisk as PBX. to be fair I need to learn more about FreeSWICH to test it well. My Question is about Kamailio installation; I am using FreeBSD 9 attached my uname -a FreeBSD PBX.XXXXX 9.1-RELEASE FreeBSD 9.1-RELEASE #0 r243826: Tue Dec 4 06:55:39 UTC 2012 root@obrian.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC i386 I've used gmake for building, compiling and installation. Everything goes smooth EXCEPT mysql db installation when I use sh /usr/local/sbin/kamdbctl create I am getting the following error: /usr/local/lib/kamailio//kamctl/kamdbctl.base: 36: Syntax error: Missing '}' Thanks a lot for your valuable time and that amazing project (Kamailio). Amr _______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users(a)lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users -- Daniel-Constantin Mierla - http://www.asipto.com http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda Kamailio World Conference, April 16-17, 2013, Berlin - http://conference.kamailio.com -