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@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@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 -