Kamailio MySQL DB Creation

List overview All Threads
Download

newer

older

File kamailio_fifo is removed...

Strange TLS issue

Amr Elsharqawi

12 Mar 2013 12 Mar '13

2:53 a.m.

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

Attachments:

attachment.html (text/html — 1.3 KB)

Show replies by date

Daniel-Constantin Mierla

12 Mar 12 Mar

3:52 a.m.

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 -

Amr Elsharqawi

4:14 a.m.

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

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

Henning Westerholt

4:26 a.m.

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@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@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@lists.sip-router.orgmailto: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!!

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/GENERICmailto: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.orgmailto: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 -

Amr Elsharqawi

4:33 a.m.

Hello Henning,

MySQL Version is 5.6.10

Amr

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

Hello Amr,

Best regards,

Henning

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

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

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

Amr Elsharqawi

7:24 a.m.

Hello,

What version of MySQL I should use?

Amr

From: sr-users-bounces@lists.sip-router.org [mailto:sr-users-bounces@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

Hello Amr,

Best regards,

Henning

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

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

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

Henning Westerholt

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

4384

Age (days ago)

4384

Last active (days ago)

sr-users@lists.kamailio.org

6 comments

3 participants

tags (0)

participants (3)

Amr Elsharqawi
Daniel-Constantin Mierla
Henning Westerholt