Server Permission Errors

[adb22791]

Hello,
I just reinstalled my Teamspeak servers (so that I could make use of the mySQL feature, and becuase I was moving servers). The reinstall was 100% fresh, nothing from the old servers.
Now, whenever I change the permissions for a user group they get reset within 1 minute to their defaults. This is particularly troublesome to me, as unregistered users cannot move around :( , etc.

Anybody have any advice? Everythinge else works (creating new channels and new clients, etc).

Thanks,
-Alex

[marcelrx]

Hello,
I just reinstalled my Teamspeak servers (so that I could make use of the mySQL feature, and becuase I was moving servers). The reinstall was 100% fresh, nothing from the old servers.
Now, whenever I change the permissions for a user group they get reset within 1 minute to their defaults. This is particularly troublesome to me, as unregistered users cannot move around :( , etc.

Anybody have any advice? Everythinge else works (creating new channels and new clients, etc).

Thanks,
-Alex

Errors in server.log?
If I understand you right. You can add clients,and channels but you can't save the permissons.
Auto_increment key in the tables?

[adb22791]

Somehow I don't think its a mysql error, since it happened before I switched over to mysql. It's like I change the permissions for say, Unregistered users. I want to allow unregistered users to join registered channels, so I check the box that says Join Registered.
Then I click OK at the bottom of the page, the screen goes to the confirmation, I click Continue, then check the permissions in Teamspeak. Nothing has changed :(

[marcelrx]

Somehow I don't think its a mysql error, since it happened before I switched over to mysql. It's like I change the permissions for say, Unregistered users. I want to allow unregistered users to join registered channels, so I check the box that says Join Registered.
Then I click OK at the bottom of the page, the screen goes to the confirmation, I click Continue, then check the permissions in Teamspeak. Nothing has changed :(

Answer my questions or I can't help you.
Some errors showen in the server.log?
Have you set an auto_increment key (id's) for the tables. (MYSQL)

[adb22791]

Answer my questions or I can't help you.
Some errors showen in the server.log?
Have you set an auto_increment key (id's) for the tables. (MYSQL)

Checked the Server log, and the only error I see is this:


24-10-05 18:55:20,ERROR,All,WEBINTERFACE, FileNotFound: "/home/tss/tss2_rc2/httpdocs/favicon.ico"


How do I go about checking the MySQL auto_increment key?

Thanks,
-Alex

[marcelrx]

Checked the Server log, and the only error I see is this:


24-10-05 18:55:20,ERROR,All,WEBINTERFACE, FileNotFound: "/home/tss/tss2_rc2/httpdocs/favicon.ico"


How do I go about checking the MySQL auto_increment key?

Thanks,
-Alex

With phpmyadmin. Login with PHPmyAdmin to your DB. The look if in the tables were these auto_increment keys.
Tabel:ts2_bans -> Field: i_ban_id must be set to auto_increment (Extra)
Tabel:ts2_channel_privileges -> Field: i_cp_id must be set to auto_increment
Tabel:ts2_channels -> Field: i_channel_id must be set to auto_increment
Tabel:ts2_clients -> Field i_client_id must be set to auto_increment
Tabel:ts2_server_privileges -> Field: i_sp_id must be set to auto_increment
Tabel:ts2_servers -> Field: i_server_id must be set to auto_increment

[adb22791]

With phpmyadmin. Login with PHPmyAdmin to your DB. The look if in the tables were these auto_increment keys.
Tabel:ts2_bans -> Field: i_ban_id must be set to auto_increment (Extra)
Tabel:ts2_channel_privileges -> Field: i_cp_id must be set to auto_increment
Tabel:ts2_channels -> Field: i_channel_id must be set to auto_increment
Tabel:ts2_clients -> Field i_client_id must be set to auto_increment
Tabel:ts2_server_privileges -> Field: i_sp_id must be set to auto_increment
Tabel:ts2_servers -> Field: i_server_id must be set to auto_increment

All set to auto_increment... I'm really stumped here :(

[adb22791]

Heres what is happening:
I go to edit the permissions of the unregistered user. I edit them, click ok, permissions are saved. Now, if I go to edit hte permissions of any other user, the permissions for the unregistered user's are reverted.
Any ideas?

[marcelrx]

Heres what is happening:
I go to edit the permissions of the unregistered user. I edit them, click ok, permissions are saved. Now, if I go to edit hte permissions of any other user, the permissions for the unregistered user's are reverted.
Any ideas?

Have you tested with root user?
Maybe you didn't have the permissions to edit the tables.

[adb22791]

Yuh, I logged in as super user. I am editing all these permission through the web interace by the way.

[marcelrx]

Yuh, I logged in as super user. I am editing all these permission through the web interace by the way.

No thats not what i mean.
The connect to the database.
The Users which uses Teamspeak to connect to your MySQL DB in your server.ini
Did it save the permissions when you use root there?

[adb22791]

The user who has access to the database has full and unrestricted access to the database I need that user to access. I will try again today with the root user, but I don't think that is the problem since I can add users fine. Its just the User Permissions that don't want to work.

[marcelrx]

The user who has access to the database has full and unrestricted access to the database I need that user to access. I will try again today with the root user, but I don't think that is the problem since I can add users fine. Its just the User Permissions that don't want to work.

Only users permissions don't want to work?
Do you have the orignal Webpanel?
Does it work when you use the sqlite Database?
Browser?
Cookies?

[adb22791]

Only users permissions don't want to work?
Yup.

Do you have the orignal Webpanel?

Yup again.

Does it work when you use the sqlite Database?

Nope

Browser?

Mozilla FireFox

Cookies?
Been cleared, but I'll try that again.