When cqrlog is opened the screen with the bug and version show and the log selector box comes up with a third box that server connection did not work.
Today 1.81 came in and was installed. Then the computer locked up. No response from keyboard or mouse. FInally killed computer with power button. After that cqrlog will not run. i forced back to version 1.73 and still would not run. then upgraded to 1.81 again and same results. it cannot connect to the database server or whatever that is.
complete dismantle here to take down desk and put station on new table being delivered tomorrow. this could not have come at a worse time.
any help would be appreciated.
73
BENNY K5KV
Wed, 2014-08-13 20:06
#1
Cqrlog fails to connect to database. Does not load or run past intro screen
THERE HAS TO BE A BETTER WAY BUT I HAD NO CHOICE DUE TO TIME PRESSURE.
DOING A COMPLETE UNINSTALLOR REMOVAL OF CQRLOG WITH SYNAPTIC AND RENAMING THE REMAIINING CQRLOG DIRECTORY UNDER .CONFIG TO "OLDCQRLOG" AND THEN A COMPLETE NEW INSTALLATION FINALLY GOT CQRLOG WORKING AGAIN.
MAYBE A FUTURE VERSION WONT LOCK UP LIKE THIS?
73
BENNY K5KV
Benny,
I have the same problem. I cannot connect to the database. This leaves CQRLOG completely unusable.
I tried to connect to localhost which is 127.0.0.1 with a username of cqrlog and password is BLANK that is nothing for a password. These were the default settings - these must have been set automatically when cqrlog installed.
I press Connect and I receive this message: "Error during connection to database: Server connect failed."
I don't know if it is just a bug - as your message says - or a possible corruption of the database file.
This program should automatically backup the database if it is that important.
I have NOT done what you suggest, but I am running cqrlog Version=1.7.4
(gdb) runStarting program: /usr/bin/cqrlog warning: Could not load shared library symbols for linux-gate.so.1.Do you need "set solib-search-path" or "set sysroot"?[Thread debugging using libthread_db enabled]Using host libthread_db library "/usr/lib/libthread_db.so.1".**** DEBUG LEVEL 0 ******** CHANGE WITH --debug=1 PARAMETER ****[New Thread 0xb5f7cb40 (LWP 22915)][Thread 0xb5f7cb40 (LWP 22915) exited][New Thread 0xb5f7cb40 (LWP 22916)][New Thread 0xb4e77b40 (LWP 22917)]
I hope this is helpful to the authors.
73
David N1EA
CQRLOG IS DEAD AGAIN WITH "CANNOT CONNECT TO DATABASE". CAN SOMEONE PLEASE TELL ME NOW TO FIX THIS WITHOUT A COMPLETE NEW INSTALL?
Hi Benny,
please look at ~/.config/cqrlog/database/mysql.err file. There will be more information.
161, Petr
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Sounds similar to my issues. Petr, I sent you an email with the info you asked for.
WIll WC2L
Hi Will,
I alredy sent you an email with solution. This is only for other users who could have the same problem.
This is interesting part of ~/.config/cqrlog/database/mysql.err:
InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytesInnoDB: than specified in the .cnf file 0 5242880 bytes!
To solve this problem, open ~/.config/cqrlog/database/mysql.cnf and just after [mysqld] add this:
innodb_log_file_size=50331648
Save the file and run CQRLOG.
It seems this have something to do with different default MySQL configuration in different distributions.
73 Petr, OK2CQR
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
<p>I have the same problem. I couldn't even find that file on my system.</p>
<p>oops!!! I found the file mysql.cnf and added the line suggested. Now I'm being told the database won't start and is it installed properly.</p>
I went back to mysql.cnf and removed the earlier line.
When I loaded cqrlog I get a simple database window but still cannot create a log. I tried to use log No1 and m0ddr but I get the reply "Error executing query Table cqrlog_main already exists" It makes no difference if I log to the local machine or not.
I looked at the error log but it might as well be in Chinese, I cannot understand what it is trying to tell me.
I BACKUP MY ENTIRE "DATABASE" DIRECTORY AFTER I SHUTDOWN CQRLOG WITH THE UBUNTU BACKUP. MY COMPUTER LOCKED UP ON MAR 3. I RESTORED THE "DATABASE" DIRECTORY TO MARCH 1. CQRLOG RUNS AGAIN AND I ADDED A FEW MISSING QSOS FROM ADIF EXPORT AND IT WORKS AGAIN. THEN UPDATED TO 1.9.0.
THE RESTORE BACK TO MARCH 1 WIPED OUT ALL MYSQL.ERR FILE DATA FROM MARCH 1 TO MARCH 5. GONE. I HAVE DATA FOR MARCH 1 AND MARCH 5 ONLY. MYSQL.ERR DOES NOT SHOW THE DATES NEEDED.
WHAT IS THE FILE OR FILES THAT NEED TO BE RESTORED TO MAKE CQRLOG WORK AGAIN WHEN IT CANT FIND THE DATABASE?
73
BENNY K5KV
same here on debian 8
Error during connection to database: Server connect failed.
strange , but luckyli it is in the repositories so that's better than deb9 :)
any tips on getting him over first start ?
never mind fixed it