Ajuda Não consigo deixar meu wodbo online

[kevin234 0]

Ola amigos não sei se estou postando esse tópico na área certa mas vamos la estou com um erro no meu wodbo quando eu vou deixar ele online da o seguinte erro 

 

mysql error mysql_real_connect: Can't connect to mysql server on 'localhost' (10061)

 

Error:Unable to load bans

 

se alguém souber como tirar esse erro avise o mais rápido possível 

 

Obrigado pela atenção

[Smart Maxx 166]

no seu config.lua troque :

sqlHost = "localhost"

por

sqlHost = "127.0.0.1"

ou

sqlHost = "seu ip"

[kevin234 0]

Smart Maxx n deu certo

 

 

no seu config.lua troque :

sqlHost = "localhost"

por

sqlHost = "127.0.0.1"

ou

sqlHost = "seu ip"

mano n deu certo

[Smart Maxx 166]

posta seu config.lua em spoiler ae \/

[kevin234 0]

posta seu config.lua em spoiler ae \/

mano agr aparece isso

loading bans mysql error mysql_real_connect host 'home-pc' is not allowed to connect to this mysql server

 

error unable to load bans

posta seu config.lua em spoiler ae \/

aki o  -------- config.lua --------

-- Config file for OTServ --

----------------------------

 

-- data directory location

datadir = "data/"

 

-- map location

map = "data/world/map.otbm"

 

-- mapkind

-- options: OTBM for binary map, XML for OTX map

mapkind = "OTBM"

 

-- map store location (for XML only)

mapstore = "data/world/map-mapstore.xml"

 

-- house store location (for XML only)

housestore = "data/world/map-housestore.xml"

 

-- bans storage (for XML only)

banIdentifier = "data/bans.xml"

 

-- server name

servername = "Dragon Ball Z Arena"

 

-- server location

location = "Brasil"

 

-- server ip (the ip that server listens on)

ip = "192.168.3.4"

 

-- server port (the port that server listens on)

port = "7171"

 

-- server owner name

ownername = "Arena"

 

-- world type

-- options: pvp, no-pvp, pvp-enforced

worldtype = "pvp"

 

-- exhausted time in ms (1000 = 1 second) for none-aggressive spells/weapons

exhausted = 2000

 

-- exhausted time in ms (1000 = 1 second) for aggressive spells/weapons 

fightexhausted = 2000

 

-- how many ms to add if the player is already exhausted and tries to cast a spell (1000 = 1 second)

exhaustedadd = 2000

 

-- how long does the player has to stay out of fight to get pz unlocked in ms (1000 = 1 second)

pzlocked = 25*1000

 

-- set to 0 = disabled (default), 1 = enabled 

enablehotkeys = 1 

 

-- minimum amount of time between actions ('Use') (1000 = 1 second)

minactioninterval = 100

 

-- minimum amount of time between extended actions ('Use with...') (1000 = 1 second)

minactionexinterval = 2000

 

-- how many messages player can span before get muted

maxmessagebuffer = 10

 

despawnragne = 2

 

despawnradius = 50

 

-- house rent period

-- options: daily, weekly, monthly

houserentperiod = "weekly"

 

-- motd (the message box that you sometimes get before you choose characters)

motd = "Welcome to Dragon Ball Z Arena"

motdnum = "2"

 

-- login message

loginmsg = "Welcome to Dragon Ball Z Arena"

 

-- how many logins attempts until ip is temporary disabled 

-- set to 0 to disable

logintries = 0

 

-- how long the retry timeout until a new login can be made (without disabling the ip)

retrytimeout = 60*1000

 

-- how long the player need to wait until the ip is allowed again

logintimeout = 60 * 1000

 

-- allow clones (multiple logins of the same char)

-- options: 0 (no), 1 (yes)

allowclones = 0

 

-- max number of players allowed

maxplayers = "120"

 

-- SQL type

-- options: mysql

sql_type = "mysql"

 

--- MySQL part (ignore if you are using SQLite)

sql_host = "192.168.3.4"

sql_user = "root"

sql_pass = "rocky123"

sql_db   = "tuka"

 

 

 

--- SQLite part (ignore if you are using MySQL)

sqlite_db = "db.s3db"

 

-------------------------------------------------------------------------------------------------

---------------------------- Configuration ------------------------------------------------------

-------------------------------------------------------------------------------------------------

 

-- world name (shows in the character list)

worldname = "DBKO Arena"

 

-- time to save the server (default = 1)

autosave = 4

 

-- do you want to enable cap system? (yes/no)

capsystem = "yes"

 

-- anti-afk - maximum idle time to kick player (1 = 1min)

kicktime = 10

 

-- how many summons player can have

maxsummons = 4

 

-- maximum items in depot

maxdepotitems = 1000

 

-- learn spells (yes/no)

learnspells = "no"

 

-- do you want everyone to have premium

freepremium = "no"

 

-- how many mana grow in 1 min sleep

bedregen = 10

 

-- Price for each SQM when buying a house

houseprice = 1000

 

-- level to buy a house

houselevel = 200

 

-- maximum death entries per player

maxdeathentries = 10

 

-- time, what player need wait to open body, if he not kill this creature (in seconds)

ownerloot = 10

 

-- players with that and lower lvl's cant be attacked 

protectlevel = 50

 

-- color o exp above player

expcolor = 71

 

-- animated spells above player (yes/no)

animatedspells = "yes"

 

 

-- remove distance ammunition (yes/no)

removedistance = "yes"

 

-- remove runes (yes/no

removerunes = "no"

 

 

-------------------------------------------------------------------------------------

----------------------------------- Multipliers -----------------------------------

-------------------------------------------------------------------------------------

 

-- experience multiplier (how much faster you got exp from monsters)

rate_exp = 999

 

-- monster lootrating (how much faster you get items from monsters)

rate_loot = 999

 

-- skill multiplier (another multiplier in data/vocations.xml)

rate_skill = 999

 

-- manaspent multiplier  (another multiplier in data/vocations.xml)

rate_magic = 999

 

-- spawn multiplier

rate_spawn = 5

 

---------------------------------------------------------------------------------------

-------------------------- Skull System -----------------------------------------------

---------------------------------------------------------------------------------------

 

-- time to lose a white skull (1 = 1 minute)

whitetime = 5

 

-- time to lose one frag (1 = 1 hour)

fragtime = 2

 

-- ban unjust, how many frags you need to get banned (1 = 1 frag)

banunjust = 16

 

-- red skull unjust, how many frags you need to get a red skull (1 = 1 frag)

redunjust = 7

 

-- bantime, for how long the player is banned (1 = 1 hour)

bantime = 12*1

 

--------------------------------------------------------------------------------------

------------------------------- GM access rights -------------------------------------

--------------------------------------------------------------------------------------

 

-- access to walk into houses and open house doors

accesshouse = 600

 

-- access to login without waiting in the queue or when server is closed

accessenter = 1

 

-- access to ignore damage, exhaustion, cap limit and be ignored by monsters

accessprotect = 600

 

-- access to broadcast messages and talk in colors (#c blabla - in public channels)

accesstalk = 600

 

-- access to see id and position of the item you are looking at

accesslook = 600

 

enfo = "yes"

[Smart Maxx 166]

tenta usar esse :

 

datadir = "data/"
map = "data/world/map.otbm"
mapkind = "OTBM"
mapstore = "data/world/map-mapstore.xml"
housestore = "data/world/map-housestore.xml"
banIdentifier = "data/bans.xml"




servername = "Dragon Ball Z Arena"
location = "Brasil"
ip = "192.168.3.4" 
port = "7171"
ownername = "Arena" 
worldtype = "pvp"




exhausted = 2000 
fightexhausted = 2000
exhaustedadd = 2000
pzlocked = 25*1000
enablehotkeys = 1 
minactioninterval = 100
minactionexinterval = 2000            
maxmessagebuffer = 10 
despawnragne = 2 
despawnradius = 50




houserentperiod = "weekly"




motd = "Welcome to Dragon Ball Z Arena"
motdnum = "2"
loginmsg = "Welcome to Dragon Ball Z Arena"
logintries = 0
retrytimeout = 60*1000
logintimeout = 60 * 1000
allowclones = 0
maxplayers = "120"




sqlType = "mysql"
sqlHost = "127.0.0.1"
sqlPort = 3306
sqlUser = "root"
sqlPass = "rocky123"
sqlDatabase = "tuka"
sqlFile = "theforgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "sha1"






worldname = "DBKO Arena"
autosave = 4
capsystem = "yes"
kicktime = 10
maxsummons = 4
maxdepotitems = 1000
learnspells = "no"


freepremium = "no"
bedregen = 10
houseprice = 1000
houselevel = 200
maxdeathentries = 10
ownerloot = 10
protectlevel = 50
expcolor = 71
animatedspells = "yes"
removedistance = "yes"
removerunes = "no"








rate_exp = 999
rate_loot = 999
rate_skill = 999
rate_magic = 999
rate_spawn = 5




whitetime = 5
fragtime = 2
banunjust = 16
redunjust = 7
bantime = 12*1








accesshouse = 600
accessenter = 1
accessprotect = 600
accesstalk = 600
accesslook = 600
enfo = "yes"

[kevin234 0]

tenta usar esse :

 

datadir = "data/"
map = "data/world/map.otbm"
mapkind = "OTBM"
mapstore = "data/world/map-mapstore.xml"
housestore = "data/world/map-housestore.xml"
banIdentifier = "data/bans.xml"




servername = "Dragon Ball Z Arena"
location = "Brasil"
ip = "192.168.3.4" 
port = "7171"
ownername = "Arena" 
worldtype = "pvp"




exhausted = 2000 
fightexhausted = 2000
exhaustedadd = 2000
pzlocked = 25*1000
enablehotkeys = 1 
minactioninterval = 100
minactionexinterval = 2000            
maxmessagebuffer = 10 
despawnragne = 2 
despawnradius = 50




houserentperiod = "weekly"




motd = "Welcome to Dragon Ball Z Arena"
motdnum = "2"
loginmsg = "Welcome to Dragon Ball Z Arena"
logintries = 0
retrytimeout = 60*1000
logintimeout = 60 * 1000
allowclones = 0
maxplayers = "120"




sqlType = "mysql"
sqlHost = "127.0.0.1"
sqlPort = 3306
sqlUser = "root"
sqlPass = "rocky123"
sqlDatabase = "tuka"
sqlFile = "theforgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "sha1"






worldname = "DBKO Arena"
autosave = 4
capsystem = "yes"
kicktime = 10
maxsummons = 4
maxdepotitems = 1000
learnspells = "no"


freepremium = "no"
bedregen = 10
houseprice = 1000
houselevel = 200
maxdeathentries = 10
ownerloot = 10
protectlevel = 50
expcolor = 71
animatedspells = "yes"
removedistance = "yes"
removerunes = "no"








rate_exp = 999
rate_loot = 999
rate_skill = 999
rate_magic = 999
rate_spawn = 5




whitetime = 5
fragtime = 2
banunjust = 16
redunjust = 7
bantime = 12*1








accesshouse = 600
accessenter = 1
accessprotect = 600
accesstalk = 600
accesslook = 600
enfo = "yes"

loading bans mysql error mysql_real_connect can't connect to mysql server on 'localhost' (10061)

eu liguei o site e apareceu isso 

MYSQL ERROR MYSQL_REAL_CONNECT ACESS DENIED FOR USER ODBC LOCALHOST USING PASSWORD:NO

Editado Dezembro 7, 2014 por kevin234 (veja o histórico de edições)