ANALGINS Posted May 13, 2010 Report Share Posted May 13, 2010 nu gudrie prati, pasakat ka shito izlabot ? mysql ieks moduljiem ir atkomatets admin_sql ieks pluginiem ir atkomatets sql konfiga noraditais juzeris nav root un tam ir parole!!!! mysql serveris stradaa, tas ir uz tas pashas kastes tatad ip ir 127.0.0.1 mysql.sock failam ir simlinks uztaisits uz /tmp/mysql.sock [AMXX] SQL error: can't connect: 'Access denied for user 'root'@'localhost' (using password: NO)' man radas doma ka varbutas admin_sql plugins pats ir nokompilets uz tadu juzeri un tapec shadas problemas ? ps nee es nelietoju amxbanus!! izguglejos bet nekadu sakrrigo skaidrojumu nedabuju idejas? Link to comment Share on other sites More sharing options...
ngEAr Posted May 13, 2010 Report Share Posted May 13, 2010 admin.sma ir janorada pie sql ari to pashu kas ir ieksh sql.cfg , sql.cfg parasti tiek izmantots kad pluginam nav nekas noradits. Vel ir janonem "//" pie define using_sql. Link to comment Share on other sites More sharing options...
ANALGINS Posted May 13, 2010 Author Report Share Posted May 13, 2010 (edited) mhm skaidrs, paldies, nostradaja lai neceltu jaunu topiku, vai nevari pateikt ko kodejot pluginus nozime `%s` ? tas ir hostneims domats vai kas ? modificeju vienu pluginu un tur ir kkadas problemas ar tabulas veidoshanu kad piekanekte edit erors ir QueryCreateTable cik noprotu nevar izveidot tabulu #if defined USING_SQL PrepareTable() { new query[128]; formatex(query, sizeof(query) - 1,\ "CREATE TABLE IF NOT EXISTS `%s` (`%s` varchar(32) NOT NULL, `%s` varchar(35) NOT NULL, `%s` int(10) NOT NULL, `%s` varchar(32) NOT NULL, `%s` varchar(128) NOT NULL, `%s` varchar(64) NOT NULL, `%s` varchar(35) NOT NULL);",\ TABLE_NAME, KEY_NAME, KEY_STEAMID, KEY_BANLENGTH, KEY_UNBANTIME, KEY_REASON, KEY_ADMIN_NAME, KEY_ADMIN_STEAMID ); SQL_ThreadQuery(g_sql_tuple, "QueryCreateTable", query); } Edited May 13, 2010 by ANALGINS Link to comment Share on other sites More sharing options...
Norek Posted May 13, 2010 Report Share Posted May 13, 2010 tie ir pēc tam norādītie optioni TABLE_NAME, KEY_NAME, KEY_STEAMID, KEY_BANLENGTH, KEY_UNBANTIME, KEY_REASON, KEY_ADMIN_NAME, KEY_ADMIN_STEAMID Link to comment Share on other sites More sharing options...
ANALGINS Posted May 13, 2010 Author Report Share Posted May 13, 2010 (edited) aa nu protams - doh ja ieks plugina noradits #include <sqlx> tad tas izmantos sqlite nevis mysql, un to vaidzetu mainit uz mysql ? ps tik stulbi jautajumi jo nekodeju katru dienu pluginus un man tas plugins nekonektee pie mysql nezinamu iemeslu del.. Edited May 13, 2010 by ANALGINS Link to comment Share on other sites More sharing options...
ngEAr Posted May 13, 2010 Report Share Posted May 13, 2010 (edited) Nav atshkiribas. sqlx=mysql. Edited May 13, 2010 by ngEAr Link to comment Share on other sites More sharing options...
ANALGINS Posted May 13, 2010 Author Report Share Posted May 13, 2010 mhm skaidrs, es tik nesaprotu kapec plugins (defultais nemodificets) negrib lounchoties o.O L 05/13/2010 - 18:56:47: [AMXX] Plugin ("bans_sql.amxx") is setting itself as failed. L 05/13/2010 - 18:56:47: [AMXX] Plugin says: Could not connect to database. L 05/13/2010 - 18:56:47: [AMXX] Displaying debug trace (plugin "bans_sql.amxx") L 05/13/2010 - 18:56:47: [AMXX] Run time error 1: forced exit L 05/13/2010 - 18:56:47: [AMXX] [0] bans_sql.sma1::QueryCreateTable (line 402) Link to comment Share on other sites More sharing options...
ngEAr Posted May 13, 2010 Report Share Posted May 13, 2010 Ta ir pedeja advanced bans versija ? Vnk tas errors ir delj trhreaded kverijam. Vinsh rakstija ka it ka jaunaja versija partaisija kodu. Link to comment Share on other sites More sharing options...
ANALGINS Posted May 13, 2010 Author Report Share Posted May 13, 2010 (edited) v0.8 lasu vinju forumu, un istas atbildes nerodu kapec neceljas tas plugins sak rasties aizdomas kas nevar executot sql konfigu, to tapat japieraksta shadi pie amx konfiga? exec sql.cfg? admin_sql plugins arrii nevar piekonekteet manam mysql serverim, kas liekas nedaudz divaini, jo izmeginaju gan defulti paredzeto juzeri prieks hlds, gan root juzeri un abiem bija vienadas problemas o.O Edited May 13, 2010 by ANALGINS Link to comment Share on other sites More sharing options...
ngEAr Posted May 13, 2010 Report Share Posted May 13, 2010 Tur bija posts kur piedavaja versiju bez kverijiem ar identisko problemu. Vel tads prikols varetu but no ta ka pats sql neakcepte to connectionu no servera un plugina. Link to comment Share on other sites More sharing options...
ANALGINS Posted May 13, 2010 Author Report Share Posted May 13, 2010 (edited) ir kada ideja ka to apkarot? ieshu pachekot varbutas atrodu to pluginu edit, hmm panacu ka strada sql admins kkada veida, tagad man ir shads forsh errors no banu puses [ 21] Advanced Bans 0.8 Exolent advanced_bans_s error ( 21) Error: Query failed. varetu ta but ka mans mysql ir jaunaks un tapec nesakrit sintakse ? (MySQL version 5.1.37 ) Edited May 13, 2010 by ANALGINS Link to comment Share on other sites More sharing options...
ngEAr Posted May 13, 2010 Report Share Posted May 13, 2010 Bet kad tu uzliec banu vinsh to kaut kur saglaba? ... Atcerejos vienu lietu , kad pats tos liku tad musejais progeris laboju kverija kodu jo tur tipa dokumentacija nomainijas un tapec sql nevareja atpazit to. Link to comment Share on other sites More sharing options...
ANALGINS Posted May 13, 2010 Author Report Share Posted May 13, 2010 (edited) nu jaa.. protams... parbaudiju vai glabaa, un konsole uzreiz izmeta ka nevar piekonektet db WTF vienkarsi konsolee (klienta) iemet info par banu, bet plugins exito pirms kas talak notiek.. Edited May 13, 2010 by ANALGINS Link to comment Share on other sites More sharing options...
ngEAr Posted May 13, 2010 Report Share Posted May 13, 2010 Ja vinsh nevar piekonnekteties tad tavai DB kaut kas nepatik jeb stav kaut kads stulbs restrikts. Jeb megini manuali uztaisit tabulu caur sql kveriju pec parauga ieksh .sma Link to comment Share on other sites More sharing options...
ANALGINS Posted May 13, 2010 Author Report Share Posted May 13, 2010 (edited) es to ari izdariju, uztasiiju tabulu vis ok, izdzesu no plugina to kverija dalju kas par to atbildeja, smuki no { lidz pedejam } kas par to dalju atbildeja bet pie banoshanas vinjsh nobljaujas L 05/13/2010 - 21:16:43: hostname <> banned test <STEAM_0:0:1431917661> || Reason: "test" || Ban Length: Permanent Ban L 05/13/2010 - 21:16:43: [AMXX] Plugin ("advanced_bans_sql.amxx") is setting itself as failed. L 05/13/2010 - 21:16:43: [AMXX] Plugin says: Could not connect to database. L 05/13/2010 - 21:16:43: [AMXX] Run time error 1 (plugin "advanced_bans_sql.amxx") - forced exit serveri un klientam konsoles paradas izdruka par banu arii chataa, un tad shis, vis apstajas un nekas nenotiek edit atradu izlaboto sourci alied modu forumaa un tagad vis iet ka pa diedzinju, beidzot var slegt topiku Edited May 13, 2010 by ANALGINS Link to comment Share on other sites More sharing options...
Recommended Posts