Hi Petr,
All now working on Linux Mint 14.04 many thanks.
73 Graeme ZL2APV
Sat, 2014-07-26 11:28
#1
CQRLog 1.8.1
CQRLOG
The world's best linux logging program!
since 2012-05-10
Seems, after this short test, also working in Fedora20...
<p>Jarmo</p>
Any help will be welcome
~$ cqrlog --debug=1
**** DEBUG LEVEL 1 ****
Loading libssl: /usr/lib/i386-linux-gnu/libssl.so
Loading libcrypto: /usr/lib/i386-linux-gnu/libcrypto.so
Loading libmysqlclient: /usr/lib/i386-linux-gnu/libmysqlclient.so.18
Loaded 73758 LoTW users
Loaded 83806 eQSL users
Loaded 43229 SCP calls
*
User home directory: /home/phil/
Program home directory: /home/phil/.config/cqrlog/
Data directory: /home/phil/.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.5
*
Closing DXCluster window
Closing TRXControl window
Closing GrayLine window
Closing dDXCC
Closing dData
(cqrlog:3846): GLib-CRITICAL **: Source ID 17 was not found when attempting to remove it
(cqrlog:3846): GLib-CRITICAL **: Source ID 16 was not found when attempting to remove it
(cqrlog:3846): GLib-CRITICAL **: Source ID 49 was not found when attempting to remove it
(cqrlog:3846): GLib-CRITICAL **: Source ID 48 was not found when attempting to remove it
(cqrlog:3846): GLib-CRITICAL **: Source ID 54 was not found when attempting to remove it
(cqrlog:3846): GLib-CRITICAL **: Source ID 53 was not found when attempting to remove it
Closing ini file ...
I was running 1.7.1 on Ubuntu 14.04LTS.
Removed 1.8.1 version then reinstalled 1.7.4 ==> connection to database works.
I will wait for more comments before trying again.
Made a copy of cqrlog folder before removing version 1.8.1 if it helps to understand the point.
Could you help me to find out where is the problem, please? Go to QSO list window, click to Filter menu and choose SQL console.
Enter this command:
select * from db_version
and click to the green button on the top left part of the window. Now it should show value in column named "nr". What the number is? Thank you!
73 Petr, OK2CQR
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
nr is 9
73 Phil, F5IYJ
Reinstalled version 1.8.1 using the deb package this time.
Same result: cannot access to the database. (and database password field is empty - tried with cqrlog as passwd, without success).
Rolled back to 1.7.4, connection to database not possible as well. Checked the box 'save log data to local machine', connection successful.
Is it linked to a passwd issue? No clue.
Could you send me the whole error message, please? In ~/.config/cqrlog/database is mysql.err file. Could you paste here a few last lines from it? Thank you!
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
sorry for my late answer, I was traveling far from my laptop
here is the error message from the mysql.err file
140731 14:10:16 InnoDB: The InnoDB memory heap is disabled
140731 14:10:16 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140731 14:10:16 InnoDB: Compressed tables use zlib 1.2.8
140731 14:10:16 InnoDB: Using Linux native AIO
140731 14:10:16 InnoDB: Initializing buffer pool, size = 80.0M
140731 14:10:16 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file ./ibdata1
140731 14:10:16 InnoDB: Could not open or create data files.
140731 14:10:16 InnoDB: If you tried to add new data files, and it failed here,
140731 14:10:16 InnoDB: you should now edit innodb_data_file_path in my.cnf back
140731 14:10:16 InnoDB: to what it was, and remove the new ibdata files InnoDB created
140731 14:10:16 InnoDB: in this failed attempt. InnoDB only wrote those files full of
140731 14:10:16 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
140731 14:10:16 InnoDB: remove old data files which contain your precious data!
140731 14:10:16 [ERROR] Plugin 'InnoDB' init function returned error.
140731 14:10:16 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140731 14:10:16 [Note] Plugin 'FEEDBACK' is disabled.
140731 14:10:16 [ERROR] Unknown/unsupported storage engine: innodb
140731 14:10:16 [ERROR] Aborting140731 14:10:16 [Note] /usr/sbin/mysqld: Shutdown complete
I was running version 1.7.3 on a fresh install of 14.04 LTS - all was good.
I then upgraded to 1.8.1 and now get an error as follows every time I try to open the QSO log:
Database upgrade crashed with this error:
:Error executing query: Duplicate column nane 'upddeleted'
If I click on "OK" in the error dialog, the application continues to run as if nothing is wrong.
Any suggestions???
Thanks
Jobst
AC0LP
This is very strange. When you start the log, the database connection with list of logs appears. Please open the console and enter this command:
mysql -S /home/ok2cqr/.config/cqrlog/database/sock where ok2cqr is my user name.
Mysql console appears. Now enter these commands:
use cqrlog001; where cqrlog001 means you are using database nr 1,
select * from db_version;
now you should see something like that:
+----+| nr |+----+| 10 |+----+1 row in set (0.00 sec)Here is everything fine, the number is 10. What number do you have there? To exit from mysql console, use quit;
Thank you!
73 Petr, OK2CQR
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
I have exactly the same problem, however after I enter: select * from db_version, I get:
MariaDB [cqrlog001]> select * from db_version ->
and I have to close the terminal window to exit.
Running Ubuntu 14.04 and latest version of CQRLOG.
Thank you
Jim - G3ZQC
Hi Jim,
you forget to enter ; at the end of the command. It should be select * from db_version;
73 Petr
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Hi Petr,
Doh! Sorry about that - all fixed now.
Thanks & 73
Jim
Hi Jobst,
thank you for your time. This is very strange, if you have database version 8, you shouldn't have "upddeleted" column in the table.
We can fix it in the mysql console
Please open the terminal and enter this command:
mysql -S /home/ok2cqr/.config/cqrlog/database/sock where ok2cqr is my user name.
Mysql console appears.
Now enter these commands:
use cqrlog001; where cqrlog001 means you are using database nr 1,
update db_version set nr=9;
quit;
Now when you open your log, it should work.I'm sorry, I have no idea what could hapeen.
73 Petr
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Error during connection to database: Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation.
I get this message on a brand new installed linux mint 17 32 bit.. older versions get the error sql database can not be installed,
Have tried to uninstall. install via terminal and install via .deb pacake... all same result... also tried to formate the drive, install mint 17, and the first thing after update, install cqr... same result....
( have still the old version 1.61 on the old drive, but not using database.. saving the logs on the local drive after some failures with database.. I had hoped a new drive, with a fresh install coud solve my problem. Have saved the logs on a stick and still have mint 12 on the old drive with the 1.61 version...
What to do ? install mint 17, install 1,7, and then update ? tired of sitting and wait for the pc to install...here is 32 degree C in the house...(sorry) I am not so familar with Linux..
Have a nice day
Vy 73 de OZ1HYI Willy oz1hyi@yahoo.dk
Maybe you check, if you have MySQL installed. I do notknow how to check with mint packages. But in console you can docommand which mysql if ok, then you get answer /usr/bin/mysql.
That's good start...
<p>Jarmo</p>
Hi, Willy
sudo apt-get install libmysqlclient18
73! Yuri RA2FT
thanks for link and ideeas to all... Have installed Mint 16, and 1,81, that works, and now I waite for some brand new hard drives to arribe, then I wil try again from scratch with Mint 17 and then see what happens... have an idea that I maybee have installed some files from a stick before install from download files from Ubuntu network ( have not the right word for it..Sorry for spelling/gramatick, and thanks again for all help. Cqrlog is the best logprogram I have tried ( and I have tried a lot).
Vy 73 de OZ1HYI Willy
I to had this dialog appear after I re-installed to new machine. I was running 1.7.3-1 on the old machine and installed 1.8.1-1~trusty on the new machine. They were both ubuntu 14.04. I took your (Petr's) advise and copied ~/.config/cqrlog/ over to the new machine after installing. Everything worked flawlessly but I did get the error dialog. I took the above advice and changed the db_version and everything is perfect. I think the above issue is probably similar. Love cqrlog BTW.
73 Tom KB1ZZV
-TC
Error during connection to database: Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation.
Is there anything i can do to fix it ?
It seems you don't have MySQL and MySQL client libraries installed. Please install related packages with software center or what Mint has.
73 Petr
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Error during connection to database: Can not load default MySQL library ("libmysqlclient.so.18" or "libmysqlclient.so"). Check your installation.
Latest debian testing and latest deb package from this. Any idea?
It seems I have to install it into virtualbox.
Please try to install libmariadbclient-dev or something like that. Debian already changed something. I don't know why they have to change things all the time.
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Hi, Peter
Latest version of libmariadbcleint-dev already installed.
Maybe it's local misconfiguration.
It's last lines of the mysql.err
2017-06-05 18:50:37 140509510953728 [Note] /usr/sbin/mysqld: Normal shutdown
2017-06-05 18:50:37 140508873606912 [Note] InnoDB: FTS optimize thread exiting.
2017-06-05 18:50:37 140509510953728 [Note] InnoDB: Starting shutdown...
2017-06-05 18:50:38 140509510953728 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-06-05 18:50:40 140509510953728 [Note] InnoDB: Shutdown completed; log sequence number 20978515
2017-06-05 18:50:40 140509510953728 [Note] /usr/sbin/mysqld: Shutdown complete
2017-06-05 18:50:44 139821944009280 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-06-05 18:50:44 139821944009280 [Note] InnoDB: The InnoDB memory heap is disabled
2017-06-05 18:50:44 139821944009280 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-06-05 18:50:44 139821944009280 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-06-05 18:50:44 139821944009280 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-06-05 18:50:44 139821944009280 [Note] InnoDB: Using Linux native AIO
2017-06-05 18:50:44 139821944009280 [Note] InnoDB: Using generic crc32 instructions
2017-06-05 18:50:44 139821944009280 [Note] InnoDB: Initializing buffer pool, size = 80.0M
2017-06-05 18:50:44 139821944009280 [Note] InnoDB: Completed initialization of buffer pool
2017-06-05 18:50:44 139821944009280 [Note] InnoDB: Highest supported file format is Barracuda.
2017-06-05 18:50:44 139821944009280 [Note] InnoDB: 128 rollback segment(s) are active.
2017-06-05 18:50:44 139821944009280 [Note] InnoDB: Waiting for purge to start
2017-06-05 18:50:44 139821944009280 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 20978515
2017-06-05 18:50:44 139821318129408 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-06-05 18:50:44 139821944009280 [Note] Plugin 'FEEDBACK' is disabled.
2017-06-05 18:50:44 139821944009280 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2017-06-05 18:50:44 139821944009280 [Note] Server socket created on IP: '::'.
2017-06-05 18:50:44 139821944009280 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
2017-06-05 18:50:44 139821943634688 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
2017-06-05 18:50:44 139821944009280 [Note] Reading of all Master_info entries succeded
2017-06-05 18:50:44 139821944009280 [Note] Added new Master_info '' to hash table
2017-06-05 18:50:44 139821944009280 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.1.23-MariaDB-8' socket: '/home/bambr/.config/cqrlog/database/sock' port: 64000 Debian 9.0
On this topic https://cqrlog.com/node/1806 working solution. Just i have problem with libssl1.0-dev
Latest version on testing a 1.1.0e-2 not a libssl1.0-dev
cqrlog installed with error "libssl1.0-dev not installed"