Hi
I'm currently running a Debian distribution and would like to install CRQLOG. However, I prefer not to install MySQL/MariaDB locally as my database is hosted on an external server. Is it possible to achieve this configuration?
Best 73 de OZ1BV, Brian
HI Brian!
Yes that is possible. Depending on your Cqrlog version there may different startup view.
All package installed Cqrlogs are old versions and you need to answer NO to question of "do you like to save your log data to local machine"
Then you have to define IP( or DNS name) and port for external SQL server as well as username and password.
User should be granted to full administration of databases whose name begins "cqr%"
External SQL server can be at same PC: localhost:3306 or any other networked SQL server. If you have server internet you should use ssh tunnel or vpn to reach your server,
Full backup needs sqldump from all databases starting "cqr%" and also folder ~./config/cqrlog. With default method "save log data to local machine" only the folder~./config/cqrlog needs to be saved for full backup.
Latest Cqrlogs (only from source at the moment) have selection #2 at startup where Cqrlog tries to define SQL user and grants for external SQL server as well as create a backup script.
Mysql and MariaDB should work as external SQL servers. How ever there may be some exceptions that work only with MariaDB ( compatibly not fully tested wit latest versions of Cqrlog Alpha)
--
Saku
OH1KH
Hi Saku
When installing using this method:
sudo add-apt-repository ppa:ok2cqr/ppa;sudo apt-get update;sudo apt-get install cqrlog
I get this:
The following additional packages will be installed:
cqrlog-data default-mysql-client-core default-mysql-server .... and much more stuff.
I don't want to install the mysql-server part. Any way to bypass this?
I am already using a NAS for my log. But I want to get rid of the MySQL/MariaDB server on my laptop.
Best 73 de OZ1BV, Brian
Vy 73 de OZ1BV, Brian
Hi Brian!
That is the problem with package installs.
Recommended way is to install self compiled version.
For that you need to install package 'lazarus' that will install all other needed stuff.
Get source from github and compile it. After that you stll need to install all other stuff from your list, but not Mysql server.
Other way is to download tgz for other linuxes from bottom of download page of this forum. That includes just Cqrlog, nothing else. You still need to install other listed stuff (including mysql client).
Note that version is very old, as well as it is also in packages available.
Third way is to install package but remove mysl server. For that you need a command. I know only that Fedora can do this package breaking with 'rpm -- nodeps -e'
How ever you will get many bugs using old versions. Using source gives the latest version either from official or Alpha.
--
Saku
OH1KH