Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 07-17-2010, 07:32 PM
Knotthead
Fire Beetle
 
Join Date: Mar 2009
Location: denver
Posts: 21
Default

Thanks Black,

I have absolutely no experience using C++, MYSQL, Pearl, etc. I am a total noob at programming.

when I am entering each line 1 at a time I get a result -
Query OK, 0 rows affected <0.00 sec>

Is this the results I am looking for?
Thanks for the help
Reply With Quote
  #2  
Old 07-17-2010, 10:47 PM
blackdragonsdg
Dragon
 
Join Date: Dec 2008
Location: Tennessee
Posts: 656
Default

Yes, you could definitely see that once, twice, or not at all but that will depend on what it is that you are sourcing in.

You are entering each line one at a time? Each line meaning load_player.sql or the contents of load_player.sql? You seem to be on the right path but there might have been a slight misunderstanding.

So just to make sure we are on the same page. This is an example of what I meant before.

Contents of load_player.sql
Code:
source D:/Everquest/SVN/PEQ Database/player_tables/aa_timers.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/account.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/account_ip.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/account_rewards.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/adventure_details.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/adventure_members.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/adventure_stats.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/Banned_IPs.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/bugs.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/buyer.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/char_recipe_list.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/character_.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/character_activities.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/character_enabledtasks.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/character_tasks.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/character_backup.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/chatchannels.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/commands.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/completed_tasks.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/db_version.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/eventlog.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/faction_values.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/friends.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/gm_ips.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/group_id.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/group_leaders.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/guild_bank.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/guild_members.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/guild_ranks.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/guild_relations.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/guilds.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/hackers.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/inventory.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/instance_lockout.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/instance_lockout_player.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/keyring.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/launcher.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/launcher_zones.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/mail.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/merchantlist_temp.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/name_filter.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/object_contents.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/petitions.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/player_corpses.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/player_corpses_backup.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/player_titlesets.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/quest_globals.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/raid_details.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/raid_members.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/reports.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/respawn_times.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/rule_sets.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/rule_values.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/sharedbank.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/spell_globals.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/timers.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/trader.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/trader_audit.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/variables.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/zone_flags.sql;
Your load_player.sql should look something like that and if it does then a simple sourcing of load_player.sql will source in all of those files.
Reply With Quote
  #3  
Old 08-30-2010, 02:23 PM
Nibor
Fire Beetle
 
Join Date: Aug 2010
Posts: 3
Default BIG Problems with this guide

When following this guide exactly this is what happens

1) Download and install Tortoise SVN∞.
After it's installed, navigate to your MySQL installation folder. In that directory, you should see a folder named bin - this is where you'll download the database to.

2) Right-click the folder and select SVN Checkout.
In the new window that pops up, where it says URL of Repository at the top, paste in:

http://projecteqdb.googlecode.com/svn/trunk
The line under that where it says Checkout directory: is the location of the folder you are downloading it to - keep an eye on that to make sure it's the correct folder.


Problems:
If you Install Mysql (Custom) and check C Include Files / Lib Files
you will recieve a warning that there are already files in the bin folder.

Also
When importing the database to the bin folder this way (currently rev1589) it creates the follow file path C:mysql/bin/projecteqdb/peqdatabase causing a failure at step 4a in the guide

A) Then type: source peqdb_Rev859.sql; (rev1589 in my case)
and press Enter.

I'm guessing since peqdb_rev1589.sql is not directly the bin folder and ends up in the peqdatabase folder ?
Reply With Quote
  #4  
Old 08-30-2010, 03:01 PM
Nibor
Fire Beetle
 
Join Date: Aug 2010
Posts: 3
Default Could somebody PLEASE update this guide?

Hopefully somebody can update it with regard to correct file/folder pathing so it works. I guess I need guide for dummies. *sigh* since I can't even get past step 4A
Reply With Quote
  #5  
Old 08-30-2010, 04:47 PM
blackdragonsdg
Dragon
 
Join Date: Dec 2008
Location: Tennessee
Posts: 656
Default

Nibor the guides are just that guides they are not perfect. The step you are stuck at probably needs to be cleaned up a bit. Try this, create a folder called peqdatabase on your C: drive. Then repeat this part:
Quote:
Originally Posted by Nibor View Post
2) Right-click the folder and select SVN Checkout.
In the new window that pops up, where it says URL of Repository at the top, paste in:

http://projecteqdb.googlecode.com/svn/trunk
The line under that where it says Checkout directory: is the location of the folder you are downloading it to - keep an eye on that to make sure it's the correct folder.
When you do that it should download the entire database. After that completes navigate to the C:\peqdatabase\ directory and unzip the file called peqdb_rev1589.sql to your C: drive.

Open up the mysql command line utility and login then type the following lines pressing enter after each one.

CREATE DATABASE peq;
use peq
source C:/peqdb_rev1589.sql

If you did everything correctly you will see a whole bunch of text scrolling down the mysql window. After that finishes navigate to the C:\peqdatabase directory and locate the files named load_player.sql and bots.sql

You will need to open both files with notepad and complete the file paths contained within. By default load_player.sql will look something like this.

source player_tables/aa_timers.sql;
source player_tables/account.sql;
source player_tables/account_ip.sql;

You will need to modify it to look something like this

source C:/peqdatabase/player_tables/aa_timers.sql;
source C:/peqdatabase/player_tables/account.sql;
source C:/peqdatabase/player_tables/account_ip.sql;

Then do the same thing with the bots.sql file.

Afterwards you need to source both files into mysql. Login to mysql and type

source C:/peqdatabase/load_player.sql

then press enter...after that finishes repeat the process for load_bots.sql

Now after that your database should be loaded.
Reply With Quote
  #6  
Old 08-30-2010, 07:08 PM
Nibor
Fire Beetle
 
Join Date: Aug 2010
Posts: 3
Default thanks

I figured it out and get up to step 7 with no problems at all but then it gets a bit sketchy since I couldn't find the file eqemulogin.ini anywhere but did find a file login.ini .. used that and edited it when i got to step 13..

[database]
host = localhost
port = 3306
db = peq
user = root
password = square
subsystem = MySQL

[options]
unregistered_allowed = TRUE
reject_duplicate_servers = FALSE
trace = TRUE
world_trace = true
dump_packets_in = True
dump_packets_out = True
listen_port = 5998
local_network = 192.168.2.4

anyway I went on and followed the rest of the guide to step 12 with no problems where i get lost again because I have no idea what my dyndns address is , where or how that info, any suggestions?

anyway I went ahead and finished the guide without that info and in the end when i run my startup.bat i get connecting to the server failed error 10061
launcher error world server connect Failed
Reply With Quote
  #7  
Old 08-30-2010, 11:47 PM
blackdragonsdg
Dragon
 
Join Date: Dec 2008
Location: Tennessee
Posts: 656
Default

When the guide refers to server.dyndns.org it is a website or service people use to simplify configuring ip addresses. If you know the ip address of your modem then use it as it will accomplish the same thing.
Reply With Quote
  #8  
Old 08-31-2010, 05:51 PM
Bransen
Fire Beetle
 
Join Date: Aug 2010
Posts: 6
Default

Ok, I feel a little dumb for even asking this, but I have set up my server with no problems at all. Everything works as it should, except I don't have GM privileges in the game. I have tried changing the ServerAdminID variable from 1 to match my loginid, but it doesn't work. Any help would be appreciated.
Reply With Quote
  #9  
Old 08-31-2010, 06:16 PM
joligario's Avatar
joligario
Developer
 
Join Date: Mar 2003
Posts: 1,498
Default

Assuming your account is the first one, you can do this from a mysql prompt:
UPDATE account SET status = 250 WHERE id = 1;
Reply With Quote
  #10  
Old 09-01-2010, 02:47 PM
Bransen
Fire Beetle
 
Join Date: Aug 2010
Posts: 6
Default

Thank you, that worked a treat.
Reply With Quote
  #11  
Old 09-04-2010, 04:29 PM
Bransen
Fire Beetle
 
Join Date: Aug 2010
Posts: 6
Default

Ok, so I have everything working perfectly on my local lan, but I told my brother about eqemu who lives across the country from me and now he wants to play with me on my server. I looked up a bunch of stuff on this site, but am still having problems. Here are the steps I took:

-I went to dyndns.org and made a free dyndns server pointing to my ip.

-I went to my router and used its dyndns settings to connect it to the dyndns server. (It told me Update OK when I checked the status)

-I went into the equemuconfig.xml and changed address and loginserver.host to the new dyndns server.

-I went into eqhost file and changed it to point to dyndns server.

I ran my server and everything seems to run normally, except the login server. I could not log in from my client. I do not know if this is significant, but when I changed my eqhost back to my local ip I could login, but could not see the server. Any help or ideas would be appreciated.

EDIT: Found an error message in my world.exe window saying could not connect to login server: censored.dydns.org:5998
Reply With Quote
  #12  
Old 09-04-2010, 05:09 PM
joligario's Avatar
joligario
Developer
 
Join Date: Mar 2003
Posts: 1,498
Default

Did you change your windows host file to point your dyndns to your computer holding your server?
Reply With Quote
  #13  
Old 09-04-2010, 05:31 PM
Bransen
Fire Beetle
 
Join Date: Aug 2010
Posts: 6
Default

how do I go about doing that? I found the windows host file, but I'm not sure what to put... do I put my local ip 192.168.1.1 then censored.dyndns.org? Sorry for all the questions, I haven't worked with servers at all before this.
Reply With Quote
  #14  
Old 09-04-2010, 07:13 PM
Bransen
Fire Beetle
 
Join Date: Aug 2010
Posts: 6
Default

Ok, I found a post on how to do that, but it still doesn't work. My world.exe window still says it cannot connect to my login server at censored.dyndns.org any other ideas?
Reply With Quote
  #15  
Old 09-04-2010, 10:36 PM
Bransen
Fire Beetle
 
Join Date: Aug 2010
Posts: 6
Default

I finally gave in and hosted it on eqemu, it seems to work fine now. No clue what the issue was. Thank you for all the help
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 10:20 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3