Community Forums Today's Posts     Member List     Archive    
Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2006
    Location
    Turkey
    Posts
    2

    MySql Problem and Login failed problem

    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

  2. #2
    Join Date
    Oct 2006
    Location
    Turkey
    Posts
    2

    Here is my complete server.log

    Here is my complete server.log
    Attached Files Attached Files

  3. #3
    Join Date
    Oct 2006
    Location
    noneya
    Posts
    6
    Not too smart to post the password to ur TS on here u know....

  4. #4
    Bastian Guest
    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.

  5. #5
    Bastian Guest
    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Superadmin - Login Failed - Searched but no answer
    By sullimo in forum [TeamSpeak 2] Server Support
    Replies: 0
    Last Post: 20-12-2005, 22:12
  2. Registered login problem
    By Washburn in forum [TeamSpeak 2] Client Support
    Replies: 2
    Last Post: 22-11-2005, 17:57
  3. problem with superadmin login
    By noobieeeeee in forum [TeamSpeak 2] Server Support
    Replies: 8
    Last Post: 29-04-2005, 13:52
  4. Webmin login problem
    By Julkku in forum [TeamSpeak 2] Server Support
    Replies: 0
    Last Post: 13-10-2004, 08:36
  5. Problem with login ! hes jump back to login panel
    By TKviper in forum [TeamSpeak 2] Addons & Scripts
    Replies: 9
    Last Post: 18-02-2004, 22:16

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •