Problem z serwerem

[krysti500]

Co w tym jest do naprawy bo nie mogę się logować i mam moduł mysql

= Multi Theft Auto: San Andreas v1.4

= Server name : XyzzyRP swieza instalacja = Server IP address:

= Server port : 22003

= Log file : .. 1.4/server/mods/deathmatch/logs/server.log = Maximum players : 100 = HTTP port : 22003 = Voice Chat : Disabled

= Bandwidth saving : Medium

[2014-10-01 17:10:24] ERROR: Couldn't find file ak47.txd for resource lss-ak47 [2014-10-01 17:10:24] Loading of resource 'lss-ak47' failed [2014-10-01 17:10:24] ERROR: Couldn't find file comet.txd for resource lss-club [2014-10-01 17:10:24] Loading of resource 'lss-club' failed [2014-10-01 17:10:24] ERROR: Couldn't find file colt45.txd for resource lss-colt45 [2014-10-01 17:10:24] Loading of resource 'lss-colt45' failed [2014-10-01 17:10:24] WARNING: Duplicate script file in resource 'lss-core': 'vehicles.lua' [2014-10-01 17:10:24] ERROR: Couldn't find file dft30.txd for resource lss-dft [2014-10-01 17:10:24] Loading of resource 'lss-dft' failed [2014-10-01 17:10:24] WARNING: Ignoring duplicate client file in resource 'lss-gui': 'img/EQ_heronina.png' [2014-10-01 17:10:24] ERROR: Couldn't find file n/wheel_sr1.dff for resource lss-kola [2014-10-01 17:10:24] Loading of resource 'lss-kola' failed [2014-10-01 17:10:25] ERROR: Couldn't find file vcnmav.txd for resource lss-pp488 [2014-10-01 17:10:25] Loading of resource 'lss-pp488' failed [2014-10-01 17:10:25] ERROR: Couldn't find file newsvan.txd for resource lss-pp582 [2014-10-01 17:10:25] Loading of resource 'lss-pp582' failed [2014-10-01 17:10:25] ERROR: Couldn't find file wmomib.dff for resource lss-skin-51 [2014-10-01 17:10:25] Loading of resource 'lss-skin-51' failed [2014-10-01 17:10:25] ERROR: Couldn't find file bmymib.dff for resource lss-skin-52 [2014-10-01 17:10:25] Loading of resource 'lss-skin-52' failed [2014-10-01 17:10:25] ERROR: Couldn't find file wmoprea.dff for resource lss-skin-62 [2014-10-01 17:10:25] Loading of resource 'lss-skin-62' failed [2014-10-01 17:10:25] ERROR: Couldn't find file 64.dff for resource lss-skin-fd [2014-10-01 17:10:25] Loading of resource 'lss-skin-fd' failed [2014-10-01 17:10:25] ERROR: Couldn't find file lekarka.dff for resource lss-skin-mc [2014-10-01 17:10:25] Loading of resource 'lss-skin-mc' failed [2014-10-01 17:10:25] ERROR: Couldn't find file 32.dff for resource lss-skin-mechanicy [2014-10-01 17:10:25] Loading of resource 'lss-skin-mechanicy' failed [2014-10-01 17:10:25] ERROR: Couldn't find file policjantka_biala.dff for resource lss-skin-pd [2014-10-01 17:10:25] Loading of resource 'lss-skin-pd' failed [2014-10-01 17:10:25] ERROR: Couldn't find file 105.dff for resource lss-skiny-co [2014-10-01 17:10:25] Loading of resource 'lss-skiny-co' failed [2014-10-01 17:10:25] ERROR: Couldn't find file 137.dff for resource lss-skiny-premium [2014-10-01 17:10:25] Loading of resource 'lss-skiny-premium' failed [2014-10-01 17:10:25] ERROR: Couldn't find file silenced.txd for resource lss-taser [2014-10-01 17:10:25] Loading of resource 'lss-taser' failed [2014-10-01 17:10:25] ERROR: Couldn't find file billbrdlawn.txd for resource lss-txd [2014-10-01 17:10:25] Loading of resource 'lss-txd' failed [2014-10-01 17:10:25] ERROR: Couldn't find file knifecur.txd for resource lss-weapon-noz [2014-10-01 17:10:25] Loading of resource 'lss-weapon-noz' failed [2014-10-01 17:10:25] ERROR: Couldn't find file lrp_cagoule.txd for resource lss-wear [2014-10-01 17:10:25] Loading of resource 'lss-wear' failed [2014-10-01 17:10:25] ERROR: Couldn't find file PoliceLight1.dff for resource samp_objects [2014-10-01 17:10:25] Loading of resource 'samp_objects' failed [2014-10-01 17:10:26] Resources: 266 loaded, 0 failed [2014-10-01 17:10:26] MODULE: Unable to load modules/mta_mysql.dll! [2014-10-01 17:10:26] MODULE: Unable to initialize modules/libmysql.dll! [2014-10-01 17:10:26] Starting resources... [2014-10-01 17:10:26] ERROR: Couldn't find resource parachute. Check it exists. [2014-10-01 17:10:26] ERROR: Couldn't find resource realdriveby. Check it exists. [2014-10-01 17:10:26] ERROR: [XyzzyRP]\DB\sql.lua:20: attempt to call global 'mysql_connect' (a nil value) [2014-10-01 17:10:27] ERROR: [XyzzyRP]\DB\sql.lua:47: attempt to call global 'mysql_query' (a nil value) [2014-10-01 17:10:27] ERROR: [XyzzyRP]\lss-budynki\biznesy.lua:223: call: failed to call 'DB:pobierzTabeleWynikow' [2014-10-01 17:10:27] ERROR: [XyzzyRP]\lss-budynki\biznesy.lua:224: bad argument #1 to 'ipairs' (table expected, got boolean) [2014-10-01 17:10:27] ERROR: Couldn't find resource lss-skiny-co. Check it exists. [2014-10-01 17:10:27] INFO: Zaladowano domow: 169 w 161ms [2014-10-01 17:10:27] WARNING: lss-frakcje/taxi_c.lua(Line 40) [Client] getVehicleModel is deprecated and may not work in future versions. Please replace with getElementModel. [2014-10-01 17:10:27] Some files in 'lss-frakcje' use deprecated functions. [2014-10-01 17:10:27] Use the 'upgrade' command to perform a basic upgrade of resources. [2014-10-01 17:10:27] ERROR: [XyzzyRP]\DB\sql.lua:47: attempt to call global 'mysql_query' (a nil value) [2014-10-01 17:10:27] ERROR: [XyzzyRP]\lss-frakcje\frakcje.lua:468: call: failed to call 'DB:pobierzTabeleWynikow' [2014-10-01 17:10:27] ERROR: [XyzzyRP]\lss-frakcje\frakcje.lua:469: bad argument #1 to 'ipairs' (table expected, got boolean) [2014-10-01 17:10:27] ERROR: [XyzzyRP]\DB\sql.lua:61: attempt to call global 'mysql_query' (a nil value) [2014-10-01 17:10:27] ERROR: [XyzzyRP]\lss-frakcje\cn.lua:66: call: failed to call 'DB:pobierzWyniki' [2014-10-01 17:10:28] ERROR: lss-gui guic.luac is invalid. Please re-compile at http://luac.mtasa.com/ [2014-10-01 17:10:28] ERROR: lss-gui ekwipunek.luac is invalid. Please re-compile at http://luac.mtasa.com/ [2014-10-01 17:10:28] WARNING: lss-gui/ekwipunek_s.lua(Line 46) [Server] isPlayerDead is deprecated and may not work in future versions. Please replace with isPedDead. [2014-10-01 17:10:28] ERROR: lss-gui telefonc.luac is invalid. Please re-compile at http://luac.mtasa.com/ [2014-10-01 17:10:28] ERROR: lss-gui afk_c.luac is invalid. Please re-compile at http://luac.mtasa.com/ [2014-10-01 17:10:28] Some files in 'lss-gui' use deprecated functions. [2014-10-01 17:10:28] Use the 'upgrade' command to perform a basic upgrade of resources. [2014-10-01 17:10:28] Server minclientversion is now 1.4.0-9.06836 [2014-10-01 17:10:28] WARNING: lss-gui2/hunger_c.lua(Line 36) [Client] isPlayerDead is deprecated and may not work in future versions. Please replace with isPedDead. [2014-10-01 17:10:28] Some files in 'lss-gui2' use deprecated functions. [2014-10-01 17:10:28] Use the 'upgrade' command to perform a basic upgrade of resources. [2014-10-01 17:10:28] ERROR: Couldn't find resource lss-clickandbuy. Check it exists. [2014-10-01 17:10:28] ERROR: lss-cn cam_c.luac is invalid. Please re-compile at http://luac.mtasa.com/ [2014-10-01 17:10:28] WARNING: lss-linaheli/lh_c.lua(Line 71) [Client] isPedInWater is deprecated and may not work in future versions. Please replace with isElementInWater. [2014-10-01 17:10:28] WARNING: lss-linaheli/lh_c.lua(Line 71) [Client] isPlayerDead is deprecated and may not work in future versions. Please replace with isPedDead. [2014-10-01 17:10:28] Some files in 'lss-linaheli' use deprecated functions. [2014-10-01 17:10:28] Use the 'upgrade' command to perform a basic upgrade of resources. [2014-10-01 17:10:28] ERROR: Couldn't find resource lss-logging. Check it exists. [2014-10-01 17:10:28] ERROR: lss-mapa ro.luac is invalid. Please re-compile at http://luac.mtasa.com/ [2014-10-01 17:10:28] ERROR: lss-muzyka eq_c.luac is invalid. Please re-compile at http://luac.mtasa.com/ [2014-10-01 17:10:28] WARNING: lss-ochrona/ochrona_c.lua [Client] is encoded in ANSI instead of UTF-8. Please convert your file to UTF-8. [2014-10-01 17:10:28] Some files in 'lss-ochrona' use deprecated functions. [2014-10-01 17:10:28] Use the 'upgrade' command to perform a basic upgrade of resources. [2014-10-01 17:10:29] ERROR: Couldn't find resource lss-paliwo. Check it exists. [2014-10-01 17:10:29] ERROR: Couldn't find resource lss-payment. Check it exists. [2014-10-01 17:10:29] ERROR: Couldn't find resource lss-pociagi. Check it exists. [2014-10-01 17:10:29] ERROR: Couldn't find resource lss-kartoteka. Check it exists. [2014-10-01 17:10:29] ERROR: [XyzzyRP]\DB\sql.lua:47: attempt to call global 'mysql_query' (a nil value) [2014-10-01 17:10:29] ERROR: [XyzzyRP]\lss-pojemniki\pojemniki.lua:14: call: failed to call 'DB:pobierzTabeleWynikow' [2014-10-01 17:10:29] ERROR: [XyzzyRP]\lss-pojemniki\pojemniki.lua:15: bad argument #1 to 'ipairs' (table expected, got boolean) [2014-10-01 17:10:29] WARNING: lss-vehicles/vehicles.lua(Line 347) [Server] setVehicleFrozen is deprecated and may not work in future versions. Please replace with setElementFrozen. [2014-10-01 17:10:29] WARNING: lss-vehicles/vehicles_c.lua(Line 332) [Client] setVehicleFrozen is deprecated and may not work in future versions. Please replace with setElementFrozen. [2014-10-01 17:10:29] Some files in 'lss-vehicles' use deprecated functions. [2014-10-01 17:10:29] Use the 'upgrade' command to perform a basic upgrade of resources. [2014-10-01 17:10:29] ERROR: [XyzzyRP]\DB\sql.lua:47: attempt to call global 'mysql_query' (a nil value) [2014-10-01 17:10:29] ERROR: [XyzzyRP]\lss-vehicles\vehicles.lua:169: call: failed to call 'DB:pobierzTabeleWynikow' [2014-10-01 17:10:29] ERROR: [XyzzyRP]\lss-vehicles\vehicles.lua:170: bad argument #1 to 'ipairs' (table expected, got boolean) [2014-10-01 17:10:29] ERROR: lss-silownia laweczka_c.lua is invalid. Please re-compile at http://luac.mtasa.com/ [2014-10-01 17:10:29] ERROR: lss-silownia bieznia_c.lua is invalid. Please re-compile at http://luac.mtasa.com/ [2014-10-01 17:10:29] ERROR: [XyzzyRP]\DB\sql.lua:47: attempt to call global 'mysql_query' (a nil value) [2014-10-01 17:10:29] ERROR: [XyzzyRP]\lss-telepickups\telepickups.lua:28: call: failed to call 'DB:pobierzTabeleWynikow' [2014-10-01 17:10:29] SyncMapElementData is now disabled [2014-10-01 17:10:29] WARNING: [XyzzyRP][obiekty]\gracz-sklep_super_sam\sklep.lua:4: Bad argument @ 'createPed' [Expected bool at argument 6, got number '225'] [2014-10-01 17:10:29] WARNING: [XyzzyRP][obiekty]\gracz-sklep_super_sam\sklep.lua:7: Bad argument @ 'setElementDimension' [Expected element at argument 1, got boolean] [2014-10-01 17:10:29] WARNING: [XyzzyRP][obiekty]\gracz-sklep_super_sam\sklep.lua:8: Bad argument @ 'setElementInterior' [Expected element at argument 1, got boolean] [2014-10-01 17:10:29] WARNING: [XyzzyRP][obiekty]\gracz-sklep_super_sam\sklep.lua:9: Bad argument @ 'setElementFrozen' [Expected element at argument 1, got boolean] [2014-10-01 17:10:29] WARNING: [XyzzyRP][obiekty]\gracz-sklep_super_sam\sklep.lua:10: Bad argument @ 'setElementData' [Expected element at argument 1, got boolean] [2014-10-01 17:10:29] WARNING: [XyzzyRP][obiekty]\gracz-sklep_super_sam\sklep.lua:11: Bad argument @ 'setElementData' [Expected element at argument 1, got boolean] [2014-10-01 17:10:30] INFO: obiektow: 337 [2014-10-01 17:10:30] ERROR: [XyzzyRP]\DB\sql.lua:61: attempt to call global 'mysql_query' (a nil value) [2014-10-01 17:10:30] ERROR: [XyzzyRP][obiekty]\lss-poczta\punkt_dystrybucji.lua:29: call: failed to call 'DB:pobierzWyniki' [2014-10-01 17:10:30] ERROR: [XyzzyRP]\DB\sql.lua:47: attempt to call global 'mysql_query' (a nil value) [2014-10-01 17:10:30] ERROR: [XyzzyRP][obiekty]\lss-prom\import_pojazdow.lua:28: call: failed to call 'DB:pobierzTabeleWynikow' [2014-10-01 17:10:30] ERROR: [XyzzyRP][obiekty]\lss-prom\import_pojazdow.lua:31: bad argument #1 to 'ipairs' (table expected, got boolean) [2014-10-01 17:10:30] ERROR: lss-scena naglosnienie_c.luac is invalid. Please re-compile at http://luac.mtasa.com/ [2014-10-01 17:10:31] WARNING: [XyzzyRP][obiekty]\lss-urzadmiasta\zasilki.lua:65: Bad argument @ 'setElementInterior' [Expected number at argument 2, got nil] [2014-10-01 17:10:31] WARNING: [XyzzyRP][obiekty]\lss-urzadmiasta\zasilki.lua:66: Bad argument @ 'setElementDimension' [Expected number at argument 2, got nil] [2014-10-01 17:10:31] WARNING: lss-warsztat1/warsztat_c.lua [Client] is encoded in ANSI instead of UTF-8. Please convert your file to UTF-8. [2014-10-01 17:10:31] Some files in 'lss-warsztat1' use deprecated functions. [2014-10-01 17:10:31] Use the 'upgrade' command to perform a basic upgrade of resources. [2014-10-01 17:10:31] WARNING: lss-wysypisko_smieci/pedy.lua [Client] is encoded in ANSI instead of UTF-8. Please convert your file to UTF-8. [2014-10-01 17:10:31] Some files in 'lss-wysypisko_smieci' use deprecated functions. [2014-10-01 17:10:31] Use the 'upgrade' command to perform a basic upgrade of resources. [2014-10-01 17:10:35] ERROR: wb-taxi Interior.lua is invalid. Please re-compile at http://luac.mtasa.com/ [2014-10-01 17:10:35] ERROR: wb-taxi Na_zewnatrz.lua is invalid. Please re-compile at http://luac.mtasa.com/ [2014-10-01 17:10:36] ERROR: wb-warsztat3 Interior.lua is invalid. Please re-compile at http://luac.mtasa.com/ [2014-10-01 17:10:36] ERROR: wb-warsztat4 Interior.lua is invalid. Please re-compile at http://luac.mtasa.com/ [2014-10-01 17:10:36] ERROR: wb-warsztat4 Warsztat4.lua is invalid. Please re-compile at http://luac.mtasa.com/ [2014-10-01 17:10:37] ERROR: zasieg_obiektow zasieg_obiektow.luac is invalid. Please re-compile at http://luac.mtasa.com/ [2014-10-01 17:10:37] ERROR: Couldn't find resource samp_objects. Check it exists. [2014-10-01 17:10:37] ERROR: Couldn't find resource . Check it exists. [2014-10-01 17:10:37] ERROR: Couldn't find resource chatbubble. Check it exists. [2014-10-01 17:10:37] ERROR: [XyzzyRP]\DB\sql.lua:70: attempt to call global 'mysql_query' (a nil value) [2014-10-01 17:10:37] ERROR: [XyzzyRP][community]\drawtag\sync.lua:163: call: failed to call 'DB:zapytanie' [2014-10-01 17:10:37] ERROR: [XyzzyRP]\DB\sql.lua:47: attempt to call global 'mysql_query' (a nil value) [2014-10-01 17:10:37] ERROR: [XyzzyRP][community]\drawtag\sync.lua:165: call: failed to call 'DB:pobierzTabeleWynikow' [2014-10-01 17:10:37] ERROR: [XyzzyRP][community]\drawtag\sync.lua:166: attempt to get length of local 'tagi' (a boolean value) [2014-10-01 17:10:37] WARNING: syncedfire/synced_fire_c.lua(Line 60) [Client] getVehicleRotation is deprecated and may not work in future versions. Please replace with getElementRotation. [2014-10-01 17:10:37] Some files in 'syncedfire' use deprecated functions. [2014-10-01 17:10:37] Use the 'upgrade' command to perform a basic upgrade of resources. [2014-10-01 17:10:37] ERROR: Couldn't find resource fireworkz. Check it exists. [2014-10-01 17:10:37] Querying MTA master server... success! (Auto detected IP:95.160.239.95) [2014-10-01 17:10:37] Server started and is ready to accept connections! [2014-10-01 17:10:37] To stop the server, type 'shutdown' or press Ctrl-C [2014-10-01 17:10:37] Type 'help' for a list of commands. [2014-10-01 17:10:37] INFO: zmiana pogody na 10

[Prezes]

Nie wgrałeś modułów odpowiadających za baze mysql. Albo twój hosting nie obsługuje tego.

[krysti500]

A w configu:

XyzzyRP swieza instalacja ``` 22003 100 22003 1 1 5 20 1 1.4.0-9.06836 1 1 medium 100 1500 500 500 1000 100 100 0 0 150 1 server-id.keys logs/server.log logs/server_auth.log logs/db.log acl.xml logs/scripts.log 0 0 60 0 0 1 4 backups 3 5 400 ```

[Prezes]

Podkreśl na POCZĄTKU, że stawiasz serwer na Windows'ie. Skonfigurowałeś serwer z bazą danych MYSQL ? Posiadasz wgl. taką baze ?

[krysti500]

wampserver skonfigurowany wszystko podane....

[Prezes]

[2014-10-01 17:10:29] ERROR: [XyzzyRP]\DB\sql.lua:47: attempt to call global 'mysql_query' (a nil value) Nie jest dobrye skonfigurowane...

[krysti500]

To jak to naprawić? Bo dane są ok...

[Prezes]

A ustawiłeś w pliku DB i DB2 ? Bo z logów wynika, że nic nie wpisałeś...

[krysti500]

Jest wpisane... plik DB

local SQL_LOGIN="gta" local SQL_PASSWD="haalo" local SQL_DB="gta" local SQL_HOST="localhost" local SQL_PORT=tonumber(get("port") or 3306)

plik DB2

SQL = dbConnect("mysql", "dbname=gta;host=localhost", "gta","haalo","share=1")

[Vinczers]

pomiędzy tym powinieneś wpisać IP serwera, znajdziesz je w panelu administracyjnym u twojego hostingu

[tomekb530]

Ehh, kolejny libmysql.dll ma byc tam dzie mta-server.exe

W dniu czwartek, 9 października 2014 Vinczers notifications@github.com napisał(a):

pomiędzy tym powinieneś wpisać IP serwera, znajdziesz je w panelu administracyjnym u twojego hostingu

— Reply to this email directly or view it on GitHub https://github.com/lpiob/MTA-XyzzyRP/issues/214#issuecomment-58548396.

[krysti500]

Ale co mam zrobić?

[tomekb530]

Masz w modules plik libmysql.dll skopiuj to do folderu tam gdzie masz mta-server.exe (jakkos tak) i odpal powinno działać