Fedora: Can not load default MySQL library

10 posts / 0 new
Last post
KF5OIM
Fedora: Can not load default MySQL library

$ cqrlog --debug=1

**** DEBUG LEVEL 1 ****

SSL libraries:
/usr/lib64/libssl.so.1.0.2m
/usr/lib64/libcrypto.so.1.0.2m
Loading libmysqlclient: /usr/lib64/mysql/libmysqlclient.so
**************************
MySQL version: 10.
**************************
**********************************
MySQL version assigned: 5.6
**********************************
Loaded 92205 LoTW users
Loaded 97499 eQSL users
Loaded 46811 SCP calls
/home/richard/.config/cqrlog/database/hobbes.localdomain.pid
Command:
kill 28366
*
User home directory: /home/richard/
Program home directory: /home/richard/.config/cqrlog/
Data directory: /home/richard/.config/cqrlog/database/
Memebers directory: /usr/share/cqrlog/members/
ZIP code directory: /usr/share/cqrlog/zipcodes/
Binary dir: /usr/bin/
Share dir: /usr/share/cqrlog/
TConnection to MySQL: 5.6
*
56 us states loaded
/usr/bin/mysqld_safe --defaults-file=/home/richard/.config/cqrlog/database/mysql.cnf --datadir=/home/richard/.config/cqrlog/database/ --socket=/home/richard/.config/cqrlog/database/sock --port=64000
Trying to connect to database
180101 08:48:13 mysqld_safe Logging to '/home/richard/.config/cqrlog/database//mysql.err'.
180101 08:48:13 mysqld_safe Starting mysqld daemon with databases from /home/richard/.config/cqrlog/database/
Can not load default MySQL library ("libmysqlclient.so.18" or "libmysqlclient.so"). Check your installation.
Trying:1
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.18" or "libmysqlclient.so"). Check your installation.
Trying:2
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.18" or "libmysqlclient.so"). Check your installation.
Trying:3
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.18" or "libmysqlclient.so"). Check your installation.
Trying:4
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.18" or "libmysqlclient.so"). Check your installation.
Trying:5
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.18" or "libmysqlclient.so"). Check your installation.
Trying:6
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.18" or "libmysqlclient.so"). Check your installation.
Trying:7
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.18" or "libmysqlclient.so"). Check your installation.
Trying:8
Closing DXCluster window
Closing TRXControl window
Closing GrayLine window
Closing dDXCC
Invalid file handle
Closing dData
/home/richard/.config/cqrlog/database/hobbes.localdomain.pid
Command:
kill 28699
Closing ini file ...

180101 08:45:08 mysqld_safe mysqld from pid file /home/richard/.config/cqrlog/database//hobbes.localdomain.pid ended
180101 08:45:27 mysqld_safe Starting mysqld daemon with databases from /home/richard/.config/cqrlog/database/
2018-01-01 8:45:27 139862457249216 [Note] /usr/libexec/mysqld (mysqld 10.2.9-MariaDB) starting as process 28366 ...
2018-01-01 8:45:27 139862457249216 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-01-01 8:45:27 139862457249216 [Note] InnoDB: Uses event mutexes
2018-01-01 8:45:27 139862457249216 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-01-01 8:45:27 139862457249216 [Note] InnoDB: Using Linux native AIO
2018-01-01 8:45:27 139862457249216 [Note] InnoDB: Number of pools: 1
2018-01-01 8:45:27 139862457249216 [Note] InnoDB: Using SSE2 crc32 instructions
2018-01-01 8:45:27 139862457249216 [Note] InnoDB: Initializing buffer pool, total size = 80M, instances = 1, chunk size = 80M
2018-01-01 8:45:27 139862457249216 [Note] InnoDB: Completed initialization of buffer pool
2018-01-01 8:45:27 139862007375616 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-01-01 8:45:27 139862457249216 [Note] InnoDB: Highest supported file format is Barracuda.
2018-01-01 8:45:27 139862457249216 [Note] InnoDB: 128 out of 128 rollback segments are active.
2018-01-01 8:45:27 139862457249216 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-01-01 8:45:27 139862457249216 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-01-01 8:45:27 139862457249216 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-01-01 8:45:27 139862457249216 [Note] InnoDB: 5.7.19 started; log sequence number 3545299
2018-01-01 8:45:27 139861633783552 [Note] InnoDB: Loading buffer pool(s) from /home/richard/.config/cqrlog/database/ib_buffer_pool
2018-01-01 8:45:27 139861633783552 [Note] InnoDB: Buffer pool(s) load completed at 180101 8:45:27
2018-01-01 8:45:27 139862457249216 [Note] Plugin 'FEEDBACK' is disabled.
2018-01-01 8:45:27 139862457249216 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2018-01-01 8:45:27 139862457249216 [Note] Server socket created on IP: '::'.
2018-01-01 8:45:27 139862457249216 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
2018-01-01 8:45:27 139862094849792 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
2018-01-01 8:45:27 139862457249216 [Note] Reading of all Master_info entries succeded
2018-01-01 8:45:27 139862457249216 [Note] Added new Master_info '' to hash table
2018-01-01 8:45:27 139862457249216 [Note] /usr/libexec/mysqld: ready for connections.
Version: '10.2.9-MariaDB' socket: '/home/richard/.config/cqrlog/database/sock' port: 64000 MariaDB Server

KF5OIM
It looks like dData.pas

It looks like dData.pas correctly finds the library and passes it to the fpc mysql module but it "forgets" where it's located and looks everywhere but where it actually is...

File: 

oh1mrr
Look my earlier post. This is

Look my earlier post. This is Fedora 27 bug...

<p>Jarmo</p>

oh1kh
Link

--
Saku
OH1KH

N3XJN
Fedora: Can not load default MySQL library

Saku,

I am assuming this bugfix has not been fixed by/for mariadb yet?
Disappointing... I waited on upgrading to 27 based on https://www.cqrlog.com/node/1915, thought a month would be enough time to have the bugfix released.
Was going to install CQRLog this week, will bookmark that link and try that work-around if needed.
Hope the bugfix is released soon.

Thanks,

---------------
73
Dan

KF5OIM
mariadb package is messed up

I agree that the mariadb package is messed up, but if cqrlog can find the library and pass the actual location it to the mysql fpc module, why can't it find it that way instead of relying on searching for it in the LD path?

KF5OIM
There are apparently multiple

There are apparently multiple problems with the package and while the update in updates-testing fixes the cqrlog problem it creates others so it will not be pushed to stable. There is a new update of 10.2.11 working its way through.

N3XJN
Fedora: Can not load default MySQL library

KF5OIM,

I'm not familiar with package tracking process.

How/where are you following the updates?

I tried some google-fu and found this: https://bodhi.fedoraproject.org/updates/FEDORA-2017-7b83201239

but wondered if there was a better method or location?

Thanks,

---------------
73
Dan

N3XJN
Fedora: Can not load default MySQL library

KF5OIM,

Should have also mentioned I found this, which may have been the more current link: https://bodhi.fedoraproject.org/updates/FEDORA-2017-ba7e224290

but original question still applies (fmi).

Thanks,

---------------
73
Dan

KF5OIM
There is a new build which

There is a new build which has not been added to an update yet:

https://koji.fedoraproject.org/koji/buildinfo?buildID=1008529

The tag shows updates-testing-candidate which means it hasn't been added to a bodhi update.