EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   Installing by the Current guide on W7 64bit (https://www.eqemulator.org/forums/showthread.php?t=37612)

Steel 12-11-2013 03:46 AM

Installing by the Current guide on W7 64bit
 
I'm running into problems.Im trying to install EQEmu mini type server on my laptop for stays in the hospital.Its a Dell windows 7 x64 with 8 gigs of ram.

When I get to the step of using Visual express 2012.I right click ALL BUILD and click BUILD.128 errors and 85 warnings.

Most are error c1083 mysql.h no such file.

I have installed and am using
Active perl 5.14.2.1402 x64
cmake 2.8.12.1 x86
git 1.8.4
heidisql 8.1.0.4545
mysql 5.1.73 x64
npp 6.5.2
tortoisesvn 1.8.4.24972 x64
Visual Studios Express 2012 full
And windows Dependencies x64(I got to the above mentioned errors with the X86 dependencies)

I found a link to the main downloads page and found there was a zip for x64 dependencies.I deleted the x86 and installed the X64 and redone the Cmake step.

And still get the errors in VS2012.

Do I have to start over or are thier more dependencies i need for win7 X64?Or can this install be salvaged?

joligario 12-11-2013 07:15 AM

Looks like you were mixing required versions. Start with this: Do you want to build 32 or 64 bit.

Steel 12-11-2013 05:17 PM

It's on a laptop.And its just going to be a solo server for my stays in the hospital.

So which ever version will be sufficiant and work on the win7 x64.It doesnt matter to me as long as it works.

Also what is boost and lua?And do I need them?And where do I put them?And how do i use it?

werebat 12-12-2013 10:04 AM

I beleive you have to use 32bit MYSQL, not 64bit.

I have the same setup as you but with 32bit mysql and it works great on my old 4GB single core Toshiba Laptop

Steel 12-13-2013 04:31 AM

Thanks that worked and got me through that step.

After figureing out some typo's in the guide I have it all installed.

BUT when i launch the startup batch when it goes to launch zone it says "ZONE.EXE" "This program cannot start because lua51.dll is missing".

It is in the dependancies folder though.

lerxst2112 12-13-2013 04:55 AM

It needs to be in the directory you have the server executables in.

Steel 12-13-2013 05:26 AM

Sweet that fixed that.Logged into my server through eqemu.

Gonna try my hand a private/lan setup.

Use the laptop as a private server for the hospital and a Lan server at home.

I did it a long time ago with minilogin.not sure how the new setup will treat me.

Steel 12-13-2013 06:18 AM

Well that Busted it.

Followed http://www.eqemulator.org/forums/sho...9&postcount=14

Loginserver just crashes so fast I cant read what it says.I do see a bunch of white lines running down the window.

Kept clicking it and i could make make out.Cannot connect to mysql database:error"Thats when the white lines fill the screen and it poofs.

So close i can taste it.

khalathas 12-13-2013 01:36 PM

I had a whole host of problems installing under win7x64 myself, and only ended up succeeding when I strayed from the guide and installed the 64bit version of MySQL instead of the 32bit. Now I'm up and running just fine.

Steel 12-13-2013 02:42 PM

I tryed my best to get the x64 working.Theres just some things you can't get x64.So I figure that may've been the problem.

But installing all 32bit allowed me to finish and was able to log into my server over the inet.

But the private setup of the eqemulogin server is giving me an error my googlefu hasnt matched yet.

Steel 12-13-2013 03:41 PM

my eqemu config-sorry dont know how to show as code

<?xml version="1.0"?>
<server>
<world>
<shortname>minieq</shortname>
<longname>steelsminieq</longname>

<!-- Only specify these two if you really think you need to. (read: You don't) -->
<!-- <address>some.server.com</address> -->
<!-- <localaddress>192.168.0.5</localaddress> -->

<!-- Loginserver information. Defaults shown -->
<loginserver>
<host>127.0.0.1</host>
<port>5998</port>
<account></account>
<password></password>
</loginserver>

<!-- Server status. Default is unlocked -->
<!--<locked/>-->
<!-- <unlocked/> -->

<!-- Sets the ip/port for the tcp connections. Both zones and console (if enabled). Defaults are shown -->
<tcp ip="127.0.0.1" port="9000" telnet="disable"/>

<!-- Sets the shared key used by zone/launcher to connect to world -->
<key>some long random string</key>

<!-- Enable and set the port for the HTTP service. Defaults are shown -->
<http port="9080" enabled="false" mimefile="mime.types" />
</world>

<!-- Chatserver (channels) information. Defaults shown -->
<chatserver>
<host>channels.eqemulator.net</host>
<port>7778</port>
</chatserver>

<!-- Mailserver (in-game mail) information. Defaults shown -->
<mailserver>
<host>channels.eqemulator.net</host>
<port>7778</port>
</mailserver>

<zones>
<defaultstatus>0</defaultstatus>

<!-- Sets port range for world to use to auto configure zones -->
<ports low="7000" high="7100"/>
</zones>

<!-- Database configuration, replaces db.ini. Defaults shown -->
<database>
<host>127.0.0.1</host>
<port>3306</port>
<username>xxxx</username>
<password>xxxx</password>
<db>peq</db>
</database>

<qsdatabase>
<host>127.0.0.1</host>
<port>3306</port>
<username>xxxx</username>
<password>xxxx</password>
<db>peq</db>
</qsdatabase>

<!-- Launcher Configuration -->
<launcher>
<!-- <logprefix>logs/zone-</logprefix> -->
<!-- <logsuffix>.log</logsuffix> -->
<!-- <exe>zone.exe or ./zone</exe> -->
<!-- <timers restart="10000" reterminate="10000"> -->
</launcher>

<!-- File locations. Defaults shown -->
<files>
<!-- <spells>spells_us.txt</spells> -->
<!-- <opcodes>opcodes.conf</opcodes> -->
<!-- <logsettings>log.ini</logsettings> -->
<!-- <eqtime>eqtime.cfg</eqtime> -->
</files>
<!-- Directory locations. Defaults shown -->
<directories>
<!-- <maps>Maps</maps> -->
<!-- <quests>quests</quests> -->
<!-- <plugins>plugins</plugins> -->
</directories>
</server>

Steel 12-13-2013 03:42 PM

My login ini


[database]
host = localhost
port = 3306
db = peq
user = xxxx
password = xxxx
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 = 127.0.0.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

Steel 12-13-2013 04:34 PM

Fixed it.

changed "host = localhost" to "host = 127.0.0.1"

Crashing stopped and my lan comp is connecting to it.Thought since the loginserver setup is new and improved,I wouldnt have to insert accounts.But it looks like i do.Just can't remember how.Back to searching.

Thanks for the help

Steel 12-13-2013 05:53 PM

Well I can find no guide to setting up the eqemuloginserver.And sourceing in accounts to it.

When i try to log in from the lan comp it gives me username or password is incorrect.

Found out it may use tblaccounts instead of the normal accounts.So I manually made a line in tblaccounts making it identical to the admin one thats already in there.All i changed was the "accountname" and "lastipaddress"

Tryed that and and the loginserver screen shows the connection and that im loggin in with that account name.It says

[network]Login recieved from client
[client]user: the username i set
[client]hash: and a long cluster of letters and numbers


Changed "password" in tblaccounts to match the "accountname" like minilogin used to be.(user and password were same.)

I still get the same result.Titanium and underfoot doesnt matter.

How do I fully setup this eqemuloginserver?

I think 20-30 more sentences in the guide would cure most of these posts needing help.

lerxst2112 12-13-2013 08:53 PM

Plenty of info on how to set up accounts here: http://www.eqemulator.org/forums/showthread.php?t=31783

khalathas 12-13-2013 09:19 PM

when you add a user to the tblloginServerAccounts table, you have to use a query because you can't just add a plaintext password, you have to set password = sha('password') to encrypt it.

Try this:
use peqlogindb;
INSERT INTO tblloginServerAccounts (AccountName, AccountPassword, AccountEmail, LastLoginDate, LastIPAddress)
VALUES('acctname', sha('password'), 'email@domain.com', now(), '192.168.1.2');

LastIPAddress and LastLoginDate don't really matter, they get updated when they log in anyway.

Steel 12-16-2013 05:22 PM

Its working now.Really appreciate it.

Steel 12-17-2013 10:52 PM

I do have one thing I can't figure out.

I played a few different custom servers before quiting and comeing back to this.I have changed spell files so many times I have no idea where my origional is.

The spellfile seems to be integrated in the server build.But i can not find the spell_us.txt to copy it to my UF install.Googlefu isnt showing anything.

Anyone know where to get a stock UF spell file or better a spell file that matches the current server build?

lerxst2112 12-18-2013 02:58 AM

Use the spell exporter to export the server database.

http://www.eqemulator.org/forums/sho...4&postcount=15


All times are GMT -4. The time now is 09:12 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.