MySql problem

6 posts / 0 new
Last post
oh1mrr
MySql problem

When I used old configs, 2.0 started ok, except TRX. I tried to start whole new 2.0
I got Mysql error

TMySQL56Connection : Error executing query: Can't create database 'cqrlog_common' (errno: 2 "No such file or directory").

Press OK to ignore and risk data corruption.
Press Cancel to kill the program.

ok2cqr
ok2cqr's picture
Re: MySql problem

This is happening when you try to copy the database directory and mysqld is still running. Could you try to delete whole ~/.config/cqrlog directory, please? Make a backup, first.

oh1mrr
Deleting itself didn't help.

Deleting itself didn't help. I had to reboot computer newly, then cqrlog started without any errors, except TRX won't start. There's allready debug messages from others, I get same, ie. old thing, Rigctld do not start.

<p>Jarmo</p>

ok2cqr
ok2cqr's picture
Jarmo, could you try if the

Jarmo, could you try if the problem is the same like reported here, please?

https://github.com/ok2cqr/cqrlog/issues/35

Thank you!

oh1mrr
Tested, I don't think it's

Tested, I don't think it's same. There's not rigctld running at all... Here's debug
[oh1mrr@oh1mrr ~]$ cqrlog

**** DEBUG LEVEL 0 ****
**** CHANGE WITH --debug=1 PARAMETER ****

160421 10:46:13 mysqld_safe Logging to '/home/oh1mrr/.config/cqrlog/database//mysql.err'.
160421 10:46:13 mysqld_safe Starting mysqld daemon with databases from /home/oh1mrr/.config/cqrlog/database/

Settings:
-----------------------------------------------------
RigCtldPath:/usr/bin/rigctld
RigCtldArgs:-m 231 -r /dev/ttys0 -t 4532 -s 9600
RunRigCtld: TRUE
RigDevice: /dev/ttys0
RigCtldPort:4532
RigCtldHost:127.0.0.1
RigPoll: 500
RigSendCWR: FALSE
RigId: 231

Starting RigCtld ...
/usr/bin/rigctld -m 231 -r /dev/ttys0 -t 4532 -s 9600
rig_open: error = IO error
rigctld failed to start!
1
2
3
4
5
6

And
[oh1mrr@oh1mrr ~]$ ps -x | grep rigctld
2566 pts/1 S+ 0:00 grep --color=auto rigctld

I think that is pid for query...

<p>Jarmo</p>

oh1mrr
AAAARGHH!!! Now found... Typo

AAAARGHH!!! Now found... Typo on line /dev/ttyS0 my bad, Sorry....
This is when getting older and wiser... You know more, but see less :)

<p>Jarmo</p>