Solved Can't connect to MySQL database HELP !!!

[Pawelwroclaw]

Hi everybody.
I'm new here. I've got a problem. While I'm trying to install mysql there appear an error (Can't connect to MySQL database) ... Here is my config..lua..

        ip = "myip"
      ownerName = "ots..."
    ownerEmail = "[email protected]"
    url = "http://ots../"
    location = "Europe"
    serverName = "Welcome e"
    loginMessage = "Witaj "
    maxPlayers = 300
    motd = "Welcome By SuddenDeath"
    freePremium = false
    worldType = "pvp"
    protectionLevel = 1


    sqlHost = "myip"
    sqlUser = "root"
    sqlPass = "mypass"
    sqlDatabase = "VISUMGOLD"
    sqlPort = 3306
    sqlKeepAlive = 0
    mysqlReadTimeout = 10
    mysqlWriteTimeout = 10



    sqlFile = "data\visum.s3db"

    sqlType = "mysql"
    encryptionType = "plain"


    experienceStages = true
    rateExperience = 5.0
    rateExperienceFromPlayers = 0
    rateSkill = 13.0
    rateMagic = 6.0
    rateLoot = 3.0
    rateSpawn = 1
    rateMonsterHealth = 1.0
    rateMonsterMana = 1.0
    rateMonsterAttack = 1.0
    rateMonsterDefense = 1.0



    removeWeaponAmmunition = false
    removeWeaponCharges = false
    removeRuneCharges = false

    buyableAndSellableHouses = true
    houseNeedPremium = true
    bedsRequirePremium = true
    levelToBuyHouse = 1
    housesPerAccount = 0
    houseRentAsPrice = false
    housePriceAsRent = false
    housePriceEachSquare = 1000
    houseRentPeriod = "never"
    houseCleanOld = 0
    guildHalls = false


    timeBetweenActions = 200
    timeBetweenExActions = 1000
    hotkeyAimbotEnabled = true


    mapName = "NaxedMap"
    mapAuthor = "VisumOTS.pl"
    randomizeTiles = true
    storeTrash = true
    cleanProtectedZones = true
    mailboxDisabledTowns = "-1"


    minLevelThresholdForKilledPlayer = 0.9
    maxLevelThresholdForKilledPlayer = 1.1


    rateStaminaLoss = 1
    rateStaminaGain = 3
    rateStaminaThresholdGain = 12
    staminaRatingLimitTop = 41 * 60
    staminaRatingLimitBottom = 14 * 60
    rateStaminaAboveNormal = 1.5
    rateStaminaUnderNormal = 0.5
    staminaThresholdOnlyPremium = true


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


    accountManager = false
    namelockManager = true
    newPlayerChooseVoc = false
    newPlayerSpawnPosX = 160
    newPlayerSpawnPosY = 50
    newPlayerSpawnPosZ = 7
    newPlayerTownId = 1
    newPlayerLevel = 1
    newPlayerMagicLevel = 0
    generateAccountNumber = false


    redSkullLength = 30 * 24 * 60 * 60
    blackSkullLength = 45 * 24 * 60 * 60
    dailyFragsToRedSkull = 20
    weeklyFragsToRedSkull = 50
    monthlyFragsToRedSkull = 100
    dailyFragsToBlackSkull = dailyFragsToRedSkull
    weeklyFragsToBlackSkull = weeklyFragsToRedSkull
    monthlyFragsToBlackSkull = monthlyFragsToRedSkull
    dailyFragsToBanishment = dailyFragsToRedSkull
    weeklyFragsToBanishment = weeklyFragsToRedSkull
    monthlyFragsToBanishment = monthlyFragsToRedSkull
    blackSkulledDeathHealth = 40
    blackSkulledDeathMana = 0
    useBlackSkull = true
    useFragHandler = true
    advancedFragList = false


    notationsToBan = 15
    warningsToFinalBan = 35
    warningsToDeletion = 50
    banLength = 7 * 24 * 60 * 60
    killsBanLength = 7 * 24 * 60 * 60
    finalBanLength = 30 * 24 * 60 * 60
    ipBanishmentLength = 1 * 24 * 60 * 60
    broadcastBanishments = true
    maxViolationCommentSize = 200
    violationNameReportActionType = 2
    autoBanishUnknownBytes = false


    pvpTileIgnoreLevelAndVocationProtection = true
    pzLocked = 30000
    huntingDuration = 60000
    criticalHitChance = 7
    criticalHitMultiplier = 1
    displayCriticalHitNotify = false
    whiteSkullTime = 3000
    noDamageToSameLookfeet = false
    showHealingDamage = false
    showHealingDamageForMonsters = false
    fieldOwnershipDuration = 5 * 1000
    stopAttackingAtExit = true
    oldConditionAccuracy = false
    loginProtectionPeriod = 10 * 1
    deathLostPercent = 10
    stairhopDelay = 1 * 1000
    pushCreatureDelay = 2 * 300
    deathContainerId = 1987
    gainExperienceColor = 215
    addManaSpentInPvPZone = true
    squareColor = 0
    allowFightback = true


    worldId = 0
    bindOnlyConfiguredIpAddress = false
    loginPort = 7171
    gamePort = 7172
    adminPort = 7171
    statusPort = 7171
    loginTries = 10
    retryTimeout = 5 * 1000
    loginTimeout = 60 * 1000
    displayOnOrOffAtCharlist = false
    onePlayerOnlinePerAccount = true
    allowClones = false
    statusTimeout = 1 * 60 * 1000
    replaceKickOnLogin = true
    forceSlowConnectionsToDisconnect = false
    loginOnlyWithLoginServer = false
    premiumPlayerSkipWaitList = false


    deathListEnabled = true
    deathListRequiredTime = 1 * 60 * 1000
    deathAssistCount = 19
    maxDeathRecords = 5


    ingameGuildManagement = true
    levelToFormGuild = 8
    premiumDaysToFormGuild = 0
    guildNameMinLength = 4
    guildNameMaxLength = 20


    highscoreDisplayPlayers = 15
    updateHighscoresAfterMinutes = 60


    defaultPriority = "high"
    niceLevel = 5
    coresUsed = "-1"


    optimizeDatabaseAtStartup = true
    removePremiumOnInit = true
    confirmOutdatedVersion = false


    formulaLevel = 5.0
    formulaMagic = 1.0
    bufferMutedOnSpellFailure = false
    spellNameInsteadOfWords = false
    emoteSpells = true


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


    dataDirectory = "data/"
    bankSystem = true
    displaySkillLevelOnAdvance = false
    promptExceptionTracerErrorBox = true
    separateViplistPerCharacter = false
    maximumDoorLevel = 500
    maxMessageBuffer = 4


    saveGlobalStorage = true
    useHouseDataStorage = false
    storePlayerDirection = false


    checkCorpseOwner = true
    monsterLootMessage = 3
    monsterLootMessageType = 25


    ghostModeInvisibleEffect = false
    ghostModeSpellEffects = true


    idleWarningTime = 14 * 60 * 1000
    idleKickTime = 15 * 60 * 1000
    expireReportsAfterReads = 1
    playerQueryDeepness = 2
    maxItemsPerPZTile = 10
    maxItemsPerHouseTile = 15


    premiumForPromotion = true


    blessingOnlyPremium = true
    blessingReductionBase = 30
    blessingReductionDecreament = 5
    eachBlessReduction = 8


    globalSaveEnabled = false
    globalSaveHour = 8
    shutdownAtGlobalSave = true
    cleanMapAtGlobalSave = false


    deSpawnRange = 2
    deSpawnRadius = 50


    maxPlayerSummons = 2
    teleportAllSummons = false
    teleportPlayerSummons = false


    displayGamemastersWithOnlineCommand = false


    adminLogsEnabled = false
    displayPlayersLogging = true
    prefixChannelLogs = ""
    runFile = ""
    outLogName = ""
    errorLogName = ""
    truncateLogsOnStartup = false

Thank.you in advance for help.

 

[Rer]

Do you have running WebServer (Apache/MySQL)?

 

[Pawelwroclaw]

I have to run my serwer by PUTTY ?

 

[Rer]

Grr.
You have entered the appropriate database name?

 

[Pawelwroclaw]

I have only innstaled (Apache/MySQL) i dont know if i run it

yeah my database is VISUMOTS.exe ...

my engine is visumots.. this is database?

 

[oualidboy1996]

    sqlHost = "myip"

should be

    sqlHost = "127.0.0.1"

if that doesn't work try

    sqlHost = "localhost"

and with myip you rlly mean your ip and you didn't just put "myip" right ?







This has nothing to do with that but I recommend using sha1 instead of plain

   encryptionType = "plain"

 

[Rer]

You try to open .exe on linux? For the first one you must compile engine to linux binary then run at your server (Putty).
You have debian/ubuntu?

    sqlHost = "myip"

should be

    sqlHost = "127.0.0.1"

if that doesn't work try

    sqlHost = "localhost"

and with myip you rlly mean your ip and you didn't just put "myip" right ?







This has nothing to do with that but I recommend using sha1 instead of plain

   encryptionType = "plain"

I think he's encrypted IP expressly

 

[oualidboy1996]

yea also thought that but I just asked to be sure you never know

 

[Pawelwroclaw]

hmm ;D I have a question maybe you teamwiever?

 

[Rer]

Yes, I can help you with TeamViewer.

 

[Pawelwroclaw]

sqlhost-my ip entered the server ip

 

[Rer]

Check your PM

 

[oualidboy1996]

@Pawelwroclaw dont enter your server ip at sqlhost.... see what I said you need to change that to "127.0.0.1" if that doesn't work change it to "localhost"

 

[Blez]

change root to the database name.

 

[Limos]

You can follow this tutorial how to setup MySQL
http://otland.net/threads/video-tut...ing-ot-server-website-and-shop-system.166818/

 

[Pawelwroclaw]

Thx Limos but "RER" help me for all installed ots