TS3 + Mysql, server_properties not saved

[sbeex]

Hello,
I've installed my ts3 server with non-profit license. It works, mysql looks like okay because my tables are created at the first time I run the server. When I register my user with the tocken it's also written in mysql table.

BUT, when I rename my server, create channel or edit server properties (name etc) it's not saved in my mysql database ...

Concret examples :
if I go directly to my database and edit this :

virtualserver_name TeamSpeak ]I[ Server

to this :

virtualserver_name My Own Server

And I start my server after that, it keep "TeamsSpeak ]I[ Server"...

And If I edit from the in-game tools, in-game it's changed but not in mysql.

Do you have any solution ?

Thanks for your help !
(Sorry for my english I speak french)

[florian_fr40]

Hello

First, NEVER make a changes directly on the database.

What is your server version ?
Do you try with the query commands ? Do you get the same result ?
Is there an error message in the log server ?
Do you check the mysql user permissions ?

[sbeex]

My version : last one downloaded it today (amd64 debian)
querycommands : this works very good I use it to display players and channels on my website.
no error message in log.

My mysql user have all the required rights.

My players are stored in mysql but my channels and my server no... It's strange...

[florian_fr40]

Please post :
- The ts3server.ini file
- The ts3db_mysql.ini file
- The command that you use to start your server.

[sbeex]

ts3server.ini

machine_id=
default_voice_port=9987
voice_ip=0.0.0.0
liscensepath=licensekey.dat
filetransfer_port=30033
filetransfer_ip=0.0.0.0
query_port=10011
query_ip=0.0.0.0
dbplugin=ts3db_mysql
dbpluginparameter=ts3db_mysql.ini
dbsqlpath=sql/
dbsqlcreatepath=create_mysql/
logpath=logs
logquerycommands=1

ts3db_mysql.ini

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

And I run my server with a small start script I putted in /etc/init.d/teamspeak.sh
who look's like this :

#!/bin/sh
# Start ts3 server
cd /home/teamspeak/teamspeak3-server_linux-amd64/
su teamspeak -c './ts3server_minimal_runscript.sh inifile=ts3server.ini &'

[florian_fr40]

querycommands : this works very good I use it to display players and channels on my website.

Do you mean, when you use the query command to change the server name, there is no problem, and if you change the server name by the client you get this problem ?

[sbeex]

no I mean, i use query to display chans and connected players on my website and it works.

[florian_fr40]

So, I repeat my question :
Do you try with the query commands (serveredit....)? Do you get the same result ?
Same is you change the server name by the client (Tools > Edit virtual server)

[sbeex]

yeah if I edit my server directly from teamspeak with GUI interface it works but it's not saved on mysql...

[florian_fr40]

Not saved on your database ???
Strange.

If you have teamviewer, send me in private message the ID and password. I'm really curious now.

One more thing.
I hope (in the server_properties table) you search the virtualserver_name for the good serverID (not server ID = 0).
If it's the case, you look the wrong place.

[sbeex]

And yes i was looking on virtual_server id=0 but i have only this one stored on this table. Where CAN i Check if its stored on mysql or not please ?
(if after this it doesnt works i'll contact you by pm. Thank you !

[Elradon]

Hello
First, NEVER make a changes directly on the database.

Isn't this the only way to edit default server settings (like default servername, slots, and so on)?

[florian_fr40]

virtual_server id=0 but i have only this one stored on this table

Only this one.
Are you 100% sure, that you look the good database ?

@Elradon
You have to use the query command serveredit (select the server template with use 0). More information in the documentation.

[catalin]

I have the same problem. I changed some of the server properties with the server query and client app and these changes don't show up in the database. I checked both mysql and sqlite databases. The sqlite db is at /opt/ts3/ts3server.sqlitedb and the mysql database is in /var/lib/mysql/data/... and I used sqliteman and phpmyadmin for viewing the data. Even after server restart the data is not written in the database. I searched the entire server for sqlite and mysql and these are the only places where they sit.

Can anyone tell me when TS3 syncs with the database? Where is this information saved ? RAM?

Thank you.

[catalin]

Never mind, there were 2 instances of teamspeak running so I had to kill one. Now the database is saved instantly.