Hi

I have been triying to install TS to my linux server so I can become a reseller. Everything is fine and working. But It is impossible to login as admin nor superadmin from web. So I searched the forum (Believe me ı read almost 30 topic about the issue) could not find any solution. Finally I have come to conclusion that my TS server is not able to write anything to server.dbs.

Here is my log file and pleas help me out on this:

---------------------------------------------------------------
-------------- log started at 13-10-06 12:20 -------------
---------------------------------------------------------------
13-10-06 12:20:04,ALL,Info,server, Server init initialized
13-10-06 12:20:04,ALL,Info,server, Server version: 2.0.20.1 Linux
13-10-06 12:20:04,WARNING,Info,SQL, created table ts2_servers
13-10-06 12:20:04,WARNING,Info,SQL, created table ts2_server_privileges
13-10-06 12:20:04,WARNING,Info,SQL, created table ts2_channels
13-10-06 12:20:04,WARNING,Info,SQL, created table ts2_channel_privileges
13-10-06 12:20:04,WARNING,Info,SQL, created table ts2_clients
13-10-06 12:20:04,WARNING,Info,SQL, created table ts2_bans
13-10-06 12:20:04,ERROR,All,SQL, ExcecSQL Error: SQL logic error or missing database in query: insert into ts2_servers
(s_server_name,
s_server_welcomemessage,
i_server_maxusers,
i_server_udpport,
s_server_password,
b_server_clan_server,
b_server_allow_codec_celp51,
b_server_allow_codec_celp63,
b_server_allow_codec_gsm148,
b_server_allow_codec_gsm164,
b_server_allow_codec_celp52,
b_server_allow_codec_speex2150,
b_server_allow_codec_speex3950,
b_server_allow_codec_speex5950,
b_server_allow_codec_speex8000,
b_server_allow_codec_speex11000,
b_server_allow_codec_speex15000,
b_server_allow_codec_speex18200,
b_server_allow_codec_speex24600,
s_server_webposturl,
s_server_weblinkurl,
b_server_active,
dt_server_created,
s_server_description)
values
('',
'',
0,
:iServer8767
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
'',
'',
-1,
:dtServer'13102006122004442'

13-10-06 12:20:04,ERROR,All,SQL, OpenSQL Error: SQL logic error or missing database in query: select * from ts2_server_privileges where i_sp_server_id = :iSe0 s_sp_usergroup = :sGro'_ugSA'
13-10-06 12:20:04,ERROR,All,SQL, ExcecSQL Error: SQL logic error or missing database in query: insert into ts2_server_privileges (
i_sp_server_id,
s_sp_usergroup,
b_sp_AccessWebAdminServer,
b_sp_AccessTcpServer,
b_sp_AccessVoice,
b_sp_AdminRegisterPlayer,
b_sp_AdminSetServerPermissions,
b_sp_AdminAddServer,
b_sp_AdminDeleteServer,
b_sp_AdminEditServerIpPort,
b_sp_AdminEditServerWebpostUrl,
b_sp_AdminEditServerName,
b_sp_AdminEditServerWelcomeMessage,
b_sp_AdminEditServerPassword,
b_sp_AdminEditServerType,
b_sp_AdminEditServerAllodCodecs,
b_sp_AdminBanIp,
b_sp_AdminMovePlayer,
b_sp_AdminListDBUsers,
b_sp_AdminChangeOwnPassword,
b_sp_AdminChangeUserPassword,
b_sp_AdminListDBServers,
b_sp_AdminEditServerMaxUsers,
b_sp_AdminStopServer,
b_sp_AdminStartServer,
b_sp_ChannelJoinRegisterred,
b_sp_ChannelCreateRegisterred,
b_sp_ChannelCreateUnregisterred,
b_sp_ChannelCreateDefault,
b_sp_ChannelCreateSubchannels,
b_sp_ChannelCreateModerated,
b_sp_ChannelDelete,
b_sp_ChannelEditName,
b_sp_ChannelEditPassword,
b_sp_ChannelEditTopic,
b_sp_ChannelEditDescription,
b_sp_ChannelEditOrder,
b_sp_ChannelEditMaxUsers,
b_sp_ChannelEditCodec,
b_sp_ChannelJoinChannelWithoutPassword,
b_sp_PrivilegeGrantSA,
b_sp_PrivilegeGrantCA,
b_sp_PrivilegeGrantAutoOp,
b_sp_PrivilegeGrantOp,
b_sp_PrivilegeGrantAutoV,
b_sp_PrivilegeGrantV,
b_sp_PrivilegeGrantAllowRegistration,
b_sp_PrivilegeRevokeSA,
b_sp_PrivilegeRevokeCA,
b_sp_PrivilegeRevokeAutoOp,
b_sp_PrivilegeRevokeOp,
b_sp_PrivilegeRevokeAutoV,
b_sp_PrivilegeRevokeV,
b_sp_PrivilegeRevokeAllowRegistration,
b_sp_PrivilegeAdminPlayerRegister,
b_sp_PrivilegePlayerDelete,
b_sp_PrivilegeRegisterSelfByDefault,
b_sp_SendTextToAll,
b_sp_SendTextToOwnChannel,
b_sp_SendTextToAllChannel,
b_sp_SendTextToPlayer,
b_sp_KickPlayerFromServer,
b_sp_KickPlayerFromChannel,
b_sp_AllowChannelCommanderStatus)
values
(
:iServerID,
:sGroup,
:bAccessWebAdminServer,
:bAccessTcpServer,
:bAccessVoice,
:bAdminRegi0,
:bAdminSet'_ugSA'ermi-1rver,
:bAdminDeleteServ-1ServerIpPort,
:bA-1rWebpostUrl,
:bAdminEditServerName,
:bAdminEditServerWelcomeMessage,
:bAdminEditServerPassword,
:bAdminEditServerTy-1erAllodCodecs,
:bAdminB-1AdminListDBUsers,
:bAdminChangeOw-1eUserPassword,
:bAdminListDBServers,
:bAdminEditServerMaxUsers,
:bAdminStopServer,
:bAdminStartServer,
:bChannelJoinRegisterred-1egiste-1registerred,
:bChannelCreateDefault,
:bChan-1els,
:bChannelCrea-1hannelDelete,
:bCha-1lEditPassword,
:bChannelEditTopic,
:bChannelEdi-1nelEditOrder,
:bChannelEditMaxUsers,
:bChannelEditCodec,
:bChannelJoinChannelWithoutPassw-1GrantSA,
:bPrivilegeGrantCA,
:bPrivilegeGrantAutoO-1Op,
:bPrivilegeGrantAu-1GrantV,
:bPrivilegeGrantAllowRegistration,
:bPrivilegeRevokeSA,
-1eCA,
:bPrivilegeRevokeAutoOp,
:bPrivilegeRevokeOp,
:bPrivilegeRevokeAutoV,
:b-1vokeAllowRegistration,
:bPrivilegeAdm-1 :bPrivilegePlayerDelete,
:b-1Default,
:bSendTextToAllP-1tToOwnChannel,
:bSend-1SendTextToPlayer,
:bKickPlayerFromServer,
:bKickPlayerFromChannel,
:bA-1tus);
-1-1
13-10-06 12:20:04,ERROR,All,SQL, OpenSQL Error: SQL logic error or missing database in query: select * from ts2_server_privileges where i_sp_server_id = :iSe0 s_sp_usergroup = :sGro'_ugCA'
13-10-06 12:20:04,ERROR,All,SQL, ExcecSQL Error: SQL logic error or missing database in query: insert into ts2_server_privileges (
i_sp_server_id,
s_sp_usergroup,
b_sp_AccessWebAdminServer,
b_sp_AccessTcpServer,
b_sp_AccessVoice,
b_sp_AdminRegisterPlayer,
b_sp_AdminSetServerPermissions,
b_sp_AdminAddServer,
b_sp_AdminDeleteServer,
b_sp_AdminEditServerIpPort,
b_sp_AdminEditServerWebpostUrl,
b_sp_AdminEditServerName,
b_sp_AdminEditServerWelcomeMessage,
b_sp_AdminEditServerPassword,
b_sp_AdminEditServerType,
b_sp_AdminEditServerAllodCodecs,
b_sp_AdminBanIp,
b_sp_AdminMovePlayer,
b_sp_AdminListDBUsers,
b_sp_AdminChangeOwnPassword,
b_sp_AdminChangeUserPassword,
b_sp_AdminListDBServers,
b_sp_AdminEditServerMaxUsers,
b_sp_AdminStopServer,
b_sp_AdminStartServer,
b_sp_ChannelJoinRegisterred,
b_sp_ChannelCreateRegisterred,
b_sp_ChannelCreateUnregisterred,
b_sp_ChannelCreateDefault,
b_sp_ChannelCreateSubchannels,
b_sp_ChannelCreateModerated,
b_sp_ChannelDelete,
b_sp_ChannelEditName,
b_sp_ChannelEditPassword,
b_sp_ChannelEditTopic,
b_sp_ChannelEditDescription,
b_sp_ChannelEditOrder,
b_sp_ChannelEditMaxUsers,
b_sp_ChannelEditCodec,
b_sp_ChannelJoinChannelWithoutPassword,
b_sp_PrivilegeGrantSA,
b_sp_PrivilegeGrantCA,
b_sp_PrivilegeGrantAutoOp,
b_sp_PrivilegeGrantOp,
b_sp_PrivilegeGrantAutoV,
b_sp_PrivilegeGrantV,
b_sp_PrivilegeGrantAllowRegistration,
b_sp_PrivilegeRevokeSA,
b_sp_PrivilegeRevokeCA,
b_sp_PrivilegeRevokeAutoOp,
b_sp_PrivilegeRevokeOp,
b_sp_PrivilegeRevokeAutoV,
b_sp_PrivilegeRevokeV,
b_sp_PrivilegeRevokeAllowRegistration,
b_sp_PrivilegeAdminPlayerRegister,
b_sp_PrivilegePlayerDelete,
b_sp_PrivilegeRegisterSelfByDefault,
b_sp_SendTextToAll,
b_sp_SendTextToOwnChannel,
b_sp_SendTextToAllChannel,
b_sp_SendTextToPlayer,
b_sp_KickPlayerFromServer,
b_sp_KickPlayerFromChannel,
b_sp_AllowChannelCommanderStatus)
values
(
:iServerID,
:sGroup,
:bAccessWebAdminServer,
:bAccessTcpServer,
:bAccessVoice,
:bAdminRegi0,
:bAdminSet'_ugCA'ermi0rver,
:bAdminDeleteServe0erverIpPort,
:bAdm0ebpostUrl,
:bAdminEditServerName,
:bAdminEditServerWelcomeMessage,
:bAdminEditServerPassword,
:bAdminEditServerTy0erAllodCodecs,
:bAdminBa0dminListDBUsers,
:bAdminChangeOwnP0serPassword,
:bAdminListDBServers,
:bAdminEditServerMaxUsers,
:bAdminStopServer,
:bAdminStartServer,
:bChannelJoinRegisterred0egiste0registerred,
:bChannelCreateDefault,
:bChanne0s,
:bChannelCreateM0nelDelete,
:bChannel0tPassword,
:bChannelEditTopic,
:bChannelEditDe0EditOrder,
:bChannelEditMaxUsers,
:bChannelEditCodec,
:bChannelJoinChannelWithoutPassw-1GrantSA,
:bPrivilegeGrantCA,
:bPrivilegeGrantAuto-1tOp,
:bPrivilegeGrantA-1eGrantV,
:bPrivilegeGrantAllowRegistration,
:bPrivilegeRevokeSA,-1keCA,
:bPrivilegeRevokeAutoOp,
:bPrivilegeRevokeOp,
:bPrivilegeRevokeAutoV,
:0evokeAllowRegistration,
:bPrivilegeAdm0 :bPrivilegePlayerDelete,
:bP-1efault,
:bSendTextToAllPl-1ToOwnChannel,
:bSendT-1endTextToPlayer,
:bKickPlayerFromServer,
:bKickPlayerFromChannel,
:b0atus);

.
.
.
.
.
.
.

13-10-06 12:22:38,WARNING,Info,SERVER, Default VirtualServer created
13-10-06 12:22:38,ERROR,All,SQL, OpenSQL Error: SQL logic error or missing database in query: select * from ts2_clients where i_client_server_id = :iSe0 s_client_name = :sName'admin'
13-10-06 12:22:38,ERROR,All,SQL, ExcecSQL Error: SQL logic error or missing database in query: insert into ts2_clients
(i_client_server_id,
b_client_privilege_serveradmin,
s_client_name,
s_client_password,
dt_client_created)
values
(:iServerID,
0Admin,
:sName,
:sPa'admin',
:dtCreated);
'13102006122238047'
13-10-06 12:22:38,WARNING,Info,SERVER, admin account info: username: admin password: rauqet
13-10-06 12:22:38,ERROR,All,SQL, OpenSQL Error: SQL logic error or missing database in query: select * from ts2_clients where i_client_server_id = :iSe0 s_client_name = :sName'superadmin'
13-10-06 12:22:38,ERROR,All,SQL, ExcecSQL Error: SQL logic error or missing database in query: insert into ts2_clients
(i_client_server_id,
b_client_privilege_serveradmin,
s_client_name,
s_client_password,
dt_client_created)
values
(:iServerID,
0Admin,
:sName,
:sPa'superadmin',
:dtCreated);
'13102006122238047'
13-10-06 12:22:38,WARNING,Info,SERVER, superadmin account info: username: superadmin password: xo5634
13-10-06 12:22:38,ALL,Info,server, Server init finished
13-10-06 12:22:38,WARNING,Info,server, TeamSpeak Server daemon activated
13-10-06 12:22:51,ERROR,All,SQL, OpenSQL Error: SQL logic error or missing database in query: select * from ts2_servers where i_server_udpport = :8767