Hi,
Today, I was trying to install CQRLOG on Kubuntu precise 12.04.01 AMD64 bit.
Somehow it alwas ends up with an error on my.cnf, which is from the scratch a 2 byte file.
I tried to chmod it to 666, but then, the error says something like ignoring globaly writable my.cnf.
I also tried "/usr/share/cqrlog/cqrlog-apparmor-fix" with no better result. Somehow, I'm lost to get CQRLOG running ....
Any hints ?
vy 73, Rolf
Here's the terminal screen output:
Loading libssl: /usr/lib/x86_64-linux-gnu/libssl.so Loading libcrypto: /usr/lib/x86_64-linux-gnu/libcrypto.so Loading libmysqlclient: /usr/lib/x86_64-linux-gnu/libmysqlclient.so.18.0.0 Loaded 58093 LoTW users Loaded 66691 eQSL users Loaded 44221 SCP calls *User home directory: /home/rolf/ Program home directory: /home/rolf/.config/cqrlog/ Data directory: /home/rolf/.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.5 * /usr/sbin/mysqld --defaults-file=/home/rolf/.config/cqrlog/database/my.cnf --default-storage-engine=MyISAM --datadir=/home/rolf/.config/cqrlog/database/ --socket=/home/rolf/.config/cqrlog/database/sock --skip-grant-tables --port=64000 --key_buffer_size=32M --key_buffer_size=4096K Could not open required defaults file: /home/rolf/.config/cqrlog/database/my.cnf Fatal error in defaults handling. Program aborted
Sun, 2013-03-03 21:58
#1
Kubuntu Precise - CQRLOG from PPA could not read my.cnf
Hi Rolf,
I'm using Kubuntu 12.04 AMD64, too. No problem here. Please try ldd cqrlog in console and look if the cqrlog binary file has all libraries available. I don't know why it should not work.
73 Petr, OK2CQR
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Hi Petr,
my first thought was something is wrong with mysql - unfortunately I'm totally unfamiliar with it.
Maybe it could be some problem with the path ? My home share is a link to a nfs nas directory ...
Here's ldd's output - no error appearded, so I guess, libraries are fine.
rolf@ja1uyn:/usr/bin$ ldd cqrlog linux-vdso.so.1 => (0x00007fff46fff000) libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007f2c283b6000) libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007f2c281b2000) libX11.so.6 => /usr/lib/x86_64-linux-gnu/libX11.so.6 (0x00007f2c27e7d000) libgdk_pixbuf-2.0.so.0 => /usr/lib/x86_64-linux-gnu/libgdk_pixbuf-2.0.so.0 (0x00007f2c27c5d000) libgtk-x11-2.0.so.0 => /usr/lib/x86_64-linux-gnu/libgtk-x11-2.0.so.0 (0x00007f2c27623000) libgdk-x11-2.0.so.0 => /usr/lib/x86_64-linux-gnu/libgdk-x11-2.0.so.0 (0x00007f2c27370000) libgobject-2.0.so.0 => /usr/lib/x86_64-linux-gnu/libgobject-2.0.so.0 (0x00007f2c27121000) libglib-2.0.so.0 => /lib/x86_64-linux-gnu/libglib-2.0.so.0 (0x00007f2c26e2c000) libgthread-2.0.so.0 => /usr/lib/x86_64-linux-gnu/libgthread-2.0.so.0 (0x00007f2c26c29000) libgmodule-2.0.so.0 => /usr/lib/x86_64-linux-gnu/libgmodule-2.0.so.0 (0x00007f2c26a25000) libpango-1.0.so.0 => /usr/lib/x86_64-linux-gnu/libpango-1.0.so.0 (0x00007f2c267dc000) libatk-1.0.so.0 => /usr/lib/x86_64-linux-gnu/libatk-1.0.so.0 (0x00007f2c265b9000) libcairo.so.2 => /usr/lib/x86_64-linux-gnu/libcairo.so.2 (0x00007f2c262fb000) libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f2c25f3c000) /lib64/ld-linux-x86-64.so.2 (0x00007f2c285f3000) libxcb.so.1 => /usr/lib/x86_64-linux-gnu/libxcb.so.1 (0x00007f2c25d1d000) libgio-2.0.so.0 => /usr/lib/x86_64-linux-gnu/libgio-2.0.so.0 (0x00007f2c259ce000) libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f2c256d2000) libpangocairo-1.0.so.0 => /usr/lib/x86_64-linux-gnu/libpangocairo-1.0.so.0 (0x00007f2c254c5000) libXfixes.so.3 => /usr/lib/x86_64-linux-gnu/libXfixes.so.3 (0x00007f2c252bf000) libpangoft2-1.0.so.0 => /usr/lib/x86_64-linux-gnu/libpangoft2-1.0.so.0 (0x00007f2c25095000) libfontconfig.so.1 => /usr/lib/x86_64-linux-gnu/libfontconfig.so.1 (0x00007f2c24e5e000) libXext.so.6 => /usr/lib/x86_64-linux-gnu/libXext.so.6 (0x00007f2c24c4d000) libXrender.so.1 => /usr/lib/x86_64-linux-gnu/libXrender.so.1 (0x00007f2c24a43000) libXinerama.so.1 => /usr/lib/x86_64-linux-gnu/libXinerama.so.1 (0x00007f2c2483f000) libXi.so.6 => /usr/lib/x86_64-linux-gnu/libXi.so.6 (0x00007f2c24630000) libXrandr.so.2 => /usr/lib/x86_64-linux-gnu/libXrandr.so.2 (0x00007f2c24427000) libXcursor.so.1 => /usr/lib/x86_64-linux-gnu/libXcursor.so.1 (0x00007f2c2421c000) libXcomposite.so.1 => /usr/lib/x86_64-linux-gnu/libXcomposite.so.1 (0x00007f2c24019000) libXdamage.so.1 => /usr/lib/x86_64-linux-gnu/libXdamage.so.1 (0x00007f2c23e16000) libffi.so.6 => /usr/lib/x86_64-linux-gnu/libffi.so.6 (0x00007f2c23c0d000) libpcre.so.3 => /lib/x86_64-linux-gnu/libpcre.so.3 (0x00007f2c239d0000) librt.so.1 => /lib/x86_64-linux-gnu/librt.so.1 (0x00007f2c237c7000) libpixman-1.so.0 => /usr/lib/x86_64-linux-gnu/libpixman-1.so.0 (0x00007f2c23540000) libfreetype.so.6 => /usr/lib/x86_64-linux-gnu/libfreetype.so.6 (0x00007f2c232a3000) libpng12.so.0 => /lib/x86_64-linux-gnu/libpng12.so.0 (0x00007f2c2307b000) libxcb-shm.so.0 => /usr/lib/x86_64-linux-gnu/libxcb-shm.so.0 (0x00007f2c22e78000) libxcb-render.so.0 => /usr/lib/x86_64-linux-gnu/libxcb-render.so.0 (0x00007f2c22c6d000) libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1 (0x00007f2c22a56000) libXau.so.6 => /usr/lib/x86_64-linux-gnu/libXau.so.6 (0x00007f2c22853000) libXdmcp.so.6 => /usr/lib/x86_64-linux-gnu/libXdmcp.so.6 (0x00007f2c2264c000) libselinux.so.1 => /lib/x86_64-linux-gnu/libselinux.so.1 (0x00007f2c2242d000) libresolv.so.2 => /lib/x86_64-linux-gnu/libresolv.so.2 (0x00007f2c22211000) libexpat.so.1 => /lib/x86_64-linux-gnu/libexpat.so.1 (0x00007f2c21fe6000)rolf@ja1uyn:/usr/bin$Hi Petr, I tried to start CQRLOG from another (local) user account and got a different behavior. I'm wondering the server bind address 0.0.0.0 ... is this correct ? Any hints ? Best regards, Rolf
arthur@ja1uyn:~$ cqrlog Loading libssl: /usr/lib/x86_64-linux-gnu/libssl.so Loading libcrypto: /usr/lib/x86_64-linux-gnu/libcrypto.so Loading libmysqlclient: /usr/lib/x86_64-linux-gnu/libmysqlclient.so.18.0.0 Ctyfiles dir: /usr/share/cqrlog/ctyfiles/ Local ctyfiles dir: /home/arthur/.config/cqrlog/ctyfiles/ Loaded 58093 LoTW users Loaded 66691 eQSL users Loaded 44221 SCP calls /home/arthur/.config/cqrlog/database/my.cnf * User home directory: /home/arthur/ Program home directory: /home/arthur/.config/cqrlog/ Data directory: /home/arthur/.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.5 * /usr/sbin/mysqld --defaults-file=/home/arthur/.config/cqrlog/database/my.cnf --default-storage-engine=MyISAM --datadir=/home/arthur/.config/cqrlog/database/ --socket=/home/arthur/.config/cqrlog/database/sock --skip-grant-tables --port=64000 --key_buffer_size=32M --key_buffer_size=4096K 130310 10:44:23 [Note] Plugin 'FEDERATED' is disabled. 130310 10:44:23 InnoDB: The InnoDB memory heap is disabled 130310 10:44:23 InnoDB: Mutexes and rw_locks use GCC atomic builtins 130310 10:44:23 InnoDB: Compressed tables use zlib 1.2.3.4 130310 10:44:23 InnoDB: Initializing buffer pool, size = 128.0M 130310 10:44:23 InnoDB: Completed initialization of buffer pool InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 130310 10:44:23 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 130310 10:44:24 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 130310 10:44:24 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: 127 rollback segment(s) active. InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 130310 10:44:25 InnoDB: Waiting for the background threads to start 130310 10:44:26 InnoDB: 1.1.8 started; log sequence number 0 130310 10:44:26 [Note] Server hostname (bind-address): '0.0.0.0'; port: 64000 130310 10:44:26 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 130310 10:44:26 [Note] Server socket created on IP: '0.0.0.0'. 130310 10:44:26 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them 130310 10:44:26 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 130310 10:44:26 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure 130310 10:44:26 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure 130310 10:44:26 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure 130310 10:44:26 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure 130310 10:44:26 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure 130310 10:44:26 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure 130310 10:44:26 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure 130310 10:44:26 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure 130310 10:44:26 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure 130310 10:44:26 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure 130310 10:44:26 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure 130310 10:44:26 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure 130310 10:44:26 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure 130310 10:44:26 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure 130310 10:44:26 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure 130310 10:44:26 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure 130310 10:44:26 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure 130310 10:44:26 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.29-0ubuntu0.12.04.2' socket: '/home/arthur/.config/cqrlog/database/sock' port: 64000 (Ubuntu) TCustomForm.SetActiveControl frmDBConnect:TfrmDBConnect AWinControl=btnOpenLog:TButton GetParentForm(AWinControl)=frmDBConnect:TfrmDBConnect csLoading=False AWinControl.CanFocus=False IsControlVisible=True Enabled=False TApplication.HandleException Cannot focus a disabled or invisible window Stack trace: $0000000000531B0A $000000000052D672 $0000000000796901 $000000000066687B $00000000007C6701 $00000000007C665B $000000000087B657 Closing BandMap window Closing DXCluster window Closing TRXControl window Closing GrayLine window End dmDXCC Complete end dmDXCC Closing dDXCC Closing dData /home/arthur/.config/cqrlog/database/ja1uyn.pid Command: kill 19062 130310 10:44:34 [Note] /usr/sbin/mysqld: Normal shutdown