Installation CQRLOG

8 posts / 0 new
Last post
DL1EYG
Installation CQRLOG

Hello folks,
does anyone have experience with installing CQRLOG on Ubuntu 20.04 LTS with already existing MySQL on a server in the network?
Configuration:
Ubuntu 20.04 LTS
Latest version of MariaDB on NAS.

After installation, the error message comes up that the application is not responding with options wait or close immediately

Thanks
P.S.: Log4OM under wine works with the database.

ok2cqr
ok2cqr's picture
Re: Installation CQRLOG

Hi,

what error comes up? I also use CQRLOG with a database on a server in our home network and don't have any problem with that.

73 Petr, OK2CQR

DL1EYG
Re: install CQRLOG

Hi Petr,

after about 10 sec.: application is not responding. Wan't you wait or close?

Start with DEBUG=1 bring no messages.

Regards,
Eugene

73, de DL1EYG Eugene

DL1EYG
solved

Hi Petr,

with
sudo cqrlog
can application start.

if i have any other problems, i'll get back to you.

Eugene

73, de DL1EYG Eugene

oh1kh
Re: Installation CQRLOG

Hi Eugene !

No, that is not solution. You should never run cqrlog as root !!!

You just give enough rights for the database user you use for cqrlog database connection so that it can create,delete and use database.
Log in to your external database as administrator and give command:

GRANT ALL PRIVILEGES ON *.* TO 'cqrlog'@'%' IDENTIFIED BY 'cqrlog';

Change user "cqrlog" and password "cqrlog" ones you want to use.
Note that that this will give full rights to do ANYTHING on this database server. You can start with that, but I suggest you limit user rights if you are using database server also for other databases than cqrlog. If cqrlog is the only usage then this is ok.

When rights are set cqrlog can create all needed databases by itself.

When you again start cqrlog as normal linux user you may have errors. That is because you have used sudo for running cqrlog.
I have never tested what happens with sudo. Does it make all its files to user directory or to /root directory.
If it uses user directory with sudo then you must give console command:

sudo chown -R username.username /home/username/.config/cqrlog

Replace "username" with your linux regular user's username. That command will change ownership of cqrlog files back to your normal user.
Command will do no harm you can do it in any case despite it is needed or not to be sure that all files of cqrlog are owned by regular user.

--
Saku
OH1KH

DL1EYG
Installation CQRLOG

Hi Saku,

thanks for your detailed description.
Even before the installation I had created the user in the DB and assigned full rights (see attachment).
just now I had started the program directly and without sudo.
it took a very long time (three times I had to click on "wait for the program").
It works.
I can connect to database server, create databases and enter data for a new qso.

so, maybe show a hint before the first start of the application that it takes a moment and you should just wait.

The next step: load adif file from another log application.

thank you again and have a nice evening

Eugene

File: 

73, de DL1EYG Eugene

oh1kh
Installation CQRLOG

Hi Eugene!

Fine !
It depends you cqrlog PC speed, network speed and you nas speed.
How ever in first start with debug=1 you should see how it builds up databases for first use.

I made it once with NanoPI, a similar but smaller device as RaspberryPi using its own database server via localhost 3306 port.
Yes it took a long time, but from debug I could see that there was something still going on.

After initial work is done it should work smoother.

--
Saku
OH1KH

DL1EYG
Installation CQRLOG

Hi Saku,
yes, it may also be the speed of my laptop.
Lenovo-YOGA i7 with 256 GB SSD (+ 256 under Windows)

After a few "false starts" I had tried with DEBUG=1.
No results in the terminal window.
But directly the message that the application hangs.

>After initial work is done it should work smoother
yes, it works. The program starts immediately.

73, de DL1EYG Eugene