[SR-Users] Kamailio MySQL DB Creation

[Henning Westerholt]

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