sonnyka
20-10-2005, 01:30
I run a linux based TS server (Version: 2.0.20.1) on a debian testing system with MySQL (Ver 14.7 Distrib 4.1.14, for pc-linux-gnu (i486) using readline 5.0).
Latelay I see the following error in my TS server.log, if a user/client changes from or to a channel where he has CA rights (not 100% if it is only with CA users, but I think so; definitively it's not limied to SA)
--- snip ---
20-10-05 01:12:56,ERROR,All,CHANNEL, SID: 1 GetChannelAttribs Exception: EDatabaseError.dbExpress Error: Operation Not Supported
20-10-05 01:12:56,ERROR,All,CHANNEL, SID: 1 GetChannelAttribs Exception: EDatabaseError.dbExpress Error: Operation Not Supported
--- snap ---
MySQL logs shows (actually twice, same for each error msg in TS log):
--- snip ---
22 Connect teamspeak@localhost on teamspeak
22 Query select count(*) from ts2_channel_privileges
23 Connect teamspeak@localhost on teamspeak
23 Query SHOW INDEX FROM ts2_channel_privileges
5 Query select * from ts2_channel_privileges
where i_cp_server_id = 1
and i_cp_channel_id = 2
and i_cp_client_id = 3
23 Quit
--- snap ---
Here the results, if I do the querys manually under the same user:
--- snip ---
mysql> select count(*) from ts2_channel_privileges;
+----------+
| count(*) |
+----------+
| 70 |
+----------+
mysql> SHOW INDEX FROM ts2_channel_privileges;
+------------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+------------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| ts2_channel_privileges | 0 | PRIMARY | 1 | i_cp_id | A | 70 | NULL | NULL | | BTREE | |
+------------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
mysql> select * from ts2_channel_privileges
-> where i_cp_server_id = 1
-> and i_cp_channel_id = 2
-> and i_cp_client_id = 3;
+---------+----------------+-----------------+----------------+-----------------+------------------+---------------------+
| i_cp_id | i_cp_server_id | i_cp_channel_id | i_cp_client_id | b_cp_flag_admin | b_cp_flag_autoop | b_cp_flag_autovoice |
+---------+----------------+-----------------+----------------+-----------------+------------------+---------------------+
| 1 | 1 | 2 | 3 | -1 | 0 | 0 |
+---------+----------------+-----------------+----------------+-----------------+------------------+---------------------+
--- snap ---
Sniplet from the server.ini:
--- snip ---
[DBEXPRESS]
sqldir=mysql_sql/
Drivername=mysql
Database=teamspeak
Hostname=localhost
User_name=teamspeak
Password=<forsuredeletedhere ;-)>
GetDriverFunc=getSQLDriverMYSQL
VendorLib=/usr/lib/libmysqlclient_r.so.10.0.0
LibraryName=./libsqlmy.so
Active=1
--- snap ---
Any ideas?
Latelay I see the following error in my TS server.log, if a user/client changes from or to a channel where he has CA rights (not 100% if it is only with CA users, but I think so; definitively it's not limied to SA)
--- snip ---
20-10-05 01:12:56,ERROR,All,CHANNEL, SID: 1 GetChannelAttribs Exception: EDatabaseError.dbExpress Error: Operation Not Supported
20-10-05 01:12:56,ERROR,All,CHANNEL, SID: 1 GetChannelAttribs Exception: EDatabaseError.dbExpress Error: Operation Not Supported
--- snap ---
MySQL logs shows (actually twice, same for each error msg in TS log):
--- snip ---
22 Connect teamspeak@localhost on teamspeak
22 Query select count(*) from ts2_channel_privileges
23 Connect teamspeak@localhost on teamspeak
23 Query SHOW INDEX FROM ts2_channel_privileges
5 Query select * from ts2_channel_privileges
where i_cp_server_id = 1
and i_cp_channel_id = 2
and i_cp_client_id = 3
23 Quit
--- snap ---
Here the results, if I do the querys manually under the same user:
--- snip ---
mysql> select count(*) from ts2_channel_privileges;
+----------+
| count(*) |
+----------+
| 70 |
+----------+
mysql> SHOW INDEX FROM ts2_channel_privileges;
+------------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+------------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| ts2_channel_privileges | 0 | PRIMARY | 1 | i_cp_id | A | 70 | NULL | NULL | | BTREE | |
+------------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
mysql> select * from ts2_channel_privileges
-> where i_cp_server_id = 1
-> and i_cp_channel_id = 2
-> and i_cp_client_id = 3;
+---------+----------------+-----------------+----------------+-----------------+------------------+---------------------+
| i_cp_id | i_cp_server_id | i_cp_channel_id | i_cp_client_id | b_cp_flag_admin | b_cp_flag_autoop | b_cp_flag_autovoice |
+---------+----------------+-----------------+----------------+-----------------+------------------+---------------------+
| 1 | 1 | 2 | 3 | -1 | 0 | 0 |
+---------+----------------+-----------------+----------------+-----------------+------------------+---------------------+
--- snap ---
Sniplet from the server.ini:
--- snip ---
[DBEXPRESS]
sqldir=mysql_sql/
Drivername=mysql
Database=teamspeak
Hostname=localhost
User_name=teamspeak
Password=<forsuredeletedhere ;-)>
GetDriverFunc=getSQLDriverMYSQL
VendorLib=/usr/lib/libmysqlclient_r.so.10.0.0
LibraryName=./libsqlmy.so
Active=1
--- snap ---
Any ideas?