CQRLog not working

8 posts / 0 new
Last post
G3NDC
CQRLog not working

I installed CQR and set up.
When I try to run it I get error message;

Error during connection to database. Can not load default MySQLlibrary (*libmysqlclient.so.16* or libmysqlclient.so) Check your installation.

I have tried reinstall and dealt with an error message about Spammers.
OS is Ubuntu 16.06 x64
Please keep advice simple for Linux Novice.
Ciff G3NDC

PA1SBM
PA1SBM's picture
Hi Ciff,

Hi Ciff,

In terminal: sudo apt-get install libmysqlclient18

good luck
Alex

G3NDC
CQRLog not working

Thanks Alex, I tried that and this is what I got:
cliff@cliff-desktop:~$ sudo apt-get install libmysqlclient18
[sudo] password for cliff:
Reading package lists... Done
Building dependency tree
Reading state information... Done
Package libmysqlclient18 is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source

E: Package 'libmysqlclient18' has no installation candidate
cliff@cliff-desktop:~$

So Alex, any further suggestions?
Cliff

ok2cqr
ok2cqr's picture
Re: CQRLog not working

Hi Cliff,

please try this in a terminal window:

sudo apt install libmysqlclient-dev libmysqlclient20

What source did you use to install cqrlog? Did you install it from my CQRLOG PPA or from downloaded deb file?

73 Petr, OK2CQR

G3NDC
Re; CQRLog not working

Thanks for the i/p Petr, this is what I get;

liff@cliff-desktop:~$ sudo apt install libmysqlclient-dev libmysqlclient20
[sudo] password for cliff:
Reading package lists... Done
Building dependency tree
Reading state information... Done
libmysqlclient-dev is already the newest version (5.7.16-0ubuntu0.16.04.1).
libmysqlclient20 is already the newest version (5.7.16-0ubuntu0.16.04.1).
libmysqlclient20 set to manually installed.
0 to upgrade, 0 to newly install, 0 to remove and 69 not to upgrade.
cliff@cliff-desktop:~$ ^C
cliff@cliff-desktop:~$

I installed from CQR PPa as per your earlier instruction.
Cliff

G3NDC
re; CQRLOg not working

And here are the lines from the error log

InnoDB: http://dev.mysql.com/doc/refman/5.6/en/error-creating-innodb.html
161127 18:13:00 [ERROR] Plugin 'InnoDB' init function returned error.
161127 18:13:00 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
161127 18:13:00 [Note] Plugin 'FEEDBACK' is disabled.
161127 18:13:00 [ERROR] Unknown/unsupported storage engine: innodb
161127 18:13:00 [ERROR] Aborting

161127 18:13:00 [Note] /usr/sbin/mysqld: Shutdown complete

161127 18:17:36 [Note] InnoDB: Using mutexes to ref count buffer pool pages
161127 18:17:36 [Note] InnoDB: The InnoDB memory heap is disabled
161127 18:17:36 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
161127 18:17:36 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
161127 18:17:36 [Note] InnoDB: Compressed tables use zlib 1.2.8
161127 18:17:36 [Note] InnoDB: Using Linux native AIO
161127 18:17:36 [Note] InnoDB: Using CPU crc32 instructions
161127 18:17:36 [Note] InnoDB: Initializing buffer pool, size = 80.0M
161127 18:17:36 [Note] InnoDB: Completed initialization of buffer pool
161127 18:17:36 [Note] InnoDB: Highest supported file format is Barracuda.
InnoDB: No valid checkpoint found.
InnoDB: If you are attempting downgrade from MySQL 5.7.9 or later,
InnoDB: please refer to http://dev.mysql.com/doc/refman/5.6/en/upgrading-downgrading.html
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/error-creating-innodb.html
161127 18:17:36 [ERROR] Plugin 'InnoDB' init function returned error.
161127 18:17:36 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
161127 18:17:36 [Note] Plugin 'FEEDBACK' is disabled.
161127 18:17:36 [ERROR] Unknown/unsupported storage engine: innodb
161127 18:17:36 [ERROR] Aborting

161127 18:17:36 [Note] /usr/sbin/mysqld: Shutdown complete

Cliff

G3NDC
CQRLog not working

Hi Petr. In the absence of any comment or advice I decided to abandon using CQRLog on Ubuntu 16.04.
I set up a VM Virtual box and installed Linux Mint 18. On that I installed your repository and then from that I installed cqrlog.
It worked instantly but with a lot of cautionary message about missing programs/files.
Slightly encouraged by this I went back to Ubuntu 16.04, checked that your ppa was installed and tried to reinstall cqrlog. It appeared to install but took me back to the same error massages as reported above.
CQRLog does not work ....... for me
Cliff

ok2cqr
ok2cqr's picture
Re: CQRLog not working

Hi Cliff,

I'm sorry you didn't get any reply but I don't know what is happening with your Ubuntu/Mint. I've installed CQRLOG several times on Mint/Ubuntu and it always worked without any error message.

The error message you've pasted here looks like the data were created by newer version of MySQL and now you are using older version and trying to use it. I know there were (maybe still is) an issue with MySQL in Ubuntu and when you try to upgrade from older version it always fails because of something in MySQL but I've never seen anything like you've send :(.

73 Petr, OK2CQR