deathangel00 Posted April 25, 2009 Report Share Posted April 25, 2009 Man ,piemēram, amxbana webs ir cita datora ,bet pats serveris atkal uz cita serveri. Kad man prasa sql vai admin_amxbans ,kas man ir jāraksta localhost vietā? Link to comment Share on other sites More sharing options...
puisitis. Posted April 25, 2009 Report Share Posted April 25, 2009 T'a datora IP uz kura atrodas amxbani un datubazes neims uc. Link to comment Share on other sites More sharing options...
ZhaKS Posted April 25, 2009 Report Share Posted April 25, 2009 IP ADRESE TĀ PC! ! ! ! KAUTKĀDS TĀDS JAUTĀJUMS P.S localhost var aizstāt ar: 127.0.0.1 Link to comment Share on other sites More sharing options...
deathangel00 Posted April 25, 2009 Author Report Share Posted April 25, 2009 Vienkārši es rakstu un man vajag vel beigās pieliekt :3306 ,bet nejiet kopumā rakstu 159.148.29.145:3306 ,bet uzrādās ,ka nevar savienoties. Link to comment Share on other sites More sharing options...
X ID Posted April 25, 2009 Report Share Posted April 25, 2009 3306 ir default'ais mysql ports, značit vari viņu nenorādīt, laikam. Prcincipā tev viss ir jādara tāpat kā tad, ja datubāze stāvētu localhost'ā, vienīgi localhost tev jāaizstāj ar datubāzes ip. Link to comment Share on other sites More sharing options...
samuray Posted April 26, 2009 Report Share Posted April 26, 2009 ports ir atvērts? Link to comment Share on other sites More sharing options...
deathangel00 Posted April 26, 2009 Author Report Share Posted April 26, 2009 Vienkārši ar ip nejiet un ar to 3... arī nejiet ,nu itkā jau jā , vaļā. Link to comment Share on other sites More sharing options...
X ID Posted April 26, 2009 Report Share Posted April 26, 2009 Tu gribi teikt, ka remote konekcija kā tāda strādā, bet no servera nē? Link to comment Share on other sites More sharing options...
samuray Posted April 27, 2009 Report Share Posted April 27, 2009 mysql jūzerim ir pieeja no jebkura hosta (%)? Link to comment Share on other sites More sharing options...
deathangel00 Posted April 29, 2009 Author Report Share Posted April 29, 2009 īsti daudz nesaprotu ,bet nu sākumam pats domāju izmeiģināt ,tad uz hosta likt.Vārdu sakot ,es tagad pats izmeiģinu admin_amxbansun sql.cfg aizstāt localhost ar SAVU ip , viss itkā pareizi ,nu vārdsakot rekur mans sql.cfg ,ip ir mana (reālā) amx_sql_host "77.38.151.11" amx_sql_user "root" amx_sql_pass "******" amx_sql_db "amxbans" amx_sql_table "admins" amx_sql_type "mysql" konsulē rāda ,ka nav savienoties. L 04/29/2009 - 15:08:32: [amxbans.amxx] [Amxbans] Connection failed! L 04/29/2009 - 15:08:32: [amxbans.amxx] [Amxbans] Threaded query error, location: 1 L 04/29/2009 - 15:08:32: [amxbans.amxx] [Amxbans] Message: Host '77.38.151.11' is not allowed to connect to this MySQL server (1130) L 04/29/2009 - 15:08:32: [amxbans.amxx] [Amxbans] Query statement: L 04/29/2009 - 15:08:33: World triggered "Round_Start" Menu item 17 added to Menus Front-End: "Banhistory Menu" from plugin "AMXBans" L 04/29/2009 - 15:08:35: [amxbans.amxx] [Amxbans] Connection failed! L 04/29/2009 - 15:08:35: [amxbans.amxx] [Amxbans] Threaded query error, location: 5 L 04/29/2009 - 15:08:35: [amxbans.amxx] [Amxbans] Message: Host '77.38.151.11' is not allowed to connect to this MySQL server (1130) L 04/29/2009 - 15:08:35: [amxbans.amxx] [Amxbans] Query Tiešām būtu loti pateicīgs ,ja palīdz'tu kāds. Link to comment Share on other sites More sharing options...
Wuu Posted April 29, 2009 Report Share Posted April 29, 2009 Pamēģini 127.0.0.1 Link to comment Share on other sites More sharing options...
X ID Posted April 29, 2009 Report Share Posted April 29, 2009 127.0.0.1 ir tas pats localhost. Priekškam tev rakstīt kaut kādu ip, ja liekot uz hosta tāpat rakstīsi localhost? Bet vispār tev firewall jāatver 3306 ports (ja ir rūteris, tad tur arī) un mysql jūzerim jāatļauj pieslēgties no konkrētā hosta vai visiem hostiem (%). Link to comment Share on other sites More sharing options...
deathangel00 Posted April 29, 2009 Author Report Share Posted April 29, 2009 Piemēram, webs ir uz mana pc (amxbans) serveris uz cita! Link to comment Share on other sites More sharing options...
Wuu Posted April 30, 2009 Report Share Posted April 30, 2009 Abi datori ir saslēgti lokāli aiz rutera vai switcha? Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now