Cannot connect to my server

Avarion · #1 05-30-2008, 05:59 PM

After setting up minilogin i can login and see my server. But if I try to connect it goes after a few seconds back to loginscreen. Ive seen this problem here but the answers there seem not to help. I dont have any errors in the logfiles.

LoginServer.ini:

Code:

## --- This file tells world.exe what loginserver to connect to.
### --- Leave the account and password field BLANK.

### --- Public Login is un-supported as is LAN playing. We reccomend using the EQEmu.net Loginserver ALWAYS.

### --- NOTE: Starting 6-1-2002, you can no longer use the word "Server" in worldname.
### --- NOTE2: the word "Server" is added to each server automaticly.

# READ README.TXT

[LoginServer]
loginserver=127.0.0.1
#loginserver2=newlogin1.eqemulator.net
loginport=5999
#loginport2=5999
worldname=testserver
worldaddress=127.0.0.1
locked=false
#account=
#password=

[WorldServer]
Defaultstatus=
Unavailzone=

[ChatChannelServer]
worldshortname=
chataddress=
chatport=

[LoginConfig]
ServerMode=MiniLogin
ServerPort=5999

eqemu_config.xml:

Code:

<?xml version="1.0">
<server>
        <world>
		<shortname>testserver</shortname>
		<longname>testserver</longname>
                
                <!-- Only specify these two if you really think you need to. -->
		<address>192.168.0.102</address>
		<localaddress>127.0.0.1</localaddress>
		
		<!-- Loginserver information.  -->
        <loginserver>
		<host>127.0.0.1</host>
		<port>5999</port>
		<account></account>
		<password></password>
        </loginserver>

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

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

                <!-- Database configuration, replaces db.ini. -->
        <database>
                <host>localhost</host>
                <port>3306</port>
                <username>root</username>
                <password>xxxx</password>
                <db>peq</db>
        </database>
</server>

I copied these two from another entry in this forum and modified for my system. Thought this can't go wrong :(

Avarion · #2 06-06-2008, 04:33 PM

No one? Im still stuck in this matter. All seems so fine but I get disconnected all the time.

**Congdar** · #3 06-06-2008, 05:39 PM

The only difference I see with your files and mine, is I use the actual IP everywhere you use 127.0.0.1

kiirdiir · #4 06-06-2008, 06:27 PM

Quote:

Originally Posted by Avarion

After setting up minilogin i can login and see my server. But if I try to connect it goes after a few seconds back to loginscreen. Ive seen this problem here but the answers there seem not to help. I dont have any errors in the logfiles.

Be sure your IP matches the account's IP in your database.

Avarion · #5 06-16-2008, 03:15 PM

Table account. Field Minilogin_ip has the same value: 127.0.0.1

Cripp · #6 06-16-2008, 03:26 PM

try using 192.168.x.xxx instead of 127.0.0.1

Avarion · #7 06-16-2008, 04:38 PM

Ok. Changing all IPs to 192.x.x.x does help. But I've one more problem.

I was able to create a character but cannot load the zone. "zone unavaliable".
I took a look into the sql-database but all zones are there. But without a filename. Is this correct?

Aramid · #8 06-16-2008, 07:01 PM

Read the change log that came with the emu and make sure you have all of the SQL changes in your database.
Also, make sure your maps are in c:\eqemu\Maps and not c:\eqemu\Maps\Maps.

Avarion · #9 06-17-2008, 02:06 PM

I tryed to execute all SQL-Commands from the changelog but most of em seemed to be included in the database.

Code:

CREATE TABLE `graveyard` (
  `id` int(11) NOT NULL auto_increment,
  `zone_id` int(4) NOT NULL default '0',
  `x` float NOT NULL default '0',
  `y` float NOT NULL default '0',
  `z` float NOT NULL default '0',
  `heading` float NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `zone_id` (`zone_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

This code does nothing. Still there is no table graveyard in my database.

Avarion · #10 06-17-2008, 02:15 PM

here is an describe from my zonetable:

Code:

"Field","Type","Null","Key","Default","Extra"
"short_name","varchar(16)","NO","PRI","",""
"file_name","varchar(16)","YES","","",""
"long_name","text","NO","","",""
"safe_x","float","NO","","0",""
"safe_y","float","NO","","0",""
"safe_z","float","NO","","0",""
"graveyard_id","float","NO","","0",""
"min_level","tinyint(3) unsigned","NO","","0",""
"min_status","tinyint(3) unsigned","NO","","0",""
"zoneidnumber","int(4)","NO","UNI","0",""
"timezone","int(5)","NO","","0",""
"maxclients","int(5)","NO","","0",""
"weather","smallint(6)","NO","","1",""
"note","varchar(80)","YES","","",""
"underworld","float","NO","","0",""
"minclip","float","NO","","450",""
"maxclip","float","NO","","450",""
"fog_minclip","float","NO","","450",""
"fog_maxclip","float","NO","","450",""
"fog_blue","tinyint(3) unsigned","NO","","0",""
"fog_red","tinyint(3) unsigned","NO","","0",""
"fog_green","tinyint(3) unsigned","NO","","0",""
"sky","tinyint(3) unsigned","NO","","1",""
"ztype","tinyint(3) unsigned","NO","","1",""
"zone_exp_multiplier","float","NO","","1",""
"walkspeed","float","NO","","0.4",""
"time_type","tinyint(3) unsigned","NO","","2",""
"fog_red1","tinyint(3) unsigned","NO","","0",""
"fog_green1","tinyint(3) unsigned","NO","","0",""
"fog_blue1","tinyint(3) unsigned","NO","","0",""
"fog_minclip1","float","NO","","450",""
"fog_maxclip1","float","NO","","450",""
"fog_red2","tinyint(3) unsigned","NO","","0",""
"fog_green2","tinyint(3) unsigned","NO","","0",""
"fog_blue2","tinyint(3) unsigned","NO","","0",""
"fog_minclip2","float","NO","","450",""
"fog_maxclip2","float","NO","","450",""
"fog_red3","tinyint(3) unsigned","NO","","0",""
"fog_green3","tinyint(3) unsigned","NO","","0",""
"fog_blue3","tinyint(3) unsigned","NO","","0",""
"fog_minclip3","float","NO","","450",""
"fog_maxclip3","float","NO","","450",""
"fog_red4","tinyint(3) unsigned","NO","","0",""
"fog_green4","tinyint(3) unsigned","NO","","0",""
"fog_blue4","tinyint(3) unsigned","NO","","0",""
"fog_minclip4","float","NO","","450",""
"fog_maxclip4","float","NO","","450",""
"flag_needed","varchar(128)","NO","","",""
"canbind","tinyint(4)","NO","","1",""
"cancombat","tinyint(4)","NO","","1",""
"canlevitate","tinyint(4)","NO","","1",""
"castoutdoor","tinyint(4)","NO","","1",""

Perhaps you can see something that helps.

Btw. canlevitate and castoutdoor are the only SQL-commands which were missing. But the problem continues. "zone not avaliable".

Avarion · #11 06-17-2008, 02:22 PM

Btw. please ignore the "no graveyard" post two above. Blind on both eyes.

**Congdar** · #12 06-17-2008, 02:49 PM

show us your start.bat file

Avarion · #13 06-17-2008, 03:16 PM

Code:

@echo off
start minilogin.exe 
Echo Please wait for Minilogin to fully boot up. 
pause
start world.exe 
Echo Wait for World to finish loading... Press Enter when done. 
pause 
start eqlaunch.exe zone 
exit

Here it is.

By the way. The eqlaunch window doesnt show anything. Is this correct?

**Congdar** · #14 06-17-2008, 03:28 PM

make sure your table 'launcher' has the name 'zone' and some number for 'dynamics'

yes, should be blank

Avarion · #15 06-17-2008, 03:31 PM

Code:

"name","dynamics"
"zone",6

it has :(