Server no start

[powaserv]

Hi

I install teamspeak 3.
When you first start this one I get an error.
In the log file:

2011-01-29 20:29:05.028324|INFO |ServerLibPriv | | Server Veerver_2011-01-29__20_29_05.028140.logon: 3.0.0-beta30 [Build: 12998], Linux
2011-01-29 20:29:05.029680|INFO |DatabaseQuery | | dbPlugin name: MySQL plugin, (c)TeamSpeak Systems GmbH
2011-01-29 20:29:05.029753|INFO |DatabaseQuery | | dbPlugin version: 1
2011-01-29 20:29:05.055381|ERROR |DatabaseQuery | | db_exec() CREATE TABLE channel_properties ( server_id integer unsigned, id error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AUTOINCREMENT NOT NULL, channel_parent_id integer unsigned, server_id ' at line 1
2011-01-29 20:29:05.055476|CRITICAL|SQL | | db_CreateTables() unable to create tables

I tested with another user, another database.
And the same result.

My server runs Ubuntu 8.04

Thank you in advance for your help.

[florian_fr40]

Hello

Could you post your ts3server.ini and ts3db_mysql.ini ?
Also, write the command that you used to start your server.

[powaserv]

*** french part deleted ***
*** This forum is english only! ***


### ts3db_mysql.ini

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

### ts3server.ini :

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

*** french part deleted ***
*** This forum is english only! ***

./ts3server_startscript.sh start

*** french part deleted ***
*** This forum is english only! ***

COMMANDLINE_PARAMETERS="dbplugin=ts3db_mysql inifile=ts3server.ini"

*** french part deleted ***
*** This forum is english only! ***


English :

Then to know that I can better speak French.
I managed to launch one and once a server.
I cut because I wanted to have the server on my site, but I had errors like what it could not access the channel list etc. ...
Again I had errors because I could not change the rights of guests.
I tried by creating another user with another database and still the same error.
Yet I tried to download other source server to the view of many worries for the forum.
But nothing helped.

So, I thank you in advance for your help.

[florian_fr40]

Salut florian

Je sais pas si je peux écrire en français ou pas.

This forum is english only (forum rules) !

### ts3db_mysql.ini

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

Remove the socket line

### ts3server.ini :

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

- licensepath => remove "./" (just licensepath=)
- dbpluginparameter => you can remove "ts3db_mysql.ini" (just dbpluginparameter=)
- logpath => replace by "logpath=logs/"

./ts3server_startscript.sh start

COMMANDLINE_PARAMETERS="dbplugin=ts3db_mysql inifile=ts3server.ini"

just with that => COMMANDLINE_PARAMETERS="inifile=ts3server.ini"

Also, be sure that all files and folders in the server folder has the same linux owner and use this linux user to start your server.

[powaserv]

Thank you!

Apparently it works ^ ^.
By cons I still can not enable or disable some function.
In permissions => group management server => Guest.
I select something and I are not rights.
I just connect with the super admin token provided.

You would of or could it come?


Thank you.

[florian_fr40]

I select something and I are not rights.

Could you be please more clear

What do you try exactly ?
Do you get an error message ?

[powaserv]

Hi

In permissions => group management server => Guest
For example global => Information
Here I can select everything is grayed out.
And if I double click on it I get this error: "insufficient permission modify power"
Thank you for your help ^^

[florian_fr40]

You need to be in Query admin group to change these permissions.
(or use the query commands).

[powaserv]

Hi,


I use the identifiers that provided the first launch.
It's not only those indetifiant ultimate?

How to do otherwise?

Thank you

[florian_fr40]

It's not only those indetifiant ultimate?
How to do otherwise?

I don't really understand.
Do you get an error ?

[powaserv]

Hi,


I said.
I use the logins that I had to first launch the server.
These logins are those for the super administrator.

So how does it make that I'm not in the administrator group.

And for those mistakes I made above in my subjects.


Otherwise how to recover the rights?

Here I do not understand either and the worst is that I need.


Thank you for your help.

[copper]

I'm assuming you're using linux since you posted it here.

You should log in with query admin, not server admin. I don't like the query interface on TS3 client. You can use "telnet localhost 10011" on your linux machine or "telnet ip_address 10011" on another machine that can reach the server through ip_address.

You must log in with your serveradmin username and password, and you must select the virtual server. Then, you can modify the permissions using the commands described in the query manual.

[powaserv]

HI,

Okay thank you.
But there would not a simpler way to address dysfunction?
Because with the query, I frankly do not understand anything.
I swim completely.