Error installing gesior

[PsyMcKenzie]

I installed the site and this error appeared. Does anyone know how I can fix it?

Spoiler

Warning: parse_ini_file(C:\Users\User\Desktop\Soft OTconfig.lua) [function.parse-ini-file]: failed to open stream: No such file or directory in C:\xampp\htdocs\config-and-functions.php on line 13
Database error. Unknown database type in C:\Users\User\Desktop\Soft OTconfig.lua . Must be equal to: "mysql" or "sqlite". Now is: ""

 

[Danger II]

C:\Users\User\Desktop\Soft OT\
instead of:
C:\Users\User\Desktop\Soft OT

 

[PsyMcKenzie]

Spoiler

Warning

Spoiler

: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) in C:\xampp\htdocs\config-and-functions.php on line 20
Nao foi possível conectar ao MySql: Access denied for user 'root'@'localhost' (using password: YES)

Now I got this.

 

[slaw]

It can't connect to database. Your password is wrong.

BTW. Don't use root user, make a new user in phpmyadmin and create database to it. Its safer.

BTW2. Don't use Gesior, use [MyAAC] v0.0.1. Its like Gesior, but with more features - and up-to-date!

 

[Raggaer]

What version of Gesior are you using? mysql_

 

[WibbenZ]

What version of Gesior are you using? mysql_

He is using one of the older ones, the unsafe ones

You can use MyAAC if you wanna give that a try, otherwise download Gesior 2012 from github Branches · gesior/Gesior2012 · GitHub

 

[PsyMcKenzie]

The problem is in the gesior?

I downloaded the datapack and it come both. What should I do? I use xampp 1.7.3.

 

[slaw]

The problem is in the gesior?

I downloaded the datapack and it come both. What should I do? I use xampp 1.7.3.

Why you using 7 years old software? XAMPP 1.7.3 has been released 23 December, 2009 (7 years ago ).

Download latest XAMPP here: Download XAMPP

And I suggest you to use MyAAC. I provided you the link. It works with any distro.

 

[PsyMcKenzie]

I downloaded the latest version of xampp and the folks told me to change.

But okay, I'm going to download xampp and MyAAC. I'll soon say if it worked.

EDIT - @slawkens

I got this error

Spoiler

Your database is MySQL. Importing schema now...

ERROR: Cannot connect to MySQL database.
Possible reasons:

• MySQL is not configured propertly in config.lua.
• MySQL server is not running.

exception 'PDOException' with message 'SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES)' in C:\xampp\htdocs\system\libs\pot\OTS_DB_MySQL.php:95 Stack trace: #0 C:\xampp\htdocs\system\libs\pot\OTS_DB_MySQL.php(95): PDO->__construct('mysql:host=127....', 'root', 'phzerapp152929') #1 C:\xampp\htdocs\system\libs\pot\OTS.php(448): OTS_DB_MySQL->__construct(Array) #2 C:\xampp\htdocs\system\database.php(79): POT->connect(1, Array) #3 C:\xampp\htdocs\install\includes\database.php(6): require('C:\\xampp\\htdocs...') #4 C:\xampp\htdocs\install\steps\database.php(36): require('C:\\xampp\\htdocs...') #5 C:\xampp\htdocs\install\index.php(40): require('C:\\xampp\\htdocs...') #6 {main}

This is my config.lua:

Spoiler

enableCast = false
accountManager = "yes"
namelockManager = "yes"
newPlayerChooseVoc = "yes"
newPlayerSpawnPosX = 324
newPlayerSpawnPosY = 1006
newPlayerSpawnPosZ = 6
newPlayerTownId = 1
newPlayerLevel = 100
newPlayerMagicLevel = 10
generateAccountNumber = "no"
redSkullLength = 50 * 62 * 70 * 90
blackSkullLength = 64 * 72 * 80 * 95
dailyFragsToRedSkull = 5
weeklyFragsToRedSkull = 20
monthlyFragsToRedSkull = 40
dailyFragsToBlackSkull = 10
weeklyFragsToBlackSkull = 25
monthlyFragsToBlackSkull = 45
dailyFragsToBanishment = 100
weeklyFragsToBanishment = 300
monthlyFragsToBanishment = 500
blackSkulledDeathHealth = 400
blackSkulledDeathMana = 100
useBlackSkull = true
useFragHandler = true
advancedFragList = false
notationsToBan = 3
warningsToFinalBan = 4
warningsToDeletion = 5
banLength = 7 * 24 * 60 * 60
killsBanLength = 8 * 24 * 60 * 60
finalBanLength = 30 * 24 * 60 * 60
ipBanishmentLength = 9999 * 24 * 60 * 60
broadcastBanishments = false
maxViolationCommentSize = 200
violationNameReportActionType = 2
autoBanishUnknownBytes = false
worldType = "open"
protectionLevel = 1000
pvpTileIgnoreLevelAndVocationProtection = true
pzLocked = 20 * 800
huntingDuration = 30 * 1000
criticalHitChance = 5
criticalHitMultiplier = 1.1
displayCriticalHitNotify = true
removeWeaponAmmunition = false
removeWeaponCharges = false
removeRuneCharges = "no"
whiteSkullTime = 8 * 10 * 100
noDamageToSameLookfeet = false
showHealingDamage = true
showHealingDamageForMonsters = true
fieldOwnershipDuration = 5 * 1000
stopAttackingAtExit = false
oldConditionAccuracy = false
loginProtectionPeriod = 30 * 1000
deathLostPercent = 10
stairhopDelay = 2 * 1000
pushCreatureDelay = 0 * 1000
deathContainerId = 1987
gainExperienceColor = 205
addManaSpentInPvPZone = true
squareColor = 0
allowFightback = true
worldId = 0
ip = "127.0.0.1"
bindOnlyConfiguredIpAddress = false
loginPort = 7171
gamePort = 7172
adminPort = 7171
statusPort = 7171
loginTries = 10
retryTimeout = 5 * 1000
loginTimeout = 60 * 1000
maxPlayers = 50
motd = "Welcome to Soft Baiak."
displayOnOrOffAtCharlist = false
onePlayerOnlinePerAccount = false
allowClones = false
serverName = "Soft Baiak"
loginMessage = "Welcome to Soft Baiak, enjoy!"
statusTimeout = 30 * 60 * 1000
replaceKickOnLogin = true
forceSlowConnectionsToDisconnect = false
loginOnlyWithLoginServer = false
premiumPlayerSkipWaitList = false
mysqlType = "mysql"
mysqlHost = "127.0.0.1"
mysqlPort = 3306
mysqlUser = "root"
mysqlPass = "ph152700"
mysqlDatabase = "opentibia"
mysqlFile = "opentibia.s3db"
mysqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "sha1"
deathListEnabled = true
deathListRequiredTime = 1 * 60 * 1000
deathAssistCount = 19
maxDeathRecords = 5
ingameGuildManagement = true
levelToFormGuild = 1000
premiumDaysToFormGuild = 0
guildNameMinLength = 4
guildNameMaxLength = 20
highscoreDisplayPlayers = 100
updateHighscoresAfterMinutes = 2
buyableAndSellableHouses = true
houseNeedPremium = true
bedsRequirePremium = true
levelToBuyHouse = 5000
housesPerAccount = 0
houseRentAsPrice = false
housePriceAsRent = false
housePriceEachSquare = 1000
houseRentPeriod = "never"
houseCleanOld = 0
guildHalls = false
timeBetweenActions = 200
timeBetweenExActions = 1000
checkCorpseOwner = true
hotkeyAimbotEnabled = true
maximumDoorLevel = 999
mapName = "Baiak.otbm"
mapAuthor = "Movie"
randomizeTiles = true
useHouseDataStorage = false
storeTrash = true
cleanProtectedZones = true
mailboxDisabledTowns = "-1"
defaultPriority = "high"
niceLevel = 5
coresUsed = "-1"
optimizeDatabaseAtStartup = true
removePremiumOnInit = true
confirmOutdatedVersion = false
maxMessageBuffer = 4
bufferMutedOnSpellFailure = false
dataDirectory = "data/"
allowChangeOutfit = true
allowChangeColors = true
allowChangeAddons = true
disableOutfitsForPrivilegedPlayers = false
bankSystem = true
saveGlobalStorage = true
displaySkillLevelOnAdvance = true
spellNameInsteadOfWords = false
emoteSpells = true
promptExceptionTracerErrorBox = true
storePlayerDirection = false
monsterLootMessage = 3
monsterLootMessageType = 25
separateViplistPerCharacter = false
ghostModeInvisibleEffect = true
ghostModeSpellEffects = true
idleWarningTime = 20 * 60 * 1000
idleKickTime = 30 * 60 * 1000
expireReportsAfterReads = 1
playerQueryDeepness = 2
maxItemsPerPZTile = 99
maxItemsPerHouseTile = 50
freePremium = true
premiumForPromotion = true
blessingOnlyPremium = true
blessingReductionBase = 30
blessingReductionDecreament = 5
eachBlessReduction = 8
experienceStages = "yes"
rateExperience = 9999
rateExperienceFromPlayers = 20
rateSkill = 200
rateMagic = 150
rateLoot = 25
rateSpawn = 80
rateMonsterHealth = 1.1
rateMonsterMana = 1.0
rateMonsterAttack = 1.0
rateMonsterDefense = 1.2
minLevelThresholdForKilledPlayer = 0.9
maxLevelThresholdForKilledPlayer = 1.1
rateStaminaLoss = 3
rateStaminaGain = 1
rateStaminaThresholdGain = 12
staminaRatingLimitTop = 41 * 60
staminaRatingLimitBottom = 14 * 60
rateStaminaAboveNormal = 1.5
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 = 6
shutdownAtGlobalSave = true
cleanMapAtGlobalSave = true
deSpawnRange = 2
deSpawnRadius = 50
maxPlayerSummons = 0
teleportAllSummons = false
teleportPlayerSummons = false
ownerName = "Movie"
ownerEmail = ""
url = ""
location = "BR"
displayGamemastersWithOnlineCommand = false
adminLogsEnabled = true
displayPlayersLogging = true
prefixChannelLogs = "[Soft Baiak] "
runFile = ""
outLogName = ""
errorLogName = ""
truncateLogsOnStartup = false

 

[Leo32]

[1045] Access denied for user 'root'@'localhost' (using password: YES)'

Your database, username or password is wrong.

Here is your mysql settings from your config file:

mysqlType = "mysql"
mysqlHost = "127.0.0.1"
mysqlPort = 3306
mysqlUser = "root"
mysqlPass = "ph152700"
mysqlDatabase = "opentibia"
mysqlFile = "opentibia.s3db"

So you've installed XAMPP?
So under http://127.0.0.1/phpmyadmin you should have a database called opentibia that you can login into using the username root and the password ph152700 right?

What is this(?)

mysqlFile = "opentibia.s3db"

It does not exist in the default config.lua

-- MySQL
mysqlHost = "127.0.0.1"
mysqlUser = "forgottenserver"
mysqlPass = ""
mysqlDatabase = "forgottenserver"
mysqlPort = 3306
mysqlSock = ""

Needs to be removed as it could be adding more confusion on your end.

 

[PsyMcKenzie]

[1045] Access denied for user 'root'@'localhost' (using password: YES)'

Your database, username or password is wrong.

Here is your mysql settings from your config file:

mysqlType = "mysql"
mysqlHost = "127.0.0.1"
mysqlPort = 3306
mysqlUser = "root"
mysqlPass = "ph152700"
mysqlDatabase = "opentibia"
mysqlFile = "opentibia.s3db"

So you've installed XAMPP?
So under http://127.0.0.1/phpmyadmin you should have a database called opentibia that you can login into using the username root and the password ph152700 right?

What is this(?)

mysqlFile = "opentibia.s3db"

It does not exist in the default config.lua

-- MySQL
mysqlHost = "127.0.0.1"
mysqlUser = "forgottenserver"
mysqlPass = ""
mysqlDatabase = "forgottenserver"
mysqlPort = 3306
mysqlSock = ""

Needs to be removed as it could be adding more confusion on your end.

All right, let's try.

How do I log out from phpmyadmin to be able to test my password?

 

[Leo32]

How to login as another user in phpmyadmin

 

[PsyMcKenzie]

@Leo32 What is the way to the config.ini file?

EDIT-
Man, I was able to log in to phpMyAdmin, but the password I had placed does not work anymore!

I tried to change it, leaving it like this:

Spoiler

$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'otserverpass';

But it did not work. :/

EDIT2-

Now I understand what is happening, phpMyAdmin is configured to not need a password, so I do not need a password to enter.
I was able to move on to the next step, but this happened:

Spoiler

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'ip' cannot be null' in C:\xampp\htdocs\system\libs\pot\OTS_Base_DB.php:100 Stack trace: #0 C:\xampp\htdocs\system\libs\pot\OTS_Base_DB.php(100): PDO->query('INSERT INTO `my...') #1 C:\xampp\htdocs\system\libs\pot\OTS_Account.php(903): OTS_Base_DB->query('INSERT INTO `my...') #2 C:\xampp\htdocs\install\steps\finish.php(99): OTS_Account->logAction('Account created...') #3 C:\xampp\htdocs\install\index.php(40): require('C:\\xampp\\htdocs...') #4 {main} thrown in C:\xampp\htdocs\system\libs\pot\OTS_Base_DB.php on line 100

Sorry for the bad english guys.

@slawkens Can you help me bro?

 

[slaw]

@Leo32 What is the way to the config.ini file?

EDIT-
Man, I was able to log in to phpMyAdmin, but the password I had placed does not work anymore!

I tried to change it, leaving it like this:

Spoiler

$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'otserverpass';

But it did not work. :/

EDIT2-

Now I understand what is happening, phpMyAdmin is configured to not need a password, so I do not need a password to enter.
I was able to move on to the next step, but this happened:

Spoiler

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'ip' cannot be null' in C:\xampp\htdocs\system\libs\pot\OTS_Base_DB.php:100 Stack trace: #0 C:\xampp\htdocs\system\libs\pot\OTS_Base_DB.php(100): PDO->query('INSERT INTO `my...') #1 C:\xampp\htdocs\system\libs\pot\OTS_Account.php(903): OTS_Base_DB->query('INSERT INTO `my...') #2 C:\xampp\htdocs\install\steps\finish.php(99): OTS_Account->logAction('Account created...') #3 C:\xampp\htdocs\install\index.php(40): require('C:\\xampp\\htdocs...') #4 {main} thrown in C:\xampp\htdocs\system\libs\pot\OTS_Base_DB.php on line 100

Sorry for the bad english guys.

@slawkens Can you help me bro?

You downloaded version 0.0.6? I think not. Cause this bug has been fixed.

 

[PsyMcKenzie]

You downloaded version 0.0.6? I think not. Cause this bug has been fixed.

I downloaded that link that you gave me.
[MyAAC] v0.0.1
Did I have to download the github link or the end of the thread?

 

[Danger II]

Download the latest release in github. Its prolly the most recent one.

 

[PsyMcKenzie]

Download the latest release in github. Its prolly the most recent one.

Thanks, now it worked!

How do I use it? Now my server already works in mysql?

EDIT-

@Danger II @Leo32
Help me please!
I installed the site, but the server continues sql. I create an account on the site and it does not work in the game and I create an account in the game and it does not appear on the site, how do I fix this?