problem with mysqld

8 posts / 0 new
Last post
w1zfb
problem with mysqld

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

PA1SBM
PA1SBM's picture
Hi Mike,

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

w1zfb
CQRlog

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

PA1SBM
PA1SBM's picture
Hi Mike,

Hi Mike,

Can you tell me how you start cqrlog?
Do you do this by commandline?

Alex

ZL2APV
MySQL root errors

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

w1zfb
MySQL root errors

I start at the command line with cqrlog.
I am not sure how to fix ~/.config/cqrlog
thanks
Mike
W1ZFB

Mike
W1ZFB

ok2cqr
ok2cqr's picture
MySQL root errors

Mike,

you can try to fix permission with

chown mike.mike /home/mike/.config/cqrlog -R

73 Petr

PA1SBM
PA1SBM's picture
Hi Mike,

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