Setting up pre5/11 Velious Beta1 + 6.1DR1 + Minilogin(windows)

[vRandom]

yep, use the username and pass you made when starting the winmsqladmin

GRANT ALL PRIVILEGES ON *.* TO Username@localhost IDENTIFIED BY 'Password' WITH GRANT OPTION;

change the username to the username your using, likely root, then set the password to what ever you want the pass to be

this changes the permissions to allow the user to use any database, if you wanted to just do one database for example, change the *.* to dbname.* (database name . and * for all tables etc in that database)

execute this command using the mysql -u [username] -p[passsword]
just with the -p and it will prompt for the password if one is set

forexample:
c:\mysql\bin\mysql -u root -ppassword
(notice no space between the -p and the password)

dont forget to change databases before sourcing, example:
use eq;

hope that helps some

[kl9470spin]

Anyone wanna add onto this explaining how to get it to go public?

[drognir]

Alright, i got through the whole tutorial with only one error this time, when i try running world.exe i get this

Failed to open log file: logs/eqemu_world_2744.log
[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.1-DR1
[Status] Loading opcodes..
[Error] Load Shared Library 'EMuShareMem' failed. Error=Error #14001
Unable to laod EMuShareMem for opcodes.
Failed to open log file: logs/eqemu_error_world_2744.log
[Error] Loading opcodes failed. I can't live like this!

Anyone know what's wrong?

[Aradorn]

Failed to open log file: logs/eqemu_world_0196.log 1st line on world.exe

this below is the last thing in world.exe everything inbetween loads perfectly now
**WARNING** You have not setup a zone server password into the database, it is HIGHLY recommended that you add a variable into variables with the varname ZSPassword and the value with random characters to protect from people connecting to your world server.Zoneserver SetConnectInfo: 127.0.0.1:1170: 127.0.0.1:8782
**WARNING** You have not setup a zone server password into the database, it is HIGHLY recommended that you add a variable into variables with the varname ZSPassword and the value with random characters to protect from people connecting to your world server.Zoneserver SetConnectInfo: 127.0.0.1:1169: 127.0.0.1:878088166 New TCP connection: 127.0.0.1:16777343New zoneserver: #3 127.0.0.1:1173
**WARNING** You have not setup a zone server password into the database, it is HIGHLY recommended that you add a variable into variables with the varname ZSPassword and the value with random characters to protect from people connecting to your world server.Zoneserver SetConnectInfo: 127.0.0.1:1173: 127.0.0.1:878490169 New TCP connection: 127.0.0.1:16777343New zoneserver: #4 127.0.0.1:1172
**WARNING** You have not setup a zone server password into the database, it is HIGHLY recommended that you add a variable into variables with the varname ZSPassword and the value with random characters to protect from people connecting to your world server.Zoneserver SetConnectInfo: 127.0.0.1:1172: 127.0.0.1:878192172 New TCP connection: 127.0.0.1:16777343New zoneserver: #5 127.0.0.1:1171
**WARNING** You have not setup a zone server password into the database, it is HIGHLY recommended that you add a variable into variables with the varname ZSPassword and the value with random characters to protect from people connecting to your world server.Zoneserver SetConnectInfo: 127.0.0.1:1171: 127.0.0.1:8783

this is the only 2 errors i see on world.exe now

was i supposed to put username\pass in LoginServer.ini

[Aradorn]

Originally Posted by drognir

Alright, i got through the whole tutorial with only one error this time, when i try running world.exe i get this

Failed to open log file: logs/eqemu_world_2744.log
[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.1-DR1
[Status] Loading opcodes..
[Error] Load Shared Library 'EMuShareMem' failed. Error=Error #14001
Unable to laod EMuShareMem for opcodes.
Failed to open log file: logs/eqemu_error_world_2744.log
[Error] Loading opcodes failed. I can't live like this!

Anyone know what's wrong?

5) Extract Compiled-Perl-Win32.zip to C:\EQEmu\, then extract EQEmu-0.6.1-DR1-Perl.zip to the same directory and ensure you *OVERWRITE* world.exe, zoneperl.exe, and emusharemem.dll
did you unzipp both those into c:\eqemu

[drognir]

I'm pretty sure i did, but i'm completely redoing the tut now..

[Aradorn]

if you redo make sure you go to control panel and add/remove mysql and perl.. then delete the perl mysql and eqemu folder or you will still get problems

[drognir]

Thanks, i tried redoing it once, and didn't completely remove mysql and i ran into problems when i tried making the eq db

[drognir]

I just redid the entire tutorial without error until i got to where i lauch world.exe, and it gave me this same error again

Failed to open log file: logs/eqemu_world_2744.log
[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.1-DR1
[Status] Loading opcodes..
[Error] Load Shared Library 'EMuShareMem' failed. Error=Error #14001
Unable to laod EMuShareMem for opcodes.
Failed to open log file: logs/eqemu_error_world_2744.log
[Error] Loading opcodes failed. I can't live like this!

I'm stumped... Anyone have any advice please?

[Aradorn]

iwantavr4 i got a question... finnaly gotinto eq but when im in wfreeport i get a pet error or something then after a few min it dropps me has this happend to you

ok here is the error
Debug Error!

Program: C:\eqemu\zoneperl.exe
modul:c:\eqemu\zoneperl.exe
file:

Run-time check failuer #3- the variable 'petstruct' is being used with being defined.
(press retry to debug the application)

its a microsoft visual c++ debug library

[vRandom]

Aradorn,

**WARNING** You have not setup a zone server password into the database, it is HIGHLY recommended that you add a variable into variables with the varname ZSPassword and the value with random characters to protect from people connecting to your world server.Zoneserver SetConnectInfo: 127.0.0.1:1170: 127.0.0.1:8782

import these in to your database, its originally from cavedudes database, but i changed the server name in my set up

you might already have the minilogin one thats if your useing it, i dont know what they all do but the error is mainly related to

INSERT INTO variables VALUES ('ZSPassword', '12345', 'Zone Server Password', '2005-06-02 21:32:56');

might actually change the pass too though, here are the rest of the vars i have set currently

INSERT INTO variables VALUES ('LoginType', 'Minilogin', 'Set this to Minilogin to login using a minilogin server :)', '2005-06-11 11:59:56');
INSERT INTO variables VALUES ('MOTD', 'Welcome to Gooberville!', 'Server Message of the Day', '2005-06-11 12:04:57');
INSERT INTO variables VALUES ('disablecommandline', '0', 'Allow command lines to be run from world.exe | 0 - off | 1 - on |', '2004-10-20 07:49:25');
INSERT INTO variables VALUES ('PersistentZoneState', '0', 'Save zone state on shutdown for bootup | 0 - off | 1 - on |', '0000-00-00 00:00:00');
INSERT INTO variables VALUES ('decaytime 1 54', '300', 'Corpse decay time for Level\'s 1 to 54', '0000-00-00 00:00:00');
INSERT INTO variables VALUES ('decaytime 55 100', '1800', 'Corpse decay time for Level\'s 55 to 100', '0000-00-00 00:00:00');
INSERT INTO variables VALUES ('Max_AAXP', '21626880', 'Max AA Experience', '0000-00-00 00:00:00');
INSERT INTO variables VALUES ('ZSPassword', '12345', 'Zone Server Password', '2005-06-02 21:32:56');
INSERT INTO variables VALUES ('loglevel', '0000', 'Commands,Merchants,Trades,Loot', '0000-00-00 00:00:00');
INSERT INTO variables VALUES ('MerchantsKeepItems', '1', 'Merchants keep items sold to them | 0 - off | 1 - on |', '2004-08-27 18:12:07');
INSERT INTO variables VALUES ('GuildWars', '0', 'Enable Guild Wars Type Server | 0 - off | 1 - on |', '0000-00-00 00:00:00');
INSERT INTO variables VALUES ('leavecorpses', '1', 'Players leave corpses | 0 - off | 1 - on |', '2004-10-19 20:41:59');
INSERT INTO variables VALUES ('holdzones', '1', 'Restart Crashed Zone Servers | 0 - off | 1 - on |', '2004-09-19 15:05:13');
INSERT INTO variables VALUES ('EXPMod', '.8', 'Experience multipler. Increase to increase exp rate', '2005-02-04 11:37:19');
INSERT INTO variables VALUES ('GroupEXPBonus', '.2', 'Experience multipler. Increase to increase group exp rate', '2004-11-10 15:00:37');
INSERT INTO variables VALUES ('AAXPMod', '.9', 'AA Experience multipler. Increase to increase exp rate', '2004-09-21 23:51:08');
INSERT INTO variables VALUES ('Expansions', '255', 'Accessible expansions for each player', '2004-04-03 21:54:03');
INSERT INTO variables VALUES ('ServerType', '0', 'Sets server type | 0 - normal | 1 - pvp |', '2004-10-28 11:09:41');
INSERT INTO variables VALUES ('DisableNoDrop', '0', 'Takes No-Drop off of items', '2004-10-28 11:08:04');
INSERT INTO variables VALUES ('ACfail', '35', 'the percentage of time AC fails to protect. 0 would mean there was always some level of protection, 100 would mean AC has no affect. When AC fails, it will be possible to get a max dmg hit.', '2005-02-04 11:36:09');
INSERT INTO variables VALUES ('ACreduction', '1', 'the percentage of AC that is ALWAYS reduced from a hit (except when AC fails with ACfail) \n\n', '2004-11-03 10:24:23');
INSERT INTO variables VALUES ('ACrandom', '3', 'the maximum amount of additional protection AC provides. 0 would mean no additional protection is provided, otherwise an additional amount of reduction is calculated using a random percentage of 1 to this value (except when AC fails with ACfail) \n', '2005-02-04 11:36:15');
INSERT INTO variables VALUES ('DBVersion', '061_gooberville', 'DB version info', '2005-06-11 12:05:06');
INSERT INTO variables VALUES ('LootCoin', '0', 'Allows players to loot coin off a player corpse in pvp | 0 - off | 1 - on |', '2004-11-08 07:28:26');
INSERT INTO variables VALUES ('PvPreward', '0', 'Allows players to loot items off a player corpse in pvp | 0 - no items | 1 - a single item | 2 - all items | 3 - item specified in PvPreward |', '2004-11-08 07:28:35');
INSERT INTO variables VALUES ('PvPitem', '0', 'Specific item that can be looted off a player in pvp', '2004-11-08 07:28:08');
INSERT INTO variables VALUES ('ailevel', '6', '', '2005-04-12 18:20:14');

[vRandom]

drognir,

Failed to open log file: logs/eqemu_error_world_2744.log

might try making a log dir in your eqemu dir, not sure otherwize

[vRandom]

Originally Posted by Aradorn

iwantavr4 i got a question... finnaly gotinto eq but when im in wfreeport i get a pet error or something then after a few min it dropps me has this happend to you

I had the pet construct error, but its late and i'm not remembering what i did to fix it..... hummm

[iwantavr4]

I dont know how you got your version number... The one i have was created/modified on this date:
Sunday, April 17, 2005, 10:13:30 PM

And has the following MD5 Hash:
40B0DA1CCB3C3C07947261B016201328

[Aradorn]

that log thing u jsut mentioned do you just make a folder called log? i also updated post above about the error