MySQL Issue + how to stop the server

**pmiguet** · 20-12-2009, 00:18

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:

Code:

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** · 20-12-2009, 00:22

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** · 20-12-2009, 00:25

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** · 20-12-2009, 00:29

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** · 20-12-2009, 00:29

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** · 20-12-2009, 00:58

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

Code:

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

Code:

#!/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** · 20-12-2009, 01:01

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?

**LuckyWS** · 20-12-2009, 01:03

I think that if its working for him hes using a non passworded root account for his mysql... something which most of us will not accept as a solution.

If you are not using a root account, then please explain in further detail how you got it to work because I have been on this issue all day with no joy, and for each server load which fails an orphan dies or a teddy bear is killed in some far east country.

**Spooky** · 20-12-2009, 01:15

The mysql accountname, db name and password was set in the
ts3db_mysql.ini

1. go to your database and create a new database
2. create an db account specially for this new db

the first time you have to start the server with this command.
Go to the TS3 server folder an type:

Code:

./ts3server_linux_x86 dbplugin=ts3db_mysql dbsqlcreatepath=create_mysql/

with this command you create the database tables and start the server.
after this you can use the startscript.

**LuckyWS** · 20-12-2009, 01:21

I did that, maybe its a x64 thing, I see your using 32bit?

**DraZtiK** · 20-12-2009, 01:29

Originally Posted by Spooky

The mysql accountname, db name and password was set in the
ts3db_mysql.ini

1. go to your database and create a new database
2. create an db account specially for this new db

the first time you have to start the server with this command.
Go to the TS3 server folder an type:

Code:

./ts3server_linux_x86 dbplugin=ts3db_mysql dbsqlcreatepath=create_mysql/

with this command you create the database tables and start the server.
after this you can use the startscript.

Have you tried this??

It doesn't work...for no one. if it works for you please explain your setup.

**Spooky** · 20-12-2009, 01:30

Ok, i try to write it step by step.

1. go to your database and create a new database
2. create an db account specially for this new db

3. Go to your TS3 server folder and create e new file,
call it ts3db_mysql.ini and put this code into:

Code:

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

Fill it out with your database informations. don't type the <>

4. In your TS3 folder create a new file, call it ts3_server and put
this code into:

Code:

#!/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

5. start your server with this command

Code:

./ts3server_linux_x86 dbplugin=ts3db_mysql dbsqlcreatepath=create_mysql/

Now the database tables will be created.

From now, you can start and stop your server with this commands:

Code:

./ts3_server start

Code:

./ts3_server stop

I hope you all understand my english mismatch ;-)

P.S.: If the database tables are not created, go into your ts3-server_linux-x86\sql\create_mysql
folder. There you will find create_tables.sql which you can directly import in your database

**DraZtiK** · 20-12-2009, 01:34

I run this.
"./ts3server_linux_x86 dbplugin=ts3db_mysql dbsqlcreatepath=create_mysql/"

I get this.

Code:

2009-12-20 01:27:47.976342|INFO    |ServerLibPriv |   | Server Version: 3.0.0-beta1 [Build: 9366]
2009-12-20 01:27:47.977479|CRITICAL|DatabaseQuery |   | unable to load database plugin library, halting!

**Spooky** · 20-12-2009, 01:36

Originally Posted by DraZtiK

I run this.
"./ts3server_linux_x86 dbplugin=ts3db_mysql dbsqlcreatepath=create_mysql/"

I get this.

Code:

2009-12-20 01:27:47.976342|INFO    |ServerLibPriv |   | Server Version: 3.0.0-beta1 [Build: 9366]
2009-12-20 01:27:47.977479|CRITICAL|DatabaseQuery |   | unable to load database plugin library, halting!

Try to import the sql file directly in your database and start with
./ts3server_linux_x86 dbplugin=ts3db_mysql
from your ts3 server folder.

**DraZtiK** · 20-12-2009, 01:41

I imported...see attachment

my ts3db_mysql.ini

Code:

[config]
host=localhost
port=3306
username=xxxxx
password=xxxxxxx
database=teamspeak
socket=

error.

Code:

2009-12-20 01:37:23.255314|INFO    |ServerLibPriv |   | Server Version: 3.0.0-beta1 [Build: 9366]
2009-12-20 01:37:23.256631|CRITICAL|DatabaseQuery |   | unable to load database plugin library, halting!

Thread: MySQL Issue + how to stop the server

Thread Tools

Display

MySQL Issue + how to stop the server

Thread Information

Users Browsing this Thread

Similar Threads

Router problems

server on freeBSD 5.3

Sicherheit

Stopped server wont restart

Scheisse habe QDSL alles geht nur keine REG

Posting Permissions