I'm new to linux but I have install CQRLOG but it says fatal error with mysqld it wants me to run mysqld as root.
Can someone walk me through this.
Thanks
Mike
Sat, 2016-03-12 16:42
#1
problem with mysqld
Hi Mike,
I dont think CQRlog will ever force you to run mysql as root :) .
Can you give us the exact error?
Also , please start cqrlog with --debug=1 from a console
copy&paste that output here. We'll help you on your way :)
Alex
PA1SBM
Hi Alex
Thanks for the reply here is what I got so far
(cqrlog:3239): IBUS-WARNING **: The owner of /home/mike/.config/ibus/bus is not root!
**** DEBUG LEVEL 1 ****
Loading libssl: /usr/lib/i386-linux-gnu/libssl.so
Loading libcrypto: /usr/lib/i386-linux-gnu/libcrypto.so
Loading libmysqlclient: /usr/lib/i386-linux-gnu/libmysqlclient.so.18.0.0
**************************
MySQL version: 5.5
**************************
**********************************
MySQL version assigned: 5.500000000000000000E+00
**********************************
Loaded 88562 LoTW users
Loaded 94812 eQSL users
Loaded 47598 SCP calls
*
User home directory: /home/mike/
Program home directory: /home/mike/.config/cqrlog/
Data directory: /home/mike/.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
*
Trying to connect to database
160312 19:11:12 [Note] /usr/sbin/mysqld (mysqld 5.5.47-MariaDB-1ubuntu0.14.04.1) starting as process 3252 ...
160312 19:11:12 [ERROR] Fatal error: Please consult the Knowledge Base to find out how to run mysqld as root!
160312 19:11:12 [ERROR] Aborting
160312 19:11:12 [Note] /usr/sbin/mysqld: Shutdown complete
Server connect failed.
Trying:1
Trying to connect to database
Server connect failed.
Trying:2
Trying to connect to database
Server connect failed.
Trying:3
Trying to connect to database
Server connect failed.
Trying:4
Trying to connect to database
Server connect failed.
Trying:5
Trying to connect to database
Server connect failed.
Trying:6
Trying to connect to database
Server connect failed.
Trying:7
Trying to connect to database
Server connect failed.
Trying:8
Closing DXCluster window
Closing TRXControl window
Closing GrayLine window
Closing dDXCC
Closing dData
(cqrlog:3239): GLib-CRITICAL **: Source ID 17 was not found when attempting to remove it
(cqrlog:3239): GLib-CRITICAL **: Source ID 16 was not found when attempting to remove it
(cqrlog:3239): GLib-CRITICAL **: Source ID 50 was not found when attempting to remove it
(cqrlog:3239): GLib-CRITICAL **: Source ID 49 was not found when attempting to remove it
(cqrlog:3239): GLib-CRITICAL **: Source ID 58 was not found when attempting to remove it
(cqrlog:3239): GLib-CRITICAL **: Source ID 57 was not found when attempting to remove it
Closing ini file
Mike
W1ZFB
Hi Mike,
Can you tell me how you start cqrlog?
Do you do this by commandline?
Alex
Hi Mike,
It is possible that you have a file in ~/.config/cqrlog which is owned by root. It may be necessary to do a chown to all the files to have them owned by you.
73, Graeme ZL2APV
I start at the command line with cqrlog.
I am not sure how to fix ~/.config/cqrlog
thanks
Mike
W1ZFB
Mike
W1ZFB
Mike,
you can try to fix permission with
chown mike.mike /home/mike/.config/cqrlog -R
73 Petr
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Hi Mike,
If you start it with a command line, do you start a normal terminal window, or a root terminal window?
I know some distro's have a automatic root window. (i think fedora has this if i remember correctly)
Why don't you start CQRlog from the the normal menus?
A quick way to test if you are really "mike" and not root, is to type "whoami" on the console.
I suspect you try to start CQRlog as root (not willingly), and CQRlog then starts mysql/mariadb as root.
see this error in your log:
160312 19:11:12 [ERROR] Fatal error: Please consult the Knowledge Base to find out how to run mysqld as root!
Alex