12 Mar
2013
12 Mar
'13
7:46 a.m.
Am Dienstag, 12. März 2013, 09:33:54 schrieb Amr Elsharqawi:
MySQL Version is 5.6.10
Amr
Hello Amr,
i think is is not related to the MySQL version. This is what I've found with
google:
"This is a result of MySQL running in "strict" mode. See
http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html for details.
Basically, you need to remove STRICT_TRANS_TABLES from sql_mode variable. You
can do that in your overall configuration file, when you start mysql, or per
session by executing SET SQL_MODE = '' (you may add any attributes you
actually need, see above link.)"
Please try to set an appropriate mode for the server and try again. Maybe you
need to delete the existing tables that were created up to the error, before
trying again.
Best regards,
Henning
From: Henning Westerholt
[mailto:henning.westerholt@1und1.de]
Sent: Tuesday, March 12, 2013 11:26 AM
To: Kamailio (SER) - Users Mailing List
Cc: aelsharqawi(a)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(a)lists.sip-router.org
[mailto:sr-users-bounces@lists.sip-router.org] On Behalf Of Amr Elsharqawi
Sent: Tuesday, March 12, 2013 9:14 AM
To: miconda(a)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.
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