MySql Problem and Login failed problem

[kelepirci]

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

[kelepirci]

Here is my complete server.log

[Warlord2k]

Not too smart to post the password to ur TS on here u know....

[Bastian]

The passwords aren't working anyway because the server is unable to access the database.

However, this issue is beeing dealed with in Tritons ticket system. This thread will be updated accordingly once the problem has been fixed.

[Bastian]

Here is the update:

The problem seems to be a messed up Linux installation. The system is giving a bunch or really strange error messages when logging in to SSH.