Windows Server Installer :: Modular & Scripted

[ElleAir55]

Hello. Im getting "no connection" error but Im online. btw Im trying to install from Japan..Isn't the location problem?



Administrative permissions required. Detecting permissions...
Success: Administrative permissions confirmed.
################################################## #######
#::: EverQuest Emulator Modular Installer
#::: Installer Author: Akkadius
#:::
#::: EQEmulator Server Software is developed and maintained
#::: by the EQEmulator Developement team
#:::
#::: Everquest is a registered trademark
#::: Daybreak Game Company LLC.
#:::
#::: EQEmulator is not associated or
#::: affiliated in any way with Daybreak Game Company LLC.
################################################## #######
:
################################################## #######
#::: To be installed:
################################################## #######
- Server running folder - Will be installed to the folder you ran this script
- MariaDB (MySQL) - Database engine
- Heidi SQL (Comes with MariaDB)
- Perl 5.12.3 :: Scripting language for quest engines
- LUA Configured :: Scripting language for quest engines
- Latest PEQ Database
- Latest PEQ Quests
- Latest Plugins repository
- Automatically added Firewall rules
- Maps (Latest V2) formats are loaded
- New Path files are loaded
- Optimized server binaries
################################################## #######
[Update] No connection to the internet, can't check update
[Update] Cannot check update without internet connection...
'world' は、内部コマンドまたは外部コマンド、
操作可能なプログラムまたはバッチ ファイルとして認識されていません。
[eqemu_server.pl] No database connection found... Running without
[Install] EQEmu Server Installer... LOADING... PLEASE WAIT...
[Download] Cannot download without internet connection...
[Update] Fetching Latest Windows Binaries...
[Download] Cannot download without internet connection...
[Update] Fetched Latest Windows Binaries...
[Update] Extracting... ---
IO error: opening updates_staged/master_windows_build.zip for read : No such file or directory
at C:/Perl/lib/Archive/Zip/Archive.pm line 546
Archive::Zip::Archive::read('Archive::Zip::Archive =HASH(0x65f43f4)', 'updates_staged/master_windows_build.zip') called at eqemu_server.pl line 1706
main::unzip('updates_staged/master_windows_build.zip', 'updates_staged/binaries/') called at eqemu_server.pl line 1201
main::fetch_latest_windows_binaries() called at eqemu_server.pl line 376
main::do_installer_routines() called at eqemu_server.pl line 271
main::new_server() called at eqemu_server.pl line 767
main::show_menu_prompt() called at eqemu_server.pl line 485
main::check_for_world_bootup_database_update() called at eqemu_server.pl line 71
read error at eqemu_server.pl line 1707.

[Lane]

I got my first server up and running in no time, simply awesome work. Question, though, where do I go from here? I tried reading through the wiki/forums and can't find where I should start studying on how to edit my database. I did see and watch some videos on EOC but wasn't sure if that should be my go-to for all things DB related?


Some things I'd like to learn how to do:
-Create/modify items, NPCs, spells (I saw these were options in EOC.)
-Disable certain classes (create new if possible?)

I also saw on the front page there will be a new wiki soon? (in the upcoming year I hope?)- awesome news.

[ChaosSlayerZ]

Quick question.
I just used this auto-installer for the first time on a new PC, and I completely out of touch with all things I knew about Emu.
How do I change from default DB password?

Thank you!

[phantomghost]

In the xml file it sets your MySQL user/pw automatically.

You would have set this in order to run the installer. Unless you are trying to add a secondary MySQL user ?

[ChaosSlayerZ]

well I guess it already set it to "root" and now I want to change it

[phantomghost]

I have never changed user, but can try this.. copy/paste from google

Instructions

Click the Windows "Start" button and type "cmd" in the search text box. Press*Enter*to open the Windows command line.

Type "mysql" and press*Enter*to start the MySQL command line utility. Using the MySQL command line, you can update the tables on the database.

Type the following SQL code to update the root user:
UPDATE mysql.user SET user='newuser' WHERE User = 'root';
Change*newuser*with the value you want to use in place of*root

Type the following SQL code to change the default user's password:
UPDATE mysql.user SET authentication_string = password('pass') WHERE User = 'newuser';
Replace*pass*with the new password, and replace*newuser*with the name of the user you set up in the previous step.

[ChaosSlayerZ]

thanks! i will try this

[jpyou127]

Install HeidiSQL and under one of the menus is "users". Edit there, much easier than running commands from cmd.

[karecalt187]

This is what I get when trying to connect to mysql. I am following the advanced guide for server setup on windows. I get this when trying to setup mysql in step 3 of the guide...am I in the wrong directory someone else mentioned restarting but I do not see a command for that or file? Thank you

C:\xampp\mysql\bin>mysql -uroot
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061 "Unknown error")

[phantomghost]

Not exactly sure which part you are at... Probably the second half of this post.

Did you launch xampp and Start Mysql


Need to start it Everytime... You can set it to start always, but I have run into issues that it does not start.

Then when you go to CMD prompt you would type

MySQL -uroot -ppassword

Where root is your user (if user was account it would read -uaccount)

Where password is your password (if password was secret it would read -psecret)

Then you can do:
use peq;

Change peq to your database name. (If you save a SQL file from heidisql from your database it will put entries in the file to make the changes to the database you pulled it from... In the event you make multiple servers and want to copy an entire table from 1 to the other).

Or what part are you at? Looks like your trying to set password after you set the path?

If so just type
MySQL -uroot

In the CMD window. You don't need to add the exact location like you did when setting the path.

[karecalt187]

Well I skipped past the MySQL setting password at the beginning and kept going forward in the guide but it never told me to run xampp I guess....logical step. Let me try your solution I am sure it is something simple like this.

[Ladrone]

trying to install EQEmu on Win 7 Ultimate x64 VM, the eqemu_install.bat file is hanging after creating the maps folder. any ideas?

[Akkadius]

Originally Posted by Ladrone

trying to install EQEmu on Win 7 Ultimate x64 VM, the eqemu_install.bat file is hanging after creating the maps folder. any ideas?

Be patient or re-run the batch file again

[Ladrone]

I made sure all Windows 7 updates are current, I re-ran the installer and I still get to this point:

[Install] Fetching Latest Maps... (This could take a few minutes...)
[Copy] folder doesn't exist, creating 'maps/'

it has been sitting at this point for more than 2 hours now, is that to be expected?

[kokey98]

maps can take a while... how fast is your connection, their servres etc.. more than 1 factor at play. go make lunch or something. if it's not stuck, you're just adding time if you interrupt the download. 2 hours is probably safe to start over, though. make sure there isn't a y/n prompt.

you don't need to run xampp after installed/setup. just make sure 3 services are set to 'automatic' or add it to bat file to "net start"/stop services with server. i made sure to copy/paste exact names:

apache2.4
sqlwriter
mysql

you can find them in services.msc - run that as a command or click "services" button in task manager etc.. multiple ways to get there.

net start ...
net stop ...

will start and stop any service in a bat file / cmd prompt. or set them as "automatic" and not worry about them being ready.

if you've gone from advanced self install to installer, make sure to start 100% fresh. remove everythign and start clean for installer.