mangos one Same issues installing db in debian

[Darklandz]

Hi,

Trying to install mangosone now and i have the same issues when i try to install the database in Debian (like i had on zero: 

 

No prob i thought i'll do the same fix like i did on zero and install the database on my windows machine first ... but now i get errors.

The character1 and mango1 installs fine, the problem is when the script wants to install the realmd database, i get this error:

The system cannot find the batch label specified - RealmDB4

Indeed this batch file seems to be missiing (from the repro).

The database was downloaded like the wiki says : 

git clone https://github.com/mangosone/database.git database --recursive

[Darklandz]

Ah the error message is not for a batch file but for a label in the batch file, something must be incorrect in the InstallDatabases.bat

[antz]

@Darklandz that is odd, I will take a look this evening

[Darklandz]

4 minutes ago, antz said:

@Darklandz that is odd, I will take a look this evening

Thank you antz,

 

For niw i'm trying to install the database manually, so far so good i think, i only get an error that the database is not up to date, i need to install the DB updates, i found them in the updates folder.

There are multiple folders Rel18,Rel 19 ... Rel 21 (lat one), do i need to run them all or is just running the last one Rel21 sufficient.

[Darklandz]

On further inspection of the .sql files i think they contain errors:

For example:

The character database:

In the characterLoadDB.sql, a table db_version is created.

In the character update sql, in the Character\updates\Rel21\Rel20_toBaseRel21_Updates\21000_00_Release_021_initial.sql :

-- Update db_version to set the latest release
ALTER TABLE character_db_version CHANGE COLUMN `required_20001_02_dbdocs_Update` `required_21000_00_Release_021_Initial` bit;

Shouldn't that be db_version instead of character_db_version (<- this table does not exist in the character1 database)

 

 

[antz]

The best solution if you are in doubt as to what version of the db you have...

Run this SQL statement:

SELECT * FROM db_version ORDER BY structure DESC, content DESC LIMIT 1

You should see some results like:

"version"	"structure"	"content"	"description     "	"comment"
"21     "	"12       "	"4      "	"Encrypted_Letter"	"Encrypted Letter and various text fixes"

In the above example from the MangosZero World Database, I have 21_12_4 Installed

The 21 signifies Rel21 and you have update 12_4 installed.

I would then browse to the \World\Updates\Rel21 folder of the database repo and see whether there are files greater than Rel21_12_04 - If they are, I need to apply them

The same query above can be applied to all three databases.

[antz]

The files in that folder are for upgrading from Rel20 to Rel21.... the base database is much much newer than that
- Which is why you are getting the errors listed above.

[Darklandz]

Editted : Did a new git pull, all seems to be ok now.
 

 

[antz]

That's good to hear

[Cylae]

Hey guys, so how to install manually databases ?

I'm on Debian 8.6

Install the project...
-- Install configuration: "Release"
-- Installing: /home/mangos/zero/bin/realmd
-- Set runtime path of "/home/mangos/zero/bin/realmd" to "/home/mangos/zero/lib"
-- Installing: /home/mangos/zero/etc/realmd.conf.dist
-- Installing: /home/mangos/zero/etc/ahbot.conf.dist
-- Installing: /home/mangos/zero/bin/mangosd
-- Set runtime path of "/home/mangos/zero/bin/mangosd" to "/home/mangos/zero/lib"
-- Installing: /home/mangos/zero/etc/mangosd.conf.dist
-- Installing: /home/mangos/zero/bin/lua_scripts//extensions
-- Installing: /home/mangos/zero/bin/lua_scripts//extensions/_Misc.ext
-- Installing: /home/mangos/zero/bin/lua_scripts//extensions/ObjectVariables.ext
-- Installing: /home/mangos/zero/bin/lua_scripts//extensions/StackTracePlus
-- Installing: /home/mangos/zero/bin/lua_scripts//extensions/StackTracePlus/README.md
-- Installing: /home/mangos/zero/bin/lua_scripts//extensions/StackTracePlus/LICENSE
-- Installing: /home/mangos/zero/bin/lua_scripts//extensions/StackTracePlus/StackTracePlus.ext
-- Installing: /home/mangos/zero/bin/tools/movemap-generator
-- Set runtime path of "/home/mangos/zero/bin/tools/movemap-generator" to "/home/mangos/zero/lib"
-- Installing: /home/mangos/zero/bin/tools/map-extractor
-- Set runtime path of "/home/mangos/zero/bin/tools/map-extractor" to "/home/mangos/zero/lib"
-- Installing: /home/mangos/zero/bin/tools/ExtractResources.sh
-- Installing: /home/mangos/zero/bin/tools/make_vmaps.bat
-- Installing: /home/mangos/zero/bin/tools/mmap_excluded.txt
-- Installing: /home/mangos/zero/bin/tools/MoveMapGen.sh
-- Installing: /home/mangos/zero/bin/tools/offmesh.txt
-- Installing: /home/mangos/zero/bin/tools/README.txt
-- Installing: /home/mangos/zero/bin/tools/vmap-extractor
-- Set runtime path of "/home/mangos/zero/bin/tools/vmap-extractor" to "/home/mangos/zero/lib"
Confirm your MySQL password     , ./getmangos.sh: line 1023: mysql_config_editor: command not found
mysql: unknown variable 'login-path=local'
mysql: unknown variable 'login-path=local'
mysql: unknown variable 'login-path=local'
mysql: unknown variable 'login-path=local'
mysql: unknown variable 'login-path=local'
mysql: unknown variable 'login-path=local'
There was an error creating the databases!

 

[antz]

@Talendrys- Any ideas ?

[Talendrys]

Hello, yes this maybe related to the version of MySQL you're using. Normally, my script is creating a local credential file (the way to interactively login to MySQL without asking for DB password each time). 

With the latest version of MySQL, the following tool is used to register that password: mysql_config_editor.