Resetare parola MySQL FreeBSD 11.2, HELP.

Simplw · 16 Iul 2018, 22:50

Descarca un user de pe net si adauga-l in mysql din mysql ,dupa care te loghezi in navicat ,stergi totii userii ,lasi doar pe cel care vrei sa dai restart la parola si pe cel care l-ai bagat in mysql ,dai restart la parola la user-ul respectiv dupa care dai reboot ,intrii in navicat si stergi user-ul adaugat in mysql ,dupa care un refresh si cam asta-i tot !

g0dafk · 17 Iul 2018, 15:28

Am reusit sa rezolv toate problemele. Serverul functioneaza. Ma pot loga, merge si baza de date si filezilla. Absolut tot. Ma pot loga si de pe alt PC ( din casa de la mine ) si chiar si altii se pot loga ( de la 300 de KM ) DAAAR, doar pana la caracter select. Cand isi selecteaza caracterul ii duce inapoi la ecranul de login. Care ar putea fi problema...? Mentionez ca am facut portforward. Sa fi omis vreun port...?
Deci eu pot intra pe cont, dar cineva din afara retelei primeste kick sa zic asa cand isi selecteaza caracterul.

g0dafk · 18 Iul 2018, 01:41

up plz.

BeauDeCiuda · 18 Iul 2018, 02:44

g0dafk scrie:Am reusit sa rezolv toate problemele. Serverul functioneaza. Ma pot loga, merge si baza de date si filezilla. Absolut tot. Ma pot loga si de pe alt PC ( din casa de la mine ) si chiar si altii se pot loga ( de la 300 de KM ) DAAAR, doar pana la caracter select. Cand isi selecteaza caracterul ii duce inapoi la ecranul de login. Care ar putea fi problema...? Mentionez ca am facut portforward. Sa fi omis vreun port...?
Deci eu pot intra pe cont, dar cineva din afara retelei primeste kick sa zic asa cand isi selecteaza caracterul.

Internet slab erori in proto sau fisiere din locale.

Posteaza syserr din ch1 db/auth

g0dafk · 18 Iul 2018, 12:11

BeauDeCiuda scrie:
g0dafk scrie:Am reusit sa rezolv toate problemele. Serverul functioneaza. Ma pot loga, merge si baza de date si filezilla. Absolut tot. Ma pot loga si de pe alt PC ( din casa de la mine ) si chiar si altii se pot loga ( de la 300 de KM ) DAAAR, doar pana la caracter select. Cand isi selecteaza caracterul ii duce inapoi la ecranul de login. Care ar putea fi problema...? Mentionez ca am facut portforward. Sa fi omis vreun port...?
Deci eu pot intra pe cont, dar cineva din afara retelei primeste kick sa zic asa cand isi selecteaza caracterul.
Internet slab erori in proto sau fisiere din locale.

Posteaza syserr din ch1 db/auth

Syserr din canal1/core1: (/usr/home/game/server/canale/canal1/core1) :

Cod: Selectaţi tot

SYSERR: Jul 18 15:34:59 :: pid_init: 
Start of pid: 2248

SYSERR: Jul 18 15:34:59 :: socket_bind: bind: Address already in use
SYSERR: Jul 18 15:43:08 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jul 18 15:43:09 :: pid_deinit: 
End of pid

SYSERR: Jul 18 15:44:25 :: pid_init: 
Start of pid: 2004

SYSERR: Jul 18 15:44:25 :: socket_connect: HOST localhost:26842, could not connect.
SYSERR: Jul 18 15:58:59 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 1, 958889, 272252, 0, 'LOGIN', '192.168.0.104 1749500990 1 41 257', '192.168.0.104') errno: 1406)
SYSERR: Jul 18 15:58:59 :: ChildLoop: AsyncSQL: query failed: Incorrect integer value: 'Y' for column 'is_gm' at row 1 (query: INSERT INTO loginlog2(type, is_gm, login_time, channel, account_id, pid, ip, client_version) VALUES('INVALID', 'Y', NOW(), 1, 1, 1, inet_aton('192.168.0.104'), '') errno: 1366)
SYSERR: Jul 18 15:59:08 :: Analyze: login phase does not handle this packet! header 80
SYSERR: Jul 18 16:00:14 :: ChildLoop: AsyncSQL: query failed: Truncated incorrect time value: '2971:52:24' (query: UPDATE loginlog2 SET type='VALID', logout_time=NOW(), playtime=TIMEDIFF(logout_time,login_time) WHERE id=@i errno: 1292)
SYSERR: Jul 18 16:00:14 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 1, 958889, 272252, 0, 'LOGOUT', '192.168.0.104 1749500990 1 41 257', '192.168.0.104') errno: 1406)

Syserr din auth (/usr/home/game/server/aivory/auth) :

Cod: Selectaţi tot

SYSERR: Jul 18 15:35:02 :: pid_init: 
Start of pid: 2256

SYSERR: Jul 18 15:35:02 :: socket_bind: bind: Address already in use
SYSERR: Jul 18 15:43:08 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jul 18 15:43:08 :: pid_deinit: 
End of pid

SYSERR: Jul 18 15:44:28 :: pid_init: 
Start of pid: 2010

Syserr din canal99 (/usr/home/game/server/canale/canal99)-( Poate ajuta si acesta cu ceva ):

Cod: Selectaţi tot

SYSERR: Jul 18 15:35:01 :: pid_init: 
Start of pid: 2254

SYSERR: Jul 18 15:35:01 :: socket_bind: bind: Address already in use
SYSERR: Jul 18 15:35:02 :: ChildLoop: AsyncSQL::ChildLoop : mysql_query error: Out of range value for column 'time' at row 1:
query: INSERT INTO bootlog (time, hostname, channel) VALUES(NOW(), 'canal99', 99)
SYSERR: Jul 18 15:43:08 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jul 18 15:43:09 :: pid_deinit: 
End of pid

SYSERR: Jul 18 15:44:27 :: pid_init: 
Start of pid: 2008

Si pentru ca cel din db (/usr/home/game/server/aivory/db) este mult prea mare si nu-i pot da copy paste aici
O sa postez cate un pic, astfel primele linii sunt:

Cod: Selectaţi tot

SYSERR: Jul 18 15:34:57 :: pid_init: 
Start of pid: 2246

Apoi:

Cod: Selectaţi tot

SYSERR: Jul 18 15:34:57 :: Start: TABLE_POSTFIX not configured use default

Apoi, aceasta linie se repeta pentru toti monstri din joc, adica in loc de caine salbatic pe urmatoare este lup nu stiu de care... etc etc.

Cod: Selectaţi tot

SYSERR: Jul 18 15:34:58 :: ChildLoop: AsyncSQL: query failed: Data truncated for column 'size' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (101, "??", "Câine sălbatic", 0, 0, 0, 1, 0, 0,

Apoi mai sunt linii care arata in felul urmator, din nou, pentru toate itemele din joc am impresia :

Cod: Selectaţi tot

SYSERR: Jul 18 15:44:26 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'locale_name' at row 1 (query: replace into item_proto (vnum, type, subtype, name, locale_name, gold, shop_buy_price, weight, size, flag, wearflag, antiflag, immuneflag, refined_vnum, refine_set, magic_pct, socket_pct, addon_type, limittype0, limitvalue0, limittype1, limitvalue1, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, value0, value1, value2, value3, value4, value5 ) values (85014, 28, 2, "ëˇśě–„ ěžĄě‹ť ëť  (ě‚¬ěš©ěž ě •ěť)", "Eşarfă suveran (avansată)", 0, 0, 0, 1, 0, 0, 49536, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0)  errno: 1406)

Iar ultima linie din fisier este aceasta:

Cod: Selectaţi tot

SYSERR: Jul 18 15:44:26 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)

Inca 3 mesaje, si apoi daca este necesar o sa postez un link de mega unde uploadez fisierul complet.
Cat despre internet nu stiu ce sa zic, eu zic ca este ok ( stiu ca nu e cel mai stralucit dar nici nu ma pot plange de el ): Imagine

BeauDeCiuda · 18 Iul 2018, 12:21

uite si buba
"query failed: Incorrect integer value: 'Y' for column 'is_gm' at row 1 (query: INSERT INTO loginlog2(type, is_gm, login_time, channel, account_id, pid, ip, client_version) VALUES('INVALID', 'Y', NOW(), 1, 1, 1, "

g0dafk · 18 Iul 2018, 12:59

BeauDeCiuda scrie:uite si buba
"query failed: Incorrect integer value: 'Y' for column 'is_gm' at row 1 (query: INSERT INTO loginlog2(type, is_gm, login_time, channel, account_id, pid, ip, client_version) VALUES('INVALID', 'Y', NOW(), 1, 1, 1, "

Daca ai putea sa ma ajuti sa o si rezolv as fi recunoscator. Ce ar trebui sa fac?

g0dafk · 18 Iul 2018, 14:51

Deci, pana la urma am rezolvat problema cu incorrect integer value Y for column is_gm.
Asa arata syserr-ul acum:

Cod: Selectaţi tot

SYSERR: Jul 18 18:45:37 :: pid_init: 
Start of pid: 2402

SYSERR: Jul 18 18:45:37 :: socket_bind: bind: Address already in use
SYSERR: Jul 18 18:46:35 :: Analyze: login phase does not handle this packet! header 80

Sa fie si acel "login phase does not handle this packet ! header 80" de vina cu ceva?

Alte idei sugestii..?
Tot il scoate cand selecteaza caracterul..

g0dafk · 18 Iul 2018, 19:35

sus pls

g0dafk · 19 Iul 2018, 12:34

Resetare parola MySQL FreeBSD 11.2, HELP.

[GHID]Resetare parolă de la MySQL root în FreeBSD

Resetare parola FreeBSD

[TUTORIAL] Resetare parola root [Freebsd x]

Resetare parola mysql

Cine este conectat