Description:
\nThere’s a small problem when using SIP Express Router (net-misc\/ser on Gentoo) with mysql support and your mysql server uses utf8 as a default character set (gentoo’s latest versions use utf8 by default). <\/p>\n
The problem: Solution 1 (remove utf8): replace it with:<\/p>\n The result: Solution 2 (reduce some column sizes): Description: There’s a small problem when using SIP Express Router (net-misc\/ser on Gentoo) with mysql support and your mysql server uses utf8 as a default character set (gentoo’s latest versions use utf8 by default). The problem: One of ser’s scripts (ser_mysql.sh) can’t handle utf8 tables. # ser_mysql.sh create MySql password for root: Domain (realm) for […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"footnotes":""},"categories":[12,3,9],"tags":[],"class_list":["post-288","post","type-post","status-publish","format-standard","hentry","category-gentoo","category-linux","category-voip"],"aioseo_notices":[],"views":6998,"_links":{"self":[{"href":"https:\/\/www.void.gr\/kargig\/blog\/wp-json\/wp\/v2\/posts\/288","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.void.gr\/kargig\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.void.gr\/kargig\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.void.gr\/kargig\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.void.gr\/kargig\/blog\/wp-json\/wp\/v2\/comments?post=288"}],"version-history":[{"count":0,"href":"https:\/\/www.void.gr\/kargig\/blog\/wp-json\/wp\/v2\/posts\/288\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.void.gr\/kargig\/blog\/wp-json\/wp\/v2\/media?parent=288"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.void.gr\/kargig\/blog\/wp-json\/wp\/v2\/categories?post=288"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.void.gr\/kargig\/blog\/wp-json\/wp\/v2\/tags?post=288"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nOne of ser’s scripts (ser_mysql.sh) can’t handle utf8 tables.
\n# ser_mysql.sh create
\nMySql password for root:
\nDomain (realm) for the default user 'admin': foobar
\ncreating database ser ...
\nERROR 1071 (42000) at line 100: Specified key was too long; max key length is 1000 bytes
\n<\/code><\/p>\n
\nChange the character set to latin1.
\nThe specified error can easily be “fixed” by editing \/usr\/sbin\/ser_mysql.sh<\/strong>. Inside that script you will find a line like this (line 38):
\nTABLE_TYPE=\"TYPE=MyISAM\"<\/code><\/p>\nTABLE_TYPE=\"TYPE=MyISAM,DEFAULT CHARACTER SET latin1\"<\/code><\/p>\n
\n# ser_mysql.sh create
\nMySql password for root:
\nDomain (realm) for the default user 'admin': foobar
\ncreating database ser ...
\n<\/code><\/p>\n
\nThe following solution makes the script run but I have not<\/strong> personally tested if ser STILL works ok after the changes. Feel free to experiment and comment back on this:
\n# sed -i 's|domain varchar(128|domain varchar(100|g' \/usr\/sbin\/ser_mysql.sh
\n# sed -i 's|contact varchar(255|contact varchar(128|g' \/usr\/sbin\/ser_mysql.sh
\n<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"