scratch65...@att.net wrote on 2017/04/19 14:05:
[Default] On Wed, 19 Apr 2017 13:45:54 +0200, Miroslav Lachman
<000.f...@quip.cz> wrote:

scratch65...@att.net wrote on 2017/04/19 12:45:
[Default] On Tue, 18 Apr 2017 21:45:47 +0200, Miroslav Lachman
<000.f...@quip.cz> wrote:

Miroslav Lachman wrote on 2017/03/31 15:31:
I don't know if it was "pkg" fault or mariadb101-server and
mariadb101-client conflict.

I did standard "pkg upgrade" and at the end I have half files of
mariadb101-client missing:

# pkg check -Ba
Checking all packages: ...
pkg: fstat() failed for(/usr/local/bin/msql2mysql): No such file or
directory
pkg: fstat() failed for(/usr/local/bin/mysql_find_rows): No such file or
directory

[...]

pkg: fstat() failed for(/usr/local/man/man1/mysqlimport.1.gz): No such
file or directory
pkg: fstat() failed for(/usr/local/man/man1/mysqlshow.1.gz): No such
file or directory
pkg: fstat() failed for(/usr/local/man/man1/mysqlslap.1.gz): No such
file or directory
Checking all packages.......... done


I think this is the root cause

Checking integrity... done (2 conflicting)
     - mariadb101-server-10.1.22 conflicts with mariadb101-client-10.1.21
on /usr/local/share/mysql/maria_add_gis_sp.sql

[...]


I couldn't tell you whether you're the only one (probably not!)
but I did a pkg upgrade on everything yesterday to recover from
pkg's quarterly version skew, and mariadb *seems* to be all there
and working correctly.  I haven't done any work yet this morning,
so I'm keeping my fingers crossed.

Do you use MariaDB version 10.1?

MariaDB server is running without problems, only some "mysql client"
libraries are missing, but if you use only PHP to connect to "mysql
server" then you will not notice any problem, because PHP uses internal
mysql client.
So first time I overlooked this issue because MariaDB was running fine
and webserver was on separate machine - PHP website was still running.

Can you check this?

ls -l /usr/local/lib/mysql/libmysqlclient_r.so.18

I see "ls: /usr/local/lib/mysql/libmysqlclient_r.so.18: No such file or
directory" on each upgraded server until i run *pkg upgrade -f
mariadb101-client*

Yes, I do have that file. Could the difference in our results be
due to my having used the -f switch, which forces upgrade of
EVERYthing instead of just those bits that pkg thinks want
upgrading?

I tried it on next machine with pkg upgrade -f but the result is the same:

pkg check -Ba

Checking all packages....
(p5-DBD-mysql-4.042) /usr/local/lib/perl5/site_perl/mach/5.24/auto/DBD/mysql/mysql.so - required shared library libmysqlclient.so.18 not found
Checking all packages........
(sphinxsearch-2.2.11_1) /usr/local/bin/indexer - required shared library libmysqlclient.so.18 not found (sphinxsearch-2.2.11_1) /usr/local/bin/indextool - required shared library libmysqlclient.so.18 not found (sphinxsearch-2.2.11_1) /usr/local/bin/spelldump - required shared library libmysqlclient.so.18 not found (sphinxsearch-2.2.11_1) /usr/local/bin/wordbreaker - required shared library libmysqlclient.so.18 not found (sphinxsearch-2.2.11_1) /usr/local/sbin/searchd - required shared library libmysqlclient.so.18 not found

Miroslav Lachman

_______________________________________________
freebsd-ports@freebsd.org mailing list
https://lists.freebsd.org/mailman/listinfo/freebsd-ports
To unsubscribe, send any mail to "freebsd-ports-unsubscr...@freebsd.org"

Reply via email to