SQL Database

[romeutt 0]

Logo peço desculpas caso esteja no lugar errado do forum minha questão. 

 

Boa Tarde a todos, estou tentando por um servidor online apenas para eu fazer alguns testes e aprender como configurar um servidor

Porem to com um problema que não consigo corrigir agora de começo...

Já consegui abrir outros ot pra teste e nao tive esse problema

No config.lua ele esta como sqlite porem sempre que tento abrir aparece o erro "error couldn't estabilish connection to sql database"

Alguem poderia me ajudar com isso?

[mister17 10]

Em 11/04/2019 em 17:50, romeutt disse:

Versão do Servidor: TFS - 0.3.4

Tipo de Script: actions

Código:

  Mostrar conteúdo oculto

	ownerName = ""
	ownerEmail = ""
	url = ""
	location = ""

	
	motd = "Olá Querido Player! Sejam Todos Bem Vindos ao OriginServer"
	serverName = "OriginServer"
	loginMessage = "Olá Amigos Players e Colaboradores, Sejam todos Bem vindos Ao OriginServer"
	displayGamemastersWithOnlineCommand = false

	sqlType = "sqlite"
	sqlHost = "localhost"
	sqlPort = 3306
	sqlUser = "root"
	sqlPass = ""
	sqlDatabase = "TheOtxServer"
	sqlFile = "otxserver.s3db"
	sqlKeepAlive = 0
	mysqlReadTimeout = 10
	mysqlWriteTimeout = 10
	mysqlReconnectionAttempts = 20
	encryptionType = "sha1" 

	worldId = 0
	ip = "127.0.0.1"
	worldType = "open"
	bindOnlyGlobalAddress = false
	loginPort = 7171
	gamePort = "7172"
	statusPort = 7171
	loginOnlyWithLoginServer = false


	accountManager = true
	namelockManager = true
	newPlayerChooseVoc = true
	newPlayerSpawnPosX = 32681
	newPlayerSpawnPosY = 32524
	newPlayerSpawnPosZ = 6
	newPlayerTownId = 1
	newPlayerLevel = 8
	newPlayerMagicLevel = 0
	generateAccountNumber = false
	generateAccountSalt = false

	fragsLimit = 24 * 60 * 60
	fragsSecondLimit = 7 * 24 * 60 * 60
	fragsThirdLimit = 30 * 24 * 60 * 60


	fragsToRedSkull = 60
	fragsSecondToRedSkull = 990
	fragsThirdToRedSkull = 995
	redSkullLength = 50 * 60 * 1000

	fragsToBlackSkull = 90
	fragsSecondToBlackSkull = 1200
	fragsThirdToBlackSkull = 1290
	blackSkulledDeathHealth = 40
	blackSkulledDeathMana = 0
	blackSkullLength = 1 * 24 * 60 * 60
	useBlackSkull = true

	notationsToBan = 3
	warningsToFinalBan = 4
	warningsToDeletion = 5
	banLength = 7 * 24 * 60 * 60
	killsBanLength = 7 * 24 * 60 * 60
	finalBanLength = 30 * 24 * 60 * 60
	ipBanLength = 1 * 24 * 60 * 60
	fragsToBanishment = 7
	fragsSecondToBanishment = 21
	fragsThirdToBanishment = 41

	protectionLevel = 80
	pvpTileIgnoreLevelAndVocationProtection = true
	allowFightback = true
	pzLocked = 20 * 10 * 100
	huntingDuration = 60 * 300
	criticalHitMultiplier = 1
	displayCriticalHitNotify = false
	removeWeaponAmmunition = false
	removeWeaponCharges = false
	removeRuneCharges = false
	whiteSkullTime = 40 * 10 * 100
	advancedFragList = false
	useFragHandler = true
	noDamageToSameLookfeet = false
	showHealthChange = true
	showManaChange = true
	showHealthChangeForMonsters = true
	showManaChangeForMonsters = true
	fieldOwnershipDuration = 5 * 1000
	stopAttackingAtExit = false
	loginProtectionPeriod = 1 * 1000
	deathLostPercent = 5
	stairhopDelay = 1 * 1000
	pushCreatureDelay = 0.2 * 1000
	deathContainerId = 1987
	gainExperienceColor = 155
	addManaSpentInPvPZone = true
	recoverManaAfterDeathInPvPZone = true
	squareColor = 0
	broadcastBanishments = false
	
useAntiPush = true 
antiPushDelay = 445
antiPushItems = "2148,2152,2160,3976" 

	
	
	rsaPrime2 = "7630979195970404721891201847792002125535401292779123937207447574596692788513647179235335529307251350570728407373705564708871762033017096809910315212884101"
	rsaPublic = "65537"
	rsaModulus = "109120132967399429278860960508995541528237502902798129123468757937266291492576446330739696001110603907230888610072655818825358503429057592827629436413108566029093628212635953836686562675849720620786279431090218017681061521755056710823876476444260558147179707119674283982419152118103759076030616683978566631413"
	rsaPrivate = "46730330223584118622160180015036832148732986808519344675210555262940258739805766860224610646919605860206328024326703361630109888417839241959507572247284807035235569619173792292786907845791904955103601652822519121908367187885509270025388641700821735345222087940578381210879116823013776808975766851829020659073"

	
		optionalWarAttackableAlly = true
		fistBaseAttack = 7
		criticalHitChance = 7
		noDamageToGuildMates = false
			
		noDamageToPartyMembers = false
			

		rookLevelTo = 5
		rookLevelToLeaveRook = 8
		rookTownId = 1
		useRookSystem = false

		
		paralyzeDelay = 1500

		
		premiumDaysToAddByGui = 1

		useCapacity = true
		defaultDepotSize = 2000
		defaultDepotSizePremium = 2000
		enableProtectionQuestForGM = true
		cleanItemsInMap = false
		playerFollowExhaust = 2000

		

		tibiaClassicSlots = false
		monsterSpawnWalkback = true
		allowBlockSpawn = true

		
		NoShareExpSummonMonster = false

		
		enableLootBagDisplay = false
		advertisingBlock = ".net;servegame;no-ip,.net;.com.br;.com;.org;.pl;.net;.biz;.info"
		gmAnonymousInChanel = 0

		manualVersionConfig = false
		versionMin = 860
		versionMax = 860
		versionMsg = "Only clients with protocol 8.6x allowed!"

	
	loginTries = 10
	retryTimeout = 5 * 1000
	loginTimeout = 60 * 1000
	maxPlayers = 1000
	displayOnOrOffAtCharlist = false
	onePlayerOnlinePerAccount = true
	allowClones = 0
	statusTimeout = 1000
	replaceKickOnLogin = true
	forceSlowConnectionsToDisconnect = false
	premiumPlayerSkipWaitList = true
	packetsPerSecond = 1000
	allowedMaxSizePackets = 100

	deathListEnabled = true
	deathListRequiredTime = 1 * 60 * 1000
	deathAssistCount = 2
	maxDeathRecords = 1
	multipleNames = false

	externalGuildWarsManagement = false
	ingameGuildManagement = false
	levelToFormGuild = 600
	premiumDaysToFormGuild = 0
	guildNameMinLength = 4
	guildNameMaxLength = 20


	buyableAndSellableHouses = true
	houseNeedPremium = false
	bedsRequirePremium = false
	levelToBuyHouse = 200
	housesPerAccount = 1
	houseRentAsPrice = false
	housePriceAsRent = false
	housePriceEachSquare = 50000
	houseRentPeriod = "weekly"
	houseCleanOld = 7 * 24 * 60 * 60
	guildHalls = true
	houseSkipInitialRent = true
	houseProtection = true

	
	timeBetweenActions = 200
	timeBetweenExActions = 1000
	timeBetweenCustomActions = 500
	checkCorpseOwner = true
	hotkeyAimbotEnabled = true
	maximumDoorLevel = 1999
	tradeLimit = 100
	canOnlyRopePlayers = false

	mapAuthor = "Igor Souza"
	randomizeTiles = true
	houseDataStorage = "binary-tilebased"
	storeTrash = true
	cleanProtectedZones = true
	mapName = "IceWars.otbm"

	
	mailMaxAttempts = 5
	mailBlockPeriod = 30 * 60 * 1000
	mailAttemptsFadeTime = 5 * 60 * 1000
	mailboxDisabledTowns = ""
		

	daemonize = false
	defaultPriority = "higher"
	niceLevel = 3
	serviceThreads = 1
	coresUsed = "-1" 
	startupDatabaseOptimization = true
	removePremiumOnInit = true
	confirmOutdatedVersion = false
	skipItemsVersionCheck = true

	
	maxMessageBuffer = 4

	
	dataDirectory = "data/"
	logsDirectory = "data/logs/"
	disableOutfitsForPrivilegedPlayers = false
	bankSystem = true
	spellNameInsteadOfWords = false
	emoteSpells = true
	unifiedSpells = true
	promptExceptionTracerErrorBox = true
	storePlayerDirection = false
	savePlayerData = true
	monsterLootMessage = 3
	monsterLootMessageType = 25
	separateViplistPerCharacter = false
	vipListDefaultLimit = 20
	vipListDefaultPremiumLimit = 100


	allowChangeOutfit = true
	allowChangeColors = true
	allowChangeAddons = true
	addonsOnlyPremium = false


	ghostModeInvisibleEffect = true
	ghostModeSpellEffects = true


	idleWarningTime = 14 * 60 * 1000
	idleKickTime = 15 * 60 * 1000
	expireReportsAfterReads = 1
	playerQueryDeepness = -1
	protectionTileLimit = 10
	houseTileLimit = 10
	tileLimit = 10

	
	freePremium = true
	premiumForPromotion = true
	updatePremiumStateAtStartup = true

	
	blessings = true
	blessingOnlyPremium = false
	blessingReductionBase = 30
	blessingReductionDecrement = 5
	eachBlessReduction = 8
	useFairfightReduction = true
	pvpBlessingThreshold = 40
	fairFightTimeRange = 60

	
	experienceStages = true
	rateExperience = 100
	rateExperienceFromPlayers = 0
	rateSkill = 25
	rateMagic = 9
	rateLoot = 7
	rateSpawn = 2
	rateSpawnMin = 1
	rateSpawnMax = 1
	formulaLevel = 3.0
	formulaMagic = 1.0
		
		rateMonsterHealth = 1.0
		rateMonsterMana = 1.0
		rateMonsterAttack = 1.0
		rateMonsterDefense = 1.3

	
	minLevelThresholdForKilledPlayer = 0.9
	maxLevelThresholdForKilledPlayer = 1.1

	
	rateStaminaLoss = 1
	rateStaminaGain = 6
	rateStaminaThresholdGain = 12
	staminaRatingLimitTop = 40 * 60
	staminaRatingLimitBottom = 14 * 60
	staminaLootLimit = 14 * 60
	rateStaminaAboveNormal = 1.2
	rateStaminaUnderNormal = 0.5
	staminaThresholdOnlyPremium = true

	
	experienceShareRadiusX = 30
	experienceShareRadiusY = 30
	experienceShareRadiusZ = 1
	experienceShareLevelDifference = 2 / 3
	extraPartyExperienceLimit = 20
	extraPartyExperiencePercent = 5
	experienceShareActivity = 2 * 60 * 1000


	globalSaveEnabled = false
	globalSaveHour = 5
	globalSaveMinute = 0
	shutdownAtGlobalSave = false
	cleanMapAtGlobalSave = false
	closeInstanceOnShutdown = true

	
	minRateSpawn = 1
	maxRateSpawn = 3
	deSpawnRange = 2
	deSpawnRadius = 50

	maxPlayerSummons = 1
	teleportAllSummons = false
	teleportPlayerSummons = true

	disableLuaErrors = false
	adminLogs = false
	displayPlayersLogging = false
	prefixChannelLogs = ""
	runFile = "server/run.log"
	outputLog = "server/out.log"
	truncateLogOnStartup = true
	logPlayersStatements = false

	managerPort = 7171
	managerLogs = true
	managerPassword = ""
	managerLocalhostOnly = true
	managerConnectionsLimit = 1

	
	adminPort = 7171
	adminPassword = ""
	adminLocalhostOnly = true
	adminConnectionsLimit = 1
	adminRequireLogin = true
	adminEncryption = ""
	adminEncryptionData = ""

	saveGlobalStorage = false
	bufferMutedOnSpellFailure = false

Logo peço desculpas caso esteja no lugar errado do forum minha questão. 

 

Boa Tarde a todos, estou tentando por um servidor online apenas para eu fazer alguns testes e aprender como configurar um servidor

Porem to com um problema que não consigo corrigir agora de começo...

Já consegui abrir outros ot pra teste e nao tive esse problema

No config.lua ele esta como sqlite porem sempre que tento abrir aparece o erro "error couldn't estabilish connection to sql database"

Alguem poderia me ajudar com isso?

Ola  o erro esta no config lua ou por não ter a data base sql, de qualquer forma vou deixar do meu servidor  abaixo pra voce ter  uma noção.

meu config lua parte do banco de dados

Spoiler

sqlType = "sqlite"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = ""
sqlDatabase = "pokemonabsalon"
sqlFile = "PAlpha.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "sha1"

 abaixo imagem  como estão nomeados dentro do meu servidor

Spoiler

 

Editado Abril 27, 2019 por mister17