Hi,
I have treid to install CQRLOG.
Error during connection to database: TMySQL57Connection : Server connect failed.
The second window states MySQL could not be started. please chek if the MySQL server is installed propperly.
I could not find the answer in the Faq Therefore as requested the last 20 lines of the error massage.
Hope some one hes the answer.
Regards Gerard
23-02-01T14:01:36.207532Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.32-0ubuntu0.20.04.2) starting as process 51178
2023-02-01T14:01:36.440536Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2023-02-01T14:01:36.440584Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2023-02-01T14:01:36.880254Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2023-02-01T14:01:36.901137Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-02-01T14:01:36.901182Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-02-01T14:01:36.901948Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.32-0ubuntu0.20.04.2) (Ubuntu).
2023-02-01T14:01:36.880528Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2023-02-01T14:01:36.921206Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-02-01T14:01:36.921253Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-02-01T14:01:36.922117Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.32-0ubuntu0.20.04.2) (Ubuntu).
2023-02-01T16:05:29.579285Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.32-0ubuntu0.20.04.2) starting as process 1937
2023-02-01T16:05:29.581777Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2023-02-01T16:05:29.581803Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2023-02-01T16:05:29.674726Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2023-02-01T16:05:29.676209Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-02-01T16:05:29.676333Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-02-01T16:05:29.677175Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.32-0ubuntu0.20.04.2) (Ubuntu).
HI Gerard!
You have a classic Ubuntu failure. The installation packet is built wrong allowing mysql as sql engine. It can be seen from the first error line: "(mysqld 8.0.32-0ubuntu0.20.04.2)"
If the first start of Cqrlog offered three choices (depends on Cqrlog version you installed) you can use only 2nd and 3rd options with mysql database engine.
If you select 1st option (the default), as you have now done, you must install MariaDB client and MariaDB server that will remove and replace Mysql.
If you want a clean start again (and you have no qsos in log) you can delete folder ~/.config/cqrlog
Be aware that this removes ALL logs and settings!
So it is useful only to start first time installation again from zero.
--
Saku
OH1KH
At startup I got this message:
It seems you are trying to run this program for the first time, are you going to save data to local machine?
If you say Yes, new databases will be created. This may take a while, please be patient.
The options are Yes/No. Both and in a error The error for Yes is as above.
The error for No I get a window that wants to connect to a server. If I try to do this I get a error massage stating:
Error during connection to database: TMySQL57Connection : Server connect failed.
After I tried this I tried to install MariaDB. this was not availeble in de Mint Appstore. Directly from the creator website. Things got to complex for my level of Linux knowlegde. Then I tried to download CQRLog for www.cqrllog.com I tried different version. some older and some newer than the one in de Mint appstore. non of them would install. I am getting to the end of my creativitie end open for suggestions I am using Linux Mint 20 by the way and recently updated it.
Regards Gerard/PD1GH
HI Gerard!
Ok! Your Cqrlog is then older version.
Latest will show like this:
The second option could be the one that works with your Mysql and it should not need too much knowledge as it tries to do all automated.
It is actually same as the third option, or in your version the "No" option. But those ones requires that you can create an SQL user by yourself and then fill the information to Cqrlog's database connection window.
Updating Mysql to MariaDB should not be very difficult.
For example look at this message chain. https://www.cqrlog.com/node/2507
The link that Alex provides in message does not work. Working one is https://github.com/pa1sbm/LM_CQRlog_Installer.
--
Saku
OH1KH
Hello Saku,
I treid the link you suggested. I downloaded the files and placed them in my home diirectory
Home/Gerard
This is the result when trying to run these files:
gerard@gerard-EasyNote-TJ65:~$ sudo chmod +x *.sh
gerard@gerard-EasyNote-TJ65:~$ ./LM_CQRlog_Installer.sh
bash: ./LM_CQRlog_Installer.sh: file or folder do not exist ( My comment: It is most certainly there withe the oder two files)
gerard@gerard-EasyNote-TJ65:~$ sudo ./LM_CQRlog_Installer_incl_HAMlib.sh
./LM_CQRlog_Installer_incl_HAMlib.sh: 9: Syntax error: newline unexpected
gerard@gerard-EasyNote-TJ65:~$ sudo ./LM_HAMlib_installer.sh
./LM_HAMlib_installer.sh: 9: Syntax error: newline unexpected
HI!
Did you try to give this command in command terminal?
sudo apt install mariadb-common mariadb-server mariadb-client
As you already have cqrlog insntalled that should bring the MariaDB for you.
--
Saku
OH1KH
Hi Saku,
That did the trick. CQRLOG is now up and running.
Thank you very much for the support.
Gerard/PD1GH