Wei Posted April 4, 2012 Share Posted April 4, 2012 Could anyone do the MySql set up ? I have a lot of problems with it. And I want to redirect it to freehost website. If could anyone be good to me and I will give him my Team Viewer. add me on skype: hellobitchy1 or PM here. Edit: I have looked on wiki for the files ant they are installed. Link to comment
Todd Posted April 4, 2012 Share Posted April 4, 2012 https://wiki.multitheftauto.com/wiki/Modules/MTA-MySQL https://wiki.multitheftauto.com/wiki/Modules/MTA- ... ysql_query mtaserver.conf "mta_mysql.dll"/> .so if you have got linux settings.xml -- MySQL Configuration --> "@sql.username" value="login for database"/> "@sql.password" value="password for database"/> "@sql.database" value="databasename"/> "@sql.hostname" value="localhost"/> "@sql.port" value="3306"/> "@sql.socket" value="/var/run/mysql/mysql.sock"/> and you have to download "sql" resource sql resource: http://github.com/mabako/mta-paradise/t ... urces/sql/ here's some resource by driver2 https://community.multitheftauto.com/index.php?p= ... ils&id=495 Link to comment
Wei Posted April 4, 2012 Author Share Posted April 4, 2012 shows this error. as you can se i have the file in map. Link to comment
Todd Posted April 4, 2012 Share Posted April 4, 2012 MODULE: Unable to find modules/mta_mysql.dll Check if you have got in mtaserver.conf or check if you have this file if you don't then download it from here: CLICK and put it into the modules folder there is also Access denied @ 'shutdown' error and some error in the script. Link to comment
Wei Posted April 4, 2012 Author Share Posted April 4, 2012 MODULE: Unable to find modules/mta_mysql.dllCheck if you have got in mtaserver.conf or check if you have this file if you don't then download it from here: CLICK and put it into the modules folder I have both okay. Any idea ? Link to comment
Todd Posted April 4, 2012 Share Posted April 4, 2012 can you show me your settings.xml file and mtaserver.conf? Link to comment
Wei Posted April 4, 2012 Author Share Posted April 4, 2012 can you show me your settings.xml file and mtaserver.conf? SURE! <settings> <setting name="*deathpickups.only_current" value="[ false ]"></setting> <setting name="*scoreboard.allowColorcodedNames" value='[ "false" ]'></setting> <setting name="@sql.username" value="a2180746_mta"/> <setting name="@sql.password" value="******"/> <setting name="@sql.database" value="a2180746_mta"/> <setting name="@sql.hostname" value="mysql16.000webhost.com"/> <setting name="@sql.port" value="3306"/> <setting name="@sql.socket" value="/var/run/mysql/mysql.sock"/> </settings> <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>[sHG] RPG|RP server |Police/medic/taxi/army/S.W.A.T|</servername> <module src="mta_mysql.dll" /> <!-- 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> <!-- SERVERIP SHOULD BE LEFT BLANK UNLESS YOU ARE SURE OF WHAT YOU ARE DOING --> <!-- 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>60</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>28999</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 is deprecated. Please use httpmaxconnectionsperclient instead--> <httpconnectionsperclient></httpconnectionsperclient> <!-- This parameter limits the number of http connections each client can make. Depending on the type of http server that is used, a lower figure may reduce download timeouts. Available range: 1 to 8. --> <httpmaxconnectionsperclient>5</httpmaxconnectionsperclient> <!-- This parameter limits the number http connections that an IP can initiate over a short period of time. Available range: 1 to 100. default value: 20 --> <httpdosthreshold>20</httpdosthreshold> <!-- By default, the server will block the use of customized GTA:SA data files. --> <!-- To allow specific client files, add one or more of the following: --> <!-- <client_file name="data/handling.cfg" verify="0"/> --> <!-- Comma seperated list of disabled anti-cheats. e.g. To disable anti-cheat #2 and #3, use: 2,3 --> <disableac></disableac> <!-- Comma seperated list of enabled special detections. A special detection is a type of anti-cheat for (usually) harmless game modifications. Competitive servers may wish to enable special detections, but most servers should leave this setting blank. e.g. To enable special detection #12 use: 12 --> <enablesd></enablesd> <!-- This parameter specifies whether communications between the server and client is encrypted. Encryption can help prevent network data being viewed and modified. Values: 0 - disabled , 1 - enabled ; default value: 1. Optional parameter. --> <networkencryption>1</networkencryption> <!-- Minimum client version. Clients with a lower version will not be allowed to connect. After disconnection, clients will be given an opportunity to download an update. If left blank, this setting is disabled and there are no restrictions on who can connect. Version numbers are described here: [url=https://wiki.multitheftauto.com/wiki/GetPlayerVersion]https://wiki.multitheftauto.com/wiki/GetPlayerVersion[/url] and look like this: 1.1.0-9.03100.0 --> <minclientversion></minclientversion> <!-- Recommended client version. When connecting, if clients have a lower version, they will be given the option to download an update. If left blank, this setting is disabled. --> <recommendedclientversion></recommendedclientversion> <!-- 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>unknown</password> <!-- This parameter reduces the server's bandwidth usage by using various optimizations. Values: none, medium or maximum ; default value: medium --> <bandwidth_reduction>medium</bandwidth_reduction> <!-- This parameter specifies whether or not to run the network synchronization on another thread. Enabling will make the sync smoother, but may increase cpu usage slightly. Values: 0 - Off, 1 - On. Default - 1 --> <threadnet>1</threadnet> <!-- Specifies the location and file name of this servers unique private key. This is used to prevent private files saved on the client from being read by other servers. More infomation about client private files can be found here: [url=https://wiki.multitheftauto.com/wiki/Filepath]https://wiki.multitheftauto.com/wiki/Filepath[/url] Keep a backup of this file in a safe place. Default value: server-id.keys--> <idfile>server-id.keys</idfile> <!-- 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> <!-- As well as the main log file, login successes and failures are logged here for easy reviewing of security issues. If left blank, this file is not used --> <authfile>logs/server_auth.log</authfile> <!-- Specifies the location and name of the file used to log database queries. The server command 'debugdb' sets the amount of logging. --> <dbfile>logs/db.log</dbfile> <!-- 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 frame rate limit that will be applied to connecting clients. Available range: 25 to 100. Default: 36. --> <fpslimit>36</fpslimit> <!-- Specifies whether or not players should automatically be logged in based on their IP adresses --> <autologin>0</autologin> <!-- This parameter specifies whether or not to enable player voice chat in-game Values: 0 - disabled , 1 - enabled --> <voice>0</voice> <!-- This parameter specifies the sample rate for voice chat. 'voice' parameter must be set to 1 for this to be effective. Higher settings use more bandwidth and increase the sampling quality of voice chat Values: 0 - Narrowband (8kHz), 1 - Wideband (16kHz), 2 - Ultrawideband (32kHz). Default - 1 --> <voice_samplerate>1</voice_samplerate> <!-- This parameter specifies the voice quality for voice chat. 'voice' parameter must be set to 1 for this to be effective. Higher settings use more bandwidth and increase the the overall quality of voice chat Available range: 0 to 10. Default - 4 --> <voice_quality>4</voice_quality> <!-- Specifies the voice bitrate, in bps. This optional parameter overrides the previous two settings. If not set, MTA handles this automatically. Use with care. --> <!-- <voice_bitrate>24600</voice_bitrate> --> <!-- This parameter specifies the path to use for a basic backup of some server files. Note that basic backups are only made during server startup. Default value: backups --> <backup_path>backups</backup_path> <!-- This parameter specifies the number of days between each basic backup. Backups are only made during server startup, so the actual interval maybe much longer. Setting backup_interval to 0 will disable backups Available range: 0 to 30. Default - 3 --> <backup_interval>3</backup_interval> <!-- This parameter specifies the maximum number of backup copies to keep. Setting backup_copies to 0 will disable backups Available range: 0 to 100. Default - 5 --> <backup_copies>5</backup_copies> <!-- Specifies the module(s) which are loaded with the server. To load several modules, add more <module> parameter(s). Optional parameter. --> <!-- <module src="sample_win32.dll"/> --> <!-- <module src="sample_linux.so"/> --> <!-- 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="sql" startup="1" protected="0" /> <resource src="admin" startup="1" protected="0" /> <resource src="defaultstats" startup="1" protected="0" /> <resource src="joinquit" startup="1" protected="0" /> <resource src="mapcycler" startup="1" protected="0" /> <resource src="mapmanager" startup="1" protected="0" /> <resource src="parachute" startup="1" protected="0" /> <resource src="resourcebrowser" startup="1" protected="1" default="true" /> <resource src="resourcemanager" startup="1" protected="1" /> <resource src="scoreboard" startup="1" protected="0" /> <resource src="spawnmanager" startup="1" protected="0" /> <resource src="voice" startup="1" protected="0" /> <resource src="votemanager" startup="1" protected="0" /> <resource src="webadmin" startup="1" protected="0" /> <resource src="playerblips" startup="1" protected="0" /> <resource src="SHGbank" startup="1" protected="0" /> <resource src="SHGlogin-system" startup="1" protected="0" /> <resource src="SHGmapstuff" startup="1" protected="0" /> <resource src="SHGmisions" startup="1" protected="0" /> <resource src="SHGpolicebikespawn" startup="1" protected="0" /> <resource src="SHGrpg" startup="1" protected="0" /> <resource src="SHGscoreboardaddons" startup="1" protected="0" /> <resource src="roleplay" startup="1" protected="0" /> <resource src="SHGtools" startup="1" protected="0" /> <!-- play is the default freeroam gamemode. Remove the following line to prevent it from starting. --> </config> Link to comment
Todd Posted April 4, 2012 Share Posted April 4, 2012 acl.xml too I want to see something Link to comment
Wei Posted April 4, 2012 Author Share Posted April 4, 2012 <acl> <group name="Everyone"> <acl name="Default"></acl> <object name="user.*"></object> <object name="resource.*"></object> </group> <group name="Moderator"> <acl name="Moderator"></acl> <object name="resource.mapcycler"></object> <object name="resource.mapmanager"></object> <object name="resource.resourcemanager"></object> <object name="resource.votemanager"></object> </group> <group name="SuperModerator"> <acl name="Moderator"></acl> <acl name="SuperModerator"></acl> </group> <group name="Admin"> <acl name="Moderator"></acl> <acl name="SuperModerator"></acl> <acl name="Admin"></acl> <acl name="RPC"></acl> <object name="resource.admin"></object> <object name="resource.SHGlogin"></object> <object name="resource.scoreboard"></object> <object name="resource.SHGscoreboardgroup"></object> <object name="user.MalaGlavica"></object> <object name="user.blazy"></object> <object name="resource.gatemaker"></object> <object name="resource.SHGtools"></object> <object name="resource.sql"></object> </group> <group name="Owner"> <acl name="Moderator"></acl> <acl name="SuperModerator"></acl> <acl name="Admin"></acl> <acl name="Owner"></acl> <acl name="RPC"></acl> </group> <group name="VIP"> <acl name="Moderator"></acl> <acl name="SuperModerator"></acl> <acl name="Admin"></acl> <acl name="Owner"></acl> <acl name="VIP"></acl> <acl name="RPC"></acl> </group> <group name="Console"> <acl name="Moderator"></acl> <acl name="SuperModerator"></acl> <acl name="Admin"></acl> <acl name="RPC"></acl> <object name="user.Console"></object> </group> <group name="RPC"> <acl name="RPC"></acl> </group> <group name="MapEditor"> <acl name="Default"></acl> <acl name="MapEditor"></acl> <object name="resource.editor_main"></object> <object name="resource.edf"></object> <object name="user.testing"></object> <object name="resource.toolbox"></object> </group> <group name="raceACLGroup"> <acl name="Default"></acl> <acl name="raceACL"></acl> <object name="resource.race"></object> </group> <group name="admin - Trial"></group> <group name="Co Leader"></group> <acl name="Default"> <right name="general.ModifyOtherObjects" access="false"></right> <right name="general.http" access="false"></right> <right name="command.redo" access="false"></right> <right name="command.nextmap" access="false"></right> <right name="command.gm" access="false"></right> <right name="command.ghostmode" access="false"></right> <right name="command.push" access="false"></right> <right name="command.smash" access="false"></right> <right name="command.givecash" access="false"></right> <right name="command.start" access="false"></right> <right name="command.stop" access="false"></right> <right name="command.stopall" access="false"></right> <right name="command.gamemode" access="false"></right> <right name="command.changemode" access="false"></right> <right name="command.changemap" access="false"></right> <right name="command.stopmode" access="false"></right> <right name="command.stopmap" access="false"></right> <right name="command.skipmap" access="false"></right> <right name="command.restart" access="false"></right> <right name="command.refresh" access="false"></right> <right name="command.refreshall" access="false"></right> <right name="command.addaccount" access="false"></right> <right name="command.delaccount" access="false"></right> <right name="command.debugscript" access="false"></right> <right name="command.chgpass" access="false"></right> <right name="command.loadmodule" access="false"></right> <right name="command.upgrade" access="false"></right> <right name="command.mute" access="false"></right> <right name="command.crun" access="false"></right> <right name="command.srun" access="false"></right> <right name="command.run" access="false"></right> <right name="command.unmute" access="false"></right> <right name="command.kick" access="false"></right> <right name="command.ban" access="false"></right> <right name="command.banip" access="false"></right> <right name="command.unbanip" access="false"></right> <right name="command.shutdown" access="false"></right> <right name="command.install" access="false"></right> <right name="command.aexec" access="false"></right> <right name="command.whois" access="false"></right> <right name="command.whowas" access="false"></right> <right name="function.executeCommandHandler" access="false"></right> <right name="function.setPlayerMuted" access="false"></right> <right name="function.addAccount" access="true"></right> <right name="function.addBan" access="true"></right> <right name="function.removeBan" access="false"></right> <right name="function.removeAccount" access="false"></right> <right name="function.setAccountPassword" access="false"></right> <right name="function.kickPlayer" access="false"></right> <right name="function.banIP" access="false"></right> <right name="function.banPlayer" access="false"></right> <right name="function.banSerial" access="false"></right> <right name="function.getBansXML" access="false"></right> <right name="function.unbanIP" access="false"></right> <right name="function.unbanSerial" access="false"></right> <right name="function.getClientIP" access="false"></right> <right name="function.setServerPassword" access="false"></right> <right name="function.getServerPassword" access="false"></right> <right name="function.callRemote" access="false"></right> <right name="function.startResource" access="false"></right> <right name="function.stopResource" access="false"></right> <right name="function.restartResource" access="false"></right> <right name="function.createResource" access="false"></right> <right name="function.copyResource" access="false"></right> <right name="function.addResourceMap" access="false"></right> <right name="function.addResourceConfig" access="false"></right> <right name="function.removeResourceFile" access="false"></right> <right name="function.setResourceDefaultSetting" access="false"></right> <right name="function.removeResourceDefaultSetting" access="false"></right> <right name="function.redirectPlayer" access="false"></right> <right name="function.aclReload" access="false"></right> <right name="function.aclSave" access="false"></right> <right name="function.aclCreate" access="false"></right> <right name="function.aclDestroy" access="false"></right> <right name="function.aclSetRight" access="false"></right> <right name="function.aclRemoveRight" access="false"></right> <right name="function.aclCreateGroup" access="false"></right> <right name="function.aclDestroyGroup" access="false"></right> <right name="function.aclGroupAddACL" access="false"></right> <right name="function.aclGroupRemoveACL" access="false"></right> <right name="function.aclGroupAddObject" access="false"></right> <right name="function.aclGroupRemoveObject" access="false"></right> <right name="general.adminpanel" access="false"></right> <right name="general.tab_players" access="false"></right> <right name="general.tab_resources" access="false"></right> <right name="general.tab_maps" access="false"></right> <right name="general.tab_server" access="false"></right> <right name="general.tab_bans" access="false"></right> <right name="general.tab_adminchat" access="false"></right> <right name="command.freeze" access="false"></right> <right name="command.shout" access="false"></right> <right name="command.spectate" access="false"></right> <right name="command.slap" access="false"></right> <right name="command.setgroup" access="false"></right> <right name="command.sethealth" access="false"></right> <right name="command.setarmour" access="false"></right> <right name="command.setmoney" access="false"></right> <right name="command.setskin" access="false"></right> <right name="command.setteam" access="false"></right> <right name="command.giveweapon" access="false"></right> <right name="command.setstat" access="false"></right> <right name="command.jetpack" access="false"></right> <right name="command.warp" access="false"></right> <right name="command.setdimension" access="false"></right> <right name="command.setinterior" access="false"></right> <right name="command.givevehicle" access="false"></right> <right name="command.repair" access="false"></right> <right name="command.blow" access="false"></right> <right name="command.destroy" access="false"></right> <right name="command.customize" access="false"></right> <right name="command.setcolor" access="false"></right> <right name="command.setpaintjob" access="false"></right> <right name="command.listmessages" access="false"></right> <right name="command.readmessage" access="false"></right> <right name="command.listresources" access="false"></right> <right name="command.execute" access="false"></right> <right name="command.setpassword" access="false"></right> <right name="command.setwelcome" access="false"></right> <right name="command.setgame" access="false"></right> <right name="command.setmap" access="false"></right> <right name="command.setweather" access="false"></right> <right name="command.blendweather" access="false"></right> <right name="command.setblurlevel" access="false"></right> <right name="command.setwaveheight" access="false"></right> <right name="command.setskygradient" access="false"></right> <right name="command.setgamespeed" access="false"></right> <right name="command.setgravity" access="false"></right> <right name="command.settime" access="false"></right> <right name="command.unban" access="false"></right> <right name="command.banserial" access="false"></right> <right name="command.unbanserial" access="false"></right> <right name="command.listbans" access="false"></right> <right name="command.random" access="false"></right> <right name="command.setnick" access="false"></right> </acl> DELETED SOMETHING... because of too big post Link to comment
Todd Posted April 4, 2012 Share Posted April 4, 2012 hmm everything looks ok but are you sure that you configured sql correctly? really strange...really.... theoretically something is wrong in settings.xml or mysql.lua file in mysql.lua you have to change too dbname etc. Link to comment
arezu Posted April 4, 2012 Share Posted April 4, 2012 why dont you use mta's own official mysql functions? they are better. like this one: https://wiki.multitheftauto.com/wiki/DbConnect Link to comment
Castillo Posted April 4, 2012 Share Posted April 4, 2012 Because he's using MTA paradise, he would need to re-script most of scripts to implement it. Link to comment
drk Posted April 4, 2012 Share Posted April 4, 2012 Check if you have the last mysql module version, it occurred to me too because mysql module version. Link to comment
Wei Posted April 5, 2012 Author Share Posted April 5, 2012 (edited) I have the last version. I'm sure. Than could anyone send the whole server to me ( without resources ) and mysql intalled ofc. Edited April 5, 2012 by Guest Link to comment
Wei Posted April 5, 2012 Author Share Posted April 5, 2012 Did you add / to mtaserver.conf? Yeah i've posted my mtaserver.conf. Link to comment
GTX Posted April 5, 2012 Share Posted April 5, 2012 Did you put libmysql.dll into your folder where MTA Server.exe is? Link to comment
Wei Posted April 5, 2012 Author Share Posted April 5, 2012 Did you put libmysql.dll into your folder where MTA Server.exe is? yeah it was that. I had it into the deathmatch folder Link to comment
Wei Posted April 5, 2012 Author Share Posted April 5, 2012 Now I have problem with the sql resource. How can I make it to it will get settings from settings.xml ? Error: Link to comment
GTX Posted April 5, 2012 Share Posted April 5, 2012 Did you wrote correct password? Try by creating new user. Link to comment
X-SHADOW Posted April 5, 2012 Share Posted April 5, 2012 Dose it Have Admin Rights ? and Are You Admin ? Link to comment
GTX Posted April 5, 2012 Share Posted April 5, 2012 Dose it Have Admin Rights ?and Are You Admin ? He already posted his ACL, and he added the sql resource to ACL. As far as I remember, admin doesn't rights to command "shutdown" Link to comment
drk Posted April 5, 2012 Share Posted April 5, 2012 X-SHADOW it have nothing about admin rights. Link to comment
X-SHADOW Posted April 5, 2012 Share Posted April 5, 2012 Yes it do if your not admin /shutdown wont Work . Link to comment
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