Local Server issues

[blackde]

Hello,

I would like to start off by saying thank you to everyone here that has worked hard to make all this possible. I have off and on played EQ since the day of its release. My first toon was a human necro on RZ server. I quit playing for abit then came back when kunark was released and started a Iksar necro on the Drinal server. Which was named something before that. After soloing for a time i joined a raiding guild and stayed there till we beat Omens the latest expansion at the time. I was bored of the class at this point and rolled up a Ogre warrior and raided with him till Underfoot. I didn't much care for the content plus the feeling of eq being more like a job then a hobby. So i quit for the last time. As fate would have it i found this place:) I have tried server 99 some but want to set up a local server of my own to tinker with/ play with my kids. On to my issues lol

Ok so i followed the Complete Windows Server guide. I'm installing it on a 64 bit system. I'm stuck at 6c.) The Database

In the command prompt window cd C:\EQ\SQL brings up C:\EQ\SQL like it should. When i enter mysql -uroot password i get this error:

ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

just with that info i'm sure someone knows the answer but i will ask a few questions anyway please.

1)I'm 95% sure i entered a password for MySQL and even wrote it down...but anyway to check it?

2)when you type mysql -uroot it has a -password on the write up. is the - needed before password?

3)has my server got a name yet? where can i check that

i may have more questions later but these should be good for now

thanks for the help

[Uleat]

mysql -uroot -pyourpassword peq


1) The password is security hashed..and requires a valid login to retrieve.

2) It also needs a 'p'

3) Not my area :/

[blackde]

thanks for the reply

i tried mysql -uroot -ppassword and it gave me a warning about using the password on a command line. plus the same 2003 error

also i tried mysql -uroot -ppassword peq and got the same response

[Bohbo]

You could try resetting the root password to roll that 5% of the dice that you messed up the PW.

http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

[Scorpious2k]

Is MySQL running? Program mysqld.exe - check the task manager.

[Riklin]

If you followed the server setup instructions precisely, then this shouldn't happen. I've done this setup many times in the last month. The issue usually is caused by trying to change the data directory for MySQL, or possibly a permission setup issue. It will also happen if you aren't running MySQL as a service.

You probably need to rerun this program and reconfigure your MySQL instance.
MySQLInstanceConfig.exe.

Once again re-read the server setup guide...


At some point if you get totally frustrated and cannot get it to work, it may be best to uninstall MySQL and start over. MySQL is particularly difficult to completely remove from a windows computer, so do some web searches for completely remove MySQL from windows and follow those instructions. Don't forget to reboot often after doing major things like uninstalling or installing MySQL. Path variables need changed, services need cleaned up, etc. works best with a reboot...

[blackde]

When I opened the task manager I did not see it running. Does this program need to start when windows boots up? I will run the exe you mentioned later. Thanks for the help

[epilz]

Yes, did you perhaps miss this step in the Windows install doc?

On the next screen, ensure 'Install as a Windows Service' is ticked and, very important, tick the box to 'Include Bin Directory in Windows PATH'. Then click Next.

[blackde]

ok so this is what happened. i'm using method 2: using XAMPP

in that step it does not mention anything about the above that you all said. It told me only to change the path.

So i guess i must have clicked thru the install without checking any boxes. I looked for the exe named MySQLInstanceConfig.exe. It is not on my machine. Does anyone have a solution to this or must i uninstall and start again?

Before i began this thread i looked on SQL forums and from what i read it sounds like removing SQL aint easy:(

thanks

[Scorpious2k]

I haven't used XAMPP but I have used WAMP. Try starting it and see if that doesn't also start MySQL. Maybe an option in it like putting it online?

[blackde]

ok so i did some digging on sql website and think i removed sql. I then downloaded version 5.1 directly from the source. I went thru all the steps outlined in installing mysql "not" using xampp.

This leads me to my next question please:

I went to the "path" and it shows \MySQL\MySQL Server 5.1\bin at the end. Does this look correct or do i need to find mysql.exe and point there at the end?

Also when setting up the sql config i entered my password. Later in method 2: USing Xampp it has me opening a command prompt and typing mysql -root and

SET PASSWORD FOR 'root'@localhost' = PASSWORD('your_password');

do i need to enter the above or has my password already been set from the config earlier?

Thank you

[epilz]

I used XAMPP the first time I installed and ran into multiple issues. I just reinstalled OS and started from scratch. No issues as of today

[blackde]

ok i think i have gotten the server up and running. When i started the bat window the command window opened quickly and I saw a few .exe open. AT the moment i have a command prompt open and it says C:\EQ\EQEmuServer\eqlaunch.exe. What should i be looking for if the server is actually running? Also How do i stop the server.

I went on to the Private server setup guide Step 5

I'm having an issue here. I don't have Heidisql installed anymore only stand alone mysql. I'm not sure which file to click to set up accounts. The guide said i can use a mysql prompt but doesn't explain how. I downloaded RoF from steam and adjusted eqhost also changed the shortcut to have a patchme behind it.


thanks for the advice so far

[blackde]

nvm the server didn't work. will look into logs and post if i'm unable to figure out. thanks

[blackde]

I keep having errors in the syntax and username issues. After viewing a few youtube videos on installing sql with xampp i was able to resolve some issues. I had to use the xampp control panel to set php passwords and mysql.

ALso i had to enter UPDATE mysql.user SET Password=PASSWORD('new-password-here') WHERE User='user-name-here';

I have complied the data base and updating it now.

[blackde]

ok status update

I have two dos windows up atm. One is EQEmu Login Server Which has many differant prompts with no errors and the last saying Server Started. The other window is the eqlaunch.exe with nothing in it. I think the server is running atm lol.

I have HeidiSQL 9.1.0.4867 running. I'm trying to make accounts but i'm having trouble where to do this. On the guide it shows what info must be placed but where on Heidi do i do this. There are 8 databases in Heidi

Thanks

[epilz]

what accounts are you trying to make? You should see 4 windows, not 2. Should see World.exe, queryserv.exe, ucs.exe, and eqlaunch.exe. Are you using a batch file to lauch them?

[blackde]

Yes a .bat file like the one setting up a local server guide.

The accounts are for player accounts. I know I can make them in a prompt window or heidi. The prompt version I'm not sure exactly what to put. The guide shows the info but I just don't want to f it up. I did a google search on creating eqemu accounts with heidi but the folder I don't see on the heidi window.

[epilz]

go to your folder where your world.exe file is located. You will have to unlock your server and login your accounts. Type world flag XXXX 250 the XXXX is your account name you want to flag. Lock your server and reboot, and then you can login while its locked

[blackde]

ok thanks i will try that. here is the log From Eqemuserver file

[Debug] [02.10.15 - 22:12:25] Logging System Init.
[Debug] [02.10.15 - 22:12:25] Config System Init.
[Debug] [02.10.15 - 22:12:25] MySQL Database Init.
[Debug] [02.10.15 - 22:12:25] Encryption Initialize.
[Debug] [02.10.15 - 22:12:25] Encryption Loaded Successfully.
[Debug] [02.10.15 - 22:12:25] Server Manager Initialize.
[Network] [02.10.15 - 22:12:25] ServerManager listening on port 5998
[Debug] [02.10.15 - 22:12:25] Client Manager Initialize.
[Network] [02.10.15 - 22:12:25] ClientManager listening on Titanium stream.
[Network] [02.10.15 - 22:12:25] ClientManager listening on SoD stream.
[Debug] [02.10.15 - 22:12:25] Server Started.

I copied all files into EQ\EQEmuServer that end with pdb. Per the guide its for logs to check world,ect. When i try to open these files with any program i get a working hour glass and it won't open.

below is the part confusing me

You now have the required database tables, but they are empty and so no one will be able to log in yet. Open up either HeidiSQL or just do this in the mysql prompt:-
?
1
2
INSERT INTO tblloginserveraccounts (AccountName,AccountPassword,AccountEmail,LastIPAd dress,LastLoginDate)
VALUES ('your_account_name',sha('your_password'),'me@me.c om','127.0.0.1','2014-01-01 00:00:01');

These files already exist in my EQ\SQL folder. When i click on the file it opens Heidi program but just the generic log in screen is there with no options.

[blackde]

so i looked at examples of others config.xml file and made some changes there

so now i have 5 windows open world.exe, login server, ucs.exe, eqluanch.exe, queryserver.exe

i coped and pasted this from the world.exe

[World Server] Loading server configuration..
[World Server] CURRENT_VERSION: 1.0.0
[World Server] Added loginserver 127.0.0.1:5998
[World Server] Connecting to MySQL...
[World Server] HTTP world service disabled.
[World Server] Checking Database Conversions..
Pulling down automatic database upgrade script...
[Upgrade Script] No script update necessary
Perl Version is 5.12.3
Warning: Using a password on the command line interface can be insecure.
ERROR 1146 (42S02) at line 1: Table 'peq.db_version' doesn't exist
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Table 'db_version' does not exists.... Creating...

Warning: Using a password on the command line interface can be insecure.
================================================== ==========
EQEmu: Automatic Upgrade Check
================================================== ==========
(Windows) MySQL is in system path
Path = C:\xampp\mysql\bin/mysql
================================================== ==========
Binary Database Version: (9075)
Local Database Version: (1000)

Retrieving latest database manifest...
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
db_update_manifest.txt
Saved: db_update/db_update_manifest.txt
You have missing database updates, type 1 or 2 to backup your database before ru
nning them as recommended...

Database Management Menu (Please Select):
1) Backup Database - (Saves to Backups folder)
Ideal to perform before performing updates
2) Backup Database Compressed - (Saves to Backups folder)
Ideal to perform before performing updates
3) Check for pending REQUIRED Database updates
Stages updates for automatic upgrade...
4) AAs - Get Latest AA's from PEQ (This deletes AA's already in the data
base)
5) OPCodes - Download latest opcodes from repository
0) Exit

> 1)
Database Management Menu (Please Select):
1) Backup Database - (Saves to Backups folder)
Ideal to perform before performing updates
2) Backup Database Compressed - (Saves to Backups folder)
Ideal to perform before performing updates
3) Check for pending REQUIRED Database updates
Stages updates for automatic upgrade...
4) AAs - Get Latest AA's from PEQ (This deletes AA's already in the data
base)
5) OPCodes - Download latest opcodes from repository
0) Exit

> 1
Can't open perl script "db_dumper.pl": No such file or directory
db_dumper.pl not found... retrieving...

URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/scri
pts/db_dumper.pl
Saved: db_dumper.pl
Performing database backup....
Warning: Using a password on the command line interface can be insecure.

Todays Date: 02-11-2015
Operating System is: MSWin32
Database is peq
Backup Directory: backups
Directory does NOT exist! Creating...

Backing up Database peq...

--- CMD ---
mysqldump -uroot --host 127.0.0.1 --max_allowed_packet=512M --password="*******"
peq > "backups\peq 02-11-2015.sql"
---------------------------------------

Backup DONE... DB Backup File Size '212432598' (202.59 MiB)

Final file located: backups\

Database Management Menu (Please Select):
1) Backup Database - (Saves to Backups folder)
Ideal to perform before performing updates
2) Backup Database Compressed - (Saves to Backups folder)
Ideal to perform before performing updates
3) Check for pending REQUIRED Database updates
Stages updates for automatic upgrade...
4) AAs - Get Latest AA's from PEQ (This deletes AA's already in the data
base)
5) OPCodes - Download latest opcodes from repository
0) Exit

I did a backup to database but not sure where to move forward now. It said something about missing an update or something.

thanks

[blackde]

sorry more info coming in...

[Debug] [02.11.15 - 22:47:11] Logging System Init.
[Debug] [02.11.15 - 22:47:11] Config System Init.
[Debug] [02.11.15 - 22:47:11] MySQL Database Init.
[Debug] [02.11.15 - 22:47:11] Encryption Initialize.
[Debug] [02.11.15 - 22:47:11] Encryption Loaded Successfully.
[Debug] [02.11.15 - 22:47:11] Server Manager Initialize.
[Network] [02.11.15 - 22:47:11] ServerManager listening on port 5998
[Debug] [02.11.15 - 22:47:11] Client Manager Initialize.
[Network] [02.11.15 - 22:47:11] ClientManager listening on Titanium stream.
[Network] [02.11.15 - 22:47:11] ClientManager listening on SoD stream.
[Debug] [02.11.15 - 22:47:11] Server Started.
[Network] [02.12.15 - 00:11:47] New world server connection from 127.0.0.1:50206
[Network Error] [02.12.15 - 00:11:47] Handle_NewLSInfo error, remote address was null, defaulting to stream address 127.0.0.1.
[Database] [02.12.15 - 00:11:47] Mysql query failed: SELECT WSR.ServerID, WSR.ServerTagDescription, WSR.ServerTrusted, SLT.ServerListTypeID, SLT.ServerListTypeDescription, WSR.ServerAdminID FROM tblWorldServerRegistration AS WSR JOIN tblServerListType AS SLT ON WSR.ServerListTypeID = SLT.ServerListTypeID WHERE WSR.ServerShortName = 'setme'
[World] [02.12.15 - 00:11:47] Server I Forgot To Edit My Config(setme) attempted to log in but database couldn't find an entry but unregistered servers are allowed.
[Database] [02.12.15 - 00:11:47] Mysql query failed: SELECT max(ServerID) FROM tblWorldServerRegistration
[Database] [02.12.15 - 00:11:47] Mysql query failed: UPDATE tblWorldServerRegistration SET ServerLastLoginDate = now(), ServerLastIPAddr = '127.0.0.1', ServerLongName = 'I Forgot To Edit My Config' WHERE ServerID = 0