Cannot connect to my server

[kiirdiir]

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]

Table account. Field Minilogin_ip has the same value: 127.0.0.1

[Cripp]

try using 192.168.x.xxx instead of 127.0.0.1

[Avarion]

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]

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]

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

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]

here is an describe from my zonetable:

"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".