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 12-16-2015, 12:22 PM
style214
Fire Beetle
 
Join Date: Dec 2014
Posts: 28
Default

eqemu_config:
Code:
<?xml version="1.0">
<server>
<world>
<!-- Set the shortname to ONE word. The longname is what shows up on server list -->
<shortname>vandeland</shortname>
<longname>The Vandeland Project</longname>

<!-- DO NOT EDIT ANY LINES BETWEEN HERE AND THE DATABASE SECTION -->
<!-- <address>do.not.edit</address> -->
<!-- <localaddress>do.not.edit</localaddress> -->

<!-- Loginserver information. DO NOT EDIT -->
<loginserver>
	<host>127.0.0.1</host>
	<port>5999</port>
	<account></account>
	<password></password>
</loginserver>

<!-- Sets the ip/port for the tcp connections. DO NOT EDIT -->
<!-- <tcp ip="127.0.0.1" port="9000" telnet="disable"/> -->
<tcp ip="127.0.0.1" port="9000" telnet="enable"/>

<!-- Sets the shared key used by zone/launcher to connect to world -->
<key>randomletterstring1</key>

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

<!-- Chatserver (channels) information. DO NOT EDIT -->
<chatserver>
	<!-- <host>127.0.0.1</host> -->
	<!-- <port>7778</port> -->
	<host></host>
	<port>7500</port>
</chatserver>

<!-- Mailserver (in-game mail) information. DO NOT EDIT -->
<mailserver>
	<!-- <host>127.0.0.1</host> -->
	<!-- <port>7778</port> -->
	<host></host>
	<port>7500</port>
</mailserver>

<zones>
<!-- The defaultstatus is what status the new toons will have on your server -->
<defaultstatus>250</defaultstatus>

<!-- Sets port range for world to use to auto configure zones DO NOT EDIT RIGHT NOW-->
<!-- <ports low="7000" high="7100"/> -->
<ports low="7000" high="7400"/>
</zones>

<!-- Set username to root and password is your MySQL password and db to peq -->
<database>
	<!-- <host>127.0.0.1</host> -->
	<!-- <port>3306</port> -->
	<!-- <username>root</username> -->
	<!-- <password>xxxxx</password> -->
	<!-- <db>peq</db> -->
   <host>127.0.0.1</host>
   <port>3306</port>
   <username>root</username>
   <password>.........</password>
   <db>peq</db>
</database>

<qsdatabase>
	<!-- <host>127.0.0.1</host> -->
	<!-- <port>3306</port> -->
	<!-- <username>root</username> -->
	<!-- <password>xxxxx</password> -->
	<!-- <db>peq</db> -->
   <host>127.0.0.1</host>
   <port>3306</port>
   <username>root</username>
   <password>........</password>
   <db>peq</db>
</qsdatabase>

<!-- Launcher Configuration DO NOT EDIT-->
<launcher>
<!-- <logprefix>logs/zone-</logprefix> -->
<!-- <logsuffix>.log</logsuffix> -->
<!-- <exe>zone.exe</exe> -->
<!-- <timers restart="10000" reterminate="10000"> -->
<!-- <timers restart="200" reterminate="200" initial="200" interval="200"/> -->
</launcher>

<!-- File locations. DO NOT EDIT -->
<files>
<!-- <spells>spells_us.txt</spells> -->
<!-- <opcodes>opcodes.conf</opcodes> -->
<!-- <logsettings>log.ini</logsettings> -->
<!-- <eqtime>eqtime.cfg</eqtime> -->
</files>
<!-- Directory locations. DO NOT EDIT -->
<directories>
<!-- <maps>Maps</maps> -->
<!-- <quests>quests</quests> -->
<!-- <plugins>plugins</plugins> -->
</directories>
</server>
Reply With Quote
  #2  
Old 12-16-2015, 12:47 PM
provocating's Avatar
provocating
Demi-God
 
Join Date: Nov 2007
Posts: 2,175
Default

In your EqEmu config you should have the login and password set for the login server.

Code:
<loginserver>
	<host>127.0.0.1</host>
	<port>5999</port>
	<account>myaccount</account>
	<password>mypassword</password>
</loginserver>
In your login database, the tblServerAdminRegistration should have the same account reflected.

Code:
INSERT INTO `tblServerAdminRegistration` (`ServerAdminID`, `AccountName`, `AccountPassword`, `FirstName`, `LastName`, `Email`, `RegistrationDate`, `RegistrationIPAddr`) VALUES (1, 'myaccount', 'mypassword', '', '', '', '0000-00-00 00:00:00', '');
Reply With Quote
  #3  
Old 12-16-2015, 12:52 PM
style214
Fire Beetle
 
Join Date: Dec 2014
Posts: 28
Default

Is the table you reference in the PEQ DB? I don't show the table in the database at all.
Reply With Quote
  #4  
Old 12-16-2015, 12:56 PM
provocating's Avatar
provocating
Demi-God
 
Join Date: Nov 2007
Posts: 2,175
Default

http://wiki.eqemulator.org/p?Windows...er_Setup_Guide

Quote:
Step 4: Create the necessary database tables.

This assumes you have fetched the database files as detailed in the server set up guide section 6 a). One of those files that you have until now ignored is "load_login.sql'.
Open up a command prompt. Navigate to the directory in which load_login.sql is stored. e.g.

cd C:\EQ\SQL

Then type

mysql -uroot -ppassword peq

where password is the password you chose when installing MySQL, and "peq" is the database name you chose (change it if you didn't call it peq!). When the mysql prompt comes up, type:

source load_login.sql;

The database tables are now created.
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 08:44 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 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3