[SOLVED] Issues setting up MaNGOS

[Campos]

Hello there!

It has been a while since I last dabbling with kind of stuff and seems a lot has changed. I tried compiling my own DB, but that was an ordeal of it's own so I switched to trying to get the pre-compiled version working. I am stuck on the last step...

apply created file to mangos database, eg.: mysql -u root -p mangos < full_db.sql

Do I do that from command prompt, MySQL command line client, or what? Neither seemed to work.

[MrFreak]

You execute this command in your SSH console:

mysql -u root -p mangos < full_db.sql

Full_db.sql is the name of the file which you want to import. 'root' is the user and 'mangos' is the database name in this example. If you use an other user than the default one you have to change 'root' to the name of your account which has sufficient rights for the databases.

[sanctum32]

which core, db you're using?

[Campos]

I am using Mangos One Server - 0.18, Revision 2048, x32 (little-endian)

Where do I find the SSH console?

[MrFreak]

Do you use Windows or Linux? Do you have something like PHPMyAdmin?

[Campos]

I use Windows. I was trying to follow along the guide for Mangos-Zero which I am not sure if it applies. I do not have PHPMyAdmin.

I remembered using HeidiSQL in the past, so I went and downloaded that. I couldn't figure out how to use a command to load the file, but I think I did it right by "Loading SQL File" and selecting the "Full_db.sql" file. It processed all 2000 processes or however many, but returned 108 or so that error'd.

If anyone has some time, an updated video guide on this would be amazing. Looking around, most of them on youtube are 3-4 years old.

[antz]

for Mangos One onwards, this is the latest guide https://github.com/mangoswiki/wiki/wiki/WindowsInstallVM

Obviously skip the setting up a VM bit

Any Questions, let me know.

[Campos]

for Mangos One onwards, this is the latest guide https://github.com/mangoswiki/wiki/wiki/WindowsInstallVM

Obviously skip the setting up a VM bit

Any Questions, let me know.

Awesome, thanks!

Edit: Figured out the directory for CMakeLists was in /src/bindings not the /mangos/ folder... moving forward!

I am having an issue with step 7 though...

We now need to modify the mangos build process to load in the script library

7) edit CMakeLists.txt in this folder

change

# add_subdirectory(scripts)

to

add_subdirectory(scripts)

There is no # add_Subdirectory(scripts) in said file. The closest thing I could find was the following

...
add_subdirectory(dep) # TODO: add vmap extractor build support
...
add_subdirectory(src)
# if(SQL)
#  add_subdirectory(sql)
# endif()

Edit: Couldn't find a more proper spot to put it, but I think there was a error in the wiki.

cd mangosdb
cd _tools
make_full_db
mysql -u root -p mangos < full_db.sql

Should be

cd mangosdb
cd _tools
make_full_db.bat
mysql -u root -p mangos < full_db.sql

shouldn't it? I assume all you are trying to tell it to do is to run the file to create the SQL file. Just using make_full_db returned "sh: make_full_db: command not found. Doing it with the file extension worked.

[Campos]

So I am now having issues with my realmd database, specifically nothing is populated there. The step is telling me to connect to the database, and edit the realmlist table but it isn't there. I tried running realmd.exe and this is what is returned.

Microsoft Windows [Version 6.3.9600]
(c) 2013 Microsoft Corporation. All rights reserved.

C:\WINDOWS\system32>cd C:\mangos

C:\mangos>realmd.exe
MaNGOS One/0.18 (* * Revision 2054 - *) for Win32 (little-endian) [realm-daemon]

<Ctrl-C> to stop.

Using configuration file realmd.conf.
Login Database total connections: 2
MySQL client library: 5.1.49
MySQL server ver: 5.6.15-log
MySQL client library: 5.1.49
MySQL server ver: 5.6.15-log
SQL: SELECT required_z2426_01_realmd_relations FROM realmd_db_version LIMIT 1
query ERROR: Table 'realmd.realmd_db_version' doesn't exist
SQL: SELECT * FROM realmd_db_version LIMIT 1
query ERROR: Table 'realmd.realmd_db_version' doesn't exist
The table `realmd_db_version` in your [REALMD] database is missing or corrupt.
MaNGOS cannot find the version info needed to check that the db is up to date.

This revision of mangos requires a database updated to:
`z2426_01_realmd_relations.sql`

Reinstall your [REALMD] database with the included sql file in the sql folder.

C:\mangos>

I looked over the previous steps and didn't see anything I missed. My scriptdev2 and mangos DBs are all filled.

Edit: Hopefully this all works after all this tinkering I have done... I figured out how to manually execute .sql files through SQLyog and used realmd located in \mangos\sql. This created the realmlist table.

[Hikari]

In the guide it isn't stated but you've to apply realmd.sql into your realmd database and characters.sql into your characters database. Those files are located at server/sql/.

[Campos]

In the guide it isn't stated but you've to apply realmd.sql into your realmd database and characters.sql into your characters database. Those files are located at server/sql/.

Thanks for the tip on the characters DB, didn't even notice that was empty still. Now I am trying to update my DB but am running into an error...

Microsoft Windows [Version 6.3.9600]
(c) 2013 Microsoft Corporation. All rights reserved.

C:\WINDOWS\system32>cd c:\mangos

c:\mangos>mangosd.exe
MaNGOS One/0.18 (* * Revision 2054 - *) for Win32 (little-endian) [world-daemon]

<Ctrl-C> to stop.


####    ####      ###   ###  ########  #######   ########
#####   #####      ####  ### ########## #########  ##########
#####   #####      #####  ### ########## #########  ##########
######  ######      #####  ### ###    ####  #### ###
######  ######  ####  ###### ### ###    ###   ### ###
####### #######  ######  ###### ### ### ##### ###   ### ########
### ### ### ###  ######  ####### ### ### ##### ###   ### #########
### ### ### ### ### ### ### ### ### ### ##### ###   ###  #########
### ####### ### ### ### ### ###### ###  ### ###   ###    ####
### ####### ### ### ### ### ###### ###  ### ###   ###     ###
### ##### ### ########## ###  ##### ###  #### ####  ####    ####
### ##### ### ########## ###  ##### #########  #########  ##########
### ##### ### ###  ### ###  #### #########  #########  #########
###  ###  ### ###  ### ###   ###  #######   #######   #######

                            ###
Website: [url]http://www.getmangos.eu[/url]          ## ## ## ## ####
                           ## ## ### ## ##
 Wiki: [url]http://github.com/mangoswiki/wiki[/url]       ## ## ###### ####
                           ## ## ## ### ##
 Forum: [url]http://community.getmangos.eu[/url]        ###  ## ## ####



Using configuration file mangosd.conf.
OpenSSL 1.0.0d 8 Feb 2011 (Library: OpenSSL 1.0.0d 8 Feb 2011)
Using ACE: 5.8.3
World Database total connections: 2
Connected to MySQL database [email protected]:3306/mangos
MySQL client library: 5.1.49
MySQL server ver: 5.6.15-log
AUTOCOMMIT SUCCESSFULLY SET TO 1
Connected to MySQL database [email protected]:3306/mangos
MySQL client library: 5.1.49
MySQL server ver: 5.6.15-log
AUTOCOMMIT SUCCESSFULLY SET TO 1
SQL: SELECT required_s2054_mangos_command FROM db_version LIMIT 1
query ERROR: Unknown column 'required_s2054_mangos_command' in 'field list'
The table `db_version` in your [WORLD] database indicates that this database is
out of date!

[A] You have: --> `s2034_12522_01_mangos_db_script_string.sql`

[b] You need: --> `s2054_mangos_command.sql`

You must apply all updates after [A] to [b] to use mangos with this database.
These updates are included in the sql/updates folder.
Please read the included [README] in sql/updates for instructions on updating.

c:\mangos>

This is the error I get when trying to import that sql file....

Query:
ALTER TABLE db_version CHANGE COLUMN required_c12484_02_realmd_account_access required_s2054_mangos_command bit

Error occured at:2014-01-01 04:33:33
Line no.:1
Error Code: 1054 - Unknown column 'required_c12484_02_realmd_account_access' in 'db_version'

All the help is greatly appreciated, I am starting to learn more about why you gotta do a certain thing instead of just that you have to do it.

Edit: I think I stumbled upon what I needed. From what I gather, I start updating the next file after (A) until I get to (B). Trying this now

Edit 2: That didn't seem to work, I got the following error.

Query:
ALTER TABLE realmd_db_version CHANGE COLUMN s2034_12522_01_mangos_db_script_string required_c12484_02_realmd_account_access BIT

Error occured at:2014-01-01 04:51:32
Line no.:1
Error Code: 1054 - Unknown column 's2034_12522_01_mangos_db_script_string' in 'realmd_db_version'

[Hikari]

Side note: If you've to apply updates you execute all updates after [ A ] to [ B ] into its appropriate database which is stated after the revision number in the file name (e.g. s2054_mangos_command.sql belongs to mangos database).

Now to your problem. It's not your fault. There is an error in the file. Below is the correct content for s2054_mangos_command.sql.

ALTER TABLE db_version CHANGE COLUMN required_s2034_12522_01_mangos_db_script_string required_s2054_mangos_command bit;

UPDATE `command` SET help = 'Syntax: .account create $account $password [$expansion]\r\n\r\nCreate account and set password to it. Optionally, you may also set another expansion for this account than the defined default value.' WHERE name = 'account create';

And for the update s2049_z2424_xxxxx_01_realm_db_version.sql, which is also after [ A ], isn't needed. It belongs to the realmd database but your database is already up to date. And it has also the wrong content.

[antz]

Thank you for that catch Hikari, I have updated the repo with the correct information

[Campos]

It's up! Thank you for all the help, gentlemen! Now to break it.