• Hey Guest, we're evolving the future of TeaSpeak.
    You're invited to join the discussion here!

Mysql connection problem

BIOS

TeaSpeak Team
Staff member
TeaTeam
since TeaSpeak-Server v1.4.10-beta [Build: 1584974330] above teaspeak cant connect to my local mysql server



Code:
[2020-03-26 13:21:36] [DEBUG] Log successfully started!
[2020-03-26 13:21:36] [INFO ]   GEN | []---------------------------------------------------------[]
[2020-03-26 13:21:36] [INFO ]   GEN |   Thank you for buying the TeaSpeak-Premium-Software!
[2020-03-26 13:21:36] [INFO ]   GEN |   License information:
[2020-03-26 13:21:36] [INFO ]   GEN |      License owner  : **********
[2020-03-26 13:21:36] [INFO ]   GEN |      License type   : Hoster
[2020-03-26 13:21:36] [INFO ]   GEN |      License expires: Wed May  6 ***** 2020
[2020-03-26 13:21:36] [INFO ]   GEN |      License valid  : yes
[2020-03-26 13:21:36] [INFO ]   GEN | []---------------------------------------------------------[]
[2020-03-26 13:21:36] [INFO ]   GEN | Starting TeaSpeak-Server v1.4.10-beta [Build: 1584974330]
[2020-03-26 13:21:36] [INFO ]   GEN | Starting music providers
[2020-03-26 13:21:36] [DEBUG] [Music] Provider load order:
[2020-03-26 13:21:36] [DEBUG] [Music] [0] providers/000ProviderFFMpeg.so
[2020-03-26 13:21:36] [DEBUG] [Music] [1] providers/001ProviderYT.so
[2020-03-26 13:21:36] [DEBUG] [Music] [FFMPEG] Using config file located at providers/config_ffmpeg.ini
[2020-03-26 13:21:36] [INFO ] [Music] [FFMPEG] Config successfully loaded
[2020-03-26 13:21:36] [DEBUG] [Music] [FFMPEG] Executing command "/home/teaspeak/providers/bin/ffmpeg -version"
[2020-03-26 13:21:36] [INFO ] [Music] [FFMPEG] Resolved ffmpeg with version "ffmpeg version 4.0.1-static https://johnvansickle.com/ffmpeg/  Copyright (c) 2000-2018 the FFmpeg developers"
[2020-03-26 13:21:36] [DEBUG] [Music] [FFMPEG] Executing command "/home/teaspeak/providers/bin/ffmpeg -protocols"
[2020-03-26 13:21:36] [DEBUG] [Music] [FFMPEG] Executing command "/home/teaspeak/providers/bin/ffmpeg -formats"
[2020-03-26 13:21:36] [INFO ] [Music] Loaded successfully provider FFMpeg
[2020-03-26 13:21:36] [DEBUG] [Music] [YT-DL] Using config file located at providers/config_youtube.ini
[2020-03-26 13:21:36] [DEBUG] [Music] [YT-DL] Missing configuration file. Using default values
[2020-03-26 13:21:36] [DEBUG] [Music] [YT-DL] Executing versions command "youtube-dl --version"
[2020-03-26 13:21:36] [ERROR] [Music] [YT-DL] Could not find youtube-dl (Error: "sh: 1: youtube-dl: not found")
[2020-03-26 13:21:36] [ERROR] [Music] [YT-DL] How to download/install youtube-dl: https://github.com/rg3/youtube-dl/blob/master/README.md#installation
[2020-03-26 13:21:36] [ERROR] [Music] Could not create music provider for providers/001ProviderYT.so
[2020-03-26 13:21:36] [CRITICAL]   GEN | Invalid geo resolver type!
[2020-03-26 13:21:36] [DEBUG]   GEN | Created a new async thread pool!
[2020-03-26 13:21:36] [CRITICAL]   GEN | Could not initialize SQL!
[2020-03-26 13:21:36] [CRITICAL]   GEN | Could not connect to mysql://localhost:3306/teaspeak?userName=***&password=****&connections=4 (-1/failed to connect to server with connection 0: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)).
[2020-03-26 13:21:36] [INFO ]   GEN | Stopping application
[2020-03-26 13:21:36] [INFO ]   GEN | Application suspend successful!



solved!
this entry in config.yml not not works:

Code:
mysql://localhost:3306/teaspeak?userName=***&password=****&connections=4
change it to:

Code:
mysql://127.0.0.1:3306/teaspeak?userName=***&password=****&connections=4
 
Last edited: