Error during connection to database: Server connect failed.

6 posts / 0 new
Last post
ON6GMT
Error during connection to database: Server connect failed.

Hi,
after a brief power outage, I have this message that appears when I log.
"Error during connection to database: Server connect failed."
Geoffroy

ok2cqr
ok2cqr's picture
Re: 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

ik1rac
ik1rac's picture
Re: Error during connection to database: Server connect failed.

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

m0ddr
Cannot connect to mysql

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?

m0ddr
I ran cqrlog debug and got

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 ...

m0ddr
Here is ls -l of mysql.err

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?