FreePBX 14 - updating mysql libraries

1

Hi everybody,

I wonder how to upgrade mysql libraries et related stuff as now mariaDB is installed. I use the freePBX pc to develop custom apps based on a remote mySQL database (v5.7.19).

When trying to install mysql clients and libs there’s a conflict with mariaDB.

“…
Resolving Dependencies
–> Running transaction check
—> Package mariadb-libs.x86_64 1:5.5.56-2.el7 will be obsoleted
…
–> Finished Dependency Resolution
Error: Package: freepbx-14.1-1.sng7.noarch (@anaconda/1707)
Requires: mariadb
Removing: 1:mariadb-5.5.56-2.el7.x86_64 (@sng-base)
mariadb = 1:5.5.56-2.el7
Obsoleted By: mysql-community-client-5.7.20-1.el7.x86_64 (mysql57-community)
Not found
Error: Package: freepbx-14.1-1.sng7.noarch (@anaconda/1707)
Requires: mariadb-server
Removing: 1:mariadb-server-5.5.56-2.el7.x86_64 (@sng-base)
mariadb-server = 1:5.5.56-2.el7
Obsoleted By: mysql-community-server-5.7.20-1.el7.x86_64 (mysql57-community)
Not found
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest
…”

Any advices ?

Cheers

Jean-Olivier

2

by the way i see also these lines in asterisk CLI :

[2017-10-19 11:34:53] WARNING[47612]: res_odbc.c:460 ast_odbc_print_errors: SQL Execute returned an error: HY000: [MySQL][ODBC 5.2(w) Driver][mysqld-5.7.19-log]Data too long for column ‘appdata’ at row 1
[2017-10-19 11:34:53] WARNING[47612]: res_odbc.c:404 ast_odbc_prepare_and_execute: SQL Execute error -1!
[2017-10-19 11:34:53] WARNING[47612]: cel_odbc.c:789 odbc_log: Insert failed on ‘asteriskcdrdb:cel’. CEL failed: INSERT INTO cel (eventtype, eventtime, cid_name, cid_num, cid_ani, cid_rdnis, cid_dnid, exten, context, channame, appname, appdata, amaflags, accountcode, uniqueid, linkedid, peer, userdeftype, extra) VALUES (‘BRIDGE_ENTER’, {ts ‘2017-10-19 11:34:53.625840’}, ‘065111702’, ‘065111702’, ‘065111702’, ‘’, ‘’, ‘s’, ‘macro-dial-one’, ‘Local/8002@from-queue-00000019;2’, ‘Dial’, ‘PJSIP/8002/sip:[email protected]:5060,trM(auto-blkvm)Ib(func-apply-sipheaders^s^1)’, 3, ‘’, ‘1508409290.153’, ‘1508409289.149’, ‘PJSIP/8002-00000067’, ‘’, ‘{“bridge_id”:“3270587e-a307-4937-95f3-65a4d2b2f10a”,“bridge_technology”:“simple_bridge”}’)

Is that also related ?

Cheers

Jean-Olivier