[SR-Users] Kamailio MySQL DB Creation

Tue Mar 12 09:14:29 CET 2013

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.

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.

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 at lists.sip-router.org
[mailto:sr-users-bounces at 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 at 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 at 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 -
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20130312/80701731/attachment-0001.htm>