Ricop522 Posted February 14, 2011 Share Posted February 14, 2011 ========================================================== = Multi Theft Auto: San Andreas v1.0.4 =========================================================== = Server name : Mabako Script = Server IP address: = Server port : 22003 = = Log file : ..reas/server/mods/deathmatch/logs/server.log = Maximum players : 32 = MTU packet size : 1264 = HTTP port : 22005 =========================================================== [2011-02-14 19:29:22] Resources: 30 loaded, 0 failed [2011-02-14 19:29:22] Querying game-monitor.com master server... success! [2011-02-14 19:29:25] Querying backup master server... success! [2011-02-14 19:29:26] MODULE: Loaded "MySQL 5.0 database module" (0.41) by "Alberto Alonso <[email protected]>" [2011-02-14 19:29:26] MODULE: Loaded "SHA Module" (1.02) by "mabako" [2011-02-14 19:29:26] MODULE: Unable to find modules/ml_sockets.dll! [2011-02-14 19:29:26] Starting resources..... [2011-02-14 19:29:26] ERROR: Unable to start resource irc; Start up of resource cancelled by script [2011-02-14 19:29:26] ERROR: Unable to start resource players; Start up of resource cancelled by script [2011-02-14 19:29:26] ERROR: Unable to start resource vehicles; Start up of resource cancelled by script [2011-02-14 19:29:26] ERROR: Unable to start resource interiors; Start up of resource cancelled by script [2011-02-14 19:29:26] ERROR: Unable to start resource items; Start up of resource cancelled by script [2011-02-14 19:29:27] ERROR: Unable to start resource shops; Start up of resource cancelled by script [2011-02-14 19:29:28] ERROR: Unable to start resource maps; Start up of resource cancelled by script [2011-02-14 19:29:28] ERROR: Unable to start resource teleports; Start up of resource cancelled by script [2011-02-14 19:29:29] ERROR: Unable to start resource bank; Start up of resource cancelled by script [2011-02-14 19:29:29] ERROR: Unable to start resource factions; Start up of resource cancelled by script [2011-02-14 19:29:29] ERROR: Unable to start resource 3dtext; Start up of resource cancelled by script [2011-02-14 19:29:29] Server started and is ready to accept connections! [2011-02-14 19:29:29] Type 'help' for a list of commands. [2011-02-14 19:29:29] _ _ _ [2011-02-14 19:29:29] | | | (_) [2011-02-14 19:29:29] _ __ ___ | |_ __ _ _ __ __ _ _ __ __ _ __| |_ ___ ___ [2011-02-14 19:29:29] | '_ ` _ \| __/ _` | | '_ \ / _` | '__/ _` |/ _` | / __|/ _ \ [2011-02-14 19:29:29] | | | | | | || (_| | | |_) | (_| | | | (_| | (_| | \__ \ __/ [2011-02-14 19:29:29] |_| |_| |_|\__\__,_| | .__/ \__,_|_| \__,_|\__,_|_|___/\___| [2011-02-14 19:29:29] | | [2011-02-14 19:29:29] |_| v1.00 [2011-02-14 19:29:33] Available commands: update start stop stopall restart refresh refreshall list info install upgrade say teamsay asay msg amsg me nick login logout chgmypass addaccount delaccount chgpass shutdown aexec whois whowas debugscript sudo help loadmodule ver sver ase openports [2011-02-14 19:30:00] CONNECT: Joe_Flores connected (IP: 127.0.0.1 Serial: EC8DDD3922C8C47A3F85610ED9DEC7A1 Version: 1.0.4-9.02106.5) [2011-02-14 19:30:01] JOIN: Joe_Flores joined the game (IP: 127.0.0.1) [2011-02-14 19:30:06] ERROR: call: Failed, the resource players isn't running [string "?"] [2011-02-14 19:30:09] ERROR: call: Failed, the resource players isn't running [string "?"] [2011-02-14 19:30:15] ERROR: call: Failed, the resource players isn't running [string "?"] [2011-02-14 19:30:18] ERROR: call: Failed, the resource players isn't running [string "?"] [2011-02-14 19:30:18] ERROR: call: Failed, the resource players isn't running [string "?"] [2011-02-14 19:30:19] ERROR: call: Failed, the resource players isn't running [string "?"] [2011-02-14 19:30:20] ERROR: call: Failed, the resource players isn't running [string "?"] [2011-02-14 19:30:34] QUIT: Joe_Flores left the game [Quit] [2011-02-14 19:30:38] Server stopped! [2011-02-14 19:30:38] Stopping resources.................... [2011-02-14 19:30:38] Closing SQLite3 database [2011-02-14 19:30:38] Closing SQLite3 database I connect but don't show the login... Any ideas? Link to comment
0 dzek (varez) Posted February 15, 2011 Share Posted February 15, 2011 Follow the instructions how to install it correctly. Everything is wrong now. Moving topic to server support. Link to comment
0 MTA Team ccw Posted February 15, 2011 MTA Team Share Posted February 15, 2011 Please show the contents of mtaserver.conf Link to comment
0 Ricop522 Posted February 15, 2011 Author Share Posted February 15, 2011 Here is it! (( thanks for the help! )) <config> <!-- This parameter specifies the name the server will be visible as in the ingame server browser and on Game-Monitor. It is a required parameter. --> <servername>[bR]Advanced ~ Roleplay</servername> <!-- ONLY USE THIS PARAMETER IF YOU ARE SURE OF WHAT YOU ARE DOING - it is generally only needed for professional servers and should be left blank otherwise. This parameter specifies the IP to use for servers that have multiple IP addresses. If left blank, it will default to server's standard local IP address. --> <serverip></serverip> <!-- This parameter specifies the Maximum Transmission Unit or maximum packet size that the server will use. This will depend on the nature of your clients, as well as the network medium your server is connected to. --> <mtusize>1264</mtusize> <!-- This parameter specifies the UDP port on which the server will be accepting incoming player connections; default value: 22003. It is a required parameter. --> <serverport>22003</serverport> <!-- This parameter specifies the number of maximum player slots available on the server; default value: 32. It is a required parameter. --> <maxplayers>32</maxplayers> <!-- This parameter specifies whether the builtin http server will be used. Values: 0 - disabled , 1 - enabled ; default value: 1. Optional parameter. --> <httpserver>1</httpserver> <!-- This parameter specifies the TCP port on which the server will be accepting incoming http connections. It can be set to the same value as <serverport>. It is a required parameter if <httpserver> is set to 1. --> <httpport>22005</httpport> <!-- If set, this parameter specifies the external URL from which clients will be able to download needed resources ingame. Otherwise they will download them directly from the server. --> <httpdownloadurl></httpdownloadurl> <!-- This parameter specifies whether the client files for hosting on an external web server should be automatically copied into mods/deathmatch/resource-cache/http-client-files/ Only relevant if <httpdownloadurl> is set. Values: 0 - disabled , 1 - enabled ; default value: 1. Optional parameter. --> <httpautoclientfiles>1</httpautoclientfiles> <!-- This parameter limits the number of http connections each client can make. If you are using an external Apache web server, a lower figure such as 8 may be required to avoid download timeouts. A streamlined web server such as lighttpd, would benefit from the maximum setting of 32. (Note: If set to less than 32, pre 1.0.3 clients will be diverted to use MTA's inbuilt web server) Available range: 2 to 32. --> <httpconnectionsperclient>32</httpconnectionsperclient> <!-- This parameter specifies what types of checks the clients should make to ensure there has been no tampering with certain settings. Values: 0 - disabled , -1 - everything. default value: -1. --> <verifyclientsettings>-1</verifyclientsettings> <!-- This parameter can be used to make the server report to Game-Monitor master servers, allowing it to be visible in the ingame server browser. An additional UDP port needs to be available for this to work (value from <serverport> + 123 , so on a default <serverport> value 22003 the right port will be 22126 ). Available values: 0 - disabled , 1 - enabled. Optional parameter, defaults to 0. --> <ase>1</ase> <!-- This parameter allows you to disable LAN broadcasting. --> <donotbroadcastlan>0</donotbroadcastlan> <!-- If set, players will have to provide a password specified below, before they can connect to the server. If left blank, server doesn't require a password from them. --> <password></password> <!-- Specifies the location and name of the main server log file. If left blank, server won't be saving this file. --> <logfile>logs/server.log</logfile> <!-- This parameter specifies the location and name of the Access Control List settings file. If left blank, server will use acl.xml file, located in the same folder as this configuration file. --> <acl>acl.xml</acl> <!-- Specifies the location and name of the debugscript log file. If left blank, server won't be saving this file. --> <scriptdebuglogfile>logs/scripts.log</scriptdebuglogfile> <!-- Specifies the level of the debugscript log file. Available values: 0, 1, 2, 3. When not set, defaults to 0. --> <scriptdebugloglevel>0</scriptdebugloglevel> <!-- Specifies the level of the html debug. Available values: 0, 1, 2, 3. When not set, defaults to 0. --> <htmldebuglevel>0</htmldebuglevel> <!-- Specifies the server frames limit. Minimum value: 25, default: 36. --> <fpslimit>45</fpslimit> <module src="mta_mysql.dll"/> <module src="sha.dll"/> <module src="ml_sockets.dll"/> <!-- <module src="ml_sockets.dll"/> <module src="mta_mysql.dll"/> <module src="sha.dll"/> <module src="ml_sockets.dll"/> --> <!-- Specifies resources that are loaded when the server starts and/or which are protected from being stopped. To specify several resources, add more <resource> parameter(s). --> <resource src="parasite" startup="1"/> <resource src="paradise" startup="1" protected="1"/> <resource src="sql" startup="1"/> <resource src="irc" startup="1"/> <resource src="server" startup="1"/> <resource src="chat" startup="1"/> <resource src="players" startup="1"/> <resource src="gui" startup="1"/> <resource src="vehicles" startup="1"/> <resource src="interiors" startup="1"/> <resource src="nametags" startup="1"/> <resource src="items" startup="1"/> <resource src="vehicle-shop" startup="1"/> <resource src="admin" startup="1"/> <resource src="shops" startup="1"/> <resource src="job-carrier" startup="1"/> <resource src="job-bus" startup="1"/> <resource src="job-taxi" startup="1"/> <resource src="jobs" startup="1"/> <resource src="world" startup="1"/> <resource src="maps" startup="1"/> <resource src="teleports" startup="1"/> <resource src="anims" startup="1"/> <resource src="freecam" startup="1"/> <resource src="bank" startup="1"/> <resource src="factions" startup="1"/> <resource src="3dtext" startup="1"/> <resource src="injuries" startup="1"/> </config> Link to comment
0 MTA Team ccw Posted February 15, 2011 MTA Team Share Posted February 15, 2011 1. 'irc' resource is failing because 'ml_sockets.dll' is failing to load 2. The other resources are failing because "MySQL 5.0 database module" is having problems. Solution: 1. Get the latest nightly, as this will show you the MySQL errors: https://nightly.multitheftauto.com/?mtasa-1.0.4-rc-latest 2. To fix ml_sockets.dll, you need either: a) To find and put MSVCP90D.DLL and MSVCR90D.DLL next to ml_sockets.dll (and hope it works) orb) Get another version of ml_sockets.dll (and hope it works) This might be ok: http://multitheftauto-modules.googlecod ... ockets.dll Good luck! Link to comment
0 Ricop522 Posted February 16, 2011 Author Share Posted February 16, 2011 1. 'irc' resource is failing because 'ml_sockets.dll' is failing to load2. The other resources are failing because "MySQL 5.0 database module" is having problems. Solution: 1. Get the latest nightly, as this will show you the MySQL errors: https://nightly.multitheftauto.com/?mtasa-1.0.4-rc-latest 2. To fix ml_sockets.dll, you need either: a) To find and put MSVCP90D.DLL and MSVCR90D.DLL next to ml_sockets.dll (and hope it works) orb) Get another version of ml_sockets.dll (and hope it works) This might be ok: http://multitheftauto-modules.googlecod ... ockets.dll Good luck! I removed IRC, and I download a new version of ml_sockets from ml_sockets ( the link of what you give ) but don't load anothers.. =========================================================== = Multi Theft Auto: San Andreas v1.0.4 =========================================================== = Server name : Advanced ~ Roleplay = Server IP address: = Server port : 22003 = = Log file : ..reas/server/mods/deathmatch/logs/server.log = Maximum players : 32 = MTU packet size : 1264 = HTTP port : 22005 =========================================================== [2011-02-16 14:44:38] Resources: 208 loaded, 0 failed [2011-02-16 14:44:38] MODULE: Loaded "MySQL 5.0 database module" (0.41) by "Alberto Alonso <[email protected]>" [2011-02-16 14:44:38] MODULE: Loaded "SHA Module" (1.02) by "mabako" [2011-02-16 14:44:38] MODULE: Loaded "Sockets Module" (1.10) by "Gamesnert, MCvarial & x86" [2011-02-16 14:44:38] Starting resources....... [2011-02-16 14:44:38] ERROR: Unable to start resource players; Start up of resource cancelled by script [2011-02-16 14:44:38] ERROR: Unable to start resource vehicles; Start up of resource cancelled by script [2011-02-16 14:44:38] ERROR: Unable to start resource interiors; Start up of resource cancelled by script [2011-02-16 14:44:39] ERROR: Unable to start resource items; Start up of resource cancelled by script [2011-02-16 14:44:40] ERROR: Unable to start resource shops; Start up of resource cancelled by script [2011-02-16 14:44:40] ERROR: Unable to start resource maps; Start up of resource cancelled by script [2011-02-16 14:44:40] ERROR: Unable to start resource teleports; Start up of resource cancelled by script [2011-02-16 14:44:41] ERROR: Unable to start resource bank; Start up of resource cancelled by script [2011-02-16 14:44:41] ERROR: Unable to start resource factions; Start up of resource cancelled by script [2011-02-16 14:44:41] ERROR: Unable to start resource 3dtext; Start up of resource cancelled by script [2011-02-16 14:44:41] Server started and is ready to accept connections! Link to comment
0 MTA Team ccw Posted February 16, 2011 MTA Team Share Posted February 16, 2011 Have you updated the MTA server from here? https://nightly.multitheftauto.com/?mtasa-1.0.4-rc-latest Also, do you have a MySQL server running? Link to comment
0 Ricop522 Posted February 16, 2011 Author Share Posted February 16, 2011 I downloaded what you say and this show to me what's wrong. But i have no idea how to fix it. =========================================================== = Multi Theft Auto: San Andreas v1.0.4 =========================================================== = Server name : Advanced ~ Roleplay = Server IP address: = Server port : 22003 = = Log file : ..reas/server/mods/deathmatch/logs/server.log = Maximum players : 32 = MTU packet size : 1264 = HTTP port : 22005 =========================================================== [2011-02-16 18:25:39] Resources: 208 loaded, 0 failed [2011-02-16 18:25:39] MODULE: Loaded "MySQL 5.0 database module" (0.50) by "Alberto Alonso <[email protected]>" [2011-02-16 18:25:39] MODULE: Loaded "SHA Module" (1.02) by "mabako" [2011-02-16 18:25:39] MODULE: Loaded "Sockets Module" (1.10) by "Gamesnert, MCvarial & x86" [2011-02-16 18:25:39] Starting resources..... [2011-02-16 18:25:39] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:39] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:39] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:39] Start up of resource players cancelled by script [2011-02-16 18:25:39] ERROR: Unable to start resource players; Start up of resource cancelled by script [2011-02-16 18:25:39] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:39] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:39] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:39] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:39] Start up of resource vehicles cancelled by script [2011-02-16 18:25:39] ERROR: Unable to start resource vehicles; Start up of resource cancelled by script [2011-02-16 18:25:39] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:39] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:39] Start up of resource interiors cancelled by script [2011-02-16 18:25:39] ERROR: Unable to start resource interiors; Start up of resource cancelled by script [2011-02-16 18:25:39] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:39] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:39] Start up of resource players cancelled by script [2011-02-16 18:25:39] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:39] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:39] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:39] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:39] Start up of resource items cancelled by script [2011-02-16 18:25:39] ERROR: Unable to start resource items; Start up of resource cancelled by script [2011-02-16 18:25:39] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:39] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:39] Start up of resource players cancelled by script [2011-02-16 18:25:39] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:39] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:39] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:39] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:39] Start up of resource vehicles cancelled by script [2011-02-16 18:25:40] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:40] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:40] Start up of resource players cancelled by script [2011-02-16 18:25:40] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:40] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:40] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:40] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:40] Start up of resource items cancelled by script [2011-02-16 18:25:40] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:40] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:40] Start up of resource players cancelled by script [2011-02-16 18:25:40] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:40] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:40] Start up of resource players cancelled by script [2011-02-16 18:25:40] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:40] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:40] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:40] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:40] Start up of resource items cancelled by script [2011-02-16 18:25:40] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:40] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:40] Start up of resource players cancelled by script [2011-02-16 18:25:40] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:40] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:40] Start up of resource shops cancelled by script [2011-02-16 18:25:40] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:40] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:40] Start up of resource players cancelled by script [2011-02-16 18:25:40] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:40] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:40] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:40] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:40] Start up of resource items cancelled by script [2011-02-16 18:25:40] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:40] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:40] Start up of resource players cancelled by script [2011-02-16 18:25:40] ERROR: Unable to start resource shops; Start up of resource cancelled by script [2011-02-16 18:25:40] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:40] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:40] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:40] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:40] Start up of resource vehicles cancelled by script [2011-02-16 18:25:40] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:40] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:40] Start up of resource players cancelled by script [2011-02-16 18:25:40] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:40] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:40] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:40] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:40] Start up of resource items cancelled by script [2011-02-16 18:25:40] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:40] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:40] Start up of resource players cancelled by script [2011-02-16 18:25:40] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:40] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:40] Start up of resource shops cancelled by script [2011-02-16 18:25:40] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:40] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:40] Start up of resource players cancelled by script [2011-02-16 18:25:40] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:40] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:40] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:40] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:40] Start up of resource items cancelled by script [2011-02-16 18:25:40] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:40] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:40] Start up of resource players cancelled by script [2011-02-16 18:25:40] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:40] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:40] Start up of resource interiors cancelled by script [2011-02-16 18:25:40] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:40] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:40] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:40] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:40] Start up of resource vehicles cancelled by script [2011-02-16 18:25:40] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:40] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:40] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:40] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:40] Start up of resource vehicles cancelled by script [2011-02-16 18:25:41] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:41] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:41] Start up of resource maps cancelled by script [2011-02-16 18:25:41] ERROR: Unable to start resource maps; Start up of resource cancelled by script [2011-02-16 18:25:41] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:41] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:41] Start up of resource teleports cancelled by script [2011-02-16 18:25:41] ERROR: Unable to start resource teleports; Start up of resource cancelled by script [2011-02-16 18:25:41] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:41] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:41] Start up of resource players cancelled by script [2011-02-16 18:25:41] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:41] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:41] Start up of resource players cancelled by script [2011-02-16 18:25:41] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:41] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:41] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:41] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:41] Start up of resource items cancelled by script [2011-02-16 18:25:41] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:41] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:41] Start up of resource players cancelled by script [2011-02-16 18:25:41] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:41] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:41] Start up of resource bank cancelled by script [2011-02-16 18:25:41] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:41] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:41] Start up of resource players cancelled by script [2011-02-16 18:25:41] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:41] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:41] Start up of resource players cancelled by script [2011-02-16 18:25:41] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:41] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:41] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:41] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:41] Start up of resource items cancelled by script [2011-02-16 18:25:41] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:41] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:41] Start up of resource players cancelled by script [2011-02-16 18:25:41] ERROR: Unable to start resource bank; Start up of resource cancelled by script [2011-02-16 18:25:41] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:41] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:41] Start up of resource players cancelled by script [2011-02-16 18:25:41] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:41] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:41] Start up of resource factions cancelled by script [2011-02-16 18:25:41] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:41] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:41] Start up of resource players cancelled by script [2011-02-16 18:25:41] ERROR: Unable to start resource factions; Start up of resource cancelled by script [2011-02-16 18:25:41] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:25:41] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:25:41] Start up of resource 3dtext cancelled by script [2011-02-16 18:25:41] ERROR: Unable to start resource 3dtext; Start up of resource cancelled by script [2011-02-16 18:25:41] Server started and is ready to accept connections! [2011-02-16 18:25:41] Type 'help' for a list of commands. [2011-02-16 18:25:41] _ _ _ [2011-02-16 18:25:41] Advanced Roleplay_ _ _ [2011-02-16 18:25:41] _ _ _ [2011-02-16 18:25:41] Edited by Ricardo_ _ _ [2011-02-16 18:25:41] Thanks to Mabako Script _ _ [2011-02-16 18:25:41] _ _ _ [2011-02-16 18:25:41] | | [2011-02-16 18:25:41] |_| v1.55 [2011-02-16 18:26:00] Server stopped! [2011-02-16 18:26:00] Stopping resources......... [2011-02-16 18:26:00] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:26:00] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:26:00] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:26:00] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:26:00] Start up of resource vehicles cancelled by script [2011-02-16 18:26:00] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:26:00] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:26:00] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:26:00] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:26:00] Start up of resource vehicles cancelled by script [2011-02-16 18:26:00] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:26:00] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:26:00] ERROR: sql\mysql.lua:35: bad argument #5 to 'mysql_connect' (number expected, got string) [2011-02-16 18:26:00] ERROR: call: failed to call 'sql:create_table' [string "?"] [2011-02-16 18:26:00] Start up of resource vehicles cancelled by script [2011-02-16 18:26:00] Closing SQLite3 database [2011-02-16 18:26:00] Closing SQLite3 database I have XAMPP and PhpMyAdmin installed SQL/MYSQL.LUA --[[ Copyright (c) 2010 MTA: Paradise This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 3 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program. If not, see <http://www.gnu.org/licenses/>. ]] local connection = nil local connection = nil local null = nil local results = { } local max_results = 128 -- connection functions local function connect( ) -- retrieve the settings local server = get( "server" ) or "localhost" local user = get( "user" ) or "root" local password = get( "password" ) or "" local db = get( "database" ) or "mta" local port = get( "port" ) or 3306 local socket = get( "socket" ) or nil -- connect connection = mysql_connect ( server, user, password, db, port, socket ) if connection then if user == "root" then setTimer( outputDebugString, 100, 1, "Connecting to your MySQL as 'root' is strongly discouraged.", 2 ) end return true else outputDebugString ( "Connection to MySQL Failed.", 1 ) return false end end local function disconnect( ) if connection and mysql_ping( connection ) then mysql_close( connection ) end end local function checkConnection( ) if not connection or not mysql_ping( connection ) then return connect( ) end return true end addEventHandler( "onResourceStart", resourceRoot, function( ) if not mysql_connect then if hasObjectPermissionTo( resource, "function.shutdown" ) then shutdown( "MySQL module missing." ) end cancelEvent( true, "MySQL module missing." ) elseif not hasObjectPermissionTo( resource, "function.mysql_connect" ) then if hasObjectPermissionTo( resource, "function.shutdown" ) then shutdown( "Insufficient ACL rights for mysql resource." ) end cancelEvent( true, "Insufficient ACL rights for mysql resource." ) elseif not connect( ) then if connection then outputDebugString( mysql_error( connection ), 1 ) end if hasObjectPermissionTo( resource, "function.shutdown" ) then shutdown( "MySQL failed to connect." ) end cancelEvent( true, "MySQL failed to connect." ) else null = mysql_null( ) end end ) addEventHandler( "onResourceStop", resourceRoot, function( ) for key, value in pairs( results ) do mysql_free_result( value.r ) outputDebugString( "Query not free()'d: " .. value.q, 2 ) end disconnect( ) end ) -- function escape_string( str ) if type( str ) == "string" then return mysql_escape_string( connection, str ) elseif type( str ) == "number" then return tostring( str ) end end local function query( str, ... ) checkConnection( ) if ( ... ) then local t = { ... } for k, v in ipairs( t ) do t[ k ] = escape_string( tostring( v ) ) or "" end str = str:format( unpack( t ) ) end local result = mysql_query( connection, str ) if result then for num = 1, max_results do if not results[ num ] then results[ num ] = { r = result, q = str } return num end end mysql_free_result( result ) return false, "Unable to allocate result in pool" end return false, mysql_error( connection ) end function query_free( str, ... ) if sourceResource == getResourceFromName( "runcode" ) then return false end checkConnection( ) if ( ... ) then local t = { ... } for k, v in ipairs( t ) do t[ k ] = escape_string( tostring( v ) ) or "" end str = str:format( unpack( t ) ) end local result = mysql_query( connection, str ) if result then mysql_free_result( result ) return true end return false, mysql_error( connection ) end function free_result( result ) if results[ result ] then mysql_free_result( results[ result ].r ) results[ result ] = nil end end function query_assoc( str, ... ) if sourceResource == getResourceFromName( "runcode" ) then return false end local t = { } local result, error = query( str, ... ) if result then for result, row in mysql_rows_assoc( results[ result ].r ) do local num = #t + 1 t[ num ] = { } for key, value in pairs( row ) do if value ~= null then t[ num ][ key ] = tonumber( value ) or value end end end free_result( result ) return t end return false, error end function query_assoc_single( str, ... ) if sourceResource == getResourceFromName( "runcode" ) then return false end local t = { } local result, error = query( str, ... ) if result then local row = mysql_fetch_assoc( results[ result ].r ) if row then for key, value in pairs( row ) do if value ~= null then t[ key ] = tonumber( value ) or value end end free_result( result ) return t end free_result( result ) return false end return false, error end function query_insertid( str, ... ) if sourceResource == getResourceFromName( "runcode" ) then return false end local result, error = query( str, ... ) if result then local id = mysql_insert_id( connection ) free_result( result ) return id end return false, error end function query_affected_rows( str, ... ) if sourceResource == getResourceFromName( "runcode" ) then return false end local result, error = query( str, ... ) if result then local rows = mysql_affected_rows( connection ) free_result( result ) return rows end return false, error end Link to comment
0 MTA Team ccw Posted February 16, 2011 MTA Team Share Posted February 16, 2011 I guess line 31 of sql\mysql.lua ought to be changed: [strike]local port = get( "port" ) or 3306[/strike] local port = tonumber( get( "port" ) or 3306 ) But I can't be sure. I suggest you contact the author of the script. Link to comment
0 Ricop522 Posted February 16, 2011 Author Share Posted February 16, 2011 Don't work = / But very thanks with your help. I'll try to make my roleplay server... ( without character create T_T ) Thanks again. Link to comment
Question
Ricop522
I connect but don't show the login...
Any ideas?
Link to comment
9 answers to this question
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now