|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Support::Windows Servers Support forum for Windows EQEMu users. |
11-17-2013, 01:02 PM
|
|
Demi-God
|
|
Join Date: Nov 2007
Posts: 2,175
|
|
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?
|
11-17-2013, 01:05 PM
|
Sarnak
|
|
Join Date: Jun 2007
Posts: 67
|
|
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).
|
11-17-2013, 01:06 PM
|
Sarnak
|
|
Join Date: Jun 2007
Posts: 67
|
|
The snapshot is immediately after win7 itself finishes its install. There isn't a single bit of post-install modification on it.
|
11-17-2013, 01:10 PM
|
|
Demi-God
|
|
Join Date: Nov 2007
Posts: 2,175
|
|
x32 or x64?
|
11-17-2013, 01:12 PM
|
Sarnak
|
|
Join Date: Jun 2007
Posts: 67
|
|
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.
|
11-17-2013, 01:15 PM
|
|
Demi-God
|
|
Join Date: Nov 2007
Posts: 2,175
|
|
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.
|
11-17-2013, 01:16 PM
|
Sarnak
|
|
Join Date: Jun 2007
Posts: 67
|
|
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.
|
11-17-2013, 01:20 PM
|
Sarnak
|
|
Join Date: Jun 2007
Posts: 67
|
|
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.
|
11-17-2013, 01:23 PM
|
Sarnak
|
|
Join Date: Jun 2007
Posts: 67
|
|
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...
|
11-17-2013, 01:57 PM
|
|
Demi-God
|
|
Join Date: Nov 2007
Posts: 2,175
|
|
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.
|
11-17-2013, 02:01 PM
|
Sarnak
|
|
Join Date: Jun 2007
Posts: 67
|
|
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.
|
11-17-2013, 02:20 PM
|
|
Demi-God
|
|
Join Date: Nov 2007
Posts: 2,175
|
|
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.
|
11-17-2013, 03:50 PM
|
Sarnak
|
|
Join Date: Jun 2007
Posts: 67
|
|
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 >.<
|
11-17-2013, 05:11 PM
|
|
Demi-God
|
|
Join Date: Nov 2007
Posts: 2,175
|
|
Unless you have a ton, it should not be a major endeavor.
|
|
|
|
11-18-2013, 01:01 AM
|
Sarnak
|
|
Join Date: Jun 2007
Posts: 67
|
|
*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
|
|
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 10:08 PM.
|
|
|
|
|
|
|
|
|
|
|
|
|