MySQL Issue + how to stop the server

[pmiguet]

Edit by mod
Please don't use this outdated script anymore! The script got an overhaul long time ago.
Please use the minimal or startscript instead


Hi,

I got two questions actually. First one... I am not able to start the server using the MySQL database, the error is:

Access denied for user 'root'@'localhost' (using password: NO)

And I have no clue what that means, all data is correct. The database is up and running, it has a login incl. a password, all information is entered in the config file I had to create as documented in the TS3 Server manual. Any ideas?

The next question: when you start the TS3 server (in this case without the mySQL support)... how do you shut it down? I start it and then (using PuTTY) the command line is not coming back and using the server-connection to send commands always says that the serverstop command is not supported, even though it's documented.

[DraZtiK]

There has to be an issue with the mysql library. I can not start the server with mysql in any way be it from the command line, or from an ini file.

as far as stopping the server hit "ctrl c".

[jwevrsn]

You're not the first to report this issue.

To be safe double check that your root user has permission over the database (generally should be the case).

[DraZtiK]

Just for giggles try to start your server using
"./ts3server_linux_x86 dbplugin=ts3db_mysql dbsqlcreatepath=create_mysql/"

And tell us what happens. It shouldn't connect to your actual mysql server database.

[pmiguet]

There is only one user and that is the root user indeed, thanks a lot for the tips, mates!

edit: no, it's not connecting, because of the error message mentioned above (just in case you're addressing me... )

[Spooky]

If you want to use mysql, first you have to create a file.
Call it ts3db_mysql.ini

[config]
host=<your host>
username=<username>
password=<password>
database=<db name>

Put this code into and upload it in the ts3 server folder.

Second, create a file call it ts3_server.

#!/bin/bash
DIR="/etc/ts3_server"
case "$1" in
    start)
	cd ${DIR}
	${DIR}/ts3server_linux_x86 dbplugin=ts3db_mysql
	;;
    stop)
	killall ts3server_linux_x86
	;;
*)
	echo "Usage: 'basename $0' {start|stop}">&2
	exit 42
	;;
esac
exit 0

Put this code into. Copy this file to your ts3 folder.
now you can start and stop your server with this script, and the
mysql function is loaded automatically.

Go into your TS3 folder and start the server: ./ts3_server start
To stop the server: ./ts3_server stop

And finally, sorry for my bad english, try my best.

[pmiguet]

But the main problem is, that it can't connect to mysql at all. I am not a pro, but that doesn't look like it would solve the issue of not accepting the root login data?