Not sure what to do but I keep receiving an error file on the mysql-server 5.7.23-0
I am running Ubuntu 16.04
Help!
73
john
(Reading database ... 292070 files and directories currently installed.)
Preparing to unpack .../mysql-server-5.7_5.7.23-0ubuntu0.16.04.1_amd64.deb ...
Aborting downgrade from (at least) 10.0 to 5.7.
If are sure you want to downgrade to 5.7, remove the file
/var/lib/mysql/debian-*.flag and try installing again.
dpkg: error processing archive /var/cache/apt/archives/mysql-server-5.7_5.7.23-0ubuntu0.16.04.1_amd64.deb (--unpack):
subprocess new pre-installation script returned error exit status 1
Selecting previously unselected package mysql-server.
Preparing to unpack .../mysql-server_5.7.23-0ubuntu0.16.04.1_all.deb ...
Unpacking mysql-server (5.7.23-0ubuntu0.16.04.1) ...
Selecting previously unselected package cqrlog.
Preparing to unpack .../cqrlog_2.3.0-1~xenial_amd64.deb ...
Unpacking cqrlog (2.3.0-1~xenial) ...
Processing triggers for bamfdaemon (0.5.3~bzr0+16.04.20180209-0ubuntu1) ...
Rebuilding /usr/share/applications/bamf-2.index...
Processing triggers for desktop-file-utils (0.22-1ubuntu5.2) ...
Processing triggers for gnome-menus (3.13.3-6ubuntu3.1) ...
Processing triggers for mime-support (3.59ubuntu1) ...
Processing triggers for man-db (2.7.5-1) ...
Errors were encountered while processing:
/var/cache/apt/archives/mysql-server-5.7_5.7.23-0ubuntu0.16.04.1_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)
Using the broken filter I feel mysql had been repaired so I started the download again only to receive this:
john@JohnsComputer:~$ sudo apt-get install cqrlog
Reading package lists... Done
Building dependency tree
Reading state information... Done
cqrlog is already the newest version (2.3.0-1~xenial).
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
mysql-server : Depends: mysql-server-5.7 but it is not going to be installed
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).
No idea what to do now.
HI!
So what is the actual problem?
It seems that you have cqrlog installed already. And suppose you have mysql server, too.
If you open command console you may check that you really have mysql:
Typing command "mysql -V" should tell the version, "mysql" alone may give error, but "sudo mysql" should work at least.
[saku@tpad ~]$ mysql -V
mysql Ver 15.1 Distrib 10.2.16-MariaDB, for Linux (x86_64) using readline 5.1
[saku@tpad ~]$ mysql
ERROR 1045 (28000): Access denied for user 'saku'@'localhost' (using password: NO)
[saku@tpad ~]$ sudo mysql
[sudo] salasana henkilölle saku:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 9
Server version: 10.2.16-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> quit
Bye
[saku@tpad ~]$
If you got something similar then type "cqrlog debug=1" to start cqrlog in debug mode.
If it does not start ok cut last lines (if there is a lot, just abt 30 from end) and paste here so we can see what is the reason cqrlog that does not work.
--
Saku
OH1KH
When trying to run cqrlog this is the error message I receive.
"Error during connection to database: TMySQL57Connection : Server connect failed."
The cqrlog database connection window shows the username as cqrlog but there is no entry for the password. What should the password be?
Choosing 'connect' I receive this error message "Error during connection to database: TMySQL57Connection : Server connect failed."
Hi!
At Database connection window (for first start):
- did you select "Save data to local machine" ? If so it should be: address localhost (or 127.0.0.1), port 64000, user cqrlog password cqrlog (showing dots).
- if you did not select it: It should be localhost (or any other mysql server's ip in network), port 3306, user and password what you have initiated at mysql you are going to use server.
If you try that here is a copy of my other message to explain what to do:
Open console and give:
sudo mysql
If your mysql-server is properly installed and running you should get prompt:
saku@NanoPi-Neo:~$ sudo mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 38
Server version: 10.0.36-MariaDB-0ubuntu0.16.04.1 Ubuntu 16.04
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
Then write line:
GRANT ALL PRIVILEGES ON *.* TO 'cqrlog'@'%' IDENTIFIED BY 'cqrlog';
You will get response like:
Query OK, 0 rows affected (0.04 sec)
Then type:
quit
Go back to cqrlog "Database connection" window. Keep address 127.0.0.1 (or "localhost") but change port from 64000 to 3306.
username is cqrlog and password is cqrlog.
uncheck "Save log data to local machine"
If this is first run wait a while when cqrlog creates first empty log. On second run (and after that) you should see a list of logs available.
Then just select log and press "Open log"
I have found out that sometimes things work better if you do not check "Save data to local machine" and do the steps above to use mysql server running at port 3306 on local, or any networked machine.
--
Saku
OH1KH
"At Database connection window (for first start):
- did you select "Save data to local machine" ? If so it should be: address localhost (or 127.0.0.1), port 64000, user cqrlog password cqrlog (showing dots)."
I did not. Followed your instructions and the program runs and able to connect to local node and log.
"Open console and give:
sudo mysql
If your mysql-server is properly installed and running you should get prompt:
saku@NanoPi-Neo:~$ sudo mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 38
Server version: 10.0.36-MariaDB-0ubuntu0.16.04.1 Ubuntu 16.04
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others."
john@JohnsComputer:~$ sudo mysql
[sudo] password for john:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 33
Server version: 10.0.36-MariaDB-0ubuntu0.16.04.1 Ubuntu 16.04
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
Things look ok Saku?
73
john
> I did not. Followed your instructions and the program runs and able to connect to local node and log.
If I understand right all is now ok (and you are using "Save data to local machine" ) ?
If so, you do not need to worry about the rest of message downwards from:
>Open console and give:
>sudo mysql
You do not need that way to connect to log database then. (unless you want to use external mysql server, or the 3306 port service at your own PC that gives some benefits, but needs more nerd skills).
Just use "Save data to local machine" and enjoy cqrlog !
--
Saku
OH1KH
ohn@JohnsComputer:~$ cqrlog debug=1
Cqrlog Ver:2.3.0 (001) Date:2018-06-17
**** DEBUG LEVEL 1 ****
SSL libraries:
/lib/x86_64-linux-gnu/libssl.so.1.0.0
/lib/x86_64-linux-gnu/libcrypto.so.1.0.0
Loading libmysqlclient: /usr/lib/x86_64-linux-gnu/libmysqlclient.so
**************************
MySQL version: 5.7
**************************
**********************************
MySQL version assigned: 5.7
**********************************
Loaded 117920 LoTW users
Loaded 115230 eQSL users
Loaded 39772 SCP calls
*
User home directory: /home/john/
Program home directory: /home/john/.config/cqrlog/
Data directory: /home/john/.config/cqrlog/database/
Memebers directory: /home/john/.config/cqrlog/members/
ZIP code directory: /usr/share/cqrlog/zipcodes/
Binary dir: /usr/bin/
Share dir: /usr/share/cqrlog/
TConnection to MySQL: 5.7
*
56 us states loaded