mysql db not working cant connect someone please help

3 posts / 0 new
Last post
kd4dpb
mysql db not working cant connect someone please help

Error during connection to database: TMySQL57Connection : Server connect failed. also no info on the database error screen the link to database error file dose nothing any ideas maybe not in path

oh1kh
mysql db not working cant connect someone please help

Hi!
Cqrlog does work with MariaDB. That is the only one known to run using user's folder as database base folder. Mysql 8.0 does not work.

How ever most of sql database engines work with Cqrlog if you use already running sql service of your computer. That exists if you have installed sql database server from installation package. (or installing Cqrlog has done it as dependency)
Already running database service uses port 3306 that is standard for SQL server.

Now, when you start Cqrlog for first time it will ask "do you want to save log data to local machine".
That means: "Do you want to use your home folder as database storage and start a new SQL server thread from that folder, even when you have already running database server at port 3306"

Reason doing this is the idea that when you close Cqrlog you can just copy ~/.config/cqrlog folder with all files and subfolders and you have complete backup of everything.

How ever you can still "save your log data to local machine" even if you do say NO to the 1st start question.
You just need to fill the database information: Ip address (localhost), port (3306), username (what you like to use), password (what you like to use) and check checkboxes "remember me" and "auto connect".
Cqrlog will then work even with Mysql 8.0 that it normally does not do.

There is just one thing to do before the 1st start. You must create a SQl database user with password and grant all privileges to that user for creating and using databases in localhost, port 3306 SQL database server.
It can be done with command line "mysql" or some other mysql database administration program.

When using SQL server with port 3306 (localhost, or networked server) you need to copy ~/.config/cqrlog folder as always, but also make sqldump from all databases starting with cqr* that exist in SQL server. Then you have complete backup of all.

Version 2.6.0 of Cqrlog offers now in 1st startup three selections to start the usage.
The 2nd option is the one where Cqrlog uses localhost : 3306 port SQL server and it tries to create the database user with password and privileges and also a command line script that mysqldumps all cqrlog data from SQL server as backup.
2nd option, when succeeded, allows also Mysql 8.0 usage.
If script fails to create user it is still possible to use by creating the SQL user manually and then using 3rd option of startup where information is entered manually (that is the same as existing second option with older Cqrlogs below version 2.6.0 offer).
2nd startup option has tested to work with Fedora 35 and Mint 19 (Ubuntu variant) when creating it.

The first start with Cqrlog 2.6.0 has also button "Read me(pse)" that opens explaining help to your web browser. It is very recommended to read it before making any selection of those three options,

If Cqrlog's 1st start fails it is easy to reproduce 1st start by just removing ~/.config/cqrlog folder. Reinstalling of Cqrlog program does not do that, so there is no need to install the program itself again when database connection fails at 1st startup.

--
Saku
OH1KH

kd4dpb
database

i fixed it the dependancies somehow didnt install for dadabase ok so far