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

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

Reply
 
Thread Tools Display Modes
  #16  
Old 11-17-2013, 01:02 PM
provocating's Avatar
provocating
Demi-God
 
Join Date: Nov 2007
Posts: 2,175
Default

I am of limited help since my server is on Debian, but what O.S. is this and is it a fresh install? Where did you snapshot? Before or after the MySQL install?
Reply With Quote
  #17  
Old 11-17-2013, 01:05 PM
khalathas
Sarnak
 
Join Date: Jun 2007
Posts: 67
Default

Incidentally, just to give specs, I'm currently running vmware workstation 10, windows 7 ultimate x64 with sp1, allocating 8gb of ram to the vm, with 2x dualcore cpus to the vm (I have plenty of hardware on the host machine). 60gb virtual hard drive. I am not patching in any way before the install of mysql. This is as fresh as it gets off the win7 install disc (an ISO I got through my MSDN subscription).
Reply With Quote
  #18  
Old 11-17-2013, 01:06 PM
khalathas
Sarnak
 
Join Date: Jun 2007
Posts: 67
Default

The snapshot is immediately after win7 itself finishes its install. There isn't a single bit of post-install modification on it.
Reply With Quote
  #19  
Old 11-17-2013, 01:10 PM
provocating's Avatar
provocating
Demi-God
 
Join Date: Nov 2007
Posts: 2,175
Default

x32 or x64?
Reply With Quote
  #20  
Old 11-17-2013, 01:12 PM
khalathas
Sarnak
 
Join Date: Jun 2007
Posts: 67
Default

OS is x64, I need that for the amount of RAM I'm allocating. I'm using the 32bit installer per the instructions in the server guide.
Reply With Quote
  #21  
Old 11-17-2013, 01:15 PM
provocating's Avatar
provocating
Demi-God
 
Join Date: Nov 2007
Posts: 2,175
Default

I see no reason to use the x32 bit of MySQL unless I am missing something. Revert your snapshot, install the x64 and try again. Also just for giggles disable the Windows Firewall.
Reply With Quote
  #22  
Old 11-17-2013, 01:16 PM
khalathas
Sarnak
 
Join Date: Jun 2007
Posts: 67
Default

I'll give those a shot. I ONLY used the 32bit versions because the guide said to, and I've successfully used the guide to set up the server before (and had quite a bit of enjoyable playtime out of it). I do prefer using 64 bit when I can unless there's a specific reason not to.
Reply With Quote
  #23  
Old 11-17-2013, 01:20 PM
khalathas
Sarnak
 
Join Date: Jun 2007
Posts: 67
Default

Hah. 64bit worked first try. I guess the 32 bit installer truly hates 64bit windows. I think I will keep the server as a vm and proceed with the rest then.
Reply With Quote
  #24  
Old 11-17-2013, 01:23 PM
khalathas
Sarnak
 
Join Date: Jun 2007
Posts: 67
Default

speaking of ram, I wonder how much ram would be necessary cumulatively to run every single zone as a static, and only have dynamics for instanced content...
Reply With Quote
  #25  
Old 11-17-2013, 01:57 PM
provocating's Avatar
provocating
Demi-God
 
Join Date: Nov 2007
Posts: 2,175
Default

My personal findings, and this is just me....I had problems with static zones. Memory wise they did not tax my server at all, it was an issue with the day/night cycles and maybe a few old peq scripts that need TLC, the zone logs got huge and that told me the server was constantly having to write to these log files. Other zones would randomly shutdown and I think it was script problems, I run vanilla PEQ. I run a pseudo dynamic / static zone thing where the zones stay open for maybe an hour, then close if they are vacant.
Reply With Quote
  #26  
Old 11-17-2013, 02:01 PM
khalathas
Sarnak
 
Join Date: Jun 2007
Posts: 67
Default

hmm..well what I was running was statics that contained any valid rare/named/group/raid targets that my friends and I were actively interested in. If it were too high or too low, I just kept 'em dynamic. Then again I'm also planning on those vsphere boxes and spreading the zoneservers out across them.
Reply With Quote
  #27  
Old 11-17-2013, 02:20 PM
provocating's Avatar
provocating
Demi-God
 
Join Date: Nov 2007
Posts: 2,175
Default

I may go back to statics but this time I will start with classics and run them for a while and weed out the bad zones, then go from there.
Reply With Quote
  #28  
Old 11-17-2013, 03:50 PM
khalathas
Sarnak
 
Join Date: Jun 2007
Posts: 67
Default

Gah I could kick myself right now. In my frustrations last night to reinstall mysql I backed up the peq database, but I was still using the older system that used a separate peqlogindb database and forgot to back up my accounts. I still have all the character data, but now I gotta rebuild the accounts in the correct order so they attach to the character data properly >.<
Reply With Quote
  #29  
Old 11-17-2013, 05:11 PM
provocating's Avatar
provocating
Demi-God
 
Join Date: Nov 2007
Posts: 2,175
Default

Unless you have a ton, it should not be a major endeavor.
Reply With Quote
  #30  
Old 11-18-2013, 01:01 AM
khalathas
Sarnak
 
Join Date: Jun 2007
Posts: 67
Default

*sigh* any ideas? Yes I put the login tables directly into peq instead of peqlogindb like they used to be.

Code:
[Debug] [11.17.13 - 23:55:46] Logging System Init.
[Debug] [11.17.13 - 23:55:46] Config System Init.
[Debug] [11.17.13 - 23:55:46] MySQL Database Init.
[Database] [11.17.13 - 23:55:47] Failed to connect to MySQL database. Error: нннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннн
Code:
[database]
host = localhost
port = 3306
db = peq
user = root
password = <edited out>
subsystem = MySQL

[options]
unregistered_allowed = TRUE
reject_duplicate_servers = FALSE
trace = TRUE
world_trace = FALSE
dump_packets_in = FALSE
dump_packets_out = FALSE
listen_port = 5998
local_network = 192.168.1.

[security]
plugin = EQEmuAuthCrypto
mode = 5

[Titanium]
port = 5998
opcodes = login_opcodes.conf

[SoD]
port = 5999
opcodes = login_opcodes_sod.conf

[schema]
account_table = tblLoginServerAccounts
world_registration_table = tblWorldServerRegistration
world_admin_registration_table = tblServerAdminRegistration
world_server_type_table = tblServerListType
Reply With Quote
Reply

Thread Tools
Display Modes

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 05:57 PM.


 

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 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3