0x0005 : Operation not permitted | After MySQL migration

[mitoskalandiel]

After havin done conversion from the SQlite scheme to the MySQL scheme (which worked just brilliant with the help of MadCat's script ) and having the server.ini settings adapted according to this fine "Tutorial" i ran into a strange situation.
The initial startup with the new settings worked just fine :

27-01-07 17:23:43,ALL,Info,server,    Server init initialized
27-01-07 17:23:43,ALL,Info,server,    Server version: 2.0.23.13 Win32
27-01-07 17:23:45,WARNING,Info,SQL,    created table ts2_servers
27-01-07 17:23:46,WARNING,Info,SQL,    created table ts2_server_privileges
27-01-07 17:23:46,WARNING,Info,SQL,    created table ts2_channels
27-01-07 17:23:50,WARNING,Info,SQL,    created table ts2_channel_privileges
27-01-07 17:23:51,WARNING,Info,SQL,    created table ts2_clients
27-01-07 17:23:52,WARNING,Info,SQL,    created table ts2_bans

After that I did the database migration with MadCat's script, which also worked like a charm, but (and this is where the trouble starts), when I start up the TSS2 I get a lil alert saying this : "0x0005 : operation not permitted" but when I look in my server.log I just get these lines :

27-01-07 17:52:10,ALL,Info,server,    Server init initialized
27-01-07 17:52:10,ALL,Info,server,    Server version: 2.0.23.13 Win32

glad enough when I change the line "Active=1" under "[DBEXPRESS]" to "Active=0" I can still use the server with the SQLite database, and that works just perfect.

but tbh I have no idea what is going wrong there as I am pretty sure the db-connection works (as the initial table-creation shows)

==edit==
I have just tried to do some error-narrowing. And I have installed a XAMPP on my local machine.
Added a database, and user for tss2.
Backuped original server.ini, edited the [DBEXPRESS]-settings, fired up TSS2 and BINGO!! all worked just fine, even with the migrated database,
so it can't be a database and/or setting problem,
question is : Could that be a problem with my MySQL Provider not allowing some specific setting or so??
I am using www.freemysql.net
==end edit==

Any help with that will be appreciated, thx in advance

[Reedy Boy]

After havin done conversion from the SQlite scheme to the MySQL scheme (which worked just brilliant with the help of MadCat's script ) and having the server.ini settings adapted according to this fine "Tutorial" i ran into a strange situation.
The initial startup with the new settings worked just fine :

27-01-07 17:23:43,ALL,Info,server,    Server init initialized
27-01-07 17:23:43,ALL,Info,server,    Server version: 2.0.23.13 Win32
27-01-07 17:23:45,WARNING,Info,SQL,    created table ts2_servers
27-01-07 17:23:46,WARNING,Info,SQL,    created table ts2_server_privileges
27-01-07 17:23:46,WARNING,Info,SQL,    created table ts2_channels
27-01-07 17:23:50,WARNING,Info,SQL,    created table ts2_channel_privileges
27-01-07 17:23:51,WARNING,Info,SQL,    created table ts2_clients
27-01-07 17:23:52,WARNING,Info,SQL,    created table ts2_bans

After that I did the database migration with MadCat's script, which also worked like a charm, but (and this is where the trouble starts), when I start up the TSS2 I get a lil alert saying this : "0x0005 : operation not permitted" but when I look in my server.log I just get these lines :

27-01-07 17:52:10,ALL,Info,server,    Server init initialized
27-01-07 17:52:10,ALL,Info,server,    Server version: 2.0.23.13 Win32

glad enough when I change the line "Active=1" under "[DBEXPRESS]" to "Active=0" I can still use the server with the SQLite database, and that works just perfect.

but tbh I have no idea what is going wrong there as I am pretty sure the db-connection works (as the initial table-creation shows)

==edit==
I have just tried to do some error-narrowing. And I have installed a XAMPP on my local machine.
Added a database, and user for tss2.
Backuped original server.ini, edited the [DBEXPRESS]-settings, fired up TSS2 and BINGO!! all worked just fine, even with the migrated database,
so it can't be a database and/or setting problem,
question is : Could that be a problem with my MySQL Provider not allowing some specific setting or so??
I am using www.freemysql.net
==end edit==

Any help with that will be appreciated, thx in advance

Why are you using a web hosted one?

Why not install it on the machine with TS...?

Try these SQL scripts

http://forum.goteamspeak.com/attachm...0&d=1164623354

[mitoskalandiel]

well actually the changed sql-scripts didn't help, but as you said, as I have MySQL installed on this machine anyway, I can also use it for productive use (after having the xampp install secured, that is )

thx anyway for your quick reply, and btw i think i found out what the prob is, tss2 used persistent connections and the freemysql.net database doesn't allow that, so that might be the problem

nice evening to you

[Reedy Boy]

well actually the changed sql-scripts didn't help, but as you said, as I have MySQL installed on this machine anyway, I can also use it for productive use (after having the xampp install secured, that is )

thx anyway for your quick reply, and btw i think i found out what the prob is, tss2 used persistent connections and the freemysql.net database doesn't allow that, so that might be the problem

nice evening to you

That could make sense