[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Bug#848430: cqrlog: Should Depends/Recommends the metapackage default-mysql-*

Sure,
follow the log. Thank you!

iz1glg@laptop:~$ cqrlog --debug=1

**** DEBUG LEVEL 1 ****

Loading libssl: /usr/lib/x86_64-linux-gnu/libssl.so
Loading libcrypto: /usr/lib/x86_64-linux-gnu/libcrypto.so.1.0.2
Loading libmysqlclient: /usr/lib/x86_64-linux-gnu/libmysqlclient.so
**************************
MySQL version: 10.
**************************
**********************************
MySQL version assigned: 5.6
**********************************

Ctyfiles dir: /usr/share/cqrlog/ctyfiles/
Local ctyfiles dir: /home/iz1glg/.config/cqrlog/ctyfiles/
Loaded 93636 LoTW users
Loaded 98114 eQSL users
Loaded 48268 SCP calls
*
User home directory:    /home/iz1glg/
Program home directory: /home/iz1glg/.config/cqrlog/
Data directory:         /home/iz1glg/.config/cqrlog/database/
Memebers directory:     /usr/share/cqrlog/members/
ZIP code directory:     /usr/share/cqrlog/zipcodes/
Binary dir:             /usr/bin/
Share dir:              /usr/share/cqrlog/
TConnection to MySQL:   5.6
*
56 us states loaded
WARNING: obsolete call to RecreateWnd for TfrmDBConnect
Warning: TWinControl.DestroyHandle frmDBConnect:TfrmDBConnect Handle
not Allocated
/usr/sbin/mysqld
--defaults-file=/home/iz1glg/.config/cqrlog/database/mysql.cnf
--datadir=/home/iz1glg/.config/cqrlog/database/
--socket=/home/iz1glg/.config/cqrlog/database/sock --port=64000
2017-05-30 21:13:43 140664095195712 [Note] /usr/sbin/mysqld (mysqld
10.1.23-MariaDB-8) starting as process 22555 ...
select * from tables where table_schema = 'cqrlog_common'

CREATE DATABASE cqrlog_common DEFAULT CHARACTER SET = utf8  DEFAULT
COLLATE = utf8_bin;

USE cqrlog_common;

CREATE TABLE bands (
       id_bands INT AUTO_INCREMENT PRIMARY KEY,
       band VARCHAR(10) DEFAULT '',
       b_begin NUMERIC(10,4),
       b_end NUMERIC(10,4),
       cw NUMERIC(10,4),
       rtty NUMERIC(10,4),
       ssb NUMERIC(10,4),
       rx_offset numeric(10,4) default 0,
       tx_offset numeric(10,4) default 0
);
CREATE INDEX band ON bands(band);

CREATE TABLE dxclusters (
      id_dxclusters INT AUTO_INCREMENT PRIMARY KEY,
      description VARCHAR(100) DEFAULT '',
      address VARCHAR(100) DEFAULT '',
      port VARCHAR(10) DEFAULT '',
      dxcuser VARCHAR(12) DEFAULT '',
      dxcpass VARCHAR(20) DEFAULT ''
);
CREATE INDEX description ON dxclusters(description);

CREATE TABLE iota_list (
      id_iota_list INT AUTO_INCREMENT PRIMARY KEY,
      iota_nr VARCHAR(6) DEFAULT '',
      island_name VARCHAR(250) DEFAULT '',
      dxcc_ref VARCHAR(15) DEFAULT '',
      pref VARCHAR(15) DEFAULT ''
);
CREATE INDEX iota_nr ON iota_list(iota_nr);
CREATE INDEX pref ON iota_list(pref);


CREATE TABLE dxcc_ref (
            id_dxcc_ref INT AUTO_INCREMENT PRIMARY KEY,
            pref VARCHAR(20) NOT NULL,
            name VARCHAR(100) NOT NULL,
            cont VARCHAR(6) NOT NULL,
            utc VARCHAR(12)NOT NULL,
            lat VARCHAR(10) NOT NULL,
            longit VARCHAR(10) NOT NULL,
            itu VARCHAR(20) NOT NULL,
            waz VARCHAR(20) NOT NULL,
            adif SMALLINT NOT NULL DEFAULT 0,
            deleted SMALLINT NOT NULL DEFAULT 0
);
CREATE INDEX pref ON dxcc_ref(pref);
CREATE INDEX adif ON dxcc_ref(adif);

CREATE TABLE qslmgr (
            id_qslmgr INT AUTO_INCREMENT PRIMARY KEY,
            callsign VARCHAR(20),
            qsl_via VARCHAR(20),
            fromdate DATE
);
CREATE INDEX callsign ON qslmgr(callsign);
CREATE INDEX fromdate ON qslmgr(fromdate);

CREATE TABLE log_list (
            id_log_list INT AUTO_INCREMENT PRIMARY KEY,
            log_nr SMALLINT NOT NULL,
            log_name VARCHAR(50) DEFAULT '',
            auto_open SMALLINT NOT NULL DEFAULT 0
);
CREATE INDEX log_nr ON log_list(log_nr);

CREATE TABLE db_version
(
  nr SMALLINT NOT NULL
);

TApplication.HandleException TMySQL56Connection : Error executing
query: Can't create database 'cqrlog_common' (errno: 2 "No such file
or directory")
  Stack trace:
  $00000000008CDA9F
  $00000000008CF178
  $000000000074271A
  $0000000000742F63
  $0000000000599A05
  $00000000007B8C29
  $00000000007AA6F3
  $00007FE8F1DD4123
Closing DXCluster window
Closing TRXControl window
Closing GrayLine window
Closing dDXCC
Closing dData
Closing ini file ...

2017-05-30 18:15 GMT+02:00 Petr Hlozek <petr@ok2cqr.com>:
> Could you run cqrlog with --debug=1 parameter? There will be more info. Thanks!
>
>
> 2017-05-30 10:39 GMT+02:00 Federico Pietro Briata <federicobriata@gmail.com>:
>> Hi all
>> with 2.0.2 with default-libmysqlclient-dev and even with cqrlog 2.0.5,
>> on on Stretch it's still failing during startup. :(
>> follow the error i get
>>
>> 73 de Iz1glg
>>
>> $ cqrlog
>>
>> ** DEBUG LEVEL 0 **
>> ** CHANGE WITH --debug=1 PARAMETER **
>>
>> WARNING: obsolete call to RecreateWnd for TfrmDBConnect
>> Warning: TWinControl.DestroyHandle frmDBConnect:TfrmDBConnect Handle
>> not Allocated
>> 2017-05-30  8:06:37 140150651388480 [Note] /usr/sbin/mysqld (mysqld
>> 10.1.23-MariaDB-8) starting as process 30994 ...
>> TApplication.HandleException TMySQL56Connection : Error executing
>> query: Can't create database 'cqrlog_common' (errno: 2 "No such file
>> or directory")
>>   Stack trace:
>>   $00000000008CDA9F
>>   $00000000008CF178
>>   $000000000074271A
>>   $0000000000742F63
>>   $0000000000599A05
>>   $00000000007B8C29
>>   $00000000007AA6F3
>>   $00007FEF936AB123
>>
>
>
>
> --
> ex OK2CQR
> https://hamqth.com/ok7an
> https://ok7an.com
> https://www.cqrlog.com/
Reply to: