汪可微

On 2/5/2020 at 11:01 PM, Fyre said:

@汪可微 @onixiyaI noticed that on line #47 it says INSERT INTO `creature_TEMPLATE` where it should say INSERT INTO `creature_template`.

Change the capital TEMPLATE to all lowercase, and it will work.
I've spoken with @Necrovoice and he should be updating the github repo as well.

nice job!  i can finally save my private server ~

11 hours ago, razz2u2 said:

I have finally got the zero server up and running and was able to connect to it. The only question I have is do you have to do anything special to get the playerbots working?  I have enabled the playerbot config file and the ahbot config file.  The ahbot is working fine. When i go to add a bot  using ".bot add name " it says no such  command.  Are they supposed to be installed by default? I remember a couple years ago there was a install file to run and you had to select if you wanted it to install.  

 

you need create some characters in your account ,then try .bot add [character name] again,if it dosn't work maybe need sql databases support

On 1/27/2020 at 8:39 AM, razz2u2 said:

Ok, first off thank you for the help provided so far. I am real close. I just need to know the location where the maps need to be placed.  I had to extract the maps on my windows machine. I have the three folders and just need to figure out where they need to go. I get the following error when running mangosd. 

Please check for the existence of map file '../etc/maps/0004331.map'
Correct *.map files not found in path '../etc/maps' or *.vmtree/*.vmtile files i                                 n '../etc/vmaps'. Please place *.map and vmap files in appropriate directories o                                 r correct the DataDir value in the mangosd.conf file.

I have put the folders in several etc folders but none has been the right one. Does the ../ refer to root of the drive?

you can define the path in mangosd.conf, and i think the path like /home/mangos/your/maps/path/ is better than ../your/maps/path

1 hour ago, onixiya said:

Can we see what the error was?

Rel21_10_147__Marsh_Caribou.sql import failed,i don't know why ,and how to fix it.

9 minutes ago, onixiya said:

You'll need to run the code in the sql file manually

i just did as you say, code one by one ,manually , it stucked at Rel21_10_147__Marsh_Caribou.sql, but 21_10_109 to 21_10_145 goes fine

42 minutes ago, Natrist said:

Hi,

You need to update your realmd database.

yes ,and when i update the world database,but another problem arises.

root@mangos-two:/opt/mangos/database/World/Updates/Rel21# mysql -umyname -pmypass mangos2 < Rel21_10_147__Marsh_Caribou.sql
mysql: [Warning] Using a password on the command line interface can be insecure.
===== Status =====      ===== DB is on Version: =====
* UPDATE FAILED *       Twilight Thug - Script Update
root@mangos-two:/opt/mangos/database/World/Updates/Rel21# mysql -umyname -pmypass mangos2 < Rel21_10_148_Script_update_for_Mobu.sql
mysql: [Warning] Using a password on the command line interface can be insecure.
===== Status =====      === Expected ===        ===== Found Version =====
* UPDATE SKIPPED *      Rel21_10_147 - IS NOT APPLIED   21_10_146 - Twilight Thug - Script Update

i get this messages,when i run systemctl realmd status

Jan 12 01:01:02 mangos-two realmd[11325]:                         Content: 4
Jan 12 01:01:02 mangos-two realmd[11325]:                     Description: Remove dbDocs
Jan 12 01:01:02 mangos-two realmd[11325]:   You need database Version: 21
Jan 12 01:01:02 mangos-two realmd[11325]:                       Structure: 2
Jan 12 01:01:02 mangos-two realmd[11325]:                         Content: 1
Jan 12 01:01:02 mangos-two realmd[11325]:                     Description: Add_Field_Comments
Jan 12 01:01:02 mangos-two realmd[11325]: You must apply all updates after [A] to to use MaNGOS with this database.
Jan 12 01:01:02 mangos-two realmd[11325]: These updates are included in the database/Realmd/Updates folder.
Jan 12 01:01:02 mangos-two systemd[1]: realmd.service: Main process exited, code=exited, status=1/FAILURE
Jan 12 01:01:02 mangos-two systemd[1]: realmd.service: Failed with result 'exit-code'.
 

i have this installed

lxc launch ubuntu:bionic mangos-two

what shoud i do? thanks in advance!

please share some videos about this. thx

step2: mangos-server-installation

This step should be done inside the container ?