Hi,
Following http://kamailio.org/docs/tutorials/devel/kamailio-install-guide-deb/ I got to the step where I had to run kamdbctl create Unfortunately, this failed, with the following output:
INFO: test server charset INFO: creating database kamailio ... INFO: granting privileges to database kamailio ... INFO: creating standard tables into kamailio ... ERROR 1101 (42000) at line 2: BLOB/TEXT column 'body' can't have a default value ERROR: Creating core tables failed at msilo!
Searching for this error turned up http://tinyurl.com/lovr4aq , but the link in the answer is broken, and it doesn't appear that STRICT_TRANS_TABLES is relevant to my version of MySQL [1], which is 5.5.54 (running on Trisquel 7, which is based on Ubuntu Trusty).
Has anyone else encountered and overcome this problem, or does anyone have any ideas about how I might proceed?
Tim <><
Sorry; I forgot to specify the version of Kamailio I'm using: 4.0.4. <><
On 03/04/17 13:15, Tim Makarios wrote:
Hi,
Following http://kamailio.org/docs/tutorials/devel/kamailio-install-guide-deb/ I got to the step where I had to run kamdbctl create Unfortunately, this failed, with the following output:
INFO: test server charset INFO: creating database kamailio ... INFO: granting privileges to database kamailio ... INFO: creating standard tables into kamailio ... ERROR 1101 (42000) at line 2: BLOB/TEXT column 'body' can't have a default value ERROR: Creating core tables failed at msilo!
Searching for this error turned up http://tinyurl.com/lovr4aq , but the link in the answer is broken, and it doesn't appear that STRICT_TRANS_TABLES is relevant to my version of MySQL [1], which is 5.5.54 (running on Trisquel 7, which is based on Ubuntu Trusty).
Has anyone else encountered and overcome this problem, or does anyone have any ideas about how I might proceed?
Tim <><
Hello,
you run a newer version of mysql that enabled more constraints than they used to be at the time 4.0 was developed (4-5 years ago).
Any reason to install 4.0.x? These should have been fixed in 4.4 or 5.0. It is practically about removing default values for BLOB/TEXT columns. Also, I encountered issues with latest mysql versions and the datetime defaulting to '0000-00-00 ...', which used to work in older versions.
Cheers, Daniel
On 03.04.17 03:26, Tim Makarios wrote:
Sorry; I forgot to specify the version of Kamailio I'm using: 4.0.4. <><
On 03/04/17 13:15, Tim Makarios wrote:
Hi,
Following http://kamailio.org/docs/tutorials/devel/kamailio-install-guide-deb/ I got to the step where I had to run kamdbctl create Unfortunately, this failed, with the following output:
INFO: test server charset INFO: creating database kamailio ... INFO: granting privileges to database kamailio ... INFO: creating standard tables into kamailio ... ERROR 1101 (42000) at line 2: BLOB/TEXT column 'body' can't have a default value ERROR: Creating core tables failed at msilo!
Searching for this error turned up http://tinyurl.com/lovr4aq , but the link in the answer is broken, and it doesn't appear that STRICT_TRANS_TABLES is relevant to my version of MySQL [1], which is 5.5.54 (running on Trisquel 7, which is based on Ubuntu Trusty).
Has anyone else encountered and overcome this problem, or does anyone have any ideas about how I might proceed?
Tim <><
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
On 03/04/17 21:05, Daniel-Constantin Mierla wrote:
Any reason to install 4.0.x?
Because that's what the Trisquel 7 default repositories gave me, along with MySQL 5.5; it appears to have inherited both of these from Ubuntu 14.04 LTS. So it sounds like Trusty's default repositories have a version of Kamailio incompatible with their version of MySQL.
Cheers, Daniel
Thanks for your reply,
Tim <><
On 03.04.17 11:42, Tim Makarios wrote:
On 03/04/17 21:05, Daniel-Constantin Mierla wrote:
Any reason to install 4.0.x?
Because that's what the Trisquel 7 default repositories gave me, along with MySQL 5.5; it appears to have inherited both of these from Ubuntu 14.04 LTS. So it sounds like Trusty's default repositories have a version of Kamailio incompatible with their version of MySQL.
One solution to fix it is to edit the sql files located in:
/usr/share/kamailio/mysql/
Search for the BLOB/TEXT columns and just remove their default value.
Not remembering by heart if in 4.0 is present, but at some point kamdbctl got the option to add only tables per module.
Like:
kamdbctl add-tables dispatcher
which adds the tables used by dispatcher. First you have to add the 'standard' tables, then choose only the tables for the modules you know you are going to use. Before that, you may need to create the database and grant access with the 'dbonly' and 'grant' commands for kamdbctl.
This may work as alternative when you don't use the modules with the columns that have more restrictions with newer versions of mysql.
Cheers, Daniel
Thanks for those hints. At the moment, I'm just experimenting with different software like this in my spare time, so it might be a while before I try it. Or I might try installing a newer version of Kamailio instead. Or I might wait until Trisquel 8 is released. But if I get impatient, I might try what you suggested.
Thanks again,
Tim <><
On 03/04/17 21:56, Daniel-Constantin Mierla wrote:
One solution to fix it is to edit the sql files located in:
/usr/share/kamailio/mysql/
Search for the BLOB/TEXT columns and just remove their default value.
Not remembering by heart if in 4.0 is present, but at some point kamdbctl got the option to add only tables per module.
Like:
kamdbctl add-tables dispatcher
which adds the tables used by dispatcher. First you have to add the 'standard' tables, then choose only the tables for the modules you know you are going to use. Before that, you may need to create the database and grant access with the 'dbonly' and 'grant' commands for kamdbctl.
This may work as alternative when you don't use the modules with the columns that have more restrictions with newer versions of mysql.
Cheers, Daniel
Given that packaging there is not controlled by the kamailio project, building from sources can be an option -- I guess that guidelines from next link are more or less the same:
- http://kamailio.org/docs/tutorials/5.0.x/kamailio-install-guide-git/
Also, you can build the deb packages yourself, the specs are available inside pkg/kamailio/deb/.
Cheers, Daniel
On 04.04.17 01:38, Tim Makarios wrote:
Thanks for those hints. At the moment, I'm just experimenting with different software like this in my spare time, so it might be a while before I try it. Or I might try installing a newer version of Kamailio instead. Or I might wait until Trisquel 8 is released. But if I get impatient, I might try what you suggested.
Thanks again,
Tim <><
On 03/04/17 21:56, Daniel-Constantin Mierla wrote:
One solution to fix it is to edit the sql files located in:
/usr/share/kamailio/mysql/
Search for the BLOB/TEXT columns and just remove their default value.
Not remembering by heart if in 4.0 is present, but at some point kamdbctl got the option to add only tables per module.
Like:
kamdbctl add-tables dispatcher
which adds the tables used by dispatcher. First you have to add the 'standard' tables, then choose only the tables for the modules you know you are going to use. Before that, you may need to create the database and grant access with the 'dbonly' and 'grant' commands for kamdbctl.
This may work as alternative when you don't use the modules with the columns that have more restrictions with newer versions of mysql.
Cheers, Daniel
Hi,
I followed the instructions at https://www.kamailio.org/wiki/packages/debs for getting kamailio50 on Ubuntu Trusty, and it successfully got me that version on Trisquel 7.
Then, after dropping the earlier Kamailio version's MySQL database, running sudo kamdbctl create worked without a problem.
Now, time for me to see what Kamailio can do for me!
Thanks for your help,
Tim <><
On 05/04/17 22:42, Daniel-Constantin Mierla wrote:
Given that packaging there is not controlled by the kamailio project, building from sources can be an option -- I guess that guidelines from next link are more or less the same:
Also, you can build the deb packages yourself, the specs are available inside pkg/kamailio/deb/.
Cheers, Daniel
On 04.04.17 01:38, Tim Makarios wrote:
Thanks for those hints. At the moment, I'm just experimenting with different software like this in my spare time, so it might be a while before I try it. Or I might try installing a newer version of Kamailio instead. Or I might wait until Trisquel 8 is released. But if I get impatient, I might try what you suggested.
Thanks again,
Tim <><
On 03/04/17 21:56, Daniel-Constantin Mierla wrote:
One solution to fix it is to edit the sql files located in:
/usr/share/kamailio/mysql/
Search for the BLOB/TEXT columns and just remove their default value.
Not remembering by heart if in 4.0 is present, but at some point kamdbctl got the option to add only tables per module.
Like:
kamdbctl add-tables dispatcher
which adds the tables used by dispatcher. First you have to add the 'standard' tables, then choose only the tables for the modules you know you are going to use. Before that, you may need to create the database and grant access with the 'dbonly' and 'grant' commands for kamdbctl.
This may work as alternative when you don't use the modules with the columns that have more restrictions with newer versions of mysql.
Cheers, Daniel
Hello,
On 10.04.17 07:16, Tim Makarios wrote:
Hi,
I followed the instructions at https://www.kamailio.org/wiki/packages/debs for getting kamailio50 on Ubuntu Trusty, and it successfully got me that version on Trisquel 7.
great, thanks for sharing how you solved, it may help others in the future trying the Trisquel 7.
Cheers, Daniel
Then, after dropping the earlier Kamailio version's MySQL database, running sudo kamdbctl create worked without a problem.
Now, time for me to see what Kamailio can do for me!
Thanks for your help,
Tim <><
On 05/04/17 22:42, Daniel-Constantin Mierla wrote:
Given that packaging there is not controlled by the kamailio project, building from sources can be an option -- I guess that guidelines from next link are more or less the same:
http://kamailio.org/docs/tutorials/5.0.x/kamailio-install-guide-git/
Also, you can build the deb packages yourself, the specs are available inside pkg/kamailio/deb/.
Cheers, Daniel
On 04.04.17 01:38, Tim Makarios wrote:
Thanks for those hints. At the moment, I'm just experimenting with different software like this in my spare time, so it might be a while before I try it. Or I might try installing a newer version of Kamailio instead. Or I might wait until Trisquel 8 is released. But if I get impatient, I might try what you suggested.
Thanks again,
Tim <><
On 03/04/17 21:56, Daniel-Constantin Mierla wrote:
One solution to fix it is to edit the sql files located in:
/usr/share/kamailio/mysql/
Search for the BLOB/TEXT columns and just remove their default value.
Not remembering by heart if in 4.0 is present, but at some point kamdbctl got the option to add only tables per module.
Like:
kamdbctl add-tables dispatcher
which adds the tables used by dispatcher. First you have to add the 'standard' tables, then choose only the tables for the modules you know you are going to use. Before that, you may need to create the database and grant access with the 'dbonly' and 'grant' commands for kamdbctl.
This may work as alternative when you don't use the modules with the columns that have more restrictions with newer versions of mysql.
Cheers, Daniel
-
Daniel-Constantin Mierla -
Tim Makarios