[SR-Users] Kamailio MySQL DB Creation

Tue Mar 12 12:24:15 CET 2013

Hello,

What version of MySQL I should use?

Amr

From: sr-users-bounces at lists.sip-router.org
[mailto:sr-users-bounces at lists.sip-router.org] On Behalf Of Amr Elsharqawi
Sent: Tuesday, March 12, 2013 11:34 AM
To: 'Henning Westerholt'; 'Kamailio (SER) - Users Mailing List'
Subject: Re: [SR-Users] Kamailio MySQL DB Creation

Hello Henning,

MySQL Version is 5.6.10

Amr

From: Henning Westerholt [mailto:henning.westerholt at 1und1.de] 
Sent: Tuesday, March 12, 2013 11:26 AM
To: Kamailio (SER) - Users Mailing List
Cc: aelsharqawi at live.com
Subject: RE: [SR-Users] Kamailio MySQL DB Creation

Hello Amr,

somehow the datatype default value that is used in the msilo table is not
understood by your mysql server. Can you specify the version of the mysql?
Maybe they changed something which is not compatible with the old ones.

Best regards,

Henning

From: sr-users-bounces at lists.sip-router.org
[mailto:sr-users-bounces at lists.sip-router.org] On Behalf Of Amr Elsharqawi
Sent: Tuesday, March 12, 2013 9:14 AM
To: miconda at gmail.com; 'Kamailio (SER) - Users Mailing List'
Subject: 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.

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/999e46fc/attachment.htm>