Hi,
after a brief power outage, I have this message that appears when I log.
"Error during connection to database: Server connect failed."
Geoffroy
Sun, 2014-09-21 09:10
#1
Error during connection to database: Server connect failed.
Hi Geoffroy,
in ~/.config/cqrlog/database/ there is mysql.err file. Please paste here a few last lines. There will be why the server didn't started.
If you want, you can send me whole database directory and I'll try to fix the data.
73 Petr, OK2CQR
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Dear Petr,
I think I have just had the very same problem.
Here are the last 20 lines of mysql.err
Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x0 thread_stack 0x48400
/usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x55a2ffe8936e]
/usr/sbin/mysqld(handle_fatal_signal+0x3bd)[0x55a2ff9cea4d]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x110c0)[0x7f2e460b20c0]
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0xcf)[0x7f2e449acfcf]
/lib/x86_64-linux-gnu/libc.so.6(abort+0x16a)[0x7f2e449ae3fa]
/usr/sbin/mysqld(+0x9d4653)[0x55a2ffe00653]
/usr/sbin/mysqld(+0x87c280)[0x55a2ffca8280]
/usr/sbin/mysqld(+0x90ac0e)[0x55a2ffd36c0e]
/usr/sbin/mysqld(+0x8214ef)[0x55a2ffc4d4ef]
/usr/sbin/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0x66)[0x55a2ff9d0b86]
/usr/sbin/mysqld(+0x422e55)[0x55a2ff84ee55]
/usr/sbin/mysqld(_Z11plugin_initPiPPci+0x7da)[0x55a2ff85048a]
/usr/sbin/mysqld(+0x37afa3)[0x55a2ff7a6fa3]
/usr/sbin/mysqld(_Z11mysqld_mainiPPc+0x1a0d)[0x55a2ff7aa78d]
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf1)[0x7f2e4499a2b1]
/usr/sbin/mysqld(_start+0x2a)[0x55a2ff79ec4a]
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
Thanks & 73
I get the following when I first run CQRLOG:
Error during connection to database: Server connect failed.
MySQL could not be started, please check if the MySQL server is installed properly
Mysql is running fine.
I tried to find the error log ~/.config/cqrlog/database/mysql.err but a search returns nothing.
Where exactly does it reside?
I ran cqrlog debug and got the following. I noticed cqrlog also couldn't find mysql.err so I created it but the result from the debug remained the same and mysql.err is empty
Loading libcrypto: /usr/lib/libcrypto.so.1.0.0
Loading libmysqlclient: /usr/lib/libmysqlclient.so
**************************
MySQL version: 5.5
**************************
**********************************
MySQL version assigned: 5.500000000000000000E+00
**********************************
Loaded 79027 LoTW users
Loaded 87197 eQSL users
Loaded 47254 SCP calls
IniFile:/root/.config/cqrlog/cqrlog.cfg
LocalIniFile:/root/.config/cqrlog/local.cfg
*
User home directory: /root/
Program home directory: /root/.config/cqrlog/
Data directory: /root/.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
180102 14:48:55 mysqld_safe Logging to '/root/.config/cqrlog/database//mysql.err'.
180102 14:48:55 mysqld_safe Starting mysqld daemon with databases from /root/.config/cqrlog/database/
/usr/bin/mysqld_safe_helper: Can't create/write to file '/root/.config/cqrlog/database//mysql.err' (Errcode: 13)
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
Closing ini file ...
Here is ls -l of mysql.err
root@Spitfire:~# ls -l /root/.config/cqrlog/database//mysql.err
-rw-r--r-- 1 root root 0 Jan 2 14:47 /root/.config/cqrlog/database//mysql.err
do I have a permission problem?