MySQL issue

9 posts / 0 new
Last post
w3khg
MySQL issue

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)

w3khg
Using the broken filter I

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.

oh1kh
Using the broken filter I

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

w3khg
When trying to run cqrlog

When trying to run cqrlog this is the error message I receive.

"Error during connection to database: TMySQL57Connection : Server connect failed."

w3khg
The cqrlog database

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."

oh1kh
The cqrlog database

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

w3khg
"At Database connection

"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

oh1kh
"At Database connection

> 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

w3khg
ohn@JohnsComputer:~$ cqrlog

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