How do I check to see if MySQL server is properly installed? I get a "Database Problem" error asking me to check if MySQL is installed properly.
I have pasted the last 20+ lines of my myqsl.err file as well.
Thanks in advance for any help!
Harm - VE4HAZ
180621 16:23:46 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure
180621 16:23:46 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure
180621 16:23:46 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure
180621 16:23:46 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure
180621 16:23:46 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure
180621 16:23:46 [ERROR] Native table 'performance_schema'.'users' has the wrong structure
180621 16:23:46 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure
180621 16:23:46 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure
180621 16:23:46 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure
180621 16:23:46 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
180621 16:23:46 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure
180621 16:23:46 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure
180621 16:23:46 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure
180621 16:23:46 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
180621 16:23:46 [Note] Reading of all Master_info entries succeded
180621 16:23:46 [Note] Added new Master_info '' to hash table
180621 16:23:46 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.0.34-MariaDB-0ubuntu0.16.04.1' socket: '/home/harm/.config/cqrlog/database/sock' port: 64000 Ubuntu 16.04
180621 16:51:30 [Note] /usr/sbin/mysqld: Normal shutdown
180621 16:51:30 [Note] InnoDB: FTS optimize thread exiting.
180621 16:51:30 [Note] InnoDB: Starting shutdown...
180621 16:51:31 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
180621 16:51:32 [Note] InnoDB: Shutdown completed; log sequence number 1600647
180621 16:51:32 [Note] /usr/sbin/mysqld: Shutdown complete
Open a terminal and run cqlog with --debug=1 parameter:
cqrlog --debug=1
There will be much more information what happened. I think mysqlclient libraries are not installed but without info about distribution, it's hart to help.
73 Petr
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
system Linux Mint 18.3 cinnamon 64-bit
cinnamon 3.6.6
4.13.0-45-generic
All was ok before I update to cqrlog-2.3.0. Now the log shows the qso done before but when I want to log a new qso these messages appear :
"Database upgrade crashed with this error:
TMySQL57Connection : Error executing query: Duplicate column name 'rxfreq'
TMySQL57Connection : Error executing query: Unknown column 'prop_mode' in 'field list'. "
And when I want to close the program there is this message :
"Q : Field not found : "RxFreq".
Press OK to ignore and risk data corruption.
Press Abort to kill the program."
What can I do to do the repair the right way ?
73 from Normandy